001.protected void btImport_Click(object sender, System.EventArgs e)
002. {
003.
004.
005. List<testdbl> lsTestdbl = new
006. List<testdbl>();
007.
008.
009. if (FileUpload1.HasFile && Path.GetExtension(FileUpload1.FileName) == ".xlsx")
010.
011. {
012.
013. using (var excel = new
014. ExcelPackage(FileUpload1.PostedFile.InputStream))
015. {
016.
017.
018.
019. var worksheet = excel.Workbook.Worksheets.First();
020.
021.
022.
023.
024. for (int row = 2; row <= worksheet.Dimension.End.Row; row++)
025. {
026.
027.
028. var PersonID = worksheet.Cells[row, 1].Value;
029. var PersonName = worksheet.Cells[row, 2].Value;
030. var PersonAge = worksheet.Cells[row, 3].Value;
031. var PersonCity = worksheet.Cells[row, 4].Value;
032. var PersonBugged = worksheet.Cells [row,5].Value;
033.
034.
035.
036.
037.
038.
039.
040. lsTestdbl.Add(new testdbl
041.
042. {
043. id = PersonID ==null ? "" : PersonID.ToString(),
044. name = PersonName == null ? "" : PersonName.ToString(),
045. age = PersonAge == null ? "" : PersonAge.ToString(),
046. city = PersonCity == null ? "" : PersonName.ToString(),
047. bugget =PersonBugged == null ? "" : PersonBugged.ToString()
048.
049.
050. });
051.
052.
053. }
054.
055. using (ADMS dc = new ADMS())
056. {
057.
058. foreach (var item in lsTestdbl)
059. {
060. var q = dc.testdbls.Where(t => t.id == item.id).FirstOrDefault();
061.
062. if (q == null)
063. {
064.
065. var newPs = new testdbl
066.
067. {
068.
069. id = item.id,
070. name = item.name,
071. age = item.age,
072. city = item.city,
073. bugget = item.bugget
074. };
075. dc.testdbls.InsertOnSubmit(newPs);
076. dc.SubmitChanges();
077.
078. }
079.
080.
081. }
082. }
083.
084.
085. GridView1.DataSource = lsTestdbl.ToList();
086.
087.
088. GridView1.DataBind();
089.
090.
091.
092. Label1.Text = "บันทึกข้อมูลเรียบร้อย";
093.
094.
095.
096.
097. }
098. }
099.
100.
101.
102.
103.
104. else {
105.
106. Label1.Text = "คุณไม่ได้ระบุไฟล์ที่จะอัปโหลด";
107.
108.
109.
110. }
