C#
帮我查一下这里程序有没问题？？
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区using System;
using System.Data;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace doughty_cn
{
/// <summary>
/// DBOperate 的摘要说明。
/// </summary>
public class DBOperate
{
public DBOperate()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
//输入SELECT语句，获得返回数据集
public static DataTable SelectFormForum(string sql,int start,int size,string tablename)
{
try
{
SqlConnection sqlConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["DBConnection"]);
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, sqlConnection);
DataSet returns = new DataSet();
sqlAdapter1.Fill(returns,start,size,tablename);
return returns.Tables[0];
}
catch (Exception ex)
{
throw (ex);
}
}
public static DataTable SelectFormForum(string sql)
{
try
{
SqlConnection sqlConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["DBConnection"]);
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, sqlConnection);
DataSet returns = new DataSet();
sqlAdapter1.Fill(returns);
return returns.Tables[0];
}
catch (Exception ex)
{
throw (ex);
}
}
//返回一条记录
public static DataRow GetDataRow(string sql,string TableName,string dbname)
{
try
{
SqlConnection sqlConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings[dbname]);
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, sqlConnection);
DataSet product = new DataSet();
sqlAdapter1.Fill(product, TableName);
return product.Tables[0].Rows[0];
}
catch (Exception ex)
{
throw (ex);
}
}
//执行SQL语句，如UPDATE，INSERT等
public static void ExcSQL(string s)
{
SqlConnection sqlConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["DBConnection"]);
try
{
SqlCommand sqlCmd =new SqlCommand(s,sqlConnection);
sqlConnection.Open();
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw (ex);
}
finally
{
sqlConnection.Close();
}
}
//获取用户短消息条数
public static int ShortMsgCount(string UserName)
{
try
{
string s="SELECT COUNT(*) AS cun FROM ShortMessage WHERE (systemmsg = 0) AND (Readed = 0) AND (UserName = '"+UserName+"')";
DataRow dr=GetDataRow(s,"ShortMessage","DBConnection");
return System.Convert.ToInt32(dr["cun"].ToString());
}
catch
{
return 0;
}
}
//计算总共有多少条问题
public static int CalculateQRecord(int BID,int SID,int solved)
{
try
{
string s="SELECT COUNT(*) AS co FROM Questions WHERE (BigClass_ID = "+BID+") AND (SmallClass_ID = "+SID+") AND (kind > 0) AND (kind < 5) AND (solved = "+solved+")";
DataRow dr=GetDataRow(s,"Questions","DBConnection");
return System.Convert.ToInt32(dr["co"].ToString());
}
catch
{
return 0;
}
}
//计算总共有多少条回复
public static int CalculateARecord(int QID)
{
try
{
string s="SELECT COUNT(*) AS co FROM Answers WHERE (Question_ID = "+QID+")";
DataRow dr=GetDataRow(s,"Answers","DBConnection");
return System.Convert.ToInt32(dr["co"].ToString());
}
catch
{
return 0;
}
}
}
}
问题是无法打开登录所请求的数据库 "doughty_bbs"。登录失败。
用户 'sa' 登录失败。我拖了一个Gridview测试了一下没问题。
...全文
