|
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?
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
