How to get the only the id of the selected value in ASP gridview

Question

0.00/5 (No votes)

See more:

, +

Hi
I am working on asp Gridview and I want to get the Id of the content by joining the content from another table and display the id.And the id od the dropdownlist is not showing in code behind.Here is my snippnet

What I have tried:

C#

<pre>protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bind();
                Bindmachine();
            }
        }
        protected void bind()
        {
            cn.Open();
            SqlCommand cmd = new SqlCommand("Select Sample7.Empid,Sample7.EmpName,Sample6.machineid From Sample7 Join Sample6 ON Sample7.Categoryid = Sample6.machineid ", cn);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            cn.Close();
            if (ds.Tables[0].Rows.Count > 0)
            {
                gvDetails.DataSource = ds;
                gvDetails.DataBind();
            }
        }
        protected void gvDetails_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName.Equals("Add"))
            {
                TextBox txtEmpId = (TextBox)gvDetails.FooterRow.FindControl("txtempid");
                TextBox txtEmpName = (TextBox)gvDetails.FooterRow.FindControl("txtempname1");
                DropDownList ddlEmpDep = (DropDownList)gvDetails.FooterRow.FindControl("txtmac1");
                

                cn.Open();
                SqlCommand cmd =
                new SqlCommand(
                "insert into Sample7(EmpId,EmpName,Categoryid) values('" + txtEmpId.Text + "','" + txtEmpName.Text + "','" +
                ddlEmpDep.SelectedValue + "')", cn);
                int result = cmd.ExecuteNonQuery();
                cn.Close();
                if (result == 1)
                {
                    bind();

                }
                else
                {

                }
            }
        }


        protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            int EmpId = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString());
            string username = gvDetails.DataKeys[e.RowIndex].Values["EmpName"].ToString();
            DropDownList txtmac = (DropDownList)gvDetails.Rows[e.RowIndex].FindControl("txtmac1");
            
            cn.Open();
            SqlCommand cmd = new SqlCommand("Update Sample7 set machineid ='" + txtmac.Text + "' where EmpId=" + EmpId, cn);
            cmd.ExecuteNonQuery();
            cn.Close();

            // lblresult.Text = username + " Details Updated successfully";
            gvDetails.EditIndex = -1;
            bind();
        }
        protected void gvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int EmpId = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Values["EmpId"].ToString());
            string username = gvDetails.DataKeys[e.RowIndex].Values["EmpName"].ToString();
            cn.Open();
            SqlCommand cmd = new SqlCommand("delete from Sample7 where EmpId=" + EmpId, cn);
            int result = cmd.ExecuteNonQuery();
            cn.Close();
            if (result == 1)
            {
                bind();

                
            }
        }
        protected void gvDetails_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            gvDetails.EditIndex = -1;
            bind();
        }
        protected void gvDetails_RowEditing(object sender, GridViewEditEventArgs e)
        {
            gvDetails.EditIndex = e.NewEditIndex;
            bind();
        }
        protected void gvDetails_OnRowDataBound(object sender, GridViewRowEventArgs e)
        {


        }
        protected void Bindmachine()
        {
            DataTable dt = new DataTable();
            cn.Open();
            SqlCommand cmd = new SqlCommand("Select * from Sample6", cn);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            //DataSet ds = new DataSet();
            da.Fill(dt);
            cn.Close();
            ddlmachine.DataSource = dt;
            ddlmachine.DataTextField = "CategoryName";
            ddlmachine.DataValueField = "CategoryName";
            ddlmachine.DataBind();
            ddlmachine.Items.Insert(0, new ListItem("--Select--"));

        }

        protected void ddlmac_SelectedIndexChanged1(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            cn.Open();
            if (ddlmachine.SelectedValue != "")
            {
                string[] sal = ddlmachine.SelectedValue.Split(',');
                

                SqlCommand cmd = new SqlCommand("select * from Sample7 ", cn);
                
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(dt);
            }

            else
            {
                SqlCommand cmd = new SqlCommand("select * from Sample7", cn);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(dt);
            }
            cn.Close();
            gvDetails.DataSource = dt;
            gvDetails.DataBind();
        }

