在VS2005环境下asp.net中连接数据库问题
各位大虾们,感谢大家抽空看的的贴子.
帮忙看看下面这个类里边连接数据库的部分哪儿错了.
我用的编辑器是visual studio 2005,下面是一个ASP.NET项目,开发的一个小网站,语言为C#
主要错误在两个重载函数( mySelect)中,
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace flower
{
/// <summary>
/// DBOP 的摘要说明。
/// </summary>
public class DBOP
{
public DBOP()
{
//
// TODO: 在此处添加构造函数逻辑
}
private SqlConnection myConn = new SqlConnection("server=localhost;database=flower;uid=sa;pwd=851009;");
//private String ms=System.Configuration.ConfigurationManager.ConnectionStrings["sqlConnectionString"].ToString();
//private String mystr="Data Source=ZHAOQI-96F2B4FD\SQLEXPRESS;AttachDbFilename=|DataDirectory|\flower.mdf;Initial Catalog=flower;Persist Security Info=True;User ID=sa;password=851009";
//private SqlConnection myConn = new SqlConnection(ms) ;
private SqlCommand myComm ;
private SqlDataAdapter myDA;
private DataSet myDS;
public object mySelect(string strComm, int mode) //参数mode表明这是使用myComm.executescaler()。
{
if (mode == 1)
{
object myObject;
myComm = new SqlCommand(strComm, this.myConn);
myConn.Open();
myObject = myComm.ExecuteScalar();
myConn.Close();
return myObject;
}
else
{
return null;
}
}
//下面是新方法
public DataSet mySelect(string strComm)//查询操作,返回含有查询结果的DataSet。
{
myDA = new SqlDataAdapter(strComm,myConn);
//this.myConn.Open();
myDS = new DataSet();
myDA.Fill(myDS);
return myDS;
}
public DataSet mySelect(string strComm, int RsCount, int PageSize)
{
myDA = new SqlDataAdapter(strComm, myConn);
myDS = new DataSet();
myDA.Fill(myDS, (RsCount - 1) * PageSize, PageSize, "myTable");
return myDS;
}
public bool myAdd(string strComm)//添加操作,返回是否操作成功。true为成功,false为不成功。
{
bool flag = false;
myComm = new SqlCommand(strComm, myConn);
try
{
myConn.Open();
if (myComm.ExecuteNonQuery() > 0)
{
flag = true;
}
myConn.Close();
}
catch (Exception ex)
{
string errormeg = ex.ToString();
return false;
}
return flag;
}
public bool myDelete(string strComm)//删除操作,返回是否操作成功。true为成功,false为不成功。
{
bool flag = false;
myComm = new SqlCommand(strComm, myConn);
try
{
myConn.Open();
if (myComm.ExecuteNonQuery() > 0)
{
flag = true;
}
myConn.Close();
}
catch
{
return false;
}
return flag;
}
public bool myUpdate(string strComm)//修改操作,返回是否操作成功。true为成功,false为不成功。
{
bool flag = false;
myComm = new SqlCommand(strComm, myConn);
try
{
myConn.Open();
if (myComm.ExecuteNonQuery() > 0)
{
flag = true;
}
myConn.Close();
}
catch
{
return false;
}
return flag;
}
}
}
谢谢