Solved

Column width on datagrid

Posted on 2008-10-22
13
504 Views
Last Modified: 2013-12-17
I have a datagrid below. What I need is to have text box's directly above every column. How can I keep them the same width as the grid view column?
<asp:GridView ID="MyGrid" runat="server" DataKeyNames="MyType" AutoGenerateColumns="False" DataSourceID="MyDataSource" AllowPaging="True">
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <RowStyle  BackColor="#F7F6F3" ForeColor="#333333" />
            <Columns>
            <asp:CommandField ShowSelectButton="True" />
                <asp:BoundField DataField="MyType" HeaderText="MyType" SortExpression="MyType" />
                <asp:BoundField DataField="Category1" HeaderText="Category1"
                    SortExpression="Category1" />
                <asp:BoundField DataField="Category2" HeaderText="Category2"
                    SortExpression="Category2" />
</Columns>
 
</asp:GridView>

Open in new window

0
Comment
Question by:caoimhincryan
  • 7
  • 5
13 Comments
 
LVL 10

Expert Comment

by:jinn_hnnl
ID: 22774146
Hi,

You can give them the style you want, manipulate it as much as you can by setting the header  style

Do it for the column that you think it might be applied.

JINN

<Columns>
            <asp:CommandField ShowSelectButton="True" />
                <asp:BoundField DataField="MyType" HeaderText="MyType" SortExpression="MyType" >
		     <HeaderStyle Width="100px"/>
		 <asp:BoundField>    
               .....
</Columns>

Open in new window

0
 
LVL 10

Expert Comment

by:jinn_hnnl
ID: 22774175
Well, I think I misunderstood your question, you wanted to set the width of the TextBox appropriately to the Width of the column??

You will have to do it in RowDataBound event of the gridView, is that you want the textBOx inside your grid or outside? you can get in there, count column
e.Row.Cells.Count

 and on each colum you get the width of that column:
int colWidth = e.Row.Cells[index].Width

Then you find your textBox control by:
TextBox myTB = e.Row.Cells[3].FindControl("tbTextBoxID")
myTB.width = colWidth


Hope it gives you some idea

JINN


protected void gvShaders_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //.... depend on how you want to put your textbox more condition will be added and changed
        if (e.Row.RowType == System.Web.UI.WebControls.DataControlRowType.DataRow)
        {
	        /...another tracking to find row of the textBox
		 //and on each colum you get the width of that column:
		int colWidth = e.Row.Cells[index].Width
 
		//Then you find your textBox control by:
		TextBox myTB = e.Row.Cells[3].FindControl("tbTextBoxID")
		myTB.width = colWidth	
        }
}

Open in new window

0
 
LVL 16

Expert Comment

by:Gyanendra Singh
ID: 22774192
0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

Author Comment

by:caoimhincryan
ID: 22774213
I would be looking to have the textbox outside the Gridview. I will look at your solutions now.
0
 
LVL 10

Expert Comment

by:jinn_hnnl
ID: 22774233
ok then you dont have to user RowDataBound, do you know in advance how many textbox you have or you create it after the GV is binded

If so, you need a placeHolder: just play around to get the layout right the way you want it
for(int i = 0; i < myGV.Columns.Count; i++)
{
   int colWidth = myGV.Columns[i].ItemStyle.Width
   TextBox myTextBox = new TextBox();
   myTextBox.Width = colWidth;
   plhBoxes.Add(myTextBox);
}

JINN
0
 

Author Comment

by:caoimhincryan
ID: 22774271
I know how many I have in advance. How can I set the size of the textbox based on their ID.
0
 
LVL 10

Expert Comment

by:jinn_hnnl
ID: 22774296
ok, as I posted.

for example if you have this textBox
<asp:TextBox ID="tbSearchName" runat="server"/>

And the Colum: "CusName" is at index 2;
then after the gridView binding in your .cs file:
tbSearchName.Width = "200px";
or bSearchName.Width = gvShaders.Columns[1].ItemStyle.Width;

// you might wanna check the casting, it's Unit type so just play around with it

JINN


0
 

Author Comment

by:caoimhincryan
ID: 22774299
My column 1 would have corresponding textbox myTextbox1,
column 2 would have corresponding textbox myTextbox2, etc etc..
0
 
LVL 10

Expert Comment

by:jinn_hnnl
ID: 22774323
myTextbox1.Width = mygv.Columns[1].ItemStyle.Width;

JINN
0
 

Author Comment

by:caoimhincryan
ID: 22775955
That doesnt seem to work for me now.

Im actually thinking of now trying to have the textboxes inside my grid. Is that what you have above?
0
 
LVL 10

Expert Comment

by:jinn_hnnl
ID: 22776224
WHere do you put this?
myTextbox1.Width = mygv.Columns[1].ItemStyle.Width;

You have to make sure you set this after the GirdView has already been binded. If you want to put the boxes inside the gridView, it's different story, quite tricky I assume (because you only want 1 box for each column)

JINN
0
 

Author Comment

by:caoimhincryan
ID: 22786258
I put it like below and as i step through it, colWidth  = 0 all the time..

Any ideas?

protected void LabourCostsGrid_DataBound(object sender, EventArgs e)
        {
            for(int i = 0; i < LabourCostsGrid.Columns.Count; i++)
            {
                double colWidth = LabourCostsGrid.Columns[i].ItemStyle.Width.Value;
            }
 
        }

Open in new window

0
 
LVL 10

Accepted Solution

by:
jinn_hnnl earned 500 total points
ID: 22794123
That doesn't make sense to me why it returns 0 there.

WHat I can guess is, the GridView finished binding data, but hasn't got it form which leads to the default column width = 0; Have you debugged and check if the data is there in the gridview by the time you get the width? (should be)

1 workaround is moving that part of code to PreRender, which has later execution state in the page life circle

Check the colwidth by that time then.

JINN

protected override void OnPreRender(EventArgs e)
{
    base.OnPreRender(e);
    for(int i = 0; i < LabourCostsGrid.Columns.Count; i++)
            {
                double colWidth = LabourCostsGrid.Columns[i].ItemStyle.Width.Value;
            }
}

Open in new window

0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now