thnx i will tray it :)

Ahmed El-Badry

i want calculate stoprate value table name trips starttime endtime triptime Stoprate 14/08/2008 10:39:00 PM 14/08/2008 10:56:00 PM 16 3 14/08/2008 10:59:00 PM 14/08/2008 11:1:00 PM 2 stop value = 14/08/2008 10:56:00 PM - 14/08/2008 10:59:00 PM = 3 i want the sql queries to calculate stoprte value

Ahmed El-Badry

table name trips starttime endtime triptime Stoprate 14/08/2008 10:39:00 PM 14/08/2008 10:56:00 PM 16 3 14/08/2008 10:59:00 PM 14/08/2008 11:1:00 PM 2 i want the sql queries to create stoprte value

Ahmed El-Badry

thnx u :-D :rose:

Ahmed El-Badry

Msge.Visible = True Dim date1 As Date = "8/27/2008" Dim date2 As Date = "5/19/2008" Dim DiffDays As Integer Dim Diffmonth As Integer Dim Diffyear As Integer DiffDays = date1.Day - date2.Day Diffmonth = date1.Month - date2.Month Diffyear = date1.Year - date2.Year Msge.Text = DiffDays.ToString + " " + Diffmonth.ToString + " " + Diffyear.ToString outing 8 days 3 month 0 year i want convert this to days = 100 days :confused:

Ahmed El-Badry

Msge.Visible = True Dim date1 As Date = "8/27/2008" Dim date2 As Date = "5/19/2008" Dim DiffDays As Integer Dim Diffmonth As Integer Dim Diffyear As Integer DiffDays = date1.Day - date2.Day Diffmonth = date1.Month - date2.Month Diffyear = date1.Year - date2.Year Msge.Text = DiffDays.ToString + " " + Diffmonth.ToString + " " + Diffyear.ToString outing 8 days 3 month 0 year i want convert this to days = 100 days

Ahmed El-Badry

I used Visual Basic.Net in VS 2003 :sigh:

Ahmed El-Badry

Msge.Visible = True Dim date1 As Date = "8/27/2008" Dim date2 As Date = "5/19/2008" Dim DiffDays As Integer DiffDays = date1.Day - date2.Day Msge.Text = DiffDays Who got the output of this code is No. 8 days ,This is not true The difference between the dates is 100 days ,This is what i mean Thank you for Help:rose:

Ahmed El-Badry

Msge.Visible = True Dim date1 As Date = "8/27/2008" Dim date2 As Date = "5/19/2008" Dim DiffDays As Integer DiffDays = date1.Day - date2.Day Msge.Text = DiffDays Who got the output of this code is No. 8 days ,This is not true The difference between the dates is 100 days ,This is what i mean Thank you for Help:rose:

Ahmed El-Badry

This is not what I mean I mean Full date like 8/27/2008 - 5/19/2008 = 100 Day thnx :S

Ahmed El-Badry

like 15/1/2008 and 30/1/2008 = 15 day Pleaaaaaaaaase

Ahmed El-Badry

I want to compare between the dates something like that If Date.Now.ToShortDateString < date2.ToShortDateString Then:cool:

Ahmed El-Badry

i need this example in VB.net not C#.net and thnx for:confused: helping

Ahmed El-Badry

yes i have web application and i want this page opend only by one user when this user close it The user is the only one who can open at the same time

Ahmed El-Badry

when someone open this page and aonther user tray open it see msg this page opened by aonther user used VS 2003

Ahmed El-Badry

How to Enable Remote Desktop and add new user from shell command

Ahmed El-Badry

i have 3com router and i have Puplic IP address Nat is Enabled and i configer it like 81.10.29.106:Defule sqlserver port how to configer sql clint to creat connection Between sql server and sql clint and thnx:confused:

Ahmed El-Badry

Thank you very much :-D:rose: to help me

Ahmed El-Badry

how use session variables give me a ex bad english sooooooooorye thnx u:rose:

Ahmed El-Badry

i want shar like cookes or send me a sample in cooke V thnx

Ahmed El-Badry