try
        {
            string strConn = "Data Source=.;Initial Catalog=MTB;Integrated Security=True";
            DataSet DNA1 = new DataSet();
            DataSet DNA2 = new DataSet();
            string strSql = "select * from Analysis;";
            SqlDataAdapter odda1;
            SqlDataAdapter odda = new SqlDataAdapter(strSql, strConn);
            odda.Fill(DNA1);//出错点
            DataTable dt = DNA1.Tables[0];
            DataRow[] dr = dt.Select();
            DataTable dt2;
            DataRow[] dr2;
            int rowsNum = dt.Rows.Count;
            int PositionInDNA, id;
            float SiteNo;
            string GeneID;
            //遍历获取的Analysis内容  dr[行][列] 下标索引从0开始  
            for (int i = 0; i < rowsNum; i++)
            {
                id = Convert.ToInt32(dr[i][0].ToString());
                GeneID = dr[i][2].ToString();
                PositionInDNA = Convert.ToInt32(dr[i][1].ToString());
                SiteNo = Convert.ToInt32(dr[i][4].ToString());
                string strSql2 = "select Strand, GeneSeq from GeneSeq where GeneID = '" + GeneID + "';";
                odda1 = new SqlDataAdapter(strSql2, strConn);
                odda1.Fill(DNA2);
                dt2 = DNA2.Tables[0];
                dr2 = dt2.Select();
                string strand = dr2[i][0].ToString();
                string geneSeq = dr2[i][1].ToString();
                if (strand == "+")
                {
                    string Alt_Codon = geneSeq.Substring((int)(SiteNo - 1) * 3, 3);
                    uploadExcelFileBiz.Add9(Alt_Codon,Alt_Codon,id);
                }
                else if (strand == "-")
                {
                    string Alt_Codon = geneSeq.Substring((int)(SiteNo - 1) * 3 - 2, 3);
                    uploadExcelFileBiz.Add9(Alt_Codon,id);
                }
            }
            Response.Write("<script>alert('突变率计算成功！')</script>");
        }
        catch
        {
            Response.Write("<script>alert('突变率计算失败！')</script>");
            return;
        }