//修改信息代码
protected void Button3_Click(object sender, EventArgs e)
{ SqlConnection sql = Class1.connection();
sql.Open();
string str = string.Format("update table_1 set qq='{0}',dz='{1}',phone='{2}',sex='{3}',number='{4}'where xm='{5}'",DropDownList4.SelectedValue, TextBox2.Text, TextBox3.Text, TextBox4.Text, DropDownList3.SelectedValue, TextBox5.Text);
SqlDataAdapter sda = new SqlDataAdapter(str,sql);
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
DataSet ds = new DataSet();
sda.Fill(ds,"table_1");
GridView1.DataSource = ds.Tables[0];//[/color]这一句报错,无法找到表0
DataRow row = ds.Tables[0].Rows[0];
row["xm"] = DropDownList4.SelectedValue;
row["qq"] = TextBox2.Text;
row["dz"] = TextBox3.Text;
row["phone"] = TextBox4.Text;
row["sex"] = DropDownList3.SelectedValue;
row["number"] = TextBox5.Text;
ds.Tables[0].Rows.Add(row);
sda.Update(ds);
五大找到边0,但是已经Fill了啊
}
protected void Button3_Click(object sender, EventArgs e)
{ SqlConnection sql = Class1.connection();
sql.Open();
string str = string.Format("update table_1 set qq='{0}',dz='{1}',phone='{2}',sex='{3}',number='{4}'where xm='{5}'",DropDownList4.SelectedValue, TextBox2.Text, TextBox3.Text, TextBox4.Text, DropDownList3.SelectedValue, TextBox5.Text);
SqlDataAdapter sda = new SqlDataAdapter(str,sql);
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
DataSet ds = new DataSet();
sda.Fill(ds,"table_1");
GridView1.DataSource = ds.Tables[0];//[/color]这一句报错,无法找到表0
DataRow row = ds.Tables[0].Rows[0];
row["xm"] = DropDownList4.SelectedValue;
row["qq"] = TextBox2.Text;
row["dz"] = TextBox3.Text;
row["phone"] = TextBox4.Text;
row["sex"] = DropDownList3.SelectedValue;
row["number"] = TextBox5.Text;
ds.Tables[0].Rows.Add(row);
sda.Update(ds);
五大找到边0,但是已经Fill了啊
}
解决方案 »
- 服务器中安装了framework,为什么没有选择版本的选项
- window.open路径问题
- 求助,A页面通过iframe链接了B页面,B页面通过javascript怎么调用A页面的控件?
- 关于RadioButtonList动态绑定的取值问题~~~!郁闷了半天!@#$$$%%%%%%%%%*(&^&*&^*&(^
- 请教孟子:你的XPTABLE中的排序方法能不能移植到REPEATER中用?
- Extjs下生成水晶报表 各位大虾们请多多指教
- 开了400分了哈,怎么还是没人回答~~~
- 使用后期绑定DataBinder.Eval的输出字如何只取Text类型字段的前固定数量的字符。
- 局域网内发短信,能实现吗?
- 如何在后台创建DataList?求各位大哥帮忙?如何在后台创建DataList?求各位大哥帮忙
- 菜鸟问下:为什么添加不了动态的表?
- 一行代码的格式问题
protected void Button3_Click(object sender, EventArgs e)
{ SqlConnection sql = Class1.connection();
sql.Open();
string str = string.Format("update table_1 set qq='{0}',dz='{1}',phone='{2}',sex='{3}',number='{4}'where xm='{5}'",DropDownList4.SelectedValue, TextBox2.Text, TextBox3.Text, TextBox4.Text, DropDownList3.SelectedValue, TextBox5.Text);
string str2 = string.Format("select * from table_1 where xm='{0}'",TextBox5.Text.Trim());
SqlDataAdapter sda = new SqlDataAdapter(str,sql);
SqlDataAdapter sda2 = new SqlDataAdapter(str2,sql);
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
SqlCommandBuilder scb2 = new SqlCommandBuilder(sda2);
DataSet ds = new DataSet();
DataSet ds2 = new DataSet();
sda.Fill(ds,"table_1");
sda2.Fill(ds2);
GridView1.DataSource = ds2.Tables[0];
DataRow row = ds.Tables[0].Rows[0];
row["xm"] = DropDownList4.SelectedValue;
row["qq"] = TextBox2.Text;
row["dz"] = TextBox3.Text;
row["phone"] = TextBox4.Text;
row["sex"] = DropDownList3.SelectedValue;
row["number"] = TextBox5.Text;
ds.Tables[0].Rows.Add(row);
sda.Update(ds);
}
在执行Select命令是才需要用SqlDataAdapter,这个是一个适配器,可以把查询到的数据fill到DataTable中活DataSet中。
你上面的功能应该是根据xm修改table_1中数据,然后并把所有的数据返回到GridView1中。
protected void Button3_Click(object sender, EventArgs e)
{ SqlConnection sql = Class1.connection();
sql.Open();
string str = string.Format("update table_1 set qq='{0}',dz='{1}',phone='{2}',sex='{3}',number='{4}'where xm='{5}'",DropDownList4.SelectedValue, TextBox2.Text, TextBox3.Text, TextBox4.Text, DropDownList3.SelectedValue, TextBox5.Text);
SqlCommand cmd=new SqlCommand();
cmd.CommandText=str;
cmd.Connection =sql;
int result= cmd.ExecuteNonQuery();//执行命令,当前命令执行完以后可到数据库中查看是否有更新
if(result>0)
{
MessageBox.Show("修改成功。");
}
else
{
MessageBox.Show("修改失败。");
} string strselect="select * from table_1";
SqlDataAdapter sda = new SqlDataAdapter(strselect,sql);
DataSet ds = new DataSet();
sda.Fill(ds,"table_1");
sql.Close();//记住使用完以后要关闭
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}