作者:无限的天空-空间 | 来源:互联网 | 2023-05-17 12:44
Ihavetext-boxinsideagridviewandiamperformingandinsertstatementloopingthrougheveryrow
I have text-box inside a gridview and i am performing and insert statement looping through every row in my gridview. My issue now is that i can have multiple names in the text-box like this:
我在gridview中有文本框,我正在执行并插入语句循环遍历gridview中的每一行。我现在的问题是,我可以在文本框中有多个名称,如下所示:
John Carter, Mike David, John Edward,
so how can i split and insert each individual name into my table with the same ID? For instance, if the current row has ID =12 then my table will look like this:
那么如何将每个单独的名称拆分并插入到具有相同ID的表中?例如,如果当前行的ID = 12,那么我的表将如下所示:
ID Full_Name
12 John Carter
12 Mike David
12 John Edward
here is my code:
这是我的代码:
foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
Label ID = row.FindControl("lbl_ID") as Label;
TextBox myUID = row.FindControl("txt_UID") as TextBox;
string Full_Name = Request.Form[row.FindControl("txt_UID").UniqueID];
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["myConn"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"if not exists(select ID from myTable where ID = @ID)
insert into myTable(ID, Full_Name) values(@ID, @Full_Name)
else update myTable set Full_Name =@Full_Name where ID =@ID";
cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = ID.Text;
cmd.Parameters.Add("@Full_Name", SqlDbType.VarChar).Value = Full_Name.ToString();
cmd.COnnection= con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
3 个解决方案