(2)Ajax-ajax下的第一个小例子

    技术2022-05-11  63

    1、启动Vs2005--------->Create WebSite----------->ASP.NET AJAX-Enabled Web Site(输入ajax(工程名)----->Desgin

    2、1).拖动一个UpdatePanel、两个TextBox、一个Button、一个GridView到页面。

         2)TextBoxButtonGridView拖放到UpdatePanel控件中。(图1

         3)在SQL Server上建立一数据库

                数据库名:king

                表名:UserContent                       SQL: Create Database king                      Use King                     Create table userContent(name varchar(200), content varchar(500))

           4)后台全部代码:

    using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls;   using System.Data.SqlClient;   public partial class _Default : System.Web.UI.Page {     protected void Page_Load(object sender, EventArgs e)     {         FillData();     }       public void FillData()     {         string sql = "Select * from userContent";         SqlConnection cn = new SqlConnection("Server=(local);database=king;uid=sa;pwd=;");         SqlDataAdapter da = new SqlDataAdapter(sql, cn);         DataSet ds = new DataSet();         da.Fill(ds, "User");         this.GridView1.DataSource = ds.Tables["User"].DefaultView;         this.GridView1.DataBind();     }     protected void Button1_Click(object sender, EventArgs e)     {         string sql = "Insert into userContent values('" + this.TextBox1.Text + "','" + this.TextBox2.Text + "')";         SqlConnection cn = new SqlConnection("Server=(local);database=king;uid=sa;pwd=;");         SqlCommand cmd = new SqlCommand(sql, cn);         cn.Open();         cmd.ExecuteNonQuery();         cn.Close();     } }

     

           

    最新回复(0)