扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条
asp:datagrid id="dgPopularFAQs" runat="server" AutoGenerateColumns="False"……> <Columns> <asp:BoundColumn DataField="FAQID" ItemStyle-Width="10%" ItemStyle-HorizontalAlign="Center" HeaderText="FAQ ID" />
<asp:BoundColumn DataField="CategoryName" HeaderText="Category" />
<asp:TemplateColumn HeaderText="Question"> <ItemTemplate> <asp:TextBox runat="server" id="txtDescription" Columns="75" Text='<%# Container.DataItem("Description") %>' /> </ItemTemplate> </asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Submitted By"> <ItemTemplate> <asp:TextBox runat="server" id="txtSubmittedBy" Text='<%# Container.DataItem("SubmittedByName") %>' /> </ItemTemplate> </asp:TemplateColumn>
</Columns> </asp:datagrid>之后,对DATAGRID进行一次遍历,Dim myConnection as New SqlConnection(connection string)
Dim myCommand as New SqlCommand(strSQL, myConnection)
Dim dgi as DataGridItem For Each dgi in dgPopularFAQs.Items 'Read in the Primary Key Field Dim id as Integer = Convert.ToInt32(dgPopularFAQs.DataKeys(dgi.ItemIndex))
Dim question as String = CType(dgi.FindControl("txtDescription"), TextBox)。Text Dim submittedBy as String = CType(dgi.FindControl("txtSubmittedBy"), TextBox)。Text
'Issue an UPDATE statement……
Dim updateSQL as String = "UPDATE TableName SET Question = @Question, " & _ "SubmittedByName = @SubmittedByName WHERE FAQID = @ID" myCommand.Parameters.Clear()
myCommand.Parameters.Add("@Question", question)
myCommand.Parameters.Add("@SubmittedByName", submittedBy)
myCommand.ExecuteNonQuery()
如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。
现场直击|2021世界人工智能大会
直击5G创新地带,就在2021MWC上海
5G已至 转型当时——服务提供商如何把握转型的绝佳时机
寻找自己的Flag
华为开发者大会2020(Cloud)- 科技行者