C#

CREATE TABLE [student](<br />
    [student_id] INT NOT NULL IDENTITY(1,1),<br />
    [student_name] VARCHAR(50) NOT NULL,<br />
    [student_lastname] VARCHAR(70) NOT NULL,<br />
    [student_age] TINYINT NOT NULL,<br />
    [student_since] SMALLDATETIME NOT NULL DEFAULT GETDATE(),<br />
    [student_grade] TINYINT NOT NULL,<br />
    [student_active] BIT NOT NULL DEFAULT 1,<br />
    PRIMARY KEY( [student_data_id] )<br />
)

CREATE TABLE [class](<br />
    [class_id] SMALLINT NOT NULL IDENTITY(1,1),<br />
    [class_name] VARCHAR(50) NOT NULL,<br />
    [class_acive] BIT NOT NULL DEFAULT 1,<br />
    PRIMARY KEY( [class_id] )<br />
)

CREATE TABLE [class_by_student](<br />
    [class_id] REFERENCES [class] ( [class_id] ),<br />
    [student_id] REFERENCES [student]( [student_id] ),<br />
    PRIMARY KEY( [class_id], [student_id] )<br />
)<br />

<br />
using System;<br />
using System.Data;<br />
using System.Data.SqlClient;<br />
using System.Windows.Forms;<br />
using System.Thread;<br />
<br />
public class Form1 : Form<br />
{<br />
    private System.ComponentModel.IContainer components = null;<br />
    private StatusStrip sb;<br />
    private ToolStripProgressBar pb;<br />
    DataGridView dg;<br />
    Thread Thread4LoadData;<br />
<br />
    public Form1()<br />
    {<br />
        this.makeForm();<br />
    }<br />
<br />
    public makeForm()<br />
    {<br />
        this.sb = new StatusStrip();<br />
        this.pb = new ToolStripProgressBar();<br />
        this.dg = new DataGridView();<br />
        ((System.ComponentModel.ISupportInitialize)(this.dg)).BeginInit();<br />
        this.sb.SuspendLayout();<br />
        this.SuspendLayout();<br />
<br />
        //status bar<br />
        this.sb.Items.Add(this.pb);<br />
        this.sb.Name = "sb";<br />
<br />
        //progress bar<br />
        this.pb.Name = "pb";<br />
        this.pb.Size = new System.Drawing.Size(100, 16);<br />
<br />
        //DataGridView<br />
        this.dg.Location = new System.Drawing.Point(12, 42);<br />
        this.dg.Name = "dg";<br />
        this.dg.Size = new System.Drawing.Size(464, 374);<br />
<br />
        //Form1<br />
        this.Controls.Add(this.sb);<br />
        this.dg.Add(this.dg);<br />
        ((System.ComponentModel.ISupportInitialize)(this.dg)).EndInit();<br />
        this.Name = "Form1";<br />
        this.Text = "Staudents";<br />
        this.Load += new System.EventHandler(this.Form1_Load);<br />
        this.sb.ResumeLayout();<br />
        this.sb.PerformLayout();<br />
        this.ResumeLayout(false);<br />
        this.PerformLayout();<br />
    }<br />
<br />
    private void Form1_Load()<br />
    {<br />
        Thread4LoadData = new Thread( new ThreadStart( this.LoadData ) );<br />
        Thread4LoadData.Start();<br />
    }<br />
<br />
    private void LoadData()<br />
    {<br />
        string connStr = "server=myserver.com.;database=school;uid=sa;password=666;Trusted_Connection=False;";<br />
        SqlConnection conn = new SqlConnection(connStr);<br />
        conn.open();<br />
<br />
        string SQL;<br />
        SQL="SELECT * " + <br />
            "FROM [class_by_student] AS [cs]" +<br />
            "JOIN [class] AS [c] ON [c].[class_id] = [cs].[class_id]" +<br />
            "JOIN [student] AS [s] ON [s].[student_id] = [cs].[student_id]" +<br />
            "WHERE [s].[student_active] = 1 " +<br />
            "AND [c].[class_active] = 1" +<br />
            "ORDER BY [S].[student_name]";<br />
<br />
        DataSet dts = new DataSet();<br />
<br />
        SqlDataAdapter da = new SqlDataAdapter( SQL, conn );<br />
        da.Fill(dts, "schools");<br />
        this.dg.DataSource = dts;<br />
        this.dg.DataMember = "schools";<br />
        conn.close();<br />
    }<br />
}<br />