Hi All,

I created a new aspx page from sharepoint desinger 2007.I used datalist control and connect to SQL Server 2005. Everything was OK so far. When I upload to sharepoint, I got the error mentioning that "This control does not allow connection strings with the following keywords:'Integrated Security','Trusted _Connection'."

I am a new to sharepoint and asp. I don't know how to fix it.

What i want to do is create a new page and add controls(text box,button and datalist) and once user click button, connect to DB and retrieve the data and show the list.

Any one got idea how to do it? pls advice.

Thanks,
Aiko