sql query to work with asp.net c#

[Ishan Halarnkar]

I have a database which has a table known as 'casetype' there are two fields namely 'sr' and 'skey', sr contains numeric value whereas 'skey' contains text value.

I have a DropdownList in asp.net and i have bound the 'skey' to it so it shows all the values that are there in 'skey' once dropped down. the query for it is

SELECT testcase.casetype.skey FROM testcase.casetype

what i want is,once user selects a value from dropdownlist corresponding value in 'sr' should be behind it.

e.g when user selects 'a' the corresponding value in the database table say '8' should be present behind.\

In short user should see a text value but a programmer will work on numeric digits.

How can i do it? i want the sql query that connects the table casetype 'skey' 'sr' i want to print numeric digit once a user select a input.

[abhinavpratap]

You should modify your sql query to
SELECT testcase.casetp e.sr,testcase.c asetype.skey FROM testcase.casety pe

Now on your aspx.cs page where you want to bind your dropdownlist as :

DropDownList1.Datasource = ds.Tables[0];
DropDownList1.DataTextField = "Field Name of the table to display text"; //e.g: DropDownList1.DataTextField = "skey";
DropDownList1.DataValueField = "Field Name of the table to set the value";  //e.g: DropDownList1.DataValueField = "sr";
DropDownList1.DataBind();

Happy Coding

[Ishan Halarnkar]

Thank you. That solved my problem.

[NeoPa]

I can't help with the ASP part, but as your question specifically asks for the SQL, you would need :

SELECT testcase.casetype.skey
     , testcase.casetype.sr
FROM   testcase.casetype

How you design your control is another matter (which you will need to determine).

[Jose Peguero]

Answer

first you must fill a dataset with your wanted data:

(SELECT testcase.casetype.skey 
     , testcase.casetype.sr 
FROM   testcase.casetype 
)

then bind your dropdownlist with the dataset

Dropdownlist1.datasource = MyDataset;
Dropdownlist1.DataTextField = "skey";
Dropdownlist1.DataValueField = "sr";
Dropdownlist1.DataBind();

then you can get the value of the selected value this way:

string Value = Dropdownlist1.SelectedValue