944,001 Members | Top Members by Rank

Ad:
  • C# Discussion Thread
  • Unsolved
  • Views: 8912
  • C# RSS
Jul 31st, 2007
0

From database to a datagrid

Expand Post »
Hi

I want to move the data in a cartein
table to a DataGrid.

What im doing right now is using the:
dataGridView1.DataSource = dataset.Tables[0];

And its adding rows and columns automaticly according to the data base.
(including the headers)

I dont want to do it like that,
i want to design manualy the DataGrid at the beginning.
and then just put the data inside my designed
datagrid, without changing anything or add anything, and without the Headers.
(i want to make my own headers)

How can i do that ?

[im using visual c# with Pervasive.SQL 8]

Thanks.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
1qaz2wsx7 is offline Offline
17 posts
since Jul 2007
Jul 31st, 2007
0

Re: From database to a datagrid

This is a DataGrid and not a DataGridView, right? DataGrids are weird in that you have to make a table style to the grid and add columns to the table style to get what you want. DataGrids aren't a storage medium, they're a presentation tool so you can't store rows in the grid itself. What you probably want is a DataView on your table that you can use as the data source for the grid. That gives you more control over what's presented.

If possible I recommend that you move to a DataGridView for .NET 2.0. It's a lot easier to figure out and you can do more with it with less work. If it's not possible to switch, this is a good FAQ for Windows Forms in .NET 1.1 and this is an article that addresses how to use table styles and columns. It should get you started.

If you have any questions about the specifics, I'll be happy to help.
Reputation Points: 180
Solved Threads: 34
Posting Whiz
Hamrick is offline Offline
322 posts
since Jun 2007
Aug 4th, 2007
0

Re: From database to a datagrid

I will presume that you are referring to the datagridview control.(After all this is 2007)

IF you are using Visual Studio 2007 then this is how you can create your own unbound datagridview columns.

> Place a new DataGridView on the form
> Click Properties.
> Scroll to columns and click collection.
> This will fire up the column editor and you can start adding custom columns to your heart's content
Reputation Points: 19
Solved Threads: 0
Newbie Poster
nyashaC is offline Offline
19 posts
since Aug 2007
Aug 14th, 2007
0

Re: From database to a datagrid

Hi,

do you want to create DataTable manually and bind it to the datagrid. Here is the code:

#Region "buildDataTable - Building Own DataTable"

Public Function buildDataTable() As DataTable
'Instantiating DataTable object
PrivateDataTable = New DataTable("tblAccounts")

'Create table structure
PrivateDataCol = New DataColumn
PrivateDataCol.ColumnName = "AccName"
PrivateDataCol.DataType = System.Type.GetType("System.String")

'Add column to data table structure
PrivateDataTable.Columns.Add(PrivateDataCol)
'Add column to pk array
PrivateDclPrimaryKey(0) = PrivateDataCol

'Set Primary key
PrivateDataTable.PrimaryKey = PrivateDclPrimaryKey

'Add Debit column
PrivateDataCol = New DataColumn
PrivateDataCol.ColumnName = "Debit"
PrivateDataCol.DataType = System.Type.GetType("System.String")

'Add column to data table structure
PrivateDataTable.Columns.Add(PrivateDataCol)

'Add Credit column
PrivateDataCol = New DataColumn
PrivateDataCol.ColumnName = "Credit"
PrivateDataCol.DataType = System.Type.GetType("System.String")

'Add column to data table structure
PrivateDataTable.Columns.Add(PrivateDataCol)
Return PrivateDataTable
End Function

#End Region

Creating dataTable manually in Visual Basic 2005
Reputation Points: 10
Solved Threads: 0
Newbie Poster
vbsqluser is offline Offline
11 posts
since Aug 2007
Dec 23rd, 2007
0

Re: From database to a datagrid

I guess that your problem is just to change texts of the colums headers right????
Bind your dataGridView
dataGridView.dataSource = dataSource.tables[0];
but in the load event handler, u should precise what the datagridView columns header text should be
private void Form1_Load(object sender, EventArgs e)
{
dataGridView1.Columns[0].HeaderText = "Columnname0";
dataGridView1.Columns[1].HeaderText = "Columnname1";
.
.
.
dataGridView1.Columns[n].HeaderText = "Columnnamen";
}
Reputation Points: 11
Solved Threads: 16
Junior Poster
Jugortha is offline Offline
172 posts
since Oct 2007
Jan 8th, 2008
0

Re: From database to a datagrid

use this code instead if u want to change the column name of ur table which is displayed in the data grid.
C# Syntax (Toggle Plain Text)
  1. ds.Tables[0].Columns[0].ColumnName = "Name";
Use this after u give ada.fill(ds);...
Like wise you can give the name you want to the columns of the table...
Reputation Points: 10
Solved Threads: 0
Light Poster
bharathi_n_r is offline Offline
25 posts
since Jan 2008
Jan 8th, 2008
0

Re: From database to a datagrid

Click to Expand / Collapse  Quote originally posted by 1qaz2wsx7 ...
Hi

I want to move the data in a cartein
table to a DataGrid.

What im doing right now is using the:
dataGridView1.DataSource = dataset.Tables[0];

And its adding rows and columns automaticly according to the data base.
(including the headers)

I dont want to do it like that,
i want to design manualy the DataGrid at the beginning.
and then just put the data inside my designed
datagrid, without changing anything or add anything, and without the Headers.
(i want to make my own headers)

How can i do that ?

[im using visual c# with Pervasive.SQL 8]

Thanks.
by using panel
1- make apanel
2- but your datagrid inside panel
3-hide header by panel
4- inside collection of your
Reputation Points: 10
Solved Threads: 1
Newbie Poster
o_shawky is offline Offline
6 posts
since Jan 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in C# Forum Timeline: Chexk Box Validation..
Next Thread in C# Forum Timeline: Drawing Things with GDI





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC