System.Web.Services.Protocols.SoapException: 服务器无法处理请求。 特急

[kke_007]

System.Web.Services.Protocols.SoapException: 服务器无法处理请求。 ---> System.NullReferenceException: 未将对象引用设置到对象的实例。
在 Service.Login(String username, String pwd)
--- 内部异常堆栈跟踪的结尾 ---

using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
using System.Data;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
public Service () {

//如果使用设计的组件，请取消注释以下行
//InitializeComponent();
}

[WebMethod]
public int Login(string username,string pwd)
{
DataRow dr= LuhooLogin(username, pwd);
if (dr != null)
{
Session.Add("l_Name", dr["Id"].ToString());
Session.Add("l_id", dr["UserName"].ToString());
return 1;
}
else {
return 0;
}
}

private DataRow LuhooLogin(string name, string pwd) {
pwd = MD5(pwd, true);
string sql = string.Format("select * from xys_sys_User where UserName='{0}' and UserPassword ='{1}'",name,pwd);
DataSet ds= FillDS(sql);
if (ds == null) {
return null;
}
if (ds.Tables[0].Rows.Count > 0)
{
return ds.Tables[0].Rows[0];
}
else {
return null;
}
}


private string MD5(string Input, bool Half)
{
string output = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(Input, "MD5").ToLower();
if (Half)//16位MD5加密（取32位加密的9~25字符）
output = output.Substring(8, 16);
return output;
}

private SqlConnection getConn()
{
try
{
String connString;
connString = "server=.;uid=xys;pwd=xuey;database=XYSCMS;";
SqlConnection myConnection1 = new SqlConnection(connString);
return myConnection1;
}
catch (Exception e)
{
// Display the error.
return null;
Console.WriteLine(e.ToString());
}
}

/// <summary>
/// 查询
/// </summary>
/// <param name="sql"></param>
/// <returns>datase</returns>
private DataSet FillDS(string sql)
{
SqlConnection conn = getConn();
try
{
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(sql, conn);
ad.Fill(ds);
return ds;
}
catch
{

}
finally
{
conn.Close();
}
return null;
}

}


调用

Service FlashNetLogin = new Service();
int i = FlashNetLogin.Login("kke_007", "646516");
if (i == 0)
{
Response.Write("失败");
}
else
{
Response.Redirect("http://192.168.0.2:8080/first.aspx");
}

[Lakers_24号程序员]

请检查你这里面
/// <summary>
/// 查询
/// </summary>
/// <param name="sql"> </param>
/// <returns>datase </returns>
private DataSet FillDS(string sql)
{
SqlConnection conn = getConn();
try
{
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(sql, conn);
ad.Fill(ds);
return ds;
}
catch
{

}
finally
{
conn.Close();
}
return null;
}

}

是否返回了dataset

[kke_007]

好像跟本就不会调用

[Lakers_24号程序员]

你这webservice 断点是不会进这里面的来。

[wuyq11]

LuhooLogin函数执行问题
SqlConnection sqlConnection1 = new SqlConnection("");
SqlCommand sqlCmd = new SqlCommand("SELECT * FROM table1",sqlConnection1); sqlConnection1.Open();
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(sqlCmd);
DataSet result =new DataSet();
sqlDataAdapter1.Fill(result);
sqlConnection1.Close();


DataRow dr中字段是否正确

[wuyq11]

有对象为null值，添加try catch判断

[kke_007]

不行

[zhouzangood]

关注下

[gongsun]

DataRow dr= LuhooLogin(username, pwd);


这个东西,看看 dr 有没有附上值。

[吕津]

帮顶

[jzj083271930]

怎么没有正确答案呢？我也在等啊！

[jackeyabc]

asdfsdfsadfsadf

[bin410384195]

事隔多年 我看看对有没有帮助