[冷枫]一个不错的.ＮＥＴ例子

  private void btnLogin_Click(object sender, System.EventArgs e)
  {
   SqlConnection con = new SqlConnection();
   con.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["DSN"];
   con.Open();
  
   string strSql = "select UserName,UserPass from tbUserInfo where UserName='"+tbName.Text+"' and UserPass='"+tbPass.Text+"'";
   SqlCommand com = new SqlCommand(strSql,con);
   SqlDataReader dr = com.ExecuteReader();
   //以下执行查询
   bool bExist = false;
   while(dr.Read())
   {
    bExist = true;
    Session["UserName"] = dr.GetString(0);
    Session["UserPass"] = dr.GetString(1);
   }
   if(bExist)
    Response.Redirect("023Query.aspx");
   else
    Response.Write("<script language='javascript'>alert('用户名称或密码错误!')</script>");

   con.Close();
  }

private void Page_Load(object sender, System.EventArgs e)
  {
   lbUserName.Text = Session["UserName"].ToString();
  }
  private void btnQuery_Click(object sender, System.EventArgs e)
  {
   SqlConnection con = new SqlConnection();
   con.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["DSN"];
   con.Open();
   string strSql = "select EnterDate from tbUserInfo where UserName='"+tbName.Text+"'";
   SqlCommand com = new SqlCommand(strSql,con);
  
   com.Parameters.Add("@Name",SqlDbType.VarChar,50,"UserName");
   com.Parameters["@Name"].Value = tbName.Text;
   com.CommandText = "select EnterDate from tbUserInfo where UserName=@Name";

   object obj = com.ExecuteScalar();
   if(obj!=null)
    lbHireDate.Text = obj.ToString();
   else
    lbHireDate.Text = "数据库中没有此人!";
   con.Close();
  }

  private void Page_Load(object sender, System.EventArgs e)
  {
   sqlDataAdapter1.Fill(dsUser1.tbUserInfo);
   if(!IsPostBack)
   {   
    Session["RecordPos"] = 0;

    this.DataBind();
   }  
  }
  private void ExcuteSql(string strSql)
  {
   try
   {
    SqlConnection con = new SqlConnection();
    con.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["DSN"];
    con.Open();
    //添加纪录...
    SqlCommand com = new SqlCommand(strSql,con);
    com.ExecuteNonQuery();
    con.Close();
    //Response.Write("<script language='javascript'>alert('操作成功!')</script>");
   }
   catch(Exception ee)
   {
    Response.Write("发生错误:"+ee.Message);
   }
  }
//下一页
  private void btnNext_Click(object sender, System.EventArgs e)
  {
   int RecordPos = (int) Session["RecordPos"];
   RecordPos++;
   if (RecordPos >= dsUser1.tbUserInfo.Rows.Count)
   {
    RecordPos=0;
   }
   Session["RecordPos"] = RecordPos;
   this.DataBind();
  }
//上一页
  private void btnPrev_Click(object sender, System.EventArgs e)
  {
   int RecordPos = (int) Session["RecordPos"];
   if (RecordPos > 0)
   {
    RecordPos--;
   }
   Session["RecordPos"] = RecordPos;
   this.DataBind();
  }
//数据绑定
  private void tbName_DataBinding(object sender, System.EventArgs e)
  {
   int RecordPos = (int) Session["RecordPos"];
   tbName.Text = dsUser1.tbUserInfo.Rows[RecordPos]["UserName"].ToString();
  }
  private void tbPass_DataBinding(object sender, System.EventArgs e)
  {
   int RecordPos = (int) Session["RecordPos"];
   tbPass.Text = dsUser1.tbUserInfo.Rows[RecordPos]["UserPass"].ToString();
  }
  private void tbSex_DataBinding(object sender, System.EventArgs e)
  {
   int RecordPos = (int) Session["RecordPos"];
   tbSex.Text = dsUser1.tbUserInfo.Rows[RecordPos]["Sex"].ToString();
  }
  private void tbZhiWei_DataBinding(object sender, System.EventArgs e)
  {
   int RecordPos = (int) Session["RecordPos"];
   tbZhiWei.Text = dsUser1.tbUserInfo.Rows[RecordPos]["zhiwei"].ToString();
  }
  private void tbNotes_DataBinding(object sender, System.EventArgs e)
  {
   int RecordPos = (int) Session["RecordPos"];
   tbNotes.Text = dsUser1.tbUserInfo.Rows[RecordPos]["Notes"].ToString();
  }
  private void tbDate_DataBinding(object sender, System.EventArgs e)
  {
   int RecordPos = (int) Session["RecordPos"];
   tbDate.Text = dsUser1.tbUserInfo.Rows[RecordPos]["EnterDate"].ToString();
  }
