Click here to Skip to main content
15,889,808 members
Search within:


Get value from datagridView to textbox.
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
C#
LINQ
Hi.

Screensort[^]

I'm having a problem in fetching values from dgview o text box.
When i click on the image button(in gridview) it is not showing the 
panel
and not getting the values of gridview into textbox.

Here my code:

C#
protected void dg_AgentSFR_Select(Object sender, DataGridCommandEventArgs e)
       {
           resetcontrols();
           dg_AgentSFR.Visible = false;
           panel.visible=true;

           btnUpdate.Visible = true;
           btnInsert.Visible = false;
           if (e.CommandName == "SelectItem")
           {

               string SFRID = e.Item.Cells[0].Text;
               if (SFRID != "")
               {
                   using (LQTransAgentSeaFreightRateDataContext DB = new LQTransAgentSeaFreightRateDataContext())
                   {
                       TB_TransAgentSeaFreightRate_2 SFR = DB.TB_TransAgentSeaFreightRate_2s.FirstOrDefault(U => U.tASF_NUPKId == mobjGenlib.ConvertLong(SFRID));
                       TXTPOLG.Text = SFR.POL.ToString();
                       TXTPODG.Text = SFR.POD.ToString();
                       TXTForwarder.Text = SFR.Forwarder.ToString();
                       TXTForwarderReference.Text = SFR.ForwarderReference.ToString();
                       TXTShippingLine.Text = SFR.ShippingLine.ToString();
                       TXTContainerType.Text = SFR.ContainerType.ToString();
                       TXTContainerSize.Text = SFR.ContainerSize.ToString();
                       TXTValidFrom.Text = SFR.ValidFrom.ToString();
                       TXTValidTo.Text = SFR.ValidTo.ToString();
                       TXTBasicRate.Text = SFR.BasicRate.ToString();
                       TXTPAF.Text = SFR.PAF.ToString();
                       TXTCAF.Text = SFR.CAF.ToString();
                       TXTPSS.Text = SFR.PSS.ToString();
                       TXTTotalAmount.Text = SFR.TotalAmount.ToString();
                       TXTFreeDays.Text = SFR.FreeDays.ToString();
                       TXTCreditDays.Text = SFR.CreditDays.ToString();
                       TXTNITDeposit.Text = SFR.NITDeposit.ToString();
                       TXTASFID.Text = SFR.tASF_NUPKId.ToString();

                   }
               }
           }
           else if (e.CommandName == "DeleteItem")
           {
               dg_AgentSFR_Delete(sender, e);
           }
           else if (e.CommandName == "InsertItem")
           {
               dg_AgentSFR_Insert(sender, e);
           }
       }


Here all the texboxes were declated inside the panel.

aspx code:

