Convert Inches To Feet/inches

Aug 5, 2004

Has anyone attempted to convert in TSQL inches to Feet and inches. For example take 74 inches and convert to 6ft 2 inches? I was thinking about a case but that seems a little cumbersome

View 1 Replies


ADVERTISEMENT

Convert Decimal Value Of Persons Height Into Feet/inches

Sep 3, 2007

given HeightInches decimal (18, 0))
and

INSERT INTO PatientVisits (PatientID,HeightInches)

select '1234-12', '68.5' -- would like to convert 68.5 to 5' 8 1/2"
how would I extract the value in a select statement of '68.5' to display in feet and inches rather than a decimal value?


Thank you!
Greg

View 7 Replies View Related

Change Ruler To Inches

Mar 25, 2008

Hi, I was just wondering if anybody knows how to change the format of the ruler in layout view so that it measures in inches? (mine currently measures in centimetres)

Also, does anyone know how to change the default currency on reports to £ instead of $?

Thanks,

Ben

View 1 Replies View Related

Deployed Report Only Showing 2 Inches On Web Page With FireFox

Feb 4, 2008

When I deploy a report, and then browse to it with FireFox, I only see 2 inces of the report. I can scroll through the entire report, but only see the 2 inch window's worth at any time.

Its like the html element the report gets put into has a hard coded height, and doesnt auto size to show the eintire report.

It works fine with IE, but we are a FireFox shop.

Anyone know how to fix this?

View 1 Replies View Related

SIMPLE Command To Convert String To Number? Not CAST Or CONVERT.

Aug 15, 2006

Dear Experts,Ok, I hate to ask such a seemingly dumb question, but I'vealready spent far too much time on this. More that Iwould care to admit.In Sql server, how do I simply change a character into a number??????In Oracle, it is:select to_number(20.55)from dualTO_NUMBER(20.55)----------------20.55And we are on with our lives.In sql server, using the Northwinds database:SELECTr.regionid,STR(r.regionid,7,2) as a_string,CONVERT(numeric, STR(r.regionid,7,2)) as a_number,cast ( STR(r.regionid) as int ) as cast_to_numberFROM REGION R1 1.00112 2.00223 3.00334 4.0044SELECTr.regionid,STR(r.regionid,7,2) as a_string,CONVERT(numeric, STR(r.regionid,7,2) ) as a_number,cast (STR(r.regionid,7,2) as numeric ) as cast_to_numberFROM REGION R1 1.00112 2.00223 3.00334 4.0044Str converts from number to string in one motion.Isn't there a simple function in Sql Server to convertfrom string to number?What is the secret?Thanks

View 4 Replies View Related

Select Convert(varchar(16), Getdate(), 101)+LEFT(REPLACE(convert(varchar, Getdate(), 108), ':', ''),4)

Sep 26, 2007



select convert(varchar(16), getdate(), 101)+LEFT(REPLACE(convert(varchar, getdate(), 108), ':', ''),4)

From above query I get

mmddyyyyhhmm

but it' s yyyy and hour can not be separated

04/12/200702:05

How can I separated the year and hour ?

Thanks
Daniel

View 2 Replies View Related

Convert Mdf To Mdb

Jul 29, 2007

hi all,
I'm using visual web developer and created a project with a mdf data file. how can I convert this file to MS ACCESS mdb file?
 Thanks

View 3 Replies View Related

Convert .MDF To .bak

Oct 3, 2007

hi friends i am using vwd 2005 i created a project now i want to upload it on the server, but i want which database i used in the database convert it into .bak file for upload it on the server how i convert it, i don't have MS SQL SERVER 2005 or any except vwd 2005.

View 1 Replies View Related

Convert

Nov 1, 2007

how to convert msaccess 2003 data to sqlserver 2005

View 1 Replies View Related

How To Convert?

Jan 29, 2008

