|
Dear All,
i have the datatable returns from sql store procedure:
sproResults = myUtils.ExecSproc(objSession, "spVoucherDetails_SelPending", printRunNumber);
and i loop through this table and try to write each row into a .csv file and save into disk, i know my current implementation wasn't quite right in here. Can someone plz advise me?
FileStream fStream = new FileStream(@"C:\Voucher\CompleteVoucher.csv", FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.None);
foreach (DataRow row in sproResults.Tables[0].Rows)
{
fStream.Write();
}
Thanks heaps.
|
|
|
|
|
AndieDu wrote: i know my current implementation wasn't quite right in here
Wrap the FileStream in using block. So it will get disposed when the scope ends. Something like
using(FileStream fStream = new FileStream(@"C:\Voucher\CompleteVoucher.csv", FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.None))
{
}If you are appending the text, easy way is to use File.AppendAllText[^]
|
|
|
|
|
do you by any chance get a blank file?
also i think you prob want to use WriteLine() method for each row
plus you need to write the values, something like this
foreach(DataRow row in sproResults.Tables[0].Rows)
{
object[] vals = row.ItemArray;
for(int i = 0; i < vals.Length - 1; i++)
{
fStream.Write((string)vals[i] + ",");
}
fStream.WriteLine((string)vals[vals.length - 1]);
}
then dont forget to close the stream i.e. fStream.Close();
EDIT: The above code would need ammending to handle null values, also FileStream will not support WriteLine. Thou i didnt actually specify the instance 
If only MySelf.Visible was more than just a getter...
A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting
|
|
|
|
|
Yummy, code that doesn't work.
Need custom software developed? I do C# development and consulting all over the United States.
If you don't ask questions the answers won't stand in your way.
Doing a job is like selecting a mule, you can't choose just the front half xor the back half so when you ask me to do a job don't expect me to do it half-assed.
|
|
|
|
|
well it certainly was not tested, but what would not work?
If only MySelf.Visible was more than just a getter...
A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting
|
|
|
|
|
The individual objects in the ItemArray are strongly typed. string foo = (string)5; will not compile and in your code will throw a runtime exception instead. Also the case of null and csv escape characters really throws a wrench into things.
Need custom software developed? I do C# development and consulting all over the United States.
If you don't ask questions the answers won't stand in your way.
Doing a job is like selecting a mule, you can't choose just the front half xor the back half so when you ask me to do a job don't expect me to do it half-assed.
|
|
|
|
|
the string casting works fine with the ItemArray.
The null issue can be solved with a simple if statement.
The only issue with the code is FileStream does not support WriteLine(), i usually would use StreamWriter so was unaware of this issue.
and the CSV escape characters are just something that isnt going to change, personally i would use a tab delimters for more reliability but then thats a TSV, no?
If only MySelf.Visible was more than just a getter...
A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting
|
|
|
|
|
The casting does not work with the ItemArray. The string casting only works if the ItemArray contains only strings which cannot be assumed, ever.
Need custom software developed? I do C# development and consulting all over the United States.
If you don't ask questions the answers won't stand in your way.
Doing a job is like selecting a mule, you can't choose just the front half xor the back half so when you ask me to do a job don't expect me to do it half-assed.
|
|
|
|
|
OK fair enough, i appreciate a cast from some object types will not work
If only MySelf.Visible was more than just a getter...
A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting
|
|
|
|
|
Hi,
Can anyone please help me in .NET console application where i need to split a zip file into small zip file of size 1MB.
please provide examples or links .
Regards
S.Guhananth
|
|
|
|
|
1 - Read the zip file to a file stream
2 - Write to a new file until you reach 1MB.
3 - Create a new file and do step 2 again until you reach end of the zip file.
|
|
|
|
|
Hi,
Can anyone help of upload a file to SFTP server using VS 2005 ?
please give codes as well as links that can help me.
Regards
S.Guhananth
|
|
|
|
|
Member 3222264 wrote: SFTP server using VS 2005 ?
Vs2005 is just an editor and what it has to do with SFTP? If you are trying to do this in C#, this[^] may help.
|
|
|
|
|
Member 3222264 wrote: please give codes as well as links that can help me.
You are using the wrong website. If you want code writing for you try rentacoder.com, otherwise write your code and post specific problems.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
hi,
Why is it that the list box control in Visual Studio 2005 cannot be styled.
All i am doing is Changing its border syle to Dashed and border color to black. But it seems the implementation is not reflecting.
i need to change the border color and style of a list Box Control out of the box. How can I ? 
|
|
|
|
|
set no border then handle the paint event?
If only MySelf.Visible was more than just a getter...
A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting
|
|
|
|
|
Hello ~
Can i ask Some question abo ut zedgraph here??
anyway this is my first question in code project ^^
and i can't english well plz comprehension my writing
let's start question
now My company Project Using Zedgraph.dll ver:5.1.4(maybe)
in the Project using zedgraph namespace
and i complete Drawing the Graph
only user X axis, Y axis
data is X[30] , T[30] <-- this data is ReadlTime data and Changing 3sec
Graph is Drawing but 3sec draw the Line, and 6sec draw the Line.. so on
Time is Gone...Line is so Many Many and i don't want it
for example)
0sec
3sec Draw the Line~~~~ Having data X[30] , T[30](data always chaging every
3sec)
and i want clear the line <-- this is i want
6sec Draw the Line~~~~ Having data X[30] , T[30](data always chaging every 3sec)
so on.....
how do i clear the Line ?? 
check this out my source
private void CreateGraph(double[] X, double[] T) //제드그래프 생성 (X,Y값을 가져옴)
{
GraphPane myPane = zgc.GraphPane;
// Set the titles and axis labels/;/l
myPane.Title.Text = "My Test Date Graph";
myPane.XAxis.Title.Text = "X";
myPane.YAxis.Title.Text = "Y";
// Make up some data points from the Sine function
PointPairList list = new PointPairList();
for (int i = 0; i < X.Length; i++)
{
list.Add(X[i], T[i]);
}
/*
for (double x = 0; x < 36; x++)
{
double y = Math.Sin(x * Math.PI / 15.0);
list.Add(x, y);
}
*/
// Generate a blue curve with circle symbols, and "My Curve 2" in the legend
LineItem myCurve = myPane.AddCurve("내부온도", list, Color.Blue,
SymbolType.Circle);
myCurve.Line.Fill = new Fill(Color.White, Color.Red, 45F);
// Make the symbols opaque by filling them with white
myCurve.Symbol.Fill = new Fill(Color.White);
// Make the symbols opaque by filling them with white
myCurve.Symbol.Fill = new Fill(Color.White);
// Fill the axis background with a color gradient
myPane.Chart.Fill = new Fill(Color.White, Color.LightGoldenrodYellow, 45F);
// Fill the pane background with a color gradient
myPane.Fill = new Fill(Color.White, Color.FromArgb(220, 220, 255), 45F);
// Calculate the Axis Scale Ranges
zgc.AxisChange();
Refresh();
|
|
|
|
|
Hi all,
On one of my application I want to use four counters. So I define them as follows as used.
int counter1 = 1, counter2 = 1, counter3 = 1, counter4 = 1;
Is there any other best way to do this?
Use of this is keep track of the index of a list view. I've four list view and to add index I use counters.
Thanks a lot.
I appreciate your help all the time...
CodingLover
|
|
|
|
|
You should probably use an array instead of four different counters. There are plenty of examples if you google for it.
Cheers,
Vıkram.
I've never ever worked anywhere where there has not been someone who given the choice I would not work with again. It's a job, you do your work, put up with the people you don't like, accept there are probably people there that don't like you a lot, and look forward to the weekends.
- Josh Gray.
|
|
|
|
|
Use an array:
int[] counter = new int[] { 1, 1, 1, 1 };
Are you really starting at one? When I count something, the count is zero before counting the first item...
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
This question is not related to C# but I am using it in C# and there is no message board for Regular Expression there for I am posting my question, and I hope some one will solve my problem.
I have this regular expression "(ABC.\d.)(?.*?)*(ABC.\d.)"
and the following data on which I am applying it.
.....
DATA To grab from Regular expression
ABC.1. Recreation. As of June 30, 2007, the balances provided
in the following citations shall revert to the fund
ABC. 2. Recreation. As of June 30, 2007, the balances provided
in the following citations shall revert to the fund
ABC. 3. Recreation. As of June 30, 2007, the balances provided
in the following citations shall revert to the fund
ABC. 4. Recreation. As of June 30, 2007, the balances provided
in the following citations shall revert to the fund
But unfortunately it grabs only ABC.1,ABC.3,ABC.5,ABC.7 and so on
it means this regular expression is skipping one step. Is there any one who can tell me how can I correct this problem. That it should not skip any sequence where it got ABC.\d. it should grab data until it found next ABC.\d.
Thanks in advance ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
modified on Wednesday, February 18, 2009 1:40 AM
|
|
|
|
|
Hi,
I created an socket program where a server listen and number of clients connect to it. Clients have a common static ip and individual local ip of their own system.
In client side if i give Socket.LocalEndPoint i get the local IP address of the client, same i check in the serverside, ie Socket.RemoteEndPoint i get the static IP of the clients network.
so all the client IP shown in the server as same.
How can i identify each clients? Will there be same port in diffrent system in a network of a single static IP?
Thanks,
Yesuprakash
|
|
|
|
|
I'm not so sure you can distinguish that info with the socket alone. I've always spun up a new thread or created new objects to deal with the new socket connection, so I knew that they were different. If you need some kind of identification, you'll need to transmit that information from the client to server on a connection, or request it from the server. Bottom line I think is that you'll need to program it into the client.
Hope that helped...
Scott P
"Simplicity carried to the extreme becomes elegance."
-Jon Franklin
|
|
|
|
|
hi,
Currently i am developing a client server application in c#. I am using socket for communication. With compare to remoting and WCF, is it socket is better?.. or which is good. How can i convert socket to WCF or Remoting?
Thankyou,
Yesuprakash
|
|
|
|
|
I have a web service that returns a custom object which contains several arrays of standard types. When I test out the service on the local machine, everything works just fine, the arrays get populated as expected. However, when I add a reference to it in another project on a different machine and invoke it, the return object's arrays all have zero length.
Any ideas? Are there limitations to having an array nested inside a return object from a Web Service?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
