Data_Bind()绑定分开写的问题
我在1.aspx.cs里面这样gridview1绑定 ,修改删除没得问题。
public void Data_Bind()
{
string sqlstr = "select * from info where id='" + Request.QueryString["id"] + "'";
sqlcon = new SqlConnection(strCon);
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds, "info");
GridView1.DataSource = myds;
GridView1.DataKeyNames = new string[] { "id" };
//主键
GridView1.DataBind();
sqlcon.Close();
}
如果我在conn.cs里面这样写
public DataTable GetMember(string id)
{
string strSql = "";
strSql = "select * from info where id='" + id + "'";
conn = new SqlConnection(connectionString);
SqlDataAdapter da = null;
da = new SqlDataAdapter(strSql, conn);
DataSet ds = new DataSet();
conn.Open();
da.Fill(ds);
conn.Close();
return ds.Tables[0];
}
然后在1.aspx里面
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Data_Bind();
}
}
public void Data_Bind()
{
this.GridView1.DataSource = b1.GetMember(Request.QueryString["id"]);
this.GridView1.DataKeyNames = new string[] { "id" };
this.GridView1.DataBind();
}
数据能显示 ,但修改就不能获取值
要如何修改Data_Bind()