Extracting data from Table2 to TextArea of Table1

[monalishabiswal]

I want to designed 2 tables in my aspx page. In table1 there is blank TextArea. In table2 there are button like(First Name,Last Name,Age,DOB) and these attributes are already entered in the database and i have entered corresponding symbols for these attributes (for e.g. for Firstname symbol is {F}, for last name symbol is {L} etc..)... My requirement is when i doubleclick on a button of Table2 (for e.g. FirstName) it will be displayed on TextArea of table1 like (Hi My Name is {F})...

[pod]

What have you done so far?
Where do you get stuck?
Have you read this http://bytes.com/topic/asp-net/answe...before-posting

We want to help you, not do the work for you. Ask specific questions, perform small steps, get one button to pop up a msgbox or something in that line, and build on that.

When you get stuck, give us the details.

Good luck

P:oD

[monalishabiswal]

I am beginner to asp.net and i am not getting any idea to solve it,thats why am asking for help not to do my whole task.....

[pod]

OK, I understand you are a beginner. So answer my questions:

What have you done so far?
Where do you get stuck?

[monalishabiswal]

I ve created an 1staspx page where if i give the first name it will show symbol F in the text area....

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Web.UI.HtmlControls;
 
public partial class Default2 : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(@"Data Source=AITPLCP72\SQLEXPRESS;Initial Catalog=Template;Integrated Security=True");
    DataSet ds = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack)
        {
            SqlDataAdapter adp = new SqlDataAdapter("select field,Symbols from temp2", con);
            adp.Fill(ds);
        }
    }
 
    protected void btnfn_Click(object sender, EventArgs e)
    {
        Symbol("firstname");
    }
    protected void btnln_Click(object sender, EventArgs e)
    {
        Symbol("lastname");
    }
    protected void btnAge_Click(object sender, EventArgs e)
    {
        Symbol("age");
    }
    protected void btnDOB_Click(object sender, EventArgs e)
    {
        Symbol("dob");
    }
 
    protected void btnsubmit_Click1(object sender, EventArgs e)
    {
        //Session["text"] = TextArea1.InnerText;
        //Response.Redirect("Default3.aspx"); 
        string s = TextArea1.InnerHtml;
        Response.Redirect("http://localhost:2482/Template1/Default3.aspx?text=" + s);
 
    }
 
 
    public void Symbol(string s)
    {
        foreach (DataRow row in ds.Tables[0].Rows)
        {
            if (row[0].ToString() == s.ToString())
            {
                string st = TextArea1.Value;
                st += row["Symbols"];
                TextArea1.Value = st;
            }
        }
    }
 
}
 
 

after that I have created 2aspx page and there i had submit firstname,lastname,age,dob and it extract from db and show in textarea..

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
 
public partial class Default3 : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(@"Data Source=AITPLCP72\SQLEXPRESS;Initial Catalog=Template;Integrated Security=True");
    SqlCommand cmd =  new SqlCommand();
    protected void Page_Load(object sender, EventArgs e)
    {
 
    }
    protected void btnsubmit_Click(object sender, EventArgs e)
    {
        string text1 = Request.QueryString["text"];
        //string text1 = TextArea1.InnerHtml;
        text1 = text1.Replace("{F}", txtfn.Text).Replace("{L}", txtln.Text).Replace("{A}", txtage.Text).Replace("{D}", txtdob.Text);
        TextArea1.Value = text1;
    }
 
}  

[monalishabiswal]

now i want 2 add repeater to make template in my 2aspx page but how i will do this....