473,883 Members | 1,852 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Too many args when running a stored procedure

M K
Heres my SP: ( i am trying to add more than 1 field but get the same error
no matter how many i try to add, i thought i would try to insert the primary
key only and work up from there but the primary key insert didnt work
either. I can run the SP manually in Visual Studio .NET and it works. When
i try to do this it doesn't.

Any help is greatly appreciated... newbie here as well so please be gentle
:)

ALTER PROCEDURE dbo.AddJob
@JobNumber varchar(30)
AS
INSERT INTO [Jobs].[dbo].[Job]
(JobRefNum)
VALUES
(@JobNumber)
Code:
SqlCommand1.Com mandType = CommandType.Sto redProcedure
SqlCommand1.Com mandText = "Jobs.dbo.AddJo b"
SqlCommand1.Par ameters.Add("@J obNumber", txtJobRefNumber .Text)
SqlCommand1.Exe cuteNonQuery()

Nov 21 '05
22 4306
Ok, let me take a shot at this. To start with, I created your database structure and SP in MSSQL.

First, you don't show that you are associating the connection object with the command. Have you done that? Secondly, your
procedure has 11 parameters and your code has 10, the "@MyDate" is missing. If you aren't going to use the parameter, remove it
from the SP parameters and replace the "@MyDate" with GetDate in the Values() line.

In order to get your code to work I had to create a connection object and connection string before opening it. I had too create a
new connection object. After opening the connection, I had to associate it with the command object. After that, I had to add a
Parameter object for the @MyDate parameter. Furthermore, I had to convert the date and money value (*.Text) to the appropriate data
types. Having done that, I was able to insert data into the table with the following code:

/////////////////
Public Sub TestIt()

Dim SqlConnection1 As OleDb.OleDbConn ection
Dim SqlCommand1 As New OleDb.OleDbComm and

Try
SqlConnection1 = Connect("sa", "gobblygoop ", dbtDatabase.dbt SqlServer, , "(local)")
' Connect is a general purpose function for connecting to various database types
' MsAbbess, MSSQL, Oracle, CSV, Excel, ...
SqlCommand1.Com mandType = CommandType.Sto redProcedure

SqlCommand1.Com mandText = "Jobs.dbo.AddAJ ob"

SqlCommand1.Con nection = SqlConnection1 '<< Added this line

SqlCommand1.Par ameters.Add("@J obName", "Test Job")

SqlCommand1.Par ameters.Add("@J obNumber", "123456")

SqlCommand1.Par ameters.Add("@C ontact", "Al Reid")

SqlCommand1.Par ameters.Add("@P hone", "4242502116 ")

SqlCommand1.Par ameters.Add("@F ax", "4022572410 ")

SqlCommand1.Par ameters.Add("@M yDate", CDate("09/17/2005")) '<<< Added this line

SqlCommand1.Par ameters.Add("@L ocation", "Here")

SqlCommand1.Par ameters.Add("@S kills", "DotNet")

SqlCommand1.Par ameters.Add("@A gency", "TechMe Corp")

'optional fields

SqlCommand1.Par ameters.Add("@C loseDate", CDate("09/17/2005")) '<< Converted to a date type

SqlCommand1.Par ameters.Add("@R ate", CType("65.50", Decimal)) '<< Converted to a numeric type

SqlCommand1.Exe cuteNonQuery()

Catch ex As Exception

MsgBox("Could not add record" & Chr(10) & ex.ToString())

Finally

SqlConnection1. Close()

End Try

End Sub
\\\\\\\\\\\\\\\ \\\\\

Also, I question the code that checks if a TextBox.Text is an empty string:
If txtFax.Text <> "" Then
SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
Else
SqlCommand1.Par ameters.Add("@F ax", "")
End If
This results in the same parameter data being sent to the SP as

SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)

Did you mean to substitute DbNull.Value for the "" in the else clause?

In any event, I was able to get your SL and modified code to function properly and never got an error indicating "Too many
arguments."
I hope this helps.

--
Al Reid

"M K" <sk*******@yaho o.com> wrote in message news:ld******** ***********@twi ster.southeast. rr.com... Did you see my first post?
I just tried creating a new SP within Visual Studio and I get the same thing
Here is all the code that I am trying to run. It does work fine if i run
the SP in Server Explorer and it updates
the table just fine.

SP:
ALTER PROCEDURE dbo.AddAJob

(

@JobName varchar(50),

@JobNumber varchar(30),

@Contact varchar(40),

@Phone char(10),

@Fax char(10),

@MyDate datetime = GetDate,

@Location varchar(40),

@Skills text,

@Agency varchar(40),

@CloseDate datetime,

@Rate money

)

AS

INSERT INTO [Jobs].[dbo].[Job]

(JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation, Skills,
Agency, CloseDate, Rate)

VALUES

(@JobName, @JobNumber, @Contact, @Phone, @Fax, @MyDate, @Location, @Skills,
@Agency, @CloseDate, @Rate)

RETURN
Code:

Try
SqlConnection1. Open()

'mandatory fields

SqlCommand1.Com mandType = CommandType.Sto redProcedure

SqlCommand1.Com mandText = "AddAJob"

SqlCommand1.Par ameters.Add("@J obName", txtJobName.Text )

SqlCommand1.Par ameters.Add("@J obNumber", txtJobRefNumber .Text)

SqlCommand1.Par ameters.Add("@C ontact", txtContact.Text )

SqlCommand1.Par ameters.Add("@P hone", txtPhone.Text)

If txtFax.Text <> "" Then

SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)

Else

SqlCommand1.Par ameters.Add("@F ax", "")

End If

SqlCommand1.Par ameters.Add("@L ocation", txtLocation.Tex t)

SqlCommand1.Par ameters.Add("@S kills", txtSkills.Text)

SqlCommand1.Par ameters.Add("@A gency", txtAgency.Text)

'optional fields

If calCloseDate.Te xt <> "" Then

