insert textBox values into database

[parshupooja]

Hello

I am trying to create to a Timesheet . I am intiating number of textboxes and label based on criteria chosen by admin. This is what i have written in pageload to generate timesheet for 2 weeks

for (int i = 1; i <= 14; i++)
        {
            Label date = new Label();
            date.ID = "Item" + i.ToString();
            date.Text = DateTime.Now.AddDays(i).ToShortDateString();
            Label day = new Label();
            day.ID = "day" + i.ToString();
            day.Text = DateTime.Parse(date.Text).DayOfWeek.ToString();
            day.Text = day.Text.Substring(0, 3);
            TextBox txtmin = new TextBox();
            txtmin.ID = "txtmin" + i.ToString();
            TextBox txtmout = new TextBox();
            TextBox txtain = new TextBox();
            TextBox txtaout = new TextBox();
            AreaDay.Controls.Add(day);
            AreaDay.Controls.Add(new LiteralControl("<br><br><br>"));
            AreaDate.Controls.Add(date);
            AreaDate.Controls.Add(new LiteralControl("<br><br><br>"));
            AreaMIn.Controls.Add(txtmin);
            AreaMIn.Controls.Add(new LiteralControl(" <br> "));
            AreaMOut.Controls.Add(txtmout);
            AreaMOut.Controls.Add(new LiteralControl(" <br>  "));
            AreaAIn.Controls.Add(txtain);
            AreaAIn.Controls.Add(new LiteralControl("  <br> "));
            AreaAOut.Controls.Add(txtaout);
            AreaAOut.Controls.Add(new LiteralControl("  <br> "));
        }

everything starts with Area is placeholders on page which I am using to to add controls

now on the click event of button i want to execute store procedure which passes these textboxes and label values to database.

[KBTibbs]

Hello

I am trying to create to a Timesheet . I am intiating number of textboxes and label based on criteria chosen by admin. This is what i have written in pageload to generate timesheet for 2 weeks
...
everything starts with Area is placeholders on page which I am using to to add controls

now on the click event of button i want to execute store procedure which passes these textboxes and label values to database.

Are you asking how to get the information entered in the text boxes into a database? If so, it can depend on what developing environment you are using and what database you choose to use. What environment/compiler are you using and what type of database?

[csoftee]

Add all the controls created to a panel. Later loop through the control collection of panel and based on the id(i value) , insert the entries into the database.

[parshupooja]

@KBTibbs

Sorry forgot to mention I am using Asp.Net C#

Are you asking how to get the information entered in the text boxes into a database? If so, it can depend on what developing environment you are using and what database you choose to use. What environment/compiler are you using and what type of database?

[parshupooja]

@csoftee

You are right I thought of it but don't know how to achieve that. I am newbie . If u could show me snippet or lead me to example or article, that will be great help.

Thank You

Add all the controls created to a panel. Later loop through the control collection of panel and based on the id(i value) , insert the entries into the database.

[csoftee]

@csoftee

You are right I thought of it but don't know how to achieve that. I am newbie . If u could show me snippet or lead me to example or article, that will be great help.

Thank You

Looping can be done, but for creating timesheet these many controls are not needed, since passing on these many values to database constitutes redundant code. Try to create the timesheet in gridview which allows editing the entries. Sending the gridview data to database is easy as it will be bound to a datasource(ex:datatable, dataset). Check an example of a gridview and implement this.