To convert any date filed with time to date without time like 1-Jan-2012 00:00:00.00

update TableName set Datefield=cast(convert(varchar,datefield,106) as datetime)

Save VsFlexGrid data to excel

1. Private Sub FlexToExcel()
2. Dim xlObject    As Excel.Application
3. Dim xlWB        As Excel.Workbook
4.        
5.     Set xlObject = New Excel.Application
7.     'This Adds a new woorkbook, you could open the workbook from file also
8.     Set xlWB = xlObject.Workbooks.Add
9.                
10.     Clipboard.Clear 'Clear the Clipboard
11.     With MSFlexGrid1
12.         'Select Full Contents (You could also select partial content)
13.         .Col = 0               'From first column
14.         .Row = 0               'From first Row (header)
15.         .ColSel = .Cols - 1    'Select all columns
16.         .RowSel = .Rows - 1    'Select all rows
17.         Clipboard.SetText .Clip 'Send to Clipboard
18.     End With
19.            
20.     With xlObject.ActiveWorkbook.ActiveSheet
21.         .Range("A1").Select 'Select Cell A1 (will paste from here, to different cells)
22.         .Paste              'Paste clipboard contents
23.     End With
24.    
25.     ' This makes Excel visible
26.     xlObject.Visible = True
27. End Sub

Binding Combobox at run time without using database connection via Dictionery Objec

        Dim objDict As New Dictionary(Of String, String)
        objDict.Add("1", "Value 1")
        objDict.Add("2", "Value 2")


        ComboBox1.DataSource = New BindingSource(objDict, Nothing)
        ComboBox1.DisplayMember = "Value"
        ComboBox1.ValueMember = "Key"

Difference between Panel and GroupBox classes in .NET

The both classes that is Panel and GroupBox can be used as a container for other controls such as check box control, radio button control etc. But the difference between these two classes is 
• In case of Panel class captions cannot be displayed i.e. we can’t set caption but in GroupBox class captions can be displayed. 
• The Panel class can have scroll bars but GroupBox class cannot have scroll bar.

Add row to bound Datagrideview

        Dim dr As DataRow = CType(DgviewDetail.DataSource, DataTable).NewRow
        dr.Item(1) = "anand"

        'DgviewDetail.Rows.Add(dr)

        CType(DgviewDetail.DataSource, DataTable).Rows.Add(dr)

excel connection string

ExcelCon = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + WorkBook + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;';")

to set database owner

use databasename

sp_changedbowner

user_name