Saving data to database from Dropdownlist in gridview

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

i'm having a gridview in which it has 10 columns and one of which is a dropdown i wanna take the selected value from it and save in a specific column of a database i wanna know how and where to access this dropdownlist. if there is a code it will be useful plzzz help

Posted 20-May-15 17:28pm

Member 11698441

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Arun Kumar_Tech · Accepted Answer · 2015-05-20T18:15:00

Solution 1

its simple, please follow the below code

C#

DropDownList lstuserName = (DropDownList)gvRow.FindControl("ddl_groub");
  Response.Write("Selected Value : " + lstuserName.SelectedValue + " " + "Selected Item : " + lstuserName.SelectedItem.Text);

Posted 20-May-15 18:15pm

Arun Kumar_Tech

Comments

Member 11698441 21-May-15 0:20am

Thanks, May i know the function where this C# code to be added?

Arun Kumar_Tech 21-May-15 0:36am

Based on your requirement you have to use that code inside the function, if you say your requirement means i will try to explain it.

Member 11698441 21-May-15 0:42am

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
Label lblupdateid = (Label)GridView2.Rows[e.RowIndex].FindControl("slnoLabel");
DropDownList drp = (DropDownList)sender;
GridViewRow gv = (GridViewRow)drp.NamingContainer;
DropDownList lstuserName = (DropDownList)gv.FindControl("DropDownList1");
Response.Write("Selected Value : " + lstuserName.SelectedValue + " " + "Selected Item : " + lstuserName.SelectedItem.Text);
string query = "update leaveforum set status1=" + lstuserName.SelectedItem.Text where SL_No =" + lblupdateid.Text;
GridView2.EditIndex = -1;
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();
conn.Close();
gvbind1();
}
this is drop down table should i give like this but its throwing errror at e.RowIndex and it couldnt seperate as string query = "update leaveforum set status1=" + lstuserName.SelectedItem.Text where SL_No =" + lblupdateid.Text;

Member 11698441 21-May-15 0:49am

my requirement is like its a leave forum and its entered into db by one user and another user accepts it so a drop down is placed in grid now i want this selected text from dropdown to be posted in the db

Arun Kumar_Tech 21-May-15 0:51am

DropDownList1 is not inside gridview right, then Eventargs e deals with event reards to DropDownList1, how can you use e.rowindex, your code seems wrong.

Member 11698441 21-May-15 1:17am

Dropdown list is inside the gridview i changed it to protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)

Arun Kumar_Tech 21-May-15 0:54am

You can use your code inside the onrowcommand event or some event that's happening in gridview, then only you can use e.rowindex to read the row index, do you understand.

Member 11698441 21-May-15 1:19am

ohhhh ok gt it will i be able to use protected void DropDownList1_SelectedIndexChanged(object sender, GridViewUpdateEventArgs e)

Arun Kumar_Tech 21-May-15 0:59am

you are trying to use onselectedindexchange event for dropdown which is inside gridview am i right?

Member 11698441 21-May-15 1:18am

yes exactly is it possible?

Arun Kumar_Tech 21-May-15 3:21am

once you choose some value in dropdown in onselectedindexchange you have to update the table with that value, is it you want?

Member 11698441 21-May-15 3:26am

yes

Arun Kumar_Tech 21-May-15 3:32am

try this dude,
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddlCurrentDropDownList= (DropDownList)sender;
string selectedvalue = ddlCurrentDropDownList.SelectedItem.Text;

}

Member 11698441 21-May-15 4:37am

i could get the selected value of dropdown inside this function but fr loading into gridview its not getting the index of the row number inside this function in the same way in inside gridview i could get index but dropdown is not working

Member 11698441 21-May-15 4:40am

protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblupdateid = (Label)GridView2.Rows[e.RowIndex].FindControl("slnoLabel");
DropDownList DropDown = (DropDownList)GridView2.Rows[e.RowIndex].FindControl("DropDownList1");
DropDownList drp = (DropDownList)sender;
GridViewRow gv = (GridViewRow)drp.NamingContainer;
DropDownList lstuserName = (DropDownList)gv.FindControl("DropDownList1");
Response.Write("Selected Value : " + lstuserName.SelectedValue + " " + "Selected Item : " + lstuserName.SelectedItem.Text);
string query = "update leaveforum set status1='" + lstuserName.SelectedItem.Text + "' where sl_no ='" + lblupdateid.ToString() + "'";
GridView2.EditIndex = -1;
conn.Open();
//SqlCommand cmd = new SqlCommand("SELECT * FROM webdesign", conn);
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();
conn.Close();
gvbind1();
// GridView2.DataBind();
}

Arun Kumar_Tech 21-May-15 6:32am

Reffer the below code,
DropDownList ddlCurrentDropDownList = (DropDownList)sender;
GridViewRow grdrDropDownRow = ((GridViewRow)ddlCurrentDropDownList.Parent.Parent);
Label lblCurrentStatus = (Label)grdrDropDownRow.FindControl("lblOrderStatus");
if (lblCurrentStatus != null)
lblCurrentStatus.Text = ddlCurrentDropDownList.SelectedItem.Text;

Member 11698441 21-May-15 23:07pm

Thanks man i got it :)