From: DavidC on 9 Jun 2010 16:32 I have a simple GridView with multiple columns from a Sql table. I have only 1 data column that I want to update (a date column) without having to have the user click an Edit button, edit the date and click the update button. I have the GridView wrapped in an UpdatePanel and have the code below in the TextChanged event of the TextBox. I think it may work if I can get the key value of the row I am on. Any help is appreciated. Thanks. Protected Sub txtCompleteDate_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Dim intKey As Int32 = 0 Dim tb As TextBox = CType(sender, TextBox) Dim dtNewDate As Date = Convert.ToDateTime(tb.Text) Using conData As SqlConnection = New SqlConnection(DBClass.GetCoreConnectionString) conData.Open() Dim strSQL As String = "UPDATE dbo.ApplicantRequirements" & _ " SET CompleteDate='" & dtNewDate.ToShortDateString & "'" & _ " WHERE ApplicantReqID = " & intKey.ToString End Using End Sub -- David
|
Pages: 1 Prev: Unable to generate a temporary class Next: HttpWebRequest and Reusing Connections |