protected void btnUpload_Click(object sender, EventArgs e) { if (ddlSPList.SelectedValue != "0") { spListGuid = ddlSPList.SelectedValue.Trim().ToString(); SPSecurity.RunWithElevatedPrivileges(delegate() { try { CreateDirectory(); excelPath = HttpContext.Current.Server.MapPath("/_layouts/Temp/" + fuExcelSheet.FileName); if (fuExcelSheet.FileName != string.Empty) { if (excelPath.EndsWith("xls", StringComparison.InvariantCultureIgnoreCase)) { excelExten = "xls"; xlConn = new global::System.Data.OleDb.OleDbConnection(Providers.Utilities.ConnUtilities.CreateXlConnectionString(excelPath, excelExten)); ddlSheetName.DataSource = DataAccessProvider.GetExcelSheetNames(xlConn); ddlSheetName.DataBind(); btnShowData.Visible = true; ddlSheetName.Visible = true; this.Page.ClientScript.RegisterStartupScript(GetType(), "key", "document.getElementById('light').style.display='block';", true); } else if (excelPath.EndsWith("xlsx", StringComparison.InvariantCultureIgnoreCase)) { excelExten = "xlsx"; xlConn = new global::System.Data.OleDb.OleDbConnection(Providers.Utilities.ConnUtilities.CreateXlConnectionString(excelPath, excelExten)); ddlSheetName.DataSource = DataAccessProvider.GetExcelSheetNames(xlConn); ddlSheetName.DataBind(); this.Page.ClientScript.RegisterStartupScript(GetType(), "key", "document.getElementById('light').style.display='block';", true); litMessage.Text = string.Empty; btnShowData.Visible = true; ddlSheetName.Visible = true; } else { litMessage.Text = "Please Upload .xls or .xlsx file"; } } else { litMessage.Text = "Please provide a valid file path"; } } catch (Exception ex) { litMessage.Text = "Incorrect Format"; rptBindColumns.Visible = false; SPErrorLogs.LogExceptionToSPLog(oWebpartName, "btnUpload_Click", ex); } }); } }
internal static System.Data.DataSet getXldata(System.Data.OleDb.OleDbConnection xlConn, string sheetName, string excelPath, string excelExten) { System.Data.DataSet ds = new System.Data.DataSet(); SPSecurity.RunWithElevatedPrivileges(delegate() { xlConn = new global::System.Data.OleDb.OleDbConnection(Utilities.ConnUtilities.CreateXlConnectionString(excelPath, excelExten)); string cmd = string.Format("select * from [{0}]", sheetName); System.Data.OleDb.OleDbCommand Comm = new System.Data.OleDb.OleDbCommand(cmd, xlConn); Comm.Connection = xlConn; System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter(); xlConn.Open(); Comm.CommandType = System.Data.CommandType.Text; adapter.SelectCommand = Comm; adapter.Fill(ds); xlConn.Close(); }); return(ds); }
protected void btnShowData_Click(object sender, EventArgs e) { try { SPSecurity.RunWithElevatedPrivileges(delegate() { xlConn = new global::System.Data.OleDb.OleDbConnection(ConnUtilities.CreateXlConnectionString(excelPath, excelExten)); rptBindColumns.DataSource = DataAccessProvider.getSPListColumns(ddlSPList.SelectedValue.ToString()); rptBindColumns.DataBind(); this.Page.ClientScript.RegisterStartupScript(GetType(), "key", "document.getElementById('light').style.display='block';", true); btnget.Visible = true; rptBindColumns.Visible = true; litValidationMessage.Text = ""; litValidationMessage.Text = ""; }); } catch (Exception ex) { lblSuccessMessage.Text = "Selected worksheet is not correctly formatted. Please try again."; SPErrorLogs.LogExceptionToSPLog(oWebpartName, "btnShowData_Click", ex); } }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::Demo.Properties.Settings.Default.AyumiDB1ConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::DistribuidoraQuilmes.Properties.Settings.Default.DBConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::GridEXTutorial23CSharp.Properties.Settings.Default.GridEXTutorialsDataConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::WindowsApplication1.Properties.Settings.Default.nwindConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); //this._connection.ConnectionString = global::Sage.Integration.Northwind.Application.Properties.Settings.Default.NorthwindConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::AmbarTakip.Properties.Settings.Default.AmbarTakipConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::Payroll_System.Properties.Settings.Default.lamolinventoryConnectionString1; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::PreviewSortSample.Properties.Settings.Default.nwindConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["NwindConnectionString"].ConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::CustomLabelsWithaLargeAmountOfData.Properties.Settings.Default.nwindConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::XtraPivotGrid_ExampleTemplate.Properties.Settings.Default.nwindConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::CustomizeParameterEditorSample.Web.Properties.Settings.Default.nwindConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::wbswinform.Properties.Settings.Default.wbsConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["Tracker08ConnectionString"].ConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"C:\\Program Files\\ComponentOne Studi" + "o.NET\\common\\C1ListDemo.mdb\""; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::JohanBot.Properties.Settings.Default.PelisConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"..\\..\\..\\Data\\C1ListDemo.mdb\""; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::SchedulerGridSync.Properties.Settings.Default.CarsDBConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::BeforePrintEvent.Properties.Settings.Default.nwindConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::ParkL.Properties.Settings.Default.ParkLotKainaguaConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::StoreRepInDB.Properties.Settings.Default.ReportsDBConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::ResultManagement.Properties.Settings.Default.ConnectionString1; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::EM.Properties.Settings.Default.em_prog_2002ConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::IndexDBTables.Properties.Settings.Default.DatabaseConnectionString; }