how to create dynamic table depending on values in database table

Question

0.00/5 (No votes)

See more:

i am having an oracle table in which one of the value is the amount received from cashier i have to submit the account details. For example if i receive 5000 rs i have to mentioned in details the expenditure for the amount of 5000/-rs i have create the addtional row depending on the balance

Posted 21-Aug-12 19:02pm

asok6783

Add a Solution

Comments

pradiprenushe 22-Aug-12 1:26am

not clear

asok6783 22-Aug-12 1:50am

i want to create a row in ui on a button click event depending the value on the db table until it becomes zero

[no name] 22-Aug-12 1:29am

make question clear plz whether u need to create in db or create in UI?

asok6783 22-Aug-12 1:49am

i want to create a row in ui on a button click event depending the value on the db table until it becomes zero

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**AmitGajjar** · Answer 1 · 2012-08-21T19:42:00

Solution 1

Hi,

Have a look at MSDN Article[^]

You can create any server control or html control dynamically. You can also add your dynamically created control in your page. you only need to create an instance of that control and add in the page with data.

Good luck.

Thanks
-Amit Gajajr

Posted 21-Aug-12 19:42pm

AmitGajjar

ridoy · Answer 2 · 2012-08-21T20:02:00

Have a look these links..you will have an idea how to create dynamic table depending on database values.
http://www.aspdotnet-suresh.com/2012/07/aspnet-save-dynamically-created-control.html[^]
http://www.dotnetcurry.com/ShowArticle.aspx?ID=135[^]
http://stackoverflow.com/questions/9835209/creating-a-dynamic-custom-datagrid-using-table-and-label[^]

Career Web Helper · Answer 3 · 2012-08-21T20:47:00

Take html table control on .aspx page and write below code on .cs page.

C#

DataTable DT = new DataTable();
//Your DT biding code goes here 
            HtmlTableRow TR;
            HtmlTableCell TD;
 //You can Iterate loop here to check ur logic i.e.until the value becomes zero
            if (DT.Rows.Count>0)
            {
            TR = new HtmlTableRow();
            TD = new HtmlTableCell();
            TD.InnerHtml = " Branch Code";
            TD.Align = "Left";
            TD.Style[HtmlTextWriterStyle.FontSize] = "11px"; 
            TR.Cells.Add(TD);
            tblRpt.Rows.Add(TR);
 
            TD = new HtmlTableCell();
            TD.InnerHtml = " Branch Name";
            TD.Align = "Left";
            TD.Style[HtmlTextWriterStyle.FontSize] = "11px";
            TR.Cells.Add(TD);
            tblRpt.Rows.Add(TR);
 
 
            TD = new HtmlTableCell();
            TD.InnerHtml = " Branch State";
            TD.Align = "Left";
            TD.Style[HtmlTextWriterStyle.FontSize] = "11px";
            TR.Cells.Add(TD);
            tblRpt.Rows.Add(TR); 
        }

Thanks!!!
Happy Codeing!!!!! :)

Karthik J, Coimbatore · Answer 4 · 2012-08-21T23:46:00

U can also use like this!!!

Below are the sample coding....

XML

StringBuilder SB = new StringBuilder();
        SB.Append("<table id='ProductModel' border='0'><tr><td width='91' style='text-align:center;'><b>Size</b></td>");
        SB.Append("<td width='87' style='text-align:center;'><b>Price in INR</b></td><td width='90' style='text-align:center;'><b>Time To Ship</b></td></tr>");
        for (int i = 0; i < dataTable.Rows.Count; i++)
        {            
            SB.Append("<td style='text-align:center;'>"+dataTable.Rows[i]["column_name1"].ToString()+" </td>");
            SB.Append("<td style='text-align:center;'>"+ dataTable.Rows[i]["column_name2"].ToString() +" </td>");
            SB.Append("<td style='text-align:center;'>"+ dataTable.Rows[i]["column_name3"].ToString() +" </tr>");
        }
        SB.Append("</table>");
        Models.InnerHtml = SB.ToString();

VB

Good luck.

Thanks,
~~Karthik.J~~

how to create dynamic table depending on values in database table

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0