How To Insert View Data In Run Time Datatable

[charneet]

hy guys ,
i am kinda new at this , i am trying to get two fields EMpid and totalsalary from view i had already created but i dunno how to insert it into the run time created datatable , my code is as follows:

private void Form1_Load(object sender, EventArgs e)
{
cmdstr = "select Empid ,(Basic+DA) as totalsalary from Vw_empdetails";
con = new SqlConnection(constr);
cmd = new SqlCommand(cmdstr, con);
}

private void button1_Click(object sender, EventArgs e)
{
con.Open();

DataSet ds = new DataSet();

DataTable dt = new DataTable("Projtable");


ds.Tables.Add(dt);

DataColumn dc1 = new DataColumn("EMID", typeof(int));

DataColumn dc2 = new DataColumn("Salary", typeof(int));

dt.Columns.Add(dc1);
dt.Columns.Add(dc2);

DataColumn[] dc = new DataColumn[1];
dc[0] = dc1;
dt.PrimaryKey = dc;

DataRow dr ;
dr = dt.NewRow();



dt.Rows.Add(dr);







dataGridView1.DataSource = dt;

con.Close();

}