How to store a query in a variable?

Question

0.00/5 (No votes)

See more:

Hi programmers!

I know how to connect database and execute queries in ASP.Net. But I do not know on how to store the result of a query in a variable. Like for example, I would like to store the result of this query:

C#

SqlCommand cmd = new SqlCommand("SELECT Milestone_Code FROM tblMilestone WHERE MIlestone_Name='"+DropdownList1.SelectedItem+"'", amicassa);

in string res. How to do that?
PLEASE HELP ME!!!

Posted 20-Jul-14 18:19pm

DarkDreamer08

Updated 20-Jul-14 20:11pm

King Fisher

v2

Add a Solution

3 solutions

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)

*Suvabrata Roy* · Answer 1 · 2014-07-20T18:32:00

Hi,

SQL Clients Full ref : http://msdn.microsoft.com/en-us/library/system.data.sqlclient(v=vs.110).aspx[^]

SQL Command Details : http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand(v=vs.110).aspx[^]

2nd link will demonstrate how to fetch data and set it in a variable.

1st will help you to learn other prospective of SQL Client

Abhinav S · Answer 2 · 2014-07-20T18:39:00

Solution 2

Execute this query against a connection.
Then define a data reader and store results using this reader.
Refer
Retrieving Data Using a DataReader[^]
Retrieving Data Using a C# .NET DataReader [^]

Posted 20-Jul-14 18:39pm

Abhinav S

Updated 20-Jul-14 18:40pm

v2

*dan!sh* · Answer 3 · 2014-07-20T19:03:00

You can make use of ExecuteScalar if your query returns one value. For more than one, you can make use of ExecuteReader and store values from reader into your own object.

As a side note, will your code work? What does SelectedItem hold? You may have to change it to SelectedValue or SelectedText based on your needs.

How to store a query in a variable?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0