how to binddata(specific column) from gridview to drowdown list in asp.net through script or ajax

Question

0.00/5 (No votes)

See more:

me have 5 columns and one of them is Business id when i bind data to control all bind but drowdown list ones are not bind.can any one give any suggession or simple idea.i have try on many ways but not complete my task .and same situation with chekbox also want help for chek box
my code are below

C#

<script>
       function EditRecord(Aid,Aaid,Bid,TAmount,APaid,ABalance,Tdate,Fmonth,Fyear,Gobserverd,Rmark) {
           $('[id$="hfAccount"]').val(Aid);
           $('[id$="AccountId"]').val(Aaid);
           //this is dropdown list...//
           $('[id$="ddlBusiness"]').val(Bid);
           $('[id$="txtTotalAmount"]').val(TAmount);
           $('[id$="txtAmountPaid"]').val(APaid);
           $('[id$="txtAmountBalance"]').val(ABalance);
           $('[id$="txtTransactionDate"]').val(Tdate);
           $('[id$="txtForMonth"]').val(Fmonth);
           $('[id$="txtForYear"]').val(Fyear);
           $('[id$="txtGestureObserved"]').val(Gobserverd);
           $('[id$="txtRemarks"]').val(Rmark);
           $('[id$="btnUpdate"]').removeAttr("disabled");
          }

   </script

XML

<asp:TemplateField  HeaderText="Edit">
               <ItemTemplate>
                   <a style="cursor:pointer" onclick="EditRecord('<%#Eval("AccountId")%>','<%#Eval("AccountId")%>','<%#Eval("BusinessTitle")%>','<%#Eval("TotalAmount")%>','<%#Eval("AmountPaid")%>','<%#Eval("AmountBalance")%>','<%#  Convert.ToDateTime(Eval("TransactionDate")).ToShortDateString()%>','<%#Eval("ForMonth")%>','<%#Eval("ForYear")%>','<%#Eval("GestureObserved")%>','<%#Eval("Remarks")%>')"><img id="imgEdit" src="Images/edit2.ico" alt="Edit"/>
               </ItemTemplate>
           </asp:TemplateField>

when i click this button all data are bind with controls except ddlBusiness

Posted 6-May-14 1:23am

Mian Sahib Jan

Updated 6-May-14 1:43am

v2

Add a Solution

Comments

DamithSL 6-May-14 7:28am

explain issue with code sample, include your aspx and code behind related codes.

Mian Sahib Jan 6-May-14 7:38am

ok

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 6-May-14 8:17am

Where is the DropDownList in the Markup?

Mian Sahib Jan 6-May-14 8:59am

'<%#Eval("BusinessTitle")%>'

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 6-May-14 13:17pm

Okay, now put a debugger inside the function EditRecord and see if the BusinessTitle parameter is coming correctly or not.

Mian Sahib Jan 6-May-14 14:41pm

ok thanks alot .i have solved

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 6-May-14 14:53pm

Please add one solution explaining how exactly you solved it. That would be useful for visitors here. Else just reply me here and I will add a answer for that.

Mian Sahib Jan 6-May-14 15:02pm

ok.i send the all code to you.
<script>
function EditRecord(Aid,Aaid,Bid,TAmount,APaid,ABalance,Tdate,Fmonth,Fyear,Gobserverd,Rmark) {
$('[id$="hfAccount"]').val(Aid);
$('[id$="AccountId"]').val(Aaid);
//this is dropdown list...//
$('[id$="ddlBusiness"]').val(Bid);
$('[id$="txtTotalAmount"]').val(TAmount);
$('[id$="txtAmountPaid"]').val(APaid);
$('[id$="txtAmountBalance"]').val(ABalance);
$('[id$="txtTransactionDate"]').val(Tdate);
$('[id$="txtForMonth"]').val(Fmonth);
$('[id$="txtForYear"]').val(Fyear);
$('[id$="txtGestureObserved"]').val(Gobserverd);
$('[id$="txtRemarks"]').val(Rmark);
$('[id$="btnUpdate"]').removeAttr("disabled");
}

</script>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div id="mainDiv" style="margin:1%;"><div><label id="lblMessage" runat="server" class="alert-success" style="margin-left:430px;"></label></div>
<asp:HiddenField ID="hfAccount" runat="server" />
<div id="formData">
<table class="tblform" style="width:800px; margin-left:164px" >

