nav07

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 …