不知道这次写程序查询的结果总是为空
public string strConn = ConfigurationManager.AppSettings["connString"].ToString() + HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"].ToString()) + ";";
public int executNum(string strsql)
{
using (OleDbConnection conn = new OleDbConnection(strConn))
{
using (OleDbCommand cmd = new OleDbCommand(strsql, conn))
{
try
{
conn.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (OleDbException e)
{
throw new Exception(e.Message);
}
finally
{
conn.Close();
}
}
}
}
#region 管理员登录查询
// public int adminlogin(string Parameter, string Table, string Para, string GetName)
public int adminlogin(string Sqlstr)
{
string strsql = Sqlstr;
int i = executNum(strsql);
return i;
//if (i < 0)
//{
// return false;
//}
//else
//{
// return true;
//}
}
#endregion------------------以上为DB文件
protected void Button1_Click(object sender, EventArgs e)
{
MyClass logins = new MyClass();
//int checklogin= logins.adminlogin("kname,kPass", "KUser", "kname", "'" + Qxx + "' and kPass='" + PassW + "'");
// IDbHelper idbhelper = new DbHelperSQL();
int checklogin = logins.adminlogin("Select * from YSK_user");
Label1.Text = checklogin.ToString();
}
刚开始有参数的总是为空,后来直接Select * from YSK_user,结果返回查询条数仍然为0,程序特简单,而且数据库连接都是对的,表,字段名也正确,数据库权限也没问题。请您帮帮忙,谢谢
public string strConn = ConfigurationManager.AppSettings["connString"].ToString() + HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"].ToString()) + ";";
public int executNum(string strsql)
{
using (OleDbConnection conn = new OleDbConnection(strConn))
{
using (OleDbCommand cmd = new OleDbCommand(strsql, conn))
{
try
{
conn.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (OleDbException e)
{
throw new Exception(e.Message);
}
finally
{
conn.Close();
}
}
}
}
#region 管理员登录查询
// public int adminlogin(string Parameter, string Table, string Para, string GetName)
public int adminlogin(string Sqlstr)
{
string strsql = Sqlstr;
int i = executNum(strsql);
return i;
//if (i < 0)
//{
// return false;
//}
//else
//{
// return true;
//}
}
#endregion------------------以上为DB文件
protected void Button1_Click(object sender, EventArgs e)
{
MyClass logins = new MyClass();
//int checklogin= logins.adminlogin("kname,kPass", "KUser", "kname", "'" + Qxx + "' and kPass='" + PassW + "'");
// IDbHelper idbhelper = new DbHelperSQL();
int checklogin = logins.adminlogin("Select * from YSK_user");
Label1.Text = checklogin.ToString();
}
刚开始有参数的总是为空,后来直接Select * from YSK_user,结果返回查询条数仍然为0,程序特简单,而且数据库连接都是对的,表,字段名也正确,数据库权限也没问题。请您帮帮忙,谢谢
解决方案 »
- 文本框中每输入一个字符,在Grid中显示该示该内容的结果, 用 ajax怎么做?
- linq添加数据的问题
- 关于oracle数据库中 大量数据分页的问题!
- .net中执行SQL查询语句的怪异问题
- 关于 ListBox 的问题
- 超时时间已到。超时时间已到,但是尚未从池中获取连接!
- 如何把DataSet里面的数据再倒进SQL Server里面?
- oracle 表中有一date字段,要把系统当前时间插入表中,sql怎么写呢?
- 一个小问题,请教大家,
- [求助]有关datagrid的问题,高手快来帮帮忙拉
- GridView的简单问题
- 请教关于Win2kServer+SqlServer2005下页面不能显示的问题。谢谢大家
=========
Select count(*) from YSK_user
Select count(*) from YSK_user
cmd.ExecuteScalar()
{
using (OleDbConnection conn = new OleDbConnection(strConn))
{
DataSet ds = new DataSet();
try
{
string strsql = "select " + Field + " from " + Table;
conn.Open();
OleDbDataAdapter ODDA = new OleDbDataAdapter(strsql, conn);
ODDA.Fill(ds);
}
catch (OleDbException e)
{
throw new Exception(e.Message);
}
finally
{
conn.Close();
}
return ds;
}
}
--------------------------
DataSet dss = logins.getList("Uname,Upass", "Users");
this.tryDataList.DataSource = dss.Tables["Uname"];
this.tryDataList.DataBind();
输出还是为空。疯了
this.tryDataList.DataSource = dss.Tables["Users"];