Problem with AddWithValue

[SLIMSHIM]

Hi,
I"m trying to insert into a database with no adapter .(AddWithValue) I get
an error when
executing ExcecuteNonQuery . Parameter pName has no default value. what am I
doing wrong ?

using (OleDbConnection conn = new OleDbConnection(

testacc.Properties.Settings.Default.mytestConnecti onString))
{

using (OleDbCommand comm = new OleDbCommand(
"INSERT INTO phonebook (name, phonenum) VALUES
(pName, pPhonenum)", conn))
{
comm.Parameters.Add("pName",
OleDbType.VarChar).SourceColumn = "name";

comm.Parameters.Add("pPhonenum",
OleDbType.VarChar).SourceColumn = "phonenum";
comm.Parameters.AddWithValue("pName", "John Doe");
comm.Parameters.AddWithValue("pPhonenum",
"555-555-1212");
conn.Open();
comm.ExecuteNonQuery();

}

[Cor Ligthert [MVP]]

Slimshim,

If I see it well, than you only need to set the value.
The AddWithValue is to add a parameteritem to the parametercollection with a
value.
(and than use an indexer to tell which parameter from the collection).

http://msdn2.microsoft.com/en-us/library/6h86wyk1.aspx

Now you are in my idea trying to do that 4 times.

Cor

"SLIMSHIM" <SL******@discussions.microsoft.comschreef in bericht
news:68**********************************@microsof t.com...

Hi,
I"m trying to insert into a database with no adapter .(AddWithValue) I get
an error when
executing ExcecuteNonQuery . Parameter pName has no default value. what am
I
doing wrong ?

using (OleDbConnection conn = new OleDbConnection(

testacc.Properties.Settings.Default.mytestConnecti onString))
{

using (OleDbCommand comm = new OleDbCommand(
"INSERT INTO phonebook (name, phonenum) VALUES
(pName, pPhonenum)", conn))
{
comm.Parameters.Add("pName",
OleDbType.VarChar).SourceColumn = "name";

comm.Parameters.Add("pPhonenum",
OleDbType.VarChar).SourceColumn = "phonenum";
comm.Parameters.AddWithValue("pName", "John Doe");
comm.Parameters.AddWithValue("pPhonenum",
"555-555-1212");
conn.Open();
comm.ExecuteNonQuery();

}

[SLIMSHIM]

I appreciate your help.
I still don't understand. Do I not use the .Add to set up the fields ?
Or am I missing a third step ?

I appoligize for being confused ...

"Cor Ligthert [MVP]" wrote:

Slimshim,

If I see it well, than you only need to set the value.
The AddWithValue is to add a parameteritem to the parametercollection with a
value.
(and than use an indexer to tell which parameter from the collection).

http://msdn2.microsoft.com/en-us/library/6h86wyk1.aspx

Now you are in my idea trying to do that 4 times.

Cor

"SLIMSHIM" <SL******@discussions.microsoft.comschreef in bericht
news:68**********************************@microsof t.com...

Hi,
I"m trying to insert into a database with no adapter .(AddWithValue) I get
an error when
executing ExcecuteNonQuery . Parameter pName has no default value. what am
I
doing wrong ?

using (OleDbConnection conn = new OleDbConnection(

testacc.Properties.Settings.Default.mytestConnecti onString))
{

using (OleDbCommand comm = new OleDbCommand(
"INSERT INTO phonebook (name, phonenum) VALUES
(pName, pPhonenum)", conn))
{
comm.Parameters.Add("pName",
OleDbType.VarChar).SourceColumn = "name";

comm.Parameters.Add("pPhonenum",
OleDbType.VarChar).SourceColumn = "phonenum";
comm.Parameters.AddWithValue("pName", "John Doe");
comm.Parameters.AddWithValue("pPhonenum",
"555-555-1212");
conn.Open();
comm.ExecuteNonQuery();

}

[SLIMSHIM]

I figured out how it's done.
string tname = "simon";
string tphonenum = "555-555-1212";

comm.Parameters.Add("pName", OleDbType.VarChar, tname.Length,"name").Value =
tname;

comm.Parameters.Add("pPhonenum",
OleDbType.VarChar,tphonenum.Length,"phonenum").Val ue = tphonenum;
this will do the trick.

"SLIMSHIM" wrote:

I appreciate your help.
I still don't understand. Do I not use the .Add to set up the fields ?
Or am I missing a third step ?

I appoligize for being confused ...

"Cor Ligthert [MVP]" wrote:

Slimshim,

If I see it well, than you only need to set the value.
The AddWithValue is to add a parameteritem to the parametercollection with a
value.
(and than use an indexer to tell which parameter from the collection).

http://msdn2.microsoft.com/en-us/library/6h86wyk1.aspx

Now you are in my idea trying to do that 4 times.

Cor

"SLIMSHIM" <SL******@discussions.microsoft.comschreef in bericht
news:68**********************************@microsof t.com...

Hi,
I"m trying to insert into a database with no adapter .(AddWithValue) I get
an error when
executing ExcecuteNonQuery . Parameter pName has no default value. what am
I
doing wrong ?
>
using (OleDbConnection conn = new OleDbConnection(
>
testacc.Properties.Settings.Default.mytestConnecti onString))
{
>
using (OleDbCommand comm = new OleDbCommand(
"INSERT INTO phonebook (name, phonenum) VALUES
(pName, pPhonenum)", conn))
{
comm.Parameters.Add("pName",
OleDbType.VarChar).SourceColumn = "name";
>
comm.Parameters.Add("pPhonenum",
OleDbType.VarChar).SourceColumn = "phonenum";
comm.Parameters.AddWithValue("pName", "John Doe");
comm.Parameters.AddWithValue("pPhonenum",
"555-555-1212");
conn.Open();
comm.ExecuteNonQuery();
>
}
>

[Dave Sexton]

Hi,

The "Add" method adds the parameter and the "AddWithValue" method adds the
parameter along with its value, simultaneously. You don't need to use both
"Add" and "AddWithValue". Use one or the other for each parameter.

comm.Parameters.AddWithValue("pName", tname);
comm.Parameters.AddWithValue("phonenum", tphonenum);

--
Dave Sexton

"SLIMSHIM" <SL******@discussions.microsoft.comwrote in message
news:46**********************************@microsof t.com...

>I figured out how it's done.
string tname = "simon";
string tphonenum = "555-555-1212";

comm.Parameters.Add("pName", OleDbType.VarChar, tname.Length,"name").Value =
tname;

comm.Parameters.Add("pPhonenum",
OleDbType.VarChar,tphonenum.Length,"phonenum").Val ue = tphonenum;
this will do the trick.

"SLIMSHIM" wrote:

>I appreciate your help.
I still don't understand. Do I not use the .Add to set up the fields ?
Or am I missing a third step ?

I appoligize for being confused ...

"Cor Ligthert [MVP]" wrote:

Slimshim,

If I see it well, than you only need to set the value.
The AddWithValue is to add a parameteritem to the parametercollection
with a
value.
(and than use an indexer to tell which parameter from the collection).

http://msdn2.microsoft.com/en-us/library/6h86wyk1.aspx

Now you are in my idea trying to do that 4 times.

Cor

"SLIMSHIM" <SL******@discussions.microsoft.comschreef in bericht
news:68**********************************@microsof t.com...
Hi,
I"m trying to insert into a database with no adapter .(AddWithValue) I
get
an error when
executing ExcecuteNonQuery . Parameter pName has no default value. what
am
I
doing wrong ?

using (OleDbConnection conn = new OleDbConnection(

testacc.Properties.Settings.Default.mytestConnecti onString))
{

using (OleDbCommand comm = new OleDbCommand(
"INSERT INTO phonebook (name, phonenum) VALUES
(pName, pPhonenum)", conn))
{
comm.Parameters.Add("pName",
OleDbType.VarChar).SourceColumn = "name";

comm.Parameters.Add("pPhonenum",
OleDbType.VarChar).SourceColumn = "phonenum";
comm.Parameters.AddWithValue("pName", "John Doe");
comm.Parameters.AddWithValue("pPhonenum",
"555-555-1212");
conn.Open();
comm.ExecuteNonQuery();

}

[Cor Ligthert [MVP]]

Hi,

The OleDB documentation on MSDN and the notations itself areconfusing.

comm.Parameters.Add("?", OleDbType.VarChar);
comm.Parameters[0]].Value = tphonenum;

is enough,

As Dave wrote you can do it as well with the AddWithValue which replaces the
overloaded Add from 1.x in version 2.0. The caveat at that, is that you can
only do it once (because it is a collection), which is seldom what is
wanted.

Be aware that this is fonfusing because this is where SQLClient and OleDb
have different notations but on many places is in MSDN taken the SQLClient
notation at OleDb. Which does not go wrong by the way, but OleDb has AFAIK
no named parameters which are working. (You can type everything there).

I hope this gives some ideas

Cor
comm.Parameters.Add("pPhonenum",
OleDbType.VarChar,tphonenum.Length,"phonenum").Val ue = tphonenum;
"SLIMSHIM" <SL******@discussions.microsoft.comschreef in bericht
news:46**********************************@microsof t.com...

>I figured out how it's done.
string tname = "simon";
string tphonenum = "555-555-1212";

comm.Parameters.Add("pName", OleDbType.VarChar, tname.Length,"name").Value
=
tname;

comm.Parameters.Add("pPhonenum",
OleDbType.VarChar,tphonenum.Length,"phonenum").Val ue = tphonenum;
this will do the trick.

"SLIMSHIM" wrote:

>I appreciate your help.
I still don't understand. Do I not use the .Add to set up the fields ?
Or am I missing a third step ?

I appoligize for being confused ...

"Cor Ligthert [MVP]" wrote:

Slimshim,

If I see it well, than you only need to set the value.
The AddWithValue is to add a parameteritem to the parametercollection
with a
value.
(and than use an indexer to tell which parameter from the collection).

http://msdn2.microsoft.com/en-us/library/6h86wyk1.aspx

Now you are in my idea trying to do that 4 times.

Cor

"SLIMSHIM" <SL******@discussions.microsoft.comschreef in bericht
news:68**********************************@microsof t.com...
Hi,
I"m trying to insert into a database with no adapter .(AddWithValue)
I get
an error when
executing ExcecuteNonQuery . Parameter pName has no default value.
what am
I
doing wrong ?

using (OleDbConnection conn = new OleDbConnection(

testacc.Properties.Settings.Default.mytestConnecti onString))
{

using (OleDbCommand comm = new OleDbCommand(
"INSERT INTO phonebook (name, phonenum) VALUES
(pName, pPhonenum)", conn))
{
comm.Parameters.Add("pName",
OleDbType.VarChar).SourceColumn = "name";

comm.Parameters.Add("pPhonenum",
OleDbType.VarChar).SourceColumn = "phonenum";
comm.Parameters.AddWithValue("pName", "John
Doe");
comm.Parameters.AddWithValue("pPhonenum",
"555-555-1212");
conn.Open();
comm.ExecuteNonQuery();

}

[Rad]

Also you need to be clear which provider you are using. Some
providers, e.g. Sybase ASA will throw an exception if you use named
parameters.

On Mon, 13 Nov 2006 05:42:30 +0100, "Cor Ligthert [MVP]"
<no************@planet.nlwrote:

>Hi,

The OleDB documentation on MSDN and the notations itself areconfusing.

comm.Parameters.Add("?", OleDbType.VarChar);
comm.Parameters[0]].Value = tphonenum;

is enough,

As Dave wrote you can do it as well with the AddWithValue which replaces the
overloaded Add from 1.x in version 2.0. The caveat at that, is that you can
only do it once (because it is a collection), which is seldom what is
wanted.

Be aware that this is fonfusing because this is where SQLClient and OleDb
have different notations but on many places is in MSDN taken the SQLClient
notation at OleDb. Which does not go wrong by the way, but OleDb has AFAIK
no named parameters which are working. (You can type everything there).

I hope this gives some ideas

Cor
comm.Parameters.Add("pPhonenum",
OleDbType.VarChar,tphonenum.Length,"phonenum").Va lue = tphonenum;
"SLIMSHIM" <SL******@discussions.microsoft.comschreef in bericht
news:46**********************************@microso ft.com...

>>I figured out how it's done.
string tname = "simon";
string tphonenum = "555-555-1212";

comm.Parameters.Add("pName", OleDbType.VarChar, tname.Length,"name").Value
=
tname;

comm.Parameters.Add("pPhonenum",
OleDbType.VarChar,tphonenum.Length,"phonenum").Va lue = tphonenum;
this will do the trick.

"SLIMSHIM" wrote:

>>I appreciate your help.
I still don't understand. Do I not use the .Add to set up the fields ?
Or am I missing a third step ?

I appoligize for being confused ...

"Cor Ligthert [MVP]" wrote:

Slimshim,

If I see it well, than you only need to set the value.
The AddWithValue is to add a parameteritem to the parametercollection
with a
value.
(and than use an indexer to tell which parameter from the collection).

http://msdn2.microsoft.com/en-us/library/6h86wyk1.aspx

Now you are in my idea trying to do that 4 times.

Cor

"SLIMSHIM" <SL******@discussions.microsoft.comschreef in bericht
news:68**********************************@microso ft.com...
Hi,
I"m trying to insert into a database with no adapter .(AddWithValue)
I get
an error when
executing ExcecuteNonQuery . Parameter pName has no default value.
what am
I
doing wrong ?

using (OleDbConnection conn = new OleDbConnection(

testacc.Properties.Settings.Default.mytestConnect ionString))
{

using (OleDbCommand comm = new OleDbCommand(
"INSERT INTO phonebook (name, phonenum) VALUES
(pName, pPhonenum)", conn))
{
comm.Parameters.Add("pName",
OleDbType.VarChar).SourceColumn = "name";

comm.Parameters.Add("pPhonenum",
OleDbType.VarChar).SourceColumn = "phonenum";
comm.Parameters.AddWithValue("pName", "John
Doe");
comm.Parameters.AddWithValue("pPhonenum",
"555-555-1212");
conn.Open();
comm.ExecuteNonQuery();

}