Question

怎样用C#语句向数据库中插入一条记录

Answer 1

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 那就更好些~~

Answer 2

SqlConnection con=new SqlConnection("XXXXX");
con.Open();
SqlCommand cmd=new SqlCommand("insert into XXXX",con);
cmd.ExecuteNonQuery();

Answer 3

SqlConnection con=new SqlConnection("连接字符串");
con.Open();
SqlCommand cmd=new SqlCommand("insert into 表名",con);
cmd.ExecuteNonQuery();

Answer 4

你还没搞清楚C#与数据库是什么吧。。

Answer 5

不是C#是T-SQL命令