private void BtnSearch_Click(object sender, System.EventArgs e)
{
string Searchstr="";
SqlDataAdapter searchCmd;
DataSet searchDs;
DataTable searchTable;
DataRow searchRow;
switch(this.Cmbtype.SelectedIndex)
{
case -1:
MessageBox.Show("请先选择查询类型");
return;
break;
case 0:
if(this.TxtSearch.Text.Length==0)
{
MessageBox.Show("请输入查询条件");
return;
}
else
{
Searchstr="select * from tblbooks where BookID='"+this.TxtBookID.Text+"'";
}
break;
case 1:
if(this.TxtSearch.Text.Length==0)
{
MessageBox.Show("请输入查询条件");
return;
}
else
{
Searchstr="select * from tblbooks where BookID='"+this.TxtBookName.Text+"'";
}
break;
case 2:
Searchstr="select count(BookName) from tblbooks";
searchDs=new DataSet();
searchCmd=new SqlDataAdapter(Searchstr,con);
try
{
searchCmd.Fill(searchDs,"tblbooks");
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
searchTable=searchDs.Tables[0];
searchRow=searchTable.Rows[0];
MessageBox.Show("图书总数为:"+searchRow[0].ToString());
break;
}
 一个简单的查询处理,出现异常了:
未处理的“System.IndexOutOfRangeException”类型的异常出现在 system.data.dll 中。其他信息: 无法找到表 0。