How do you change the size of a DataGrid "edit" te

Dominic51 · Apr 28, 2012

Hi, Does anybody know how you change the size of the textbox you get in a Bound Column when you "Edit" a DataGrid? I would like the textboxes to be longer if the field to be edited is long, and vice versa. Is there a way to do this, or are you stuck with a default size? Thanks for your help! JON ************************************************** ***************** THE CODE ************************************************** ***************** <%@ Page Language="VB" Debug="true" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.Oledb" %> <script language="VB" runat="server"> Dim objConn as New OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=C

ocuments and SettingsAdministratorMy DocumentsJon DocsMiscAccess emp.mdb" ) Dim ds as Dataset = New DataSet() Dim objAdapter as New OleDbDataAdapter("SELECT * FROM tblItems", objConn) Sub Page_Load(sender as object, e as eventargs) objConn.Open() objAdapter.Fill(ds, "tblItems") dg.DataSource = ds dg.DataMember = "tblItems" If Not Page.IsPostBack Then dg.Databind() End If End Sub sub dg_edit(sender as object, e as DataGridCommandEventArgs) dg.edititemindex = e.item.itemindex dg.databind() end sub sub dg_cancel(sender as object, e as DataGridCommandEventArgs) dg.edititemindex = -1 dg.databind() end sub sub dg_update(sender as object, e as DataGridCommandEventArgs) dim tbItemTitle as TextBox = e.Item.Cells(2).Controls(0) dim tbItemSummary as TextBox = e.Item.Cells(3).Controls(0) Dim strSQL As String strSQL = "UPDATE tblItems SET ItemTitle = '" & tbItemTitle.Text & "', ItemSummary = '" & tbItemSummary.Text & "' WHERE ItemID = " & e.Item.Cells(0).Text Dim objCommand as New OleDbCommand(strSQL, objConn) objCommand.ExecuteNonQuery() ds.Tables.Clear objAdapter.Fill(ds, "tblItems") dg.edititemindex = -1 dg.DataBind() end sub </script> <html><body> <form runat="server"> <asp

ataGrid id="dg" runat="server" Bordercolor="black" gridlines="vertical" font-names="Arial" font-size="10pt" cellpadding="4" cellspacing="0" width="100%" ShowFooter="True" HeaderStyle-BackColor="#cccc99" FooterStyle-BackColor="#cccc99" ItemStyle-BackColor="#ffffff" AlternatingItemStyle-Backcolor="#cccccc" AutoGenerateColumns="False" OnEditCommand="dg_edit" OnCancelCommand="dg_cancel" OnUpdateCommand="dg_update"> <Columns> <asp:BoundColumn HeaderText="ItemID" DataField="ItemID" ReadOnly="true" /> <asp:BoundColumn HeaderText="ItemType" DataField="ItemTypeID" ReadOnly="true" /> <asp:BoundColumn HeaderText="ItemTitle" DataField="ItemTitle" /> <asp:BoundColumn HeaderText="ItemSummary" DataField="ItemSummary" /> <asp:editcommandcolumn edittext="Edit" CancelText="Cancel" UpdateText="Save" HeaderText="" /> </Columns> </asp:dataGrid> </form> </body></html> You can do it in ItemCreated Although there are a lot of examples using the .Width property to set the size, that just sets the style which kind of bugs me. I usually use Attributes.Add("size", "20") instead. regards, Dave Kawliche http://AccessHelp.net http://1ClickDB.comHi David, Thanks for your answer - and excuse my ignorance - but can you show me a few lines of VB.NET code that would implement your suggestion? Thanks, JONIf it were only a "few lines of code" I would be happy to share it here. Unfortunately working with dynamically generated DataGrids can be a real pain with a lot of issues not easily explained in a short messageboard exchange. To give you a sense of this, the 1 Click DB .NET WebForm adapter uses a few hundred lines of code "behind the scenes" to just do basically what I thought the DataGrid should do "out of the box" when autogenerating columns. I am working on a series of articles for my own web site to share some the experiences and techniques I have picked up working with WebForms, especially the DataGrid. Hopefully the first one will be out later this week !! regards, Dave Kawliche http://AccessHelp.net http://1ClickDB.comHi Dave, Would be interested in seeing those articles when they come out - where would I find them? JONYou can watch this URL for the announcement : http://AccessHelp.net/news.asp regards, Dave Kawliche http://AccessHelp.net http://1ClickDB.com

How do you change the size of a DataGrid "edit" te

Dominic51

New Member