本文介绍了缺少操作数错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我在这里编写了程序.我在这里遇到这样的错误.

here i wrote the program. here i am getting error like this.

private void GetData()
{
  con = new SqlConnection(cons);
  string query  = "Select PersonId, Lastname, Firstname, Hiredate, EnrollmentDate from Person";
  DataSet ds=new DataSet();
  da = new SqlDataAdapter(query,con);
  da.Fill(ds, "person");
  DataTable mytable = ds.Tables["Person"];
  DataRow[] row = mytable.Select("Select PersonID=1");
  gv1.DataSource = row;
  gv1.DataBind();
}


PersonID运算符后缺少操作数.


Missing operand after PersonID operator.

推荐答案

DataRow[] row = mytable.Select("Select PersonID=1");

成为

DataRow[] row = mytable.Select("PersonID=1");


protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=test;Integrated Security=True");
        string statment = "select item_code, Item_name, brand, size, section, price, Material, Qty, tax, tt  from Items ";
        SqlDataAdapter da = new SqlDataAdapter(statment, con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        DataRow[] foundRows = ds.Tables[0].Select("item_code = 1", " item_code DESC", DataViewRowState.CurrentRows);
        //this is for create datatable with same schema like the orginal one .
        string statment2 = "select item_code, Item_name, brand, size, section, price, Material, Qty, tax, tt  from Items where  item_code = 0";
        SqlDataAdapter da2 = new SqlDataAdapter(statment2, con);
        DataTable dt = new DataTable();

        da2.Fill(dt);
        DataRow dr = dt.NewRow();
        foreach (DataRow row in foundRows)
        {
            dr[0] = row[0];
            dr[1] = row[1];
            dr[2] = row[2];
            dr[3] = row[3];
            dr[4] = row[4];
            dr[5] = row[5];
            dt.Rows.Add(dr);
        }
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }





<div>
       <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="true">
       </asp:GridView>
</div>



最好的问候
米特瓦里(M.Mitwalli)



Best Regards
M.Mitwalli


这篇关于缺少操作数错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

06-20 09:15