ASP.NET

<pre><asp:GridView ID="gvDetails" style="background-color:lightblue;     border-collapse: collapse;
               background-color: lightgreen;
    margin-top: -53px;" DataKeyNames="EmpId,EmpName" runat="server"
               HeaderStyle-CssClass="TableHead"
                AutoGenerateColumns="false"  HeaderStyle-BackColor="#61A6F8"
                ShowFooter="true" HeaderStyle-Font-Bold="true" HeaderStyle-ForeColor="white"
                CellPadding="10" CellSpacing="0"
                AllowPaging="true" PageSize="5"
                OnRowCommand="gvDetails_RowCommand"  OnRowUpdating="gvDetails_RowUpdating" 
                OnRowEditing="gvDetails_RowEditing" OnRowCancelingEdit="gvDetails_RowCancelingEdit"
                OnRowDeleting="gvDetails_RowDeleting" OnPageIndexChanging="OnPaging"
                 AllowSorting="True" OnRowDataBound="gvDetails_OnRowDataBound"
                OnTextChanged="OnTextChanged">

        <Columns >
                    <asp:TemplateField  HeaderText="EmployeeID">
                        <ItemTemplate>
                            <asp:Label ID="lblempid" runat="server" 
                                Text='<%# Eval("EmpId")%>'></asp:Label>
                        </ItemTemplate>
                        <FooterTemplate>
                            <asp:TextBox ID="txtempid" 
                                MaxLength="5" runat="server"></asp:TextBox>
                            <asp:RequiredFieldValidator ID="rfvempid" runat="server" ControlToValidate="txtempid" Text="*" ValidationGroup="validaiton" />
                        </FooterTemplate>
                    </asp:TemplateField>



                    <asp:TemplateField HeaderText="EmployeeName">
                        <HeaderTemplate>
                            EmployeeName 
                             <br></br>
                            
                            

                        </HeaderTemplate>
                        <EditItemTemplate>
                            <asp:TextBox ID="txtempname" runat="server"   Text='<%#Eval("EmpName") %>' />
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="lblempname" runat="server"  Text='<%#Eval("EmpName") %>' />
                        </ItemTemplate>
                        <FooterTemplate>
                            <asp:TextBox ID="txtempname1" runat="server"  AutoPostBack="false"  />
                            <asp:RequiredFieldValidator ID="rfvempname" runat="server" ControlToValidate="txtempname1" Text="*" ValidationGroup="validaiton" />
                        </FooterTemplate>
                    </asp:TemplateField>


                    <asp:TemplateField HeaderText="Categoryid">
                        <HeaderTemplate>
                            Categoryid 
                             <br></br>
                            
                            

                        </HeaderTemplate>
                        <EditItemTemplate>
                            <asp:DropDownList ID="ddlmachine" runat="server" OnSelectedIndexChanged="ddlmac_SelectedIndexChanged1" ></asp:DropDownList>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="lblmac" runat="server"  Text='<%#Eval("machineid") %>' />
                        </ItemTemplate>
                        <FooterTemplate>
                            <asp:TextBox ID="txtmac1" runat="server" />
                            <asp:RequiredFieldValidator ID="rfvdep" runat="server" ControlToValidate="txtmac1" Text="*" ValidationGroup="validaiton" />
                        </FooterTemplate>
                    </asp:TemplateField>

            <asp:TemplateField HeaderText="Edit/Delete" HeaderStyle-Width="5%">
                        <EditItemTemplate>
                            <asp:ImageButton ID="imgbtnUpdate"  CommandName="Update" runat="server" ImageUrl="~/Images/update.png" ToolTip="Update" Height="20px" Width="20px" />
                            <asp:ImageButton ID="imgbtnCancel" runat="server" CommandName="Cancel" ImageUrl="~/Images/cancel.png" ToolTip="Cancel" Height="20px" Width="20px" />
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:ImageButton ID="imgbtnEdit" CommandName="Edit" runat="server" ImageUrl="~/Images/ediit.png" ToolTip="Edit" Height="20px" Width="20px" />
                            <asp:ImageButton ID="imgbtnDelete" CommandName="Delete" Text="Edit" runat="server" ImageUrl="~/Images/deletee.png" ToolTip="Delete" Height="10px" Width="10px" />
                        </ItemTemplate>
                        <FooterTemplate>
                            <asp:ImageButton ID="imgbtnAdd" runat="server" ImageUrl="~/Images/Add.png" CommandName="Add" Width="20px" Height="20px" ToolTip="Add new User" ValidationGroup="validaiton" OnClientClick="GetGridFooterRowvalues()" />
                        </FooterTemplate>
                    </asp:TemplateField>

                   
                </Columns>
        </asp:GridView>

SQL

Create Table Sample7 (id int identity(1,1),Empid int,EmpName varchar(50),Categoryid nvarchar(50))

Insert Into Sample7 (Empid,EmpName,Categoryid)
Values (1,'Rahul','1'),
 (2,'Sam','2'),(3,'Raj','3')
Select * from Sample7

Create Table Sample6 (id int identity(1,1),machineid nvarchar(50) ,CategoryName varchar(50))
Insert Into Sample6 (machineid,CategoryName)
Values (1,'Machine1'),(2,'Machine2'),(3,'Machine3')
Select * from Sample6

Select Sample7.Empid,Sample7.EmpName,Sample6.machineid From Sample7
Join Sample6 ON Sample7.Categoryid = Sample6.machineid

Posted 26-Mar-17 21:24pm

Member 12605293

Updated 27-Mar-17 17:53pm

Add a Solution

Comments

Karthik_Mahalingam 27-Mar-17 10:53am

not clear

Member 12605293 27-Mar-17 14:36pm

Hi Karthik
I am using asp gridview and I have 3 columns in my First table as follows which is ..Empid,EmpName,Categoryid (Table1) and a dropdown from another table whose column names are Machineid and CategoryName(Table2)

Now I bind the dropdown with the second table column CategoryName and using that selected value I want to show only its machineid in my grid which has table 1 columns.....Secondly it that possible to make the dropdown to have multiple seclect options and display machineid as '1,2,3' in my column using comma split????

Member 12605293 27-Mar-17 14:37pm

I was waitng fr your reply earlier.Hope you understand the post.

Karthik_Mahalingam 27-Mar-17 23:51pm

you have got a solution, i hope that makes sense

Member 12605293 28-Mar-17 1:27am

Hi Karthik.
I have little doubt in this

Karthik_Mahalingam 28-Mar-17 1:28am

what doubt

Member 12605293 28-Mar-17 1:35am

Hi Karthik
I am Having two tables
Table 1 has 3 column (Empid,EmpName,Categoryid)

Table 2 has 2 column (Categoryid and CategoryName)

In the dropdownlist I have to bind the CategoryName from Table2 to show in dropdown.
While selecting the those value I want to get the Categoryid in my table1.

My questions

1.My doubt should I use join query here to join two tables ???
2.Is that possible to select multiple values in dropdownlist and show their is like 1,2,3 horizontaly
3.While doing edit function, I want that particular column as dropdown with multiselect and not as textbox.

Karthik_Mahalingam 28-Mar-17 3:08am

1.My doubt should I use join query here to join two tables ???
yes with common id

2.Is that possible to select multiple values in dropdownlist and show their is like 1,2,3 horizontaly
yes but its not a good aproach

3.While doing edit function, I want that particular column as dropdown with multiselect and not as textbox.
yes, use multi selecct control (jquery plugin)

Member 12605293 28-Mar-17 3:49am

Hi Karthik
Thanks for your reply.Secondly I hv another doubt
I want to display the dropdown on my EditItemTemplate and Footer Template and to show label in Itemtemplate.
Should i need to write 2 "OnSelectedIndexChanged" for EditItem Template and Footer Template for the dropDown?

Karthik_Mahalingam 28-Mar-17 5:20am

yes you have to

Member 12605293 28-Mar-17 5:25am

Hi karthik
Spend few mins for my issue sir

Member 12605293 28-Mar-17 8:28am

Hi Karthik
Ping me once your are free

Member 12605293 28-Mar-17 14:05pm

Hi Karthik,

Please check the code ...

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{ bind(); }
}
protected void bind()
{
cn.Open();
SqlCommand cmd = new SqlCommand("Select T0.Empid,T0.name,T1.Departmentid From Telerik3 Join Department1 ON T0.skillsid = T1.Departmentid", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
cn.Close();
if (ds.Tables[0].Rows.Count > 0)
{
gvDetails.DataSource = ds;
gvDetails.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
gvDetails.DataSource = ds;
gvDetails.DataBind();
int columncount = gvDetails.Rows[0].Cells.Count;
gvDetails.Rows[0].Cells.Clear();
gvDetails.Rows[0].Cells.Add(new TableCell());
gvDetails.Rows[0].Cells[0].ColumnSpan = columncount;
gvDetails.Rows[0].Cells[0].Text = "Enter the details";
}
}
protected void gvDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Add"))
{
TextBox txtEmpId = (TextBox)gvDetails.FooterRow.FindControl("txtempid");
TextBox txtEmpName = (TextBox)gvDetails.FooterRow.FindControl("txtempname1");
DropDownList ddlEmpDep = (DropDownList)gvDetails.FooterRow.FindControl("DropDownList3");
cn.Open();
SqlCommand cmd =
new SqlCommand(
"insert into Telerik3(empid,name,skillsid) values ('" + txtEmpId.Text + "','" + txtEmpName.Text + "','" +
ddlEmpDep.SelectedValue + "')", cn);
int result = cmd.ExecuteNonQuery();
cn.Close();
if (result == 1)
{
bind();

}
else
{

}
}
}

protected void ddlitem_SelectedIndexChanged(object sender, GridViewRowEventArgs e)
{
//DropDownList ddl = (DropDownList)e.Row.FindControl("DropDownList2");
//DataTable dt = new DataTable();
//cn.Open();
//if (ddl.SelectedValue != "")
//{
// string[] sal = ddl.SelectedValue.Split(',');
// string from = sal[0];
// string to = sal[1];
//}
}
protected void gvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int EmpId = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Values["empid"].ToString());
string username = gvDetails.DataKeys[e.RowIndex].Values["empname"].ToString();
cn.Open();
SqlCommand cmd = new SqlCommand("delete from Telerik3 where empid=" + EmpId, cn);
int result = cmd.ExecuteNonQuery();
cn.Close();
if (result == 1)
{
bind();

}
}
protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int EmpId = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString());

TextBox txtname = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtempname");
DropDownList txtskills = (DropDownList)gvDetails.Rows[e.RowIndex].FindControl("DropDownList2");

cn.Open();
SqlCommand cmd = new SqlCommand("Update Telerik3 set name='" + txtname.Text + "',skillsid='" + txtskills.Text + "' where empid=" + EmpId, cn);
cmd.ExecuteNonQuery();
cn.Close();

// lblresult

Member 12605293 28-Mar-17 14:08pm

Hi Karthik
Please check my snippets to achieve the selected text id in the textbox Like (1,2,3) with multiselect option (which I have not used)

<asp:GridView ID="gvDetails" style="background-color:lightgreen; border-collapse: collapse;
background-color: lightgreen;
margin-top: -53px;" DataKeyNames="empid,name" runat="server"

AutoGenerateColumns="false" HeaderStyle-BackColor="#61A6F8"
ShowFooter="true" HeaderStyle-Font-Bold="true" HeaderStyle-ForeColor="White"
CellPadding="10" CellSpacing="0"
AllowPaging="true" PageSize="5"
AllowSorting="True" OnRowDataBound="gvDetails_OnRowDataBound"
OnRowCancelingEdit="gvDetails_RowCancelingEdit"
OnRowDeleting="gvDetails_RowDeleting" OnRowEditing="gvDetails_RowEditing"
OnRowUpdating="gvDetails_RowUpdating"
OnRowCommand="gvDetails_RowCommand" >

