資源簡介
c# 學生選課系統

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
namespace?course
{
????class?Database
????{
????????public?static?string?connStr?=?“Data?Source=.\\SQLEXPRESS;Initial?Catalog=DBSelect;Integrated?Security=true“;
????????//public?static?string?connStr;
????????public?static?SqlConnection?conn?=?new?SqlConnection(connStr);
????????//“讀”數據的靜態方法
????????public?static?DataSet?GetDataFromDB(string?sqlStr)
????????{
????????????conn.Open();
????????????SqlDataAdapter?MyAdapter?=?new?SqlDataAdapter(sqlStrconn);
????????????DataSet?MyDataSet?=?new?DataSet();
????????????MyDataSet.Clear();
????????????MyAdapter.Fill(MyDataSet);
????????????conn.Close();
????????????if?(MyDataSet.Tables[0].Rows.Count?!=?0)
????????????{
????????????????return?MyDataSet;
????????????}
????????????else
????????????{
????????????????return?null;
????????????}
????????}
????????//“寫“數據的方法
????????public?static?bool?UpdataDB(string?sqlStr)
????????{
????????????conn.Open();
????????????//定義數據命令對象
????????????SqlCommand?myCdm?=?new?SqlCommand(sqlStrconn);
????????????//設置Command對象的CommandType的屬性
????????????myCdm.CommandType?=?CommandType.Text;
????????????//執行SQl語句
????????????myCdm.ExecuteNonQuery();
????????????conn.Close();
????????????//數據庫更新成功,返回true
????????????return?true;
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????45568??2015-04-25?17:38??course\course\bin\Debug\course.exe
?????文件??????89600??2015-04-25?17:38??course\course\bin\Debug\course.pdb
?????文件??????11600??2015-05-11?16:42??course\course\bin\Debug\course.vshost.exe
?????文件????????490??2010-03-17?22:39??course\course\bin\Debug\course.vshost.exe.manifest
?????文件???????4882??2014-11-23?13:10??course\course\course.csproj
?????文件???????1520??2014-11-18?11:40??course\course\Databa
?????文件???????9893??2014-11-23?19:17??course\course\Formcourse.cs
?????文件??????11488??2014-11-23?19:14??course\course\Formcourse.Designer.cs
?????文件???????5817??2014-11-23?19:14??course\course\Formcourse.resx
?????文件????????362??2014-11-23?13:10??course\course\FormHelp.cs
?????文件???????3120??2014-11-23?13:10??course\course\FormHelp.Designer.cs
?????文件???????5817??2014-11-23?13:10??course\course\FormHelp.resx
?????文件???????4442??2014-11-23?13:17??course\course\FormMain.cs
?????文件???????6107??2014-11-23?13:17??course\course\FormMain.Designer.cs
?????文件???????5817??2014-11-23?13:15??course\course\FormMain.resx
?????文件??????11854??2014-12-22?22:20??course\course\FormSelect.cs
?????文件??????14467??2014-11-23?20:14??course\course\FormSelect.Designer.cs
?????文件???????5817??2014-11-23?20:14??course\course\FormSelect.resx
?????文件??????11616??2014-12-22?22:20??course\course\FormStudent.cs
?????文件??????10722??2014-11-23?13:48??course\course\FormStudent.Designer.cs
?????文件???????5817??2014-11-23?13:48??course\course\FormStudent.resx
?????文件???????5026??2014-12-22?22:20??course\course\FrmLogin.cs
?????文件???????4890??2014-11-23?12:56??course\course\FrmLogin.Designer.cs
?????文件???????6011??2014-11-23?12:56??course\course\FrmLogin.resx
?????文件???????2723??2015-05-11?16:42??course\course\obj\x86\Debug\course.csproj.FileListAbsolute.txt
?????文件??????45568??2015-04-25?17:38??course\course\obj\x86\Debug\course.exe
?????文件????????180??2014-11-23?19:16??course\course\obj\x86\Debug\course.Formcourse.resources
?????文件????????180??2014-11-23?19:02??course\course\obj\x86\Debug\course.FormHelp.resources
?????文件????????180??2014-11-23?19:02??course\course\obj\x86\Debug\course.FormMain.resources
?????文件????????180??2014-11-23?20:14??course\course\obj\x86\Debug\course.FormSelect.resources
............此處省略34個文件信息
- 上一篇:C#計算器含源碼
- 下一篇:RPLIDAR A2 C#.rar
評論
共有 條評論