Click here to Skip to main content
15,889,992 members
Home / Discussions / Mobile
   

Mobile

 
QuestionWhy player.settings.autostart doesn't work ? Pin
sebapi31-Mar-06 23:45
sebapi31-Mar-06 23:45 
QuestionAdd Registry Key Pin
oskardiazdeleon30-Mar-06 11:58
oskardiazdeleon30-Mar-06 11:58 
QuestionTCP/IP on the 2003 Pocket PC emulator Pin
dt.lcr29-Mar-06 15:43
dt.lcr29-Mar-06 15:43 
QuestionHow to speak with the GSM Modem (HTC SDA) Pin
t-q29-Mar-06 5:36
t-q29-Mar-06 5:36 
AnswerRe: How to speak with the GSM Modem (HTC SDA) Pin
akang_cupez12-Aug-06 9:18
akang_cupez12-Aug-06 9:18 
QuestionMove and update thru RecordSet Pin
mmfdg29-Mar-06 3:17
mmfdg29-Mar-06 3:17 
QuestionGPS Auto Detection Pin
someone_blank28-Mar-06 14:56
someone_blank28-Mar-06 14:56 
QuestionProblem on displaying the dataadapter,anyone can help? Pin
drexler_kk27-Mar-06 22:10
drexler_kk27-Mar-06 22:10 
Hello everyone,I'm totally new to this .Net development. I found problem on my mobile development here using ASP.NET. I'm using MS SQL 2000 as my database,I am creating a searching function which retrieve data from my database using this mobile development.

I have solve this command with no error,but I found this problem below now at this moment. Anyone can give me some help on this please? I think this is not too difficult for you,but I really have no idea with how to solve this.

1. I don't have any idea if the dataset is load with any data inside. Normally we can test with (Messagebox.show) function in VB.NET to check if there was load with data, but for this Mobile Development,what should we used to check?
2. I need to display the data adapter to a new form,the user can see all the data by a list in a new form. And the user can go for more details by selecting any field of the data to look for the details of each row.

The following are my code,I wish can get help from someone here. Thank you so much for reading and hear from you all soon.

Private Sub SrcSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SrcSubmit.Click
Dim xname As String 'This is the username
Dim xage As String 'This is the selected age
Dim xgender As String 'This is the gender being selected
Dim ObAdapter1 As SqlDataAdapter


If Len(SrcTxtB.Text) <> "0" Then
xname = Convert.ToString(SrcTxtB.Text)
End If
If SelectionList1.Selection.Text <> "" Then
xage = Convert.ToString(SelectionList1.Selection.Text)
End If
If SelectionList2.Selection.Text <> "" Then
xgender = Convert.ToString(SelectionList2.Selection.Text)
End If

If Len(xname) > 0 And xgender = "0" And xage = "0" Then
ObAdapter1 = New SqlDataAdapter("SELECT * FROM UserPass WHERE Username='" & xname & "' and Status='1'", Obconn)

ElseIf Len(xname) > 0 And xgender <> "0" And xage = "0" Then
ObAdapter1 = New SqlDataAdapter("SELECT * FROM UserPass WHERE Username='" & xname & "' and Gender='" & xgender & "' and Status='1'", Obconn)

ElseIf Len(xname) > 0 And xgender <> "0" And xage <> "0" Then
If xage = "1" Then
ObAdapter1 = New SqlDataAdapter("SELECT * FROM UserPass WHERE Username ='" & xname & "' and Gender='" & xgender & "' and Age>17 and Age<24 and Status='1'", Obconn)
End If

ElseIf Len(xname) > 0 And xgender = "0" And xage <> "0" Then
If xage = "1" Then
ObAdapter1 = New SqlDataAdapter("SELECT * FROM UserPass WHERE Username ='" & xname & "' and Age>17 and Age<24 and Status='1'", Obconn)
End If

ElseIf Len(xname) = 0 And xgender <> "0" And xage <> "0" Then
If xage = "1" Then
ObAdapter1 = New SqlDataAdapter("SELECT * FROM UserPass WHERE Gender='" & xgender & "' and Age>17 and Age<24 and Status='1'", Obconn)
ElseIf xage = "2" Then
ObAdapter1 = New SqlDataAdapter("SELECT * FROM UserPass WHERE Gender='" & xgender & "' and Age>23 and Age<30 and Status='1'", Obconn)
End If

ElseIf Len(xname) = 0 And xgender <> "0" And xage = "0" Then
ObAdapter1 = New SqlDataAdapter("SELECT * FROM UserPass WHERE Gender='" & xgender & "' and Status='1'", Obconn)

ElseIf Len(xname) = 0 And xgender = "0" And xage <> "0" Then
If xage = "1" Then
ObAdapter1 = New SqlDataAdapter("SELECT * FROM UserPass WHERE Age>17 and Age<24 and Status='1'", Obconn)
End If
End If

Try
Obconn.Open()
ObAdapter1.Fill(DS, "SrcResult")
List3.DataSource = DS.Tables("SrcResult").DefaultView
ActiveForm = SearchResult.Form

Catch ex As Exception

End Try
Obconn.Close
End Sub
QuestionEmbedded CE C++ tutorial -- for dummies. Pin
Greg Barnes27-Mar-06 7:48
Greg Barnes27-Mar-06 7:48 
Questionbuild nk.bin problem Pin
hakanaktan26-Mar-06 21:21
hakanaktan26-Mar-06 21:21 
QuestionDoes IWMPPlayer work in C# ?? Pin
sebapi26-Mar-06 3:15
sebapi26-Mar-06 3:15 
QuestionCollege Project Pin
Osama12325-Mar-06 19:03
Osama12325-Mar-06 19:03 
QuestionOT: OBEX push, but on linux Pin
CaesarCZ25-Mar-06 12:44
CaesarCZ25-Mar-06 12:44 
Questionhelp needed Pin
nidheeshkayal22-Mar-06 0:25
nidheeshkayal22-Mar-06 0:25 
AnswerRe: help needed Pin
beniwtv4-Apr-06 23:01
beniwtv4-Apr-06 23:01 
GeneralRe: help needed Pin
nidheeshkayal5-Apr-06 18:18
nidheeshkayal5-Apr-06 18:18 
Question"This program excists. overwrite it?" - avert Pin
Imperial-X21-Mar-06 21:48
Imperial-X21-Mar-06 21:48 
AnswerRe: "This program excists. overwrite it?" - avert Pin
beniwtv4-Apr-06 23:05
beniwtv4-Apr-06 23:05 
QuestionHow to create on-screen keyboard on PocketPC Pin
trail20-Mar-06 0:55
trail20-Mar-06 0:55 
AnswerRe: How to create on-screen keyboard on PocketPC Pin
beniwtv4-Apr-06 22:52
beniwtv4-Apr-06 22:52 
Questionterminal service on pda Pin
contact ajo19-Mar-06 20:24
contact ajo19-Mar-06 20:24 
Questionobjectlist templates in Mobile Web Applications Pin
TheEagle19-Mar-06 18:18
TheEagle19-Mar-06 18:18 
QuestionPhone cannot access mobile web app anymore...why??? Pin
lnong17-Mar-06 11:17
lnong17-Mar-06 11:17 
QuestionReading in data from GPS Pin
prashantkgupta16-Mar-06 8:59
prashantkgupta16-Mar-06 8:59 
QuestionMP3 player on Win CE Pin
houari_id15-Mar-06 12:08
houari_id15-Mar-06 12:08 

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.