使用下拉列表将数据提取到表单中 [英] Fetching Data into form using Drop down list

问题描述

大家好，



我是初学者并且学习ASP.NET我已经制作了下拉列表，它工作正常。但是反对那个ID我想显示其他数据。

我在表格中的字段是ddldate，Ref_No，Client_Coa。



我正在制作功能我是初学者我想显示这些字段agaist选择的ID这是IMP_CASE_NUMBER。我没有得到如何分配这些值以获取上面提到的FORM值。

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"));

推荐答案

dt.tables [0] .rows [数据表行名] .tostring（）;

dt.tables[0].rows["data table row name"].tostring();

这篇关于使用下拉列表将数据提取到表单中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！