ASP.NET

jkirkerx17-Dec-11 21:02

jkirkerx

17-Dec-11 21:02

I remember an array.reverse or something to sort

before sort, get the time stamp, when done get time stamp, and deduct the time using time difference.

That's a good test of skill.

Chris_B8418-Dec-11 1:25

Chris_B84

18-Dec-11 1:25

Yep, for the sorting I used Array.Sort(myArray) for ascending. I did the same for descending with Array.Reverse(myArray) afterwards.

How do I do a timestamp? I've never worked with timers before in C# - only in VB and even then it was a very basic thing that counted up in seconds.

Could someone give me some code which times the sort and puts the amount of time into a float or double variable?

I've googled it and found QueryPerfCounter(). Is that what I need to use?

Thanks.

EDIT: I now have the following code:

var start = DateTime.now;
//code here which I am timing
int i = DateTime.Now.Subtract(start).Milliseconds;
TextBox1.Text = Convert.ToString(i);

The last line is just so I can test the answer I get. And I keep getting zero! I guess thats because I'm only measuring hours, minutes and seconds - not milliseconds. Can someone help?

modified 18-Dec-11 8:56am.

Richard MacCutchan18-Dec-11 4:39

Richard MacCutchan

18-Dec-11 4:39

How To: Measure execution time in C#[^] may have what you are looking for.

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

Chris_B8418-Dec-11 5:23

Chris_B84

18-Dec-11 5:23

Thank you! Smile | :)

I have now done it, using Stopwatch.

I had tried to use the stopwatch earlier and couldn't get it to work - all because I was missing the namespace using System.Diagnostics Roll eyes | :rolleyes:

Re: related news function?

Not Active18-Dec-11 9:03

Not Active

18-Dec-11 9:03

I understand your desire to learn, however, I believe the intention of the interview process is to see what you can do, not what others recommend you do, or do for you. If you do manage to get to the next stage of the interview process, do you mention you had help with this? If you manage to get the job, will the employer expect you to deliver, or expect you to ask others?

It is one thing to research a problem; no one is expected to know everything. It is another matter entirely, IMO, to ask for help on such interview, or exam, questions.

Also keep in mind the there may be a good likelihood the person who gave you these questions checks sites like this for people asking questions like this.

No comment

related news function?

duongvannam16-Dec-11 17:39

duongvannam

16-Dec-11 17:39

hello,i have a question.I bulding a news page.I'm using C# asp.net.So,when i view a news related to Beckham.I want in the end of the news to show another news reated ti Beckham.
So,in my database,news column just have 4 column:title,content,summary,teaster image.
So,just in title have Beckham.how to display it in related news?

Example:From this title about David Beckham.The keyword "David" has choosen.And the related news in bottomto display the related news about "David".

http://www.newstrackindia.com/newsdetails/255070

Can you help me?Thank you.

Not Active17-Dec-11 3:54

Not Active

17-Dec-11 3:54

It is simply a matter of forming the database query. Something like,

SELECT Title, Summary
WHERE Title CONTAINS('@keyword')

No comment

Comparing array of strings

indian14316-Dec-11 6:23

indian143

16-Dec-11 6:23

Hi,

I have an asp.net application which loads data from csv file. I need to check for duplicate rows in the csv file and should not process them and give error message for those duplicate rows.

I did in some approach but got the comments like performance is impacted. Is there any performance oriented process available to compare the string arrays

Any type of help is greatly appreciate.

Here is my code

