how can store the text value of dynamically created textbox in database.
Expand|Select|Wrap|Line Numbers
- using System;
- using System.Data;
- using System.Configuration;
- using System.Collections;
- using System.Web;
- using System.Web.Security;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.WebControls.WebParts;
- using System.Web.UI.HtmlControls;
- using System.Data.SqlClient;
- public partial class frndslambook : System.Web.UI.Page
- {
- SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
- SqlCommand com1;
- SqlCommand com;
- SqlDataReader dr1;
- static string[] exp;
- static string exp1;
- static long c;
- TextBox[] textBoxArr = new TextBox[c + 1];
- protected void Page_Load(object sender, EventArgs e)
- {
- com1 = new SqlCommand("Select * From slambook Where username=@username", con);
- com1.Parameters.Add("@username", SqlDbType.NVarChar).Value = Session["userfrndname"].ToString();
- try
- {
- if (con.State == ConnectionState.Closed)
- con.Open();
- dr1 = com1.ExecuteReader();
- if (dr1.Read())
- {
- string exp1 = dr1["slambookfields"].ToString();
- long c = Convert.ToInt64(exp1.Length);
- Label[] l1 = new Label[c + 1];//array of lables
- TextBox[] textBoxArr = new TextBox[c + 1];//array of textboxes
- exp = (exp1).Trim('^').Split('^');
- for (int i = 0; i < exp.Length; i++)
- {
- Panel frndstextBoxLabelGroup = new Panel();
- l1[i] = new Label();
- l1[i].ID = "frndslambooklabel" + i.ToString();
- l1[i].Text = exp[i].ToString();
- l1[i].Visible = true;
- textBoxArr[i] = new TextBox();
- textBoxArr[i].ID = "frndslambooktextbox" + i.ToString();
- textBoxArr[i].Visible = true;
- //Initializing the TextBox so that it is not rendered in the browser
- frndstextBoxLabelGroup.ID = "frndstextBoxLabelGroup" + i.ToString();
- fspfrndslambook.Visible = true;
- // Pnl_TextBox.Controls.Add(br);
- frndstextBoxLabelGroup.Controls.Add(l1[i]);
- frndstextBoxLabelGroup.Controls.Add(textBoxArr[i]);
- fspfrndslambook.Controls.Add(frndstextBoxLabelGroup);
- }
- }
- }
- catch (Exception exc)
- {
- }
- finally
- {
- con.Close();
- }
- }
- protected void fsbfill_Click(object sender, EventArgs e)
- {
- com = new SqlCommand("Insert Into slambookans (slambookfields_ans,sender,receiver) Values(@slambookfields_ans,@sender,@receiver)", con);
- for (int i = 0; i < exp.Length; i++)
- //{
- //textBoxArr[i] = new TextBox();
- com.Parameters.Add("@slambookfields_ans", SqlDbType.NVarChar).Value =textBoxArr[i].Text;
- }
- com.Parameters.Add("@sender", SqlDbType.NVarChar).Value = Session["username"].ToString();
- com.Parameters.Add("@receiver", SqlDbType.NVarChar).Value = Session["userfrndname"].ToString();
- try
- {
- if (con.State == ConnectionState.Closed)
- con.Open();
- int i=com.ExecuteNonQuery();
- if(i!=0)
- Response.Write("Success");
- else
- Response.Write("Fail");
- }
- catch(Exception exc)
- {
- }
- finally
- {
- con.Close();
- }
- }
- }