protected void btn_save(object sender, EventArgs e) { string path = FileUpload1.PostedFile.FileName; string ext = Path.GetExtension(path); string contenttype = string.Empty; if (!FileUpload1.HasFile) { ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('Please select a file')</script>"); //if file uploader has no file selected } else if (FileUpload1.HasFile) { try { switch (ext) { case ".csv": contenttype = "application/vnd.ms-excel"; break; } string year = ddlyear.SelectedItem.ToString(); string month = ddlmonth.SelectedItem.ToString(); MySqlConnection exclecon = new MySqlConnection("Server=Localhost;DataBase=password1;user=root;password=nectar"); string insquery = "INSERT INTO sla (month, year, contenttype) VALUES(@month, @year, @contenttype)"; string uploadQry = "LOAD DATA LOCAL INFILE '" + path + "' INTO TABLE sla1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '/n' IGNORE 1 LINES "; MySqlCommand mycom = new MySqlCommand(insquery, exclecon); mycom.Parameters.AddWithValue("@month", month); mycom.Parameters.AddWithValue("@year", year); mycom.Parameters.Add("@contenttype", MySqlDbType.VarChar).Value = contenttype; MySqlCommand myCUpload = new MySqlCommand(uploadQry, exclecon); exclecon.Open(); mycom.ExecuteNonQuery(); myCUpload.ExecuteNonQuery(); ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('File uploaded Successfully ')</script>"); } catch (Exception ex) { Label4.Text = "Error: " + ex.Message.ToString(); } }
LINES TERMINATED BY '/n'
LINES TERMINATED BY '\\n'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)