需要帮助修复我的内部联接SQL语句和C＃代码

debugcn 发表于 Dev

威廉·J

我有2张桌子，我正在寻找的是：

JobApplic 该表包含：

ApplicNum, 
JobNum, 
UID "this is the employer", 
Jobtitle, 
AplicUID " this is job seeker"

CVs 该表包含：

CVNum, 
UID (here in this table is the job seeker) , 
FN, 
LN, 
etc....

声明像这样，但我不是很专业，无法以正确的方式编写：

select 
from [JobApplic] ApplicNum, JobNum, UID, Jobtitle, AplicUID 
where 
     UID 
into table JobApplic = session["UsrNme"], 
inner join table [CVs] UID,FN, LN, ... 
Where UID into table CVs = ApplicUID into table JobApplic"

该代码的意思是，当雇主进入他的帐户时，他将能够看到所有由雇主发布的求职者的简历。

protected void ViewapplCV_Click(object sender, EventArgs e)
{
    if (Session["UsrNme"] != null)
    {
        using (SqlConnection AppCVsSQLCon = new SqlConnection(sc))
        {
            AppCVsSQLCon.Open();

            SqlDataAdapter ApplCVsDAADP = new SqlDataAdapter(@"
               SELECT AD.[ApplicNum], AD.[JobNum], AD.[UID], AD.[Jobtitle],
                      AD.[AplicUID], UI.[UID], UI.[FN], UI.[LN] 
               FROM [JobApplic] AS AD JOIN CVs AS UI ON AD.[UID] = UI.[UID] 
               WHERE AD.UID = @UID AND AD.AplicUID = UI.UID", sc);

            var use = Session["UsrNme"];

            ApplCVsDAADP.SelectCommand.Parameters.AddWithValue("@UID", use);

            DataSet dsApplCVs = new DataSet();

            ApplCVsDAADP.Fill(dsApplCVs);

            showapplicforemployrLV.DataSource = dsApplCVs.Tables[0];
            showapplicforemployrLV.DataBind();
        }
    }
    else
    {
        // Your Session key could not be found, consider displaying an error
    }

    MultiView1.ActiveViewIndex = 12;
}

史蒂夫

如果我正确理解这些表之间的关系，则查询应为

SqlDataAdapter ApplCVsDAADP = new SqlDataAdapter(@"
   SELECT AD.[ApplicNum],AD.[JobNum],AD.[UID],AD.[Jobtitle],
          AD.[AplicUID],UI.[UID],UI.[FN],UI.[LN] 
   FROM [JobApplic] as AD JOIN CVs as UI ON AD.[AplicUID] = UI.[UID] 
   WHERE AD.UID = @UID", sc);

您说在第一个表AplicUID中 “这是求职者”，在第二个表中UID （此处是求职者），因此您需要在这两个字段之间建立联接，而无需重复在WHERE子句中再次建立关系

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。