public void BindDistrict() { DataSet ds = new DataSet(); ds = objBAL.BindDistrictBAL(); if (ds.Tables[0].Rows.Count > 0) { ddlDistirct.DataSource = ds.Tables[0]; ddlDistirct.DataTextField = "DistrictName"; ddlDistirct.DataValueField = "DistrictCode"; ddlDistirct.DataBind(); ddlDistirct.Items.Insert(0, new ListItem("--Select--", "0")); ddlDistirct.SelectedIndex = 0; } else { } }
public void BindDistrict() { //cmd.CommandText = "SELECT [DistrictCode],[DistrictName] FROM [TrueVoterDB].[dbo].[tblDistrictMapping]"; //cmd.CommandType = CommandType.Text; //cmd.Connection = con; //da.SelectCommand = cmd; //ds.Clear(); //da.Fill(ds); DataSet ds = new DataSet(); ds = objBAL.BindDistrictBAL(); if (ds.Tables[0].Rows.Count > 0) { ddlDistirct.DataSource = ds.Tables[0]; ddlDistirct.DataTextField = "DistrictName"; ddlDistirct.DataValueField = "DistrictCode"; ddlDistirct.DataBind(); ddlDistirct.Items.Insert(0, new ListItem("Select", "0")); ddlDistirct.SelectedIndex = 0; } else { } }