C#

sqlcommand cmd=new sqlcommand(sele ct name, empid from tablename);
con.open();
dataset ds=new dataset();
sqldataadapter da=new sqldataadapter( cmd);
da.fill(ds);
datagrid.dataso urce=ds.table(0 );
con.close();...