ERROR: Method name expected

Sousa Pambo

Hi, i get this error ,Method name expected, when I write this code, please help

public string MonthP(string student_id, int y, string mth)

{

string sql = "Select sitS from Sit where student_id='" + id + "' and years='" + (y).ToString() + "'";

using (SqlConnection cn = new SqlConnection(con.stringConex()))

{

try

{

cn.Open();

using (SqlCommand cm = new SqlCommand(sql, cn))

{

using (SqlDataReader rd = cm.ExecuteReader())

{

if (rd.Read())

{

return rd["sitS "](Convert.ToInt32(mth) - 1); // Error on this line

}

else

{

return "-1";

}

catch (Exception ex)

{

return "-1";

}

Thanks!

4 Replies

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

Sousa Pambo10y ago
Hi guys, i think what i was needing is this code below

string st = Convert.ToString(rd["sitS"]);
return st[Convert.ToInt32(moth) - 1].ToString();

Thank u!

-1
Amit Gupta10y ago
Hey Sousa
When you are reading data from SQL, it returns object.
As your method return type is of string type, you need to convert to string

return Convert.ToString (rd["sitS "]);

Do keep in mind that do all your stuff before using the return keyword else all the below part will not get executed.

Convert.ToString () and *.ToString () both convert the object to string but have some difference.

Hope it helps :)
0
Abhilash J A10y ago
if (rd.Read())
                           {
                               int month = Convert.ToInt32(mth) - 1;
                               return rd["sitS"].ToString();

                           }
0
Amit Gupta10y ago
Your code seems good. Debug your code and find which line cause the exception
0