Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~5K People Reached
Favorite Tags
Member Avatar for 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 = …

Member Avatar for hericles
0
202
Member Avatar for nav07
Member Avatar for nav07
Member Avatar for nav07

c# - How can I raise an event every day 12:00 AM or specific time interval in c#.NET Please suggest

Member Avatar for Narue
0
74
Member Avatar for nav07

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........

Member Avatar for nav07
0
3K
Member Avatar for nav07

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.....

Member Avatar for nav07
0
96
Member Avatar for nav07

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 …

Member Avatar for MeSampath
0
78
Member Avatar for nav07

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 …

Member Avatar for skatamatic
0
455
Member Avatar for nav07

[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 …

Member Avatar for adam_k
0
435