SqlCommand1.Par ameters.Add("@C loseDate", Format(calClose Date.Text, "General
Date"))

Else

SqlCommand1.Par ameters.Add("@C loseDate", "")

End If

If txtRate.Text <> "" Then

SqlCommand1.Par ameters.Add("@R ate", Format(txtRate. Text, "Currency") )

Else

SqlCommand1.Par ameters.Add("@R ate", "")

End If

SqlCommand1.Exe cuteNonQuery()

Catch ex As Exception

MsgBox("Could not add record" & Chr(10) & ex.ToString())

Exit Function

Finally

SqlConnection1. Close()

End Try
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:OV******** ******@TK2MSFTN GP12.phx.gbl...
MK,

Are you maybe adding the parameter to the parameterlist more times, this
is not unlikely because normally we would have seen an instrucktion as

\\\
SqlCommand1.Par ameters("@JobNu mber").value = xtJobRefNumber. Text
SqlCommand1.Exe cuteNonQuery()
///
I hope this helps,

Cor


Nov 21 '05 #11
MK,

If you don't want to give further information than it is your case.

Very clever to show on a newsgroup where all people are active to tell
somebody that he must read your post that you sent on your local time 9.15
10:11. Maybe can you copy it yourself next time.

Although I have read it, and it is exact what I am telling you all the time.

Success

Cor

"M K" <sk*******@yaho o.com> schreef in bericht
news:Er******** ***********@twi ster.southeast. rr.com...
I tried your code as well and got the same error. The code i used i took
straight from the book and just put in my values instead.
Read my post from 9/15 10:11 as it has the exact error

"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:uk******** ******@TK2MSFTN GP15.phx.gbl...
MK,

Did you read my reply?

Now you show the same style of code. Where do you use that code, if that
is repeatedly done, than you will get an error message.

"Too many arguments"

Which has nothing to do with the stored procedure by the way.

Cor


Nov 21 '05 #12
Al,

I am asking if he is stepping in a simple error and he does not want to
answer if he has used it like this.

\\\
public sqlcommand1 as new sqlcommand
Button Click
SqlCommand1.Com mandType = CommandType.Sto redProcedure
SqlCommand1.Com mandText = "Jobs.dbo.AddJo b"
SqlCommand1.Par ameters.Add("@J obNumber", txtJobRefNumber .Text)
SqlCommand1.Exe cuteNonQuery()
///

With the second buttonclick does this gives the error "Procedure or
function AddJob has too many arguments specified at ..."

Cor
"Al Reid" <ar*****@reidDA SHhome.com> schreef in bericht
news:%2******** **********@TK2M SFTNGP10.phx.gb l...
Ok, let me take a shot at this. To start with, I created your database
structure and SP in MSSQL.

First, you don't show that you are associating the connection object with
the command. Have you done that? Secondly, your
procedure has 11 parameters and your code has 10, the "@MyDate" is
missing. If you aren't going to use the parameter, remove it
from the SP parameters and replace the "@MyDate" with GetDate in the
Values() line.

In order to get your code to work I had to create a connection object and
connection string before opening it. I had too create a
new connection object. After opening the connection, I had to associate
it with the command object. After that, I had to add a
Parameter object for the @MyDate parameter. Furthermore, I had to convert
the date and money value (*.Text) to the appropriate data
types. Having done that, I was able to insert data into the table with
the following code:

/////////////////
Public Sub TestIt()

Dim SqlConnection1 As OleDb.OleDbConn ection
Dim SqlCommand1 As New OleDb.OleDbComm and

Try
SqlConnection1 = Connect("sa", "gobblygoop ",
dbtDatabase.dbt SqlServer, , "(local)")
' Connect is a general purpose function for connecting to various
database types
' MsAbbess, MSSQL, Oracle, CSV, Excel, ...
SqlCommand1.Com mandType = CommandType.Sto redProcedure

SqlCommand1.Com mandText = "Jobs.dbo.AddAJ ob"

SqlCommand1.Con nection = SqlConnection1 '<< Added this line

SqlCommand1.Par ameters.Add("@J obName", "Test Job")

SqlCommand1.Par ameters.Add("@J obNumber", "123456")

SqlCommand1.Par ameters.Add("@C ontact", "Al Reid")

SqlCommand1.Par ameters.Add("@P hone", "4242502116 ")

SqlCommand1.Par ameters.Add("@F ax", "4022572410 ")

SqlCommand1.Par ameters.Add("@M yDate", CDate("09/17/2005")) '<<<
Added this line

SqlCommand1.Par ameters.Add("@L ocation", "Here")

SqlCommand1.Par ameters.Add("@S kills", "DotNet")

SqlCommand1.Par ameters.Add("@A gency", "TechMe Corp")

'optional fields

SqlCommand1.Par ameters.Add("@C loseDate", CDate("09/17/2005")) '<<
Converted to a date type

SqlCommand1.Par ameters.Add("@R ate", CType("65.50", Decimal)) '<<
Converted to a numeric type

SqlCommand1.Exe cuteNonQuery()

Catch ex As Exception

MsgBox("Could not add record" & Chr(10) & ex.ToString())

Finally

SqlConnection1. Close()

End Try

End Sub
\\\\\\\\\\\\\\\ \\\\\

Also, I question the code that checks if a TextBox.Text is an empty
string:
If txtFax.Text <> "" Then
SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
Else
SqlCommand1.Par ameters.Add("@F ax", "")
End If


This results in the same parameter data being sent to the SP as

SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)

Did you mean to substitute DbNull.Value for the "" in the else clause?

In any event, I was able to get your SL and modified code to function
properly and never got an error indicating "Too many
arguments."
I hope this helps.

--
Al Reid

"M K" <sk*******@yaho o.com> wrote in message
news:ld******** ***********@twi ster.southeast. rr.com...
Did you see my first post?
I just tried creating a new SP within Visual Studio and I get the same
thing
Here is all the code that I am trying to run. It does work fine if i run
the SP in Server Explorer and it updates
the table just fine.

SP:
ALTER PROCEDURE dbo.AddAJob

(

@JobName varchar(50),

@JobNumber varchar(30),

@Contact varchar(40),

@Phone char(10),

@Fax char(10),

@MyDate datetime = GetDate,

@Location varchar(40),

@Skills text,

@Agency varchar(40),

@CloseDate datetime,

@Rate money

)

AS

INSERT INTO [Jobs].[dbo].[Job]

(JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation,
Skills,
Agency, CloseDate, Rate)

VALUES

(@JobName, @JobNumber, @Contact, @Phone, @Fax, @MyDate, @Location,
@Skills,
@Agency, @CloseDate, @Rate)

RETURN
Code:

Try
SqlConnection1. Open()

'mandatory fields

SqlCommand1.Com mandType = CommandType.Sto redProcedure

SqlCommand1.Com mandText = "AddAJob"

SqlCommand1.Par ameters.Add("@J obName", txtJobName.Text )

SqlCommand1.Par ameters.Add("@J obNumber", txtJobRefNumber .Text)

SqlCommand1.Par ameters.Add("@C ontact", txtContact.Text )

SqlCommand1.Par ameters.Add("@P hone", txtPhone.Text)

If txtFax.Text <> "" Then

SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)

Else

SqlCommand1.Par ameters.Add("@F ax", "")

End If

SqlCommand1.Par ameters.Add("@L ocation", txtLocation.Tex t)

SqlCommand1.Par ameters.Add("@S kills", txtSkills.Text)

SqlCommand1.Par ameters.Add("@A gency", txtAgency.Text)

'optional fields

If calCloseDate.Te xt <> "" Then

SqlCommand1.Par ameters.Add("@C loseDate", Format(calClose Date.Text,
"General
Date"))

Else

SqlCommand1.Par ameters.Add("@C loseDate", "")

End If

If txtRate.Text <> "" Then

SqlCommand1.Par ameters.Add("@R ate", Format(txtRate. Text, "Currency") )

Else

SqlCommand1.Par ameters.Add("@R ate", "")

End If

SqlCommand1.Exe cuteNonQuery()

Catch ex As Exception

MsgBox("Could not add record" & Chr(10) & ex.ToString())

Exit Function

Finally

SqlConnection1. Close()

End Try
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:OV******** ******@TK2MSFTN GP12.phx.gbl...
> MK,
>
> Are you maybe adding the parameter to the parameterlist more times,
> this
> is not unlikely because normally we would have seen an instrucktion as
>
> \\\
> SqlCommand1.Par ameters("@JobNu mber").value = xtJobRefNumber. Text
> SqlCommand1.Exe cuteNonQuery()
> ///
> I hope this helps,
>
> Cor
>
>



Nov 21 '05 #13
Cor,

Indeed, if the SqlCommand1 object is declared at the class/module level rather than locally scoped, then each subsequent "Button
Click" will append the parameter again and will result in the "Too many arguments were supplied..." exception.

--
Al Reid

"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message news:%2******** ********@TK2MSF TNGP15.phx.gbl. ..
Al,

I am asking if he is stepping in a simple error and he does not want to
answer if he has used it like this.

\\\
public sqlcommand1 as new sqlcommand
Button Click
SqlCommand1.Com mandType = CommandType.Sto redProcedure
SqlCommand1.Com mandText = "Jobs.dbo.AddJo b"
SqlCommand1.Par ameters.Add("@J obNumber", txtJobRefNumber .Text)
SqlCommand1.Exe cuteNonQuery()
///

With the second buttonclick does this gives the error "Procedure or
function AddJob has too many arguments specified at ..."

Cor

Nov 21 '05 #14
M K
Al thanks for the great information. I have the SQLCommand And
SQLConnection objects due to the fact when i created the SP i dragged it to
the form which created both objects for me

I thought there was a Null object but when i put in Null it didnt work
thanks for correcting my use of DBNull

I have tried the @MyDate parm this way as well and still get the same error.
I have tried so many things i cant remember what i have tried or not but it
always results in the same error. I even tried just inserting just the
primary key and still the same error, ive even put the parameters in code in
the same order as below.
ALTER PROCEDURE dbo.AddAJob

(

@JobName varchar(50),

@JobNumber varchar(30),

@Contact varchar(40),

@Phone char(10),

@Fax char(10),

--@MyDate datetime = GetDate,

@Location varchar(40),

@Skills text,

@Agency varchar(40),

@CloseDate datetime,

@Rate money

)

AS

INSERT INTO [Jobs].[dbo].[Job]

(JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation, Skills,
Agency, CloseDate, Rate)

VALUES

(@JobName, @JobNumber, @Contact, @Phone, @Fax, GetDate(), @Location,
@Skills, @Agency, @CloseDate, @Rate)

RETURN

"Al Reid" <ar*****@reidDA SHhome.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...
Ok, let me take a shot at this. To start with, I created your database
structure and SP in MSSQL.

First, you don't show that you are associating the connection object with
the command. Have you done that? Secondly, your
procedure has 11 parameters and your code has 10, the "@MyDate" is
missing. If you aren't going to use the parameter, remove it
from the SP parameters and replace the "@MyDate" with GetDate in the
Values() line.

In order to get your code to work I had to create a connection object and
connection string before opening it. I had too create a
new connection object. After opening the connection, I had to associate
it with the command object. After that, I had to add a
Parameter object for the @MyDate parameter. Furthermore, I had to convert
the date and money value (*.Text) to the appropriate data
types. Having done that, I was able to insert data into the table with
the following code:

/////////////////
Public Sub TestIt()

Dim SqlConnection1 As OleDb.OleDbConn ection
Dim SqlCommand1 As New OleDb.OleDbComm and

Try
SqlConnection1 = Connect("sa", "gobblygoop ",
dbtDatabase.dbt SqlServer, , "(local)")
' Connect is a general purpose function for connecting to various
database types
' MsAbbess, MSSQL, Oracle, CSV, Excel, ...
SqlCommand1.Com mandType = CommandType.Sto redProcedure

SqlCommand1.Com mandText = "Jobs.dbo.AddAJ ob"

SqlCommand1.Con nection = SqlConnection1 '<< Added this line

SqlCommand1.Par ameters.Add("@J obName", "Test Job")

SqlCommand1.Par ameters.Add("@J obNumber", "123456")

SqlCommand1.Par ameters.Add("@C ontact", "Al Reid")

SqlCommand1.Par ameters.Add("@P hone", "4242502116 ")

SqlCommand1.Par ameters.Add("@F ax", "4022572410 ")

SqlCommand1.Par ameters.Add("@M yDate", CDate("09/17/2005")) '<<<
Added this line

SqlCommand1.Par ameters.Add("@L ocation", "Here")

SqlCommand1.Par ameters.Add("@S kills", "DotNet")

SqlCommand1.Par ameters.Add("@A gency", "TechMe Corp")

'optional fields

SqlCommand1.Par ameters.Add("@C loseDate", CDate("09/17/2005")) '<<
Converted to a date type

SqlCommand1.Par ameters.Add("@R ate", CType("65.50", Decimal)) '<<
Converted to a numeric type

SqlCommand1.Exe cuteNonQuery()

Catch ex As Exception

MsgBox("Could not add record" & Chr(10) & ex.ToString())

Finally

SqlConnection1. Close()

End Try

End Sub
\\\\\\\\\\\\\\\ \\\\\

Also, I question the code that checks if a TextBox.Text is an empty
string:
If txtFax.Text <> "" Then
SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
Else
SqlCommand1.Par ameters.Add("@F ax", "")
End If


This results in the same parameter data being sent to the SP as

SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)

Did you mean to substitute DbNull.Value for the "" in the else clause?

In any event, I was able to get your SL and modified code to function
properly and never got an error indicating "Too many
arguments."
I hope this helps.

--
Al Reid

"M K" <sk*******@yaho o.com> wrote in message
news:ld******** ***********@twi ster.southeast. rr.com...
Did you see my first post?
I just tried creating a new SP within Visual Studio and I get the same
thing
Here is all the code that I am trying to run. It does work fine if i run
the SP in Server Explorer and it updates
the table just fine.

SP:
ALTER PROCEDURE dbo.AddAJob

(

@JobName varchar(50),

@JobNumber varchar(30),

@Contact varchar(40),

@Phone char(10),

@Fax char(10),

@MyDate datetime = GetDate,

@Location varchar(40),

@Skills text,

@Agency varchar(40),

@CloseDate datetime,

@Rate money

)

AS

INSERT INTO [Jobs].[dbo].[Job]

(JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation,
Skills,
Agency, CloseDate, Rate)

VALUES

(@JobName, @JobNumber, @Contact, @Phone, @Fax, @MyDate, @Location,
@Skills,
@Agency, @CloseDate, @Rate)

RETURN
Code:

Try
SqlConnection1. Open()

'mandatory fields

SqlCommand1.Com mandType = CommandType.Sto redProcedure

SqlCommand1.Com mandText = "AddAJob"

SqlCommand1.Par ameters.Add("@J obName", txtJobName.Text )

SqlCommand1.Par ameters.Add("@J obNumber", txtJobRefNumber .Text)

SqlCommand1.Par ameters.Add("@C ontact", txtContact.Text )

SqlCommand1.Par ameters.Add("@P hone", txtPhone.Text)

If txtFax.Text <> "" Then

SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)

