dynamic textbox with values

Question

0.00/5 (No votes)

See more:

Hi,

I have one textboxes. I want to fetch the record from table and display in dynamic textboxes in column wise. for example i have sixteen records then i need to display 16 columns in one row.

How to do that...

my code is below

ASPX page
-----------

XML

<tr>
     <td class="Content">Sno</td>
     <td class="Content">Name</td>
     <td>
                  <asp:TextBox runat="server" id="txtDesign">
     </td>
</tr>
<tr>
		              <td align="left" colspan="18" class="Content">Engineers</td>
	            </tr>
                <tr>
		                <td align="left" colspan="18">Designers</td>
	            </tr>

ASPX.VB Code
------------

VB

StrQry = ""
        StrQry = "Select Designation,DesigCode,Priority,Priority2,ProfRoleCode,ProfRole,DeptCode from Designation where DeptCode='" & Session("Dept") & "' order by Priority2"
        Cmd.Connection = Conn
        Cmd.CommandText = StrQry
        Rdr = Cmd.ExecuteReader
        Dim recCount As Integer = 0
        'recCount = Rdr.HasRows
        If Rdr.HasRows Then
            While Rdr.Read
                txtDesign.Text = Rdr("Designation")
                recCount = recCount + 1
            End While
            recCount = recCount ' To Count the Number of Records
        End If
        Rdr.Close()
        Conn.Close()

How to do that

Posted 6-Jul-11 1:01am

gani7787

Updated 6-Jul-11 1:05am

Tarun.K.S

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 6-Jul-11 11:49am

What is non-dynamic text box?
--SA

4 solutions

Solution 2

Dear,
If You Have A Datatable, then DataGrid Is The Best Way for This.

Posted 6-Jul-11 1:11am

Anudeep Jaiswal - MCA

Solution 3

Hi,
There is many solution on adding TextBox dynamically, but that require some additional workaround as .Net only recognize controls available on control collection , so you have to add each dynamic control to its control collection to use those from server side. Soin my opinion best way is use GridView and use TemplateField. This way you can dynamically add TextBox and able to use them from server side.

Posted 6-Jul-11 1:23am

Shahriar Iqbal Chowdhury/Galib

Solution 4

Creating Dynamic Controls in ASP.Net[^]

Posted 6-Jul-11 1:55am

raju melveetilpurayil

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)

Deepthi Aravind · Accepted Answer · 2011-07-06T01:10:00

Solution 1

Try this...

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

	TableRow tr = new TableRow();
        TableCell td = new TableCell();
        TextBox textBox = new TextBox();
        td = new TableCell();
        td.Width = Unit.Pixel(145);
        textBox = new TextBox();
        textBox.Text ="From DB";
        td.Controls.Add(textBox );
	if(i=RDL.Count-1)
	{
		tr.Controls.Add(td);
	}

}

Posted 6-Jul-11 1:10am

Deepthi Aravind

Updated 6-Jul-11 1:33am

v2

Comments

gani7787 6-Jul-11 7:19am

Hi,
What is lbl..?

Deepthi Aravind 6-Jul-11 7:33am

Sorry...pls check the solution now...