No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
3 Posted Topics
hi... im not able to update data in vb.net....here is my code: cmd = New SqlCommand("update tbl_Account_charts set AccountTypeid='" & cmbAccountType.Text & "',AccountNumber='" & TxtAccountNumber.Text & "',AccountName='" & txtaccountname.Text & "',Status='" & chbmark & "',UpdateDate='" & sys_date & "' where AccountTypeid=" & AccountID, con) cmd.ExecuteNonQuery()
hi.... im getting this error "Syntax error converting datetime from character string" when im trying to insert values into the table in sql server 2000....here is hw my code goes... insert into vw_student(RegNo,StudID,StudName,FathName,Sex,DOB,Department,DOJ,Yr,ContactNo)values('0001','1101','Abilash','Ramankutty','Female','1989-02-03','B.com','1styear','2006-06-16','90451299098') pls help me in solving dis....
The End.