ASP.NET

How to read everyother line from a CSV file

19-Dec-08 15:27

This is asked so often. The regional settings are obviously different, no matter what you think, and either way, apart from the terrible naming conventions, no production code should ever use Date.Parse, that's what Date.TryParse is for. I wouldn't actually sack someone for writing this code, but there's quite a number of htings I'd be having a talk to them about.

You will always face this issue - if you're moving dates from strings, you risk getting the wrong dates unless you can be sure of the setup on the server. Either way, it's best avoided. I'm all for using a 17 Feb 1969 format, as it's unambiguous.

Christian Graus

Driven to the arms of OSX by Vista.

Re: date.parse problem

todd.0101110120-Dec-08 2:52

todd.01011101

20-Dec-08 2:52

I love pompous know-it-all responses that don't answer the question.
Christian, it seemed pretty obvious that the code was written for purposes of demonstrating the problem and was not supposed to be "production code". Feel free to spend as much time as you'd like refactoring it and bringing it up to your standard.

I did some additional reading, and found this very helpful knowledge base article about stabilizing culture specific behavior in asp.net apps - if anyone else has a similar question in the future..

http://support.microsoft.com/kb/326943[^]

Tina P19-Dec-08 10:55

19-Dec-08 10:55

Hello,

I am reading a CSV file into the memory using a streamreader object. I was wondering if there's a way to skip every other line.

ABCD........ (read it)
EFGH........ (skip it)

Here's how I'm reading the csv file:

Command.Parameters.Add("@FirstName", SqlDbType.Nvarchar);
               Command.Parameters.Add("@LocationCode", SqlDbType.Float);\
               Command.Parameters.Add("@Zip", SqlDbType.Float);


                   for (int i = 0; i < 11; i ++)
                        {
                            while ((line = sr.ReadLine()) != null)
                            {
                                string[] col = line.Split(',');
                                cmd.Parameters["@FirstName"].Value = col[i];
                                cmd.Parameters["@LocationCode"].Value = col[i + 1];
                                .
                                .
                                cmd.Parameters["@Zip"].Value = col[i + 10];

                                cmd.ExecuteNonQuery();
                            }
                        }

Thanks

Tina

Blue_Boy19-Dec-08 11:50

Blue_Boy

19-Dec-08 11:50

You want to execute code in this way:

ABCD........ (read it)
EFGH........ (skip it)
IJKL.........(read it)
MNOP.........(skip it)

and so on?

Do you want to execute code inside while loop in every odd case?

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Tina P22-Dec-08 5:58

22-Dec-08 5:58

Hello there, thanks for the speedy response. Sorry couldn’t write back sooner. Yes I do want to skip every other line….chances are its going to be the odd line every single time, however as I said the data is pretty out of whack, so if they decided to add another line before we receive it…it may switch to even.

Is there a way to do code it in a way to skip either one (even or odd line) depending on my data coming in?

Thanks

Tina

Christian Graus19-Dec-08 13:45

19-Dec-08 13:45

You have to read the line then skip it in code. You can't tell the streamreader to read every other line directly.

If you know it's every other line, always, then do this:

