ASP.NET

22-Oct-10 11:45

Start off by working out what you actually want your project to do, and how you want it to work. Once you know that, you need to break the application down into smaller areas and start thinking about how to compartmentalize the different aspects of the app. Don't get hung up on designing for patterns; let it come naturally.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

how to store arraylist in string???????????

srisairam22-Oct-10 0:37

srisairam

22-Oct-10 0:37

Hi all,

in my datatable i have 2 columns 1.email 2. fax(retrieving from database)

that datatable i am storing in arrylist.
i am doing like this:

for (int i = 0; i < dt.Columns.Count; i++)
{
a1.Add(dt.Rows[0][i].ToString());
}
wht i have to do is store arrylist inside string.

after storing the values in string , i have to identify the email with "@" symbol if value contains @ symbol then i have to bind that values to array2

if anybody knows please let me know.

Regards
Rama

Khaniya22-Oct-10 1:27

Khaniya

22-Oct-10 1:27

I have some suggestion for you

1. Why are you using ArrayList you can use Generic List instead.
2. You can use Regular Express to validate email.
3. you can fire Linq query to filter out your list

I know this is not answer but you should have to improve your programming using upgrade techniques

Thanks
Smile | :)

Life's Like a mirror. Smile at it & it smiles back at you.- P Pilgrim
So Smile Please

Sort of a cross between Lawrence of Arabia and Dilbert.[^]

Keith Barrow24-Oct-10 8:04

Keith Barrow

24-Oct-10 8:04

5'd - everything you said here makes sense. Occasionally it is good to step back and look at the problem being solved and all your points are valid. I don't know why you have been downvoted.

Khaniya26-Oct-10 23:49

Khaniya

26-Oct-10 23:49

Thanks

Life's Like a mirror. Smile at it & it smiles back at you.- P Pilgrim
So Smile Please

Adding DataBase to Project

Parwej Ahamad22-Oct-10 6:00

Parwej Ahamad

22-Oct-10 6:00

Make sure you have rows. Do like:

if(dt.Rows.Count > 0 )
{
   ar.Add(dt.Rows[0]["EmailColumnName" OR Index no].ToString());
   ar.Add(dt.Rows[0]["FaxColumnName" OR Index no].ToString());

   if( ar[0].Contains("@") )
       //Bind Array2
 }

If you are looking something else then let me know.

Parwej Ahamad
ahamad.parwej@gmail.com

future383921-Oct-10 15:33

future3839

21-Oct-10 15:33

Hi,
I have installed VS 2008 and SQL Server 2008 Enterprise edition. I basically want to add my database to my website. in the App_Data folder right click and find my database(.mdf). the problem is after hitting enter I got this error.(Access Denied)

does any one has any solution,pleas.

Not Active22-Oct-10 3:20

Not Active

22-Oct-10 3:20

SQL Server Enterprise? You're running a server OS on your development machine?

All you need is SQLExpress. If you look at the machine.config you will see the default connection string is to a SQLExpress instance.

I know the language. I've read a book. - _Madmatt

fjdiewornncalwe22-Oct-10 3:31

fjdiewornncalwe

22-Oct-10 3:31

Assuming that you have to attach the mdf as a static file in your project due to licensing on the SQL Server or for some other reason can't deploy the MSSQL server to your deployment environment, you should perhaps look into using SQLLite and not MSSQL. Clickey

I wasn't, now I am, then I won't be anymore.

future383922-Oct-10 13:00

future3839

22-Oct-10 13:00

thanks for your reply, guys.
i have done the following steps:
I installed VS2008 and MSSQL2008;
I design database and its table in SQLServer2008.
I don't installed SQLExpress.

now, I am developing an MVC Web Application;
the problem is when right click in App_Data folder and choose existing item to add the created database in SQLServer2008, get this error: Access Denied.
Could you please tell me what is the problem? is there any solution to remove fix this error without installing SQLExpress?

fjdiewornncalwe22-Oct-10 14:20

fjdiewornncalwe

22-Oct-10 14:20

SQl Express is not an answer. Your problem is that you cannot connect a db the way your are trying to. You have to create objects that connect with the SQL Server. You are getting Access Denied because SQL Server owns and controls the file.

I wasn't, now I am, then I won't be anymore.

System.FormatException: String was not recognized as a valid DateTime

future383922-Oct-10 14:59

future3839

22-Oct-10 14:59

Hi,

I create an ODBC Driver and find my databse; in VS2008, in Server Explorer I add my database(ODBC.Dell.Test)

I just get confuse; in MVC I have to add my database in App_data(is it true?)if yes, how?
because, again when I add that object get the same problem(Access Denied)

XML deserialization

indian14321-Oct-10 10:23

indian143

21-Oct-10 10:23

Hi All,

I have XML string as below. I am trying to deserialize this xml string in to a Request Object or NewHire Object. I have designed the Request class as it holds
the instance of NewHire class as a public property. I did in two ways

1. First time when I tried for the Request type it was giving exception like error in identifying property NewHire.

2. Then I deleted the Request element from the xml and kept from NewHire to /NewHire part only and then tried to deserialize the object for the NewHire type.
Then its not giving the exception but all the values in the NewHire instance it is giving null. Its not reading the values.

XML File :
----------
string strXML = "" + "<Request>" + "<NewHire>"
+ "<CompanyCandidateCode>CandCode</CompanyCandidateCode>"+ "<SSN>SSS</SSN>"
+ "<LastName>6456</LastName>"+ "<FirstName>3434</FirstName>"
+ "<MiddleName>676</MiddleName>"+ "<EthnicGroup>546456</EthnicGroup>"
+ "<Address>tuituiu</Address>"+ "<City>dfgfd</City>"
+ "<State>ghjgjg</State>"+ "<Zip>345345</Zip>"
+ "<HomePhone>bvnbvn</HomePhone>"+ "<OtherPhone>234234</OtherPhone>"+ "</NewHire>"+ "</Request>";

Deserialize Code:
----------------
            try
            {
                System.Xml.Serialization.XmlSerializer serializer = new System.Xml.Serialization.XmlSerializer(typeof(Request));
            System.IO.TextReader reader =
                new System.IO.StreamReader(new MemoryStream(ASCIIEncoding.Default.GetBytes(strXML))); 
           
            Request ObjItems;

            ObjItems = (Request)serializer.Deserialize(reader);
                reader.Close();

                string str = Convert.ToString(ObjItems.NewHire.Address);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

I want to read this in to my Request or NewHire objects any of the above two methods ok. I prefer for the first one to fill the Request ojbect but if it can fill only NewHire
object and cant fill an object containing another object, I will adjust with NewHire only.

Can anybody please help me in this regard as I have to deserialize it in anyway.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: XML deserialization

T M Gray21-Oct-10 11:06

T M Gray

21-Oct-10 11:06

This article[^] should help, particularly the section Complex Object Serialization. It's all about the attributes.

Re: XML deserialization

indian14321-Oct-10 12:26

indian143

21-Oct-10 12:26

Hi Gray,

I dont know your First Name to call but really it helped me a lot. Thanks for the excellent help. I am going to rate it very very excellent.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

RSS Feed Aggregation

devenneym21-Oct-10 9:59

devenneym

21-Oct-10 9:59

I want to create (or borrow if one exists) a "news ticker" for our website that aggregates RSS feeds from vendors and news outlets into a section of our webpage. I want to maintain the functionality of being able to click through to the stories as you would when using an RSS reader. Is there something out there that already exists and I'm just not looking for the right thing? I know I've seen this on other websites and was just wondering if this is something that every website has developed on their own? Any help is much appreciated, thanks!

Asif Rehman21-Oct-10 1:18

Asif Rehman

21-Oct-10 1:18

When I don't pass certain value in textbox. It gives me above exception.
Here's the code.

cmd.Parameters.Add("DOB", SqlDbType.SmallDateTime).Value = txtDOB.Text;

I want to ignore NULL values. How to tackle this problem.

I know it should have been easy. But anyhow, I stuck .

Regards
Asif Rehman

Re: System.FormatException: String was not recognized as a valid DateTime

Pete O'Hanlon21-Oct-10 1:25

21-Oct-10 1:25

If the value in txtDOB.Text is a null or whitespace character, you need to set Value to DBNull.Value.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

Re: System.FormatException: String was not recognized as a valid DateTime

Asif Rehman21-Oct-10 1:37

Asif Rehman

21-Oct-10 1:37

thanks for quick response.

So to my best understanding, I can replace

old phrase

cmd.Parameters.Add("DOB", SqlDbType.SmallDateTime).Value = txtDOB.Text;

with this one

cmd.Parameters.Add("DOB", SqlDbType.SmallDateTime).Value =  (string.IsNullOrEmpty( txtDOB.Text)) ? DBNull.Value.ToString() : txtDOB.Text;

Is there any way shorter to do this.

Regards
Asif Rehman

Re: System.FormatException: String was not recognized as a valid DateTime

Pete O'Hanlon21-Oct-10 1:55

21-Oct-10 1:55

I normally use a utility method like this:

public static object GetValueForParameter(string value)
{
  if (!string.IsNullOrWhitespace(value))
    return value;
  return DBNull.Value;
}

Then you can replace your code with cmd.Parameters.Add("DOB", SqlDbType.SmallDateTime).Value = Utility.GetValueForParameter(txtDOB.Text);

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

Thanks It works.

Asif Rehman21-Oct-10 2:15

Asif Rehman

21-Oct-10 2:15

Thanks. It works.

Regards
Asif Rehman

Re: Thanks It works.

Pete O'Hanlon21-Oct-10 2:57

21-Oct-10 2:57

You're welcome. Thanks for letting me know.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads