var orderExists = (Int32)ChkavailbleJobCMD.ExecuteScalar() > 0;
protected void LinkButton4_Click(object sender, EventArgs e) { JobsMView.ActiveViewIndex = 2; using (var UsOrderCon = new SqlConnection(cs)) { UsOrderCon.Open(); string chksBervJobsSt = "Select JobNum, Jobtitle, Dept, VacCountry, Employer from jobs where Employer=@Emp"; SqlCommand ChkavailbleJobCMD = new SqlCommand(chksBervJobsSt, UsOrderCon); ChkavailbleJobCMD.Parameters.AddWithValue("@Emp", "Berava"); var orderExists = (Int32)ChkavailbleJobCMD.ExecuteScalar() > 0; if (orderExists) { jobsAvaPan.Visible = true; SqlDataAdapter BervJonavaADPA = new SqlDataAdapter("SELECT JobNum, Jobtitle, Dept, VacCountry, Employer FROM jobs WHERE Employer = @Emp ", cs); BervJonavaADPA.SelectCommand.Parameters.AddWithValue("@Emp", "Berava"); DataSet BervJonavaDST = new DataSet(); BervJonavaADPA.Fill(BervJonavaDST); GridView1.DataSource = BervJonavaDST.Tables[0]; GridView1.DataBind(); } else { NoJobAvPan.Visible = true; NoJobLbl.Text = "Sorry, we don't have any job available at the moment"; } } }
Select JobNum, Jobtitle, Dept, VacCountry, Employer from jobs where Employer=@Emp
Select count(*) from jobs where Employer=@Emp
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)