|
Hi Luis
If I remember correctly I ended up using another library called Taramon.Exceller which is basically a wrapper class for Excel interop. I initially tried to avoid this because it requires reading the entire excel file into memory whereas the ExcelReader class streams the required data directly (and much quickly).
Karl
|
|
|
|
|
OK I had a problem reading a large excel document.
The problem: The problem was who I was doing it.
Firs I loaded the excel file to the data base and for each of this excel I was making a validation.
The solution:
First I loaded the excel to a dt this data table had 4 columns as Keys and my validations whore to this DT so the 15000 row wore loaded an calculated in almost 30 secs
Thanks any way
Luis Fernando Forero G.
|
|
|
|
|
hi friends
I want to know how to convert C source code into C# source code
please..
|
|
|
|
|
Easy... 3 Steps...
1. Learn C Programming langauge
2. Learn C# Programming language
3. Re-Write the C Source into C# source
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
|
There are converters which can reduce the amount of work required, but you must have a good knowledge of both C/C++ and C# to get the job done.
David Anton
http://www.tangiblesoftwaresolutions.com
Convert VB to C#, C++, or Java
Convert C# to VB, C++, or Java
Convert C++ to C#, VB, or Java
Convert Java to C#, C++, or VB
|
|
|
|
|
hello, I need to call an Oracle FUNCTION which returns a REF CURSOR - tutorial?
closest I found is this, which illustrate stored proc (not function) with CURSOR output param (and use of OracleParameter with type=OracleType.Cursor)
http://support.microsoft.com/kb/322160[^]
Thanks
dev
|
|
|
|
|
|
hi friends,
i am working on c# .net and i need video cutter in my project.my project in c# .net and window application so if any one hacund code for that then please reply me.
thanks
|
|
|
|
|
I also need video cutter in my project. my project in c# .net and window application. so if any one can help me regarding this issue.
please reply me.
thanks.
|
|
|
|
|
Hi all,
TO my .net setup project i want to add a launch condition for crystal report installation.
In my prerequisities i selected Crystal reports fro basic visual studio 2008 (x64, x86)
in my debug folder i got those respective crystalreport10_5 folder after successful build.
i got CRRedist2008_x64.msi,CRRedist2008_x86.msi
i want to install CRRedist2008_x86.msi so in my Installurl i specified CRRedist2008_x86.msi's path.
but it is not installing, in installing window a message gathering information came and after some time it is closing.
so am trying to install CRRedist2005_x86.msi
but when am trying to install my setup project it always going to that crystal report launch condition though i installed CRRedist2005_x86.msi.
in my launch condition i gave properties as
Name : CrystalReport
Condition: CrystalReport
InstallUrl : CrystalReports10_5\CRRedist2005_x86.msi
Message: Do you want to install crystal Reports?
please provide launch condition to install crystal reports.
and why it is asking every time crystal report installation?
so that am not able to proceed further to install my application.
please help me out.
Thanks In Advance
|
|
|
|
|
Hdey pls let me know the answer if you will get the answer of your solution...
As i m also facing the same problem so..
pls reply earlyiest...
|
|
|
|
|
No dude, not yet
still am researching
no one providing necessary things.
|
|
|
|
|
Hello. I have a listview where I load data from sql database. ListView has two columns (name, surname) where data is loaded. On the selectedindexchanged event, when an item from the listview is selected it gets the other data from the database, based on selection, and writes it to several textboxes... basicly a phonebook. If I select someone from the list the info is displayed in the txtboxes, but if i click smeone a second time i get an exception "NullRefferenceException" "Object reference not set to an instance of an object."
private void lvNameList_SelectedIndexChanged(object sender, EventArgs e)
{
ClearSearch();
select = "SELECT * FROM agenda_telefonica WHERE nume = '" + lvNameList.FocusedItem.Text + "' AND prenume = '" + lvNameList.FocusedItem.SubItems[1].Text + "'";
SqlDataReader dr = realSql.Select(select);
if (!dr.HasRows)
{
MessageBox.Show("Information not found", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
while (dr.Read())
{
tbName.Text = dr[1].ToString().Trim() + " " + dr[2].ToString().Trim();
tbPhoneNumber1.Text = dr[3].ToString().Trim();
tbPhoneNumber2.Text = dr[4].ToString().Trim();
tbPhoneNumber3.Text = dr[5].ToString().Trim();
tbFaxNumber.Text = dr[6].ToString().Trim();
tbEmail.Text = dr[7].ToString().Trim();
tbCompany.Text = dr[8].ToString().Trim();
tbService.Text = dr[9].ToString().Trim();
tbEquipment.Text = dr[10].ToString().Trim();
}
}
dr.Close();
realSql.Close();
}
}
The exception is raised the second time i click an item in the list and points to the select string. Does it have something to do with the FocusedItem?
|
|
|
|
|
Before doing anything else check the if the SelectedItems.Count property is > 0.
|
|
|
|
|
Thanks.
|
|
|
|
|
You are closing realSql which is not opened in the method you have posted. It could therefore be realSql (null after closing) that is causing the exception.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
realSql is a dll refference to a sql class i've created. it has an select(string select) which open an sql connection then returns a datareader ("SqlDataReader dr = realSql.Select(select)"). So the realSql.Close() closes the connection opened by the Select() method.
|
|
|
|
|
i have to Make a GridView with print option (Inherit the GridView control and add a print method). The print button should print all the rows in the gridview. There should an option to print no of rows perpage.
. i have to use GDI printing APIs for printing.
Maifs
|
|
|
|
|
So, get started - you'll finish quicker that way!
Was there a question you wanted to ask?
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
When faced with a problem like this, you have to ask yourself a question.
"Am I so brilliant that I have thought of doing something so extraordinary that no one has thought of doing it before?"
In 999,999,999 cases out of 1,000,000,000 cases the answer is going to be NO.
If the answer is yes, ask here. In all other cases Google the bloody thing!!!
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
can you tell me that which type of quesiotns have to be asked here?
its a realy so pythetic answer.
Maifs
|
|
|
|
|
The sort of questions that should be asked here are those concerning a piece of code that you have written, that is not working in the way you expect, or at all. This is CodeProject.
The important points to remember here are
a) code
b) you have written
There are so many solutions to this problem on the internet that people are reluctant to answer, because it is perceived (may not be true but it is perceived) that you are too lazy to either Google, or try for yourself.
Find something on the Internet that most nearly suits your situation and try to implement it. If you get stuck then or do not understand part of it then ask here with a code snippet that is relevant (properly formatted, of course) and any error messages.
For goodness sake Google for print datagrid c# or print datagridview c# whichever applies. Pick one and have a go.
All of this advice is free, there is no need to thank me!
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi,
I want to decompile a CHM file (help file) and also be able to compile the generated files back to a CHM file again in C#.
I have tried to do this using Microsoft Html Help Workshop. I create a Process and decompile with hh.exe and it works fine. After that I create a Microsoft Html Help Workshop project file, and the project file works perfect if I compile in Microsoft Html Help Workshop. But if I create a Process in .Net and try to compile with hhc.exe I get a corrupt CHM file, it looks like a web page that not can be loaded. I got the same problem if I compile from command line -> hhc [project file].
HHC5013: Error:
runtime error R6002
- floating point not loaded
Is it possible to do this only in C#? Or anyone who knows what is wrong?
I have added Hh.exe and Hha.dll in my Path variable.
I am not sure where I shall post this question so I try here.
Best regards
Marc
|
|
|
|
|
Hello,
Digging up this post from 1000 years ago
I am experiencing the issue of R6002 floating point not loading while running hhc.exe from the command line.
Have you by any chance found how to solve this issue (and remember how?)
Thanks
|
|
|
|