返回首页

您好所有!

我试图从数据库检索一些值,并显示在GridView。当我上da.fill运行的应用程序,它给我的错误(DS)

Cannot call methods on text.
我搜索网上,但有没有关于这个错误的信息。

这里是代码的。aspx
{C} 这里是代码。aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

 

public partial class Employer_EmployerViewResume : System.Web.UI.Page

{

    SqlConnection con;

    protected void Page_Load(object sender, EventArgs e)

    {

        if (Session["Employer"] == null )

        {

            Response.Redirect("EmployerLogin.aspx");

        }

        con = new SqlConnection(ConfigurationManager.ConnectionStrings["Constr"].ConnectionString);

        con.Close();

        

        databind();

    }

 

    private void databind()

    {

        con.Open();

       

 

        SqlDataAdapter da =  new  SqlDataAdapter("Select a.Name , a.JobTitle , a.UserId , a.JobID ,a.Status,a.AppliedDate,b.MobileNo, b.Email,b.ProfessionalQualification,b.TotalExpYear.b.TotalExpMonth,b.CurrentLocation from Applied a join JobSeeker b on a.UserId= b.UserId order by a.Status DESC ,a.AppliedDate ASC",  con) ;

        DataSet ds = new DataSet();

        da.Fill(ds);

        GridView1.DataSource = ds;

        GridView1.DataBind();

        con.Close();

    }

}

回答

评论会员: 时间:2
s