C#操作SQL常用对象有SqlConnection,SqlAdapter,SqlCommand、Dataset、DataGrid和DataReader等。
新建数据代码:
string MyConn="server=数据名;uid=用户名;pwd=密码;database=数据库名;Trusted_Connection=no";
SqlConnection MyConnection=new SqlConnection(MyConn);
string MyInsert="insert into Categories(CategoryName, Description)values('"+Convert.ToString(TextBox2.Text)+"','"+Convert.ToString(TextBox3.Text)+"')";
SqlCommand MyCommand=new SqlCommand(MyInsert,MyConnection);
try
{
MyConnection.Open();
MyCommand.ExecuteNonQuery();
MyConnection.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
修改数据代码:
string MyConn="server=数据名;uid=用户名;pwd=密码;database=数据库名;Trusted_Connection=no";
string categoryName=TextBox2.Text;
string categoryDescription=Tex