<tr>
<td style="width:150px;height:20px;text-align:center;margin:4px;">
<asp:Label ID="lblAccountId" runat="server" Text="Accout Id" Width="150px" Height="18">
</td>
<td style="width:200px;height: 60px;">

<asp:TextBox ID="txtAccountId" CssClass="form-control" Width="200px" runat="server" Height="40" Font-Size="Larger" ReadOnly="True">

</td>
<td style="width:150px;height:20px;text-align:center;margin:4px;">
<asp:Label ID="lblBusinesId" runat="server" Text="Business Id" Width="150" Height="18">
</td>
<td style="width:200px;height: 60px;">
<asp:DropDownList ID="ddlBusiness" CssClass="form-control" Width="200px" runat="server" Height="40" Font-Size="Larger">
</td>

</tr>
<tr>
<td style="width:150px;height:20px;text-align:center;margin:4px;">
<asp:Label ID="lblTotalAmount" runat="server" Text="Total Amount" Width="150px" Height="18">
</td>
<td style="width:200px;height: 60px;">
<asp:TextBox ID="txtTotalAmount" CssClass="form-control" Width="200px" runat="server" Height="40" Font-Size="Larger">
</td>
<td style="width:150px;height:20px;text-align:center;margin:4px;">
<asp:Label ID="lblAmountPaid" runat="server" Text="Amount Paid" Width="150px" Height="18">
</td>
<td style="width:200px;height: 60px;">
<asp:TextBox ID="txtAmountPaid" CssClass="form-control" Width="200px" runat="server" Height="40" Font-Size="Larger">
</td>
</tr>
<tr>
<td style="width:150px;height:20px;text-align:center;margin:4px;">
<asp:Label ID="lblAmountBalance" runat="server" Text="Amount Balance" Width="150px" Height="18">
</td>
<td style="width:200px;height: 60px;">
<asp:TextBox ID="txtAmountBalance" CssClass="form-control" Width="200px" runat="server" Height="40" Font-Size="Larger">
</td>
<td style="width:150px;height:20px;text-align:ce

Mian Sahib Jan 6-May-14 15:05pm

this is the complete code when i click edit btn the values goes to the controls and after that i can update eaisly.ok thanks alot to all and Tadit Dash

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 6-May-14 22:43pm

The function seems the same. What did you change?

Mian Sahib Jan 7-May-14 2:23am

me only chnge the database view and the edit btn i send the id to control and the grid i shown the businessTitle.so when i click the edit btn it send the id to dropdown list and the dropdownlist have already fill from dataset when the id goes to dropdown list the businessTitle of this is are shown to me.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 7-May-14 2:58am

I have added one answer. Please accept that. :)

Thanks,
Tadit

3 solutions

Solution 1

C#

 protected void grdReview_RowDataBound(object sender, GridViewRowEventArgs e)
        {
           
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                DropDownList ddlId= (DropDownList)e.Row.FindControl("ddl");
//Here write your code to fill dropdownlist
                ddlID.DataSource=ds;
                ddlID.DataBound();

            }
   }

Posted 6-May-14 1:38am

MNamrata

Comments

Mian Sahib Jan 6-May-14 7:48am

this is good but i want to click the button or icon in gridview and all the data are bound me post my code that bind all data with control but problem with dropdown list which not bind

Mian Sahib Jan 6-May-14 14:42pm

thanks to all who share their knowlege and suggesition with us.my problem are solved

Solution 2

try this..

Button_OnClick()
{

Button btn=(Button)sender;
GridViewRow r=(GridviewRow)btn.parent.parent;
DropDownList ddlId= (DropDownList)r.FindControl("ddl");
//Here write your code to fill dropdownlist
ddlID.DataSource=ds;
ddlID.DataBound();
}

Posted 6-May-14 1:56am

MNamrata

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2014-05-06T20:58:00

Below is the revised version of the OP's reply...

"I only changed the database view/DataSource.

In the Edit Button click, I send the id of the control and the Grid showing the businessTitle.
So, when I click the edit button, it sends the id of DropDownList and the DropDownList have been already filled from DataSet. When the DropDownList id goes, before that the businessTitle are already populated on that."

My Conclusion

So, basically the issue was with the popuation of the DropDownList Data, which got fixed by doing modification to the DataSource.