Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Writing queries for mobile web sites Expand / Collapse
Author
Message
Posted Thursday, March 11, 2010 9:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 10, 2014 3:12 PM
Points: 2,132, Visits: 3,399
Hey guys . . .

I've been tasked with writing a version of our web site for mobile devices. Although I have a lot of experience with HTML, ASP, and ASP.NET, I have never written mobile apps before, so this is uncharted territory for me.

So, you might be asking, what does this have to do with SQL? Well, a lot of our web pages are data-driven (they use a SQL Server back-end -- I think it's 2005). In fact, one of my first tasks is to retrofit a data-driven page for mobile devices.

I've read, so far, that mobile authoring discourages using scripting, which will likely impact my ability to access data.

With that, can any of you recommend reference resources, best practices, and hidden "gotchas" that I might come across when writing data-driven web sites for mobile devices? (Apologies if this question seems vague -- I haven't delved deeply enough into this yet to know what to ask!)

Thanks!
Post #881157
Posted Saturday, March 13, 2010 5:44 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, April 13, 2014 12:23 PM
Points: 3,433, Visits: 14,411
Ray K (3/11/2010)
Hey guys . . .

I've been tasked with writing a version of our web site for mobile devices. Although I have a lot of experience with HTML, ASP, and ASP.NET, I have never written mobile apps before, so this is uncharted territory for me.

So, you might be asking, what does this have to do with SQL? Well, a lot of our web pages are data-driven (they use a SQL Server back-end -- I think it's 2005). In fact, one of my first tasks is to retrofit a data-driven page for mobile devices.

I've read, so far, that mobile authoring discourages using scripting, which will likely impact my ability to access data.

With that, can any of you recommend reference resources, best practices, and hidden "gotchas" that I might come across when writing data-driven web sites for mobile devices? (Apologies if this question seems vague -- I haven't delved deeply enough into this yet to know what to ask!)

Thanks!


The mobile area of Asp.net moves so fast the it is best to use third party controls because these vendors handle mobile browser changes. There are some options with mobile data, write RMO(replication management object) code, consume SSIS package with SQL Server CE getting you mobile data and the last option use Replication. Check the thread below for some replication sample code.

http://www.sqlservercentral.com/Forums/Topic836764-323-1.aspx


Kind regards,
Gift Peddie
Post #882437
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse