|
That sounds like it could be interesting Look forward to reading it.!!
|
|
|
|
|
I have a working example going now. It works with nslookup and at least one utility of my own, but not FTP and TELNET -- they don't prompt when executed in this manner.
How have you progressed in the meantime?
P.S. And I did post my script article. I'm just working on the class that wraps a Process so the engine can use it.
|
|
|
|
|
As a newbie to code writing this one got me really stumped. While I have been contemplating and get help from people here I turned my attention to some other area's that I need to master in order to get to the end of my project. I am now able to churn out windoes services / service installers etc... without much hassle.... all I need to do now is to get my service to drive these cmd line utilities
I havent looked yet but am looking forward to seeing what you have done and how you did it.
|
|
|
|
|
|
i have a form which contain rich text box and that accepts return key.On save of text with multiline text property to the grid it shows a square on enter key press position..pls help
modified on Friday, March 19, 2010 7:32 AM
|
|
|
|
|
Change your column's WrapMode to true .
///to clarify:
Change the wrapmode of the DataGridView.RowTemplate.DefaultCellStyle
|
|
|
|
|
i ve set wrapmode to true..a small square box is shown on save of text from rich text box with accept return set as true
|
|
|
|
|
Seems to work on my machine.
Could you post some (short and isolated) example of your code that reproduces this behaviour?
|
|
|
|
|
there isnt any code for it..my multiline and word wrap property is set to true..a small square box appears when i click save button after entering data with accept return property set to true.Cud u plz help me
|
|
|
|
|
Hey guys,
I want to fill my array into a .xls or .xlsx file...
momentary I fill it with 2 loops from my grid.
I read something about the ".Range" property from Excel, but how can I handle it?
or is there a possibility to import 120.000 rows & 20 cols much faster?
hope you can help me!
thanks previously
modified on Friday, March 19, 2010 7:46 AM
|
|
|
|
|
Depending on which version of Excel you're using, you can easily run the machine out of RAM doing this. Also, there are versions of Excel that cannot hold 120,000 rows in a single sheet.
You have to populate each cell with its appropriate value from your dataset. There is no "bulk" way to do it.
Your only other option, instead of filling in a Worksheet object directly, is to write your data out to a .CSV file and open that in Excel.
|
|
|
|
|
Hey
>> Also, there are versions of Excel that cannot hold 120,000 rows in a single sheet.
Office Excel 2007 can hold 1.048.576 rows.
>> Your only other option, instead of filling in a Worksheet object directly, is to write your data out to a .CSV file and open that in Excel.
Should have a .xls or .xlsx format and should can autosize cols and edit backcolor from the header.
>> You have to populate each cell with its appropriate value from your dataset.
There must be an another way...
...fill it with
for (int i = 0; i < UsingGrid.Cols; i++)
{
for (int j = 0; j < UsingGrid.Rows; j++)
{
worksheet.Cells[j + 1, i + 1] = ConvertToExcelFormat(Convert.ToString(UsingGrid[j, i]));
}
}
costs amount of time (up to 10 minutes)...
modified on Monday, March 22, 2010 3:56 AM
|
|
|
|
|
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?
|
|
|
|