data grid view

[Kawshik_itbd]

two row in my data table it shows only last row

String sql = "select Name,Gender,Course1,Course2 from Info ";
DataTable t = DataAccess.GetDataTable(sql);
for (int i = 0; i <t.Rows.Count; i++)
{
dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Column1"].Value =t.Rows[i]["Name"] ;
dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Column2"].Value =t.Rows[i]["Gender"] ;
dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Column3"].Value =t.Rows[i]["Course1"] ;
dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Column4"].Value = t.Rows[i]["Course2"];

       }

how i show all the row in gridview plz solve this prob :(

[Freak30]

This way you end up just filling the same row over and over, also it fails if there is no row in the DataGridView. I would do it that way instead:

if (dataGridView1.Rows.Count <= i)
dataGridView1.Rows.Add();
dataGridView1.Rows[i].Cells[...

The good thing about pessimism is, that you are always either right or pleasently surprised.

[Kawshik_itbd]

thank you Freak30 that means always add dataGridView1.Rows.Add()

[Lost User]

You are using the list t as the source of your index count, rather than dataGridView1, it should be:

for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
dataGridView1.Rows[i].Cells["Column1"].Value = t.Rows[0]["Address"].ToString();
}

(or similar).

Veni, vidi, abiit domum

[Kawshik_itbd]

is this right ? String sql = "select Name,Gender,Course1,Course2 from Info "; DataTable t = DataAccess.GetDataTable(sql); MessageBox.Show(Convert.ToString(dataGridView1.Rows.Count)); for (int i = 0; i <t.Rows.Count; i++) { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells["Column1"].Value = t.Rows[i]["Name"]; dataGridView1.Rows[i].Cells["Column2"].Value = t.Rows[i]["Gender"]; dataGridView1.Rows[i].Cells["Column3"].Value = t.Rows[i]["Course1"]; dataGridView1.Rows[i].Cells["Column4"].Value = t.Rows[i]["Course2"]; }

[Lost User]

Kawshik_itbd wrote:

is this right ?

It looks like it probably is; what happens when you try it? I would also ask why you are not using databinding to build your view automatically.

Veni, vidi, abiit domum

[Freak30]

Should be ok, provided you want to append every time you call this function. Else you will probably have to clear the GridControl first.

The good thing about pessimism is, that you are always either right or pleasently surprised.

[Kawshik_itbd]

it works .how i use databinding? can you gives some example of code ??

[Kawshik_itbd]

can you gives some basics about GridControl?

[Lost User]

There are lots of samples and articles around that explain databinding and how it can speed up your applications.

Veni, vidi, abiit domum

[Kawshik_itbd]

the way that i follow is n;t correct or not ??

[Lost User]

Yes, it's correct, in the sense that it does what you need, but databinding is much more powerful and you can do it with a single line of code.

Veni, vidi, abiit domum

[Kawshik_itbd]

thnaks for advice :)

[sanket164]

you can also write like this.. //this line write before for loop //with this line grid(dataGridView1) create line as per dataTable(t) dataGridView1.RowCount=t.Rows.Count for (int i = 0; i < t.Rows.Count; i++) { dataGridView1.Rows[i].Cells["Column1"].Value = t.Rows[0]["Address"].ToString(); }

[sanket164]

you can also write like this.. //this line write before for loop //with this line grid(dataGridView1) create line as per dataTable(t) dataGridView1.RowCount=t.Rows.Count for (int i = 0; i < t.Rows.Count; i++) { dataGridView1.Rows[i].Cells["Column1"].Value = t.Rows[0]["Address"].ToString(); }

[Kawshik_itbd]

it does not show the multiple it shows only first row ,if i did like for (int i = 0; i <t.Rows.Count; i++) { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells["Column1"].Value = t.Rows[i]["Name"]; dataGridView1.Rows[i].Cells["Column2"].Value = t.Rows[i]["Gender"]; dataGridView1.Rows[i].Cells["Column3"].Value = t.Rows[i]["Course1"]; dataGridView1.Rows[i].Cells["Column4"].Value = t.Rows[i]["Course2"]; } no prob occur.