Hi jayakumar,1)Binding only three column to the datagridviewSqlDataAdapter da=new SqlDataAdapter("select id,name,deptname from A",conn);DataSet ds=new DataSet();da.Fill(ds,"A);DataGridView1.DataSource=ds.Tables["A];