ASP编程：关于在DataGrid里增加ComboBox（一）

SQLServer是基于服务器端的中型的数据库，可以适合大容量数据的应用，在功能上管理上也要比Access要强得多。在处理海量数据的效率，后台开发的灵活性，可扩展性等方面强大。这段代码我没收拾过，但愿哪位收拾一下从头贴下去
usingSystem;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Collections;
usingSystem.Globalization;
usingSystem.Windows.Forms;
usingSystem.ComponentModel;
usingSystem.Data.SqlClient;
namespaceComboBoxInDataGrid
{
publicclassForm2:System.Windows.Forms.Form
{
///<summary>
///Requireddesignervariable.
///</summary>
privateSqlDataAdaptersqlDA;
privateSqlCommandsqlSelectStudent;
privateSqlCommandsqlInsertStudent;
privateSqlCommandsqlUpdateStudent;
privateSqlCommandsqlDeleteStudent;
privateSystem.ComponentModel.Containercomponents=null;
privatestringStrSQL;
privateSqlConnectionsqlConn;
privateDataSet_StudentDS;
privateDataTable_CourseDT;
privateDataGridTableStyleGridTableStyle;
privateSystem.Windows.Forms.ButtonbtnUpdate;
privateSystem.Windows.Forms.ButtonbtnMoveFirst;
privateSystem.Windows.Forms.ButtonbtnMovePrevious;
privateSystem.Windows.Forms.ButtonbtnMoveNext;
privateSystem.Windows.Forms.ButtonbtnMoveLast;
privateSystem.Windows.Forms.DataGriddataGrid1;
privateSystem.Windows.Forms.Labellabel1;
privateCurrencyManagerobjStudentCM;
publicForm2()
{
//
//RequiredforWindowsFormDesignersupport
//
InitializeComponent();
//
//TODO:AddanyconstructorcodeafterInitializeComponentcall
//
}
///<summary>
///Cleanupanyresourcesbeingused.
///</summary>
protectedoverridevoidDispose(booldisposing)
{
if(disposing)
{
if(components!=null)
{
components.Dispose();
}
}
base.Dispose(disposing);
}
#regionWindowsFormDesignergeneratedcode
///<summary>
///RequiredmethodforDesignersupport-donotmodify
///thecontentsofthismethodwiththecodeeditor.
///</summary>
privatevoidInitializeComponent()
{
this.sqlUpdateStudent=newSystem.Data.SqlClient.SqlCommand();
this.sqlConn=newSystem.Data.SqlClient.SqlConnection();
this.sqlDA=newSystem.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteStudent=newSystem.Data.SqlClient.SqlCommand();
this.sqlInsertStudent=newSystem.Data.SqlClient.SqlCommand();
this.sqlSelectStudent=newSystem.Data.SqlClient.SqlCommand();
this.btnMoveLast=newSystem.Windows.Forms.Button();
this.dataGrid1=newSystem.Windows.Forms.DataGrid();
this.btnUpdate=newSystem.Windows.Forms.Button();
this.btnMoveNext=newSystem.Windows.Forms.Button();
this.btnMoveFirst=newSystem.Windows.Forms.Button();
this.btnMovePrevious=newSystem.Windows.Forms.Button();
this.label1=newSystem.Windows.Forms.Label();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.SuspendLayout();
//
//sqlUpdateStudent
//
this.sqlUpdateStudent.CommandText=@"UPDATEStudentSETSNo=@SNo,SName=@SName,Course=@CourseWHERE(SNo=@Original_SNo)AND(Course=@Original_CourseOR@Original_Course1ISNULLANDCourseISNULL)AND(SName=@Original_SNameOR@Original_SName1ISNULLANDSNameISNULL);SELECTSNo,SName,CourseFROMStudentWHERE(SNo=@Select_SNo)";
this.sqlUpdateStudent.Connection=this.sqlConn;
this.sqlUpdateStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@SNo",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,false,((System.Byte)(0)),((System.Byte)(0)),"SNo",System.Data.DataRowVersion.Current,null));
this.sqlUpdateStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@SName",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,true,((System.Byte)(0)),((System.Byte)(0)),"SName",System.Data.DataRowVersion.Current,null));
this.sqlUpdateStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@Course",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,true,((System.Byte)(0)),((System.Byte)(0)),"Course",System.Data.DataRowVersion.Current,null));
this.sqlUpdateStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@Original_SNo",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,false,((System.Byte)(0)),((System.Byte)(0)),"SNo",System.Data.DataRowVersion.Original,null));
this.sqlUpdateStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@Original_Course",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,true,((System.Byte)(0)),((System.Byte)(0)),"Course",System.Data.DataRowVersion.Original,null));
this.sqlUpdateStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@Original_Course1",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,true,((System.Byte)(0)),((System.Byte)(0)),"Course",System.Data.DataRowVersion.Original,null));
this.sqlUpdateStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@Original_SName",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,true,((System.Byte)(0)),((System.Byte)(0)),"SName",System.Data.DataRowVersion.Original,null));
this.sqlUpdateStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@Original_SName1",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,true,((System.Byte)(0)),((System.Byte)(0)),"SName",System.Data.DataRowVersion.Original,null));
this.sqlUpdateStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@Select_SNo",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,false,((System.Byte)(0)),((System.Byte)(0)),"SNo",System.Data.DataRowVersion.Current,null));
//
//sqlConn
//
this.sqlConn.ConnectionString="datasource=localhost;initialcatalog=myData;persistsecurityinfo=False;userid="+
"sa;workstationid=NWAD-SJALLI;packetsize=4096";
//
//sqlDA
//
this.sqlDA.DeleteCommand=this.sqlDeleteStudent;
this.sqlDA.InsertCommand=this.sqlInsertStudent;
this.sqlDA.SelectCommand=this.sqlSelectStudent;
this.sqlDA.TableMappings.AddRange(newSystem.Data.Common.DataTableMapping[]{
newSystem.Data.Common.DataTableMapping("Table","Student",newSystem.Data.Common.DataColumnMapping[]{
newSystem.Data.Common.DataColumnMapping("SNo","SNo"),
newSystem.Data.Common.DataColumnMapping("SName","SName"),
newSystem.Data.Common.DataColumnMapping("Course","Course")})});
this.sqlDA.UpdateCommand=this.sqlUpdateStudent;
//
//sqlDeleteStudent
//
this.sqlDeleteStudent.CommandText="DELETEFROMStudentWHERE(SNo=@SNo)AND(Course=@CourseOR@Course1ISNULL"+
"ANDCourseISNULL)AND(SName=@SNameOR@SName1ISNULLANDSNameISNULL)";
this.sqlDeleteStudent.Connection=this.sqlConn;
this.sqlDeleteStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@SNo",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,false,((System.Byte)(0)),((System.Byte)(0)),"SNo",System.Data.DataRowVersion.Original,null));
this.sqlDeleteStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@Course",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,true,((System.Byte)(0)),((System.Byte)(0)),"Course",System.Data.DataRowVersion.Original,null));
this.sqlDeleteStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@Course1",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,true,((System.Byte)(0)),((System.Byte)(0)),"Course",System.Data.DataRowVersion.Original,null));
this.sqlDeleteStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@SName",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,true,((System.Byte)(0)),((System.Byte)(0)),"SName",System.Data.DataRowVersion.Original,null));
this.sqlDeleteStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@SName1",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,true,((System.Byte)(0)),((System.Byte)(0)),"SName",System.Data.DataRowVersion.Original,null));
//
//sqlInsertStudent
//
this.sqlInsertStudent.CommandText="INSERTINTOStudent(SNo,SName,Course)VALUES(@SNo,@SName,@Course);SELECTSN"+
"o,SName,CourseFROMStudentWHERE(SNo=@Select_SNo)";
this.sqlInsertStudent.Connection=this.sqlConn;
this.sqlInsertStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@SNo",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,false,((System.Byte)(0)),((System.Byte)(0)),"SNo",System.Data.DataRowVersion.Current,null));
this.sqlInsertStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@SName",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,true,((System.Byte)(0)),((System.Byte)(0)),"SName",System.Data.DataRowVersion.Current,null));
this.sqlInsertStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@Course",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,true,((System.Byte)(0)),((System.Byte)(0)),"Course",System.Data.DataRowVersion.Current,null));
this.sqlInsertStudent.Parameters.Add(newSystem.Data.SqlClient.SqlParameter("@Select_SNo",System.Data.SqlDbType.VarChar,50,System.Data.ParameterDirection.Input,false,((System.Byte)(0)),((System.Byte)(0)),"SNo",System.Data.DataRowVersion.Current,null));
//
//sqlSelectStudent
//
this.sqlSelectStudent.CommandText="SELECTSNo,SName,CourseFROMStudent";
this.sqlSelectStudent.Connection=this.sqlConn;
//
//btnMoveLast
//
this.btnMoveLast.Anchor=(System.Windows.Forms.AnchorStyles.Bottom|System.Windows.Forms.AnchorStyles.Left);
this.btnMoveLast.Font=newSystem.Drawing.Font("MicrosoftSansSerif",8.25F,System.Drawing.FontStyle.Bold,System.Drawing.GraphicsUnit.Point,((System.Byte)(0)));
this.btnMoveLast.Location=newSystem.Drawing.Point(128,264);
this.btnMoveLast.Name="btnMoveLast";
this.btnMoveLast.Size=newSystem.Drawing.Size(32,24);
this.btnMoveLast.TabIndex=5;
this.btnMoveLast.Text="|>";
this.btnMoveLast.Click+=newSystem.EventHandler(this.btnMoveLast_Click);
//
//dataGrid1
//
this.dataGrid1.AlternatingBackColor=System.Drawing.Color.WhiteSmoke;
this.dataGrid1.Anchor=(((System.Windows.Forms.AnchorStyles.Top|System.Windows.Forms.AnchorStyles.Bottom)
|System.Windows.Forms.AnchorStyles.Left)
|System.Windows.Forms.AnchorStyles.Right);
this.dataGrid1.BackColor=System.Drawing.Color.Gainsboro;
this.dataGrid1.BackgroundColor=System.Drawing.Color.Beige;
this.dataGrid1.CaptionBackColor=System.Drawing.Color.Blue;
this.dataGrid1.CaptionForeColor=System.Drawing.Color.Yellow;
this.dataGrid1.DataMember="";
this.dataGrid1.ForeColor=System.Drawing.Color.Navy;
this.dataGrid1.GridLineColor=System.Drawing.Color.Chocolate;
this.dataGrid1.HeaderBackColor=System.Drawing.Color.CadetBlue;
this.dataGrid1.HeaderFont=newSystem.Drawing.Font("MicrosoftSansSerif",10F,System.Drawing.FontStyle.Bold);
this.dataGrid1.HeaderForeColor=System.Drawing.Color.Brown;
this.dataGrid1.Location=newSystem.Drawing.Point(16,8);
this.dataGrid1.Name="dataGrid1";
this.dataGrid1.PreferredColumnWidth=-1;
this.dataGrid1.SelectionBackColor=System.Drawing.Color.Brown;
this.dataGrid1.SelectionForeColor=System.Drawing.Color.Aqua;
this.dataGrid1.Size=newSystem.Drawing.Size(512,224);
this.dataGrid1.TabIndex=0;

实现规模效益。与传统的用户拥有硬件软件所有权和使用权以及传统的应用服务商提供一对一的服务模式不同，ASP拥有应用系统所有权，用户拥有使用权，应用系统集中放在ASP的数据中心中，集中管理，分散使用，以一对多的租赁的形式为众多用户提供有品质保证的应用技术服务，实现规模效益。

ASP（ActiveServerPages）是Microsfot公司1996年11月推出的WEB应用程序开发技术，它既不是一种程序语言，也不是一种开发工具，而是一种技术框架，不须使用微软的产品就能编写它的代码，能产生和执行动态、交互式、高效率的站占服务器的应用程序。

学习是为了用的，是为了让你的程序产生价值，把握住这个原则会比较轻松点。除此之外，课外时间一定要多参加一些社会实践活动，来锻炼自己的能力。

封装性使得代码逻辑清晰，易于管理，并且应用到ASP.Net上就可以使业务逻辑和Html页面分离，这样无论页面原型如何改变，业务逻辑代码都不必做任何改动；继承性和多态性使得代码的可重用性大大提高。

Response:从字面上讲是“响应”，因此这个是服务端向客户端发送东西的，例如Response.Write

作为IE上广为流传的动态网页开发技术,ASP以它简单易学博得了广大WEB程序爱好这的青睐,而且它对运行环境和开发品台的不挑剔,以及有大量有效的参考手册,极大的推广了它的发展。

代码逻辑混乱，难于管理：由于ASP是脚本语言混合html编程，所以你很难看清代码的逻辑关系，并且随着程序的复杂性增加，使得代码的管理十分困难，甚至超出一个程序员所能达到的管理能力，从而造成出错或这样那样的问题。

那么，ASP.Net有哪些改进呢？

仓酷云

我可以结合自己的经验大致给你说一说，希望对你有所帮助，少走些弯路。