Visual Basic

wrote:

is there any code syntax that: when a user log in, automatically the username & login time should get insert

CREATE TABLE unix
 ( 
   -- other fields here
   LastAccessedBy varchar(220) not null CONSTRAINT [DF_LastAccesedBy]
       DEFAULT (suser_sname()),
   LastAccessedDate DateTime not null CONSTRAINT [DF_LastAccesedDate]
       DEFAULT (GetDate())
 )

<br />
public class Switch<br />
<br />
public myLight as Light<br />
<br />
public Sub New(aLight as Light)<br />
myLight = aLight<br />
End Sub<br />
<br />
public Sub SwitchOn()<br />
myLight.TurnOn()<br />
end Sub<br />
End Class<br />

<br />
Public Class Light<br />
private isOn as boolean<br />
<br />
public Sub New()<br />
End Sub<br />
<br />
Public Sub TurnOn()<br />
isOn = true<br />
' And some other code to shine brightly<br />
End Sub<br />
<br />
End Class<br />

<br />
Public Class Bell<br />
private isOn as boolean<br />
<br />
public Sub New()<br />
End Sub<br />
<br />
Public Sub TurnOn()<br />
isOn = true<br />
' And some other code to ring loudly<br />
End Sub<br />
<br />
End Class<br />

Public Interface ISwitchableObject<br />
    Sub TurnOn()<br />
End Interface

<br />
public class Switch<br />
<br />
public myObj as ISwitchableObject<br />
<br />
public Sub New(anObject as ISwitchableObject)<br />
myObj = anObject<br />
End Sub<br />
<br />
public Sub SwitchOn()<br />
myLight.TurnOn()<br />
end Sub<br />
End Class<br />

lopashree wrote:

plz give me ans that how to insert binary data into database by using vb.net?

wrote:

how to insert binary data into database by using vb.net?

theCommand.CommandText = "INSERT INTO MyTable(binaryColumn) VALUES (@binaryData)"
theCommand.Parameters.Add("@binaryData", byteArray)
theCommand.ExecuteNonQuery()