connection

Hello,

I'm getting the error below...

The connection was not closed. The connection's current state is open.

And heres the code thats casung the problem,...

publicstaticvoid JoinGroup(string GroupID,string User_ID)

{

SqlCommand cmd =newSqlCommand("insert into User_Joined_Groups (GroupID, User_ID) values (@.GroupID, @.User_ID)", conn);

conn.Open();

cmd.Parameters.Add(newSqlParameter("@.GroupID", GroupID));cmd.Parameters.Add(newSqlParameter("@.User_ID", User_ID));

cmd.ExecuteNonQuery();

conn.Close();

}

The method is called on a button click

anyone know what I've done wrong?

Thank you

Open your connection before using it when establishing your command. Also, make sure you have created your connection with the proper connection string before opening it:

public static void JoinGroup(string GroupID,string User_ID) {
conn =new SqlConnection(connStr);
conn.Open();SqlCommand cmd =new SqlCommand("insert into User_Joined_Groups (GroupID, User_ID) values (@.GroupID, @.User_ID)", conn); cmd.Parameters.Add(new SqlParameter("@.GroupID", GroupID));cmd.Parameters.Add(new SqlParameter("@.User_ID", User_ID)); cmd.ExecuteNonQuery();conn.Close();}

|||

champion!