The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dlg.FileName + @";Extended Properties=""Excel 8.0;HDR=YES;"""; OleDbConnection cnn = new OleDbConnection(connectionString); OleDbDataAdapter da; DataSet1 ds; string sql = @"Select" + "'*'" + "+OrderNumber+" + "'*'" + " as OrderNumber,City,Phone FROM [sheet1$] WHERE OrderNumber > 0"; da = new OleDbDataAdapter(sql, cnn); ds = new DataSet1(); da.Fill(ds, "ExcelData"); CrystalReport1 Report = new CrystalReport1(); Report.SetDataSource(ds); crystalReportViewer1.ReportSource = Report;
|placing a checked in the checklistbox based on the value in database table.||3||24|
|split worksheet into new worksheets based on changing value in Column A (by means of an Excel VBA)||4||33|
|Can a filename retrieved using the FileUpload control be automatically copied to a textbox control in ASP.Net using C#?||4||24|
|Using SUMPRODUCT with a Date Range||6||22|