XML
<asp:Panel ID ="PanelControl"  runat="server">
             <table>
                     <tr>
                          <td class="label" valign="top">
                             <asp:Label ID="lblPOL" runat="server" Text="POL"  meta:resourceKey="lblPOL"/>
                         </td>
                         <td>
                             <asp:TextBox ID="TXTPOLG" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                         <td class="label" valign="top">
                             <asp:Label ID="lblPOD" runat="server" Text="POD" meta:resourceKey="lblPOD"/>
                         </td>
                         <td>
                             <asp:TextBox ID="TXTPODG" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                     </tr>
                     <tr>
                          <td class="label" valign="top">
                             <asp:Label ID="lblForwarder" runat="server" Text="Forwarder" meta:resourceKey="lblForwarder"/>
                          </td>
                          <td>
                             <asp:TextBox ID="TXTForwarder" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                          </td>
                         <td class="label" valign="top">
                             <asp:Label ID="lblForwarderReference" runat="server" Text="ForwarderReference" meta:resourceKey="lblForwarderReference"/>
                         </td>
                         <td>
                             <asp:TextBox ID="TXTForwarderReference" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                     </tr>
                     <tr>
                          <td class="label" valign="top">
                             <asp:Label ID="lblShipping" runat="server" Text="Shipping" meta:resourceKey="lblShipping" />
                         </td>
                         <td>
                             <asp:TextBox ID="TXTShippingLine" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                         <td class="label" valign="top">
                             <asp:Label ID="lblContainerType" runat="server" Text="Container Type" meta:resourceKey="lblContainerType" />
                         </td>
                         <td>
                             <asp:TextBox ID="TXTContainerType" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                      </tr>
                     <tr>
                         <td class="label" valign="top">
                             <asp:Label ID="lblContainerSize" runat="server" Text="Comtainer Size" meta:resourceKey="lblContainerSize" />
                         </td>
                         <td>
                             <asp:TextBox ID="TXTContainerSize" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                         <td class="label" valign="top">
                             <asp:Label ID="lblValidFrom" runat="server" Text="Valid From" meta:resourceKey="lblValidFrom"/>
                         </td>
                         <td>
                             <asp:TextBox ID="TXTValidFrom" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                      </tr>
                     <tr>
                          <td class="label" valign="top">
                             <asp:Label ID="lblValidTo" runat="server" Text="ValidTO" meta:resourceKey="lblValidTo"/>
                         </td>
                         <td>
                             <asp:TextBox ID="TXTValidTo" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                         <td class="label" valign="top">
                             <asp:Label ID="lblBasicRate" runat="server" Text="Basic Rate" meta:resourceKey="lblBasicRate"/>
                         </td>
                         <td>
                             <asp:TextBox ID="TXTBasicRate" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                      </tr>
                     <tr>
                         <td class="label" valign="top">
                             <asp:Label ID="lblPAF" runat="server" Text="PAF" meta:resourceKey="lblPAF" />
                         </td>
                         <td>
                             <asp:TextBox ID="TXTPAF" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                          <td class="label" valign="top">
                             <asp:Label ID="lblCAF" runat="server" Text="CAF" meta:resourceKey="lblCAF"/>
                         </td>
                         <td>
                             <asp:TextBox ID="TXTCAF" runat="server" CssClass="HtmlTxt" Width="200px" ></asp:TextBox>
                         </td>
                      </tr>
                     <tr>
                        <td class="label" valign="top">
                             <asp:Label ID="lblPSS" runat="server" Text="PSS" meta:resourceKey="lblPSS"/>
                         </td>
                         <td>
                             <asp:TextBox ID="TXTPSS" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                          <td class="label" valign="top">
                             <asp:Label ID="lblTotalAmount" runat="server" Text="Total Amount" meta:resourceKey="lblTotalAmount"/>
                         </td>
                         <td>
                             <asp:TextBox ID="TXTTotalAmount" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                      </tr>
                     <tr>
                          <td class="label" valign="top">
                             <asp:Label ID="lblFreeDays" runat="server" Text="Free Days" meta:resourceKey="lblFreeDays"/>
                         </td>
                         <td>
                             <asp:TextBox ID="TXTFreeDays" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                         <td class="label" valign="top">
                             <asp:Label ID="lblCreditDays" runat="server" Text="Credit Days" meta:resourceKey="lblCreditDays"/>
                         </td>
                         <td>
                             <asp:TextBox ID="TXTCreditDays" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>
                      </tr>
                     <tr>
                          <td class="label" valign="top">
                             <asp:Label ID="lblNITDeposit" runat="server" Text="Deposit" meta:resourceKey="lblNITDeposit"/>
                         </td>
                         <td>
                             <asp:TextBox ID="TXTNITDeposit" runat="server" CssClass="HtmlTxt"  Width="200px"></asp:TextBox>
                         </td>

                         <td class="field" align="right" width="171">

                            <asp:Button CssClass="formbutton" ID="btnInsert" runat="server" TabIndex="9" Text="Insert"
                             OnClick="btnadd_Click"></asp:Button>
                         </td>
                         <td class="field" align="right" width="171">

                             <asp:Button CssClass="formbutton" ID="btnUpdate" runat="server" TabIndex="9" Text="Update"
                             OnClick="btnupdate_Click"></asp:Button>
                         </td>
                         <td class="field" align="right" width="171">

                             <asp:Button CssClass="formbutton" ID="btnExit" runat="server" TabIndex="9" Text="Cancel"
                             OnClick="btnExit_Click"></asp:Button>
                         </td>

                      </tr>

             </table>
         </asp:Panel>



please help me thanks in advance.
Posted
Updated 26-Mar-14 1:18am
v2
Add a Solution
Comments
Oshtri Deka 26-Mar-14 8:44am    
What does resetcontrols() method?
Have you debugged it? Is SFRID set to some value other than empty string?
[no name] 26-Mar-14 9:01am    
Ya reset will clear textbox values if exist. and ya it was getting the value for SFRID.
1st time when i click it load empty box ...next tim if i click another row it loads textbox with the previous click.like wise at 1st click it was loading with empty data what to do
please help me

2 solutions

I believe your problem is caused by Linq nature i.e. deffered execution (deferred vs immediate).
Try to change your data fetching code something like this:
C#
var SFR = DB.TB_TransAgentSeaFreightRate_2s.Where(YourLambaExpression)
                                           .ToList()
                                           .FirstOrDefault();

I hope this will help.
 
Share this answer
 
Posted
Comments
[no name] 27-Mar-14 0:24am    
What ever code we gave in gridview nothing fires.
For EG:

If i give as btninser.visible=false inside the protected void dg_AgentSFR_Select(Object sender, DataGridCommandEventArgs e) it is not working but if i give the same code in some other function then it fires. dont know why such problem :(
[no name] 27-Mar-14 0:39am    
Hope the problem is with my gridview but don't know how t predict.
[no name] 29-Mar-14 0:12am    
Thanks for showing interest for my question.
HI

I just added all my text box as well as gridview inside the updatepanel
and in codebehind file i added the following code:

C#
UpPanelcontrol.update();


Now it works fine.
 
Share this answer
 
Posted
Comments
Oshtri Deka 28-Mar-14 10:59am    
:)
Add a Solution

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

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
add value in datagridview from textbox
How to show datagridview value in textbox.
loading textbox value to datagridview
Multiply textbox value with datagridview cell
fetch values to textbox from datagridview
Datagridview passing values to textbox
Loading DataGridView cell value to textBox
how to compare textbox value with datagridview value
datagridview textbox column
DatagridView and TExtbox Editing

Advertise
Privacy
Cookies
Terms of Use
Last Updated 27 Mar 2014
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900