Database

UPDATE customer<br />
SET [name] = @newname<br />
WHERE [id] = @id<br />
AND [rowversion] = @timestamp  <-- timestamp value

cbhkenshin wrote:

what sholud i change only the connection string so that it will work over lan and for more than one user.

Server=MyServerMachine

Server=MyServerMachine\NamedInstance

SELECT COUNT(*) FROM user<br />
WHERE username = 'user' AND pass = PASSWORD('pass')

Select A.Flds , B.Flds From Server1.db1.dbo.Table1 A<br />
Inner Join Server1.db2.dbo.Table1 B A.Fld = B.Fld

dansoft wrote:

in which format the user have to input the date in asp.net?

SqlCommand cmd = new SqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = "SELECT * FROM MyTable "+
    "WHERE SomeDate BETWEEN @startDate AND @endDate";
cmd.Parameters.Add("@startDate", theStartDateTimeObject);
cmd.Parameters.Add("@endDate", theEndDateTimeObject);
SqlDataReader reader = cmd.ExecuteDataReader();

dansoft wrote:

can you please give me the code in vb.net format? i don't know c#.net

Dim cmd As SqlCommand 
cmd = New SqlCommand()
cmd.Connection = myConnection
cmd.CommandText = "SELECT * FROM MyTable " & _
    "WHERE SomeDate BETWEEN @startDate AND @endDate"
cmd.Parameters.Add("@startDate", theStartDateTimeObject)
cmd.Parameters.Add("@endDate", theEndDateTimeObject)
Dim reader As SqlDataReader 
reader = cmd.ExecuteDataReader()