Else

SqlCommand1.Par ameters.Add("@F ax", "")

End If

SqlCommand1.Par ameters.Add("@L ocation", txtLocation.Tex t)

SqlCommand1.Par ameters.Add("@S kills", txtSkills.Text)

SqlCommand1.Par ameters.Add("@A gency", txtAgency.Text)

'optional fields

If calCloseDate.Te xt <> "" Then

SqlCommand1.Par ameters.Add("@C loseDate", Format(calClose Date.Text,
"General
Date"))

Else

SqlCommand1.Par ameters.Add("@C loseDate", "")

End If

If txtRate.Text <> "" Then

SqlCommand1.Par ameters.Add("@R ate", Format(txtRate. Text, "Currency") )

Else

SqlCommand1.Par ameters.Add("@R ate", "")

End If

SqlCommand1.Exe cuteNonQuery()

Catch ex As Exception

MsgBox("Could not add record" & Chr(10) & ex.ToString())

Exit Function

Finally

SqlConnection1. Close()

End Try
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:OV******** ******@TK2MSFTN GP12.phx.gbl...
> MK,
>
> Are you maybe adding the parameter to the parameterlist more times,
> this
> is not unlikely because normally we would have seen an instrucktion as
>
> \\\
> SqlCommand1.Par ameters("@JobNu mber").value = xtJobRefNumber. Text
> SqlCommand1.Exe cuteNonQuery()
> ///
> I hope this helps,
>
> Cor
>
>



Nov 21 '05 #15
M K
Cor,
I have tried that as well. I have 2 objects command and connection that
i dragged from server explorer (the SP) to the form which creates the 2
objects and fills in all the fields (ie connection string, sp name etc)

I have tried to insert just the 1 primary key and it still has the same
error. I only push the button 1time and wait
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:%2******** ********@TK2MSF TNGP15.phx.gbl. ..
Al,

I am asking if he is stepping in a simple error and he does not want to
answer if he has used it like this.

\\\
public sqlcommand1 as new sqlcommand
Button Click
SqlCommand1.Com mandType = CommandType.Sto redProcedure
SqlCommand1.Com mandText = "Jobs.dbo.AddJo b"
SqlCommand1.Par ameters.Add("@J obNumber", txtJobRefNumber .Text)
SqlCommand1.Exe cuteNonQuery()
///

With the second buttonclick does this gives the error "Procedure or
function AddJob has too many arguments specified at ..."

Cor
"Al Reid" <ar*****@reidDA SHhome.com> schreef in bericht
news:%2******** **********@TK2M SFTNGP10.phx.gb l...
Ok, let me take a shot at this. To start with, I created your database
structure and SP in MSSQL.

First, you don't show that you are associating the connection object with
the command. Have you done that? Secondly, your
procedure has 11 parameters and your code has 10, the "@MyDate" is
missing. If you aren't going to use the parameter, remove it
from the SP parameters and replace the "@MyDate" with GetDate in the
Values() line.

In order to get your code to work I had to create a connection object and
connection string before opening it. I had too create a
new connection object. After opening the connection, I had to associate
it with the command object. After that, I had to add a
Parameter object for the @MyDate parameter. Furthermore, I had to
convert the date and money value (*.Text) to the appropriate data
types. Having done that, I was able to insert data into the table with
the following code:

/////////////////
Public Sub TestIt()

Dim SqlConnection1 As OleDb.OleDbConn ection
Dim SqlCommand1 As New OleDb.OleDbComm and

Try
SqlConnection1 = Connect("sa", "gobblygoop ",
dbtDatabase.dbt SqlServer, , "(local)")
' Connect is a general purpose function for connecting to various
database types
' MsAbbess, MSSQL, Oracle, CSV, Excel, ...
SqlCommand1.Com mandType = CommandType.Sto redProcedure

SqlCommand1.Com mandText = "Jobs.dbo.AddAJ ob"

SqlCommand1.Con nection = SqlConnection1 '<< Added this line

SqlCommand1.Par ameters.Add("@J obName", "Test Job")

SqlCommand1.Par ameters.Add("@J obNumber", "123456")

SqlCommand1.Par ameters.Add("@C ontact", "Al Reid")

SqlCommand1.Par ameters.Add("@P hone", "4242502116 ")

SqlCommand1.Par ameters.Add("@F ax", "4022572410 ")

SqlCommand1.Par ameters.Add("@M yDate", CDate("09/17/2005")) '<<<
Added this line

SqlCommand1.Par ameters.Add("@L ocation", "Here")

SqlCommand1.Par ameters.Add("@S kills", "DotNet")

SqlCommand1.Par ameters.Add("@A gency", "TechMe Corp")

'optional fields

SqlCommand1.Par ameters.Add("@C loseDate", CDate("09/17/2005")) '<<
Converted to a date type

SqlCommand1.Par ameters.Add("@R ate", CType("65.50", Decimal)) '<<
Converted to a numeric type

SqlCommand1.Exe cuteNonQuery()

Catch ex As Exception

MsgBox("Could not add record" & Chr(10) & ex.ToString())

Finally

SqlConnection1. Close()

End Try

End Sub
\\\\\\\\\\\\\\\ \\\\\

Also, I question the code that checks if a TextBox.Text is an empty
string:
If txtFax.Text <> "" Then
SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
Else
SqlCommand1.Par ameters.Add("@F ax", "")
End If


This results in the same parameter data being sent to the SP as

SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)

Did you mean to substitute DbNull.Value for the "" in the else clause?

In any event, I was able to get your SL and modified code to function
properly and never got an error indicating "Too many
arguments."
I hope this helps.

--
Al Reid

"M K" <sk*******@yaho o.com> wrote in message
news:ld******** ***********@twi ster.southeast. rr.com...
Did you see my first post?
I just tried creating a new SP within Visual Studio and I get the same
thing
Here is all the code that I am trying to run. It does work fine if i
run
the SP in Server Explorer and it updates
the table just fine.

SP:
ALTER PROCEDURE dbo.AddAJob

(

@JobName varchar(50),

@JobNumber varchar(30),

@Contact varchar(40),

@Phone char(10),

@Fax char(10),

@MyDate datetime = GetDate,

@Location varchar(40),

@Skills text,

@Agency varchar(40),

@CloseDate datetime,

@Rate money

)

AS

INSERT INTO [Jobs].[dbo].[Job]

(JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation,
Skills,
Agency, CloseDate, Rate)

VALUES

(@JobName, @JobNumber, @Contact, @Phone, @Fax, @MyDate, @Location,
@Skills,
@Agency, @CloseDate, @Rate)

RETURN
Code:

Try
SqlConnection1. Open()

'mandatory fields

SqlCommand1.Com mandType = CommandType.Sto redProcedure

SqlCommand1.Com mandText = "AddAJob"

SqlCommand1.Par ameters.Add("@J obName", txtJobName.Text )

SqlCommand1.Par ameters.Add("@J obNumber", txtJobRefNumber .Text)

SqlCommand1.Par ameters.Add("@C ontact", txtContact.Text )

SqlCommand1.Par ameters.Add("@P hone", txtPhone.Text)

If txtFax.Text <> "" Then

SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)

