data grid view

Kawshik_itbd

for (int i = 0; i < t.Rows.Count; i++)
{

       dataGridView1.Rows\[i\].Cells\["Column1"\].Value = t.Rows\[0\]\["Address"\].ToString();

   }

error occur :

index was out of range,must be non-negative and less than the
size of the collection. parameter name:index

how i solve this prob,

vonb

Kawshik_itbd wrote:

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

Change to

for (int i = 0; i

This should do it..

The signature is in building process.. Please wait...

Kawshik_itbd

if i do

for (int i = 0; i <=

t.Rows.Count-1; i++)
{
dataGridView1.Rows.Add();
dataGridView1.Rows[i].Cells["Column1"].Value ="roy";

        }</pre>

my prob is solve but i don;t add dataGridView1.Rows.Add() prog can not be execute through a exception like Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index whatever i do either t.Rows.Count-1 or t.Rows.Count
plz help what can i do

vonb

Change

...
dataGridView1.Rows[i].Cells[...
...

to

...
dataGridView1.Rows[dataGridView1.Rows.Count-1].Cells[...
...

Your counter is based on t, which is not equal to the dataGridView.

The signature is in building process.. Please wait...

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.