ERROR: Method name expected

Question

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!

Amit Gupta · Answer

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 :)

Mani Kandan · Answer

if (rd.Read()) { int month = Convert.ToInt32(mth) - 1; return rd[ sitS ].ToString(); }

Amit Gupta · Answer

Your code seems good. Debug your code and find which line cause the exception

Sousa Pambo · Answer

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!