Else

SqlCommand1.Par ameters.Add("@F ax", "")

End If

SqlCommand1.Par ameters.Add("@L ocation", txtLocation.Tex t)

SqlCommand1.Par ameters.Add("@S kills", txtSkills.Text)

SqlCommand1.Par ameters.Add("@A gency", txtAgency.Text)

'optional fields

If calCloseDate.Te xt <> "" Then

SqlCommand1.Par ameters.Add("@C loseDate", Format(calClose Date.Text,
"General
Date"))

Else

SqlCommand1.Par ameters.Add("@C loseDate", "")

End If

If txtRate.Text <> "" Then

SqlCommand1.Par ameters.Add("@R ate", Format(txtRate. Text, "Currency") )

Else

SqlCommand1.Par ameters.Add("@R ate", "")

End If

SqlCommand1.Exe cuteNonQuery()

Catch ex As Exception

MsgBox("Could not add record" & Chr(10) & ex.ToString())

Exit Function

Finally

SqlConnection1. Close()

End Try
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:OV******** ******@TK2MSFTN GP12.phx.gbl...
> MK,
>
> Are you maybe adding the parameter to the parameterlist more times,
> this
> is not unlikely because normally we would have seen an instrucktion as
>
> \\\
> SqlCommand1.Par ameters("@JobNu mber").value = xtJobRefNumber. Text
> SqlCommand1.Exe cuteNonQuery()
> ///
> I hope this helps,
>
> Cor
>
>



Nov 21 '05 #16
MK,

Perhaps you have a duplicate definition of "AddAJob" in the master database schema. I noticed that you were not specifying the
schema.owner.sp name in the .CommandText. Try

SqlCommand1.Com mandText = "Jobs.dbo.AddAJ ob"

and see if you get the expected results. As I stated, I replicated your schema and SP in my system and had it working using the
code I posted.

--
Al Reid
"M K" <sk*******@yaho o.com> wrote in message news:HT******** ***********@twi ster.southeast. rr.com...
Al thanks for the great information. I have the SQLCommand And
SQLConnection objects due to the fact when i created the SP i dragged it to
the form which created both objects for me

I thought there was a Null object but when i put in Null it didnt work
thanks for correcting my use of DBNull

I have tried the @MyDate parm this way as well and still get the same error.
I have tried so many things i cant remember what i have tried or not but it
always results in the same error. I even tried just inserting just the
primary key and still the same error, ive even put the parameters in code in
the same order as below.
ALTER PROCEDURE dbo.AddAJob

(

@JobName varchar(50),

@JobNumber varchar(30),

@Contact varchar(40),

@Phone char(10),

@Fax char(10),

--@MyDate datetime = GetDate,

@Location varchar(40),

@Skills text,

@Agency varchar(40),

@CloseDate datetime,

@Rate money

)

AS

INSERT INTO [Jobs].[dbo].[Job]

(JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation, Skills,
Agency, CloseDate, Rate)

VALUES

(@JobName, @JobNumber, @Contact, @Phone, @Fax, GetDate(), @Location,
@Skills, @Agency, @CloseDate, @Rate)

RETURN

"Al Reid" <ar*****@reidDA SHhome.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...
Ok, let me take a shot at this. To start with, I created your database
structure and SP in MSSQL.

First, you don't show that you are associating the connection object with
the command. Have you done that? Secondly, your
procedure has 11 parameters and your code has 10, the "@MyDate" is
missing. If you aren't going to use the parameter, remove it
from the SP parameters and replace the "@MyDate" with GetDate in the
Values() line.

In order to get your code to work I had to create a connection object and
connection string before opening it. I had too create a
new connection object. After opening the connection, I had to associate
it with the command object. After that, I had to add a
Parameter object for the @MyDate parameter. Furthermore, I had to convert
the date and money value (*.Text) to the appropriate data
types. Having done that, I was able to insert data into the table with
the following code:

/////////////////
Public Sub TestIt()

Dim SqlConnection1 As OleDb.OleDbConn ection
Dim SqlCommand1 As New OleDb.OleDbComm and

Try
SqlConnection1 = Connect("sa", "gobblygoop ",
dbtDatabase.dbt SqlServer, , "(local)")
' Connect is a general purpose function for connecting to various
database types
' MsAbbess, MSSQL, Oracle, CSV, Excel, ...
SqlCommand1.Com mandType = CommandType.Sto redProcedure

SqlCommand1.Com mandText = "Jobs.dbo.AddAJ ob"

SqlCommand1.Con nection = SqlConnection1 '<< Added this line

SqlCommand1.Par ameters.Add("@J obName", "Test Job")

SqlCommand1.Par ameters.Add("@J obNumber", "123456")

SqlCommand1.Par ameters.Add("@C ontact", "Al Reid")

SqlCommand1.Par ameters.Add("@P hone", "4242502116 ")

SqlCommand1.Par ameters.Add("@F ax", "4022572410 ")

SqlCommand1.Par ameters.Add("@M yDate", CDate("09/17/2005")) '<<<
Added this line

SqlCommand1.Par ameters.Add("@L ocation", "Here")

SqlCommand1.Par ameters.Add("@S kills", "DotNet")

SqlCommand1.Par ameters.Add("@A gency", "TechMe Corp")

'optional fields

SqlCommand1.Par ameters.Add("@C loseDate", CDate("09/17/2005")) '<<
Converted to a date type

SqlCommand1.Par ameters.Add("@R ate", CType("65.50", Decimal)) '<<
Converted to a numeric type

SqlCommand1.Exe cuteNonQuery()

Catch ex As Exception

MsgBox("Could not add record" & Chr(10) & ex.ToString())

Finally

SqlConnection1. Close()

End Try

End Sub
\\\\\\\\\\\\\\\ \\\\\

Also, I question the code that checks if a TextBox.Text is an empty
string:
If txtFax.Text <> "" Then
SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
Else
SqlCommand1.Par ameters.Add("@F ax", "")
End If


This results in the same parameter data being sent to the SP as

SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)

Did you mean to substitute DbNull.Value for the "" in the else clause?

In any event, I was able to get your SL and modified code to function
properly and never got an error indicating "Too many
arguments."
I hope this helps.

--
Al Reid

"M K" <sk*******@yaho o.com> wrote in message
news:ld******** ***********@twi ster.southeast. rr.com...
Did you see my first post?
I just tried creating a new SP within Visual Studio and I get the same
thing
Here is all the code that I am trying to run. It does work fine if i run
the SP in Server Explorer and it updates
the table just fine.

SP:
ALTER PROCEDURE dbo.AddAJob

(

@JobName varchar(50),

@JobNumber varchar(30),

@Contact varchar(40),

@Phone char(10),

@Fax char(10),

@MyDate datetime = GetDate,

@Location varchar(40),

@Skills text,

@Agency varchar(40),

@CloseDate datetime,

@Rate money

)

AS

INSERT INTO [Jobs].[dbo].[Job]

(JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation,
Skills,
Agency, CloseDate, Rate)

VALUES

(@JobName, @JobNumber, @Contact, @Phone, @Fax, @MyDate, @Location,
@Skills,
@Agency, @CloseDate, @Rate)

RETURN
Code:

Try
SqlConnection1. Open()

'mandatory fields

SqlCommand1.Com mandType = CommandType.Sto redProcedure

SqlCommand1.Com mandText = "AddAJob"

SqlCommand1.Par ameters.Add("@J obName", txtJobName.Text )

SqlCommand1.Par ameters.Add("@J obNumber", txtJobRefNumber .Text)

SqlCommand1.Par ameters.Add("@C ontact", txtContact.Text )

SqlCommand1.Par ameters.Add("@P hone", txtPhone.Text)

If txtFax.Text <> "" Then

SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)

