Author: kimlong008 | Posted on: 1/26/2010 4:41:48 PM | Views : 221

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 ...