Member Avatar for kanuri1
kanuri1 -2 Junior Poster in Training

hi
how to insert default year into the database

here my coding is given below

Dim connstr As String
connstr = ConfigurationManager.ConnectionStrings("guest1").ConnectionString()
Dim conn As New SqlConnection(connstr)
Dim year As Integer
conn.open()
Dim insert As New SqlClient.SqlCommand("insert into guesthouse(year) values('" & year & "')", conn)
insert.ExecuteNonQuery()
conn.close()
here iam using asp.net with vb script.....
database is sql server-2005.......

  • 1 Contributor
  • 0 Replies
  • 50 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.