gridview - date fromat string in asp.net gridview

gridview date format string

DataFormatString="{0:dd/MM/yyyy}"

To get the list of tables in sql server

SELECT * FROM information_schema.tables
OR
SELECT sobjects.name FROM sysobjects sobjects WHERE sobjects.xtype = 'U'

-The list of other object types you can search for

C: Check constraint
D: Default constraint
F: Foreign Key constraint
L: Log
P: Stored procedure
PK: Primary Key constraint
RF: Replication Filter stored procedure
S: System table
TR: Trigger
U: User table
UQ: Unique constraint
V: View
X: Extended stored procedure

Get the list of stored procedures in sql server

SELECT * FROM SYS.procedures WHERE NAME NOT LIKE 'SP_%DIAGRAM%' ORDER BY modify_date desc

OR

SELECT * FROM sys.all_objects where type='p' and NAME NOT LIKE 'SP_%DIAGRAM%' ORDER BY create_date desc

Select data from sql and bind to datalist

Private Sub FillDataList()
        Try
            Dim strConString As String = String.Empty
            Dim SqlQuery As String = String.Empty
            Dim sqlda As SqlDataAdapter
            Dim SqlDs As New DataSet
            strConString = System.Configuration.ConfigurationManager.ConnectionStrings("CnString").ConnectionString
            SqlQuery = "SELECT TOP 6 * FROM SampleTable"

            sqlcon = New SqlConnection(strConString)
            sqlcmd = New SqlCommand(SqlQuery, sqlcon)
            sqlda = New SqlDataAdapter(sqlcmd)
            sqlcon.Open()
            sqlda.Fill(SqlDs, "Stf")

            DataList1.DataSource = SqlDs.Tables(0)
            DataList1.DataBind()

            sqlcon.Close()
            sqlcmd.Dispose()
            sqlcon.Dispose()
        Catch ex As Exception
            lblMsg.Text = ex.ToString()
        End Try
    End Sub

Update sql table data using asp.net

Private Sub UpdateTest()
        Try
            Dim SqlCmd As SqlCommand
            Dim SqlCon As SqlConnection
            Dim strConString As String
            Dim SqlQuery As String = String.Empty

            strConString = System.Configuration.ConfigurationManager.ConnectionStrings("Cn").ConnectionString
            SqlQuery = "UPDATE Staff SET TEST='HI' WHERE ID = 12"

            SqlCon = New SqlConnection(strConString)
            SqlCmd = New SqlCommand(SqlQuery, SqlCon)
            SqlCon.Open()
            SqlCmd.ExecuteNonQuery()

            SqlCon.Close()
            SqlCmd.Dispose()
            SqlCon.Dispose()
        Catch ex As Exception
            lblMsg.Text = "Error"
        Finally
            SqlCon.Close()
            SqlCmd.Dispose()
            SqlCon.Dispose()
        End Try
    End Sub