how to display database records on lable control..??

Question

I want to display the values from database table on lable. please suggest me for solution

Shweta Lodha · Accepted Answer

One solution to display such data is to use HTML table. Sample code: var table = new HtmlTable (); foreach ( var row in yourData ) { var tRow = new HtmlTableRow (); foreach ( var cell in row . Select ( item => new HtmlTableCell { InnerText = item })) { tRow . Cells . Add ( cell ); } table . Rows . Add ( tRow ); } Page . Controls . Add ( table );

Saurabh patil · Answer

[OrderId] INT IDENTITY (1, 1) NOT NULL, [TableId] INT NULL, [TableSeatId] INT NULL, [DepartmentId] INT NULL, [ProductId] INT NULL, [Size_Food] NVARCHAR (10) NULL, [LastUnitId] INT NULL, [Quantity] INT NULL, [TotalPrice] DECIMAL (18) NULL,   These fields i want to display.  means orderId value on one lable1.... tableid value on another lable like that way in table format

Shweta Lodha · Answer

Hi Saurabh, Please elaborate more on what kind of values and how many values you want to display. Because lable can display only 1 value at a time.