con.Open();
string checkuser = "select count(*) from UserData where [User Name]='" + TextBoxUserName.Text + "'";
SqlCommand com = new SqlCommand(checkuser, con);
SqlDatareader dr = com.executereader();
if(dr.read())
{
int temp = dr[0];
}
con.Close();
this will work fine