Loading

dropdownlist selected value from database values

dropdownlist selected value from database values

Azaad Abbas

Azaad Abbas

11y1.1kLearn iOS Programming

if (connection.State == ConnectionState.Closed)

connection.Open();

command = new SqlCommand();

command.CommandText = "sp_Get_ControlValues";

command.CommandType = CommandType.StoredProcedure;

command.Connection = connection;

command.Parameters.AddWithValue("@uid", uid);

SqlDataAdapter daPack = new SqlDataAdapter(command);

DataSet dsPack = new DataSet();

daPack.Fill(dsPack);

//ddlPackPeriod.DataSource = dsPack;

//ddlPackName.DataSource = dsPack;

//ddlPackPeriod.DataTextField = "PackagePeriod";

//ddlPackName.DataTextField = "PackageName";

txtOldExpDate.Text = dsPack.Tables[0].Rows[0]["OldExpiryDate"].ToString();

txtNoOfExtConn.Text = dsPack.Tables[0].Rows[0]["NoOfExtraConn"].ToString();

txtAmntToPay.Text = dsPack.Tables[0].Rows[0]["Balance"].ToString();

ddlPackPeriod.DataBind();

ddlPackName.DataBind();

In 'pageload' iam alredy binded those two dropdowns and those dropdowns are cascading

so when I click on 'Suearch' button I just want to show as selected of 'UserId' col values

so How?

3 Replies

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

Azaad Abbas11y ago
I got the Answer Friends

ddlPackPeriod.SelectedIndex = ddlPackPeriod.Items.IndexOf(ddlPackPeriod.Items.FindByText(dsPack.Tables[0].Rows[0]["PackagePeriod"].ToString()));

//open the db connection if it is closed...
if (connection.State == ConnectionState.Closed)
connection.Open();
string packagePeriod = ddlPackPeriod.SelectedValue;
command = new SqlCommand();
command.CommandText = "sp_Get_PackName";
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;

command.Parameters.AddWithValue("@packagePeriod", packagePeriod);
ddlPackName.DataSource = command.ExecuteReader();
ddlPackName.DataValueField = "PackageId";
ddlPackName.DataTextField = "PackageName";
ddlPackName.DataBind();

ddlPackName.SelectedIndex = ddlPackPeriod.Items.IndexOf(ddlPackName.Items.FindByText(dsPack.Tables[0].Rows[0]["PackageName"].ToString()));
0
Azaad Abbas11y ago
I have Three tables 'Customer_Reg' (Cid,PackId,....), 'Recieve_Payment' (rPid,cid,packid....) 'Package' (PackId,PackPeriod,PackName...)

In 'Recieve_Payment.aspx' have two dropdowns 'PackPeriod' and 'PackName (cascaded with PackPeriod from databse)' and grid with 'Serach' button.

wehen i click 'search' button with 'Cid' should bind those two grids (PackPeriod,packName, PackPrice..e.t.c) and also show 'PackPeriod' and 'PackName' on dropdwons as selected but not effect before binded it...

so how?
0
Khargesh Rajput11y ago
In page load check
If(!page.ispostback)
{
Code to bind dropdown
}
0