retrive data from db to text box and grid view

Make sure when you enter a record in table1 with some id,  the details in other tables should also be entered with the same id.

Hello madhu........

Hi Rahul just checked replace the code in zip file with yours

1.   Table name :- Pinfo

Probably you are having same column names in the tables. Try using the alias names

select p.[name],a.*,e.* from  Pinfo as p
inner join Academic_dtl as a on p.id=a.id
inner join Emp_dtl as e on p.id=e.id where p.e_mail="+TextBox21.Text+"

Hello Rahul change your button search click event with. And I suggest you to improve your coding standards. Hope this helps

protected void btnSearch_Click(object sender, EventArgs e)
    {
        try
        {
            SqlConnection con3 = new SqlConnection();
            con3.ConnectionString = ConfigurationManager.AppSettings["cn"];
            {
                con3.Open();
            }
            SqlCommand cmd3 = new SqlCommand("select Job_applied,Name,Date_brith,Sex,Present_add,Permanent_add,Contact_no,Mobile_no,E_mail,Marital_st,Agreement,Min_salary from Pinfo where E_mail=@search", con3);
            cmd3.Parameters.Add("@search", SqlDbType.VarChar, 50).Value = TextBox21.Text.ToString();
            SqlDataReader dr = cmd3.ExecuteReader();
            if (dr.HasRows == false)
            {
                throw new Exception();
            }
            if (dr.Read())
            {
                TextBox1.Text = dr[0].ToString();
                TextBox2.Text = dr[1].ToString();
                TextBox3.Text = dr[2].ToString();
                RadioButtonList1.Text = dr[3].ToString();
                TextBox4.Text = dr[4].ToString();
                TextBox5.Text = dr[5].ToString();
                TextBox6.Text = dr[6].ToString();
                TextBox7.Text = dr[7].ToString();
                TextBox8.Text = dr[8].ToString();
                RadioButtonList2.Text = dr[9].ToString();
                RadioButtonList3.Text = dr[10].ToString();
                TextBox20.Text = dr[11].ToString();
            }
            dr.Close();
            cmd3.Dispose();
            SqlCommand cmd4 = new SqlCommand("select Pinfo.E_mail,Academic_dtl.*,Emp_dtl.* from Pinfo inner join Academic_dtl on Pinfo.id=Academic_dtl.id inner join Emp_dtl on Pinfo.id=emp_dtl.id where Pinfo.E_mail="+TextBox21.Text+"", con3);
            SqlDataAdapter da = new SqlDataAdapter(cmd4);
            DataTable dt = new DataTable();
            da.Fill(dt);
            GridView1.DataSource = dt;
            GridView1.DataBind();
            GridView2.DataSource = dt;
            GridView2.DataBind();
            cmd4.Dispose();
            con3.Close();
        }
        catch(Exception ex)
        {
            Response.Write(ex.Message.ToString());
        }
    }

Using this code whe i execute the form and search any emp data then the data of Academic_dtl and Emp_dtl can't be shown in grid views.....Means it doesn't work.....

//After if(dr.read()) block
write foloowing. You need to bind the gridview.
cmd3.Dispose();
            SqlCommand cmd4 = new SqlCommand("select Pinfo.E_mail,Academic_dtl.Examination,Emp_dtl.Name of employee from Pinfo inner join Academic_dtl on Pinfo.id=Academic_dtl.id inner join Emp_dtl on Pinfo.id=emp_dtl.id where Pinfo.E_mail=TextBox21.Text.ToString()", con3);
            SqlDataAdapter da = new SqlDataAdapter(cmd4);
            DataTable dt = new DataTable();           
            da.Fill(dt);
            GridView1.DataSource = dt;
            GridView1.DataBind();
            cmd4.Dispose();
            con3.Close();

Tell me if you dint understand.

ok madhu...

ok Madhu k, but how can i call the id oh the table Pinfo from email id which is also in Pinfo... i can search the data by typing the email id of the emp....once id can be called from email id then we can join the tables each other by id of the table.....

you need to use sql join to retrieve values from three tables something like

select Pinfo.column1,Acd_dtl.column2,emp_dtl.column3 from Pinfo
inner join Acd_dtl on
Pinfo.id=Acd_dtl.id
inner join emp_dtl on
Pinfo=emp_dtl.id

check the link for sqljoins
http://www.w3schools.com/sql/sql_join_inner.asp

Hi,
In Grid view Between the Columns tag use template fields and there you define the columns what you need.....

In code behind page open the connection string and write the select queries to ur requirement put it in the dataset........

below Links will help you:

http://www.c-sharpcorner.com/UploadFile/jitendra1987/1893/Default.aspx?ArticleID=418874ab-9d12-49af-98b7-6729ab35e59e
http://www.c-sharpcorner.com/UploadFile/jitendra1987/3804/Default.aspx?ArticleID=62298b7b-ea7b-4528-8a7e-5dfe872dfe16
http://www.c-sharpcorner.com/UploadFile/jitendra1987/3848/Default.aspx?ArticleID=274124a2-1c6a-45fb-8ba4-c459c2fbf223


If this post helped you, then tick the "Do you like this Answer" checkbox which is placed at above this post.