Rowupdating in gridview in asp net

Add(New Data Column("Col1_Shift Type", Get Type(Int32))) dt. Add(New Data Column("Col1_Submitted By", Get Type(Int32))) Dim dr As Data Row While reader. Connection = conn3 sql3 = "SET DATEFORMAT dmy; SELECT * FROM xxx" cmd3. New Row() dr("Staff Name") = g_selectstaffname dr("Post Code") = g_selectpostcode dr("Staff Key") = Temp Staff Key dr("Post Key") = Temp Post Key 'Col1 If Temp Shift Date = g_header1 Then dr("Col1_Roster Key") = Temp Roster Key dr("Col1_Shift Date") = Temp Shift Date dr("Col1_Start Time") = Temp Start Time dr("Col1_End Time") = Temp End Time dr("Col1_SL") = Temp SL dr("Col1_VL") = Temp VL dr("Col1_ML") = Temp ML dr("Col1_PH") = Temp PH dr("Col1_APH") = Temp APH dr("Col1_TOIL") = Temp TOIL dr("Col1_Others") = Temp Others dr("Col1_Shift Type") = Temp Shift Type dr("Col1_Submitted By") = Temp Submitted By End If End If .................

New Edit Index 'Bind data to the Grid View control. Bind Data() End Sub Private Sub Create Data Table() Dim cmd As New System.

Add(New Data Column("Col1_TOIL", Get Type(String))) dt.

Add(New Data Column("Col1_Others", Get Type(String))) dt. Read() '---For each row g_Temp Staff Key = "0" Temp Staff Key = reader("staff_key") 'will not null g_selectstaffkey = Temp Staff Key g_selectpostkey = reader("post_key") g_selectstaffname = RTrim(reader("name_eng")) g_selectpostcode = RTrim(reader("post_code")) Using conn3 As New System.

If you have any compliments or complaints to MSDN Support, feel free to contact [email protected]

Now you can ask questions directly to me on my new site ASPForums.

442

Leave a Reply