private static bool CheckForDuplicateRow(FileInfo file
            ,string[] line
            ,int lineNumber
            ,ref bool lineAlreadyVerified)
        {
            CsvStream csvStream;

            using (Stream fileStream = file.OpenRead())
            {
                using (StreamReader reader = new StreamReader(fileStream))
                {
                    csvStream = new CsvStream(reader);
                    string[] rowItems;
                    try
                    {
                        csvStream.GetNextRow(); //This is for header values, we are not comparing for header values

                        rowItems = csvStream.GetNextRow();
                        int rownumber = 1;

                        while (rowItems != null)
                        {
                            if ((rowItems.Length == line.Length) && (rownumber != lineNumber) && (rowItems.Length > 0))
                            {
                                bool b = AreRowItemsEqual(rowItems, line);
                                if (AreRowItemsEqual(rowItems, line) == true)
                                {
                                    if (lineNumber < rownumber)
                                        lineAlreadyVerified = true;
                                    return true;
                                }
                            }
         
                   rowItems = csvStream.GetNextRow();
                            rownumber++;
                        }
                    }
                    catch (Exception e)
                    {                        
                        throw e;
                    }
                }
            }

            return false;
        }

        private static bool AreRowItemsEqual(string[] rowItems, string[] line)
        {
            for (int i = 0; i < rowItems.Length; i++)
            {
                if (rowItems[i] != line[i])
                {
                    return false;
                }
            }
            return true;
        }

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

modified 16-Dec-11 12:34pm.

Morgs Morgan17-Dec-11 8:57

Morgs Morgan

17-Dec-11 8:57

indian143 wrote:
I have an asp.net application which loads data from csv file. I need to check for duplicate rows in the csv file and should not process them and give error message for those duplicate rows.

Here's my approach:

//list to add lines in your csv file
ArrayList uniqueLines = new ArrayList();
ArrayList duplicateLines = new ArrayList();

//Read all lines from your csv file
String[] lines = File.ReadAllLines( "C:/file.csv" );//passing the file path

foreach ( String line in lines )
{
   if ( !uniqueLines.Contains( line ) )
   {
      uniqueLines.Add( line );
   }
   else
   {
      duplicateLines.Add( line );
   }

}

From the above, you have all the unique lines in the uniqueLines arraylist and you have duplicate lines in the duplicateLines arraylist.
To display errors, loop through the "duplicateLines" and tell the user about the error.

Happy Coding,
Morgs

indian14318-Dec-11 14:03

indian143

18-Dec-11 14:03

Can I use List instead of ArrayList, because that class is not coming in my application, I dont know why?

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

Morgs Morgan18-Dec-11 19:06

Morgs Morgan

18-Dec-11 19:06

Yes, you can use List<string> if you want. The ArrayList comes from the: using System.Collections;

how to show a pupup on my parant window.

indian14318-Dec-11 21:03

indian143

18-Dec-11 21:03

Hi,

Is there any way to get the which rows are repeated, like for example row 1, 3, 5 are same and 2 and 4 are same.

Is there any way to get that from this list?

thanks,
Abdul.

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

Jitendra Parida - Jeetu16-Dec-11 1:59

Jitendra Parida - Jeetu

16-Dec-11 1:59

Hi,

For when click datalist item show pupup on parent window i use this code :

any other???????

XML

protected void dlPhotos_ItemCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName == "Select")
        {
            Response.Write("<script>");
          Response.Write("window.open(Default3.aspx','_self','toolbar=0,location=0,menubar=0,resizable=0,width=400,height=320')");
            Response.Write("</script>");
        }
    }

Dennis E White16-Dec-11 5:30

Dennis E White

16-Dec-11 5:30

Jitendra Parida1987 wrote:
ItemCommand(object source, DataListCommandEventArgs e)

this is server side code which will get executed the user clicks a button in your DataList. I am assuming that your expected behavior is not working.

since everything in your script appears to be static why not just write the script code into your .aspx page directly? add your control and on the click event call your javascript function. the only thing you need change is returning false so that it won't post back.

as if the facebook, twitter and message boards weren't enough - blogged

Jitendra Parida - Jeetu17-Dec-11 1:06

Jitendra Parida - Jeetu

17-Dec-11 1:06

Hi,

My requirement is dynamically implement so that i try this code.

Dennis E White17-Dec-11 5:42

Dennis E White

17-Dec-11 5:42

Jitendra Parida1987 wrote:
My requirement is dynamically implement

dynamically implement??

there is nothing dynamic about that script that you posted so why not just put it in a static javascript function that gets called from each item in the DataList. the html code that gets displayed is dynamically generated on the server so maybe that is it??

sounds like a homework assignment when you mention it this.. haha

as if the facebook, twitter and message boards weren't enough - blogged