<Columns >

<asp:TemplateField HeaderText="EmployeeID">
<itemtemplate>
<asp:Label ID="lblempid" runat="server" class="clsempid"
Text='<%# Eval("empid")%>'>

<footertemplate>
<asp:TextBox ID="txtempid"
MaxLength="5" runat="server">

<asp:TemplateField HeaderText="EmployeeName">
<edititemtemplate>
<asp:TextBox ID="txtempname" runat="server" Text='<%#Eval("name") %>' />

<itemtemplate>
<asp:Label ID="lblempname" runat="server" class="clsempid1" Text='<%#Eval("name") %>' />

<footertemplate>
<asp:TextBox ID="txtempname1" runat="server" AutoPostBack="true" onkeypress="hidedialog(this)" />

<asp:TemplateField HeaderText="Skills">
<edititemtemplate>
<asp:DropDownList ID="DropDownList2" runat="server" OnSelectedIndexChanged="Chekddl_SelectedIndexChanged" AutoPostBack="true" >

<itemtemplate>
<asp:Label ID="Label4" runat="server" Text='<%#Eval("Departmentid") %>' >

<footertemplate>
<asp:DropDownList ID="DropDownList3" runat="server" >

<asp:TemplateField HeaderText="Edit/Delete" HeaderStyle-Width="5%">
<edititemtemplate>
<asp:ImageButton ID="imgbtnUpdate" CommandName="Update" runat="server" ImageUrl="~/Images/update.png" ToolTip="Update" Height="20px" Width="20px" />
<asp:ImageButton ID="imgbtnCancel" runat="server" CommandName="Cancel" ImageUrl="~/Images/cancel.png" ToolTip="Cancel" Height="20px" Width="20px" />

<itemtemplate>
<asp:ImageButton ID="imgbtnEdit" CommandName="Edit" runat="server" ImageUrl="~/Images/Insert.png" ToolTip="Edit

Karthik_Mahalingam 28-Mar-17 22:26pm

can you post some screenshots on your page.

Member 12605293 29-Mar-17 1:11am

Hi Karthik
Good Morning

Member 12605293 29-Mar-17 1:20am

Thanks for your reply Sir.Sorry I cant post the pics here sites are locked in my office

Karthik_Mahalingam 29-Mar-17 1:23am

then how will i get your point.
you should pin point the exact place where you are getting the error or stuck
so that i can look on it.
i cant see the whole code and understand

Member 12605293 29-Mar-17 1:35am

Yes Karthik
Here Is my doubt

The crud Operation is working Karthik but on selecting the the value in dropdownlist suppose say I am selecting 'Drilling Machine' it is displaying in my gridtextbox but I dont want to show the name whereas I want to display its id "01" on selecting..

What I have done

1.I have binded the dropdown and the ddl works
2.I have joined the id parts with my inserting table
3.I have done the "nvarchar" datatype in the Id column to get multiple ids '1,2,' and only thing i get is the name "Drilling Machine"

Need some snippets on its selectedindex karthik so that i can wrk on the rest of the ddlz.

Member 12605293 29-Mar-17 1:42am

protected void gvDetails_OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
DropDownList ddlDesignation = (DropDownList)e.Row.FindControl("DropDownList3");
DataTable dt = new DataTable();
cn.Open();
SqlCommand cmd = new SqlCommand("Select * from Department2", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);
cn.Close();
ddlDesignation.DataSource = dt;
ddlDesignation.DataTextField = "DepartmentName";
ddlDesignation.DataValueField = "DepartmentName";
ddlDesignation.DataBind();
ddlDesignation.Items.Insert(0, new ListItem("--Select--", "0"));
cn.Close();
}
DropDownList ddl = (DropDownList)e.Row.FindControl("DropDownList2");
if (ddl != null)
{
DataTable dt = new DataTable();
cn.Open();
SqlCommand cmd = new SqlCommand("Select * from Department2", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
ddl.DataSource = dt;
ddl.DataValueField = "DepartmentName";
ddl.DataTextField = "DepartmentName";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("--Select--", "0"));
cn.Close();
}

