asp.net

//



<appSettings>
    <add key="connectionStrings" value="server=.;user id=sa;password=sa;database=wangyan"/>
  </appSettings>

  <!--
 
  <appSettings>
    <add key="connectionStrings" value="server=(local);user id=sa;password=sa;initial catalog=wangyan"/>
  </appSettings>
 
  一般用来设置常用的字符串，如数据库连接
  //用来获取字符串//string conn = ConfigurationSettings.AppSettings["connectionStrings"];
  -->
 






  // gridView控件 显示数据库数据　绑定数据源
        string conn = ConfigurationSettings.AppSettings["connectionStrings"];   //获取连接数据库字符串
        SqlConnection comm = new SqlConnection();                               //建立连接对象
        comm.ConnectionString = conn;                                           //打开数据库连接
        string sql = "select * from user_admin";                                 //定义记录集SQL命令
        SqlCommand cm = new SqlCommand(sql,comm);     //创建记录集
        comm.Open();                                 //打开记录集
        SqlDataReader reader = cm.ExecuteReader();   //读取记录集
        
        this.mydata.DataSource = reader;             //绑定记录集到数据控件
        this.mydata.DataBind();                      //记录集回滚     
        reader.Close();
        comm.Close();

   //判断数据库连接状态

     if (comm.State == ConnectionState.Closed)
        {
            Response.Write("数据库连接已经关闭");

        }
        else
        {
            Response.Write("数据库连接已经打开");
        }
        




//插入数据到数据库


 string connstring = ConfigurationSettings.AppSettings["connectionStrings"];   //获取连接数据库字符串
        SqlConnection conn = new SqlConnection();                               //建立连接对象
        conn.ConnectionString = connstring;                                           //打开数据库连接
        string sql = "insert into user_admin values('aaa','ssss','sss','sss')";                                 //定义记录集SQL命令
        SqlCommand rs = new SqlCommand(sql, conn);     //创建记录集
        conn.Open();
        rs.ExecuteNonQuery();




///删除数据行



        string connstring = ConfigurationSettings.AppSettings["connectionStrings"];   //获取连接数据库字符串
        SqlConnection conn = new SqlConnection();                               //建立连接对象
        conn.ConnectionString = connstring;                                           //打开数据库连接
        string sql = "delete from user_admin where id='" + mydata.DataKeys[e.RowIndex].Value.ToString() + "'";                             //定义记录集SQL命令
       
       // Response.Write(sql)
        SqlCommand rs = new SqlCommand(sql, conn);     //创建记录集
        conn.Open();
        rs.ExecuteNonQuery();
        conn.Close();









/


HttpRequest：Querystring [提交前]

  "SHOW.ASPX?ID={0}&NAME=aasheaa



HttpRequest：Querystring [提交后]


   string  aaa=Request.QueryString["id"];
       Response.Write(aaa);
        string userNm=HttpContext.Current.Request.QueryString["id"];

        HttpContext.Current.Response.Write("<Font color='Red'><B>欢迎</B></Font>");
    HttpContext.Current.Response.Write(userNm);
    Response.Write ("<B>你的密码是:</B>"+Request.QueryString["name"]);



        string username = HttpContext.Current.Request.Form["useraaa"];
        string password = Request.Form["password"];







  变量方法绑定数据
  <%#GetVotePercent(10)%>

protected string GetVotePercent(int vote)
    {
        int sumVote = num;
        if (sumVote == 0)
        {
            return "0%";
        }
        else
        {
            decimal percent = 100 * (Convert.ToDecimal(vote)/ Convert.ToDecimal(sumVote));
            return percent.ToString("n2") + "%";
        }
    

    }