Question

GridView编辑模式下 DropDownList绑定值问题

GridView有一列是命令列
就是编辑更新取消
点编辑的时候 有三个DropDownList需要绑定
怎么绑定啊

Answer 1

<div>
<asp:DropDownList ID="dlPro" runat="server">
</asp:DropDownList>
省(市)
<asp:DropDownList ID="dlArea" runat="server" Enabled="False">
<asp:ListItem Value="0">-请选择-</asp:ListItem>
</asp:DropDownList>
市(区)
<asp:DropDownList ID="dlBar" runat="server" Enabled="False">
<asp:ListItem Value="0">-请选择-</asp:ListItem>
</asp:DropDownList>
订购店
<asp:HiddenField ID="hideBar" runat="server" EnableViewState="true" Value="0" />
</div>

jquery代码：
<script type="text/javascript">
$(function () {
var dlArea = document.getElementById("<%=thisID%>_dlArea");
var dlBar = document.getElementById("<%=thisID%>_dlBar");
// 根据省市 绑定 地区：
$("#<%=thisID%>_dlPro").change(function () {
if (this.value == 0) {
dlArea.selectedIndex = 0;
dlArea.disabled = "disabled";
dlBar.selectedIndex = 0;
dlBar.disabled = "disabled";
}
else {
dlBar.selectedIndex = 0;
dlBar.disabled = "disabled";

// 移除原来地区
$("#<%=thisID%>_dlArea option:gt(0)").remove();
// 增加新地区
AddDlArea(this.value);
}
})
// 根据地区选择订购店
$("#<%=thisID%>_dlArea").change(function () {
if (this.value == 0) {
dlBar.selectedIndex = 0;
dlBar.disabled = "disabled";
}
else {
$("#<%=thisID%>_dlBar option:gt(0)").remove();
AdddlBar(this.value);
}
})
// 给隐藏控件赋值
$("#<%=thisID%>_dlBar").change(function () {
document.getElementById("<%=thisID%>_hideBar").value = this.value;
})
// 动态加载地区
function AddDlArea(selectedValue) {
var url = "/Post/EsbSelect.aspx?";
$.get(url, { pid: selectedValue, t: new Date().getMilliseconds(), type: "dlPro", renderType: "<%=_renderType%>" }, function (jnum) {
var jnum = eval(jnum);
if (jnum != undefined && jnum != "") {
var $dlArea = $("#<%=thisID%>_dlArea");
// 绑定新节点：
for (var i = 0; i < jnum.length; i++) {
$dlArea.append("<option value='" + jnum[i].Id + "'>" + jnum[i].Name + "</option>")
} // 设置为可用
dlArea.disabled = "";
}
});
}
// 动态添加订购店
function AdddlBar(selectedValue) {
var url = "/Post/EsbSelect.aspx?";
$.get(url, { aid: selectedValue, t: new Date().getMilliseconds(), type: "dlArea", renderType: "<%=_renderType%>" }, function (jnum) {
var jnum = eval(jnum);
if (jnum != undefined && jnum != "") {
var $dlBar = $("#<%=thisID%>_dlBar");
// 绑定新节点：
for (var i = 0; i < jnum.length; i++) {
$dlBar.append("<option value='" + jnum[i].CompanyId + "'>" + jnum[i].CompanyName + "</option>")
} // 设置为可用
dlBar.disabled = "";
}
});
}
})
</script>

.cs代码
public string _renderType = "0";
/// <summary>
/// 呈现类型
/// </summary>
public string RenderType
{
get { return _renderType; }
set { _renderType = value; }
}
//ControlId
public string thisID = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
thisID = ID;
if (!IsPostBack)
{
BindProList();
}
}
// 绑定省
private void BindProList()
{
dlPro.Items.Clear();
CityInfo[] infos = EsbSelectView.GetProList("");
dlPro.DataSource = infos;
dlPro.DataTextField = "Name";
dlPro.DataValueField = "Pid";
dlPro.DataBind();
dlPro.Items.Insert(0, new ListItem("-请选择-", "0"));
}
复制下来，改一下你的控件，就可以用

Answer 2

SqlConnection sqlcon;
string strCon = "Data Source=(local);Database=数据库名;Uid=sa;Pwd=sa";
protected void Page_Load(object sender, EventArgs e)
{
DropDownList ddl;
if (!IsPostBack)
{
string sqlstr = "select top 5 * from 表";
sqlcon = new SqlConnection(strCon);
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds, "起个名字");
GridView1.DataSource = myds;
GridView1.DataBind();
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
DataRowView mydrv = myds.Tables["起个名字"].DefaultView[i];
if (Convert.ToString(mydrv["列名"]).Trim() == "True")
{
ddl = (DropDownList)GridView1.Rows[i].FindControl("DropDownList1");
ddl.SelectedIndex = 0;
}
if (Convert.ToString(mydrv["列名"]).Trim() == "False")
{
ddl = (DropDownList)GridView1.Rows[i].FindControl("DropDownList1");
ddl.SelectedIndex = 1;
}
}
sqlcon.Close();
}
}
public SqlDataReader ddlbind()
{
string sqlstr = "select distinct 列名from 表";
sqlcon = new SqlConnection(strCon);
SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
return sqlcom.ExecuteReader();
}

Answer 3

比如gridview 是ID dropDownLis是ID
foreach (GridView rows in gridview.Rows)
{
DropDownList drp=(DropDownList)rows.FindControl("dropDownLis");
然后对drp进行绑定你所要绑定的
drp.items.add(new ListItem("显示的值","这个选项的ID"))
}
大概就是这样，这个写法的字母大先写有错 思路没错