.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Sms to mobile phone using SQL server

Posted By:      Posted Date: September 19, 2010    Points: 0   Category :Sql Server

hello every one


     any body please help me how to send SMS through SQL SERVER to mobile phone and how to schedule using sql to send automatically.

View Complete Post

More Related Resource Links

Use a Windows Mobile Phone as a Bluetooth Modem

Many Windows Mobile Pocket PC Phones and Windows Mobile Smartphones can be connected to a Windows PC via Bluetooth for use as a wireless dial-up modem. If your Windows Mobile device supports Bluetooth Dial-Up Networking, or Bluetooth DUN, and your Windows PC Bluetooth-enabled, you have everything you need.

In this tutorial, we'll show you how to use Windows Mobile Pocket PC Phones or Smartphones as a Bluetooth modem for Windows XP PCs.

Mobile phone browser detection


Hi i am planning to develop a site for mobiles. My first problem is how to find the mobile browser so that i can redirect to the mobile site for good look. When i searched for that i came accross WURFL which contains the list of mobile user agents? Is this the good solution or anybody having good solution please tell which will be helpful for me.

Waiting for the reply

How to detect mobile phone name/model no from asp.net?


Hi experts,

Can I detect the Name/model no of the mobile phones ,which are browsing my asp.net website from C# code behind? I need to show welcome message, addressing their model numbers and redirect to appropriate pages.

Thanks in advance for your reply.


Go Mobile: Create Compact, Robust Mobile Apps with SQL Server CE 2.0 and the .NET Compact Framework


Developers have myriad options when it comes to creating solutions for mobile devices. One of the greatest challenges facing mobile developers is finding a compact yet robust local storage solution. SQL Server CE 2.0 promises to deliver on both fronts. This new release represents a tremendous leap in terms of features and performance over its predecessor. This article will review some of the platform and tools choices developers have today. The authors will compare and contrast the significant new features in SQL Server CE 2.0 with the previous release. Following that, they will build a sample app for illustration.

Mark Brown and David Meunier

MSDN Magazine January 2003

Getting IMEI number of a mobile phone

I am developing an  asp.net web application which supplies content to mobile phones  , Im trying to get the imei number of  mobile phones using thier numbers. How can we achieve this?

Synchronize group calendar from Sharepoint 2007 (SBS Server 2008) using ActiveSync for mobile device


I've created a Public Folder Calendar on my Exchange Server that our Office Manager uses to inform all our partners and staff (small medical practice) of vacations, group meetings, etc.

I'd like to make this calendar available to mobile devices (1 Windows Mobile, 1 Blackberry, 3 iPhones). I know that individual user Exchange Calendars can sync, but I'm told Microsoft isn't making any effort to make this happen for Public Folder calendars because they're being deemphasized and will disappear in either the next or subsequent version of Exchange. There's a third party product that claims to do this (Outlook AddIn). Since the Public Folder Calendars are being de-emphasized in favor of the Sharepoint calendar, one would think that Activesync would be able to work with the SharePoint group calendar, but apparently that's not the case. Is my best bet still the Add to Outlook product from diditbetter.com?

How to send sms from a desktop or web app using a windows mobile phone as a gsm modem


Hi to all,

I need to make an application that can send sms from a desktop pc using a windows mobile phone as a gsm modem. It can be a desktop app or a web app. 

The mobile phone is connected via USB. 

I don't want to use third party sms gateways.

Can you point me in the right direction?

Thanks in advance

Access ASP.Net website in a mobile phone



I have an internal ASP.Net application. We want to extend the accessibility of this application for the users using their mobile phone.

The application runs on an internal server of the company.

Is it possible to open the website(internal within the intranet) in a mobile phone and perform operations?

Thank you,


Mobile Apps: Getting Started with Windows Phone Development Tools


Windows Phone 7 has shipped, and now it's your turn to start developing apps for it. We'll introduce you to the Windows Phone Developer Tools and walk you through the creation of a Windows Phone application that accesses a web service.

Joshua Partlow

MSDN Magazine October 2010

From Mobile to SQL Server


Hi guys........

I have a little problem.

I'm using a mobile to connect to a sql express instance.

I see my connection is very slow to open SQLConnection.

and when i try to insert the record are writed one for second.


Can someone help me to solve this issue ?????

thenk you in advance.


Cannot connect 2010 Access 2010 Excel or PowerPivot to Mobile SQL(SQL Server Compact) - SDF files

