Click here to Skip to main content
15,922,309 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: online cd database Pin
JR21223-Oct-08 3:20
JR21223-Oct-08 3:20 
QuestionAdding unmanged code to VB.NET Pin
Nanda160523-Oct-08 0:39
Nanda160523-Oct-08 0:39 
AnswerRe: Adding unmanged code to VB.NET Pin
jzonthemtn23-Oct-08 1:11
jzonthemtn23-Oct-08 1:11 
GeneralRe: Adding unmanged code to VB.NET Pin
Nanda160523-Oct-08 1:53
Nanda160523-Oct-08 1:53 
GeneralRe: Adding unmanged code to VB.NET Pin
Dave Kreskowiak23-Oct-08 2:02
mveDave Kreskowiak23-Oct-08 2:02 
GeneralRe: Adding unmanged code to VB.NET Pin
Nanda160523-Oct-08 2:13
Nanda160523-Oct-08 2:13 
GeneralRe: Adding unmanged code to VB.NET Pin
Dave Kreskowiak23-Oct-08 3:53
mveDave Kreskowiak23-Oct-08 3:53 
Questionusing store procedure to insert selected checkboxlist values into database Pin
Mamphekgo Bahula22-Oct-08 21:55
Mamphekgo Bahula22-Oct-08 21:55 
Hi I created store produce to insert selected values from checkboxlist into sql database and it gives me this error "Procedure or function SaveAdmin has too many arguments specified."
here is my store procedure

ALTER PROCEDURE [dbo].[SaveAdmin]
-- Add the parameters for the stored procedure here
@Perno int,
@Client_id int,
@Region_id int,
@Service_id int

AS
INSERT INTO Admin(Perno, Client_id, Region_id, Service_id)

VALUES(@Perno, @Client_id, @Region_id, @Service_id)
and here is my vb.net code

cmdStandby.CommandText = "SaveAdmin"
cmdStandby.CommandType = CommandType.StoredProcedure
cmdStandby.Connection = sqlstandby


cmdStandby.Parameters.AddWithValue("@Perno", lblEmpNo.Text)
cmdStandby.Parameters.AddWithValue("@Client_id", ddlClient1.SelectedValue)


For Each li In ChkRegion.Items
If li.Selected = True Then
cmdStandby.Parameters.AddWithValue("@Region_id", li.Value)

End If
Next


For Each li In ChkService.Items
If li.Selected = True Then

cmdStandby.Parameters.AddWithValue("@Service_id", li.Value)

End If
Next

cmdStandby.ExecuteNonQuery()

thanx in advance

Mamphekgo

AnswerRe: using store procedure to insert selected checkboxlist values into database Pin
TheComputerMan22-Oct-08 23:39
TheComputerMan22-Oct-08 23:39 
AnswerRe: using store procedure to insert selected checkboxlist values into database Pin
Dave Kreskowiak23-Oct-08 2:01
mveDave Kreskowiak23-Oct-08 2:01 
QuestionSFTP activex? Pin
hatemtaleb22-Oct-08 21:27
hatemtaleb22-Oct-08 21:27 
AnswerRe: SFTP activex? Pin
Dave Kreskowiak23-Oct-08 7:18
mveDave Kreskowiak23-Oct-08 7:18 
QuestionVariables.. Pin
Subjugate22-Oct-08 17:34
Subjugate22-Oct-08 17:34 
AnswerRe: Variables.. Pin
Rupesh Kumar Swami22-Oct-08 20:42
Rupesh Kumar Swami22-Oct-08 20:42 
AnswerRe: Variables.. Pin
Jon_Boy23-Oct-08 2:55
Jon_Boy23-Oct-08 2:55 
QuestionProblem with Drag & Drop between list boxes Pin
TheComputerMan22-Oct-08 12:38
TheComputerMan22-Oct-08 12:38 
AnswerRe: Problem with Drag & Drop between list boxes Pin
sumit703422-Oct-08 22:47
sumit703422-Oct-08 22:47 
GeneralRe: Problem with Drag & Drop between list boxes Pin
TheComputerMan22-Oct-08 23:01
TheComputerMan22-Oct-08 23:01 
GeneralRe: Problem with Drag & Drop between list boxes Pin
Mycroft Holmes22-Oct-08 23:39
professionalMycroft Holmes22-Oct-08 23:39 
GeneralRe: Problem with Drag & Drop between list boxes Pin
TheComputerMan22-Oct-08 23:44
TheComputerMan22-Oct-08 23:44 
QuestionDesignMode Dilemma! [modified] Pin
Saul Johnson22-Oct-08 8:49
Saul Johnson22-Oct-08 8:49 
AnswerRe: DesignMode Dilemma! Pin
Dave Kreskowiak22-Oct-08 11:43
mveDave Kreskowiak22-Oct-08 11:43 
GeneralRe: DesignMode Dilemma! Pin
Saul Johnson24-Oct-08 4:54
Saul Johnson24-Oct-08 4:54 
QuestionLinkLabels and Data Source Pin
KrisnNala22-Oct-08 8:28
KrisnNala22-Oct-08 8:28 
AnswerRe: LinkLabels and Data Source Pin
Wendelius22-Oct-08 9:40
mentorWendelius22-Oct-08 9:40 

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.