• 大小: 5.48MB
    文件类型: .rar
    金币: 1
    下载: 0 次
    发布日期: 2023-09-18
  • 语言: C#
  • 标签: 源码  c#  sqlserver  asp.net  

资源简介

某大学网络教学平台全部源码(经典)c#某大学网络教学平台全部源码(经典)c#

资源截图

代码片段和文件信息

using System;

namespace Teaching.DAC
{
/// 
/// 对数据源连接字符串构成的封装,可以生成不同数据源的连接字符串。
/// 

public class ConnectionStringHelper
{
public ConnectionStringHelper()
{
//
// TODO: Add constructor logic here
//
}

// 创建Sql Server以用户授权方式访问的数据库连接字符串
// “Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;“ 
static public string CreateSqlConnectionString(string server string database string userId string password)
{
string connectionString = ““;

if(server == null || server == ““ || database == null || database == ““ || userId == null || userId == ““)
{
return connectionString;
}
connectionString = “Data Source=“ + server + “;Initial Catalog=“ + database + “;User Id=“ + userId + “;Password=“ + password + “;Connect Timeout=30;“;
return connectionString;
}

// 创建Sql Server以安全模式访问的数据库连接字符串
// “Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;“  - or - “Server=Aron1;Database=pubs;Trusted_Connection=True;“ 
static public string CreateSqlConnectionString(string server string database)
{
string connectionString = ““;

if(server == null || server == ““ || database == null || database == ““)
{
return connectionString;
}
            connectionString = “Data Source=“ + server + “;Initial Catalog=“ + database + “;Integrated Security=SSPI;Connect Timeout=30;“;
return connectionString;
}

// 创建Sql Server的OleDb数据源类型的连接字符串
// “Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;“
static public string CreateSqlOleDbConnectionString(string dataSource string database string userId string password)
{
string connectionString = ““;

if(dataSource == null || dataSource == ““ || database == null || database == ““ || userId == null || userId == ““)
{
return ““;
}
            connectionString = “Provider=sqloledb;Data Source=“ + dataSource + “;Initial Catalog=“ + database + “;User Id=“ + userId + “;Password=“ + password + “;Connect Timeout=30;“;
return connectionString;
}

// 创建Sql Server的OleDb的数据源类型的连接字符串
// “Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;“ 
static public string CreateSqlOleDbConnectionString(string dataSource string database)
{
string connectionString = ““;

if(dataSource == null || dataSource == ““ || database == null || database == ““)
{
return ““;
}
            connectionString = “Provider=sqloledb;Data Source=“ + dataSource + “;Initial Catalog=“ + database + “;Integrated Security=SSPI;Connect Timeout=30;“;
return connectionString;
}

// 创建Oracle连接字符串-信任模式 “Data Source=MyOracleDB;Integrated Security=yes;“ 
static public string CreateOracleConnectionString(string dataSource)
{
string connectionString = ““;

if(dataSource == null || dataSource == ““)
return connectionString;
            connectionString = 

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件      28160  2010-02-28 18:44  Teaching.User\bin\Debug\Teaching.DAC.dll

     文件     112128  2010-02-28 18:44  Teaching.User\bin\Debug\Teaching.DAC.pdb

     文件      67584  2010-03-09 20:59  Teaching.User\bin\Debug\Teaching.MOD.dll

     文件     386560  2010-03-09 20:59  Teaching.User\bin\Debug\Teaching.MOD.pdb

     文件      72704  2010-03-09 20:59  Teaching.User\bin\Debug\Teaching.User.dll

     文件     144896  2010-03-09 20:59  Teaching.User\bin\Debug\Teaching.User.pdb

     文件       7168  2010-03-09 20:59  Teaching.User\bin\Debug\Teaching.Utility.dll

     文件      15872  2010-03-09 20:59  Teaching.User\bin\Debug\Teaching.Utility.pdb

     文件       6646  2010-03-09 20:59  Teaching.User\obj\Debug\ResolveAssemblyReference.cache

     文件        697  2010-03-09 20:59  Teaching.User\obj\Debug\Teaching.User.csproj.FileListAbsolute.txt

     文件      72704  2010-03-09 20:59  Teaching.User\obj\Debug\Teaching.User.dll

     文件     144896  2010-03-09 20:59  Teaching.User\obj\Debug\Teaching.User.pdb

     文件       1452  2008-11-20 11:28  Teaching.User\Properties\AssemblyInfo.cs

     文件      41363  2009-09-05 20:57  Teaching.User\SqlStudentDAL.cs

     文件      26008  2009-08-20 22:01  Teaching.User\SqlSysUserDAL.cs

     文件      41555  2009-10-07 23:05  Teaching.User\SqlTeacherDAL.cs

     文件      13703  2009-06-20 23:23  Teaching.User\SqlUserGroupDAL.cs

     文件      39237  2010-01-31 18:24  Teaching.User\SqlUserInfoDAL.cs

     文件      13292  2010-01-22 23:10  Teaching.User\SqlUserTypeDAL.cs

     文件       5538  2009-06-13 08:22  Teaching.User\StudentDAL.cs

     文件        640  2008-11-20 11:41  Teaching.User\StudentDALFactory.cs

     文件        238  2009-08-14 22:02  Teaching.User\SysUserBLL.cs

     文件       4850  2009-08-20 21:46  Teaching.User\SysUserDAL.cs

     文件        640  2008-11-20 11:41  Teaching.User\SysUserDALFactory.cs

     文件       5609  2009-10-06 15:20  Teaching.User\TeacherDAL.cs

     文件        640  2008-11-20 11:41  Teaching.User\TeacherDALFactory.cs

     文件       3976  2009-08-14 22:32  Teaching.User\Teaching.User.csproj

     文件      13946  2009-09-05 11:16  Teaching.User\UserBLL.cs

     文件       4650  2009-06-20 23:22  Teaching.User\UserGroupDAL.cs

     文件        646  2008-11-20 11:41  Teaching.User\UserGroupDALFactory.cs

............此处省略2176个文件信息

评论

共有 条评论