iceweek
20-08-2012, 10:55
private const string CommandText = "select * from dbo.Member";
private const string ConnectionString =
"server=localhost;database=test;" +
"user id=sa;password=123;";
SqlConnection objConnection;
objConnection = new SqlConnection(ConnectionString);
s
SqlCommand objCommand = new SqlCommand();
objCommand.Connection = objConnection;
objCommand.CommandText = "Insert into dbo.Member values( @1,@2,@3)";
objCommand.Parameters.AddWithValue("@1",textBox1);
objCommand.Parameters.AddWithValue("@2", textBox2);
objCommand.Parameters.AddWithValue("@3", textBox3).DbType = DbType.Currency; ;
objConnection.Open();
objCommand.ExecuteNonQuery();
objConnection.Close();
s
private const string ConnectionString =
"server=localhost;database=test;" +
"user id=sa;password=123;";
SqlConnection objConnection;
objConnection = new SqlConnection(ConnectionString);
s
SqlCommand objCommand = new SqlCommand();
objCommand.Connection = objConnection;
objCommand.CommandText = "Insert into dbo.Member values( @1,@2,@3)";
objCommand.Parameters.AddWithValue("@1",textBox1);
objCommand.Parameters.AddWithValue("@2", textBox2);
objCommand.Parameters.AddWithValue("@3", textBox3).DbType = DbType.Currency; ;
objConnection.Open();
objCommand.ExecuteNonQuery();
objConnection.Close();
s