DepositData http://Depositdata.com Take Control of your website Mon, 27 Feb 2012 20:23:36 +0000 en hourly 1 http://wordpress.org/?v=3.2.1 Ms-sql detect email address http://Depositdata.com/?p=1337 http://Depositdata.com/?p=1337#comments Mon, 27 Feb 2012 20:23:36 +0000 seven http://Depositdata.com/?p=1337 1 AND LEN(LTRIM(RTRIM(@EmailAddress ))) - LEN(REPLACE(LTRIM(RTRIM(@EmailAddress)),'@','')) = 1 AND CHARINDEX('.',REVERSE(LTRIM(RTRIM(@EmailAddress)))) >= 3 AND … ]]> Declare @EmailAddress as varchar(max)
set @EmailAddress = 'anthonyp@alpha.com'
IF (
CHARINDEX(' ',LTRIM(RTRIM(@EmailAddress))) = ''
AND LEFT(LTRIM(@EmailAddress),1) <> '@'
AND RIGHT(RTRIM(@EmailAddress),1) <> '.'
AND CHARINDEX('.',@EmailAddress ,CHARINDEX('@',@EmailAddress)) - CHARINDEX('@',@EmailAddress ) > 1
AND LEN(LTRIM(RTRIM(@EmailAddress ))) - LEN(REPLACE(LTRIM(RTRIM(@EmailAddress)),'@','')) = 1
AND CHARINDEX('.',REVERSE(LTRIM(RTRIM(@EmailAddress)))) >= 3
AND (CHARINDEX('.@',@EmailAddress ) = 0 AND CHARINDEX('..',@EmailAddress ) = 0)
)
print 'valid email address'
ELSE
print 'not valid'

]]> http://Depositdata.com/?feed=rss2&p=1337 0 How to VB.NET String.Format http://Depositdata.com/?p=1325 http://Depositdata.com/?p=1325#comments Mon, 05 Dec 2011 20:55:31 +0000 seven http://Depositdata.com/?p=1325 How to string format money in a sqlreader.

Dim dNum1 As Double
dNum1 = sqlDR(“Cost”)
String.Format(“{0:c}”, dNum1)
]]> http://Depositdata.com/?feed=rss2&p=1325 0 ASP.NET Image Slider http://Depositdata.com/?p=1302 http://Depositdata.com/?p=1302#comments Tue, 20 Sep 2011 19:32:46 +0000 seven http://Depositdata.com/?p=1302 ]]> I took this reference from DYNAMIC DRIVE And what i like to do is take there scripts and modify it. Make it more user friendly.

jQuery image galleries and sliders are very common on portfolio sites and are also useful for any other type of site for displaying images and photos. Also, provide a good user experience and make viewing images more pleasant and intuitive on your website. With the advent of powerful JavaScript frameworks like jQuery, Prototype, Mootools etc., the quality of JavaScript based image galleries and slideshows have improved dramatically.

Now I converted this into asp.net file. you can add any image in a folder and the slider will dyanmically read all images in that folder. For this example I called the folder Fimages.

View Example. Download – ASP.net Slider (79)

Source code and C# code coming soon.
For now in your page (instructions)
1. ADD to the top header

<%@ Register TagPrefix=”Slider” TagName=”fadepg” Src=”~/control/homepageFade.ascx” %>

2. reference your Jquery and dynamic scripts Fadeslideshow.js file in your header.

<script type=”text/javascript” src=”jquery/1.4.2/jquery-1.4.2.min.js”></script>
<script type=”text/javascript” src=”js/fadeslideshow.js”>

3. In your body tag after the

tag call your usercontrol.
<Slider:fadepg runat=”server” id=”fadeshow21″ />

this example standard size is 1021px by 368px.
You can download the source code and make size changes yourself. Please add a comment if any changes or you find a better way. Thanks.

]]> http://Depositdata.com/?feed=rss2&p=1302 0 How to Override Inline Styles with Style Sheet http://Depositdata.com/?p=1264 http://Depositdata.com/?p=1264#comments Mon, 08 Aug 2011 17:17:35 +0000 seven http://fun.depositdata.com/?p=1264 ]]> For the first time I ran into an instance where I could not get to the inline style code. After research the best way but not good practice is to use my sample below.

This works in all browsers except IE7, but of course.

<div style=”height: 15px; width: 20px; font-weight: bold;”>text here</div>
———————————————————————
overide below *.testout[style]
{font-weight:normal !important;

}

For IE 7 Only works using the body.
for example

body .testout
/* Hack for IE 7 Only */
{
height: 12px !important;

}

]]> http://Depositdata.com/?feed=rss2&p=1264 8 HttpBrowserCapabilities Class http://Depositdata.com/?p=1254 http://Depositdata.com/?p=1254#comments Fri, 05 Aug 2011 20:21:34 +0000 seven http://fun.depositdata.com/?p=1254 ]]> You can use this function in your vb or C# file for many different properties. for example

VB
Dim browser As System.Web.HttpBrowserCapabilities = Request.Browser
Dim browsername As String = browser.Browser
If browsername = “Firefox” Or browsername = “IE” Then
Else
End If

C#
System.Web.HttpBrowserCapabilities browser = Request.Browser;
string browsername = browser.Browser;
if (browsername == “Firefox” | browsername == “IE”) {
} else {
}

For more information on how to use this class click here

]]> http://Depositdata.com/?feed=rss2&p=1254 0 xhtml 2.0 abandoned http://Depositdata.com/?p=1230 http://Depositdata.com/?p=1230#comments Thu, 04 Aug 2011 19:30:33 +0000 seven http://fun.depositdata.com/?p=1230 During the time that HTML5 was in development, so was XHTML 2.0. that project has since been abandoned to allow focus on HTML5.

]]> http://Depositdata.com/?feed=rss2&p=1230 0