Gridview的一些用法

绑定

public void bind()

{

string sqlstr = "select * from 表";

sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

DataSet myds = new DataSet();

sqlcon.Open();

myda.Fill(myds, "表");

GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { "id" };//主键

GridView1.DataBind();

sqlcon.Close();

}

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

bind();

}

 

//删除

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

string sqlstr = "delete from 表 where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

sqlcon = new SqlConnection(strCon);

sqlcom = new SqlCommand(sqlstr,sqlcon);

sqlcon.Open();

sqlcom.ExecuteNonQuery();

sqlcon.Close();

bind();

}

 

//更新

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

sqlcon = new SqlConnection(strCon);

string sqlstr = "update 表 set 字段1='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',字段2='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "',字段3='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where id='"

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

sqlcom=new SqlCommand(sqlstr,sqlcon);

sqlcon.Open();

sqlcom.ExecuteNonQuery();

sqlcon.Close();

GridView1.EditIndex = -1;

bind();

}

 

//取消

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

bind();

}

 

创建临时表

新建表

static DataTable dt=new DataTable();  //dt需声明为静态的 否则每次页面刷新都会把表中的内容清空

 

新建列

DataColumn column=new DataColomn("列名");

dt.Columns.Add(column);  //将这一列添加到表中

databind();                    //绑定

 

 

private void  databind()

{

     gridview1.DataSource=dt;   //将dt表绑定到gridview中

     gridview1.DataBind();        //绑定

};         

 

将内容添加到dt表中

 

DataRow row;           //新建行

row=dt.NewRow();

row["列名"]=txtQuantity.Text.Trim().Tostring();

 

dropdownlist.selectedIten.text;  //去下拉框的值

 

dt.Rows.Add(row);   //将row的内容添加到表中

databind();