how to store value in to the string variable from query

Question

0.00/5 (No votes)

See more:

oleDbConnection cn;
string name;
string sirname;
string query="select s_name,s_sirname from record_table";
oleDbCommand cmd = new OleDbCommand(query, cn);

//I want to save these selected value in name and sirname.

Posted 25-Feb-14 0:17am

Rajkumar_007

Add a Solution

6 solutions

Solution 2

You have to execute your command, than by using a reader you should read the results and stored in your variables.

C#

IDataReader reader = null;
//
try
{
    reader = cmd.ExecuteReader();
    //
    if (reader.Read())
    {
      name = (string)reader["s_name"];
      sirname = (string)reader["s_sirname"];

    }
}
catch (SqlException exception)
{
    // TO DO!
}
finally
{
    if (reader != null)
        reader.Close();

}

Posted 25-Feb-14 0:32am

Raul Iloc

Updated 25-Feb-14 0:55am

v2

Comments

Raul Iloc 26-Feb-14 3:16am

Why did not accept my solution?
PS: I gave you a solution that I used in many projects and that also manage the possible exceptions.

Solution 3

you can use dataset like below way
string name;
string sirname;
string query="select s_name,s_sirname from record_table";
oleDbCommand cmd = new OleDbCommand(query, cn);
DataSet ds = new DataSet();

using (OleDbConnection connection = new OleDbConnection(connectionString))
using (OleDbCommand command = new OleDbCommand(query, connection))
using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
{
adapter.Fill(ds);
}
name=ds.tables[0].rows[0]["s_name"].tostring();
sirname=ds.tables[0].rows[0]["s_sirname"].tostring();

Posted 25-Feb-14 0:33am

JatinKhimani

Solution 4

you can either use datareader or dataset to sovle your issue. some thing like below

C#

string query="select s_name,s_sirname from record_table";
oleDbCommand cmd = new OleDbCommand(query, cn);
oleDbAdepter Da = new oleDbAdepter(cmd);
dataset ds = new dataset();
cn.open();
da.fill(ds);
cn.close();

if(ds!=null && ds.tables[0].rows.count>0)
{
name = ds.tables[0].rows[0]["name"].tostring();
sirname =ds.tables[0].rows[0]["sirname "].tostring(); 
}

Posted 25-Feb-14 0:35am

ravikhoda

Solution 5

I would suggest you to read this:
How to: Create and Execute an SQL Statement that Returns a Single Value[^]
How to: Create and Execute an SQL Statement that Returns Rows[^]
How to: Create and Execute an SQL Statement that Returns No Value[^]

Posted 25-Feb-14 0:40am

Maciej Los

Solution 1

C#

SqlDataReader rdr = null;
oleDbConnection cn;
string name;
string sirname;
string query="select s_name,s_sirname from record_table";
oleDbCommand cmd = new OleDbCommand(query, cn);
rdr = cmd.ExecuteReader();

while(rdr.Read())
                {
                   string name=rdr.getString(0);
                 string sirname=rdr.getString(1);  // Store this value to a                                collection ...this exit from this loop after getting all items .so store to collection or do some other things

                }</pre>

Posted 25-Feb-14 0:29am

k07

Updated 25-Feb-14 0:54am

v2

Comments

Rajkumar_007 25-Feb-14 6:38am

It's not working, name and sirname value always null.

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)

Sanket Saxena · Accepted Answer · 2014-02-25T00:51:00

Solution 6

C#

SqlDataReader rdr = null;
oleDbConnection cn;
string name;
string sirname;
string query="select s_name,s_sirname from record_table";
oleDbCommand cmd = new OleDbCommand(query, cn);
rdr = cmd.ExecuteReader();


Try Sol: 

while(rdr.Read())
                {
name = (string)rdr["s_name"];
sirname = (string)rdr["s_sirname"];
                }

Posted 25-Feb-14 0:51am

Sanket Saxena

Updated 25-Feb-14 0:53am

v3

Comments

Rajkumar_007 25-Feb-14 7:04am

It gives an Error like "No value given for one or more required parameters."

Sanket Saxena 25-Feb-14 7:08am

Dear this error comes from rdr = cmd.ExecuteReader(); (execution of your select query). Debug the code and check the query what it returns.

Rajkumar_007 25-Feb-14 7:30am

Thank u Sir.... :)