public static int ExecuteNonQuerystring sql SqlParameter param using SqlConnection con = new SqlConnectionconnectionString if conState != ConnectionStateO

This method executes a SQL command that does not return any data using the specified SQL query and parameters. It creates a new SqlConnection object using the connectionString property and opens the connection. It then creates a new SqlCommand object with the specified query and CommandType.Text, and adds the specified parameters to the command if they are not null. It executes the command using the ExecuteNonQuery method and retrieves the number of rows affected. It then clears the parameters and closes the connection before returning the number of rows affected.

This method is typically used to execute SQL commands such as INSERT, UPDATE, and DELETE statements that do not return any data but modify the database in some way. It is important to always close the connection after executing a command to avoid resource leaks and to clear the parameters to avoid issues with future commands