missice's Blog

轉載自大陸網友。

假定你的ID都是字串型
如果你的資料庫access的話，就要用oledb的ado物件

OleDbConnection conn = new OleDbConnection(資料庫連接字串);
OleDbCommand cmd = new OleDbCommand( "INSERT INTO [table](id1, id2) values(@ID1, @ID2)" );
conn.Open();
cmd.Connection = conn;
//cmd.CommandType = CommandType.StoredProcedure;
OleDbParameter id1 = new OleDbParameter( "@ID1", DbType.String );
id1.Value=TextBox1.Text;
OleDbParameter id2 = new OleDbParameter( "@ID2", DbType.String );
id2.Value=TextBox2.Text;

cmd.Parameters.Add(id1);
cmd.Parameters.Add(id2);
cmd.ExecuteNonQuery();

如果你的id是整型的話，就要用以下的方法了
OleDbParameter id1 = new OleDbParameter( "@ID1", DbType.Int32 );
id1.Value=Int32.Parse(TextBox1.Text);
OleDbParameter id2 = new OleDbParameter( "@ID2", DbType.Int32 );
id2.Value=Int32.Parse(TextBox2.Text);