HOW TO INSERT VIEW DATA INTO RUN TIME DATATABLE

hy guys
I am looking to insert data from view into run time created datatable ,As shownbelow i am tryin to insert two fields E mpid and Totalsalary into this new datatable but dunno how to go about it, i am kinda new at this kindly help


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");

dataGridView1.DataSource = dt;

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);



con.Close();

}
}
}