Advertisement
Advertisement
| 08.07.2008 at 07:01AM PDT, ID: 23629302 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: |
Imports System.Data
Imports System.Data.SqlClient
Imports System.Web.UI.WebControls
Imports System.Configuration
Imports System.Web.Security
Partial Public Class Login
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Encrypt("DataProtectionConfigurationProvider")
End Sub
Public Sub EncryptConnStr(ByVal protectionProvider As String)
'---open the web.config file
Dim config As Configuration = _
ConfigurationManager.OpenWebConfiguration( _
Request.ApplicationPath)
'---indicate the section to protect
Dim section As ConfigurationSection = _
config.Sections("connectionStrings")
'---specify the protection provider
section.SectionInformation.ProtectSection(protectionProvider)
'---Apple the protection and update
config.Save()
End Sub
Public Sub DecryptConnStr()
Dim config As Configuration = _
ConfigurationManager.OpenWebConfiguration( _
Request.ApplicationPath)
Dim section As ConfigurationSection = _
config.Sections("connectionStrings")
section.SectionInformation.UnProtectSection()
config.Save()
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
'Add Job Titles Data to Database
Dim DBConn As New SqlConnection("UID=MyUserID;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Kiosks;Data Source=DATABASE;Packet Size=4096;")
'Dim DBConn As New SqlConnection("Data Source=DATABASE;Initial Catalog=Kiosks;")
Dim DBCmd As New SqlCommand
Dim DBAdap As New SqlDataAdapter
DBConn.Open()
Dim strClientIP As String = ""
strClientIP = HttpContext.Current.Request.ServerVariables("REMOTE_ADDR") 'Request.ServerVariables("REMOTE_ADDR")
'strClientIP = Request.UserHostAddress()
Response.Write(strClientIP)
Try
'Add Insert Statement
DBCmd = New SqlCommand("INSERT INTO Users (FName,LName,PIN,KioskIP,uDate) VALUES (@FName,@LName,@PIN,@KioskIP,getdate())", DBConn)
'Add Database Parameters
DBCmd.Parameters.Add("@FName", SqlDbType.VarChar).Value = txtFName.Text
DBCmd.Parameters.Add("@LName", SqlDbType.VarChar).Value = txtLName.Text
DBCmd.Parameters.Add("@PIN", SqlDbType.Int).Value = intPIN.Text
DBCmd.Parameters.Add("@KioskIP", SqlDbType.VarChar).Value = strClientIP 'How to determine the IP?
'DBCmd.Parameters.Add("@cbSundays", SqlDbType.VarChar).Value = cbSundays.Checked 'Just an example of a checkbox
'DBCmd.Parameters.Add("@WorkersComp", SqlDbType.VarChar).Value = ddlJobDescriptionPrim.SelectedValue ' Example of DropDownList
DBCmd.ExecuteNonQuery()
Catch exp As Exception
Response.Write(exp)
End Try
'Close Database connection
'and Dispose Database objects
DBCmd.Dispose()
DBAdap.Dispose()
DBConn.Close()
DBConn = Nothing
End Sub
End Class
|