救命~~~~

Question

代码是下面这样的，麻烦前辈们看一下！private void Page_Load(object sender, System.EventArgs e)
{
this.sqlConnection1.Open();
//打开数据库连接
// 在此处放置用户代码以初始化页面
DataSet objDataset;
//新建一个放数据的DataSet
objDataset=new DataSet();
this.sqlDataAdapter1.Fill(objDataset, "clientele");
//将数据填入DataSet
this.DataGrid1.DataSource=objDataset.Tables["clientele"].DefaultView;
//关联DataSet和DataGrid
this.DataGrid1.DataBind();
//绑定数据
this.sqlConnection1.Close();
            //关闭数据库连接
}

Answer 1

private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{

} private void Button1_Click(object sender, System.EventArgs e)
{
sqlInsertCommand1.Parameters["@ID"].Value=TextBox1.Text;
//将TextBox赋值给对应参数
sqlInsertCommand1.Parameters["@Address"].Value=TextBox2.Text;
sqlInsertCommand1.Parameters["@Postcode"].Value=TextBox3.Text;
sqlInsertCommand1.Parameters["@address"].Value=TextBox4.Text;
sqlInsertCommand1.Parameters["@Email"].Value=TextBox5.Text;
sqlInsertCommand1.Parameters["@Phone"].Value=TextBox6.Text;
sqlInsertCommand1.Parameters["@Fax"].Value=TextBox7.Text;
sqlInsertCommand1.Parameters["@Contact"].Value=TextBox8.Text;
sqlInsertCommand1.Connection.Open();
//打开连接
sqlInsertCommand1.ExecuteNonQuery();
//执行Insert语句
sqlInsertCommand1.Connection.Close();
//关闭连接
sqlConnection1.Open();
DataSet objDataset;
//下面程序段更新DataGrid
objDataset=new DataSet();
sqlDataAdapter1.Fill(objDataset, "clientele");
DataGrid1.DataSource=objDataset.Tables["clientele"].DefaultView;
DataGrid1.DataBind();
}

Answer 2

ivate void Button2_Click(object sender, System.EventArgs e)
{
System.Data.SqlClient.SqlCommand sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
//声明Sql Command类对象
this.sqlDataAdapter1.DeleteCommand = sqlDeleteCommand1;
sqlDeleteCommand1.CommandText="DELETE FROM ADDRESS WHERE NAME='"+TextBox9.Text+"'";
//SQL语句
sqlDeleteCommand1.Connection = this.sqlConnection1;
//声明使用的数据连接
sqlDeleteCommand1.Connection.Open();
sqlDeleteCommand1.ExecuteNonQuery();
//执行该SQL语句
sqlDeleteCommand1.Connection.Close();
}
private void REFRESH_Click(object sender, System.EventArgs e)
{
sqlConnection1.Open();
//打开数据库连接
DataSet objDataset;
//新建一个放数据的DataSet
objDataset=new DataSet();
sqlDataAdapter1.Fill(objDataset, "address");
//将数据填入DataSet
DataGrid1.DataSource=objDataset.Tables["address"].DefaultView;
//关联DataSet和DataGrid
DataGrid1.DataBind();
//绑定数据
sqlConnection1.Close();
//关闭数据库连接 }