I m trying to make event calandar but it shows error.

Question

error CS1061: 'object' does not contain a definition for 'Tables' and no extension method 'Tables' accepting a first argument of type 'object' could be found (are you missing a using directive or an assembly reference?) How to resolve this problem.

Piyush Pansuriya · Answer

Hello, Try to put your code into this method : public DataTable GetEventData( string comp_code, int month, string year = null ) { try { SqlCommand cmd = new SqlCommand(); DataSet dataSet= new DataSet(); DataTable dataTable= new DataTable(); SqlDataAdapter dataAdapter= new SqlDataAdapter(); cmd.Connection = cnSCT; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_GetEventSummary" ; cmd .Parameters.Add( "@comp_code" , SqlDbType.VarChar).Value = comp_code; cmd .Parameters.Add( "@month" , SqlDbType.Int).Value = month; cmd .Parameters.Add( "@year" , SqlDbType.VarChar).Value = year; dataAdapter.SelectCommand = cmd ; dataAdapter.Fill(dataSet); if (dataSet.Tables.Count > 0) dataTable = dataSet.Tables[0]; return dataTable; } catch (Exception) { throw ; } }

yoga ram · Answer

Remove Table[0] and run

Suraj Kumar · Answer

Where is the definition of RunProcedure? If you will provide then someone can help you fast.

I m trying to make event calandar but it shows error.

Answers (3)