public void SelectItem(int i)
{
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
string mySelectQuery =
"select ItemNO,ItemName from ts_AO_Item order by ItemNO";
SqlDataAdapter myCommand = new SqlDataAdapter(mySelectQuery,myConnection);
myConnection.Open();
DataSet ds = new DataSet();
myCommand.Fill(ds,"data");
AddxmDs(ds);
item.DataSource=ds.Tables["data"].DefaultView;
item.DataBind();
myConnection.Close();
}
private void AddxmDs(DataSet ds)
{
ds.Tables[0].Rows[0]["ItemNO"]="-1";
ds.Tables[0].Rows[0]["ItemName"]="- 全部 -";
}