Question

.net gridview如何实现逐行填充

protected void Button2_Click(object sender, EventArgs e)
{

DataTable datatable = new DataTable();
// 连接sql数据库
String sqlconn = "Data Source=bds-031.hichina.com;Initial Catalog=bds0310493_db;user id=bds0310493; pwd=xjlyzhcs3601260";
SqlConnection myConnection = new SqlConnection(sqlconn);
myConnection.Open();

//定义SqlCommand类

int a =Convert.ToInt32(TextBox1.Text);
SqlCommand myCommand = new SqlCommand("select ckbm,ckmc," + a + " as num" + ",(ckbm*"+a+")as money from a_ckzl where ckbm=12", myConnection);

SqlDataAdapter da = new SqlDataAdapter(myCommand);
DataTable dt = new DataTable();
da.Fill(dt);

GridView1.DataSource = dt;
GridView1.DataBind();
}
这是按钮2的单机事件，如果gridview原来已经有内容的话怎么让他再插入一行，现在单机按钮2的时候按钮1显示的内容就没了

Answer 1

那就不能直接绑定数据源了。
或者在你绑定数据源之前，把原来的数据合并到新的 DataTable变量中 再来绑定