"景先生毕设|www.jxszl.com

C# DataBaseConnection类代码示例

2023-12-29 17:48编辑: www.jxszl.com景先生毕设
本文整理汇总了C#中DataBaseConnection类的典型用法代码示例。如果您正苦于以下问题:C#DataBaseConnection类的具体用法?C#DataBaseConnection怎么用?C#DataBaseConnection使用的例子?这里精选的类代码示例或许可以为您提供帮助。 示例1:GetListSchools publicListGetListSchools() { Listlist=newList(); Schoolscins; //...DatabaseConnection... DataBaseConnectiondbConn=newDataBaseConnection(); SqlConnectioncon=dbConn.SqlConn(); SqlCommandcmdI; //...SQLCommands... cmdI=newSqlCommand("SELECT*FROMSchools",con); cmdI.Connection.Open(); SqlDataReaderdrI=cmdI.ExecuteReader(); //...RetrieveData... if(drI.HasRows) { while(drI.Read()) { ins=newSchoolsc(); ins.SchoolId=Convert.ToInt32(drI["SchoolId"]); ins.ClientId=Convert.ToInt32(drI["ClientId"]); ins.SchoolName=drI["SchoolName"].ToString(); ins.Schoolabbreviation=drI["Schoolabbreviation"].ToString(); ins.PictureId=Convert.ToInt32(drI["PictureId"]); list.Add(ins); } } drI.Close(); con.Close(); returnlist; }
原文链接:http://www.jxszl.com/biancheng/C/556840.html