//删除
  private void btnDelete_Click(object sender, System.EventArgs e)
  {
   string strSql = "Delete tbUserInfo where username='"+tbName.Text+"'";
   ExcuteSql(strSql);
  }
//更新
  private void btnUpdate_Click(object sender, System.EventArgs e)
  {
   string strSql = "UPDATE tbUserInfo "+
    "SET " +
    "UserPass ='"+tbPass.Text+"', "+
    "Sex ='"+tbSex.Text+"'," +
    "EnterDate ='"+tbDate.Text+"'," +
    "Zhiwei ='"+tbZhiWei.Text+"'," +
    "Notes ='" + tbNotes.Text + "'" +
    " WHERE UserName ='"+tbName.Text+"'";
   ExcuteSql(strSql);
  }

有关存储过程
//执行存储过程
  private void btnDataReader_Click(object sender, System.EventArgs e)
  {
   //建立Table，用来存放查询的结果
   DataTable table = new DataTable("Test");
   //为表格添加列
   table.Columns.Add("EmployeeID");
   table.Columns.Add("OrderDate");
   table.Columns.Add("RequiredDate");
   //执行查询
   SqlDataReader rdrEmployees;
   sqlConnection.Open();//打开数据库连接
   rdrEmployees = sqlCommand.ExecuteReader();//执行语句
   //以下读取数据
   DataRow   dr;
   while(rdrEmployees.Read())
   {
    dr = table.NewRow();//新建一行
    //对当前行每一列赋值
    dr[0] = rdrEmployees.GetInt32(0);
    dr[1] = rdrEmployees.GetDateTime(1);
    dr[2] = rdrEmployees.GetDateTime(2);
    table.Rows.Add(dr);//添加当前行
   }
   //以下设置数据源
   sqlConnection.Close();//关闭连接
   dataGridReader.DataSource = table;//设置数据源，显示数据
   dataGridReader.DataBind();
  }

//执行带参数的存储过程
  private void Button1_Click(object sender, System.EventArgs e)
  {
   //建立Table，用来存放查询的结果
   DataTable table = new DataTable("Test");
   //为表格添加列
   table.Columns.Add("OrderID");
   table.Columns.Add("OrderDate");
   table.Columns.Add("RequreDate");
   table.Columns.Add("ShippedDate");
  //执行查询
   SqlDataReader rdrEmployees;
   sqlConnection.Open();//打开数据库连接
   sqlCommand1.Parameters["@CustomerID"].Value = "VICTE";
   sqlCommand1.Parameters["@RETURN_VALUE"].Value = 1;
   rdrEmployees = sqlCommand1.ExecuteReader();//执行语句
   //以下读取数据
   DataRow   dr;
   while(rdrEmployees.Read())
   {
    dr = table.NewRow();//新建一行
    //对当前行每一列赋值
    dr[0] = rdrEmployees.GetInt32(0);
    dr[1] = rdrEmployees.GetDateTime(1);
    dr[2] = rdrEmployees.GetDateTime(2);
    dr[3] = rdrEmployees.GetDateTime(3);
    table.Rows.Add(dr);//添加当前行
   }
   //以下设置数据源
   sqlConnection.Close();//关闭连接
   dataGridReader.DataSource = table;//设置数据源，显示数据
   dataGridReader.DataBind();  
  } 

Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1039063