Database

neodeaths wrote:

i would like to know how can i store my user password and username as my window form need to be able to log in and out

neodeaths wrote:

i am needed to create a user on the security of the ms sql database and map it to my database

neodeaths wrote:

is it possible to set the ms sql database or the windowform to loginto the ms sql server and authenticate thru a table

Ahmed El-Badry wrote:

i want the sql queries to create stoprte value

select datediff(minute,
                trips.endtime, 
                (select min(t2.starttime)
                 from   trips t2
                 where  t2.starttime > trips.endtime))
from trips...

SELECT ...
FROM ...
WHERE DateFromTextBox BETWEEN date1 AND date2

String rqtr2 = "select ID as [p1] from Table where ('" + TextBox2.Text + "' between date1 and date2)";

TextBox2.Text = Convert.ToString(DateTime.Now) ;

foryou wrote:

but it is not right

foryou wrote:

sorry I dont speak English well

foryou wrote:

what I am in the textbox is the system date (detetime)
example :
07/01/2009 11:59:16

select ...
from   ...
where CONVERT(datetime, '07/01/2009 11:59:16', 101) between date1 and date2

select * 
from  sysobjects 
where CONVERT(datetime, '01/07/2009 11:59:16',101) -- now
between GETDATE()-1  -- yesterday
and     GETDATE()+1  -- tomorrow

CONVERT(datetime, '07/01/2009 11:59:16', 103)

select ...
from   ...
where @SomeDateParameter between date1 and date2

foryou wrote:

Merci Mika Wendelius

foryou wrote:

Thank you very much

foryou wrote:

they say "De rien".