Data Grid View without SQL dataset

Question

5.00/5 (1 vote)

See more:

VB

Can DataGridView be displayed without a dataset from a database? How is this done?

Posted 12-May-11 7:55am

TugBest

Updated 12-May-11 8:09am

wizardzz

v3

Add a Solution

5 solutions

Solution 5

Do you want to connect to database table without using System.SqlClient namespace. In my opinion not possible. If you will find it, please do tell me then.

or

Just want to bind a datagridview to your customized table (obviously without connecting to SQL) which is easily possible.

Posted 16-May-11 20:21pm

sk saini

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sk saini · Accepted Answer · 2011-05-12T09:35:00

You can bind DataGridView directly to your cutomized table, after retrieving records from database through SqlDataReader instead of DataSet, as below:

DataTable tb2 = new DataTable("Table1");
tb2.Columns.Add("id", System.Type.GetType("System.String"));
tb2.Columns.Add("Dept", System.Type.GetType("System.String"));
cmd = new SqlCommand("Select DeptGroupID, DeptGroup from Department", conn);
SqlDataReader rdr;
conn.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
    DataRow newrow = tb2.NewRow();
    newrow["id"] = rdr.GetInt32(0).ToString();
    newrow["Dept"] = rdr.GetString(1);
    tb2.Rows.Add(newrow);
}
conn.Close();
cmd.Dispose();
dataGridView2.DataSource = tb2.DefaultView;

Hope , it will be useful for you.

TweakBird · Accepted Answer · 2011-05-12T08:03:00

Solution 3

Have a look Here[^]

Posted 12-May-11 8:03am

TweakBird

wizardzz · Accepted Answer · 2011-05-12T08:03:00

Solution 2

You don't have to bind the datagrid to a source. You can add rows and columns dynamically. For example:

this.dataGridView1.Rows.Add(a, b, c);

You can also bind to a data source that is not populated via database.

Posted 12-May-11 8:03am

wizardzz

Comments

Miroxlav 3-Aug-15 13:04pm

1. Create necessary columns.
2. Add data rows with the above line of the code
3. To contine working without a dataset, refer to the following properties of your DataGridView:

* Rows to work with records
* Rows.Cells to work with record fields
* Columns to work with column definitions

Fabio V Silva · Accepted Answer · 2011-05-12T08:01:00

Solution 1

Short answer, yes, create one dataset programmatically...

Posted 12-May-11 8:01am

Fabio V Silva