asp.net读取文件并添加到数据库（linq+asp.net）

 

 protected void Unnamed1_Click(object sender, EventArgs e)
    {
        string filename = @"C:\Documents and Settings\huanghui\桌面\中行多支行数据.dat";
        string line;
        string[] stringArray;
        try
        {
            using (StreamReader sr = new StreamReader(filename, Encoding.Default))
            {
                while ((line = sr.ReadLine()) != null)
                {

                    stringArray = line.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
                    if (stringArray.Length == 14 || stringArray.Length == 15)
                    {
                        List<string> list = new List<string>();

                        Response.Write("</br></br>");
                        for (int i = 0; i < stringArray.Length; i++)
                        {
                            list.Add(stringArray[i]);
                            //  Response.Write(list[i] + "</t>");
                        }
                        change(list);
                    }
                }
            }
        }
        catch (Exception ex)
        {
            Response.Write("失败:"); Response.Write(ex.Message);
        }
    }

    private void change(List<string> list)
    {
        daily model = new daily();
        model.customerID = list[0].ToString();
        model.customerName = list[1].ToString();
        model.productCode = list[2].ToString();
        model.lendmAark = list[3].ToString();
        model.loanDate = Convert.ToDateTime(list[4]);
        model.termMonth = list[5].ToString();
        model.limitDatys = list[6].ToString();
        model.lanPactSum = list[7].ToString();
        model.lanSum = list[8].ToString();
        model.notDayCorpus = list[9].ToString();
        model.oweLoanBalance = Convert.ToDouble(list[10]);
        model.oweAccrual = Convert.ToDouble(list[11]);
        model.publishSum = Convert.ToDouble(list[12]);
        model.sysSortResult = list[13].ToString();
        if (list.Count == 14)
        {
            model.handSortResult = "";
        }
        else
        {
            model.handSortResult = list[14].ToString();
        }
        Insert(model);

    }
    /// <summary>
    /// 对表dbo.daily中数据进行添加
    /// </summary>
    /// <param name="model">要添加的实体对象</param>

    public void Insert(daily model)
    {
        db.daily.InsertOnSubmit(model);
        db.SubmitChanges();
    }