大哥们来帮忙
public partial class found : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection sqlconn = new SqlConnection("server=localhost;database=招式;uid=sa;pwd=320123");
string nam = DropDownList2.SelectedValue;
string str = "select 系别,力敌抗性,灵巧抗性,群攻抗性,普通抗性 from 所有招式 where 招式名称='"+nam +"'order by 主修等级";
sqlconn.Open();
SqlCommand sqlcmd = new SqlCommand(str, sqlconn);
string liruo="无",qiaoruo="无",qunruo="无",puruo="无";
int kangruo;
int i=0;
string[] mystring=new string[19];
SqlDataReader sqlreader = sqlcmd.ExecuteReader();
if (sqlreader.Read())
{
string xibie = sqlreader["系别"].ToString ();
int lidi = Convert.ToInt32(sqlreader.GetValue(1));
int lingqiao = Convert.ToInt32(sqlreader.GetValue(2));
int qungong = Convert.ToInt32(sqlreader.GetValue(3));
int putong = Convert.ToInt32(sqlreader.GetValue(4));
switch (xibie )//选择的这一个抗性要大于0(未完成)
{
case "力敌":
kangruo = 3; break ;
case "灵巧":
kangruo = 4; break ;
case "群攻":
kangruo = 5; break ;
default :
kangruo = 6; break ;
}
//系别要是对方的招式要是弱点(完成)
if (lidi <= 0)
{
liruo = "力敌";
}
if (lingqiao <= 0)
{
qiaoruo = "灵巧";
}
if (qungong <= 0)
{
qunruo = "群攻";
}
if (putong <= 0)
{
puruo = "普通";
}
sqlreader.Close();
sqlreader.Dispose();
string search = "select 流派,系别,招式名称,力敌抗性,灵巧抗性,群攻抗性,普通抗性 from 所有招式 where 系别='" + liruo + "'or 系别='" + qiaoruo + "'or 系别='" + qunruo + "'or 系别='" + puruo + "'order by 流派,主修等级";
SqlCommand sqlcomd2 = new SqlCommand(search, sqlconn);
SqlDataReader sqlreader2 = sqlcomd2.ExecuteReader();
if (sqlreader2 .Read () )//我想在sqldataread中选择符合条件的数据存入数组,再绑定到girdview中
{
if (Convert.ToInt32(sqlreader2.GetValue(kangruo)) > 0)
{
mystring[i] = sqlreader2.ToString();
i++;
}
}
GridView2.DataSource =mystring ;
GridView2.DataBind();//在容器中未找到数据项。容器必须实现 IDataItemContainer 或者具有名为 DataItem 的属性。
}
sqlconn.Close();
sqlconn.Dispose();
}
哪位大哥能帮帮忙,找出错误,或者给我好的方法,谢谢啦