How to display third table values in Grid View

AKSHAY HARSHA

12y1.3kLearn iOS Programming

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...

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dipankar Biswas12y ago
Accepted 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:
AKSHAY HARSHA12y ago
I got it ...
thanks to Dipankar Biswas and Kailash Chandra Behera for giving valuable information...
Dipankar Biswas12y ago
send me your query and code details. i shall try to solved it...

Thanks...
Dipankar Biswas
AKSHAY HARSHA12y ago
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..
12y ago
Hi,
Please view answers of previous same question before posting same question