No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
This is my code, but its taking time to save record in excel. In SQL Server table have 11201 rows and 80 columns. please suggest private void button1_Click(object sender, EventArgs e) { Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing); Microsoft.Office.Interop.Excel._Worksheet worksheet = null; app.Visible = true; worksheet = … |
|
how trigger an event on specific time of day .net |
|
how trigger an event on specific time of day pls suggest code |
|
c# - How can I raise an event every day 12:00 AM or specific time interval in c#.NET Please suggest |
|
cmd = new OleDbCommand("select Convert(varchar(50),Fault_Time),[Level],[Trouble_Source],[Solution],[Ticket_Status],[Close_Date],convert(varchar,Close_Time),[Actual_Cause],[Solution],[Description] from [TT_Record$]", conn); its showing error at runtime :- Undefined function 'Convert' in expression pls suggest........ |
|
My date and time is different, i want time calculate in total minutes example:- A time is 10/19/2011 1:26:00 PM B time is 11/11/2011 7:14:00 AM please suggest..... |
|
I have a table which has a field ItemsReceived of type datetime. I have a grid view which has two columns. In first column i have to show the data from field ItemsReceived and in second column I have to show difference between Currenttime and date from ItemReceived. How can … |
|
I am exporting data to excel but inserting rows is very slow about 2 seconds per row pls help using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.Data.SqlClient; using System.IO; using Microsoft.Office.Interop.Excel; namespace Dashboard { public partial class Form1 … |
|
[code]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.Data.SqlClient; using System.IO; using Microsoft.Office.Interop.Excel; using System.Reflection; namespace Dashboard { public partial class Form1 : Form { public OleDbConnection con,con1; public OleDbCommand cmd,cmd1; public OleDbDataReader dr; public OleDbDataAdapter db; public string … |