asked on 1/12/2018

Query question

Hi,

I am trying to run a query in code behind, because the query is simple, I do not want to create a sp just for that. Here is my code. It runs well without a parameter.

        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ToString());

        SqlCommand cmd = new SqlCommand("SELECT CategoryName from Category ORDER BY CategoryName="  + Session["sCMID"], con);

        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable table = new DataTable();
        da.Fill(table);

        ContactName.DataSource = table;
        ContactName.DataValueField = "CategoryName";
        ContactName.DataTextField = "CategoryName";
        ContactName.DataBind();


        con.Close();

Open in new window

The result will be loaded into a dropdown list. thAnks

Last Comment

mcrmg

1/12/2018

SOLUTION

Dustin Saunders

1/12/2018

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

kaufmed

1/12/2018

What is the question here?

mcrmg

1/12/2018

ASKER

I need help with passing the parameter. thanks

mcrmg

1/12/2018

ASKER

The code works fine

SqlCommand cmd = new SqlCommand("SELECT CategoryName from Category ORDER BY CategoryName=", con);

But when I try to add parameter, it does not work

SqlCommand cmd = new SqlCommand("SELECT CategoryName from Category ORDER BY CategoryName=" + Session["sCMID"], con);

thanks

ASKER CERTIFIED SOLUTION

johnsone

1/12/2018

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

SOLUTION

Dustin Saunders

1/12/2018

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.