Cannot find table 0.

Question

I am trying to auto generate id in the webpage it gives me cannot find table o(Index out of Range Exception) Tell me where i am wrong and what i have to do My databaselayer public int generateid() { int id = 0; DataSet ds = new DataSet(); string constring = null; SqlConnection conn = null; try { constring = ConfigurationManager.ConnectionStrings[MyConnection].ConnectionString; conn = new SqlConnection(constring); conn.Open(); SqlCommand cmd = new SqlCommand(spAutoGeneratecustomerId1 conn); cmd.CommandType = CommandType.StoredProcedure; // SqldataAdapter da = new SqldataAdapter(cmd); id = Convert.ToInt32(ds.Tables[0].Rows[0][Customer_id].ToString()); } catch (Exception ex) { Console.WriteLine(Error + ex.Message); } return id; } #business logic layer public int getId() { int id; id=dal.generateid(); return id; } #code behind public partial class Test : System.Web.UI.Page { Business bal = new Business(); protected void Page_Load(object sender EventArgs e) { txtId.Text = bal.getId().ToString(); }

Midhun T P · Answer

Hi You are not assigning the result to dataset. SqldataAdapter da = new SqldataAdapter(cmd); da.Fill(ds); Use above lines before assigning id as value from dataset ds. Reference - https://stackoverflow.com/questions/8654829/how-to-get-data-from-stored-sql-procedure-in-dataset-with-sqldataadapter

Rafnas T P · Answer

hi as mithun said you missed a line to assign results to your data set thats why you are getting this error you have to change your code as below constring = ConfigurationManager.ConnectionStrings[ MyConnection ].ConnectionString; conn = new SqlConnection(constring); conn.Open(); SqlCommand cmd = new SqlCommand( spAutoGeneratecustomerId1  conn); cmd.CommandType = CommandType.StoredProcedure; SqldataAdapter da = new SqldataAdapter(cmd); //add these lines da.Fill(ds); id = Convert.ToInt32(ds.Tables[0].Rows[0][ Customer_id ].ToString());