Re: Reading excel file in blocks - C# Discussion Boards

First Prev Next

Re: mssql version problem

K03063-Jul-09 2:21

K0306

3-Jul-09 2:21

May be you didn't installed all the features, try this link

Installation guide for MSSQL 2005[^]

Re: mssql version problem

leone3-Jul-09 6:08

leone

3-Jul-09 6:08

i read it but couldn t fix my problem. İ checked all of those
# SQL Server Database Engine
# Analysis Services
# Reporting Services
# Notification Services
# Integration Services
# Management Tools
# Documentation and Samples

Re: mssql version problem

Luc Pattyn3-Jul-09 6:20

Luc Pattyn

3-Jul-09 6:20

Sorry for stating the obvious, but when you install more than one database on a machine, they would have different names, and your connection strings need modified including the name.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.

Reading excel file in blocks

sankar i3-Jul-09 1:28

sankar i

3-Jul-09 1:28

Hi,

I would like to know is there any way where we can read excel file in blocks("x" rows at a time) so that the entire file is not loaded into memory.

Replies would be appreciated.

Re: Reading excel file in blocks

padmanabhan N3-Jul-09 1:44

padmanabhan N

3-Jul-09 1:44

sankar i wrote:
any way where we can read excel file in blocks("x" rows at a time)

means you want to read for example A1 to A20, something like this

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Re: Reading excel file in blocks

moon_stick3-Jul-09 3:25

moon_stick

3-Jul-09 3:25

I assume you're talking about loading the data from an excel spreadsheet into a datatable (for example). I wrote the following snippet that will extract the top 10 lines from an excel file using a database connection:

static void Main(string[] args)
        {
            string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;;Data Source=C:\temp\XlsJetTest.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";";
            OleDbConnection conn = new OleDbConnection(connStr);
            OleDbCommand comm = new OleDbCommand("select top 10 * from [Sheet1$]", conn);
            conn.Open();

            OleDbDataAdapter da = new OleDbDataAdapter(comm.CommandText, conn);
            DataTable dt = new DataTable();
            da.Fill(dt);

            Console.WriteLine("RowCount:\t{0}", dt.Rows.Count);
            Console.ReadLine();
        }

A little bit of SQL manipulation should allow you to be able to 'page' through chunks of the spreadsheet (you might have to write a couple of functions to do something clever).

It definitely isn't definatley

Re: Reading excel file in blocks

EliottA3-Jul-09 3:36

EliottA

3-Jul-09 3:36

I think he want's to read the first ten lines without opening up the excel file in memory as a whole (which is done above).

If that is the case, then no, it cannot be done that way.

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Re: Reading excel file in blocks

sankar i7-Jul-09 18:45

sankar i

7-Jul-09 18:45

exactly......I want to read first 1000lines so that entire file is not loaded in memory....
Is there any mechanism to read excel file itself through some binary reader line by line?

How to close pop3 connection

Nekkantidivya3-Jul-09 1:04

Nekkantidivya

3-Jul-09 1:04

Hi,

I am working on apop3 application. In this I connected to gmail and retrieved the selected number of mails. After this I closed the connection using "Quit" command. Then the number of emails that I selected are deleted from the pop3.
To solve this I used "RSET" command before "QUIT". But even then the emails are deleted.

If anyone have any idea to solve this please reply me.

Thanks in Advance.

Note:I didn't found any correct forum to post this. So I posted it here. If this is not the correct forum please suggest me the correct forum to post this.

Re: How to close pop3 connection

Manas Bhardwaj3-Jul-09 1:29

Manas Bhardwaj

3-Jul-09 1:29

this has nothing to with the application but the way you have configured the Email Server.

Especially, gmail has this option When messages are accessed with POP [^]where you can define what to once the email is accessed through POP3.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

close or overwrite the file

havejeet3-Jul-09 1:03

havejeet

3-Jul-09 1:03

Hi all,

I have one windows service made in C#. I want My service to create CSV file every two minutes... but it should overwrite the existing file every two minutes. but whenever I try - it says file is already open - while I am sure that file is processed during those elapsed two minutes.. How do i programmatically close the file or overwrite the same. My file creation is through windows utility CSVDE (so have no control over creation except for the time and name!)

please suggest, thanks,
Jeet

Re: close or overwrite the file

Tamer Oz3-Jul-09 1:39

Tamer Oz

3-Jul-09 1:39

