Fetching Data into form using Drop down list

See more:

ASP.NET

Hi All,

I am beginner and learning ASP.NET I had made Drop Down list which is working fine. But Against That ID I want to display other data.
My Fields in Forms are ddldate, Ref_No, Client_Coa.

I am making function i am beginner i want to display these field agaist the selected ID Which is IMP_CASE_NUMBER. I am not getting how to assign those values to fetch into FORM Values which I mention above.

protected void IMPCASE()
        {
            string conn = ""

            OracleConnection ora = new OracleConnection(conn);
            ora.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SID=amir)));User Id=newami;Password=newami;";


            string qry = "select IMP_CASE_Date,IMP_CASE_REF,CLIENT_COA from IMP_CASE_Header where Loc_ID = 'HO' and IMP_CASE_NUMBER ="'+ ddlimpcase + '";
            OracleCommand oracmd = new OracleCommand(qry, ora);
            DataTable impcase = new DataTable();
            OracleDataAdapter da = new OracleDataAdapter(qry, ora);
            da.Fill(impcase);
            ddlimpcase.DataSource = impcase;
            ddldate.DataTextField = "IMP_CASE_DATE";
            ddlimpcase.DataBind();
            ddlimpcase.Items.Insert(0, new ListItem("Select", "0"));