Click here to Skip to main content
16,005,120 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: SplashScreen Pin
Dave Kreskowiak24-Feb-07 16:57
mveDave Kreskowiak24-Feb-07 16:57 
GeneralRe: SplashScreen Pin
WestSideRailways24-Feb-07 17:23
WestSideRailways24-Feb-07 17:23 
GeneralRe: SplashScreen Pin
Dave Kreskowiak25-Feb-07 5:42
mveDave Kreskowiak25-Feb-07 5:42 
AnswerRe: SplashScreen Pin
Christian Graus24-Feb-07 16:24
protectorChristian Graus24-Feb-07 16:24 
GeneralRe: SplashScreen Pin
WestSideRailways24-Feb-07 17:14
WestSideRailways24-Feb-07 17:14 
GeneralRe: SplashScreen Pin
Christian Graus25-Feb-07 8:57
protectorChristian Graus25-Feb-07 8:57 
AnswerRe: SplashScreen Pin
TwoFaced24-Feb-07 17:46
TwoFaced24-Feb-07 17:46 
GeneralRe: SplashScreen Pin
WestSideRailways24-Feb-07 18:33
WestSideRailways24-Feb-07 18:33 
Questionupdate doesnt save into table using vb.net Pin
7prince24-Feb-07 9:53
7prince24-Feb-07 9:53 
AnswerRe: update doesnt save into table using vb.net Pin
Dave Kreskowiak24-Feb-07 11:42
mveDave Kreskowiak24-Feb-07 11:42 
Questiontree view Pin
manni_n24-Feb-07 7:28
manni_n24-Feb-07 7:28 
AnswerRe: tree view Pin
MatrixCoder24-Feb-07 9:12
MatrixCoder24-Feb-07 9:12 
QuestionOleDB error Pin
7prince24-Feb-07 6:31
7prince24-Feb-07 6:31 
AnswerRe: OleDB error Pin
Dave Kreskowiak24-Feb-07 12:12
mveDave Kreskowiak24-Feb-07 12:12 
Questioninsert text data into database (SQL 2005) Pin
lyzaa24-Feb-07 5:22
lyzaa24-Feb-07 5:22 
AnswerRe: insert text data into database (SQL 2005) Pin
TriGiggleMich24-Feb-07 7:48
TriGiggleMich24-Feb-07 7:48 
I had a little trouble getting started as well in vb.net, don't give up though!!
Try this

'add this to setup your sub
Private Sub YourWorkSub()
Dim oDB as ClsDb
Dim MyQuery as String

try

oDB = New ClsDb("YourServerNameOrIP", "YourDataBaseName")
MyQuery = "Selec into (field name ID,field name IC,field name KP,field name Address) Values(1234,56,789,'quert')"
oDB.ExecuteQuery(MyQuery)

catch e as Exception
MsgBox(e.Message)
EndTry
End Sub

'Add This part down as a class
Imports System.Data.SqlClient

Public Class ClsDb
Private m_sServerIP As String
Private m_sDatabase As String

Sub New(ByVal sServerIP As String, ByVal sDatabase As String)
m_sServerIP = sServerIP
m_sDatabase = sDatabase
End Sub

Private Function GetConnection() As SqlConnection
Dim oDBConn As SqlConnection = New SqlConnection("User ID=YourUserID;Pwd=yourpass;Data Source=" & m_sServerIP & ";Initial Catalog=" & m_sDatabase)
Try
oDBConn.Open()

Catch e As SqlException
Throw e

End Try
Return oDBConn
End Function

Public Sub ExecuteQuery(ByVal sQuery)
Dim oCmd As SqlCommand
Dim oConn As SqlConnection

Try
oConn = GetConnection()
oCmd = New SqlCommand(sQuery, oConn)
oCmd.Connection = oConn
oCmd.ExecuteNonQuery()
oConn.Close()

Catch e As SqlException
Throw e
End Try
End Sub
End Class

Hope This Helps Ya!!Cool | :cool:
GeneralRe: insert text data into database (SQL 2005) Pin
lyzaa25-Feb-07 16:37
lyzaa25-Feb-07 16:37 
QuestionRegEx to replace a string [modified] Pin
T John24-Feb-07 3:40
T John24-Feb-07 3:40 
AnswerRe: RegEx to replace a string Pin
The Tigerman24-Feb-07 13:17
The Tigerman24-Feb-07 13:17 
GeneralRe: RegEx to replace a string Pin
T John25-Feb-07 4:36
T John25-Feb-07 4:36 
QuestionHow do you open an Access Query in Excel using a vb button? Pin
China-Gary24-Feb-07 2:09
China-Gary24-Feb-07 2:09 
QuestionCan a form have a scroll bar? Pin
steve_rm24-Feb-07 1:35
steve_rm24-Feb-07 1:35 
AnswerRe: Can a form have a scroll bar? Pin
JUNEYT24-Feb-07 2:10
JUNEYT24-Feb-07 2:10 
AnswerRe: Can a form have a scroll bar? Pin
manni_n24-Feb-07 2:22
manni_n24-Feb-07 2:22 
AnswerRe: Can a form have a scroll bar? Pin
Guffa24-Feb-07 3:41
Guffa24-Feb-07 3:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.