public static DataSet importXlsFileToSql(string sFile, CheckBoxList list)
{
NewsletterReceiver receiver;
try
{
DataSet ds = new DataSet();
OleDbDataAdapter MyCommand;
//OleDbConnection MyConnection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + sFile + ";Extended Properties=Excel 12.0;");
OleDbConnection MyConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sFile + ";Extended Properties='Excel 8.0;HDR=Yes'");
MyConnection.Open();
DataTable _mytableSchema = MyConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
MyConnection.Close();
string sheetName = _mytableSchema.Rows[0]["TABLE_NAME"].ToString();
MyCommand = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [" + sheetName + "]", MyConnection);
// MyCommand = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [Plan$]", MyConnection);
//MyCommand = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [vanessatesteggg$]", MyConnection);
MyCommand.TableMappings.Add("Table", "TesteTable");
MyCommand.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
//receiver = CtrlNewsletterReceivers.getReceiverByEmail(ds.Tables[0].Rows[i][1].ToString());
//if (receiver == null)
//{
// if (Validation.Email(ds.Tables[0].Rows[i][1].ToString()))
// {
// receiver = new NewsletterReceiver();
// receiver.newsletterReceiverName = ds.Tables[0].Rows[i][0].ToString();
// receiver.newsletterReceiverEmail = ds.Tables[0].Rows[i][1].ToString();
// receiver.newsletterReceiverCityID = 0;
// receiver.newsletterReceiverAddress = "";
// receiver.newsletterReceiverDistrict = "";
// receiver.newsletterReceiverDescription = "";
// receiver.newsletterReceiverBornDate = DateTime.Now;
// receiver.newsletterReceiverUpdateDate = DateTime.Now;
// receiver.newsletterReceiverRegistrationDate = DateTime.Now;
// CtrlNewsletterReceivers.save(receiver);
// }
//}
// NewsletterReceiver receiverExisted = Ctrl.NewsletterReceivers.getReceiverByEmail(ds.Tables[0].Rows[i][1].ToString());
foreach (ListItem item in list.Items)
{
// if (item.Selected)
// {
// int idGroup = Convert.ToInt32(item.Value);
// GroupsNewsletterReceiverGroup obj = CtrlGroupsNewsletterReceiverGroup.getGroupNewsletterReceiverGroupByBothIds(receiverExisted.newsletterReceiverID, idGroup);
// if (obj == null)
// {
// obj = new GroupsNewsletterReceiverGroup();
// obj.newsletterReceiverID = receiverExisted.newsletterReceiverID;
// obj.newsletterReceiverGroupID = idGroup;
// CtrlGroupsNewsletterReceiverGroup.save(obj);
// }
// }
//}
}
MyConnection.Close();
return ds;
}
}
catch (Exception ex)
{
// AlertMessage.show(ex.ToString(), AlertMessageType.ERROR, true);
}
return null;
}
Assinar:
Postar comentários (Atom)
Nenhum comentário:
Postar um comentário