判断用户注册的用户名是否为数据库中已有的用户名

关键：使用DataSet 实现

 protected void Button1_Click(object sender, EventArgs e)     

{  string UserName = TextBox1.Text;

    SqlConnection conn = new SqlConnection();    

    conn.ConnectionString = "server=.;database=数据库名;uid=sa;pwd=;integrated security=SSPI;persist security info=False;";       

    conn.Open();       

    string  Name = "select UserName from User where UserName='" + UserName+ "'";     

    DataSet ds = new DataSet();      

   SqlDataAdapter sda = new SqlDataAdapter(Name,conn);       

   sda.Fill(ds, "User");     

   if (ds.Tables["User"].Rows.Count > 0)       

  {              Response.Write("<script>alert(/"+该用户已存在,请重新输入用户名！+/")/script>");                              

   }      

  else        

  {                    string Item_Username=Session["userName"].ToString ();           

         string strConnection = "server=.;database=数据库名;uid=sa;pwd=;integrated security=SSPI;persist security info=False;";                

    string queryStr = "Insert Into User   UserName,password) values ('" + UserName+ "','" + password+ "')";           

         SqlConnection nwConn = new SqlConnection(strConnection);            

        SqlCommand sqc = new SqlCommand(queryStr, nwConn);               

     nwConn.Open();               

     sqc.ExecuteNonQuery();                

    nwConn.Close();                 

   Response.Write("<script>alert(/"+所添加用户信息已成功！+/")</script>");              

  }