Posted on: 5/23/2014 2:02:55 PM | Views : 387

Column name or number of supplied values doe not match table definition? How do i fix that?

'Saving Textboxes Sqlupdate.SelectCommand = "Select * From LOCATIONS where LOCATIONID = '" & SaveAsResult.Value & "'" Dim savetxtboxes As DataView = CType(Sqlupdate.Select(DataSourceSelectArguments.Empty), DataView) If savetxtboxes.Count = 0 Then 'Insert Sqlupdate.InsertCommand = "INSERT INTO LOCATIONS Values('" & txtlocwname.Text & "','" & txtlocnw.Text & "','" & txtaddr1.Text & "','" & txtaddr2.Text & "','" & txtaddr3.Text & "','" & txtcity.Text & "','" & txtzip.Text & "')" Sqlupdate.Insert() End If

Go to the complete details ...