sql "trim" in asp.net c# & connection strings

[willthepirate]

if anyone could spare me 2 minuites it would be Greatly appreciated,

basically im playing around with c# and experimenting with shopping carts.

im reading this tutorial:
http://www.worldofasp.net/tut/Shopp...opping_Cart_using_ASPNET_and_Cookies_129.aspx

and im trying to get the connection string sorted so that it will connect to an .mdf file in the app_data folder.

ive tried modifying the connection to point to another connection in the web.config, but i get told off about "trim" not bieng defined.

i imagine its a quick fix of the connection string, but im a complete beginner

 

[GravyMonster]

It sounds like your connection string is working fine. The fact it's complaining about a TRIM function not being defined leads me to believe it is connecting and trying to run a query.

In MSSQL there is no TRIM function, only LTRIM and RTRIM.

 

[Pho]

CREATE FUNCTION dbo.TRIM(@string VARCHAR(MAX))
RETURNS VARCHAR(MAX)
BEGIN
RETURN LTRIM(RTRIM(@string))
END
GO

http://blog.sqlauthority.com/2007/04/24/sql-server-trim-function-udf-trim/


I agree with Spunkey. Try adding the above to your mdf database so that TRIM is defined.

 

[Dj_Jestar]

What's wrong with just using string.Trim() in code?

 

[Gullanian]

Highly recommend you don't use an MDF database for a website. They are designed for office use, and they actually get slower and slower the more queries that are executed on the db. In this instance, you need to compact and repair it which can be a slow process.

I recommend using SQL Server, or MySQL if you have to use a free one.