本文介绍了缺少操作数错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在这里编写了程序.我在这里遇到这样的错误.
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
这篇关于缺少操作数错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!