Click here to Skip to main content
15,897,519 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionmoving files to UNC share Pin
Keith Andersch15-Jun-07 6:26
Keith Andersch15-Jun-07 6:26 
AnswerRe: moving files to UNC share Pin
Keith Andersch15-Jun-07 9:33
Keith Andersch15-Jun-07 9:33 
Questioncannot create activex component .. Pin
dhanis15-Jun-07 6:12
dhanis15-Jun-07 6:12 
QuestionGet Web Service URL Pin
mail57235215-Jun-07 5:55
mail57235215-Jun-07 5:55 
QuestionAvailablity Calendar Controls Needed Pin
Brendan Vogt15-Jun-07 4:43
Brendan Vogt15-Jun-07 4:43 
AnswerRe: Availablity Calendar Controls Needed Pin
nareshss15-Jun-07 21:04
nareshss15-Jun-07 21:04 
QuestionHELP Please!! Datagrid with update function!!!!! Pin
papy-boom15-Jun-07 4:20
papy-boom15-Jun-07 4:20 
QuestionPage_Load calling Sub [modified] Pin
kallileo15-Jun-07 3:44
kallileo15-Jun-07 3:44 
I do initialize some controls on Page_Load.

Sub Page_Load(ByVal Sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
SQLconn.Open()
Dim SelectCmd1 As New SqlCommand("SP1", SQLconn)
SelectCmd1.CommandType = CommandType.StoredProcedure
Dim result1 As Integer
Dim myDataReader1 As SqlDataReader
myDataReader1 = SelectCmd1.ExecuteReader()
myDataReader1.Read()
result1 = myDataReader1.GetInt32(0)
SQLconn.Close()

ChangeButton(result1)
End Sub

Sub ChangeButton(ByVal Status As Integer)
If Status = -1 Then
Label1.Text = "ON"
OnOff1.Style.Value = "background-image: url(../ImgContr/1.png);"
Else
Label1.Text = "OFF"
OnOff1.Style.Value = "background-image: url(../ImgContr/2.png);"
End If
End Sub

I moved the code from Page_Load to MyRefresh bc I want to call this code fom other events too:

Sub Page_Load()

If Not Page.IsPostBack Then
MyRefresh()
End If

End Sub


Sub MyRefresh()
SQLconn.Open()
Dim SelectCmd1 As New SqlCommand("SP1", SQLconn)
SelectCmd1.CommandType = CommandType.StoredProcedure
Dim result1 As Integer
Dim myDataReader1 As SqlDataReader
myDataReader1 = SelectCmd1.ExecuteReader()
myDataReader1.Read()
result1 = myDataReader1.GetInt32(0)
SQLconn.Close()

ChangeButton(result1)
End Sub

I don't get any errors but the controls get no values from the database. Something is missing but I don't know what.D'Oh! | :doh:

Thanks



-- modified at 10:05 Friday 15th June, 2007
AnswerRe: Page_Load calling Sub Pin
kubben15-Jun-07 3:49
kubben15-Jun-07 3:49 
GeneralRe: Page_Load calling Sub Pin
kallileo15-Jun-07 4:03
kallileo15-Jun-07 4:03 
GeneralRe: Page_Load calling Sub Pin
kubben15-Jun-07 4:15
kubben15-Jun-07 4:15 
GeneralRe: Page_Load calling Sub Pin
kallileo15-Jun-07 5:15
kallileo15-Jun-07 5:15 
GeneralRe: Page_Load calling Sub Pin
kubben15-Jun-07 5:19
kubben15-Jun-07 5:19 
GeneralRe: Page_Load calling Sub Pin
kallileo15-Jun-07 5:35
kallileo15-Jun-07 5:35 
QuestionHttpContext.Request.Url Problem Pin
Jkirt15-Jun-07 3:40
Jkirt15-Jun-07 3:40 
AnswerRe: HttpContext.Request.Url Problem Pin
kubben15-Jun-07 3:51
kubben15-Jun-07 3:51 
GeneralRe: HttpContext.Request.Url Problem Pin
Jkirt15-Jun-07 4:01
Jkirt15-Jun-07 4:01 
GeneralRe: HttpContext.Request.Url Problem Pin
kubben15-Jun-07 4:12
kubben15-Jun-07 4:12 
GeneralRe: HttpContext.Request.Url Problem Pin
Jkirt15-Jun-07 4:59
Jkirt15-Jun-07 4:59 
GeneralRe: HttpContext.Request.Url Problem Pin
kubben15-Jun-07 5:13
kubben15-Jun-07 5:13 
GeneralRe: HttpContext.Request.Url Problem Pin
Jkirt15-Jun-07 5:52
Jkirt15-Jun-07 5:52 
GeneralRe: HttpContext.Request.Url Problem Pin
kubben15-Jun-07 6:02
kubben15-Jun-07 6:02 
GeneralRe: HttpContext.Request.Url Problem Pin
Jkirt15-Jun-07 6:11
Jkirt15-Jun-07 6:11 
GeneralRe: HttpContext.Request.Url Problem Pin
kubben15-Jun-07 6:03
kubben15-Jun-07 6:03 
GeneralRe: HttpContext.Request.Url Problem Pin
Jkirt15-Jun-07 6:18
Jkirt15-Jun-07 6:18 

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.