Improve company productivity with a Business Account.Sign Up

x
?
Solved

Customize the column of Datagrid in VB.net

Posted on 2004-03-23
4
Medium Priority
?
549 Views
Last Modified: 2012-06-27
In the VB.net from the Database I am getting the following columns
Emp_Name, Rate_of_change and Salary

In the DataGrid I want to customize this columns as with the
following captions

Employee name
Rate of Change
Salary

correspondingly I want to set the width as

500 (for Employee name)
280 (for Rate of Change)
350 (for Salary)

Could you please let me know how to do this

Thanks
0
Comment
Question by:jra2002
4 Comments
 
LVL 15

Expert Comment

by:OMC2000
ID: 10657958
myDataGrid.TableStyles[0].GridColumnStyles[0].Width = 500
 myDataGrid.TableStyles[0].GridColumnStyles[1].Width = 280
 myDataGrid.TableStyles[0].GridColumnStyles[2].Width = 350

0
 
LVL 10

Expert Comment

by:GoodJun
ID: 10657977
right click the grid and select grid builder to customize it.
0
 
LVL 2

Expert Comment

by:HugoCode
ID: 10658236
The easiest way to change the column header would be modifying your statement.
F.e.:
Instead of
"Select [ID], description from xyz"
You can use
"Select MyColumn1=[ID], MyColumn2=description from xyz"

Thats not beautiful, but is the simplest way to solve it.
A better method would be:

Dim oTable As New DataTable("test")
Dim oRead As New SqlClient.SqlDataAdapter("Select ID, description from xyz", oCon)
oRead.Fill(oTable)
oTable.Columns(0).ColumnName = "myCol_Identifier"
oTable.Columns(1).ColumnName = "myCol_Text"
DataGrid1.DataSource = oTable

Notice that this will only work if you set the Datasource member of datagrid1 at runtime!
0
 
LVL 4

Accepted Solution

by:
Jarodtweiss earned 750 total points
ID: 10661202
As OMC2000 as said, the best way to do that is to use the TableStyles.
If you don't provide anything, .NET will build one itself, very basic.

In the designer, add a new TableStyle and then add some columns.
For this to work, you must :
- Set a name to your DataTable : myTable.Name = "MyTable"
- Set the MappingName for the Table style to your table name "MyTable"
- For each column, set the mapping name to the name of your datatables column

Then you can customize a lot : Width, readonly, maxlength, ....

Be Careful !
The settings of the table style (backcolor, ...) override the settings of the datagrid.
So you have to set your settings there !
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
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…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…

601 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