No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
With both subs you must enter the values as you would write them into a sql string i.e. 'mustsurroundstrings' I'm rather new at VB.Net and SQL but these work for me and are seem pretty efficient. If anyone has a way to improve on them or finds a flaw in … |
|
Re:
[LEFT]Hey guys. i am trying to insert data from a form to a sql database, but this error keeps coming up. [code]Incorrect syntax near ',' [/code] Here is the code. [code] Dim AddSwimmer_comm As New SqlCommand( _ "INSERT INTO [MasterRecords] ([APASCID], [FullName], [Gender], [DOB], [21m], [25m], [50m], [100m], [4x21m], [4x50m]) … |
|
Re:
Hi there, Being new to Vb.Net 2003, I need help to determine whether to Create new Record or Update an exisitng record in SQL SERVER table. In VB6 I used this logic to do that but in Vb.Net 2003, I am totally lost at it. Please Help me. Thanks. VB6 … |
|
[code] Public Sub add_emp(ByVal emp As EmployeeObj) Dim con As New SqlConnection Dim sqlcmd As SqlCommand 'Dim sqlrdr As SqlDataReader Try If is_emp(emp.Id) = False Then con.ConnectionString = My.Resources.ConnString con.Open() sqlcmd = New SqlCommand("INSERT INTO [Employees] (" _ & "[Id], [SocialSecurity], [FirstName], " _ & "[MiddleName], [LastName], [Suffix], " _ … |
|
Re:
ho do i store information to a mysql database? what i am trying to do is to fill out some students information and when i try to click save it should be saved to a mysql database.... here is my code but every time i click save it couldn't connect … |