Database

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()

Dim Conn As New SqlConnection<br />
Dim cmd As New SqlCommand<br />
Conn.ConnectionString = "Data Source=Server; Database = DB ; Integrated Security=SSPI"<br />
Conn.Open()<br />
cmd.Connection = Conn<br />
cmd.CommandType = CommandType.Text<br />
cmd.CommandText = "Delete From TableName"<br />
cmd.ExecuteNonQuery()

csharp_boy wrote:

how do i link Order_Items record with Order record in the dataset?