哈...很简单啊...dim comdinsert1 as new sqlcommand("insert into 表名(字段名) values(字段名=" & textbox1.text & ")",sqlconnection1) comdinser1.executenonquery()ok!了..给分了....!!!!!!!
public string zhuanhuan(string strtext) { return "'"+strtext+"'"; } this.textbox.text=zhuanhuan(this.textbox.text);string strConnection="Provider=Microsoft.Jet.OleDb.4.0;"; strConnection+=@"Data Source=数据库的位置和名字";string addsql="insert into table(字段名)"+" values("+this.textbox.text+")";OleDbConnection objConnection=new OleDbConnection(strConnection); objConnection.Open(); OleDbCommamd addCommand=new OleDbCommand(addsql,objConnection); int rows=addCommand,ExecuteNonQuery(); 搞定!!
dim comdinsert1 as new sqlcommand("insert into 表名(字段名) values(字段名=" & textbox1.text & ")",sqlconnection1) comdinser1.executenonquery()
To zxm123(序子陵): 你给的是vb的吧,楼主问的是C#,正确应该是 string addsql="insert into table(字段名)"+" values('"+textbox.text+"')";//字段类型是字符型
comdinser1.executenonquery()ok!了..给分了....!!!!!!!
{
return "'"+strtext+"'";
}
this.textbox.text=zhuanhuan(this.textbox.text);string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=数据库的位置和名字";string addsql="insert into table(字段名)"+" values("+this.textbox.text+")";OleDbConnection objConnection=new OleDbConnection(strConnection);
objConnection.Open();
OleDbCommamd addCommand=new OleDbCommand(addsql,objConnection);
int rows=addCommand,ExecuteNonQuery();
搞定!!
comdinser1.executenonquery()
你给的是vb的吧,楼主问的是C#,正确应该是
string addsql="insert into table(字段名)"+" values('"+textbox.text+"')";//字段类型是字符型