📄 termlib.cs
字号:
using System;
using System.Data;
using System.Data.SqlClient;
namespace Njnu.DAL
{
/// <summary>
/// TermLib 的摘要说明。
/// </summary>
public class TermLib
{
public DataTable GetTermLibByCateID(string cateID)
{
DataTable dt = new DataTable();
SqlParameter[] parameters = {};
string str = "select * from TermLib where cateID = '" + cateID + "'";
using(SqlDatabase sqlDB = new SqlDatabase(str, parameters))
{
sqlDB.Run(dt);
}
return dt;
}
public DataTable GetTermLib()
{
DataTable dt = new DataTable();
SqlParameter[] parameters = {};
string str = "select * from TermLib";
using(SqlDatabase sqlDB = new SqlDatabase(str, parameters))
{
sqlDB.Run(dt);
}
return dt;
}
public DataTable GetCateID()
{
DataTable dt = new DataTable();
SqlParameter[] parameters = {};
string str = "select distinct(cateID) from TermLib";
using(SqlDatabase sqlDB = new SqlDatabase(str, parameters))
{
sqlDB.Run(dt);
}
return dt;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -