Hi,
No need to use
SqlDataReader
here. Use
SqlDataAdapte
.
Try this:
public void GetData( )
{
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mob"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("GetData", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapte(cmd);
da.Fill(ds);
con.Close();
}
--Amit