asign a parameter command2

[David]

I use the parameter command,

cmd.Parameters. Add("@var_new", OleDbType.Integ er).Value= t_var;

I receive the error,

Compiler Error Message: CS0029: Cannot implicitly convert type 'int' to
'System.Data.Ol eDb.OleDbDataRe ader'

t_var is declared as an int. So what's the problem?

[Miha Markic [MVP C#]]

Can you show us a bit more code?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Da***@web. com" <Da*********@di scussions.micro soft.com> wrote in message
news:F3******** *************** ***********@mic rosoft.com...

I use the parameter command,

cmd.Parameters. Add("@var_new", OleDbType.Integ er).Value= t_var;

I receive the error,

Compiler Error Message: CS0029: Cannot implicitly convert type 'int' to
'System.Data.Ol eDb.OleDbDataRe ader'

t_var is declared as an int. So what's the problem?

[David]

Yes, here is all the code,

string conVar = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\\data \\data;Extended Properties=dBas e 5.0";
string conVarCommand= "Select var From mob_var";

OleDbConnection cn= new OleDbConnection ();
cn.ConnectionSt ring= conVar;
cn.Open();

OleDbCommand cmd = new OleDbCommand(co nVarCommand, cn);
OleDbDataReader dtrVar = cmd.ExecuteRead er();
string VarText;
if (dtrVar.Read()) {
VarText= dtrVar["var"].ToString();
}
int t_var;
t_var = Convert.ToInt32 (dtrVar["var"]);
t_var += 1;

conVarCommand= "Update mob_var Set var=@var_new";
cmd = new OleDbCommand(co nVarCommand, cn);
cmd.Parameters. Add("@var_new", OleDbType.Integ er).Value= t_var;
dtrVar = cmd.ExecuteNonQ uery();
Response.Write( "Var-"+t_var);
cn.Close();

"Miha Markic [MVP C#]" wrote:

Can you show us a bit more code?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Da***@web. com" <Da*********@di scussions.micro soft.com> wrote in message
news:F3******** *************** ***********@mic rosoft.com...

I use the parameter command,

cmd.Parameters. Add("@var_new", OleDbType.Integ er).Value= t_var;

I receive the error,

Compiler Error Message: CS0029: Cannot implicitly convert type 'int' to
'System.Data.Ol eDb.OleDbDataRe ader'

t_var is declared as an int. So what's the problem?

[Miha Markic [MVP C#]]

Hi David,

First thing is that you really have to Close reader before using another
reader with the same connection.
The other thing is, that you should replace parameter name with question
mark:
conVarCommand= "Update mob_var Set var=@var_new";
change to
conVarCommand= "Update mob_var Set var=?";

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Da***@web. com" <Da*********@di scussions.micro soft.com> wrote in message
news:98******** *************** ***********@mic rosoft.com...

Yes, here is all the code,

string conVar = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\\data \\data;Extended Properties=dBas e 5.0";
string conVarCommand= "Select var From mob_var";

OleDbConnection cn= new OleDbConnection ();
cn.ConnectionSt ring= conVar;
cn.Open();

OleDbCommand cmd = new OleDbCommand(co nVarCommand, cn);
OleDbDataReader dtrVar = cmd.ExecuteRead er();
string VarText;
if (dtrVar.Read()) {
VarText= dtrVar["var"].ToString();
}
int t_var;
t_var = Convert.ToInt32 (dtrVar["var"]);
t_var += 1;

conVarCommand= "Update mob_var Set var=@var_new";
cmd = new OleDbCommand(co nVarCommand, cn);
cmd.Parameters. Add("@var_new", OleDbType.Integ er).Value= t_var;
dtrVar = cmd.ExecuteNonQ uery();
Response.Write( "Var-"+t_var);
cn.Close();

"Miha Markic [MVP C#]" wrote:

Can you show us a bit more code?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Da***@web. com" <Da*********@di scussions.micro soft.com> wrote in message
news:F3******** *************** ***********@mic rosoft.com...

>I use the parameter command,
>
> cmd.Parameters. Add("@var_new", OleDbType.Integ er).Value= t_var;
>
> I receive the error,
>
> Compiler Error Message: CS0029: Cannot implicitly convert type 'int' to
> 'System.Data.Ol eDb.OleDbDataRe ader'
>
> t_var is declared as an int. So what's the problem?

[David]

After making the suggested changes I received the same error. Then I tried
totally closing the connection and then reopening it, and I received the same
error.

"Miha Markic [MVP C#]" wrote:

Hi David,

First thing is that you really have to Close reader before using another
reader with the same connection.
The other thing is, that you should replace parameter name with question
mark:
conVarCommand= "Update mob_var Set var=@var_new";
change to
conVarCommand= "Update mob_var Set var=?";

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Da***@web. com" <Da*********@di scussions.micro soft.com> wrote in message
news:98******** *************** ***********@mic rosoft.com...

Yes, here is all the code,

string conVar = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\\data \\data;Extended Properties=dBas e 5.0";
string conVarCommand= "Select var From mob_var";

OleDbConnection cn= new OleDbConnection ();
cn.ConnectionSt ring= conVar;
cn.Open();

OleDbCommand cmd = new OleDbCommand(co nVarCommand, cn);
OleDbDataReader dtrVar = cmd.ExecuteRead er();
string VarText;
if (dtrVar.Read()) {
VarText= dtrVar["var"].ToString();
}
int t_var;
t_var = Convert.ToInt32 (dtrVar["var"]);
t_var += 1;

conVarCommand= "Update mob_var Set var=@var_new";
cmd = new OleDbCommand(co nVarCommand, cn);
cmd.Parameters. Add("@var_new", OleDbType.Integ er).Value= t_var;
dtrVar = cmd.ExecuteNonQ uery();
Response.Write( "Var-"+t_var);
cn.Close();

"Miha Markic [MVP C#]" wrote:

Can you show us a bit more code?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Da***@web. com" <Da*********@di scussions.micro soft.com> wrote in message
news:F3******** *************** ***********@mic rosoft.com...
>I use the parameter command,
>
> cmd.Parameters. Add("@var_new", OleDbType.Integ er).Value= t_var;
>
> I receive the error,
>
> Compiler Error Message: CS0029: Cannot implicitly convert type 'int' to
> 'System.Data.Ol eDb.OleDbDataRe ader'
>
> t_var is declared as an int. So what's the problem?