public partial class signup : System.Web.UI.Page
{
SqlConnection conn;
DataSet ds;
SqlDataAdapter da;
protected void Page_Load(object sender, EventArgs e)
{
ds = new DataSet();
string strConnection = ConfigurationManager.ConnectionStrings["Data_ConnStr"].ConnectionString;
conn = new SqlConnection(strConnection);
SqlCommand cmd = conn.CreateCommand();
//cmd.CommandText = "SELECT username, nickname FROM users WHERE status = 1 AND username <> '"
//+ User.Identity.Name + "'";
& ...
Go to the complete details ...