Hi all,
 
  How to convert varchar value to int in SQL Server2000?
  For example i'm having the varchar value '1,2,3,4'
  i want to convert this to 1,2,3,4 that is i want to remove single quote (') at the start and end of the varchar value,
  how to do this?
 
Thanks!

View 5 Replies View Related

Help Me Convert This.

Mar 6, 2008

 Hello! I need help to change this to @@Identity..Thanks!     protected void Button2_Click(object sender, EventArgs e)    {       
SqlConnection con = new
SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ThesisConnectionString"].ToString());        con.Open();       SqlCommand com1 = new SqlCommand();        com1.Connection = con;        com1.CommandText = "Insert into TransactionHeader values ('" +  DateTime.Now + "', '"            + DropDownList1.SelectedValue + "', '"            + TextBox1.Text + "', '"            + TextBox4.Text + "', '"            + TextBox9.Text + "', '"            + TextBox11.Text + "', '"            + TextBox12.Text + "');select scope_identity() as returnidentity";            string xyz = Convert.ToString(com1.ExecuteScalar());                               DataTable dt = (DataTable)Session["shoppingCart"];        for (int i = 0; i <= dt.Rows.Count - 1; i++)        {            String WasteType = dt.Rows[i][0].ToString();            double Volume = double.Parse(dt.Rows[i][1].ToString());            double Fees = double.Parse(dt.Rows[i][2].ToString());            double total = Volume * Fees;            SqlCommand com = new SqlCommand();            com.Connection = con;            com.CommandText = "Insert into TransactionDetail values ('" + xyz + "', '"                + WasteType + "', '"                + Volume + "', '"                + total + "')";            com.ExecuteNonQuery();            ClientScript.RegisterStartupScript(GetType(), "save", "alert('Record Saved');", true);        }                                 }  

View 2 Replies View Related

Convert() Help...

May 24, 2004

How can I convert a date to MMDDYY with Convert()?

View 3 Replies View Related

How To Convert This?

Jun 18, 2004

Hi, I am new to Sql.

My question is how to convert nvarchar like this "Wed Jun 16 19:14:23 2004 GMT" to standard datetime format?


Thanks!

View 2 Replies View Related

Convert

Nov 15, 2001

Hi,

Can anyone tell me, how can I get the date format in YYYYMMDDHHMISS format.
For Ex: select convert(char(12),getdate(),112) gives me the result as
'20011115'. Now, how can I get the the result something like '20011115110020'?

View 3 Replies View Related

Convert From Hex

May 24, 2001

If I do a query from SQL 7.0 and get the result "10" which is a hex value (0x0A), how do I convert this using something like convert or cast to show "a"
Is there anywhere that I can look for help? I can get it to show 0x0A using cast, but that is not what I want. I want a hex number without 0X0 in front of A. The A I can convert using something like Lower(A)

Thank you.

View 1 Replies View Related

Convert

Oct 11, 2001

Hi, I am trying to convert 2 columns from varchar(255) to datetime, the format of the data in the columns is '02/02/2001', and 1 column from varchar(255) to money, the format of the data in this column is '12,340.00'.

When I run : select convert(datetime, Col004), convert(datetime, Col005), convert(money, Col007) from table1

I get a result upto 59,996 rows then get the error:

Syntax error converting datetime from character string.

Any help would be appreciated, I have to convert 4 tables with, 722834, 1113978, 115489 and 121983 rows respectivly.

View 3 Replies View Related

Convert

Jun 2, 1999

Is there a way to install MS SQL 6.5 twice on the same server? I would like to install SQL into the following dorectories D:MSSQL and D:MSSQL2. Any help would be appreciated.

View 5 Replies View Related

Convert To T-SQL

Sep 24, 2004

can anybody convert this to T-SQl :

Select decode(trunc((d_vst_btcdte - nvl(n_per_birth,d_vst_btcdte))/10000,0),0,'no DOB',
14,'14-16',15,'14-16',16,'14-16',
17,'17-20',18,'17-20',19,'17-20',20,'17-20',
21,'21-25',22,'21-25',23,'21-25',24,'21-25',25,'21-25',
26,'26-30',27,'26-30',28,'26-30',29,'26-30',30,'26-30',
31,'31-35',32,'31-35',33,'31-35',34,'31-35',35,'31-35',
36,'36-40',37,'36-40',38,'36-40',39,'36-40',40,'36-40',
41,'41-45',42,'41-45',43,'41-45',44,'41-45',45,'41-45',
46,'46-50',47,'46-50',48,'46-50',49,'46-50',50,'46-50',
51,'51-55',52,'51-55',53,'51-55',54,'51-55',55,'51-55',
56,'56-60',57,'56-60',58,'56-60',59,'56-60',60,'56-60',
61,'61-65',62,'61-65',63,'61-65',64,'61-65',65,'61-65',
66,'66-70',67,'66-70',68,'66-70',69,'66-70',70,'66-70',
'71+') AGE

View 1 Replies View Related

Convert To T-SQL

Oct 12, 2004

Can anybody convert to T-SQL;
select distinct to_char(sysdate,'FMDAY, MONTH DD, YYYY HH:FMMIAM') TODAY
, d_aaa_insthdg CNTRHD
, decode(trunc((d_vst_btcdte - nvl(n_per_birth,d_vst_btcdte))/10000,0),0,'no DOB',
14,'14-16',15,'14-16',16,'14-16',
17,'17-20',18,'17-20',19,'17-20',20,'17-20',
21,'21-25',22,'21-25',23,'21-25',24,'21-25',25,'21-25',
26,'26-30',27,'26-30',28,'26-30',29,'26-30',30,'26-30',
31,'31-35',32,'31-35',33,'31-35',34,'31-35',35,'31-35',
36,'36-40',37,'36-40',38,'36-40',39,'36-40',40,'36-40',
41,'41-45',42,'41-45',43,'41-45',44,'41-45',45,'41-45',
46,'46-50',47,'46-50',48,'46-50',49,'46-50',50,'46-50',
51,'51-55',52,'51-55',53,'51-55',54,'51-55',55,'51-55',
56,'56-60',57,'56-60',58,'56-60',59,'56-60',60,'56-60',
61,'61-65',62,'61-65',63,'61-65',64,'61-65',65,'61-65',
66,'66-70',67,'66-70',68,'66-70',69,'66-70',70,'66-70',
'71+') AGE
, sum(decode(d_vst_dontyp,'WB',1,0)) DRAW1
, sum(decode(d_vst_dontyp,'xx',1,1)) TOTAL0

View 1 Replies View Related

Convert Xml To Db

Feb 20, 2008

dear all,

i have an XML that i want to create a database for it, so depending on this XML i need to create the right tables to store the information in tables and then call these info from the database instead of from XML.

it is a big XML but here is just one part, the other parts are the same:

<?xml version="1.0" encoding="UTF-8" ?>
- <RENTETARIEVEN date="04-12-2007 00:00">
- <GELDVERSTREKKER mvcode="AA" naam="ABN AMRO">
- <HYPVORM mvcode="aflosvrij">
- <PRODUCT mvcode="2000" mvproductcode="197" naam="Aflossingsvrije hypotheek" renteaangepast="4-10-2007">
- <VARIABEL>
<NHG>5.4</NHG>
<EW ew="75">5.6</EW>
<EW ew="90">5.9</EW>
<EW ew="100">5.9</EW>
<EW ew="125">5.9</EW>
</VARIABEL>
+ <VAST periode="1">
+ <VAST periode="2">
+ <VAST periode="3">
+ <VAST periode="5">
+ <VAST periode="6">
+ <VAST periode="7">
+ <VAST periode="10">
+ <VAST periode="12">
+ <VAST periode="15">
+ <VAST periode="20">
+ <VAST periode="25">
+ <VAST periode="30">
+ <PRODUCT mvcode="XX" mvproductcode="9045" naam="Internet hypotheek" overbrugging="6.6" renteaangepast="3-12-2007">
+ <HYPVORM mvcode="annuiteit">
+ <PRODUCT mvcode="1000" mvproductcode="286" naam="Annuïteitenhypotheek" renteaangepast="4-10-2007">
- <VARIABEL>
<NHG>5.4</NHG>
<EW ew="75">5.6</EW>
<EW ew="90">5.9</EW>
<EW ew="100">5.9</EW>
<EW ew="125">5.9</EW>
</VARIABEL>
- <VAST periode="1">
<NHG>5.3</NHG>
<EW ew="75">5.5</EW>
<EW ew="90">5.6</EW>
<EW ew="100">5.6</EW>
<EW ew="125">5.8</EW>
</VAST>
- <VAST periode="2">
<NHG>5.3</NHG>
<EW ew="75">5.5</EW>
<EW ew="90">5.6</EW>
<EW ew="100">5.6</EW>
<EW ew="125">5.8</EW>
</VAST>
- <VAST periode="3">
<NHG>5.3</NHG>
<EW ew="75">5.5</EW>
<EW ew="90">5.6</EW>
<EW ew="100">5.6</EW>
<EW ew="125">5.8</EW>
</VAST>
- <VAST periode="5">
<NHG>5.3</NHG>
<EW ew="75">5.5</EW>
<EW ew="90">5.6</EW>
<EW ew="100">5.6</EW>
<EW ew="125">5.8</EW>
</VAST>
- <VAST periode="6">
<NHG>5.3</NHG>
<EW ew="75">5.5</EW>
<EW ew="90">5.6</EW>
<EW ew="100">5.6</EW>
<EW ew="125">5.8</EW>
</VAST>
- <VAST periode="7">
<NHG>5.4</NHG>
<EW ew="75">5.6</EW>
<EW ew="90">5.7</EW>
<EW ew="100">5.7</EW>
<EW ew="125">5.9</EW>
</VAST>
- <VAST periode="10">
<NHG>5.4</NHG>
<EW ew="75">5.6</EW>
<EW ew="90">5.7</EW>
<EW ew="100">5.7</EW>
<EW ew="125">5.9</EW>
</VAST>
- <VAST periode="12">
<NHG>5.5</NHG>
<EW ew="75">5.7</EW>
<EW ew="90">5.8</EW>
<EW ew="100">5.8</EW>
<EW ew="125">6</EW>
</VAST>
- <VAST periode="15">
<NHG>5.6</NHG>
<EW ew="75">5.8</EW>
<EW ew="90">5.9</EW>
<EW ew="100">5.9</EW>
<EW ew="125">6.1</EW>
</VAST>
- <VAST periode="20">
<NHG>5.7</NHG>
<EW ew="75">5.9</EW>
<EW ew="90">6</EW>
<EW ew="100">6</EW>
<EW ew="125">6.2</EW>
</VAST>
- <VAST periode="25">
<NHG>5.7</NHG>
<EW ew="75">5.9</EW>
<EW ew="90">6</EW>
<EW ew="100">6</EW>
<EW ew="125">6.2</EW>
</VAST>
- <VAST periode="30">
<NHG>5.8</NHG>
<EW ew="75">6</EW>
<EW ew="90">6.1</EW>
<EW ew="100">6.1</EW>
<EW ew="125">6.3</EW>
</VAST>
</PRODUCT>
</HYPVORM>
- <HYPVORM mvcode="beleggers">
+ <PRODUCT mvcode="XX" mvproductcode="9050" naam="Internet hypotheek" overbrugging="6.6" renteaangepast="3-12-2007">
+ <VARIABEL>
+ <HYPVORM mvcode="hybride">
+ <PRODUCT mvcode="4000" mvproductcode="2316" naam="Meegroeihypotheek" renteaangepast="4-10-2007">
+ <HYPVORM mvcode="lineair">
- <PRODUCT mvcode="6000" mvproductcode="2509" naam="Lineaire hypotheek" renteaangepast="4-10-2007">
+ <VARIABEL>
+ <HYPVORM mvcode="spaar">
- <PRODUCT mvcode="7000" mvproductcode="3110" naam="Meegroeihypotheek" renteaangepast="4-10-2007">
+ <PRODUCT mvcode="7109" mvproductcode="7687" naam="Spaargroeihypotheek" renteaangepast="4-10-2007">
+ <HYPVORM mvcode="tradleven">
+ <PRODUCT mvcode="5000" mvproductcode="3214" naam="Levensverzekeringhypotheek" renteaangepast="4-10-2007">
+ <HYPVORM mvcode="unitlink">
+ <PRODUCT mvcode="8000" mvproductcode="1486" naam="Meegroeihypotheek" renteaangepast="4-10-2007">
</PRODUCT>
</HYPVORM>
</GELDVERSTREKKER>

i already started creating some tables but i need to know some good practice to o this. any help will be very appriciated


thanks

View 3 Replies View Related

Convert

Jan 15, 2004

I want to do this

SELECT TOP 100 PERCENT CONVERT(smalldatetime, DOCDATE, 105) AS DOCDATE
FROM SQSDBA.D_DETAILS
WHERE (DOCTYPE = 'SSCB') AND (DOCNUM = 155)
ORDER BY ROWNO

It is returning a date as 13/12/2003 ???

Any Ideas ?

Michael

View 13 Replies View Related

Convert

Jan 31, 2007

hi
how can i convert smallint to varchar
declare @over smallint
[rollover_txn] = CASE WHEN hh.[deint] & ' + CAST(varchar(5),@over)+ ' = ' + CAST(varchar(5),@over) + ' THEN 1 ELSE 0 END,



krmm

View 15 Replies View Related

How To Convert Value?

Feb 21, 2007

How do I convert a value in a qeuery to be displayed as money or currency?

Thanks,

www.myspace.com/drew22299

View 1 Replies View Related

Convert

Oct 30, 2007

I'm trying to convert an int to a string in my expression in ssis. Is this possible? I keep getting an error and I've also tried the cast operator, can't figure it out! Can someone help?

@[User::Path]+ "DEN" + Cast(@[User::Counter] as string)

thanks,
Mike

View 2 Replies View Related

How To Convert SDF To XML?

May 19, 2006

Hi All,

Did anyone know or can tell me how I can convert SDF to XML? and XML to SDF? Is there are tools or any code for me can use?

My boss don't want to use Merge Replication/RDA to push data from PDA to PC because sometimes got error when he want to replicate data.

View 4 Replies View Related

Convert Bug?

Apr 13, 2007

Hello, I am having trouble using CONVERT, I am using this select statement






Code Snippet

SELECT a.TaskId,a.Name,a.Description,a.StartDate,

CASE WHEN Convert(nvarchar,a.DueDate,101) = Convert(nvarchar,getdate(),101)

THEN

CONVERT(nvarchar,a.DueDate,108)

ELSE

a.DueDate

END as DueDate, a.NotificationRuleId, c.RowStateTypeId, a.CustomerId, a.CustomerIdent, a.SourceCustomerId, a.CreatedByUserId, a.CreatedDate, a.UpdatedByUserId, a.UpdatedDate, u.FirstName + ' ' + u.LastName as CreatedBy, r.Name as Status FROM Task a inner join AssignedTask c on a.TaskId = c.TaskId inner join UserAssignedTask b on c.AssignedTaskId = b.AssignedTaskId INNER JOIN [User] u on u.UserId = b.UserId INNER JOIN RowStateType r on c.RowStateTypeId = r.RowStateTypeId WHERE b.UserId = {0} and c.RowStateTypeId<>8









but if the statement hits the CONVERT section it formats the date as 1900-1-1 (time) instead of just (time) which is what I am looking for, is there any other way I can accomplish this?

View 1 Replies View Related

Convert

Dec 7, 2007

Hello,

I am making reports with SQL and Reporting Services.
To day I wanted to convert a field to datetime.
It had to have the style of Holland, so dd-mm-yyyy.
I used the following code, which not gives the expected output:




Code Block

CONVERT(DATETIME, Objectplaatsingsdatum, 105) AS Objectplaatsingsdatumconvert
It gives output like:
7/1/1992 12:00:00 AM
It is sure not what i wanted.

Can someone tell me what I do wrong?
The 105 stands for the style I wanted, so I do not know where it goes wrong.

Thanks,

View 5 Replies View Related

Convert

Nov 22, 2007

hi
below is my procedure.ToDate is varchar datatype.i can not make it datetime as per my need..so my date is now storing
in this format 11/2/2007..but i want to store this 2007-11-02 00:00:00.000 in this format ..how to do this ?

thanx


CREATE PROCEDURE sp_WriteLiveInDates
@ClientID INT,
@LiveInStatus BIT,
@FromDate DATETIME,
@ToDate VARCHAR(50) = null

AS
BEGIN
SET NOCOUNT ON
/* IF EXISTS (SELECT LiveInID FROM t_HR_LiveINDates WHERE ClientID=@ClientID AND RecordStatus = 1)
BEGIN
UPDATE
t_HR_LiveINDates
SET
FromDate = @FromDate,
ToDate = @ToDate,
DateModified = GETDATE()
WHERE
ClientID=@ClientID
IF @@error <> 0
RETURN(0)
ELSE
RETURN(1)
END
ELSE */
BEGIN
INSERT INTO t_HR_LiveINDates
(ClientID,
LiveInStatus,
FromDate,
ToDate,
RecordStatus,
DateCreated
)
VALUES
(@ClientID,
@LiveInStatus,
@FromDate,
@ToDate,
1,
GETDATE()
)

IF @@error <> 0
RETURN(0)
ELSE
RETURN(1)
END
END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

View 8 Replies View Related

101 Convert Does Not Convert?

May 5, 2006

Hi,

I am trying to convert a datetime to a date and get a rid of the time or set it to 00:00:00. I use the convert like BOL says will trunc the time, but it does not. I must miss something. See example bellow. The first formula should trunc the datetime as per BOL but it does not so I have to use the second formula which I feel is somewhat bad even if it works.

I have the same problem on both 2000 and 2005. I am sure I missunderstand something fundamental here. Thanks to point me to the right direction.

Philippe

----------------

SELECT CONVERT(datetime, getdate(), 101)

--------------------------------------------

SELECT CONVERT(datetime,

cast(datepart(yyyy, getdate()) as char(4))

+'-'+ cast(datepart(mm,getdate()) as char(2))

+'-'+ cast(datepart(dd, getdate()) as char(2))

, 101)

View 4 Replies View Related

Trying To Convert WQL To SQL, Need Help

Jan 11, 2008

Can someone point me in the right direction with this please?

This is what I have currently:

--Main SQL Code:
select distinct sys.Netbios_Name0,
sysou.System_OU_Name0,
sys.Operating_System_Name_and0,
sys.User_Name0
from dbo.v_r_system_valid AS sys,
dbo.v_RA_System_SystemOUName AS sysou
where (sysou.System_OU_Name0 LIKE @OU)

--OU Prompt SQL Code:
BEGIN
IF (@__filterwildcard = '')
SELECT DISTINCT ou.system_ou_name0
FROM dbo.v_ra_system_systemouname AS ou
ORDER BY ou.system_ou_name0
ELSE
SELECT DISTINCT ou.system_ou_name0
FROM dbo.v_ra_system_systemouname AS ou
WHERE ou.system_ou_name0 LIKE @__filterwildcard
ORDER BY ou.system_ou_name0
END

**********************************

When I run the above report from the sccm admin console, I get this error:



Microsoft VBScript runtime error '800a0007'
Out of memory: 'GetRows'
/SMSReporting_1PR/Report.asp, line 546

**************************************

I have the code working as an SCCM query (WQL), I just wanted to convert it to a report (SQL), this code is here:

select distinct SMS_R_System.Name,
SMS_R_System.OperatingSystemNameandVersion,
SMS_R_System.LastLogonUserName
from SMS_R_System
where SMS_R_System.SystemOUName = ##PRM: SMS_R_System.SystemOUName##

View 1 Replies View Related

Convert .mdf To .sdf

Nov 28, 2006

how can i convert .mdf to .sdf using SSIS and using code in c#

please help me

thx alot

View 7 Replies View Related

SQL - CONVERT &&amp; BETWEEN

Apr 29, 2008

Hi All


Can you show me a way to be able to do this in a SQL Access string ?


(Note , the field type is Text, so the use of the CONVERT , but don't work on access)


HOW-TO IN ACCESS:


SELECT * FROM YourTable WHERE CONVERT(datetime, datecolum) BETWEEN '01-01-2005' AND '04-19-2009'



Thank you veryyy much !!


Core regards


(Ps. I know it's not SQL Server, but envolves a SQL String, Thanks)

View 3 Replies View Related

Convert Access To SQL

Jul 15, 2006

The following is my code for Access... can someone help me convert it to sql:
My Connectionstring is "server=(local);database=Database;trusted_connection=true"
 
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="VB" runat="server">
Sub btnLogin_OnClick(Src As Object, E As EventArgs)
Dim myConnection As OleDbConnection
Dim myCommand As OleDbCommand
Dim intUserCount As Integer
Dim strSQL As String
strSQL = "SELECT COUNT(*) FROM tblLoginInfo " _
& "WHERE username='" & Replace(txtUsername.Text, "'", "''") & "' " _
& "AND password='" & Replace(txtPassword.Text, "'", "''") & "';"
myConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source=" & Server.MapPath("login.mdb") & ";")
myCommand = New OleDbCommand(strSQL, myConnection)
myConnection.Open()
intUserCount = myCommand.ExecuteScalar()
myConnection.Close()
If intUserCount > 0 Then
lblInvalid.Text = ""
FormsAuthentication.SetAuthCookie(txtUsername.Text, True)
Response.Redirect("login_db-protected.aspx")
Else
lblInvalid.Text = "Sorry... try again..."
End If
End Sub
</script>

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved