SqlConnection Con = new SqlConnection(FunComponent.GetConnString());
SqlDataAdapter da;
DataTable dt1 = new DataTable();
string sql = "select FltNo from dtFltDetails where Origin='"+TextBox3.Text.Trim()+"' and Destination='"+TextBox4.Text.Trim()+"'";
da = new SqlDataAdapter(sql,Con);

try
{
Con.Open();
da.Fill(dt1);
for (int j = 0; j < dt1.Rows.Count;j++ )
{
DataTable dt2 = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter("select * from dtStatus where FltNo='" + dt1.Rows[j]["FltNo"].ToString() + "' and StatusDate='" + DropDownList1.SelectedItem.Value + DropDownList2.SelectedItem.Value + DropDownList3.SelectedItem.Value + "'", Con);
da1.Fill(dt2);

if (dt2.Rows.Count == 0)
{
DataTable dt3=new DataTable();
SqlDataAdapter da2 = new SqlDataAdapter("select FltNo,SeatsExec,SeatsBn from dtFltDetails where Origin='" + TextBox3.Text.Trim() + "'and Destination='" + TextBox4.Text.Trim() + "'", Con);
da2.Fill(dt3);
SqlCommand Com = new SqlCommand("insert into dtStatus(FltNo,StatusDate,ExecStatus,BnStatus) values('" + dt3.Rows[0]["FltNo"].ToString() + "','" + DropDownList1.SelectedItem.Value + DropDownList2.SelectedItem.Value + DropDownList3.SelectedItem.Value + "','" + dt3.Rows[0]["SeatsExec"].ToString() + "','" + dt3.Rows[0]["SeatsBn"].ToString()+"'", Con);
Com.ExecuteNonQuery();
}
}
}

为什么程序到da1.Fill(dt2);就执行不下去了

SqlConnection sqlConn = new SqlConnection(str);str = 连接数据库的字符串
sqlCommand sqlComm = new sqlCommand(strSql,sqlConn);strSql = sql语句
sqlDataAdapter sda = new sqlDataAdapter();
sqlDataSet ds = new sqlDataSet();
sda.SelectCommand = sqlComm;
sda.Fill(ds);

一般我是这么用的,我想你那个问题有可能是SQL语句出错啦,你先检查一下