ASP.NET

David C# Hobbyist.21-Dec-11 11:13

David C# Hobbyist.

21-Dec-11 11:13

Thanks for answering My post. I think I will store the salted hash and email a temp link for password reset.

I can try to make it somewhat secure that way.

Smile | :)

Frazzle the name say's it all

jkirkerx21-Dec-11 11:55

jkirkerx

21-Dec-11 11:55

That's how I started. Later on down the road, you'll need something else, and you can add it then.

David C# Hobbyist.21-Dec-11 14:06

David C# Hobbyist.

21-Dec-11 14:06

Out of curiosity what more can I do? If You know of some learning resources I can use like books or links I would be most grateful.
Thanks in advance

Frazzle the name say's it all

html contents into plain text

jkirkerx21-Dec-11 15:25

jkirkerx

21-Dec-11 15:25

The main goal is to obscure the password in the database in case someone gets a peek at it. Now you can encrypt the username, so if someone peeks, they can't put the 2 together.

You can encrypt the email address, so it is a mystery as to who it is.

On the customer service side, people will say I lost my password. Or what is my husbands password, assuming the husband uses the same password, so they can access his email.

Or people will forget their password, because they were drinking when they created the account, thus the password reset.

OK, so your all encrypted to the max, a programmer just needs the code, the key, and perhaps the IV to decrypt the data.

Is your data file protected, from internal or external theft? Can someone on the internet figure out how to steal it online.

It goes on and on and on.

MalarGayu19-Dec-11 9:36

MalarGayu

19-Dec-11 9:36

hi
i am having the following function in javascript:

function passvalue() {

var editor = $find("<%=Editor1.ClientID%>");
var content = editor.get_content();
window.opener.document.getElementById("ctl00_cphMain_txtEditor").value = content;
self.close();
}
in this function in am getting the editor contents but all are in html format.

can anyone plz tell me how to convert the contents into plain text.

K.Gayathri

Re: html contents into plain text

Jain Vijay19-Dec-11 17:37

Jain Vijay

19-Dec-11 17:37

var nonHTMLcontent = document.getElementById(ControlIdContainsHTMLContent).contentWindow.document.execCommand("RemoveFormat",false,null)

Here

ControlIdContainsHTMLContent

contains HTML content. In

nonHTMLcontent

variable you will get content after removing formatting.

Hope this will help.

Regards...

Vijay Jain

"One thing you can't recycle is wasted time."

Re: html contents into plain text

MalarGayu19-Dec-11 17:57

MalarGayu

19-Dec-11 17:57

hi
thanks for the reply
but in the code my document.getelementbyid(" ")

is not finding the element so only i am using find method..
so now how to proceed plz...

K.Gayathri

Data display with dynamic coloum

yesu prakash18-Dec-11 23:17

yesu prakash

18-Dec-11 23:17

Insert Multiple Records by one click

sk_ko18-Dec-11 20:09

sk_ko

18-Dec-11 20:09

Re: Insert Multiple Records by one click

kaisernayan21-Dec-11 0:06

kaisernayan

21-Dec-11 0:06

Its really simple. You have to put the insert code into a loop. From your description, suppose your list-box has 5 items. then you can make code like this

for(int i=0;i

Re: Insert Multiple Records by one click

rkrishnach21-Dec-11 0:15

rkrishnach

21-Dec-11 0:15

Build datatable in code behind.Add all rows to the datatable. Then use sqlbulkcopy.It inserts all the records into database table in one shot.

SqlConnection destinationConnection = new SqlConnection(strConnection);
destinationConnection.Open();
SqlBulkCopy bulkCopy = new SqlBulkCopy(destinationConnection );
bulkCopy.DestinationTableName = "destination";
bulkCopy.WriteToServer(yourDatatable);
destinationConnection .Close();

Rams.Ch

Sorting numbers then adding to a database

Chris_B8417-Dec-11 9:50

Chris_B84

17-Dec-11 9:50

Hi, I have applied for an entry-level job. I've been sent the following email and I have to program it before I can get an interview. I graduated in 2007 and have forgotten a lot, so have been teaching myself programming languages again recently.

Candidates are required to build an ASP.NET application, using C#.Net for code behind and targeting version 3.5 of the framework. The application will require a SQL server database for storage of data generated by the application. This application must perform the following tasks:

1. Allow the user to enter numbers, of any integer value and in random order. Sort these numbers in either ascending or descending order – the order should be chosen by the user.
2. The ordered sequence should be inserted into a database record along with the direction that the sequence was sorted in and the time taken to perform the sort.
3. Standard .Net controls should be used to bind to the newly inserted record and display the results of the ordering.
4. Again using standard .Net controls the results of all sorts should be available for display in either ascending or descending order of time taken and exportable as XML.
5. Use the design template provided to style your application.
6. Please document all assumptions and decisions taken separately and submit with final code base.

-------------------------

For 1: I have 6 text boxes the user will type numbers in to and a drop down list for them to select ascending or descending. When they click a button, all the numbers go into an array, it is sorted in the required order, and then the numbers will be output into the text boxes in the correct order - is this how you would do this?

I think I know how to add it to the database. The one part I'm stumped on is in part 2: How do I get the time taken to perform the sort? Do I use a Timer control? If so, how many decimal places would you use? 3 or 4? Or much more?

Thanks in advance for any help Smile | :)

modified 17-Dec-11 16:09pm.

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;