我先从几个关联表中查找相关数据读取到gridview,并显示,按bottom1实现了,但是,我需要设计一个bottom2,按下bottom2,把gridview中的数据写到数据库的一个新表中,请问代码怎样下?
部分代码如下:
protected void Button1_Click(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["schoolConnectionString"].ConnectionString;
string cmdtxt2 = "select * from Student where Class='" + DropDownList4.Text + "'order ";
SqlConnection Con = new SqlConnection(connStr);
Con.Open();
SqlDataAdapter Da = new SqlDataAdapter(cmdtxt2, Con);
DataSet ds = new DataSet();
Da.Fill(ds, "GridView1");
GridView1.DataSource = ds.Tables["GridView1"].DefaultView;
GridView1.DataBind();
Con.Close(); }
protected void Button2_Click1(object sender, EventArgs e)
{
//这里怎样写啊 ?
}
部分代码如下:
protected void Button1_Click(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["schoolConnectionString"].ConnectionString;
string cmdtxt2 = "select * from Student where Class='" + DropDownList4.Text + "'order ";
SqlConnection Con = new SqlConnection(connStr);
Con.Open();
SqlDataAdapter Da = new SqlDataAdapter(cmdtxt2, Con);
DataSet ds = new DataSet();
Da.Fill(ds, "GridView1");
GridView1.DataSource = ds.Tables["GridView1"].DefaultView;
GridView1.DataBind();
Con.Close(); }
protected void Button2_Click1(object sender, EventArgs e)
{
//这里怎样写啊 ?
}
/// 用DataSet对象,更新数据库
/// </summary>
void IDbAccess.UpdateDataSet(DataSet dataset)
{
SqlDataAdapter sqlSdr = new SqlDataAdapter(sqlCom);
dataset.Clear();
sqlSdr.Fill(dataset);
}
试试看,不好用再告诉我。我这里好用
SqlCommand cmd = New SqlCommand("insert ......", con)
cmd.ExecuteNonQuery()
用从gridview里获得的dataset做参数,明白了么?
protected void Button2_Click1(object sender, EventArgs e)
{
//这里怎样写啊 ?
}
protected void Button2_Click1(object sender, EventArgs e)
{
//这里怎样写啊 ?
}
protected void Button2_Click1(object sender, EventArgs e)
{
//这里怎样写啊 ?
}
这里的代码啊 !有谁能帮下忙?
{
string connStr = ConfigurationManager.ConnectionStrings["schoolConnectionString"].ConnectionString;
SqlConnection Con = new SqlConnection(connStr);
OleDbCommand sqlCom = Con.CreateCommand();
SqlDataAdapter sqlSdr = new SqlDataAdapter(sqlCom);
dataset.Clear();
sqlSdr.Fill(GridView1.Rows);
}
试试,我现在试不了了,你要是提示出错就告诉我
values('" + row[0].ToString() + "','" + row[1].ToString() + "'
这样的
select * into TempTable from Student where Class='" + DropDownList4.Text + "
如果不是,可以这样用:
《把gridview中的数据写到数据库的一个新表》
将dataset 改为类的公用对象,这样button2还可以继续用dataset,再遍历dataset不就行了吗?
protected void Button2_Click1(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["schoolConnectionString"].ConnectionString;
string cmdtxt2 = "select Student.*,Class.* ,Course.* from Student INNER JOIN Class ON Student.Class_id=Class.Class_id INNER JOIN Course ON Course.zydm=Class.zydm where Student.Class_id='" + DropDownList4.Text + "'order by Course.term asc";
SqlConnection Con = new SqlConnection(connStr);
Con.Open();
SqlDataAdapter Da = new SqlDataAdapter(cmdtxt2, Con);
DataSet myds = new DataSet();
Da.Fill(myds, "GridView1");
GridView1.DataSource = myds.Tables["GridView1"].DefaultView;
GridView1.DataBind();
try
{
SqlCommand myComm;
foreach (DataTable table in myds.Tables)
foreach (DataRow row in table.Rows)
{
connStr = "Insert Into StudentGrade(Stu_name,Stu_id,nf) values('" + row[0].ToString() + "','" + row[1].ToString() + "','" + row[2].ToString() + "')"; myComm = new SqlCommand(connStr, Con);
int res = myComm.ExecuteNonQuery();
if (res > 0)
{
Label1.Text = "成绩批量更新成功";
}
else
{
Label1.Text = "更新失败";
}
}
} }