I think you forgot to close the stream or something like that if you send the code, maybe i can have better ideas.

Re: close or overwrite the file

havejeet3-Jul-09 4:35

havejeet

3-Jul-09 4:35

hi all,

came across to wonderful code, i am deleting older files now!

protected void CleanImageFolder()
{
string imgFolder = Server.MapPath("~/lab/maskemail/img/");
string[] imgList = Directory.GetFiles(imgFolder, "*.jpg");
foreach (string img in imgList)
{
FileInfo imgInfo = new FileInfo(img);
if (imgInfo.LastWriteTime < DateTime.Now.AddMinutes(-3))
{
imgInfo.Delete();
}
}
}
thanks
jeet

OFNHookProc Parameters Values

Satish Pai3-Jul-09 1:03

Satish Pai

3-Jul-09 1:03

Can anybody tell me the parameter values for OFNHookProc Procedures..

Re: OFNHookProc Parameters Values

Manas Bhardwaj3-Jul-09 1:07

Manas Bhardwaj

3-Jul-09 1:07

What did you try to find the params yourself?

A simple google search [^]gave me these reults.

And the first one [^]seems to answer your questions.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: OFNHookProc Parameters Values

DaveyM693-Jul-09 2:02

DaveyM69

3-Jul-09 2:02

Have a look at this[^].

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

ADO.Net Dataview........ [modified]

Isaac Gordon3-Jul-09 0:16

Isaac Gordon

3-Jul-09 0:16

Hi Experts
i using Visual Studio 2005.
I Fill a grid using Dataview in C#.NET winForms.
I Filter it with Dataview RowFilter then the result Come After Row Filter
Show in Different Grid now i want to Filter The Data from Second Grid not from first grid.
I mean to say that suppose e.g I Have Grid Result first Time
ID Name
1 Hello How R
2 i am fine
3 this is my book
4 this is C# Book
5 this is C# Example
6 Book is black

now i apply Row Filter on the 'this is'
dvs.RowFilter =Name like '%this is %'

now Result Come
ID Name
3 this is my book
4 this is C# Book
5 this is C# Example

Now i am again apply Row Filter not on the first case but apply on the second case.

now i apply Row Filter on the 'this is'
dvs.RowFilter =Name like '%Book%'
now Result Come this
Cry | :((

I want this result set
ID Name
3 this is my book
4 this is C# Book
Unsure | :~

but result come
ID Name
3 this is my book
4 this is C# Book
6 Book is black

then how to fix this problem

this search within search in n time untill zero result is come....
Thank u
Dinesh

modified on Friday, July 3, 2009 7:14 AM

Re: ADO.Net Dataview........

Manas Bhardwaj3-Jul-09 1:01

Manas Bhardwaj

3-Jul-09 1:01

Sharma Dinesh Kumar wrote:
~~dvs.RowFilter =Name like '%Book%'~~

dvs.RowFilter = Name Like '%Book%' AND Name like '%this is%'

Another options is that, use the CopyTo method of the dataview after the fisrt operation and now use this datatable to filter the results for the next datagridview

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

code/class for searching for a name from a database in c#

frank q-p2-Jul-09 23:53

frank q-p

2-Jul-09 23:53

how to write a code/class for searching for a name from a database in c#

Re: code/class for searching for a name from a database in c#

K03063-Jul-09 0:11

K0306

3-Jul-09 0:11

What you already done for this, if you don't know how to retrieve data from database, just buy a book and go through it.

I just give some hits to retrieve data from database for searching

1.write a sql query for searching
2.Execute with sqldatareader or dataset
3.display the result using grid view.

Re: code/class for searching for a name from a database in c#

himanshu25613-Jul-09 0:13

himanshu2561

3-Jul-09 0:13

What have you tried so far???

himanshu

Re: code/class for searching for a name from a database in c#

Vasudevan Deepak Kumar3-Jul-09 2:11

Vasudevan Deepak Kumar

3-Jul-09 2:11

himanshu2561 wrote:
What have you tried so far???

1) Waded through the internet ocean to arrive at CP Shores
2) Wandered a bit in the shore
3) Dumped the crap in C# forum
4) Set on another voyage again!

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!

Re: code/class for searching for a name from a database in c#

himanshu25613-Jul-09 2:25

himanshu2561

3-Jul-09 2:25

yup and still gives 1 to other. Thumbs Down | :thumbsdown: