display of datatable contain issue

diamond diamond

13y1.4kVisual Basic .NET

Hi,

I have datatable, I want to display it contain, but it does not work.

void Form1_Load(object sender, EventArgs e)

{

DataClasses1DataContext dc = new DataClasses1DataContext();

var Kelihos = from n in dc.kv1s

select n;

DataTable dt = new DataTable("kelihos");

DataColumn col1 = new DataColumn("saddr", typeof(string));

dt.Columns.Add(col1);

DataColumn col2 = new DataColumn("daddr", typeof(string));

dt.Columns.Add(col2);

DataColumn col3 = new DataColumn("dur", typeof(string));

dt.Columns.Add(col3);

DataColumn col4 = new DataColumn("dport", typeof(string));

dt.Columns.Add(col4);

DataColumn col5 = new DataColumn("state", typeof(string));

dt.Columns.Add(col5);

DataColumn col6 = new DataColumn("proto", typeof(string));

dt.Columns.Add(col6);

DataColumn col7 = new DataColumn("bytes", typeof(string));

dt.Columns.Add(col7);

DataColumn col8 = new DataColumn("pkts", typeof(string));

dt.Columns.Add(col8);

DataColumn col9 = new DataColumn("stime", typeof(string));

dt.Columns.Add(col9);

DataColumn col10 = new DataColumn("ltime", typeof(string));

dt.Columns.Add(col10);

int row = 0;

foreach (var item in Kelihos)

{

dt.Rows.Add();

dt.Rows[row][0] = item.saddr.ToString().Trim();

dt.Rows[row][1] = item.daddr.ToString().Trim();

dt.Rows[row][2] = item.dport.ToString().Trim();

dt.Rows[row][3] = item.dur.ToString().Trim();

dt.Rows[row][4] = item.state.ToString().Trim();

dt.Rows[row][5] = item.proto.ToString().Trim();

dt.Rows[row][6] = item.bytes.ToString().Trim();

dt.Rows[row][7] = item.pkts.ToString().Trim();

dt.Rows[row][8] = item.stime.ToString().Trim();

dt.Rows[row][9] = item.ltime.ToString().Trim();

row++;

}

}

Please help me to write suitable code for print its contain.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Accepted answer
I think there is no record for your datacontext class. Can you set break point in your for loop and check the data?

foreach (var item in Kelihos)
{
}

Regards,
Iftikar
diamond diamond13y ago
I can see my datatable with breakpoint.
Thanks
diamond diamond13y ago
Thanks for your quick reply
Yes, I can test it but does not show nothing, For that I thought my datatable code is wrong.
Sanjeeb Lenka13y ago
take a datagrid control in your form and bind the data table to the grid.

like this

dataGridView1.DataSource = dt ;
diamond diamond13y ago
Thanks your reply.
But I want to show the contain of datatable in form.
How can I show?
Iftikar Hussain13y ago
Hi,
You need to create DataRow for each record. Try like this

DataTable dt = new DataTable("kelihos");
DataColumn col1 = new DataColumn("saddr", typeof(string));
dt.Columns.Add(col1);
DataColumn col2 = new DataColumn("daddr", typeof(string));
dt.Columns.Add(col2);
DataColumn col3 = new DataColumn("dur", typeof(string));
dt.Columns.Add(col3);
DataColumn col4 = new DataColumn("dport", typeof(string));
dt.Columns.Add(col4);
DataColumn col5 = new DataColumn("state", typeof(string));
dt.Columns.Add(col5);
DataColumn col6 = new DataColumn("proto", typeof(string));
dt.Columns.Add(col6);
DataColumn col7 = new DataColumn("bytes", typeof(string));
dt.Columns.Add(col7);
DataColumn col8 = new DataColumn("pkts", typeof(string));
dt.Columns.Add(col8);
DataColumn col9 = new DataColumn("stime", typeof(string));
dt.Columns.Add(col9);
DataColumn col10 = new DataColumn("ltime", typeof(string));
dt.Columns.Add(col10);

foreach (var item in Kelihos)
{
DataRow dataRow = dt.NewRow();
dataRow[0] = item.saddr.ToString().Trim();
dataRow[1] = item.daddr.ToString().Trim();
dataRow[2] = item.dport.ToString().Trim();
dataRow[3] = item.dur.ToString().Trim();
dataRow[4] = item.state.ToString().Trim();
dataRow[5] = item.proto.ToString().Trim();
dataRow[6] = item.bytes.ToString().Trim();
dataRow[7] = item.pkts.ToString().Trim();
dataRow[8] = item.stime.ToString().Trim();
dataRow[9] = item.ltime.ToString().Trim();
dt.Rows.Add(dataRow);
}

Regards,
Iftikar
13y ago
When you want to add rows,try

foreach (var item in Kelihos)
{

DataRow dr = dt.NewRow();
dr[0] = item.saddr.ToString().Trim();
dr[1] = item.daddr.ToString().Trim();
dr[2] = item.dport.ToString().Trim();
dr[3] = item.dur.ToString().Trim();
dr[4] = item.state.ToString().Trim();
dr[5] = item.proto.ToString().Trim();
dr[6] = item.bytes.ToString().Trim();
dr[7] = item.pkts.ToString().Trim();
dr[8] = item.stime.ToString().Trim();
dr[9] = item.ltime.ToString().Trim();
dt.Rows.Add(dr);
}

Now the datatable (dt) has all the rows from your kelihos collection.