Error in Query in windows application c#

Question

Please write Right Query private int billno(string p) { cmd = new SqlCommand(); string bill = cmd(Query con); con.Open(); return bill; con.Close(); }

Rafnas T P · Answer

try this Int32 Billno = 0; cmd = new SqlCommand(p con); con.Open(); Billno = (Int32) cmd.ExecuteScalar(); con.Close(); return Billno;

Tapan Patel · Answer

I think you are missing some pieces here. SqlConnection con = new SqlConnection( Your Connection string ); SqlCommand cmd = new SqlCommand( Your Query con); con.Open(); cmd.ExecuteNonQuery(); // or cmd.ExecuteReader(); if you are expecting databack from this query con.Close();