protected void Chekddl_SelectedIndexChanged1(object sender, EventArgs e)
{
//What come to get the Id of that selected item
}

<asp:TemplateField HeaderText="Skills">
<edititemtemplate>
<asp:DropDownList ID="DropDownList2" runat="server" OnSelectedIndexChanged="Chekddl_SelectedIndexChanged" AutoPostBack="true" >

<itemtemplate>
<asp:Label ID="Label4" runat="server" Text='<%#Eval("Departmentid") %>' >

<footertemplate>
<asp:DropDownList ID="DropDownList3" runat="server" OnSelectedIndexChanged="Chekddl2_SelectedIndexChanged" >

Karthik_Mahalingam 29-Mar-17 1:43am

do you have team viewer?

Member 12605293 29-Mar-17 1:45am

No karthi :( I am at office

Member 12605293 29-Mar-17 1:46am

The code is working only thing is getting the id instead of name

Karthik_Mahalingam 29-Mar-17 1:49am

if ddl then ddl.value (if id is set a valuefield )

Member 12605293 29-Mar-17 1:53am

I am not getting you Sir

Member 12605293 29-Mar-17 1:59am

Should I do something like this

protected void ddlitem_SelectedIndexChanged(object sender, GridViewRowEventArgs e)
{
DropDownList ddl = (DropDownList)e.Row.FindControl("DropDownList2");
if (ddl != null)
{
DataTable dt = new DataTable();
cn.Open();
SqlCommand cmd = new SqlCommand("Select Departmentid from Department2", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
ddl.DataSource = dt;
ddl.DataValueField = "Departmentid";
cn.Close();
}
}

Karthik_Mahalingam 29-Mar-17 2:01am

Select DepartmentName,Departmentid from Department2

ddl.DataTextField = "DepartmentName";

Member 12605293 29-Mar-17 2:09am

Yes Like this

protected void gvDetails_OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
DropDownList ddlDesignation = (DropDownList)e.Row.FindControl("DropDownList3");
DataTable dt = new DataTable();
cn.Open();
SqlCommand cmd = new SqlCommand("Select Departmentid,DepartmentName from Department2", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);
cn.Close();
ddlDesignation.DataSource = dt;
ddlDesignation.DataTextField = "Departmentid";
ddlDesignation.DataValueField = "DepartmentName";
ddlDesignation.DataBind();
ddlDesignation.Items.Insert(0, new ListItem("--Select--", "0"));
cn.Close();
}
DropDownList ddl = (DropDownList)e.Row.FindControl("DropDownList2");
if (ddl != null)
{
DataTable dt = new DataTable();
cn.Open();
SqlCommand cmd = new SqlCommand("Select Departmentid,DepartmentName from Department2", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
ddl.DataSource = dt;
ddl.DataValueField = "Departmentid";
ddl.DataTextField = "DepartmentName";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("--Select--", "0"));
cn.Close();
}

//But what comes inside Selected Index changed???

Karthik_Mahalingam 29-Mar-17 2:15am

why you need selectedindexchange event.

Member 12605293 29-Mar-17 2:24am

:/ ohh. then How can I get the Id by selecting the name?

Karthik_Mahalingam 29-Mar-17 2:31am

are you doing something on selectedindex change evnt ?

Member 12605293 29-Mar-17 2:34am

While selecting a name ,the id should be displayed Instead of name

Karthik_Mahalingam 29-Mar-17 2:38am

this is a very simple one, i dont know why u r struggling so much on this.

Member 12605293 29-Mar-17 2:33am

My question is the dropdown shows the names of the category..
Machine1
Machine2
Machine3
Machine4

For example I am choosing "Machine4" I should get only the Id in my texbox "4" and not "Machine4"

Karthik_Mahalingam 29-Mar-17 2:37am

txt.Text = ddl.selectedValue;

Member 12605293 29-Mar-17 2:41am

<asp:TemplateField HeaderText="Skills">
<edititemtemplate>
<asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="true" >

<itemtemplate>
<asp:Label ID="Label4" runat="server" Text='<%#Eval("Departmentid") %>' >

<footertemplate>
<asp:DropDownList ID="DropDownList3" runat="server" OnSelectedIndexChanged="Chekddl_SelectedIndexChanged" >

There is not texbox sir

Karthik_Mahalingam 29-Mar-17 2:43am

use

 <pre>

to post code.

Member 12605293 29-Mar-17 2:46am

Ok Karthik

Karthik_Mahalingam 29-Mar-17 2:44am

dont use post back inside grid, it will work weird,
use client side scripting

Member 12605293 29-Mar-17 2:57am

What should I change in this

<asp:TemplateField HeaderText="Skills">
<edititemtemplate>
<asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="true" >

<itemtemplate>
<asp:Label ID="Label4" runat="server" Text='<%#Eval("Departmentid") %>' >

<footertemplate>
<asp:DropDownList ID="DropDownList3" runat="server" OnSelectedIndexChanged="Chekddl_SelectedIndexChanged" >

protected void gvDetails_OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
DropDownList ddlDesignation = (DropDownList)e.Row.FindControl("DropDownList3");
DataTable dt = new DataTable();
cn.Open();
SqlCommand cmd = new SqlCommand("Select Departmentid,DepartmentName from Department2", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);
cn.Close();
ddlDesignation.DataSource = dt;
ddlDesignation.DataValueField = "Departmentid";
ddlDesignation.DataTextField = "DepartmentName";
ddlDesignation.DataBind();
ddlDesignation.Items.Insert(0, new ListItem("--Select--", "0"));
cn.Close();
}
DropDownList ddl = (DropDownList)e.Row.FindControl("DropDownList2");
if (ddl != null)
{
DataTable dt = new DataTable();
cn.Open();
SqlCommand cmd = new SqlCommand("Select Departmentid,DepartmentName from Department2", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
ddl.DataSource = dt;
ddl.DataValueField = "Departmentid";
ddl.DataTextField = "DepartmentName";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("--Select--", "0"));
cn.Close();
}

