how to store commandobject in a string

Question

0.00/5 (No votes)

See more:

MySqlCommand  com = new MySqlCommand(" Select P.productname from productmast P join userpermission U on P.pid=U.uid innerjoin adminusermast A on U.adminuserid = A.adminuserid where ((A.adminuserid = 2) OR (A.adminuserid <> 2)) AND (U.permissionstatus = true))" , myPConn);

I write this query now i want to store it in a string SQeury = com; but its not working So how i store it .

Posted 6-Oct-11 19:42pm

Vimalrashamra

Updated 6-Oct-11 19:45pm

sravani.v

v3

Add a Solution

Comments

Mehdi Gholam 7-Oct-11 1:51am

Your query is already a string.

hitech_s 7-Oct-11 1:54am

why you want store command object ?
i think your requirement is string the text for that you can use
this
string query =commandobject.CommandText;

Vimalrashamra 7-Oct-11 2:23am

actually i want the result of the query .
I want to resultant productid

P.Salini 7-Oct-11 2:30am

use
string res=com.executenonquery();

4 solutions

Solution 1

what u want to store in a string?
You want to store the sql query or entire com object...
If u r trying to store entire com object then
I think It is not possible

Posted 6-Oct-11 19:50pm

sravani.v

Solution 2

Yes it is not possible to store cmd object in string.
if you want to get query then use this.

C#

string query=cmd.CommandText;

Posted 6-Oct-11 19:54pm

P.Salini

Comments

Vimalrashamra 7-Oct-11 2:22am

it gives me the query not the result of query

P.Salini 7-Oct-11 2:29am

to get result write this code
string result=cmd.ExecuteNonQuery();

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Muralikrishna8811 · Accepted Answer · 2011-10-06T22:47:00

Solution 3

Hi,

try this

C#

string val=com.ExecuteScalar ().tostring();

It returns the result of your query after executing in sql

All the Best

Posted 6-Oct-11 22:47pm

Muralikrishna8811

Simon_Whale · Accepted Answer · 2011-10-07T11:39:00

If I get understand you correctly you want to store your SQL command i.e. "Select * from sysobjects" in a string?

if so you have 2 ways that you can use it

C#

string SQL_String = "select * from sysobjects";
sqlconnection cn = new sqlconnection("ConnectionString") ;
cn.open(); //OPen connection object
sqlcommand cmd = new sqlcommand(SQL_String, cn);

or

C#

string SQLString = "select * from sysobjects";
sqlconnection cn = new sqlconnection("ConnectionString");
cn.open;

slqcommand cmd = new sqlcommand();
cmd.connection = cn;
cmd.commandtext = SQLString;
cmd.CommandType = CommandType.Text();