出错的是这一行?
public static string strCon = "Data Source =(local);database=control_OAdb ; uid = sa;pwd =";
public static string strCon = "Data Source =(local);database=control_OAdb ; uid = sa;pwd =";
解决方案 »
- 【求助】asp.net+mysql登陆验证和权限分级
- asp.net关于ajax
- vs2010 连接服务器上的oracle数据库问题 在线等
- 我的网站后台莫名的总是多数据??高手帮忙看看!!
- 递归问题,应该很简单!
- 怎么实现事务
- 关闭Connection前检查一下有没有和它关联的DataReader没关闭,如何得到和它关联的DataReader?
- listbox中的多个项,但无论选中哪个,点确定按钮时都显示是第一项被选中,为什么,怎么解决?
- 大伙都是俺的MVP,帮忙看看Attributes.Add和alert是啥意思?!
- 从sql2000动态生成的数据如何转成excel文件并可从web页面下载
- 数据条目问题,select count 高手请进
- Bestcomy.Web.Controls.Upload控件问题?
DDLdep.DataTextField = "tag";
DDLdep.DataValueField = "tag_id";
DDLdep.DataBind();
public void CheckConnection()
{
con.Open();
}后面及时关闭!
三楼说的地方也要注意下!
private const String SqlString = "server=.;uid=sa;pwd=sa;database=b2bcn;Connect Timeout=20000";
public SqlConnection Connection;
//打开
public void Open()
{
Connection = new SqlConnection(SqlString);
if (Connection.State.Equals(ConnectionState.Closed))
{
Connection.Open();
}
} //关闭数据库连接。
public void Close()
{
if (Connection != null)
{
Connection.Close();
Connection.Dispose();
}
} /// <summary>
/// 获取DataSet
/// </summary>
/// <param name="SqlString">SQL语句</param>
/// <returns></returns>
public DataSet GetDataSet(String SqlString)
{
Open();
SqlDataAdapter adapter = new SqlDataAdapter(SqlString, Connection);
DataSet dataset = new DataSet();
adapter.Fill(dataset);
adapter.Dispose();
Close();
return dataset;
} //获取列
public DataRow GetDataRow(string SqlString)
{
DataRow datarow = GetDataSet(SqlString).Tables[0].Rows[0];
return datarow;
} /// <summary>
/// 检测记录是否存在
/// </summary>
/// <param name="SqlString">SQL语句</param>
/// <returns></returns>
public bool Execute(String SqlString)
{
Open();
SqlCommand cmd = new SqlCommand(SqlString, Connection);
cmd.CommandTimeout = 800;
cmd.Dispose();
if (cmd.ExecuteReader().Read())
{
return true;
}
else
{
return false;
}
} /// <summary>
/// 返回记录行数
/// </summary>
/// <param name="SqlString">SQL语句</param>
/// <returns></returns>
public int ExcuteInt(string SqlString)
{
Open();
SqlDataAdapter ds = new SqlDataAdapter(SqlString, Connection);
DataSet myds = new DataSet();
ds.Fill(myds);
return myds.Tables[0].Rows.Count;
} /// <summary>
/// 上传图片
/// </summary>
/// <param name="MyUpfile">上传控件</param>
/// <param name="newpath">服务器相对路经</param>
/// <returns>返回图片名称加后缀</returns>
public string Uploadfile(FileUpload MyUpfile, string newpath,string returnpath)
{
if (MyUpfile.FileName != "")
{
string pic = DateTime.Now.Millisecond.ToString() + DateTime.Now.ToFileTimeUtc().ToString(); //随机名
int istrat = MyUpfile.FileName.LastIndexOf('.');
int ilenght = MyUpfile.FileName.Length;
int iend = ilenght - istrat;
string accpho = MyUpfile.FileName.Substring(istrat, iend); //后缀
string pho = newpath + pic + accpho;
string pho2 = returnpath + pic + accpho;
MyUpfile.SaveAs(System.Web.HttpContext.Current.Server.MapPath(pho));
return pho2;
}
return null;
} /// <summary>
/// 清除图片
/// </summary>
/// <param name="picpath">图片相对路经</param>
/// <returns></returns>
public bool Delpic(string picpath)
{
FileInfo F = new FileInfo(System.Web.HttpContext.Current.Server.MapPath(picpath));
if (F.Exists)
{
F.Delete();
return true;
}
else
{
return false;
}
} /// <summary>
/// 分页
/// </summary>
/// <param name="page">分页参数</param>
/// <param name="sql">SQL语句</param>
/// <returns></returns>
public PagedDataSource GetDatePage(string page,string sql)
{
PagedDataSource mypage = new PagedDataSource();
int i;
if (HttpContext.Current.Request.QueryString[page] == null || !int.TryParse(HttpContext.Current.Request.QueryString[page].ToString(),out i))
{
mypage.CurrentPageIndex = 0;
}
else
{
mypage.CurrentPageIndex = Convert.ToInt32(HttpContext.Current.Request.QueryString[page]) - 1;
}
mypage.DataSource = GetDataSet(sql).Tables[0].DefaultView;
mypage.AllowPaging = true;
return mypage;
} /// <summary>
/// 检测URL是否有恶意码
/// </summary>
/// <param name="Str">内容</param>
/// <param name="Regstr">以strcode隔开</param>
/// <param name="Strcode">分隔符</param>
/// <param name="Message">错误时输出内容</param>
public void RegUrl(string Str,string Regstr,char Strcode,string Message)
{
string[] p=Regstr.Split(Strcode);
for (int i = 0; i < p.Length; i++)
{
if (Str != Str.Replace(p[i],""))
{
//HttpContext.Current.Response.Write(Message);
HttpContext.Current.Response.End();
}
}
} /// <summary>
/// 截取字串
/// </summary>
/// <param name="Str">内容</param>
/// <param name="num">显示长度</param>
/// <param name="addstr">追加字串</param>
/// <returns></returns>
public string Dstr(string Str, int num, string addstr)
{
if (Str != null)
{
if (Str.Length > num)
{
string mystr;
mystr = Str.Substring(0, num) + addstr;
return mystr;
}
else
{
return Str;
}
}
else
{
return null;
}
}我基本上不用bill层