I've believe I've installed everything to read Mobile SQL .SDF files.  I've insalled Sql Server Management Studio, Sql Server 2008 R2, .NET 4.0 Framework and just about everything else I've read to see the contents of an .SDF file created for what I read directly from these product sources as this DotNet Compact Framework is the greatest new SQL stuff on the planet.  I can connect using the Management Studio and see the TABLE Stucture easy enough and I can query using some simple SQL Commands from the Management Studio but what really bugs me is if this is all so wonderful, how come I cannot connect to what the SQL Server 2008 R2 Server type "SQL Server Compact" Authentication: "SQL Server Compact Authentication in Office 2010 Access, Excel or even "WOW" PowerPivot!  I've run across a couple 3rd party .SDF Readers - one that exports to Excel such as flyhoward.com  I'm growing old with all the work around import export stuff and just want to use PowerPivot to  excersise the data......or should I use something that actually works like Tableau??

SQL Server Mobile 2005 Merge replication failing over SSL, but can browse through pocket IE.


Hi All, this system is scheduled to go live in near to a day... but i have hit an issue when switching on SSL.  Any help would be greatly appreciated.


Device Env:

Windows Mobile 5.0 + Messaging and Security Feature Pack

SQL Server Mobile 2005.


Merge replication works fine without SSL.  After running the Configure Web Sync wizzard to setup SSL merge replication no longer works.  Note i checked using pocket IE by browsing to https://mycompany.com/pub/sqlcesa30.dll?diag and all worked fine.  There was no prompt saying the cert was bad etc.


The certificate is a:

Equifax secure global ebusiness CA-1 cert.

Signature algorithm md5RSA

public key RSA(1024 bits)

thumbprint algorithm sha1


Stacktrace given is:

-  ex {"A request to send data to the computer running IIS has failed. For more information, see HRESULT."} System.Data.SqlServerCe.SqlCeException
-  Errors {System.Data.SqlServerCe.SqlCeErrorCollection} System.Data.SqlServerCe.SqlCeErrorCollection
  Count 1 Integer

I need to simulate a proxy server to test mobile device c# application.


I need to simulate a proxy server to test mobile device c# application.

Is there a way to do this? how should I do this. 

Location Server, mobile site?


Does C# have any coding to provide location service for mobile sites?

An example would be bestbuy viewing it on your mobile phone.  They use it on their weekly ad's page to pull the zip code your currently in to populate the box.  I'm just wondering if I could integrate this into our mobile site.

No such interface supported - running windows mobile phone application


I open sample project, build goes OK.
When i try to run it (or just deploy it) i get error "No such interface supported" and project does not strat.

It was working ok a day ago, i had to install VS 2008 since and this is my suspect No1.

Any ideas? Thank you.

Running on Windows 7.


SQL Server Compact v3.5 SqlCeEngine.Upgrade method not working on PocketPC 2003/Windows Mobile 2003

When trying to use the SqlCeEngine.Upgrade(string connectionString) method i get the following exception:

The Parameter is incorrect.
at System.Data.SqlServerCe.SqlCeEngine.ProcessResults()
at System.Data.SqlServerCe.SqlCeEngine.Repair()
at System.Data.SqlServerCe.SqlCeEngine.Upgrade()
at Vbi.Compact.ErbisPda.Client.Program.Main()

The same code works like a charm on a Windows Mobile 2005 device. I installed "SQL Server Compact v3.5 Core" and "SQL Server Compact v3.5 Repl" on both devices, the WCE4/Armv4 version on Pocket PC 2003 and the WCE5/Armv4i version on Windows Mobile 2005.

I am hoping someone can help me with this problem, its being a showstopper.

[edit]Please note that i am using v3.5 and not v3.5 SP1. This is because for some of our data access we use a 3rd party library that needs v3.5 without SP1. Also i didn't run across above problem when i deployed my application from Visual Studio 2008 SP1 (debugging), it does occur on a clean system with only the two mentioned SQL Server Compact cabs installed and our app.[/edit]

want to connect with remote sql server to mobile pocket pc




I am using mobile 5.0 pocket pc. i have developed one application and its running success fully. Now i want to fetch the data from remote server having sql sever 2008 or sql server 2005. here is the code for it

private void button1_Click(object sender, EventArgs e)
                SqlConnection connection = new SqlConnection("Server=servername;Initial Catalog=dbname;User ID=username;Password=password;Integrated Security=false;");
                SqlCommand command = connection.CreateCommand();
                command.CommandText = "select top 1 id from empinfo";
                label1.Text = command.ExecuteScalar().ToString();

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend