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

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.

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;
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

yoga ram7y ago
Remove Table[0] and run
Piyush Pansuriya7y ago
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;
            }
        }
Suraj Kumar7y ago
Where is the definition of RunProcedure? If you will provide then someone can help you fast.