问题描述
判断TextBox输入的值在Gridview中第一列中是否存在,不用sql,ado.net,直接点的方法
解决方案
解决方案二:
foreach(GridViewRowgvrinGridView.Rows){}
解决方案三:
protectedvoidButton1_Click(objectsender,EventArgse){ StringBuilderquery=newStringBuilder(); for(inti=0;i<Gridview1.Rows.Count;i++) { GridviewRowrow=Gridview1.Rows[i]; stringvalue1=((TextBox)row.Cells[0].FindControl("TextBox2")).Text.Replace("’","’’"); stringvalue2=((TextBox)row.Cells[1].FindControl("TextBox3")).Text.Replace("’","’’"); stringvalue3=Gridview1.DataKeys[i].Value.ToString(); query.Append("UPDATE[Customers]SET[CompanyName]=’").Append(value1).Append("’,[ContactTitle]=’").Append(value2).Append("’WHERE[CustomerID]=’").Append(value3).Append("’;n"); } SqlConnectioncon=newSqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString1"].ConnectionString); SqlCommandcommand=newSqlCommand(query.ToString(),con); con.Open(); command.ExecuteNonQuery(); con.Close();}}