Member 12605293 29-Mar-17 3:07am

Hi I have thes piece of code
Label Text = (Label)e.Row.FindControl("Label4");
Text.Text = ddlDesignation.SelectedValue;

Where should I use this

Karthik_Mahalingam 29-Mar-17 3:12am

so you want to update the label in the row, when changing the drop down list

Karthik_Mahalingam 29-Mar-17 3:31am

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script>
        function change(obj) {
            debugger;
            var value = obj.value;
            var label = obj.parentElement.parentElement.getElementsByClassName('ClasslabelID1')[0];
            label.innerText = value;
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <asp:GridView ID="gv" runat="server" AutoGenerateColumns="false">
            <Columns>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:DropDownList onchange="change(this)" runat="server">
                            <asp:ListItem Value="0" Text="Select" />
                            <asp:ListItem Value="1" Text="One" />
                            <asp:ListItem Value="2" Text="Two" />
                        </asp:DropDownList>
                    </ItemTemplate> 
                </asp:TemplateField>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:Label CssClass="ClasslabelID1"   runat="server"></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>

    </form>
</body>
</html>

refer the sample and try..

Karthik_Mahalingam 29-Mar-17 3:32am

 protected void Page_Load(object sender, EventArgs e)
        {
            gv.DataSource = "1,2,3".Split(',');
            gv.DataBind();

        }

Member 12605293 29-Mar-17 3:43am

Thanks Sir

Karthik_Mahalingam 29-Mar-17 3:46am

welcome

Member 12605293 29-Mar-17 3:56am

Sir
I Have used jquery for making the dropdown Multiselect

$(function () {
        $('[id*=DropDownList3]').multiselect({
            includeSelectAllOption: true
        });
    });

<asp:TemplateField HeaderText="Skills">  
                            <EditItemTemplate>  
                                <asp:DropDownList ID="DropDownList2" runat="server"  >  
  
                                     
                                </asp:DropDownList>  
                            </EditItemTemplate>  
                            <ItemTemplate>  
                                <asp:Label ID="Label4" runat="server" Text='<%#Eval("Departmentid") %>' >  
                                </asp:Label>  
                            </ItemTemplate> 
                
                <FooterTemplate>
                            <asp:DropDownList ID="DropDownList3" runat="server" OnSelectedIndexChanged="dd1_selectedindexchanged"  >  
  
                                     
                                </asp:DropDownList> 
                            
                        </FooterTemplate> 
                        </asp:TemplateField>

Karthik_Mahalingam 29-Mar-17 4:06am

ok, then explore the Multiselect jquery plugin.

Member 12605293 29-Mar-17 4:34am

I have an issue in this

It gets post back and I am able do select only one value in ddl,It works like a radio button Sir

Karthik_Mahalingam 29-Mar-17 6:13am

ok

Member 12605293 29-Mar-17 7:05am

How to do multiple selection in this

Member 12605293 29-Mar-17 7:24am

script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<link href="http://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/css/bootstrap.min.css"
    rel="stylesheet" type="text/css" />
<script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/js/bootstrap.min.js"></script>
<link href="http://cdn.rawgit.com/davidstutz/bootstrap-multiselect/master/dist/css/bootstrap-multiselect.css" rel="stylesheet" type="text/css" />
<script src="http://cdn.rawgit.com/davidstutz/bootstrap-multiselect/master/dist/js/bootstrap-multiselect.js" type="text/javascript"></script>
<script type="text/javascript">

$(function () {
        $('[id*=DropDownList2]').multiselect({
            includeSelectAllOption: true
        });
    });

    $(function () {
        $('[id*=DropDownList3]').multiselect({
            includeSelectAllOption: true
        });
    });
</script>

<asp:TemplateField HeaderText="Skills">  
                            <EditItemTemplate>  
                                <asp:DropDownList ID="DropDownList2"  OnSelectedIndexChanged="dd2_selectedindexchanged" runat="server" >  
  
                                     
                                </asp:DropDownList>  
                            </EditItemTemplate>  
                            <ItemTemplate>  
                                <asp:Label ID="Label4" runat="server" Text='<%#Eval("Departmentid") %>' >  
                                </asp:Label>  
                            </ItemTemplate> 
                
                <FooterTemplate>
                            <asp:DropDownList ID="DropDownList3"  runat="server" OnSelectedIndexChanged="dd1_selectedindexchanged"  >  
  
                                     
                                </asp:DropDownList> 
                            
                        </FooterTemplate> 
                        </asp:TemplateField>

Karthik_Mahalingam 29-Mar-17 23:18pm

you shouldn't ask like this.

Member 12605293 29-Mar-17 23:29pm

Hi Karthik,
Sorry sir.I won't.

Richard Deeming 28-Mar-17 11:13am

Your code is vulnerable to SQL Injection[^]. NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.

Everything you wanted to know about SQL injection (but were afraid to ask) | Troy Hunt[^]
How can I explain SQL injection without technical jargon? | Information Security Stack Exchange[^]
Query Parameterization Cheat Sheet | OWASP[^]

2 solutions

Solution 1

protected void Bindmachine()
{
DataTable dt = new DataTable();
cn.Open();
SqlCommand cmd = new SqlCommand("Select * from Sample6", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataSet ds = new DataSet();
da.Fill(dt);
cn.Close();
ddlmachine.DataSource = dt;
ddlmachine.DataTextField = "CategoryName";
ddlmachine.DataValueField = "CategoryID"; //"CategoryName"; Here the column name which contains the ID should bind.
ddlmachine.DataBind();
ddlmachine.Items.Insert(0, new ListItem("--Select--"));

}
Check this code it may help you.

Posted 26-Mar-17 21:49pm

Ramesh Kumar Barik

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)

Karthik_Mahalingam · Accepted Answer · 2017-03-27T17:53:00

Solution 2

You will have to use machineid to get the value as id on selection

ddlmachine.DataValueField = "machineid";

Posted 27-Mar-17 17:53pm

Karthik_Mahalingam