Else

SqlCommand1.Par ameters.Add("@F ax", "")

End If

SqlCommand1.Par ameters.Add("@L ocation", txtLocation.Tex t)

SqlCommand1.Par ameters.Add("@S kills", txtSkills.Text)

SqlCommand1.Par ameters.Add("@A gency", txtAgency.Text)

'optional fields

If calCloseDate.Te xt <> "" Then

SqlCommand1.Par ameters.Add("@C loseDate", Format(calClose Date.Text,
"General
Date"))

Else

SqlCommand1.Par ameters.Add("@C loseDate", "")

End If

If txtRate.Text <> "" Then

SqlCommand1.Par ameters.Add("@R ate", Format(txtRate. Text, "Currency") )

Else

SqlCommand1.Par ameters.Add("@R ate", "")

End If

SqlCommand1.Exe cuteNonQuery()

Catch ex As Exception

MsgBox("Could not add record" & Chr(10) & ex.ToString())

Exit Function

Finally

SqlConnection1. Close()

End Try
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:OV******** ******@TK2MSFTN GP12.phx.gbl...
> MK,
>
> Are you maybe adding the parameter to the parameterlist more times,
> this
> is not unlikely because normally we would have seen an instrucktion as
>
> \\\
> SqlCommand1.Par ameters("@JobNu mber").value = xtJobRefNumber. Text
> SqlCommand1.Exe cuteNonQuery()
> ///
> I hope this helps,
>
> Cor
>
>



Nov 21 '05 #17
M K
Yup I've tried that too.. lol.. man this is frustrating.. You use the OLE
object where I am trying to use the SQL object. Would that be the problem?
If i cant figure this out im going to make them inline vs stored procedure..
ugggg

"Al Reid" <ar*****@reidDA SHhome.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
MK,

Perhaps you have a duplicate definition of "AddAJob" in the master
database schema. I noticed that you were not specifying the
schema.owner.sp name in the .CommandText. Try

SqlCommand1.Com mandText = "Jobs.dbo.AddAJ ob"

and see if you get the expected results. As I stated, I replicated your
schema and SP in my system and had it working using the
code I posted.

--
Al Reid
"M K" <sk*******@yaho o.com> wrote in message
news:HT******** ***********@twi ster.southeast. rr.com...
Al thanks for the great information. I have the SQLCommand And
SQLConnection objects due to the fact when i created the SP i dragged it
to
the form which created both objects for me

I thought there was a Null object but when i put in Null it didnt work
thanks for correcting my use of DBNull

I have tried the @MyDate parm this way as well and still get the same
error.
I have tried so many things i cant remember what i have tried or not but
it
always results in the same error. I even tried just inserting just the
primary key and still the same error, ive even put the parameters in code
in
the same order as below.
ALTER PROCEDURE dbo.AddAJob

(

@JobName varchar(50),

@JobNumber varchar(30),

@Contact varchar(40),

@Phone char(10),

@Fax char(10),

--@MyDate datetime = GetDate,

@Location varchar(40),

@Skills text,

@Agency varchar(40),

@CloseDate datetime,

@Rate money

)

AS

INSERT INTO [Jobs].[dbo].[Job]

(JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation,
Skills,
Agency, CloseDate, Rate)

VALUES

(@JobName, @JobNumber, @Contact, @Phone, @Fax, GetDate(), @Location,
@Skills, @Agency, @CloseDate, @Rate)

RETURN

"Al Reid" <ar*****@reidDA SHhome.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...
> Ok, let me take a shot at this. To start with, I created your database
> structure and SP in MSSQL.
>
> First, you don't show that you are associating the connection object
> with
> the command. Have you done that? Secondly, your
> procedure has 11 parameters and your code has 10, the "@MyDate" is
> missing. If you aren't going to use the parameter, remove it
> from the SP parameters and replace the "@MyDate" with GetDate in the
> Values() line.
>
> In order to get your code to work I had to create a connection object
> and
> connection string before opening it. I had too create a
> new connection object. After opening the connection, I had to
> associate
> it with the command object. After that, I had to add a
> Parameter object for the @MyDate parameter. Furthermore, I had to
> convert
> the date and money value (*.Text) to the appropriate data
> types. Having done that, I was able to insert data into the table with
> the following code:
>
> /////////////////
> Public Sub TestIt()
>
> Dim SqlConnection1 As OleDb.OleDbConn ection
> Dim SqlCommand1 As New OleDb.OleDbComm and
>
> Try
> SqlConnection1 = Connect("sa", "gobblygoop ",
> dbtDatabase.dbt SqlServer, , "(local)")
> ' Connect is a general purpose function for connecting to
> various
> database types
> ' MsAbbess, MSSQL, Oracle, CSV, Excel, ...
>
>
> SqlCommand1.Com mandType = CommandType.Sto redProcedure
>
> SqlCommand1.Com mandText = "Jobs.dbo.AddAJ ob"
>
> SqlCommand1.Con nection = SqlConnection1 '<< Added this line
>
> SqlCommand1.Par ameters.Add("@J obName", "Test Job")
>
> SqlCommand1.Par ameters.Add("@J obNumber", "123456")
>
> SqlCommand1.Par ameters.Add("@C ontact", "Al Reid")
>
> SqlCommand1.Par ameters.Add("@P hone", "4242502116 ")
>
> SqlCommand1.Par ameters.Add("@F ax", "4022572410 ")
>
> SqlCommand1.Par ameters.Add("@M yDate", CDate("09/17/2005")) '<<<
> Added this line
>
> SqlCommand1.Par ameters.Add("@L ocation", "Here")
>
> SqlCommand1.Par ameters.Add("@S kills", "DotNet")
>
> SqlCommand1.Par ameters.Add("@A gency", "TechMe Corp")
>
> 'optional fields
>
> SqlCommand1.Par ameters.Add("@C loseDate", CDate("09/17/2005"))
> '<<
> Converted to a date type
>
> SqlCommand1.Par ameters.Add("@R ate", CType("65.50", Decimal))
> '<<
> Converted to a numeric type
>
> SqlCommand1.Exe cuteNonQuery()
>
> Catch ex As Exception
>
> MsgBox("Could not add record" & Chr(10) & ex.ToString())
>
> Finally
>
> SqlConnection1. Close()
>
> End Try
>
> End Sub
> \\\\\\\\\\\\\\\ \\\\\
>
> Also, I question the code that checks if a TextBox.Text is an empty
> string:
>
>> If txtFax.Text <> "" Then
>> SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
>> Else
>> SqlCommand1.Par ameters.Add("@F ax", "")
>> End If
>
> This results in the same parameter data being sent to the SP as
>
> SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
>
> Did you mean to substitute DbNull.Value for the "" in the else clause?
>
> In any event, I was able to get your SL and modified code to function
> properly and never got an error indicating "Too many
> arguments."
>
>
> I hope this helps.
>
> --
> Al Reid
>
> "M K" <sk*******@yaho o.com> wrote in message
> news:ld******** ***********@twi ster.southeast. rr.com...
>> Did you see my first post?
>> I just tried creating a new SP within Visual Studio and I get the same
>> thing
>> Here is all the code that I am trying to run. It does work fine if i
>> run
>> the SP in Server Explorer and it updates
>> the table just fine.
>>
>> SP:
>> ALTER PROCEDURE dbo.AddAJob
>>
>> (
>>
>> @JobName varchar(50),
>>
>> @JobNumber varchar(30),
>>
>> @Contact varchar(40),
>>
>> @Phone char(10),
>>
>> @Fax char(10),
>>
>> @MyDate datetime = GetDate,
>>
>> @Location varchar(40),
>>
>> @Skills text,
>>
>> @Agency varchar(40),
>>
>> @CloseDate datetime,
>>
>> @Rate money
>>
>> )
>>
>> AS
>>
>> INSERT INTO [Jobs].[dbo].[Job]
>>
>> (JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation,
>> Skills,
>> Agency, CloseDate, Rate)
>>
>> VALUES
>>
>> (@JobName, @JobNumber, @Contact, @Phone, @Fax, @MyDate, @Location,
>> @Skills,
>> @Agency, @CloseDate, @Rate)
>>
>> RETURN
>>
>>
>> Code:
>>
>> Try
>> SqlConnection1. Open()
>>
>> 'mandatory fields
>>
>> SqlCommand1.Com mandType = CommandType.Sto redProcedure
>>
>> SqlCommand1.Com mandText = "AddAJob"
>>
>> SqlCommand1.Par ameters.Add("@J obName", txtJobName.Text )
>>
>> SqlCommand1.Par ameters.Add("@J obNumber", txtJobRefNumber .Text)
>>
>> SqlCommand1.Par ameters.Add("@C ontact", txtContact.Text )
>>
>> SqlCommand1.Par ameters.Add("@P hone", txtPhone.Text)
>>
>> If txtFax.Text <> "" Then
>>
>> SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
>>
>> Else
>>
>> SqlCommand1.Par ameters.Add("@F ax", "")
>>
>> End If
>>
>> SqlCommand1.Par ameters.Add("@L ocation", txtLocation.Tex t)
>>
>> SqlCommand1.Par ameters.Add("@S kills", txtSkills.Text)
>>
>> SqlCommand1.Par ameters.Add("@A gency", txtAgency.Text)
>>
>> 'optional fields
>>
>> If calCloseDate.Te xt <> "" Then
>>
>> SqlCommand1.Par ameters.Add("@C loseDate", Format(calClose Date.Text,
>> "General
>> Date"))
>>
>> Else
>>
>> SqlCommand1.Par ameters.Add("@C loseDate", "")
>>
>> End If
>>
>> If txtRate.Text <> "" Then
>>
>> SqlCommand1.Par ameters.Add("@R ate", Format(txtRate. Text, "Currency") )
>>
>> Else
>>
>> SqlCommand1.Par ameters.Add("@R ate", "")
>>
>> End If
>>
>> SqlCommand1.Exe cuteNonQuery()
>>
>> Catch ex As Exception
>>
>> MsgBox("Could not add record" & Chr(10) & ex.ToString())
>>
>> Exit Function
>>
>> Finally
>>
>> SqlConnection1. Close()
>>
>> End Try
>>
>>
>> "Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
>> news:OV******** ******@TK2MSFTN GP12.phx.gbl...
>> > MK,
>> >
>> > Are you maybe adding the parameter to the parameterlist more times,
>> > this
>> > is not unlikely because normally we would have seen an instrucktion
>> > as
>> >
>> > \\\
>> > SqlCommand1.Par ameters("@JobNu mber").value = xtJobRefNumber. Text
>> > SqlCommand1.Exe cuteNonQuery()
>> > ///
>> > I hope this helps,
>> >
>> > Cor
>> >
>> >
>>
>>
>
>



Nov 21 '05 #18
M K
i guess theres something about SQLConnection that was messing me up.. heres
what now works.. need to tweek it but at least i got the insert to work..
Thanks a bunch Al!

I created the connection using the data object.. keeps from having to type
in the connection string .. it does it for you..

Again.. thanks!
Mark
Dim SqlCommand2 As New OleDb.OleDbComm and

Try

OleDbConnection 1.Open()

SqlCommand2.Com mandType = CommandType.Sto redProcedure

SqlCommand2.Com mandText = "Jobs.dbo.AddAJ ob"

SqlCommand2.Con nection = OleDbConnection 1 '<< Added this line

SqlCommand2.Par ameters.Add("@J obName", "Test Job")

SqlCommand2.Par ameters.Add("@J obNumber", "123456")

SqlCommand2.Par ameters.Add("@C ontact", "Al Reid")

SqlCommand2.Par ameters.Add("@P hone", "4242502116 ")

SqlCommand2.Par ameters.Add("@F ax", "4022572410 ")

SqlCommand2.Par ameters.Add("@L ocation", "Here")

SqlCommand2.Par ameters.Add("@S kills", "DotNet")

SqlCommand2.Par ameters.Add("@A gency", "TechMe Corp")

'optional fields

SqlCommand2.Par ameters.Add("@C loseDate", CDate("09/17/2005")) '<< Converted
to a date type

SqlCommand2.Par ameters.Add("@R ate", CType("65.50", Decimal)) '<< Converted
to a numeric type

SqlCommand2.Par ameters.Add("@E mail", "myemail")

SqlCommand2.Exe cuteNonQuery()

Catch ex As Exception

MsgBox("Could not add record" & Chr(10) & ex.ToString())

Finally

OleDbConnection 1.Close()

End Try

End Sub


"Al Reid" <ar*****@reidDA SHhome.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
MK,

Perhaps you have a duplicate definition of "AddAJob" in the master
database schema. I noticed that you were not specifying the
schema.owner.sp name in the .CommandText. Try

SqlCommand1.Com mandText = "Jobs.dbo.AddAJ ob"

and see if you get the expected results. As I stated, I replicated your
schema and SP in my system and had it working using the
code I posted.

--
Al Reid
"M K" <sk*******@yaho o.com> wrote in message
news:HT******** ***********@twi ster.southeast. rr.com...
Al thanks for the great information. I have the SQLCommand And
SQLConnection objects due to the fact when i created the SP i dragged it
to
the form which created both objects for me

I thought there was a Null object but when i put in Null it didnt work
thanks for correcting my use of DBNull

I have tried the @MyDate parm this way as well and still get the same
error.
I have tried so many things i cant remember what i have tried or not but
it
always results in the same error. I even tried just inserting just the
primary key and still the same error, ive even put the parameters in code
in
the same order as below.
ALTER PROCEDURE dbo.AddAJob

(

@JobName varchar(50),

@JobNumber varchar(30),

@Contact varchar(40),

@Phone char(10),

@Fax char(10),

--@MyDate datetime = GetDate,

@Location varchar(40),

@Skills text,

@Agency varchar(40),

@CloseDate datetime,

@Rate money

)

AS

INSERT INTO [Jobs].[dbo].[Job]

(JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation,
Skills,
Agency, CloseDate, Rate)

VALUES

(@JobName, @JobNumber, @Contact, @Phone, @Fax, GetDate(), @Location,
@Skills, @Agency, @CloseDate, @Rate)

RETURN

"Al Reid" <ar*****@reidDA SHhome.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...
> Ok, let me take a shot at this. To start with, I created your database
> structure and SP in MSSQL.
>
> First, you don't show that you are associating the connection object
> with
> the command. Have you done that? Secondly, your
> procedure has 11 parameters and your code has 10, the "@MyDate" is
> missing. If you aren't going to use the parameter, remove it
> from the SP parameters and replace the "@MyDate" with GetDate in the
> Values() line.
>
> In order to get your code to work I had to create a connection object
> and
> connection string before opening it. I had too create a
> new connection object. After opening the connection, I had to
> associate
> it with the command object. After that, I had to add a
> Parameter object for the @MyDate parameter. Furthermore, I had to
> convert
> the date and money value (*.Text) to the appropriate data
> types. Having done that, I was able to insert data into the table with
> the following code:
>
> /////////////////
> Public Sub TestIt()
>
> Dim SqlConnection1 As OleDb.OleDbConn ection
> Dim SqlCommand1 As New OleDb.OleDbComm and
>
> Try
> SqlConnection1 = Connect("sa", "gobblygoop ",
> dbtDatabase.dbt SqlServer, , "(local)")
> ' Connect is a general purpose function for connecting to
> various
> database types
> ' MsAbbess, MSSQL, Oracle, CSV, Excel, ...
>
>
> SqlCommand1.Com mandType = CommandType.Sto redProcedure
>
> SqlCommand1.Com mandText = "Jobs.dbo.AddAJ ob"
>
> SqlCommand1.Con nection = SqlConnection1 '<< Added this line
>
> SqlCommand1.Par ameters.Add("@J obName", "Test Job")
>
> SqlCommand1.Par ameters.Add("@J obNumber", "123456")
>
> SqlCommand1.Par ameters.Add("@C ontact", "Al Reid")
>
> SqlCommand1.Par ameters.Add("@P hone", "4242502116 ")
>
> SqlCommand1.Par ameters.Add("@F ax", "4022572410 ")
>
> SqlCommand1.Par ameters.Add("@M yDate", CDate("09/17/2005")) '<<<
> Added this line
>
> SqlCommand1.Par ameters.Add("@L ocation", "Here")
>
> SqlCommand1.Par ameters.Add("@S kills", "DotNet")
>
> SqlCommand1.Par ameters.Add("@A gency", "TechMe Corp")
>
> 'optional fields
>
> SqlCommand1.Par ameters.Add("@C loseDate", CDate("09/17/2005"))
> '<<
> Converted to a date type
>
> SqlCommand1.Par ameters.Add("@R ate", CType("65.50", Decimal))
> '<<
> Converted to a numeric type
>
> SqlCommand1.Exe cuteNonQuery()
>
> Catch ex As Exception
>
> MsgBox("Could not add record" & Chr(10) & ex.ToString())
>
> Finally
>
> SqlConnection1. Close()
>
> End Try
>
> End Sub
> \\\\\\\\\\\\\\\ \\\\\
>
> Also, I question the code that checks if a TextBox.Text is an empty
> string:
>
>> If txtFax.Text <> "" Then
>> SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
>> Else
>> SqlCommand1.Par ameters.Add("@F ax", "")
>> End If
>
> This results in the same parameter data being sent to the SP as
>
> SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
>
> Did you mean to substitute DbNull.Value for the "" in the else clause?
>
> In any event, I was able to get your SL and modified code to function
> properly and never got an error indicating "Too many
> arguments."
>
>
> I hope this helps.
>
> --
> Al Reid
>
> "M K" <sk*******@yaho o.com> wrote in message
> news:ld******** ***********@twi ster.southeast. rr.com...
>> Did you see my first post?
>> I just tried creating a new SP within Visual Studio and I get the same
>> thing
>> Here is all the code that I am trying to run. It does work fine if i
>> run
>> the SP in Server Explorer and it updates
>> the table just fine.
>>
>> SP:
>> ALTER PROCEDURE dbo.AddAJob
>>
>> (
>>
>> @JobName varchar(50),
>>
>> @JobNumber varchar(30),
>>
>> @Contact varchar(40),
>>
>> @Phone char(10),
>>
>> @Fax char(10),
>>
>> @MyDate datetime = GetDate,
>>
>> @Location varchar(40),
>>
>> @Skills text,
>>
>> @Agency varchar(40),
>>
>> @CloseDate datetime,
>>
>> @Rate money
>>
>> )
>>
>> AS
>>
>> INSERT INTO [Jobs].[dbo].[Job]
>>
>> (JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation,
>> Skills,
>> Agency, CloseDate, Rate)
>>
>> VALUES
>>
>> (@JobName, @JobNumber, @Contact, @Phone, @Fax, @MyDate, @Location,
>> @Skills,
>> @Agency, @CloseDate, @Rate)
>>
>> RETURN
>>
>>
>> Code:
>>
>> Try
>> SqlConnection1. Open()
>>
>> 'mandatory fields
>>
>> SqlCommand1.Com mandType = CommandType.Sto redProcedure
>>
>> SqlCommand1.Com mandText = "AddAJob"
>>
>> SqlCommand1.Par ameters.Add("@J obName", txtJobName.Text )
>>
>> SqlCommand1.Par ameters.Add("@J obNumber", txtJobRefNumber .Text)
>>
>> SqlCommand1.Par ameters.Add("@C ontact", txtContact.Text )
>>
>> SqlCommand1.Par ameters.Add("@P hone", txtPhone.Text)
>>
>> If txtFax.Text <> "" Then
>>
>> SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
>>
>> Else
>>
>> SqlCommand1.Par ameters.Add("@F ax", "")
>>
>> End If
>>
>> SqlCommand1.Par ameters.Add("@L ocation", txtLocation.Tex t)
>>
>> SqlCommand1.Par ameters.Add("@S kills", txtSkills.Text)
>>
>> SqlCommand1.Par ameters.Add("@A gency", txtAgency.Text)
>>
>> 'optional fields
>>
>> If calCloseDate.Te xt <> "" Then
>>
>> SqlCommand1.Par ameters.Add("@C loseDate", Format(calClose Date.Text,
>> "General
>> Date"))
>>
>> Else
>>
>> SqlCommand1.Par ameters.Add("@C loseDate", "")
>>
>> End If
>>
>> If txtRate.Text <> "" Then
>>
>> SqlCommand1.Par ameters.Add("@R ate", Format(txtRate. Text, "Currency") )
>>
>> Else
>>
>> SqlCommand1.Par ameters.Add("@R ate", "")
>>
>> End If
>>
>> SqlCommand1.Exe cuteNonQuery()
>>
>> Catch ex As Exception
>>
>> MsgBox("Could not add record" & Chr(10) & ex.ToString())
>>
>> Exit Function
>>
>> Finally
>>
>> SqlConnection1. Close()
>>
>> End Try
>>
>>
>> "Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
>> news:OV******** ******@TK2MSFTN GP12.phx.gbl...
>> > MK,
>> >
>> > Are you maybe adding the parameter to the parameterlist more times,
>> > this
>> > is not unlikely because normally we would have seen an instrucktion
>> > as
>> >
>> > \\\
>> > SqlCommand1.Par ameters("@JobNu mber").value = xtJobRefNumber. Text
>> > SqlCommand1.Exe cuteNonQuery()
>> > ///
>> > I hope this helps,
>> >
>> > Cor
>> >
>> >
>>
>>
>
>



Nov 21 '05 #19
I would not expect it to make a difference. However, I don't have VB.Net on
the machine I am at now, so I can't try it (I won't have access to my dev
machine until Monday).

Have you tried to declare your object as I have shown? Does it work? Can
you show how you have declared the Connection and Command Objects?

"M K" <sk*******@yaho o.com> wrote in message
news:2m******** ***********@twi ster.southeast. rr.com...
Yup I've tried that too.. lol.. man this is frustrating.. You use the OLE
object where I am trying to use the SQL object. Would that be the problem?
If i cant figure this out im going to make them inline vs stored
procedure.. ugggg

"Al Reid" <ar*****@reidDA SHhome.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
MK,

Perhaps you have a duplicate definition of "AddAJob" in the master
database schema. I noticed that you were not specifying the
schema.owner.sp name in the .CommandText. Try

SqlCommand1.Com mandText = "Jobs.dbo.AddAJ ob"

and see if you get the expected results. As I stated, I replicated your
schema and SP in my system and had it working using the
code I posted.

--
Al Reid
"M K" <sk*******@yaho o.com> wrote in message
news:HT******** ***********@twi ster.southeast. rr.com...
Al thanks for the great information. I have the SQLCommand And
SQLConnection objects due to the fact when i created the SP i dragged it
to
the form which created both objects for me

I thought there was a Null object but when i put in Null it didnt work
thanks for correcting my use of DBNull

I have tried the @MyDate parm this way as well and still get the same
error.
I have tried so many things i cant remember what i have tried or not but
it
always results in the same error. I even tried just inserting just the
primary key and still the same error, ive even put the parameters in
code in
the same order as below.
ALTER PROCEDURE dbo.AddAJob

(

@JobName varchar(50),

@JobNumber varchar(30),

@Contact varchar(40),

@Phone char(10),

@Fax char(10),

--@MyDate datetime = GetDate,

@Location varchar(40),

@Skills text,

@Agency varchar(40),

@CloseDate datetime,

@Rate money

)

AS

INSERT INTO [Jobs].[dbo].[Job]

(JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation,
Skills,
Agency, CloseDate, Rate)

VALUES

(@JobName, @JobNumber, @Contact, @Phone, @Fax, GetDate(), @Location,
@Skills, @Agency, @CloseDate, @Rate)

RETURN

"Al Reid" <ar*****@reidDA SHhome.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...
> Ok, let me take a shot at this. To start with, I created your
> database
> structure and SP in MSSQL.
>
> First, you don't show that you are associating the connection object
> with
> the command. Have you done that? Secondly, your
> procedure has 11 parameters and your code has 10, the "@MyDate" is
> missing. If you aren't going to use the parameter, remove it
> from the SP parameters and replace the "@MyDate" with GetDate in the
> Values() line.
>
> In order to get your code to work I had to create a connection object
> and
> connection string before opening it. I had too create a
> new connection object. After opening the connection, I had to
> associate
> it with the command object. After that, I had to add a
> Parameter object for the @MyDate parameter. Furthermore, I had to
> convert
> the date and money value (*.Text) to the appropriate data
> types. Having done that, I was able to insert data into the table
> with
> the following code:
>
> /////////////////
> Public Sub TestIt()
>
> Dim SqlConnection1 As OleDb.OleDbConn ection
> Dim SqlCommand1 As New OleDb.OleDbComm and
>
> Try
> SqlConnection1 = Connect("sa", "gobblygoop ",
> dbtDatabase.dbt SqlServer, , "(local)")
> ' Connect is a general purpose function for connecting to
> various
> database types
> ' MsAbbess, MSSQL, Oracle, CSV, Excel, ...
>
>
> SqlCommand1.Com mandType = CommandType.Sto redProcedure
>
> SqlCommand1.Com mandText = "Jobs.dbo.AddAJ ob"
>
> SqlCommand1.Con nection = SqlConnection1 '<< Added this line
>
> SqlCommand1.Par ameters.Add("@J obName", "Test Job")
>
> SqlCommand1.Par ameters.Add("@J obNumber", "123456")
>
> SqlCommand1.Par ameters.Add("@C ontact", "Al Reid")
>
> SqlCommand1.Par ameters.Add("@P hone", "4242502116 ")
>
> SqlCommand1.Par ameters.Add("@F ax", "4022572410 ")
>
> SqlCommand1.Par ameters.Add("@M yDate", CDate("09/17/2005"))
> '<<<
> Added this line
>
> SqlCommand1.Par ameters.Add("@L ocation", "Here")
>
> SqlCommand1.Par ameters.Add("@S kills", "DotNet")
>
> SqlCommand1.Par ameters.Add("@A gency", "TechMe Corp")
>
> 'optional fields
>
> SqlCommand1.Par ameters.Add("@C loseDate", CDate("09/17/2005"))
> '<<
> Converted to a date type
>
> SqlCommand1.Par ameters.Add("@R ate", CType("65.50", Decimal))
> '<<
> Converted to a numeric type
>
> SqlCommand1.Exe cuteNonQuery()
>
> Catch ex As Exception
>
> MsgBox("Could not add record" & Chr(10) & ex.ToString())
>
> Finally
>
> SqlConnection1. Close()
>
> End Try
>
> End Sub
> \\\\\\\\\\\\\\\ \\\\\
>
> Also, I question the code that checks if a TextBox.Text is an empty
> string:
>
>> If txtFax.Text <> "" Then
>> SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
>> Else
>> SqlCommand1.Par ameters.Add("@F ax", "")
>> End If
>
> This results in the same parameter data being sent to the SP as
>
> SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
>
> Did you mean to substitute DbNull.Value for the "" in the else clause?
>
> In any event, I was able to get your SL and modified code to function
> properly and never got an error indicating "Too many
> arguments."
>
>
> I hope this helps.
>
> --
> Al Reid
>
> "M K" <sk*******@yaho o.com> wrote in message
> news:ld******** ***********@twi ster.southeast. rr.com...
>> Did you see my first post?
>> I just tried creating a new SP within Visual Studio and I get the
>> same
>> thing
>> Here is all the code that I am trying to run. It does work fine if i
>> run
>> the SP in Server Explorer and it updates
>> the table just fine.
>>
>> SP:
>> ALTER PROCEDURE dbo.AddAJob
>>
>> (
>>
>> @JobName varchar(50),
>>
>> @JobNumber varchar(30),
>>
>> @Contact varchar(40),
>>
>> @Phone char(10),
>>
>> @Fax char(10),
>>
>> @MyDate datetime = GetDate,
>>
>> @Location varchar(40),
>>
>> @Skills text,
>>
>> @Agency varchar(40),
>>
>> @CloseDate datetime,
>>
>> @Rate money
>>
>> )
>>
>> AS
>>
>> INSERT INTO [Jobs].[dbo].[Job]
>>
>> (JobName, JobRefNum, Contact, Phone, Fax, DateApplied, JobLocation,
>> Skills,
>> Agency, CloseDate, Rate)
>>
>> VALUES
>>
>> (@JobName, @JobNumber, @Contact, @Phone, @Fax, @MyDate, @Location,
>> @Skills,
>> @Agency, @CloseDate, @Rate)
>>
>> RETURN
>>
>>
>> Code:
>>
>> Try
>> SqlConnection1. Open()
>>
>> 'mandatory fields
>>
>> SqlCommand1.Com mandType = CommandType.Sto redProcedure
>>
>> SqlCommand1.Com mandText = "AddAJob"
>>
>> SqlCommand1.Par ameters.Add("@J obName", txtJobName.Text )
>>
>> SqlCommand1.Par ameters.Add("@J obNumber", txtJobRefNumber .Text)
>>
>> SqlCommand1.Par ameters.Add("@C ontact", txtContact.Text )
>>
>> SqlCommand1.Par ameters.Add("@P hone", txtPhone.Text)
>>
>> If txtFax.Text <> "" Then
>>
>> SqlCommand1.Par ameters.Add("@F ax", txtFax.Text)
>>
>> Else
>>
>> SqlCommand1.Par ameters.Add("@F ax", "")
>>
>> End If
>>
>> SqlCommand1.Par ameters.Add("@L ocation", txtLocation.Tex t)
>>
>> SqlCommand1.Par ameters.Add("@S kills", txtSkills.Text)
>>
>> SqlCommand1.Par ameters.Add("@A gency", txtAgency.Text)
>>
>> 'optional fields
>>
>> If calCloseDate.Te xt <> "" Then
>>
>> SqlCommand1.Par ameters.Add("@C loseDate", Format(calClose Date.Text,
>> "General
>> Date"))
>>
>> Else
>>
>> SqlCommand1.Par ameters.Add("@C loseDate", "")
>>
>> End If
>>
>> If txtRate.Text <> "" Then
>>
>> SqlCommand1.Par ameters.Add("@R ate", Format(txtRate. Text, "Currency") )
>>
>> Else
>>
>> SqlCommand1.Par ameters.Add("@R ate", "")
>>
>> End If
>>
>> SqlCommand1.Exe cuteNonQuery()
>>
>> Catch ex As Exception
>>
>> MsgBox("Could not add record" & Chr(10) & ex.ToString())
>>
>> Exit Function
>>
>> Finally
>>
>> SqlConnection1. Close()
>>
>> End Try
>>
>>
>> "Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
>> news:OV******** ******@TK2MSFTN GP12.phx.gbl...
>> > MK,
>> >
>> > Are you maybe adding the parameter to the parameterlist more times,
>> > this
>> > is not unlikely because normally we would have seen an instrucktion
>> > as
>> >
>> > \\\
>> > SqlCommand1.Par ameters("@JobNu mber").value = xtJobRefNumber. Text
>> > SqlCommand1.Exe cuteNonQuery()
>> > ///
>> > I hope this helps,
>> >
>> > Cor
>> >
>> >
>>
>>
>
>



Nov 21 '05 #20

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
6311
by: Boris Nikolaevich | last post by:
This is backwards of what I usually want--normally if you have a long-running ASP script, it's a good idea to check to see whether the client is still connected so you can cancel execution. However, I have a script that absolutely MUST finish one it's been started--is there a way to cause the entire script to execute, even if the client disconnects in the middle of the process? It doesn't matter if the script returns anything to the...
5
7301
by: Warren Wright | last post by:
Hi group, I have a select statement that if run against a 1 million record database directly in query analyzer takes less than 1 second. However, if I execute the select statement in a stored procedure instead, calling the stored proc from query analyzer, then it takes 12-17 seconds. Here is what I execute in Query Analyzer when bypassing the stored procedure:
1
7355
by: Private Pyle | last post by:
DB2 version 8, fixpack 5. Aix 5.1.0.0 Using C for AIX compiler. I'm having a problem where I can create stored procedures but I'm getting -444 when I call them. It's a new environment for running SP's so I wrote a very simple procedure just to make sure everything is working. Below is the db2set output for the SQLROUTINE_COMPILE_COMMAND, stored procedure text, log file, and result of a call. I'm getting an error that says function...
9
1655
by: John | last post by:
I have a single server running SQL Server 2000 sp3a, and acting as a ASP.NET webserver (.net 1.1 sp1). W2k sp4. Dual Xeon processor, 2 gigs RAM. Everything works fine, but sometimes when I execute a particular stored procedure (on server console using command line, nothing .net), my webapps will fail intermitently. Custom errors are turned on, so at this stage I can't give you error codes! But my assumption is that it's a SQL problem,...
4
5083
by: nate axtell | last post by:
In a VB .NET app I changed the text of a label then proceed to run a stored procedure which takes about 20 seconds. The label change doesn't show until after the stored procedure is finished. Is there a way to flush the label.text change right before the stored procedure call so that the text will be displayed to the user while the procedure is running? the "pseudo"code for what i have is: Label5.Visible = True Label5.Text = "Running...
7
3256
by: Jerry | last post by:
I'm trying to execute a stored procedure in a loop while paging through database table records but the stored procedure isn't running. I get the folowing error: The component 'adodb.connection' cannot be created. Apartment threaded components can only be created on pages with an <%@ Page aspcompat=true %> page directive. Can anyone tell me what I'm doing wrong? Below is my code. <%@ Import Namespace="System.Data" %> <%@ Import...
3
2937
by: =?Utf-8?B?YWJheWVy?= | last post by:
In short: I have an application using the CommittableTransaction class that works fine when run locally, but does not escalate to MSDTC when deployed to a Windows 2003 R2 server. More Specifically: I have a web service that saves data to a database. This service uses a CommittableTransaction to decide when to Commit or Abort the underlying
1
2659
by: Sureshbari | last post by:
Dear All, I have four table in database , each table contain the 5 lacs record, i have created a view on that four table using union clause. and now i am call that view form my code like select * form myview where name like '%Xya%' after that i am getting the memory fault .
0
1233
by: DR | last post by:
what are the memory caps for threads running as a CLR stored procedure executed by sql server 2005? is it limited by OS only or also by sql servers memory limits? e.g. lets say my clr stored procedure is executed by sql server 2005 then it creates 10 threads and each thread builds a giant array on the stack, is the limits of each array limited by sql server or the os? do these clr stored procedures run inside the sql server address space or...
0
9944
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11152
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10859
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9582
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7974
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7134
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5804
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
4225
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3239
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.