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 ...