Click here to Skip to main content
15,898,222 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Datagridview combobox column set selectedvalue Pin
Member 344963618-Jun-08 2:25
Member 344963618-Jun-08 2:25 
GeneralRe: Datagridview combobox column set selectedvalue Pin
Jay Royall18-Jun-08 2:35
Jay Royall18-Jun-08 2:35 
GeneralRe: Datagridview combobox column set selectedvalue Pin
Member 344963618-Jun-08 12:50
Member 344963618-Jun-08 12:50 
GeneralRe: Datagridview combobox column set selectedvalue Pin
ismusidhu30-Mar-10 19:39
ismusidhu30-Mar-10 19:39 
GeneralRe: Datagridview combobox column set selectedvalue Pin
san40329-Dec-10 1:41
san40329-Dec-10 1:41 
GeneralRe: Datagridview combobox column set selectedvalue Pin
imamul.karim3-Mar-11 0:44
imamul.karim3-Mar-11 0:44 
QuestionGraphics Pin
kmbhatt18-Jun-08 1:11
kmbhatt18-Jun-08 1:11 
QuestionVB.NET/SQL Pin
safealloys17-Jun-08 23:51
safealloys17-Jun-08 23:51 
Please help me with this CODE. What I want to do is to update the existing data in my database.


Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlClient.SqlDataReader
Imports System.Transactions
Imports System.Collections
Imports System.Collections.Generic

Public Class SelectStaffManager
Const strConnectionString As String = "Server=(local);Initial Catalog=VideoClub;User ID=sa;Password="
#Region "SQL Statements"
Private Const SQL_SELECT_STAFF As String = "Select * From Staff"

Public Shared Function SELECTStaff(ByVal FirstName As String, ByVal LastName As String, ByVal ContactAddress As String, ByVal MaritalStatus As String, _
ByVal Sex As String, ByVal EmailAddress As String, ByVal DateofBirth As Date, ByVal DateofEmployment As Date, _
ByVal Photograph As String, ByVal PhoneNo As String, ByRef strMessage As String) As Integer
Dim SqlConn As SqlConnection = Nothing
Dim cmd As SqlCommand = Nothing
Dim SqlParm As SqlParameter = Nothing
Dim collectdata As SqlDataReader

Try


'Prepare the SqlCommand Object and all it's neccessary properties for data commission into the database
SqlConn = New SqlConnection(strConnectionString)
cmd = New SqlCommand(SQL_SELECT_STAFF, SqlConn)


'cmd.Connection.Open()

collectdata = cmd.ExecuteReader

cmd.Connection.Close()
Catch ex As Exception
collectdata = Nothing
strMessage = ex.Message
End Try
Return collectdata
End Function

#End Region

End Class
AnswerRe: VB.NET/SQL Pin
Noctris18-Jun-08 0:09
Noctris18-Jun-08 0:09 
AnswerRe: VB.NET/SQL Pin
Ashfield18-Jun-08 3:44
Ashfield18-Jun-08 3:44 
QuestionFrom name as String to form reference Pin
nishkarsh_k17-Jun-08 23:48
nishkarsh_k17-Jun-08 23:48 
AnswerRe: From name as String to form reference Pin
darkelv18-Jun-08 15:34
darkelv18-Jun-08 15:34 
QuestionHow to save images into SQL database using ASP.net under VB instead of C# Pin
anting17-Jun-08 22:59
anting17-Jun-08 22:59 
AnswerRe: How to save images into SQL database using ASP.net under VB instead of C# Pin
Smithers-Jones17-Jun-08 23:04
Smithers-Jones17-Jun-08 23:04 
Questionreading logfile Pin
Ebube17-Jun-08 21:21
Ebube17-Jun-08 21:21 
AnswerRe: reading logfile Pin
Noctris18-Jun-08 0:14
Noctris18-Jun-08 0:14 
GeneralRe: reading logfile Pin
Ebube18-Jun-08 4:35
Ebube18-Jun-08 4:35 
GeneralRe: reading logfile Pin
Noctris18-Jun-08 6:02
Noctris18-Jun-08 6:02 
AnswerRe: reading logfile Pin
Hasan Jaffal18-Jun-08 20:05
Hasan Jaffal18-Jun-08 20:05 
QuestionAsking about global variable using VB.NET Window Form Application Pin
drexler_kk17-Jun-08 21:01
drexler_kk17-Jun-08 21:01 
AnswerRe: Asking about global variable using VB.NET Window Form Application Pin
Ashfield17-Jun-08 21:20
Ashfield17-Jun-08 21:20 
GeneralRe: Asking about global variable using VB.NET Window Form Application Pin
drexler_kk17-Jun-08 22:11
drexler_kk17-Jun-08 22:11 
AnswerRe: Asking about global variable using VB.NET Window Form Application Pin
Guffa17-Jun-08 21:34
Guffa17-Jun-08 21:34 
QuestionRe: Asking about global variable using VB.NET Window Form Application Pin
drexler_kk17-Jun-08 22:06
drexler_kk17-Jun-08 22:06 
AnswerRe: Asking about global variable using VB.NET Window Form Application Pin
Guffa17-Jun-08 22:21
Guffa17-Jun-08 22:21 

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.