SqlDataBase ThisB = new SqlDataBase();
string CheckSql = "select count(*) from UserList where UserName = '" + UserName + "' and PassWord = '" + PassWord + "'";
int ThisNum = Convert.ToInt32(ThisB.ReturnSQL(CheckSql));这里老是说:System.FormatException: 输入字符串的格式不正确。出错就错在:int ThisNum = Convert.ToInt32(ThisB.ReturnSQL(CheckSql))这行,请问该怎么处理,请高手指点下,我看到有人网上说这里输出下,可是我这个是在一个cs文件的类里,我该怎么输出,用response.write又说不允许使用。求教,求教,我是.net新手
string CheckSql = "select count(*) from UserList where UserName = '" + UserName + "' and PassWord = '" + PassWord + "'";
int ThisNum = Convert.ToInt32(ThisB.ReturnSQL(CheckSql));这里老是说:System.FormatException: 输入字符串的格式不正确。出错就错在:int ThisNum = Convert.ToInt32(ThisB.ReturnSQL(CheckSql))这行,请问该怎么处理,请高手指点下,我看到有人网上说这里输出下,可是我这个是在一个cs文件的类里,我该怎么输出,用response.write又说不允许使用。求教,求教,我是.net新手
解决方案 »
- 求各位帮我看看这个问题....
- 高分求解决方案.net2005下 如何不同项目共享 session :???
- System.InvalidCastException: Specified cast is not valid. 是什么错误?
- “大侠求助!”请问如何将js自动生成的文本框内的值插入到数据库啊?
- (挑战性问题)如何用ASP.net读取图片的颜色值?
- 菜鸟来报到!!!!散分!
- 在ASP.NET with C#中,怎么控制IE标准按钮、地址栏等等的显示问题!!!!!
- 一个filters的问题!
- 如果是一个控制台程序,怎么调用javascript?
- 关于gridview的绑定跳转
- 从数据类型 nvarchar 转换为 int 时出错。
- 网站更改该了一个页面,需要整站编译重新上传吗?
{
SqlDataBase ThisB = new SqlDataBase();
string CheckSql = "select count(*) from UserList where UserName = '" + UserName + "' and PassWord = '" + PassWord + "'";
int ThisNum = Convert.ToInt32(ThisB.ReturnSQL(CheckSql)); return ThisNum;}
看看是什么
CheckSql不就是返回的count吗
tring CheckSql = "select count(*) from UserList where [UserName] = '" + UserName + "' and [PassWord] = '" + PassWord + "'";System.Web.HttpContext.Current.Response.Write(ThisB.ReturnSQL(CheckSql)); //看是什么
//int ThisNum = Convert.ToInt32(ThisB.ReturnSQL(CheckSql));
using System.Data;
using System.Data.SqlClient;
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;/// <summary>
/// CheckLogin 的摘要说明
/// </summary>
public class CheckLogin
{
public CheckLogin()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public int GiveID(string UserName, string PassWord)
{
SqlDataBase ThisB = new SqlDataBase();
string CheckSql = "select count(*) from UserList where UserName = '" + UserName + "' and PassWord = '" + PassWord + "'";
System.Web.HttpContext.Current.Response.Write(ThisB.ReturnSQL(CheckSql));
int ThisNum = Convert.ToInt32(ThisB.ReturnSQL(CheckSql));
if (ThisNum > 0)
{
string SqlType = "select * from UserList where UserName = '" + UserName + "' and PassWord = '" + PassWord + "'";
SqlDataReader ThRead = ThisB.GRead(SqlType);
while (ThRead.Read())
{
return Convert.ToInt32(ThRead["ID"]);
}
}
return 0;
} private void mbox(string p)
{
throw new NotImplementedException();
}
public static bool CheckAdmin(int UserID)
{
SqlDataBase MyDb = new SqlDataBase();
string Log = Convert.ToString(MyDb.ReturnSQL("select UserType from UserList Where ID = '" + UserID + "'"));
if (Log == "1")
{
return true;
}
else
{
return false;
}
}
public static int GiveCheckAd(int UserID)
{
SqlDataBase MyDb = new SqlDataBase();
int Log = Convert.ToInt32(MyDb.ReturnSQL("select GoodsType from UserList Where ID = '" + UserID + "'"));
return Log;
}
public static DataTable GiveMsgGod(int UserID) //返回对应仓库的数量超限产品
{
SqlDataBase MyDb = new SqlDataBase();
int Log = Convert.ToInt32(MyDb.ReturnSQL("select Controls from UserList Where ID = '" + UserID + "'"));
string SqlString = "";
if (Log == 0)
{
SqlString = "select * from View_GoodMsg";
}
else
{
SqlString = "select * from View_GoodMsg where ID = '"+Log+"'";
}
return MyDb.DT(SqlString);
}
public static bool CheckKeepAdmin(int UserID)
{
SqlDataBase MyDb = new SqlDataBase();
string Log = Convert.ToString(MyDb.ReturnSQL("select GoodsType from UserList Where ID = '" + UserID + "'"));
if (Log == "0")
{
return true;
}
else
{
return false;
}
}
}
{
public SqlDataBase()
{
//
// TODO: 在此处添加构造函数逻辑
// }
private SqlConnection Cn;
private SqlCommand Cm;
private DataSet ds;
private DataView dv; #region
private void Open()
{
Cn = new SqlConnection(ConfigurationSettings.AppSettings["Dsn"]);
Cn.Open();
}
#endregion #region 关闭连接
private void Close()
{
if (Cn != null)
{
Cn.Close();
Cn.Dispose();
}
}
#endregion #region 执行简单的SQL语句
public void NoreturnSql(string Sql)
{
Open();
Cm = new SqlCommand(Sql, Cn);
Cm.ExecuteNonQuery();
Close();
}
#endregion
怎么没看见ReturnSQL(CheckSql)这个函数?
异常详细信息: System.FormatException: 输入字符串的格式不正确。源错误:
行 26: string CheckSql = "select count(*) from UserList where UserName = '" + UserName + "' and PassWord = '" + PassWord + "'";
行 27: // System.Web.HttpContext.Current.Response.Write(ThisB.ReturnSQL(CheckSql));
行 28: int ThisNum = int.Parse(ThisB.ReturnSQL(CheckSql).ToString().Trim());
行 29:
行 30: //int ThisNum = Convert.ToInt32(ThisB.ReturnSQL(CheckSql));
源文件: d:\WuZiGuanLi_51aspx\App_Code\CheckLogin.cs 行: 28 还是不行啊
SqlDataBase ThisB = new SqlDataBase();
string CheckSql = "Declare @RowCount int ;select RowCount =count(*) from UserList where UserName = '" + UserName + "' and PassWord = '" + PassWord + "' RETURN RowCount ";
int ThisNum = Convert.ToInt32(ThisB.ReturnSQL(CheckSql));试试。准可以!
public DataRow GetRow(string Sqlstr)
{ SqlDataAdapter da = new SqlDataAdapter(Sqlstr, Sqlcoon);
DataSet ds = new DataSet(); da.Fill(ds, "TableName");
return ds.Tables[0].Rows[0];
}SqlDataBase ThisB = new SqlDataBase();
string CheckSql = "select count(*) as Cut from UserList where UserName = '" + UserName + "' and PassWord = '" + PassWord + "'";
DataRow dr = GetRow(CheckSql);
int count = System.Convert.ToInt32(dr["Cut"].ToString());这样就可以了