No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
5 Posted Topics
 | 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 … |
| | Here's an example of what to do with boolean statements hope it helps. [code] sqlcmd = New SqlCommand("INSERT INTO [Employees] (" _ & "[Id], [Name], [Rehire] ) " _ & "VALUES ( " _ & " & idvalue & ", " _ & "'" & namevalue &"', " & & … |
| | Here's an example of adding a record and updating records it's not commented I'm horrible at remembering to comment but, if u have any questions please feel free to ask on here or u can email me. [code] Public Sub AddRecord(ByVal tbl As String, ByVal fields As String, ByVal values … |
| | [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], " _ … |
| | [QUOTE=herms14;822648]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 … |
The End.