在编辑模式GridBoundColumn中更改文本框的大小 [英] Change size of textbox in Edit mode GridBoundColumn

问题描述

你好



i使用绑定字段和sqlData Source绑定的网格视图但是当我尝试编辑它时显示我的文本框，我想要多行文本框我应该怎么做对于它？



代码是

hello

i use grid view which bind by bound fields and sqlData Source but when i try to edit it show me textbox and i want multiline textbox what should i do for it ?

mt code is

<asp:GridView ID="grdNews" runat="server" align="center" AutoGenerateColumns="False" CellPadding="6" ForeColor="#333333" GridLines="None" Width="100%" AllowPaging="True" AllowSorting="True" DataKeyNames="AutoID" DataSourceID="SqlDataSource_sendbox">
                <RowStyle BackColor="#F7F6F3" ForeColor="#333333" HorizontalAlign="Left" />
                <EmptyDataTemplate>
                    No Message for you...
                </EmptyDataTemplate>
                <Columns>
                    <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                    <asp:BoundField DataField="AutoID" HeaderText="AutoID" InsertVisible="False" ReadOnly="True" SortExpression="AutoID" Visible="False" />
                    <asp:BoundField DataField="NewsDetails" HeaderText="NewsDetails" SortExpression="NewsDetails"  />
                     
                    <asp:BoundField DataField="DateOfCreate" HeaderText="DateOfCreate" SortExpression="DateOfCreate" />
                    <asp:BoundField DataField="Priority" HeaderText="Priority" SortExpression="Priority" />
                    <asp:CheckBoxField DataField="IsActive" HeaderText="IsActive" SortExpression="IsActive" />
                </Columns>
               
                <FooterStyle BackColor="#00A3D9" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="#00A3D9" ForeColor="White" HorizontalAlign="Center" Font-Bold="True" Font-Underline="true" />
                <SelectedRowStyle BackColor="#D6F7FF" Font-Bold="True" ForeColor="#333333" />
                <HeaderStyle BackColor="#00A3D9" Font-Bold="True" ForeColor="White" HorizontalAlign="Left" />
                <EditRowStyle BackColor="#D6F7FF" HorizontalAlign="Left" />
                <AlternatingRowStyle BackColor="White" ForeColor="#284775" HorizontalAlign="Left" />
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource_sendbox" runat="server" ConnectionString="<%$ ConnectionStrings:MLMConn %>" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [News] WHERE [AutoID] = @original_AutoID AND (([NewsDetails] = @original_NewsDetails) OR ([NewsDetails] IS NULL AND @original_NewsDetails IS NULL)) AND (([DateOfCreate] = @original_DateOfCreate) OR ([DateOfCreate] IS NULL AND @original_DateOfCreate IS NULL)) AND (([Priority] = @original_Priority) OR ([Priority] IS NULL AND @original_Priority IS NULL)) AND (([IsActive] = @original_IsActive) OR ([IsActive] IS NULL AND @original_IsActive IS NULL))" InsertCommand="INSERT INTO [News] ([NewsDetails], [DateOfCreate], [Priority], [IsActive]) VALUES (@NewsDetails, @DateOfCreate, @Priority, @IsActive)" OldValuesParameterFormatString="original_{0}"

                SelectCommand="SELECT * FROM [News]" UpdateCommand="UPDATE [News] SET [NewsDetails] = @NewsDetails, [DateOfCreate] = @DateOfCreate, [Priority] = @Priority, [IsActive] = @IsActive WHERE [AutoID] = @original_AutoID AND (([NewsDetails] = @original_NewsDetails) OR ([NewsDetails] IS NULL AND @original_NewsDetails IS NULL)) AND (([DateOfCreate] = @original_DateOfCreate) OR ([DateOfCreate] IS NULL AND @original_DateOfCreate IS NULL)) AND (([Priority] = @original_Priority) OR ([Priority] IS NULL AND @original_Priority IS NULL)) AND (([IsActive] = @original_IsActive) OR ([IsActive] IS NULL AND @original_IsActive IS NULL))">
                <DeleteParameters>
                    <asp:Parameter Name="original_AutoID" Type="Int32" />
                    <asp:Parameter Name="original_NewsDetails" Type="String" />
                    <asp:Parameter Name="original_DateOfCreate" Type="DateTime" />
                    <asp:Parameter Name="original_Priority" Type="Int32" />
                    <asp:Parameter Name="original_IsActive" Type="Boolean" />
                </DeleteParameters>
                <UpdateParameters>
                    <asp:Parameter Name="NewsDetails" Type="String" />
                    <asp:Parameter Name="DateOfCreate" Type="DateTime" />
                    <asp:Parameter Name="Priority" Type="Int32" />
                    <asp:Parameter Name="IsActive" Type="Boolean" />
                    <asp:Parameter Name="original_AutoID" Type="Int32" />
                    <asp:Parameter Name="original_NewsDetails" Type="String" />
                    <asp:Parameter Name="original_DateOfCreate" Type="DateTime" />
                    <asp:Parameter Name="original_Priority" Type="Int32" />
                    <asp:Parameter Name="original_IsActive" Type="Boolean" />
                </UpdateParameters>
                <InsertParameters>
                    <asp:Parameter Name="NewsDetails" Type="String" />
                    <asp:Parameter Name="DateOfCreate" Type="DateTime" />
                    <asp:Parameter Name="Priority" Type="Int32" />
                    <asp:Parameter Name="IsActive" Type="Boolean" />
                </InsertParameters>
            </asp:SqlDataSource>

