Sql Data Adapter

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

string query = "SELECT [Name],Age,Gender From Student WHERE ID="+id+"";

cmd.CommandText = query;

DataTable tbl = new DataTable();

SqlDataAdapter adapter = new SqlDataAdapter(cmd);

adapter.Fill(tbl);