如何在来自数据库的下拉列表中设置默认值 [英] how to set default value in dropdownlist which is comes from database

问题描述

亲爱的先生

我有一个下拉列表，我想要一个默认值以及asp.net中的其他值

在此先感谢

dear sir

i have a dropdownlist i want to a default value and also other value in asp.net

thanks in advance

推荐答案

UploadSP spUpload =新的UploadSP();
ddlStudent.DataSource = spUpload.StudenntNameViewForUploadingFile(Decimal.Parse(ddlClass.SelectedValue.ToString())，ddlDivision.Text);
ddlStudent.DataTextField ="studentName";
ddlStudent.DataValueField ="studentId";
ddlStudent.DataBind();
ddlStudent.Items.Insert(0，"--Select-");

Hi,
UploadSP spUpload = new UploadSP();
ddlStudent.DataSource = spUpload.StudenntNameViewForUploadingFile(Decimal.Parse(ddlClass.SelectedValue.ToString()),ddlDivision.Text);
ddlStudent.DataTextField = "studentName";
ddlStudent.DataValueField = "studentId";
ddlStudent.DataBind();
ddlStudent.Items.Insert(0, "--Select--");

嗨Dinesh

下面的代码将解决您的查询

DataRow dr = ds.Tables [0] .NewRow();
dr ["CityName"] =选择城市";
dr ["CityID"] ="0";
ds.Tables [0] .Rows.InsertAt(dr，0);
Dropdownlist.DataTextField =城市名称";
Dropdownlist.DataValueField ="CityID";
Dropdownlist.DataSource = ds;
Dropdownlist.DataBind();

Hi Dinesh

below Code will you to resolve your query

DataRow dr = ds.Tables[0].NewRow();
dr["CityName"] = "Select City";
dr["CityID"] = "0";
ds.Tables[0].Rows.InsertAt(dr, 0);
Dropdownlist.DataTextField = "CityName";
Dropdownlist.DataValueField = "CityID";
Dropdownlist.DataSource = ds;
Dropdownlist.DataBind();

您用来标识默认列的数据表字段是什么

What is your datatable Fields to Identify Default Columns

这篇关于如何在来自数据库的下拉列表中设置默认值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！