how to check selected dropdown value is exists or not

Deekshaa Singh Chauhan

8y1.6k.NET

How to check selected dropdown value is available in database

When we select commodity from dropdaown and this value is not in database with this warehouse it does not show any message .

protected void ddlCommodity_SelectedIndexChanged(object sender, EventArgs e)
{
Int64 Cmdty = Convert.ToInt64(ddlCommodity.SelectedItem.Value);
if ((Convert.ToInt32(ddlWarehouse.SelectedItem.Value)) != 0)
{
//int InsuranceId = Convert.ToInt32(grd.DataKeys[e.RowIndex].Values[0]);
string constr = WebConfigurationManager.ConnectionStrings["WarehouseWebsiteString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("Select CommodityId from tblCommodityonWarehouse WHERE WarehouseId = @WarehouseId"))
{
cmd.Parameters.AddWithValue("@CommodityId", Cmdty);
cmd.Parameters.AddWithValue("@WarehouseId", ddlWarehouse.SelectedIndex);
cmd.Connection = con;
con.Open();
int k = cmd.ExecuteNonQuery();
if (k > 0)
{
string popupScript = "$.prompt('This Commodity is Not Available. Please use another.');";
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "clientScript", popupScript, true);
ddlCommodity.SelectedIndex = -1;
}
//else
//{
//}
con.Close();
}
}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sankara Krishnan Venugopal8y ago
Hi Deeksha,

Instead of sending parameters, you can directly assign the dropdown value to select statement to check the value in database.

I have checked the below Query, it is worked for me.
Int64 Cmdty = Convert.ToInt64(10);
if ((Convert.ToInt32(10)) != 0)
{
//int InsuranceId = Convert.ToInt32(grd.DataKeys[e.RowIndex].Values[0]);
string constr = WebConfigurationManager.ConnectionStrings["WarehouseWebsiteString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("Select CommodityId from tblCommodityonWarehouse WHERE WarehouseId =" + Cmdty))
{
//cmd.Parameters.AddWithValue("@CommodityId", Cmdty);
//cmd.Parameters.AddWithValue("@WarehouseId", 10);
cmd.Connection = con;
con.Open();
int k = cmd.ExecuteNonQuery();
if (k > 0)
{
string popupScript = "$.prompt('This Commodity is Not Available. Please use another.');";
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "clientScript", popupScript, true);
//ddlCommodity.SelectedIndex = -1;
}
else
{
// do actions
}
con.Close();
}
}
}
NOTE: You can use the procedure, when you have defined "Stored Procedure" instead of Select Statement.

Thanks.
+1
Deekshaa Singh Chauhan8y ago
Where is problem I dont understand how to do it.
It does not show any value on dropdown list.
using (SqlCommand cmd = new SqlCommand("select tblCommodity.Name from tblCommodityonWarehouse  join tblCommodity on tblCommodityonWarehouse.CommodityId=tblCommodity.CommodityId where WarehouseId =" + ddlWarehouse.SelectedIndex))
           {
               //cmd.Parameters.AddWithValue("@CommodityId", Cmdty);
               //cmd.Parameters.AddWithValue("@WarehouseId", ddlWarehouse.SelectedIndex);
               cmd.Connection = con;
               con.Open();
               int k = cmd.ExecuteNonQuery();
               if (k > 0)
               {
                   string popupScript = "$.prompt('This Commodity is Not Available. Please use another.');";
                   ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "clientScript", popupScript, true);
                   ddlCommodity.SelectedIndex = -1;
               }
               //else
               //{

               //}
               con.Close();
           }
+1
Francis Susaimichael8y ago
What you get when you use "ExecuteScalar" on the variable "k"?
+1
Deekshaa Singh Chauhan8y ago
Is not work, yogesh and francis.
0
Yogesh Vedpathak8y ago
Hi Deeksha ,
Check condition you could try checking to see if this method returns a null

if (ddlCommodity.Items.FindByText(cmd().ToString()) !null)
ddlCommodity.SelectedIndex = 0;
+1
Francis Susaimichael8y ago
Try to use "ExecuteScalar" instead of "ExecuteNonQuery", it will solve your problem.

http://csharp.net-informations.com/data-providers/csharp-sqlcommand-executescalar.htm
+1