从datagridView获取值到文本框。
问题描述：
嗨。
Screensort [ ^ ]
我在抓取时遇到问题来自dgview o文本框的值。
当我点击图片按钮（在gridview中）时，它没有显示
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并没有将gridview的值放到文本框中。
这里我的代码：
and not getting the values of gridview into textbox.
Here my code:
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);
}
}
这里所有的texbox都在面板内进行了解析。
aspx代码：
Here all the texboxes were declated inside the panel.
aspx code:
<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.
please help me thanks in advance.
答
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:
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:
var SFR = DB.TB_TransAgentSeaFreightRate_2s.Where(YourLambaExpression)
.ToList()
.FirstOrDefault();
I hope this will help.
I hope this will help.
HI
I just added all my text box as well as gridview inside the updatepanel
and in codebehind file i added the following code:
HI
I just added all my text box as well as gridview inside the updatepanel
and in codebehind file i added the following code:
UpPanelcontrol.update();
Now it works fine.
Now it works fine.