how we can create dataset of existing table in sqlserver2000 using c# n asp.net

you can create dataset of existing table by using select command like bellow.

Private DataSet CreateDS()
{
//connection object
SqlConnection cn=new SqlConnection("U r ConnectionString");
//command object
SqlCommand cmd=new SqlCommand("Select * from TableName",cn);
//create dataset
DataSet ds=new DataSet();
//call adapter
SqlDataAdapter da=new SqlDataAdapter(cmd);
//fill the dataset
da.Fill(ds);
return ds;
}

I hope this will help you.