How to display a single row in asp.net web forms?

Question

I ask myself how I can display a single row from a datatable object in a control like a gridview.

I already did it with label objects like here: (this is in load event. I already have buttons which increment the zero and decrement)

 Tbname.Text = (dset.Tables("coduta").Rows(0).Item("Firma"))
        TbStraße.Text = (dset.Tables("coduta").Rows(0).Item("Straße_Firma"))
        TbHausnummer.Text = (dset.Tables("coduta").Rows(0).Item("Hausnummer_Firma"))
        TbOrt.Text = (dset.Tables("coduta").Rows(0).Item("Ort_Firma"))

the point is I want to show the specific row in something like a gridview control. The only Idea i have is, to create a new table out of the row and that looks like a too complicated way for this. I hope guys can help

cheers steven

so the point is you want to get first row of datatable into another datatable?? — Jahangeer
– Jahangeer, Commented Aug 21, 2015 at 7:11
No I want to display the first row in a gridview or a similar control. when I click the next button I want to display the next row. — steve
– steve, Commented Aug 21, 2015 at 7:18

Imad · Accepted Answer · 2015-08-21 07:28:00Z

1

I am from C# background but this approach should help you.

Get first row from existing table.
Make clone of existing table.
Add that row to clone table.

Assign that table as datasource for grid

DataRow dr = dset.Tables("coduta").Rows(0); 
DataTable dtNew = dset.Tables("coduta").Clone();
dtNew.Rows.Add(dr.ItemArray);
grid.DataSource = dtNew;
grid.DataBind();

answered Aug 21, 2015 at 7:28

Imad

7,51014 gold badges64 silver badges124 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

steve Over a year ago

does clone only clone the scheme?

Imad Over a year ago

yes. With contraints and no data is copied. try it.

steve Over a year ago

This is how I do it now. It is not what I wish to archive but it works. Cheers and thx

Jahangeer · Accepted Answer · 2015-08-21 10:42:14Z

0

try

da = new SqlDataAdapter();
DataSet ds = new DataSet();
DataTable dt = new DataTable();

da.SelectCommand = new SqlCommand(@"SELECT * FROM coduta", connString);
da.Fill(ds, "coduta");
dt = ds.Tables["coduta"];

foreach (DataRow dr in dt.Rows)
{
    //here is your row of data
}

answered Aug 21, 2015 at 10:42

Jahangeer

4781 gold badge7 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to display a single row in asp.net web forms?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related