推荐答案

ConnectionStrings：MLMConn％> ConflictDetection = CompareAllValues DeleteCommand = DELETE FROM [News] WHERE [AutoID] = @original_AutoID AND（（[NewsDetails] = @original_NewsDetails）OR（[NewsDetails] I S NULL AND @original_NewsDetails IS NULL））AND（（[DateOfCreate] = @original_DateOfCreate）OR（[DateOfCreate] IS NULL AND @original_DateOfCreate IS NULL））AND（（[Priority] = @original_Priority）OR（[Priority] IS NULL AND @original_Priority IS NULL））AND（（[IsActive] = @original_IsActive）OR（[IsActive] IS NULL和@original_IsActive IS NULL）） InsertCommand = INSERT INTO [新闻]（[NewsDetails] ，[DateOfCreate]，[Priority]，[IsActive]）VALUES（@ NewsDetails，@ DateOfCreate，@ Priority，@ IsActive） OldValuesParameterFormatString = original_ {0}

< span class =code-attribute> SelectCommand = SELECT * FROM [News] UpdateCommand = 更新[新闻] SET [NewsDetails] = @NewsDetails，[DateOfCreate] = @DateOfCreate，[Priority] = @Priority，[IsActive] = @IsActive WHERE [AutoID] = @original_AutoID AND（（[NewsDetails] = @original_NewsDetails）或（[NewsDetails] IS NULL AND @original_NewsDetails IS NULL））AND（（[DateOfCreate] = @original_DateOfCreate）OR（[DateOfCreate] IS NULL AND @orinalinal_DateOfCreate IS NULL））AND（（[Priority] = @original_Priority）OR（[优先级] IS NULL和@original_Priority IS NULL））AND（（[IsActive] = @original_IsActive）OR（[IsActive] IS NULL和@original_IsActive IS NULL）） >
< DeleteParameters >
< asp：参数 Name=\"original_AutoID \" Type=\" Int32\" />
<asp:Parameter Name=\"original_NewsDetails\" Type=\"String\" />
<asp:Parameter Name=\"original_DateOfCreate\" Type=\"DateTime\" />
<asp:Parameter Name=\"original_Priority\" Type=\"Int32\" />
<asp:Parameter Name=\"original_IsActive\" Type=\"Boolean\" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name=\"NewsDetails\" Type=\"String\" />
<asp:Parameter Name=\"DateOfCreate\" Type=\"DateTime\" />
<asp:Parameter Name=\"Priority\" Type=\"Int32\" />
<asp:Parameter Name=\"IsActive\" Type=\"Boolean\" />
<asp:Parameter Name=\"original_AutoID\" Type=\"Int32\" />
<asp:Parameter Name=\"original_NewsDetails\" Type=\"String\" />
<asp:Parameter Name=\"original_DateOfCreate\" Type=\"DateTime\" />
<asp:Parameter Name=\"original_Priority\" Type=\"Int32\" />
<asp:Parameter Name=\"original_IsActive\" Type=\"Boolean\" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name=\"NewsDetails\" Type=\"String\" />
<asp:Parameter Name=\"DateOfCreate\" Type=\"DateTime\" />
<asp:Parameter Name=\"Priority\" Type=\"Int32\" />
<asp:Parameter Name=\"IsActive\" Type=\"Boolean\" />
</InsertParameters>
</asp:SqlDataSource>

