需要一个多表绑定的代码

Question

ALTER PROCEDURE [dbo].[Op_Email_ChengJiFaSong] (@Email char(50)='')
AS
BEGIN
SELECT     dbo.jw_xsb.xm, dbo.jw_cjb.xh,  dbo.jw_kmb.xq,dbo.jw_cjb.cjzp1, dbo.jw_cjb.cjzp2, dbo.jw_cjb.cjzp3, dbo.jw_cjb.cjzp4,
           dbo.jx_kcb.Kcmc, dbo.jx_kcb.xs
FROM           dbo.jx_kcb INNER JOIN
                      dbo.jw_kmb ON dbo.jx_kcb.Kcbh = dbo.jw_kmb.kcbh INNER JOIN
                      dbo.jw_cjb ON dbo.jw_kmb.zdbhsk = dbo.jw_cjb.zdbhsk INNER JOIN
                      dbo.jw_xsb ON dbo.jw_cjb.xh = dbo.jw_xsb.xh 
                      where jw_xsb .email =@Email 
                      order by xq 

END
怎样把这个存储过程，用到C#的Windows服务中。请把代码写一下，谢谢!!

Answer 1

 var query = from j in db.jx_kcb
                    join k in db.jw_kmb
                    on j.kcbh equals kkcbh
                    join c in db.jw_cjb
                    on k.zdbhsk equals c.zdbhsk
                    join x in db.jw_xsb
                    on c.xh equals x.xh
                    orderby k.xq
                    where x.email == "email"
                    select new
                    {
                        x.xm,
                        c.xh,
                        k.xq,
                        c.cjzp1,
                        c......                    };

Answer 2

楼上的是用LINQ 的技术，lz 上网搜一下就一大把啦

Answer 3

去googl 找 C# 调用存储过程public void Exec()
{

using(System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("连接串自己写")) //这个不会到微乳msdn 网站搜 SqlConnection
using(var cmd =conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "[dbo].[Op_Email_ChengJiFaSong]";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@Email",System.Data.SqlDbType.Char,50);
using(System.Data.IDataReader reader = cmd.ExecuteReader())
{
while(reader.Read())
{
System.Diagnostics.Debug.WriteLine(reader["xm"]); //列1
System.Diagnostics.Debug.WriteLine(reader["xh"]); //列1
System.Diagnostics.Debug.WriteLine(reader["...."]); //列N
}
}
}
}

Answer 4

conn.Open();
cmd.CommandText = "[dbo].[Op_Email_ChengJiFaSong]";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@Email",System.Data.SqlDbType.Char,50);
cmd.Parameters["@Email"].Value ="$email 地址写上你要的$"; //哦忘记了
using(System.Data.IDataReader reader = cmd.ExecuteReader())
{
while(reader.Read())
{
System.Diagnostics.Debug.WriteLine(reader["xm"]); //列1
System.Diagnostics.Debug.WriteLine(reader["xh"]); //列1
System.Diagnostics.Debug.WriteLine(reader["...."]); //列N
}
}

Answer 5

请问要怎么把那些值全部提取到一个string body里面？？