hello all
i have a dropdwon list as below :
<div class="col-lg-3">
<asp:DropDownList ID="ddlAssignedto" runat="server" CssClass="form-control" DataTextField="Emp_Name" DataValueField="Emp_Name" ></asp:DropDownList>
</div>
and this drop down list get its data from a stored procedure , an its value will be selected from a grid view ,
what i want is : when the ddlassinged dropdownlist value from the grid view is empty , i want the defualt value which is ( Select an employee ) to be selected...
the code for the gridview is as below :
<asp:GridView ID="GVAssetList" runat="server" DataKeyNames="Asset_ID" AutoGenerateColumns="false" CssClass="table table-bordered table-responsive table-striped table-hover ">
<Columns>
<asp:BoundField DataField="Asset_ID" HeaderText="Asset ID" />
<asp:BoundField DataField="Asset_Name" HeaderText="Asset Name" />
<asp:BoundField DataField="Asset_SN" HeaderText="Asset SN" />
<asp:BoundField DataField="Make" HeaderText="Asset Make" />
<asp:BoundField DataField="Model" HeaderText="Asset Model" />
<asp:BoundField DataField="Asset_Status" HeaderText="Asset Status" />
<asp:BoundField DataField="Emp_Name" HeaderText="Assinged to" />
<asp:TemplateField>
<ItemTemplate>
<asp:Button runat="server" ID="btnSelect" Text="Select" OnClick="btnSelect_Click" CssClass="btn btn-info" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
and the code behin the page is as below :
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable gvdt = new DataTable("GVAssetList-table");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
cmd.CommandText = "SP_GetAssetList";
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(gvdt);
GVAssetList.DataSource = gvdt;
GVAssetList.DataBind();
con.Close();
//call data for dropdownlist
ddlMake.DataSource = GetData("SP_ddlMake", null);
ddlMake.DataBind();
ListItem liMake = new ListItem("Select Make", "-1");
ddlMake.Items.Insert(0, liMake);
ListItem liModel = new ListItem("Select Model", "-1");
ddlModel.Items.Insert(0, liModel);
ddlModel.Enabled = false;
// asset status drop downlist
ListItem SelectStatus = new ListItem("Select Status", "-1");
ListItem NewListitem = new ListItem("New", "1");
ListItem OldListitem = new ListItem("Used", "2");
ListItem DefctListitem = new ListItem("Defective", "3");
ddlAssetStatus.Items.Add(SelectStatus);
ddlAssetStatus.Items.Add(NewListitem);
ddlAssetStatus.Items.Add(OldListitem);
ddlAssetStatus.Items.Add(DefctListitem);
// employee list drop downlist
ddlAssignedto.DataSource = GetData("SP_GetEmpList", null);
ddlAssignedto.DataBind();
ListItem liEmployee = new ListItem("Selecte Employee", "-1");
ddlAssignedto.Items.Insert(0, liEmployee);
}
}
// centralize the data set for drop downlist controls
private DataSet GetData(string SP_Name, SqlParameter SP_Parameter)
{
SqlDataAdapter sda = new SqlDataAdapter(SP_Name, con);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
if (SP_Parameter != null)
{
sda.SelectCommand.Parameters.Add(SP_Parameter);
}
DataSet ds = new DataSet();
sda.Fill(ds);
return ds;
}
//grid view select functionality
protected void btnSelect_Click(object sender, EventArgs e)
{
GridViewRow SelectedRow = ((sender as Button).NamingContainer as GridViewRow);
Session["GVAssetList_ID"] = GVAssetList.DataKeys[SelectedRow.RowIndex].Value;
txtAssetName.Text = SelectedRow.Cells[1].Text;
txtAssetSN.Text = SelectedRow.Cells[2].Text;
ddlMake.SelectedItem.Text = SelectedRow.Cells[3].Text;
ddlModel.SelectedItem.Text = SelectedRow.Cells[4].Text;
ddlAssetStatus.SelectedItem.Text = SelectedRow.Cells[5].Text;
ddlAssignedto.SelectedItem.Text = SelectedRow.Cells[6].Text;
}
protected void ddlMake_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlMake.SelectedIndex == 0)
{
}
else
{
ddlModel.Enabled = true;
SqlParameter ddlModelParameter = new SqlParameter("@Make_ID", ddlMake.SelectedValue);
DataSet ds = GetData("SP_ddlModel", ddlModelParameter);
ddlModel.DataSource = ds;
ddlModel.DataBind();
ListItem liModel = new ListItem("Select Model", "-1");
ddlModel.Items.Insert(0, liModel);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (Session["GVAssetList_ID"] != null)
{
try
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SP_EditAsset";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Asset_ID", Convert.ToInt32(Session["GVAssetList_ID"]));
cmd.Parameters.AddWithValue("@Asset_Name", txtAssetName.Text);
//cmd.Parameters.AddWithValue("@Asset_SN", txtAssetSN.Text);
//cmd.Parameters.AddWithValue("@Asset_Make", ddlMake.SelectedValue);
//cmd.Parameters.AddWithValue("@Asset_Model", ddlModel.SelectedValue);
//cmd.Parameters.AddWithValue("@Emp_ID_FK", ddlAssignedto.SelectedValue);
con.Open();
// SqlDataReader sdr = cmd.ExecuteReader();
cmd.ExecuteNonQuery();
GVAssetList.DataBind();
lblmsg.Text = "Asset Update!!";
con.Close();
}
catch
{ }
}
}
}
currently when i do selection on of the row , and the value for the drop down box is empty ...
the selected text of the ddlassignedto dropdown list is like the screenshoot