Click here to Skip to main content
15,925,602 members
Home / Discussions / Mobile
   

Mobile

 
AnswerRe: Internet connection on win mobile 5.0 emulator Pin
PavanPareta5-Mar-09 17:40
PavanPareta5-Mar-09 17:40 
AnswerRe: Internet connection on win mobile 5.0 emulator Pin
ankita patel5-Mar-09 18:58
ankita patel5-Mar-09 18:58 
AnswerRe: Internet connection on win mobile 5.0 emulator Pin
~Khatri Mitesh~7-Mar-09 0:45
~Khatri Mitesh~7-Mar-09 0:45 
QuestionHow can i access mobile calender from PC side? Pin
Member 40849644-Mar-09 3:08
Member 40849644-Mar-09 3:08 
AnswerRe: How can i access mobile calender from PC side? Pin
Joel Ivory Johnson5-Mar-09 7:51
professionalJoel Ivory Johnson5-Mar-09 7:51 
QuestionPassing multiple parameters to update query in C# Pin
Deepali Khalkar4-Mar-09 1:25
Deepali Khalkar4-Mar-09 1:25 
AnswerRe: Passing multiple parameters to update query in C# Pin
Rupesh Kumar Swami4-Mar-09 2:25
Rupesh Kumar Swami4-Mar-09 2:25 
QuestionWriting SQL statement in C# Pin
Deepali Khalkar3-Mar-09 6:30
Deepali Khalkar3-Mar-09 6:30 
I am developing an application on Win mobile 5.0 emulator in C# using Visual studio 2008.
Can anyone let me know how to write an SQL statement in C# which returns the row count?
Is the parameter required to store the count value?
I will be greatefull if someone helps with the code snippet for the same.

I have tried the following code for the select statement(the select stmt does not return the row count value) and is working fine.

String uname_in='abc';
SqlCeConnection conn;
SqlCeCommand comm;
SqlCeDataAdapter adap = new SqlCeDataAdapter();
String connstring = @"Data Source=Program Files\signup\signupdb.sdf";
conn = new SqlCeConnection(connstring);
conn.Open();
comm = new SqlCeCommand();
comm.Connection = conn;
comm.CommandText = "select * from signuptbl where username =@uname";
SqlCeParameter para = new SqlCeParameter();
para.ParameterName = "@uname";
para.Value = uname_in;
comm.Parameters.Add(para);
adap.SelectCommand = comm;
System.Data.DataTable dt = new DataTable();
ap.Fill(dt);
psw1 = dt.Rows[0][1].ToString();

What changes should be done in the above code for writing a select stmt the return the number of rows selected?

Thanks in advance.

Smile | :)
AnswerRe: Writing SQL statement in C# Pin
PavanPareta3-Mar-09 23:31
PavanPareta3-Mar-09 23:31 
AnswerRe: Writing SQL statement in C# Pin
ziwez06-Mar-09 11:54
ziwez06-Mar-09 11:54 
QuestionUnable to load bitmap with Compact Framework Pin
rudy.net2-Mar-09 8:42
rudy.net2-Mar-09 8:42 
AnswerRe: Unable to load bitmap with Compact Framework Pin
Joel Ivory Johnson5-Mar-09 7:50
professionalJoel Ivory Johnson5-Mar-09 7:50 
GeneralRe: Unable to load bitmap with Compact Framework Pin
rudy.net5-Mar-09 8:15
rudy.net5-Mar-09 8:15 
QuestionPocket PC today item code in VB .Net Pin
Nirmit Kavaiya27-Feb-09 1:47
professionalNirmit Kavaiya27-Feb-09 1:47 
AnswerRe: Pocket PC today item code in VB .Net Pin
Joel Ivory Johnson1-Mar-09 3:44
professionalJoel Ivory Johnson1-Mar-09 3:44 
QuestionDMProcessConfigXML API returns error code E_INVALIDARG Pin
Mohamed Shakir25-Feb-09 23:56
Mohamed Shakir25-Feb-09 23:56 
AnswerRe: DMProcessConfigXML API returns error code E_INVALIDARG Pin
Manvendra Kumar Sah26-Feb-09 18:12
Manvendra Kumar Sah26-Feb-09 18:12 
QuestionGet All Applications information in the given smartphone programatically using Win32 Pin
hemlat25-Feb-09 19:56
hemlat25-Feb-09 19:56 
Questionaccessing data from database on Win mobile 5.0 emulator Pin
Deepali Khalkar24-Feb-09 1:25
Deepali Khalkar24-Feb-09 1:25 
AnswerRe: accessing data from database on Win mobile 5.0 emulator Pin
PavanPareta2-Mar-09 19:31
PavanPareta2-Mar-09 19:31 
QuestionError in connecting device emulator to GPRS Pin
ReachMe@CodeProject23-Feb-09 23:22
ReachMe@CodeProject23-Feb-09 23:22 
QuestionHow to repaint the whole screen? Pin
sushilange18-Feb-09 23:30
sushilange18-Feb-09 23:30 
AnswerRe: How to repaint the whole screen? Pin
Joel Ivory Johnson19-Feb-09 10:52
professionalJoel Ivory Johnson19-Feb-09 10:52 
GeneralRe: How to repaint the whole screen? Pin
sushilange19-Feb-09 11:15
sushilange19-Feb-09 11:15 
GeneralRe: How to repaint the whole screen? Pin
Dr. William J. Blanke21-Feb-09 15:48
Dr. William J. Blanke21-Feb-09 15:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.