|
Mschauder wrote: Office Excel 2007 can hold 1.048.576 rows.
Which not everyone has... But then again, you haven't said anything about your client base, so I'm, assuming you have to support more than a "corporate standard load".
Mschauder wrote: Should have a .xls or .xlsx format and should can autosize cols and edit backcolor from the header
You cannot write an .XLS file without using the Excel object model or a third party control, filing in all the cells, formatting them, then saving it.
An .XLSX file is just an XML file, so there's a bit of work there to get the data in the correct format surrounded by the required XML Excel wants to see. Not every Excel can open an .XLSX file either. Again, it depends on your clients...
Mschauder wrote: There must be an another way...
You've got your options. There is no "bulk insert" option for Excel.
Mschauder wrote: //Application.DoEvents();
I wish DoEvents was never allowed to be created...
|
|
|
|
|
Cheack out this article or this one.
It is fast kind of bulk.
Another totally diferent option is to use OLEDB.
|
|
|
|
|
Hi,
you could do it faster with this Excel .NET component.
It uses its own parsing engine written purely in managed environment, so no cross platform invocations, no COM wrappers, no Excel Automation.
Here is a sample Excel C# code how to export DataSet to Excel within just one for loop:
var ef = new ExcelFile();
foreach (DataTable dataTable in dataSet.Tables)
{
var ws = ef.Worksheets.Add(dataTable.TableName);
ws.InsertDataTable(dataTable, "A1", true);
}
ef.SaveXls("DataSet.xls");
|
|
|
|
|
i tried registering a dll,it resulted in the following error
"the library was loaded,but the DllregisterServer entry point was not found . this file can not be registered"
can anyone tell me what the problem is and how to rectify this problem ?
|
|
|
|
|
You do know that's for COM DLLs, right?
.45 ACP - because shooting twice is just silly ----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
|
I suppose you are using regsvr32 to register your assembly for COM clients.This tool could be used for native COM dlls not .NET assemblies.You should use Regasm instead.
Life is a stage and we are all actors!
|
|
|
|
|
It means you are trying to use regsvr32 to register a dll. There are two things to consider here:
1. In .NET, assemblies are registered using Regasm.
2. This error can occur if the DLL is not a COM dll.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Pete O'Hanlon wrote: Regasm
I thought that was the result of a second... ummm... a subsequent... errrr... well, you know.
.45 ACP - because shooting twice is just silly ----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
You have a very mucky mind. You remind me of someone... oh wait, it's me.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Individuality is fine, as long as we do it together - F. Burns
Help humanity, join the CodeProject grid computing team here
|
|
|
|
|
Hi,
I want to get updated fields row from datatable or dataset.
I used Getchanges() on dataset but didnt work at all.
How can I Get the updated rows only from existing dataset or datatable.
Thanks
sjs
|
|
|
|
|
You need to provide some code to know what is happening there. We all use these functions and they work for us. So you must be doing something wrong. right?
|
|
|
|
|
hi,
let me clarify now.
string mySelectQuery = "SELECT * from Table1";
SqlConnection myConnection = new SqlConnection(connectionString);
SqlDataAdapter adpt = new SqlDataAdapter(mySelectQuery, myConnection);
dt = new DataTable();
myConnection.Open();
adpt.Fill(ds);
dt = ds.Tables[0];
dataGridView1.DataSource = dt;
myConnection.Close();
This is written on Refresh button.
Now there is another button where i written code to get only updated row from above datatable.
DataSet ds3 = new DataSet();
dt.AcceptChanges(); // dt delcared globally
ds3 = dt.GetChanges();
If I change one of the field in table1 directly from database and if i clicked on refresh button then it is showing the updated field. Now if i clicked on second button then I want only that updated row and want to store in dataset ds3.
Just let me know if i m doing any wrong from above code.
Thanks
sjs
|
|
|
|
|
sjs4u wrote: DataSet ds3 = new DataSet();
dt.AcceptChanges(); // dt delcared globally
ds3 = dt.GetChanges();
After you say AcceptChanges, there are no changes left. Hence you will get null in GetChanges method.
I suggest adding an AcceptChanges when you load your table. This way any changes maade during the program will be shown when you want to.
|
|
|
|
|
I write it after
adpt.Fill(ds)
It is showing in the dt that value is updated but when i click on 2nd button still it is not showing that perticular updated row..
Can you show it with the above example
|
|
|
|
|
see, its simple.
DataSet ds = new DataSet("DateSet");
ds.Tables.Add(new DataTable());
LoadTable(ds.Tables[0]);
ds.AcceptChanges();
ds.Tables[0].Rows.Add(50,20,10);
DataTable changedTable = ds.Tables[0].GetChanges();
|
|
|
|
|
ok thanks... I will try it
|
|
|
|
|
Read the documentation on GetChanges and AcceptChanges. Those functions do things different than what your code suggests they do.
GetChanges returns a DataSet/DataTable object with the changes in the DataSet/DataTable. It does NOT get the last set of changes from the database.
DataSet/DataTable objects keep track of which records they hold are "dirty" an need to be written back to the database. AcceptChanges tells the DataSet/DataTable object to reset all the "dirty", "new", and "deleted" flags to "original" (can't remember the actual enum names right now!) so the DataSet/DataTable thinks there are no changes to be written back to the database.
|
|
|
|
|
On wondiws 7 professional 64 bit machine. I have written an exe which will defragment particular drive and runs in system account. The exe is scheduled. whenever exe runs it gives below error.
<b>The resource loader cache doesn't have loaded MUI entry. (0x80073B01) .</b>
i have rebooted machine 2-3 times but no any luck.
Can any one tell me what is the error and why it occurs? and what is the solution?
|
|
|
|
|
Message Closed
modified 23-Nov-14 6:31am.
|
|
|
|
|
UAC is disabled on the machine.
|
|
|
|
|
Hello,
Im near completeion of a windows app and now need to generate my .ico for the forms(and shorctcut).
Ive googled and looked around to convert\create .png into .ico but the applications I have found so far seem unable to convert my .png into
.ico while maintaing quality.
I need an app that can design all the way from 16 x 16 upto 256x256.
Is there a industry standard app that does this? or what else do you use?
thanks
|
|
|
|
|
Yes if you are trying to create icon from Image then image color some information will be lost.
So you should need to open Your image to icon Creator then Correct it as per your requirement.
If you can think then I Can.
|
|
|
|
|
I used either Paint.NET or GIMP (I can't remember which... probably GIMP) to save an image in layers. Doing so, you can create an icon with multiple resolutions in one (Winodws will choose the proper resolution depending on how big the icon being displayed is). You could probably find similar instructions by searching for "create layered application icon with GIMP" (replace with "Paint.NET" too) or something like that.
|
|
|
|