这是书本上例题的源码,但是不知道为什么会报错;
事件:
protected void Button4_Click(object sender, EventArgs e)
{
Sample21_1.Models.User user = new Sample21_1.Models.User();
int userID = user.register(UserName.Text.ToString(), RealName.Text.ToString(), Password.Text.ToString(),
Address.Text.ToString(), Phone.Text.ToString(), Email.Text.ToString(), 3, Re.Text.ToString());
if (userID == -1)
{
Response.Write("用户名已被占用!");
}
else if (userID == 0)
{
Response.Write("数据库访问失败!");
}
else
{
Session["username"] = UserName.Text.ToString();
Session["userID"] = userID;
//Response.Redirect("UserMain.aspx");
Response.Write("<script language=\"javascript\" type=\"text/javascript\">window.close();</script>");
}
}
public int register(string UserName, string RealName, string Password,
string Address, string phone, string Email, int RoleID, string Re)
{
//声明定义类型和方法的DataModelDataContext类的对象,它是调用模型和方法的基础。
DataModelDataContext data = new DataModelDataContext();
//调用方法Pr_Register获得所有的书籍信息 return data.(UserName, RealName, Password,Address, phone, Email, RoleID, Re);
//无法从“System.Data.Linq.ISingleResult<Sample21_1.Models.Pr_RegisterResult>”转换为“int”
//try
//{
// return int.Parse(data.Pr_Register(UserName, RealName, Password, Address, phone, Email, RoleID, Re));
//}
//catch
//{
// return 0;
//}
无法从“System.Data.Linq.ISingleResult<Sample21_1.Models.Pr_RegisterResult>”转换为“string”
} public partial class DataModelDataContext : DataContext
{
private static MappingSource mappingSource = new AttributeMappingSource();
#region 可扩展性方法定义
partial void OnCreated();
partial void InsertBook(Book instance);
partial void UpdateBook(Book instance);
partial void DeleteBook(Book instance);
partial void Insertcart(cart instance);
partial void Updatecart(cart instance);
partial void Deletecart(cart instance);
partial void InsertCategory(Category instance);
partial void UpdateCategory(Category instance);
partial void DeleteCategory(Category instance);
partial void InsertComment(Comment instance);
partial void UpdateComment(Comment instance);
partial void DeleteComment(Comment instance);
partial void InsertPicture(Picture instance);
partial void UpdatePicture(Picture instance);
partial void DeletePicture(Picture instance);
partial void InsertUser(User instance);
partial void UpdateUser(User instance);
partial void DeleteUser(User instance);
partial void InsertOrder(Order instance);
partial void UpdateOrder(Order instance);
partial void DeleteOrder(Order instance);
partial void InsertOrderList(OrderList instance);
partial void UpdateOrderList(OrderList instance);
partial void DeleteOrderList(OrderList instance);
partial void InsertSendWay(SendWay instance);
partial void UpdateSendWay(SendWay instance);
partial void DeleteSendWay(SendWay instance);
partial void InsertSendAddress(SendAddress instance);
partial void UpdateSendAddress(SendAddress instance);
partial void DeleteSendAddress(SendAddress instance);
#endregion
public DataModelDataContext() : base(System.Configuration.ConfigurationManager.ConnectionStrings["BookShopDBConnectionString1"].ConnectionString, mappingSource)
{OnCreated();}
public DataModelDataContext(string connection) :
base(connection, mappingSource)
{OnCreated();}
public DataModelDataContext(IDbConnection connection) :
base(connection, mappingSource)
{OnCreated();}
public DataModelDataContext(string connection, MappingSource mappingSource) :
base(connection, mappingSource)
{OnCreated();}
public DataModelDataContext(IDbConnection connection, MappingSource mappingSource) :
base(connection, mappingSource)
{OnCreated();}
public abstract class MappingSource
{
//
// 摘要:
// Initializes a new instance of the System.Data.Linq.Mapping.MappingSource class.
[TargetedPatchingOptOut("Performance critical to inline this type of method across NGen image boundaries")]
protected MappingSource();
// 摘要:
// 返回映射模型。
// 参数:
// dataContextType:
// 要返回的模型的 System.Data.Linq.DataContext 的类型。
// 返回结果:
// 与此映射源关联的映射模型。
public MetaModel GetModel(Type dataContextType);
// 摘要:
// 创建新的映射模型。
// 参数:
// dataContextType:
// 映射要基于的 System.Data.Linq.DataContext 的类型。
// 返回结果:
// 为匹配当前的映射架构而创建的元模型。
protected abstract MetaModel CreateModel(Type dataContextType);
}public sealed class AttributeMappingSource : MappingSource
{
//
// 摘要:
// 初始化 System.Data.Linq.Mapping.AttributeMappingSource 类的新实例。
[TargetedPatchingOptOut("Performance critical to inline this type of method across NGen image boundaries")]
public AttributeMappingSource(); protected override MetaModel CreateModel(Type dataContextType);
}
事件:
protected void Button4_Click(object sender, EventArgs e)
{
Sample21_1.Models.User user = new Sample21_1.Models.User();
int userID = user.register(UserName.Text.ToString(), RealName.Text.ToString(), Password.Text.ToString(),
Address.Text.ToString(), Phone.Text.ToString(), Email.Text.ToString(), 3, Re.Text.ToString());
if (userID == -1)
{
Response.Write("用户名已被占用!");
}
else if (userID == 0)
{
Response.Write("数据库访问失败!");
}
else
{
Session["username"] = UserName.Text.ToString();
Session["userID"] = userID;
//Response.Redirect("UserMain.aspx");
Response.Write("<script language=\"javascript\" type=\"text/javascript\">window.close();</script>");
}
}
public int register(string UserName, string RealName, string Password,
string Address, string phone, string Email, int RoleID, string Re)
{
//声明定义类型和方法的DataModelDataContext类的对象,它是调用模型和方法的基础。
DataModelDataContext data = new DataModelDataContext();
//调用方法Pr_Register获得所有的书籍信息 return data.(UserName, RealName, Password,Address, phone, Email, RoleID, Re);
//无法从“System.Data.Linq.ISingleResult<Sample21_1.Models.Pr_RegisterResult>”转换为“int”
//try
//{
// return int.Parse(data.Pr_Register(UserName, RealName, Password, Address, phone, Email, RoleID, Re));
//}
//catch
//{
// return 0;
//}
无法从“System.Data.Linq.ISingleResult<Sample21_1.Models.Pr_RegisterResult>”转换为“string”
} public partial class DataModelDataContext : DataContext
{
private static MappingSource mappingSource = new AttributeMappingSource();
#region 可扩展性方法定义
partial void OnCreated();
partial void InsertBook(Book instance);
partial void UpdateBook(Book instance);
partial void DeleteBook(Book instance);
partial void Insertcart(cart instance);
partial void Updatecart(cart instance);
partial void Deletecart(cart instance);
partial void InsertCategory(Category instance);
partial void UpdateCategory(Category instance);
partial void DeleteCategory(Category instance);
partial void InsertComment(Comment instance);
partial void UpdateComment(Comment instance);
partial void DeleteComment(Comment instance);
partial void InsertPicture(Picture instance);
partial void UpdatePicture(Picture instance);
partial void DeletePicture(Picture instance);
partial void InsertUser(User instance);
partial void UpdateUser(User instance);
partial void DeleteUser(User instance);
partial void InsertOrder(Order instance);
partial void UpdateOrder(Order instance);
partial void DeleteOrder(Order instance);
partial void InsertOrderList(OrderList instance);
partial void UpdateOrderList(OrderList instance);
partial void DeleteOrderList(OrderList instance);
partial void InsertSendWay(SendWay instance);
partial void UpdateSendWay(SendWay instance);
partial void DeleteSendWay(SendWay instance);
partial void InsertSendAddress(SendAddress instance);
partial void UpdateSendAddress(SendAddress instance);
partial void DeleteSendAddress(SendAddress instance);
#endregion
public DataModelDataContext() : base(System.Configuration.ConfigurationManager.ConnectionStrings["BookShopDBConnectionString1"].ConnectionString, mappingSource)
{OnCreated();}
public DataModelDataContext(string connection) :
base(connection, mappingSource)
{OnCreated();}
public DataModelDataContext(IDbConnection connection) :
base(connection, mappingSource)
{OnCreated();}
public DataModelDataContext(string connection, MappingSource mappingSource) :
base(connection, mappingSource)
{OnCreated();}
public DataModelDataContext(IDbConnection connection, MappingSource mappingSource) :
base(connection, mappingSource)
{OnCreated();}
public abstract class MappingSource
{
//
// 摘要:
// Initializes a new instance of the System.Data.Linq.Mapping.MappingSource class.
[TargetedPatchingOptOut("Performance critical to inline this type of method across NGen image boundaries")]
protected MappingSource();
// 摘要:
// 返回映射模型。
// 参数:
// dataContextType:
// 要返回的模型的 System.Data.Linq.DataContext 的类型。
// 返回结果:
// 与此映射源关联的映射模型。
public MetaModel GetModel(Type dataContextType);
// 摘要:
// 创建新的映射模型。
// 参数:
// dataContextType:
// 映射要基于的 System.Data.Linq.DataContext 的类型。
// 返回结果:
// 为匹配当前的映射架构而创建的元模型。
protected abstract MetaModel CreateModel(Type dataContextType);
}public sealed class AttributeMappingSource : MappingSource
{
//
// 摘要:
// 初始化 System.Data.Linq.Mapping.AttributeMappingSource 类的新实例。
[TargetedPatchingOptOut("Performance critical to inline this type of method across NGen image boundaries")]
public AttributeMappingSource(); protected override MetaModel CreateModel(Type dataContextType);
}
解决方案 »
- 教学系统的需求,有点疑惑,,希望各位给点意见
- 一个空间放两个 .net 网站,对应不同的域名有人做过没有?
- 修改图片后,必须手动刷新才显示新图片的问题
- 如何实现TreeView中嵌套CheckBox控件,如图。
- 到底是搞C/S模式赚钱,还是搞B/S模式赚钱?
- 向页面上打印html代码,怎么防止html被编码
- 问一个关于B/S结构的销售管理系统的相关或类似的程序.急啊.
- .net有没有Request.ServerVariables("HTTP_X_FORWARDED_FOR")和这个一样的函数啊
- 请教ASP。NET新手问题
- 求怎么用SQL语句向ACCESS数据库里写进一条含MEMO类型字段的纪录
- vs2017和19将代码放在独立的文件中
- Response.TransmitFile(FileName);用click调用后点击没反应
Pr_Register返回的不是int。
也试过这样: var result = data.Pr_Register(UserName, RealName, Password, Address, phone, Email, RoleID, Re);
DataTable table = new DataTable();
table = result.CopyToDataTable();
if (table != null)
{
if (Convert.ToInt32(table.Rows[0][0].ToString()) != 0)
return Convert.ToInt32(table.Rows[0][0].ToString());
else
return -1;
}
else
return 0;
能执行,但是还是会出错。返回值一直是-1.
return a ;//这里加断点 , 你看看 这a 是返回了一个什么玩意儿
然后有一个returnValue。