如题,代码如下:
a.cs
private string m_Memo;
/// <summary>
/// 备注
/// </summary>
public string Memo
{
get { return m_Memo; }
set { m_Memo = value; }
}b.cs
a.Memo=textbox1.text;
a.cs
private string m_Memo;
/// <summary>
/// 备注
/// </summary>
public string Memo
{
get { return m_Memo; }
set { m_Memo = value; }
}b.cs
a.Memo=textbox1.text;
namespace aa
{
public class a
{
private string m_Memo;
/// <summary>
/// 备注
/// </summary>
public string Memo
{
get { return m_Memo; }
set { m_Memo = value; }
}
}
}
b.cs
a a1 = new a();
a1.Memo = "值";
a d=new a();
a.Memo=textbox1.text
?
楼上的仁兄是不是指这样?
a.Memo = textbox1.Text;
using System.Data;
using System.Data.OleDb;
using ThClient.DataAccess;namespace ThClient.Item.DataAccess
{
public class Department : Base,IOperable
{
#region IOperable 成员 private string m_sqlList = " SELECT ID,Name,Memo From Department ";
private string m_sqlLoad = " SELECT ID,Name,Memo From Department WHERE ID = {0} ";
private string m_sqlAdd = " INSERT INTO Department(Name,Memo) VALUES('{0}','{1}') ";
private string m_sqlUpdate = " Update Department SET Name = '{0}',Memo = '{1}' WHERE ID = '{2}' ";
private string m_sqlDelete = " Delete Deparemnt WHERE ID = {0} "; public DataSet List()
{
DataSet set = new DataSet();
try
{
set = OleHelper.ExctureDataSet(m_sqlList);
}
catch (Exception) { }
return set;
} public OleDbDataReader ReadList()
{
OleDbDataReader set = null;
try
{
set = OleHelper.ExctureDataReader(m_sqlList);
}
catch (Exception) { }
return set;
} public bool Add()
{
bool result = false; string _sql = String.Format(m_sqlAdd, Filter.GetText(this.m_Name), Filter.GetText(this.m_Memo)); try
{
OleHelper.ExctureNonQuery(_sql);
result = true;
}
catch (Exception){ } return result;
} public bool Update()
{
bool result = false; string _sql = String.Format(m_sqlUpdate, Filter.GetText(this.m_Name), Filter.GetText(this.m_Memo),this.m_ID); try
{
OleHelper.ExctureNonQuery(_sql);
result = true;
}
catch (Exception) { } return result;
} public bool Delete()
{
bool result = false; string _sql = String.Format(m_sqlDelete, this.m_ID); try
{
OleHelper.ExctureNonQuery(_sql);
result = true;
}
catch (Exception) { } return result;
} public bool Load()
{
bool result = false;
OleDbDataReader reader = null;
string _sql = String.Format(m_sqlLoad,this.m_ID);
try
{
reader = OleHelper.ExctureDataReader(_sql);
if ( reader.Read() )
{
m_Name = reader["Name"] != DBNull.Value ? reader["Name"].ToString() : "";
m_Memo = reader["Memo"] != DBNull.Value ? reader["Memo"].ToString() : "";
result = true;
}
}
catch(Exception){}
finally
{
if ( reader != null )
reader.Close();
}
return result;
} public string GetDisplayMember()
{
return "Name";
} #endregion #region property private int m_ID;
/// <summary>
/// 编号
/// </summary>
public int ID
{
get { return m_ID; }
set { m_ID = value; }
} private string m_Name;
/// <summary>
/// 部门名称
/// </summary>
public string Name
{
get { return m_Name; }
set { m_Name = value; }
} private string m_Memo;
/// <summary>
/// 备注
/// </summary>
public string Memo
{
get { return m_Memo; }
set { m_Memo = value; }
} #endregion }
}
b.csusing System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using ThClient.Item.DataAccess;namespace ThClient.Item.DataAccess.Tester
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
Department d=new Department();
d.Name = this.textBox1.Text;
d.Memo = this.textBox2.Text;
if (d.Add())
MessageBox.Show("成功!");
else
MessageBox.Show("失败!");
}
}
}反回失败,帮看看。
--------->
string _sql = String.Format(m_sqlAdd, this.m_Name, this.m_Memo);Filter.GetText什么意思
看一下你的sql是什么
在查询分析器中是否可以正确执行