Browse by Tags

Home › ASP.NET Weblogs

All Tags » SQLDataSource (RSS)

Data Access - The SqlDataSource Part 3

In the previous posts we dropped a table from the Server Explorer onto our design surface and saw how a SqlDataSource was created with T-SQL statements to populate the basic functions of our control. In the second part we replaced our T-SQL with stored procedures and saw how this can help us maintain...

Posted to Ryan Smith (Weblog) by ryansjedi on 04-24-2008, 12:00 AM
Filed under: .Net, Visual Studio, ASP.NET, SqlDataSource
Data Access - The SqlDataSource Part 2.5

Ok so I made a mistake when I kicked off this series...I picked Sql Server Express as our database for all the logical reasons...however I failed to remember that Sql Server Express doesn't do Sql Cache Dependency...so instead of retro fitting my series to use Sql Server 2005 I'll punt and just say ...

Posted to Ryan Smith (Weblog) by ryansjedi on 04-21-2008, 12:00 AM
Filed under: Visual Studio, ASP.NET, SqlDataSource, Sql Server
Data Access - The SqlDataSource Part 2

In our last post we showed what happened when you drag and drop a table onto the design surface, a fully functional (including sorting, paging, updating and deleting) SqlDataSource with T-SQL populating the command fields. While this scenario makes for a slick demo, it's not ideal. The reason I say it...

Posted to Ryan Smith (Weblog) by ryansjedi on 04-14-2008, 12:00 AM
Filed under: .Net, SqlDataSource, Sql Server
Data Access - The SqlDataSource Part 1

Welcome back! If you are following along from the last post , you'll notice that two controls were automatically created on our page when we dropped the Customer table onto the page. The first control is called a GridView. The GridView control is used to display data in much the same way that the SQL...

Posted to Ryan Smith (Weblog) by ryansjedi on 04-12-2008, 12:00 AM
Filed under: Visual Studio, ASP.NET, SqlDataSource, Sql Server
Fixed! Oracle 11G and SqlDataSource: The ugly 'ORA-01036: illegal variable name/number' Issue

I posted my problem on Oracle's OTN Discussion Forum ( http://forums.oracle.com/forums/thread.jspa?messageID=2366331&#2366331 ) and got two great answers. It turns out that I was using Microsoft's Oracle provider, not Oracle's. Make sure you install Oracle's software and take care to select the right...

Posted to WebLog of Ken Cox (Weblog) by Ken Cox [MVP] on 02-25-2008, 12:00 AM
Filed under: .NET, ASP.NET, sqldatasource, oracle
Oracle 11G and SqlDataSource: The ugly 'ORA-01036: illegal variable name/number' Issue

Update: Fixed as described here : http://weblogs.asp.net/kencox/archive/2008/02/25/fixed-oracle-11g-and-sqldatasource-the-ugly-ora-01036-illegal-variable-name-number-issue.aspx ---- I've created a short video to explain my problem with Oracle and SqlDataSource. If you'd rather watch than read, go see...

Posted to WebLog of Ken Cox (Weblog) by Ken Cox [MVP] on 02-24-2008, 12:00 AM
Filed under: .NET, ASP.NET, sqldatasource, oracle