retrive data from db to text box and grid view

Question

Hiiiii I am new in asp.net i m makeing a one form through which i enter the data into the db now i want to retrive that data from database to that form in form i uses textbox and gridview.. In my db i make a three tables i.e. PinfoAcd_dtl and emp_dtl in these tables i take a one column of id which is unique an all tables. now i want to retrieve data from that tables to my form with the help of search button... to search i take a text box to enter a email id of employee. Now i want that when i fill the email id of employee then all the relevant data of that email id can show me on my form...I take the email id in the table Pinfo..... so plzzzz help me guyz..............

Madhu K · Answer

//After if(dr.read()) block write foloowing. You need to bind the gridview. cmd3.Dispose(); SqlCommand cmd4 = new SqlCommand(select Pinfo.E_mailAcademic_dtl.ExaminationEmp_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.

Madhu K · Answer

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+

Madhu K · Answer

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.

Rahul Goyal · Answer

Hello madhu........ The sent by you is working.. Thanx for help...... Really thank u.......... Now i have 1 more problem.... when i m add the two rows in a grid view and add these data to db then its added but in db the diffrent id are generated of these data in d and when i m retrieve these data from db then only the data of one row can be viewed.....

Madhu K · Answer

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

Rahul Goyal · Answer

1. Table name :- Pinfo Column name:- [id] [Job_applied] [Name] [Date_brith] [Sex] [Present_add] [Permanent_add] [Contact_no] [Mobile_no] [E_mail] [Marital_st] [Agreement] [Min_salary] 2 .Table Name:-Academic_dtl column name:-[id] [Examination] [Year_passing] [Major_subjects] [Inst_Univ] [Percentage] 3. Table name:- Emp_dtl column name:-[id] [Name_employee] [Date_joined] [Date_left] [Reason_leaving] [Last_salary] [Project_worked]

Madhu K · Answer

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+ Instead of a.Examination... and e.Name of employee..... write the column names that are to bind the Gridview. Can you post the 3 table column names you are using so that i can check.

Rahul Goyal · Answer

I do but same error occur.......

Rahul Goyal · Answer

There should a problem When i am execute the program and search any emp data then the data can't be show in gridviews it shows the errori.e. The multi-part identifier   could not be bound.....

Madhu K · Answer

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_appliedNameDate_brithSexPresent_addPermanent_addContact_noMobile_noE_mailMarital_stAgreementMin_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_mailAcademic_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()); } }

Rahul Goyal · Answer

i am sending you html code oh my page also....plz see it and do something.......

Rahul Goyal · Answer

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..... plz do something...... i m send u the aspx.cs...........

Rahul Goyal · Answer

ok madhu... but there is a problem here when i write this query and execute the application and fill the email id of employee then only the data from Pinfo can be show on page the data of other two tables can't be shown on the page.... so for this what can i do.... and i want that the data of other two tables can be show me in grid view which i used in the page..... i am attaching the code also with this plz check it and tell me the solution... plzzzzzzzzzzz

Madhu K · Answer

No need to call the id . Based on unique ID column values are retrieved from tables. select Pinfo. E_mail Acd_dtl.column2emp_dtl.column3 from Pinfo inner join Acd_dtl on Pinfo.id=Acd_dtl.id inner join emp_dtl on Pinfo=emp_dtl.id where Pinfo.E_mail=txtEmail.Text

Rahul Goyal · Answer

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..... so how can i call the id of table from email id....???????????

Madhu K · Answer

you need to use sql join to retrieve values from three tables something like select Pinfo.column1Acd_dtl.column2emp_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

Jiteendra Sampathirao · Answer

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 Answe r checkbox which is placed at above this post.