aa.cs

C#2.0宝典源码,C#经典书籍,很多例子

using System;
using System.Text;
using System.Data;
using System.Data.OleDb;


namespace StudentsMIS.DataAccess
{
	/// <summary>
	/// aa 的摘要说明。
	/// </summary>
	public class aa
	{
		public static void Main()
    {
      OleDbConnection objConnection = new OleDbConnection();
      objConnection.ConnectionString = "aa";
      OleDbCommand objCommand = new OleDbCommand();
      objCommand.Connection = objConnection;
      objCommand.CommandText = "Update students Set student_name='Joesph' Where student_id='18021333'";
      objCommand.Parameters.Add("@StuName","Joseph");
      objCommand.Parameters.Add("@StuID","18021333");
      objCommand.ExecuteScalar();
      OleDbDataReader objReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
      string a;
      if(objReader.HasRows)
      {
        while(objReader.Read())
          a = objReader["student_name"].ToString();
      }
      else
      {
        
      }

    }
	}
}