本文整理汇总了C#中DataBaseConnection类的典型用法代码示例。如果您正苦于以下问题:C#DataBaseConnection类的具体用法?C#DataBaseConnection怎么用?C#DataBaseConnection使用的例子?这里精选的类代码示例或许可以为您提供帮助。
示例1:GetListSchools
publicList
GetListSchools()
{
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