Home » 2012 (Page 4)

Archive for 2012

Record Count Using Stored Procedure

Imports System.Data.SqlClient Partial Class mb_app_promo Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) _ Handles Me.Load G1.Text = “500” Dim connString As String connString = ConfigurationManager.ConnectionStrings(“myConnString”).ToString Dim conn As New SqlConnection(connString) Try conn.Open() Dim cmd As New SqlCommand(“myStoredProcedure”, conn) Dim count As Integer = CInt(cmd.ExecuteScalar()) If count >= 500 Then Goal1.Text […]

Resize image before upload

Markup Page <div id=”FileUpd1″ runat=”server” > Default: <asp:FileUpload ID=”ImgUpload1″ runat=”server” /> <asp:Button ID=”Btn1″ runat=”server” Text=”Submit ” CssClass=”btnSubmit” CausesValidation=”true”/> Code Behind – Click to read more… Imports System.IO Imports System.Web.UI Imports System.Data.Sql Imports System.Data.SqlClient Imports System.Drawing Imports System.Drawing.Imaging Protected Sub Btn1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Btn1.Click ‘define variable Dim adPhotoName As String = […]

Multiple file upload – VB.NET

Code behind only Imports System.IO Imports System.Web.UI Imports System.Data.Sql Imports System.Data.SqlClient ‘define public classes/share them on page Public ImgUpConf1 As String ‘displays img after success. upload Public ImgUpConf2 As String ‘ ” Public BadImgFormat As String ‘passing banned file ext msg to page Public NoImage As String = “no_image.jpg” ‘default image no image jpg Public […]