How to display third table values in Grid View

Question

I have 1 DB Students with 2 Tables Student & Course

Columns are

For Student For Course

Sid Cid

Sname Cname

Joining Date Fee

Finishing Date

Completed or Not

My problem is am create another Table STUENTCOURSE , i want save the combination of student and course values in third table (i.e, am enter Sname or Cname in front-end it display Sid, Sname, Cname, Fee, Joining Date, Finishing Date, Completed or Not.. in grid view).

I want retrieve values from third table

My Front end Application is

Student Name

Course Name

Show Button

One Grid View

If anybody understand my question plz reply...

Dipankar Biswas · Answer

Table 1 table 2 ............ Code: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.Configuration; public partial class Defaul : System.Web.UI.Page { public static string strConnectionString = ConfigurationManager.ConnectionStrings["profileconnectionstrin"].ConnectionString; public static SqlConnection con = new SqlConnection(strConnectionString); public static SqlCommand cmd; protected void Page_Load(object sender, EventArgs e) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("select tbl_s.Sname ,tbl_s.Saaddress,tbl_c.NCor,tbl_c.Cst from tbl_s inner join tbl_c on tbl_s.id = tbl_c.uid", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); GridView1.DataSource = dt; DataBind(); con.Close(); } } Result:

Kailash Chandra Behera · Answer

Hi, Please view answers of previous same question before posting same question

AKSHAY HARSHA · Answer

Thanks for giving excellent example... Its working fine when dip select c++ but dip select Java course, sac select c++ instead of Java how to write query for below Example ? Plz i need reply.. Thanks..

AKSHAY HARSHA · Answer

I got it ... thanks to Dipankar Biswas and Kailash Chandra Behera for giving valuable information...

Dipankar Biswas · Answer

send me your query and code details. i shall try to solved it... Thanks... Dipankar Biswas

How to display third table values in Grid View

Answers (5)