while ((line = sr.ReadLine()) != null)
{
{
if ((line = sr.ReadLine()) != null)
{
xx

If you want the odd numbered line, do the second read at the end of the block.

Christian Graus

Driven to the arms of OSX by Vista.

Tina P22-Dec-08 6:04

22-Dec-08 6:04

Christian Graus wrote:
If you want the odd numbered line, do the second read at the end of the block.

Could you please elaborate on the above statement Frown | :(

Unfornunately I don't see how would it skip the line?

Is there a way to code it in a way that it'll skip either one (even or odd line) depending on my data coming in?

Thanks

Tina

Christian Graus22-Dec-08 10:46

22-Dec-08 10:46

You'd have to read the line and then parse it if you wanted to decide as you go which line to skip. It skips a line because it reads two lines, the code to read a line is repeated, and so it reads two before doing anything with the data.

Christian Graus

Driven to the arms of OSX by Vista.

Tina P22-Dec-08 12:20

22-Dec-08 12:20

Sorry once again about the delayed response to your earlier post...i was out of town Smile | :)

Thanks once again Christian!

I guess that make sense...is this scenario capable of handling even and odd both (lines to skip)? I'm going to try it out later tonigt but just checking with you? Thanks
Tina

Christian Graus22-Dec-08 14:00

22-Dec-08 14:00

Yes, either read two lines, then parse, or read a line, parse, then read another before the loop goes back.

Christian Graus

Driven to the arms of OSX by Vista.

Tina P25-Dec-08 16:47

Adding Controls to a updatepanel dynamically

25-Dec-08 16:47

Hello, Christian...sorry I've been a little sick lately. ANyways, i tried but it won't work quite the way you said.

I swithced to using a TextFieldParser class in Microsoft.VisualBasic.FileIO namespace.

Here's what I'm doing:

using (TextFieldParser textParser = new TextFieldParser(sFileName))
               {
                   textParser.TextFieldType = FieldType.Delimited;
                   textParser.HasFieldsEnclosedInQuotes = false;
                   textParser.SetDelimiters(",");

                   while (!textParser.EndOfData)
                   {
                       Measurements myMeasure = new Measurements();

                       String[] currentRow = textParser.ReadFields();

                       myMeasure._EmplNum= double.Parse(currentRow[0]);
                       myMeasure.DATE = DateTime.Parse(currentRow[1]);
                       myMeasure.Day = Convert.ToString(currentRow[2]);

                       myMeasure.Process(myMeasure);
                   }
               }

where Process is a custom method that is used to instantiate dataContext and then invoke the stored procedure (by calling its method that is generated by LINQ to SQL)

public void Process(Measurements measObj)
        {
            //This is where we implement the logic to process the data.

            MyDataContext dataContext = new MyDataContext();

            dataContext.InsertDaily(measObj.EmplNum, measObj.Date, measObj.Day);
        }

In the first code block where I'm setting up the while loop, i need to set it up in such a way that it'll skip some lines (say first 100) from the CSV file (in other words a few hundred lines of data upfron is useless and needs to be discarded but it'll be part of the CSV coming in) and then when it finally find the place where the actual data begins (lets say a keyWord such as 'Target' or something along those lines, then perhaps I need to do a string.Substring and find it...then starts reading it? I'm not quite sure how to accomplish that keeping the above code in mind.

Any advice.

Thanks a lot
Tina

Windows Authentication

Jacob D Dixon19-Dec-08 9:51

Jacob D Dixon

19-Dec-08 9:51

Hey I was wondering how to use windows authentication.

In IIS what do I set? Everything I have tried setting still requires a username and password when going into the page. Now in the page I have coded it to pull active directory information.

By using User.Identity.Name I was able to get the information from AD like Division, Full name, email address. But the user still needs to login to the web page. Well our users on the local network are already logged into the network.

So how do I use User.Identity.Name without them logging into the webpage? I have set Digest Windows Authentication and when tyring to view the web page it pops up asking for a username and password.

With SharePoint it gets this information without the user logging in. If the user is logged into the network it automatically gets the information through a web page.

Alomgir Miah A19-Dec-08 9:49

19-Dec-08 9:49

Hi,

I have a Custom control derived from webcontrol. This control has an UpdatePanel as its member variable. In the constructor of the UpdatePanel I am creating the childcontrols of the UpdatePanel

this.updatePanel.ContentTemplateContainer.Controls.Add(this);

What I want to achieve here is that when I do something like control.Invalidate(), the UpdatePanel should force the control it is tied to, to rerender i.e. call the Render method of the custom control.

for some reason this is not working. Can someone please give me some pointers on what I am doing wrong.

Thanks,
Alomgir Miah
Live Life King Size

Christian Graus19-Dec-08 10:46

19-Dec-08 10:46

An update panel means you're in the right forum. Does the Invalidate method force a postback on the AJAX control ? Or are you saying you're trying to work out what method to call to force an update panel to make an AJAX call ? Just look in the javascriot, work out what the framework calls, and call it. If you wrote AJAX code yourself, you'd know what method to call.

Funny enough, someone asked the same question and got an answer, just a few posts down.

Christian Graus

Driven to the arms of OSX by Vista.

Alomgir Miah A19-Dec-08 14:28

19-Dec-08 14:28

Thanks for your reply.
The website I am working in refreshes every second to keep the data up to date. Clicking the control does a AJAX postback and that part is working fine. The problem is that I want to change the control settings in the server due to some server events. Now to force the control rendering independently of all the other controls Invalidate essentially call Update() on the UpdatePanel associated with the control. For some reason the Render method of the control does not get called when the Update is called on the UpdatePanel.

googling this suggests that I need to implement ITemplate, add the control to it and replace the ContentTemplate with it. But it seems this technique is not working.
I hope I am clear enough in what I am looking for.

Thanks,
Live Life King Size

Christian Graus19-Dec-08 16:37

19-Dec-08 16:37

you want the server to force a control to update ? That can't happen. AJAX doesn't mean the server can talk to the client.

Christian Graus

Driven to the arms of OSX by Vista.

Alomgir Miah A19-Dec-08 18:07

19-Dec-08 18:07

Yes it can happen. If the trigger of the UpdatePanel is set to conditional then calling Update() on the UpdatePanel will do an update. Like I was mentioning that I am doing a postback every 1 second and checking for changes. This ensures the Server forcing a client update. Only if somethings happens in the server, a certain UpdatePanel gets updated.

Christian Graus19-Dec-08 18:23

19-Dec-08 18:23

Yes, you can force it to call every second, but your server can only respond to those calls, it can't make a call to a webpage. Every AJAX call can change the controls on the page, in fact, you can use js to do that any time you like.

Christian Graus

Driven to the arms of OSX by Vista.

Alomgir Miah A19-Dec-08 18:45

19-Dec-08 18:45

Yes thats true.
So I think in this hussle we forgot about the original problem. How to add a control to the UpdatePanel dynamically and force the call to UpdatePanel.Update() to call Render(HtmlWriter writer) on the child controls.

Thanks

Christian Graus19-Dec-08 18:56