string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\db1.mdb";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strSql = "insert into moneyinf values('" + namecombox.Text.Trim() + "','" + moneytext.Text.Trim() + "')";
OleDbCommand com = new OleDbCommand(strSql,conn);
com.ExecuteNonQuery();
conn.Close();
往一个叫moneyinf的表里插入数据~~很简单的,就按照表里的对应的字段的顺序~~ 当然还可以加上try catch 那就更好些~~
SqlConnection con=new SqlConnection("XXXXX");
con.Open();
SqlCommand cmd=new SqlCommand("insert into XXXX",con);
cmd.ExecuteNonQuery();
SqlConnection con=new SqlConnection("连接字符串");
con.Open();
SqlCommand cmd=new SqlCommand("insert into 表名",con);
cmd.ExecuteNonQuery();
你还没搞清楚C#与数据库是什么吧。。
不是C#是T-SQL命令