我已经在我的asp.net页面上放置了一个gridview,并且正在使用sql调用来获取数据源。在sql调用中,它为所有字段(姓名、地址、电话、类型)带来数据。在gridview中,有2个字段(phone, type)在编辑期间需要成为模板字段而不是绑定字段,以及Item模板中的文本框或标签(无论哪个)。
当我运行代码时,数据网格完成并填充-减去电话或类型字段(模板字段)的信息。我如何绑定字段,使信息将正确显示。我已经包含了我的代码
任何帮助都将非常感激。提前感谢!
GRIDVIEW: <asp:GridView ID="gvMTM" runat="server" AllowPaging="True" DataKeyNames="MTMID"
AutoGenerateColumns="False" AutoGenerateEditButton="True"
OnRowEditing="gvMTM_RowEditing"
OnRowUpdating="gvMTM_UpdateRowEditing"
OnRowCancelingEdit="gvMTM_CancelRowEditing" >
<Columns>
<asp:BoundField DataField="MTMID" HeaderText="ID" />
<asp:BoundField DataField="MTMName" HeaderText="Name" />
<asp:BoundField DataField="Add1" HeaderText="Add1" />
<asp:BoundField DataField="Add2" HeaderText="Add2" />
<asp:BoundField DataField="City" HeaderText="City" />
<asp:BoundField DataField="ST" HeaderText="ST" />
<asp:BoundField DataField="Zip" HeaderText="Zip" />
<asp:BoundField DataField="Email" HeaderText="Email" />
<asp:TemplateField HeaderText="Phone#">
<EditItemTemplate>
<asp:TextBox ID="txtPhoneEdit" runat="server"></asp:TextBox>
<asp:MaskedEditExtender ID="TemptxtPhone_MaskedEditExtender" runat="server"
CultureAMPMPlaceholder="" CultureCurrencySymbolPlaceholder=""
CultureDateFormat="" CultureDatePlaceholder="" CultureDecimalPlaceholder=""
CultureThousandsPlaceholder="" CultureTimePlaceholder="" Enabled="True"
TargetControlID="TemptxtPhone">
</asp:MaskedEditExtender>
</EditItemTemplate>
<ItemTemplate>
<asp:TextBox ID="txtPhoneRead" runat="server" BorderStyle="None"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="RR">
<EditItemTemplate>
<asp:DropDownList ID="ddRREdit" runat="server" Height="16px" Width="100px" DataTextField="Railroad" DataValueField="RRID">
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:TextBox ID="txtRRRead" runat="server" BorderStyle="None"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
on .CS page:
gvMTM.DataSource = code.GetMTMList();
gvMTM.DataBind();
SQL调用 public DataTable GetMTMList()
{
try
{
SQLCON = new SqlConnection(connectionString);
SQLCON.Open();
SQLCmd = new SqlCommand("spGetMTMList", SQLCON);
SQLCmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adapter = new SqlDataAdapter(SQLCmd);
DataTable Detailtable = new DataTable();
adapter.Fill(Detailtable);
return Detailtable;
}
catch (Exception ex)
{
HttpContext.Current.Response.Redirect("~/ErrorRedirect.aspx?" + ex.Message, false);
return null;
}
finally
{
SQLCON.Close();
}
}
使用
Text='<%# Eval("phone") %>'
你需要加上这个:
<ItemTemplate>
<asp:TextBox ID="txtPhoneRead" runat="server" Text='<%# Eval("phone") %>'>
</asp:TextBox>
</ItemTemplate>
Eval()
方法将数据源中的数据绑定到Text
属性
你可以看看他的帖子了解更多信息
注意考虑将<ItemTemplate>
中的TextBox
控制更改为asp:Label
应该是这样的:
<ItemTemplate>
<asp:Label ID="txtPhoneRead" runat="server" Text='<%# Eval("Phone") %>'>
</asp:Label>
</ItemTemplate>