Click here to Skip to main content
15,920,650 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionHow to add application to Windows Scheduler? Pin
.NetRams13-Feb-06 1:32
.NetRams13-Feb-06 1:32 
AnswerRe: How to add application to Windows Scheduler? Pin
Tim Carmichael13-Feb-06 3:14
Tim Carmichael13-Feb-06 3:14 
AnswerRe: How to add application to Windows Scheduler? Pin
Dave Kreskowiak14-Feb-06 7:56
mveDave Kreskowiak14-Feb-06 7:56 
QuestionRDA Help... Pin
UniBond13-Feb-06 1:22
UniBond13-Feb-06 1:22 
QuestionScheduler Application in VB.Net. Pin
.NetRams12-Feb-06 23:45
.NetRams12-Feb-06 23:45 
AnswerRe: Scheduler Application in VB.Net. Pin
mgilmore13-Feb-06 13:43
mgilmore13-Feb-06 13:43 
QuestionHow to upload webpages to the site Pin
Sgn_Flex12-Feb-06 22:27
Sgn_Flex12-Feb-06 22:27 
AnswerRe: How to upload webpages to the site Pin
Guffa13-Feb-06 0:20
Guffa13-Feb-06 0:20 
GeneralRe: How to upload webpages to the site Pin
Sgn_Flex13-Feb-06 0:44
Sgn_Flex13-Feb-06 0:44 
GeneralRe: How to upload webpages to the site Pin
Dave Kreskowiak13-Feb-06 5:52
mveDave Kreskowiak13-Feb-06 5:52 
QuestionBIOS changes Pin
rzvme12-Feb-06 22:07
rzvme12-Feb-06 22:07 
AnswerRe: BIOS changes Pin
Dave Kreskowiak13-Feb-06 5:50
mveDave Kreskowiak13-Feb-06 5:50 
QuestionHow to Create typeconverter dynamically by reflection to use in a PropertyGrid? Pin
Mohamed Ali Jinnah12-Feb-06 21:29
Mohamed Ali Jinnah12-Feb-06 21:29 
AnswerRe: How to Create typeconverter dynamically by reflection to use in a PropertyGrid? Pin
J4amieC12-Feb-06 23:28
J4amieC12-Feb-06 23:28 
GeneralRe: How to Create typeconverter dynamically by reflection to use in a PropertyGrid? Pin
Mohamed Ali Jinnah13-Feb-06 0:05
Mohamed Ali Jinnah13-Feb-06 0:05 
GeneralRe: How to Create typeconverter dynamically by reflection to use in a PropertyGrid? Pin
Danilo Corallo10-Apr-06 3:09
Danilo Corallo10-Apr-06 3:09 
QuestionRegarding datagrid control (very urgent) Pin
nagalakshmibasireddy12-Feb-06 21:21
nagalakshmibasireddy12-Feb-06 21:21 
Questionremote connection error! Pin
pandapatin12-Feb-06 20:19
pandapatin12-Feb-06 20:19 
AnswerRe: remote connection error! Pin
Dave Kreskowiak14-Feb-06 8:03
mveDave Kreskowiak14-Feb-06 8:03 
Questionencountring a substring from a string inputted in a textbox Pin
anurag11oct12-Feb-06 18:49
anurag11oct12-Feb-06 18:49 
AnswerRe: encountring a substring from a string inputted in a textbox Pin
Colin Angus Mackay12-Feb-06 20:28
Colin Angus Mackay12-Feb-06 20:28 
QuestionHow to make a Web Browser based on these criterias? Pin
Iftikhar Ali12-Feb-06 17:38
Iftikhar Ali12-Feb-06 17:38 
AnswerRe: How to make a Web Browser based on these criterias? Pin
Dave Kreskowiak13-Feb-06 5:56
mveDave Kreskowiak13-Feb-06 5:56 
AnswerRe: How to make a Web Browser based on these criterias? Pin
Iftikhar Ali13-Feb-06 19:55
Iftikhar Ali13-Feb-06 19:55 
QuestionProblem migrating from VB to VB.NET Pin
drexler_kk12-Feb-06 17:38
drexler_kk12-Feb-06 17:38 
I'm beginner for VB.NET. This is my code that migrating from VB to VB.NET. I'm selecting a group of data in the same data table from my MSSQL database to a dataset,and I wish to process the data row by row inside the dataset. There is no error shown when executed,but there is not messagebox pop-up to show the OriginatingAddress when I try to test the result.

Anyone can give me a solution about this please?

Private Sub Spam_Now()
Dim conStr1 As String
Dim con1 As SqlConnection
Dim reader As IDataReader
Dim sql1 As String
Dim command As SqlCommand

Try
con1 = New SqlConnection("server=(local);database=Jacson;integrated security=true;")
sql1 = "SELECT TOP 10 * FROM TT_Member WHERE Reminder ='0' AND Status ='1'"
command = New SqlCommand(sql1, con1)
con1.Open()
reader = command.ExecuteReader
If Not reader.Read() Then
Label1.Text = "Finished - " & DateTime.Now
Else
Do
Label1.Text = "Spamming - " & DateTime.Now
OriginatingAddress = reader.GetValue("Mobile_No")
MessageBox.Show("This is my>>" & OriginatingAddress & "<<") '<<<<
If OriginatingAddress.Substring(0, 3) = "601" Then
Telco = 2
ElseIf OriginatingAddress.Substring(0, 3) = "013" Then
Telco = 3
ElseIf OriginatingAddress.Substring(0, 3) = "016" Then
Telco = 6
ElseIf OriginatingAddress.Substring(0, 3) = "019" Then
Telco = 9
End If

Reminder_Msg = "Free Msg. Subscription Reminder.Fee:Auto renewal datedate,unless cancelled. To cancel, send STOP TT to 32132."
MT_Msg = Reminder_Msg
MT_Msg = Replace(MT_Msg, "datedate", Renewal_Date3)

Loop Until Not reader.Read()
con1.Close()

End If
Catch ex As Exception

End Try

End Sub

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.