ConnectionStrings:MLMConn %>" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [News] WHERE [AutoID] = @original_AutoID AND (([NewsDetails] = @original_NewsDetails) OR ([NewsDetails] IS NULL AND @original_NewsDetails IS NULL)) AND (([DateOfCreate] = @original_DateOfCreate) OR ([DateOfCreate] IS NULL AND @original_DateOfCreate IS NULL)) AND (([Priority] = @original_Priority) OR ([Priority] IS NULL AND @original_Priority IS NULL)) AND (([IsActive] = @original_IsActive) OR ([IsActive] IS NULL AND @original_IsActive IS NULL))" InsertCommand="INSERT INTO [News] ([NewsDetails], [DateOfCreate], [Priority], [IsActive]) VALUES (@NewsDetails, @DateOfCreate, @Priority, @IsActive)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [News]" UpdateCommand="UPDATE [News] SET [NewsDetails] = @NewsDetails, [DateOfCreate] = @DateOfCreate, [Priority] = @Priority, [IsActive] = @IsActive WHERE [AutoID] = @original_AutoID AND (([NewsDetails] = @original_NewsDetails) OR ([NewsDetails] IS NULL AND @original_NewsDetails IS NULL)) AND (([DateOfCreate] = @original_DateOfCreate) OR ([DateOfCreate] IS NULL AND @original_DateOfCreate IS NULL)) AND (([Priority] = @original_Priority) OR ([Priority] IS NULL AND @original_Priority IS NULL)) AND (([IsActive] = @original_IsActive) OR ([IsActive] IS NULL AND @original_IsActive IS NULL))"> <DeleteParameters> <asp:Parameter Name="original_AutoID" Type="Int32" /> <asp:Parameter Name="original_NewsDetails" Type="String" /> <asp:Parameter Name="original_DateOfCreate" Type="DateTime" /> <asp:Parameter Name="original_Priority" Type="Int32" /> <asp:Parameter Name="original_IsActive" Type="Boolean" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="NewsDetails" Type="String" /> <asp:Parameter Name="DateOfCreate" Type="DateTime" /> <asp:Parameter Name="Priority" Type="Int32" /> <asp:Parameter Name="IsActive" Type="Boolean" /> <asp:Parameter Name="original_AutoID" Type="Int32" /> <asp:Parameter Name="original_NewsDetails" Type="String" /> <asp:Parameter Name="original_DateOfCreate" Type="DateTime" /> <asp:Parameter Name="original_Priority" Type="Int32" /> <asp:Parameter Name="original_IsActive" Type="Boolean" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="NewsDetails" Type="String" /> <asp:Parameter Name="DateOfCreate" Type="DateTime" /> <asp:Parameter Name="Priority" Type="Int32" /> <asp:Parameter Name="IsActive" Type="Boolean" /> </InsertParameters> </asp:SqlDataSource>

Follow the code below:

Follow the code below:

<EditItemTemplate>
 <asp:textbox id="txt" runat="server" text="<%# Bind("your field") %>" TextMode="MultiLine" Width="20px"> </asp:textbox>
</EditItemTemplate>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowCancelingEdit="GridView1_RowCancelingEdit"

                                OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" CssClass="GridView">
                                <Columns>
                                    <asp:TemplateField HeaderText="Username" HeaderStyle-HorizontalAlign="Center">
                                        <ItemTemplate>
                                            <asp:Label ID="lblid1" runat="server" Text='<%# Bind("uname") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Code" HeaderStyle-HorizontalAlign="Center">
                                        <ItemTemplate>
                                            <asp:Label ID="lblid2" runat="server" Text='<%# Bind("code") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Department" HeaderStyle-HorizontalAlign="Center">
                                        <ItemTemplate>
                                            <asp:Label ID="lblid3" runat="server" Text='<%# Bind("dept") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Joining Date" HeaderStyle-HorizontalAlign="Center">
                                        <ItemTemplate>
                                            <asp:Label ID="lblid4" runat="server" Text='<%# Bind("jdate","{0:dd/MM/yy}") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="CL" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Left">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtcl" runat="server" Text='<%# Bind("cl") %>' Width="20px"></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="lblcl" runat="server" Text='<%# Bind("cl") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="SL" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Left">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtSL" runat="server" Text='<%# Bind("sl") %>' Width="20px"></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="lblSL" runat="server" Text='<%# Bind("sl") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="HL" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Left">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txthl" runat="server" Text='<%# Bind("hl") %>' Width="20px"></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="lblhl" runat="server" Text='<%# Bind("hl") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="ML" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Left">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtml" runat="server" Text='<%# Bind("ml") %>' Width="20px"></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="lblml" runat="server" Text='<%# Bind("ml") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="PL" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Left">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtpl" runat="server" Text='<%# Bind("pl") %>' Width="20px"></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="lblpl" runat="server" Text='<%# Bind("pl") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:CommandField HeaderText="Action" ShowEditButton="True" ItemStyle-HorizontalAlign="Left"

                                        ButtonType="Button">
                                        <ControlStyle CssClass="btn" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:CommandField>
                                </Columns>
                            </asp:GridView>

<edititemtemplate>
                           <asp:textbox id="txtNews" runat="server" text="<%# Bind("NewsDetails") %>" textmode="MultiLine" height="80px" width="250px" xmlns:asp="#unknown"></asp:textbox>
                           <asp:requiredfieldvalidator id="RequiredFieldValidator2" runat="server" errormessage="*" controltovalidate="txtNews" xmlns:asp="#unknown"></asp:requiredfieldvalidator>
                       </edititemtemplate>
                       <itemtemplate>
                           <asp:label id="lblnews" runat="server" text="<%# Bind("NewsDetails") %>" xmlns:asp="#unknown"></asp:label>
                       </itemtemplate>

try this one for my code re. ’’Rohan Leuva ans’’

try this one for my code re. ''Rohan Leuva ans''

这篇关于在编辑模式GridBoundColumn中更改文本框的大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！