C＃code在asp.net在下拉列表中显示数据库值 [英] c# code in asp.net for displaying database values in dropdown list

问题描述

大家好我试着在我的下拉列表中显示的数据库值，我创建存储过程，并试图通过调用后面我的code该存储过程来获取值，但即时通讯无法显示。请帮我出

 保护无效DrpClientName_SelectedIndexChanged（对象发件人，EventArgs的发送）
   {        MTMSDTO objc =新MTMSDTO（）;
        {
            objc.ClientName = Convert.ToString（会话[CLIENTNAME]）;
            数据集ClientN = obj.GetClientList（）;
            数据视图Projview =新的数据视图（）;
            Projview.Table = ClientN.Tables [0];
            DrpClientName.DataSource = Projview;
            DrpClientName.DataBind（）;
        }
    }
 

解决方案

不要写code在下拉菜单中选择指标更改事件写在一个函数并调用它的页面加载事件

您了设置DataTextField和DatavalueField

  objc.ClientName = Convert.ToString（会话[CLIENTNAME]）;
            数据集ClientN = obj.GetClientList（）;
            数据视图Projview =新的数据视图（）;
            Projview.Table = ClientN.Tables [0];
            DrpClientName.DataSource = Projview;
            DrpClientName.DataTextField =说明;
            DrpClientName.DataValueField =ID;
            DrpClientName.DataBind（）;
 

hello everybody im trying to display the database values in my dropdown list, i have created stored procedure for it and trying to get the values by calling that stored procedure in my code behind but im not able to display it. please help me out

   protected void DrpClientName_SelectedIndexChanged(object sender, EventArgs e)   
   {

        MTMSDTO objc = new MTMSDTO();
        {
            objc.ClientName = Convert.ToString(Session["ClientName"]);
            DataSet ClientN = obj.GetClientList();
            DataView Projview = new DataView();
            Projview.Table = ClientN.Tables[0];
            DrpClientName.DataSource = Projview;
            DrpClientName.DataBind();
        }
    } 

解决方案

Dont write the code in dropdowns selected index changed event write it in a function and call it in pageload event

you have to set the DataTextField and DatavalueField

objc.ClientName = Convert.ToString(Session["ClientName"]);
            DataSet ClientN = obj.GetClientList();
            DataView Projview = new DataView();
            Projview.Table = ClientN.Tables[0];
            DrpClientName.DataSource = Projview;
            DrpClientName.DataTextField="Description";
            DrpClientName.DataValueField="ID";
            DrpClientName.DataBind();

这篇关于C＃code在asp.net在下拉列表中显示数据库值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！