各位大神来帮帮我解决下

[hfdianjing]

[Function(Name = "proc_books")]
public IMultipleResults proc_books(
[Parameter(Name = "@bookname", DbType = "varchar(200)")] string name,
[Parameter(Name = "@booknum", DbType = "int")] int booknum,
[Parameter(Name = "@bookprice", DbType = "int")] int bookprice,
[Parameter(Name = "@booktype", DbType = "varchar(20)")]string booktype)
{
IExecuteResult result = this.ExecuteMethodCall
(this, MethodInfo.GetCurrentMethod() as MethodInfo, name, booknum, bookprice, booktype);
return result.ReturnValue as IMultipleResults;
}


private void button2_Click(object sender, EventArgs e)
{
Model.dbSQL db = new Model.dbSQL();
dataGridView1.DataSource = db.proc_books(this.txtname.Text.ToString(), Convert.ToInt32(this.txtnum.Text),
Convert.ToInt32(txtprice.Text), this.txttype.Text.ToString()).GetResult<Model.buyBookRecord> ().ToList();


}

提示报 没有返回IMultipleResults的函数"proc_books"声明结果类型

[EnForGrass]

[Function(Name = "proc_books")]
[ResultType(typeof(Model.buyBookRecord))]
public IMultipleResults proc_books(
[Parameter(Name = "@bookname", DbType = "varchar(200)")] string name,
[Parameter(Name = "@booknum", DbType = "int")] int booknum,
[Parameter(Name = "@bookprice", DbType = "int")] int bookprice,
[Parameter(Name = "@booktype", DbType = "varchar(20)")]string booktype)
{
IExecuteResult result = this.ExecuteMethodCall
(this, MethodInfo.GetCurrentMethod() as MethodInfo, name, booknum, bookprice, booktype);
return result.ReturnValue as IMultipleResults;
}

[hfdianjing]

[Quote=引用 1 楼 的回复:]
[Function(Name = "proc_books")]
[ResultType(typeof(Model.buyBookRecord))]
public IMultipleResults proc_books(
[Parameter(Name = "@bookname", DbType = "varchar(200)")] string name,
[Paramet……
修改了修改完了提示bookName不存在[/Quote]

[hfdianjing]

dataGridView1.DataSource = db.proc_books(this.txtname.Text.ToString(), Convert.ToInt32(this.txtnum.Text),
Convert.ToInt32(txtprice.Text), this.txttype.Text.ToString()).GetResult<Model.buyBookRecord>().ToList();

报 所需的列“bookName”在结果中不存在

[EnForGrass]

[Quote=引用 3 楼 的回复:]

dataGridView1.DataSource = db.proc_books(this.txtname.Text.ToString(), Convert.ToInt32(this.txtnum.Text),
Convert.ToInt32(txtprice.Text), this.txttype.Text.ToString()).GetResult<Model.bu……
[/Quote]
是没有bookName，只有bookNum，在检查一下

[hfdianjing]

[Quote=引用 4 楼 的回复:]
引用 3 楼 的回复:

dataGridView1.DataSource = db.proc_books(this.txtname.Text.ToString(), Convert.ToInt32(this.txtnum.Text),
Convert.ToInt32(txtprice.Text), this.txttype.Text.ToString()).GetResult<Model.……

[Table(Name = "buyBookRecord")]
public class buyBookRecord
{
//图书名称
[Column(Name = "bookName",IsPrimaryKey=true)]
public string bookName { get; set; }
//图书数量
[Column(Name = "bookNum")]
public int bookNum { get; set; }
//图书价格
[Column(Name = "bookPrice")]
public int bookPrice { get; set; }
[Column(Name = "bookTypeName")]
//图书所属类别
public string bookTypeName { get; set; }
[Column(Name = "buyDate")]
public DateTime buyDate { get; set; }

}
#endregion这个里面有[/Quote]

[EnForGrass]

[Quote=引用 5 楼 的回复:]

引用 4 楼 的回复:
引用 3 楼 的回复:

dataGridView1.DataSource = db.proc_books(this.txtname.Text.ToString(), Convert.ToInt32(this.txtnum.Text),
Convert.ToInt32(txtprice.Text), this.txttype.Text.ToString()).G……
[/Quote]
先保证存储过程没错,LINQ TO SQL 调用存储过程
参考http://www.cnblogs.com/lovecherry/archive/2007/08/18/860935.html