|
here is an example of Odbc Data reader
u read each row at a time until the value of Reaq() is false - no more rows to read
u can not read all rows at once
OdbcDataReader Reader;
while (Reader.Read())
{
object[] dataArray = { };
Reader.GetValues(dataArray);
}
u can use : dataSet to hold data and use datadaptor to fill the dataset
this method is more handy where u assign an SQL stat. to the adaptor and by using the Fill
method u read all rows to the datatable inside the data set
Have Fun
Never forget it
|
|
|
|
|
DataReader won't hold the rows. It's a connection oriented design and it reads row by row. So if you are reading 1 crore rows, connection has to be open for until it finishes.
|
|
|
|
|
Hi All,
I'm using SQLBulkCopy class in .net 2.0
I'm passing SQLDataReader object to SQLBulkCopy's WriteToServer () method.
Actually, source query returns around 1crore records. while running this exe I'm getting System.OutOfMemoryException exception.
any ideas to handle this exception?
Thanks in Advance
Shah_tech
|
|
|
|
|
According to wiki a "crore" is 10million in India or 500000 in Iran(you learn something everyday  ), since you are from india i will assume it is 10 million.
10 million records is a huge amount of data, you should fragment this process to deal with a far smaller chunk at a time or buy more RAM.
modified on Friday, July 11, 2008 2:18 AM
|
|
|
|
|
How can i check in a system how many only microsoft products are installed
regards
|
|
|
|
|
You might want to look around on MSDN or traverse through the registry (my late night, quick thought  )...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Well, count all programs from Microsoft you know you installed: office, vstudio,expression studio, etc. Then count every single sub program of the OS.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios
Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com
|
|
|
|
|
Hi,
I am getting some data from a database and populating it to a DataTable.
This Datatable is assigned as a DataSource to a DataGridView. This table gets displayed on the datagridview.
After that, i am adding a combobox column to DataGridView and filling the cells under that combobox with item selected.
I want to retreive the whole updated DataGridView along with the new column and values in the cell into a Datable object.
I am able to assign datagridview columns to a newly created datatable object and unable to do same for the datagridview rows.
Thanks in advance.
Praveen
|
|
|
|
|
Currently am using IMAPI for CD burning. I can perform multisession writes to CD. The problem comes when i add a folder with the same name that already exists in the CD. Suppose am having a folder named Test containing 1.docx in the CD. Now am trying to add anothe folder named Test with another doc file named 2.docx. I want the file 2.docx to be added under the earlier created folder containing document 1.docx. Is dat possible? Can anyone provide a sample code for that
|
|
|
|
|
no man why would you do such a thing.remmber what is inide does not matter.the folder name should have different names
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
how to correctly deploy crystal reports using c# envirronment
|
|
|
|
|
What kind of researching have you done on the topic?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
|
Hence you need to dedicate yourself to the 'C# environment', now.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
i am c#.net developer.i worked microsoft visual studeo 2005 express edition environment.i made report using crystal reports in visual studeo 2005 for my pos system project.it works only my computer.it not work other computers.i copy dll and install dotnet framwork but not work crital reports.please help me.give me more examples. thank you! 
|
|
|
|
|
What all did you copy and install? Any of the CR stuff?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
dll files for crystal reports
|
|
|
|
|
Did you merely just copy the dll's or run them through an installer for the cr runtimes? You may not want to downvote someone helping you, that's kind of rude.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Install The frame work for CR. Hope this will work.
|
|
|
|
|
I am controlling the paint event of my Circle class but when I am resizing its size by clicking on one of it's handles the circle get drawn but i couldn't eliminate ghosting while it is drawn on the form. I have tried even setting DoubleBuffer=true but doesn't work.
protected override void OnPaint(PaintEventArgs e)
{
base.OnPaint(e);
Graphics g = e.Graphics;
Rectangle r = new Rectangle();
r.Size = this.Bounds.Size;
GraphicsPath ca = new GraphicsPath();
ca.AddEllipse(r);
Region region = new Region(ca);
this.Region = region;
g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.AntiAlias;
g.DrawEllipse(new Pen(Color.FromArgb(0, 0, 0)), r);
g.FillEllipse(Brushes.AntiqueWhite, r);
}
|
|
|
|
|
I haven't tested this, but you could try calling the Form's SuspendLayout () method at the beginning of OnPaint (), and calling the ResumeLayout () method at the end of OnPaint ().
|
|
|
|
|
Hi,
I am implementing a drag/drop system and am having trouble programmatically firing an event such that the control that receives the event remains focused.
For example, if you actually click on a button, and don't release the mouse button all MouseMove events are sent to that button even if you drag your cursor off the control. If you drag off to the left, the button continues to receive mouse events and the X is now negative. This is the desired behavior.
Currently I am firing the MouseDown event on a target control by having a member function that calls OnMouseDown() but this does not lock the focus as described above.
Can someone tell me how to lock the focus programmatically so all mouse events continue to be sent to the targeted control.
Thanks
-David
|
|
|
|
|
Hi,
you might be interested in Mouse.Capture()
|
|
|
|
|
I have a C++ Dll that returns the pointer to the start of an image in memory and it also returns the size of the image in memory, in C++ I use memcpy to copy it to a vairable, however I am new to C# and need to know how to copy the memory block to a jpg file.
|
|
|
|
|
use the Marshel Class to read write assgin all that is needed to and out of a memory block
do not forget u're in manged coding!!!!!
Here is a good Red MSDN[^]
Have Fun
Never forget it
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
