You searched for the word(s): userid:687558

More Search Options

RSS Available

• Regular Expression for a cost

  Hi This seems so simple, and yet I find myself pulling my hair out! I’d like a regular expression for cost – any number for the pounds 1-999, then a ‘.’ And then 2 digits. I’ve got this far: ^[0-9]{3}.[0-9]{2}$ But the first part requires 3 digits ( 001.00 ) and I’d like to support just ( 1.00 ). Any thoughts? Many thanks.

  Posted to Getting Started (Forum) by RichardLaw on 12/31/2009

• Re: Regular Expression for a cost

  Thanks Roma!

  Posted to Getting Started (Forum) by RichardLaw on 12/31/2009

• Connection String - Local MS SQL 2005 (express)

  Hi I'm running Windows XP, and MS SQL Express 2005. I've made a simple .Net 2.0 website and it runs fine; but I'd like to get it running using IIS outside of Visual Studio. I've setup IIS and that's fine, but what do I need to use for the connection string? Do I create a ODBC connection? Can someone please help with examples? Many thanks Richard

  Posted to Getting Started (Forum) by RichardLaw on 11/21/2009

• Re: Connection String - Local MS SQL 2005 (express)

  Thanks for your help, only I get the following error: System.Data.SqlClient.SqlException: Cannot open database "myDatabase" requested by the login. The login failed

  Posted to Getting Started (Forum) by RichardLaw on 11/21/2009

• Re: Connection String - Local MS SQL 2005 (express)

  Thanks. This is what I've created so far: < add name = " connectionString " connectionString = " Server=.\SqlExpress; Database=bam;Integrated Security=True; User ID=webAccess; password=webAccess; " providerName = " System.Data.SqlClient " /> But now I get login failures. I can get a working connection via ODBC - can I not just reference that??? Thanks Richard

  Posted to Getting Started (Forum) by RichardLaw on 11/21/2009

• MS SQL to Access

  Hi I've been using the following code with an Access database, and now have upgraded to MS SQL. Can someone show me what I need to change inorder to support MS SQL?? SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["StressM_ConnectionString"].ToString()); SqlCom = new SqlCommand("SELECT * FROM tblNews", SqlCon); SqlCon.Open(); Many thanks Richard

  Posted to Getting Started (Forum) by RichardLaw on 10/27/2009

• Re: MS SQL to Access

  I'm an idiot! I ment to say, the code works with MS SQL, and now I need to change it to work with MS Access. Sorry!!!

  Posted to Getting Started (Forum) by RichardLaw on 10/27/2009

• Help with converting code behind - stored procedure to standard tables

  I’ve found what I hope is a great easy tutorial to setup RSS on my site. The only thing is, the code is calling a stored procedure, and I’d like to call a table. Can someone please help with the code conversion? SqlCon = new SqlConnection (ConfigurationManager.ConnectionStrings[ "ConnectionString" ].ToString()); SqlCom = SqlCom.CommandType = CommandType.StoredProcedure; { SqlCon.Open(); } SqlDR = SqlCom.ExecuteReader(); new SqlCommand ( "GetTodaysHeadlines" , SqlCon); if (SqlCon

  Posted to Getting Started (Forum) by RichardLaw on 10/25/2009

• Re: Help with converting code behind - stored procedure to standard tables

  Thanks so much - works perfect!!!

  Posted to Getting Started (Forum) by RichardLaw on 10/25/2009

• Re: Multiple DataNavigateUrlFields in template format

  Works perfect! Thank you very much!

  Posted to Data Presentation Controls (Forum) by RichardLaw on 10/19/2009