protected void srjobs()
    {
        //sql1.Open();
        //SqlCommand com = new SqlCommand(str, sql1);
        //SqlDataAdapter da = new SqlDataAdapter(com);
        //da.Fill(ds,"hrjob");
        dbclass cl = new dbclass();

        cl.srchjobs(ds, str);
        DataTable a1 = new DataTable("a1");

        a1.Columns.Add("jobid", typeof(string));
        a1.Columns.Add("location", typeof(string));
        a1.Columns.Add("jobdetails1", typeof(string));
        a1.Columns.Add("jobdetails2", typeof(string));
        DataRow drow;
        int     k = ds.Tables["hrjob"].Rows.Count;
        int     l = 0;

        while (l < k)
        {
            drow                = a1.NewRow();
            drow["jobid"]       = ds.Tables["hrjob"].Rows[l]["jobid"];
            drow["location"]    = ds.Tables["hrjob"].Rows[l]["location"];
            drow["jobdetails1"] = ds.Tables["hrjob"].Rows[l]["name"] + ", Min Exp : " + ds.Tables["hrjob"].Rows[l]["exp_req"] + ", Salary : " + ds.Tables["hrjob"].Rows[l]["salary"];
            drow["jobdetails2"] = ds.Tables["hrjob"].Rows[l]["position"] + ", Degree : " + ds.Tables["hrjob"].Rows[l]["qual1"] + ", " + ds.Tables["hrjob"].Rows[l]["qual2"] + ", Preferred Skills  = " + ds.Tables["hrjob"].Rows[l]["skill1"] + ", " + ds.Tables["hrjob"].Rows[l]["skill2"];
            a1.Rows.Add(drow);
            l++;
        }
        if (k == 0 && a == false)
        {
            grid.Visible = true;
            grid.Text    = "No Jobs Found.";
        }
        if (a == true && k > 0)
        {
            grid.Visible = true;
            grid.Text    = "There are " + k + " Jobs in your Network.";
        }
        ds.Tables.Add(a1);
        //ds.Tables["a1"].Columns.Add() = ds.Tables["hr_jobpost"].Columns["location"];
        GridView1.DataSource = ds.Tables["a1"];
        GridView1.DataBind();
        //sql1.Close();
    }