c#代码注释

来源:百度知道 编辑:UC知道 时间:2024/09/20 03:08:02
public class BaseClass
{

public static SqlConnection DBCon()
{
return new SqlConnection("server=.;database=db_ExamOnline;uid=sa;pwd=");
}

public static void BindDG(GridView dg, string id, string strSql, string Tname)
{
SqlConnection conn = DBCon();
SqlDataAdapter sda = new SqlDataAdapter(strSql, conn);
DataSet ds = new DataSet();
sda.Fill(ds, Tname);
dg.DataSource = ds.Tables[Tname];
dg.DataKeyNames = new string[] { id };
dg.DataBind();
}
public static void OperateData(string strsql)
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand(strsql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
//================如果是学生登录=========================================
public static bool

public class BaseClass
{

public static SqlConnection DBCon() //下面连接数据库写的代码
{
return new SqlConnection("server=.;database=db_ExamOnline;uid=sa;pwd=");
}

public static void BindDG(GridView dg, string id, string strSql, string Tname)
{
SqlConnection conn = DBCon(); //创建连接数据库
SqlDataAdapter sda = new SqlDataAdapter(strSql, conn);//传入参数
DataSet ds = new DataSet(); //声明并且初始化dataSet
sda.Fill(ds, Tname); //填充
dg.DataSource = ds.Tables[Tname];//邦定数据源
dg.DataKeyNames = new string[] { id };//数组法?现在不提倡了 用起来麻烦
dg.DataBind(); //邦定到GridView 控件
}
public static void OperateData(string strsql) //将strsql传入此方法内
{
SqlConnection conn = DBCon(); //查ungjian连接数据库
conn.Open(); //打开数据库
SqlCommand cmd = new SqlCommand(strsql, conn); //执行参数传递过来的命令
cmd.ExecuteNonQuery(); //返回值
conn.Close(); //关闭数据库
}
//================如果是学生登录=========================