Get value of dynamic textbox in dynamic table with masterpages

Ive been stuck on this one for a month:

So I have a custom control that has a list of textboxes, and a button that will dynamically add a new textbox to the list.

 So I have an addTextbox() function, that will do something like

TextbBox t = new TextBox()

 then I add it to the page.  So adding a new textbox works fine, but I have values that I want to put into each textbox and upon each page load, the values get replaced.  What I need to do is get the textboxes from the viewstate so I can use their values for other textboxes, but since they are created anonymously, im not sure how I can do that.  I tried to get the unique name and put all of them into an arraylist, then upon the next page load, load the names from the list, but the unique name isnt unique.  Thanks

I am writing a function in which i generate autocode in specific format i want to make this function generalize so that i send tablename and columnname  parameter and function return the next code. I am using linq to sql with MVC e.g. i want to make table name and column name dyanamic

from m in db.<tblnameparam> 
                       orderby m.<colnameparam> descending
                       select m.<colnameparam>

This Works

create table #tmp1(rowID int)
declare @rowID int
set @rowID = 1
exec('insert into #tmp1(rowID) SELECT ' + @rowID)

This does not work

Declare @tmp1 table(rowID int)
declare @rowID int
set @rowID = 1
exec('insert into @tmp1(rowID) SELECT ' + @rowID)

Error Msg:
Msg 137, Level 15, State 2, Line 1
Must declare the variable '@tmp1'.

Is there a way to use Dynamic Sql against a Table var -- @tmp1?
How to do this?

The goal is to be able to pass in a string param like this to a proc

s1 = 'aa'',''bb'',''cc'

declare @s1 varchar(20)

Begin As

declare @tmp1(...)
exec('Insert Into ' + @tmp1 + ' (...) Where fldx In (''' + @s1 + ''')')
...

Thanks

 Hi all. I want to create a TableRow with a TextBox. I want when click a Button a TableRow add to asp:table. in Button_Click event code I can add a row by a TableRow & TableCell & TextBox Objects and with help a HiddenField.
My problem is that: after add first row that has a textbox, next row doesn't add by click button. I think Controls delete after post back in server and first textbox delete and new textbox add same position. what is solution after every click, a row with textbox add to the table?

            TableRow tr = new TableRow();
            TableCell tc1 = new TableCell();
            TableCell tc2 = new TableCell();
            TableCell tc3 = new TableCell();
            TextBox txt1 = new TextBox();
            TextBox txt2 = new TextBox();
            DropDownList drp = new DropDownList(); drp.Width = Unit.Pixel(100);
            tc1.Controls.Add(txt1);
            tc2.Controls.Add(txt2);
            tc3.Controls.Add(drp);
            tr.Cells.Add(tc1);
            tr.Cells.Add(tc2);
            tr.Cells.Add(tc3);
            tblAccessories.Rows.Add(tr);

Hello All,

I want to export my data to excel sheet. The logic to export data in excel is clear.

Now my query is I have 3 tables and I want to generate the data jst like below.

And so on.....

The data will come from 3 tables I.e

1. Master Table for Company

2. Highlight text in a dynamic textbox

     

    Hi, I have a dynamic textbox appearing in a gridview on the row editing function. I have the following code to set the focus tot he textbox:

   GridView1.EditIndex = e.NewEditIndex
   BindData()
   GridView1.Rows(e.NewEditIndex).FindControl("txtTargetAmount").Focus()

   This works fine, but I would now also like to select the data in the textbox so the user does not have to select the text before typing, they can just type straight away.

   I have been trying to use:

   txtTargetAmount1.SelectionStart = 0
   txtTargetAmount1.SelectionLength = txtTargetAmount1.Text.Length

   but this does not work.

   Any ideas?

   Thanks