How to bind dropdownlist when updating data from to db in as

Anjali Khan

8y1.7k.NET

Hi Frnds

How to bind dropdownlist when updating data from to db in asp.net ?

i have a form with dropdown list

i completed work on this and successfully data inserted in db . and dispalying gridview

now when i edit this form for updating and click on edit form - form is opened but dropdown is not binding. how to do this for update data

20 Replies

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

Jitendra Shekhawat8y ago
Accepted answer
http://www.c-sharpcorner.com/UploadFile/rohatash/binding-dropdownlist-with-database-and-display-data-in-gridv/
Ronika Jency8y ago
Hi Anjali,

Edit click -> You have to bind the dropdown data.

FYR, below code is used to bind the data
SqlConnection con = new SqlConnection(str);
string com = "Select * from UserDetail";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DropDownList1.DataSource = dt;
DropDownList1.DataBind();
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();
Code get from below URL

http://www.c-sharpcorner.com/UploadFile/rohatash/binding-dropdownlist-with-database-and-display-data-in-gridv/

After, You have to assign the selected value for dropdown

Using SelectedValue property, you can assign the inserted value to dropdown.

DropDownList1.SelectedValue = "Anjali";
Naresh Singhal8y ago
Hi Anjali , Kindly refer below linnk for CRUD (create,update,delete) operation in drop down list with database

http://www.c-sharpcorner.com/UploadFile/009464/crud-operation-of-dropdownlist-inside-gridview-in-Asp-Net/
Anjali Khan8y ago
hi team

i am sending my page here column name From whom i.e my department name

but when displaying column name data is is showing id so how to do this .i attached my screen short . and sending my procedure n function

function ---

public void bindropDownDepartment()

{

try

{

objDiaryOB.DepartmentNameID = 1;

p_Var.dSet = objDiaryBl.getDepartmentType(objDiaryOB);

if (p_Var.dSet.Tables[0].Rows.Count > 0)

{

ddlDepartName.DataSource = p_Var.dSet;

ddlDepartName.DataValueField = "Deptt_Id";

ddlDepartName.DataTextField = "Deptt_Name";

ddlDepartName.DataBind();

}

ddlDepartName.Items.Insert(0, new ListItem("Select", "0"));

if (ViewState["departmentid"] != null)

{

ddlDepartName.SelectedValue = ViewState["departmentid"].ToString();

}

p_Var.dSet = null;

}

and procedure

ALTER PROC [dbo].[Inward_MST_GET_Department]

--(

--@ModuleId int=null,

--@Deptt_Id INT = NULL

--)

AS

BEGIN

BEGIN TRY

SET NOCOUNT ON;

SELECT [Deptt_Id],[Deptt_Name]

FROM tbl_Mst_Department

-- WHERE ((Deptt_Id=@Deptt_Id) OR (@Deptt_Id IS NULL))

SET NOCOUNT OFF;

END TRY

BEGIN CATCH

--There was an error

exec sp_error_handler

IF @@TRANCOUNT>0

ROLLBACK

RETURN -101

END CATCH

RETURN 0

END
sunil r8y ago
HI
this is not a answer for your question but i have a same question so i am posting here.

i have developed one page with textarea and gridview and i have successfully executing the select queery and getting the result in gridview but i am not getting how to achive insert and updtate queeries through my textarea and it should reflect in db so can you please help me out with this problem
Laxmidhar Sahoo8y ago
grdManageDiary.DataSource = p_Var.dSet; thi change to
grdManageDiary.DataSource = p_Var.dSet.tables[0];
Anjali Khan8y ago
frnds

this is my function

#region Function to bind userd display
private void DisplayViewDiary()
{
objDiaryOB.PageIndex = 1;
objDiaryOB.PageSize = 50;
// objDiaryOB.InwardNO = null;
p_Var.dSet = objDiaryBl.ManageDiaryDisplay(objDiaryOB);
if (p_Var.dSet.Tables[0].Rows.Count > 0)
{
grdManageDiary.DataSource = p_Var.dSet;
grdManageDiary.DataBind();
}
}
#endregion

and its id binding in page load also

but editing time dd not binding
Sagar Pandurang Kap8y ago
Firstly the NewEditIndex is used to get index.

If you want to bind data to dropdown then
SqlCommand sqlcomm = new SqlCommand("your query",ConnectionString);
SqlDataAdapter sda2 = new SqlDataAdapter(sqlcomm);
DataSet ds2 = new DataSet();
sda2.Fill(ds2);
gridname.Visible = true;
gridname.DataSource = null;
gridname.DataSource = ds2;
gridname.DataBind();
Anjali Khan8y ago
Hi sager

i did

protected void grdmanageDiary_RowEditing(object sender, GridViewEditEventArgs e)
{
grdManageDiary.EditIndex = e.NewEditIndex;
this.DisplayViewDiary();
}

but still not bind
Laxmidhar Sahoo8y ago
hi
I think the page load event intialised dropdownlist
if(!ispostback)
{
your code
}
Sagar Pandurang Kap8y ago
Hi Anjali,
You need to fetch related data on edit click of gridview on event gridview_RowEditing.
Write code on gridview_RowEditing to bind data into dropdown.
Anjali Khan8y ago
yes laxmidhar so how to do this
Laxmidhar Sahoo8y ago
hi
I think your page is refreshed and dropdownlist is also refreshed.
or datasource is not find to bind
Anjali Khan8y ago
yes for editing time dropdown is not binding
Sagar Pandurang Kap8y ago
HI Anjali,
I think when you click on edit button embedded into grid you want the form controls(like textboxes) should be filled with grids data to edit. Is it your Problem right????
Anjali Khan8y ago
Hi sagar

i have a form with drop down list and submitted data successfull
after showing data in grid from to data base .this is also done
now if i click on edit button which is bind by gv and click on form so form is open but data is not binded which i select inserted time
Sagar Pandurang Kap8y ago
These links mights help you..
http://www.c-sharpcorner.com/UploadFile/rohatash/binding-dropdownlist-with-database-and-display-data-in-gridv/
https://www.aspsnippets.com/Articles/Populate-DropDownList-with-Selected-Value-in-EditItemTemplate-of-GridView-in-ASPNet.aspx
https://forums.asp.net/t/1317231.aspx?how+to+refresh+data+in+dropdownlist+
https://www.codeproject.com/Questions/412998/bind-data-to-dropdownlist-with-csharp
Sagar Pandurang Kap8y ago
The dropdownlist is inside gridview or outside??
Anjali Khan8y ago
HI frnds

these thing i did and it is binded successfully.now after inserted data from to form if i will do edit that time dropdown nit binding
8y ago
Hi
https://www.aspsnippets.com/Articles/Bind-Fill-Populate-DropDownList-control-from-database-in-ASPNet-using-C-and-VBNet.aspx