GL SOFT INDIA
Fusion of Web, Mobile & Desktop Applications.
Monday, June 15, 2015
vb.net - DataGridView to Datatable
›
Convert DataGridView Source to Datatable *********************************** dim dt as New DataTable dt = TryCast(dgv.DataSource, DataT...
Grouping Datetime Column by Date part only.
›
SELECT DATEADD(dd,(DATEDIFF(dd,0,CRETS)),0), COUNT(*) FROM Table1 GROUP BY DATEADD(dd,(DATEDIFF(dd,0,CRETS)),0) SELECT CAST(DATEDIFF(dd...
Wednesday, May 16, 2012
Listview - autosize columns disbale
›
Private Sub lvwOne_ColumnWidthChanging(ByVal sender As Object, ByVal e As System.Windows.Forms.ColumnWidthChangingEventArgs) Handles lvwOn...
Friday, January 15, 2010
Import from Excel Sheet into Sql Table with filtering
›
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Data.xls', 'S...
Monday, June 15, 2009
SQL FUNCTION ExtractNumbers
›
SQL FUNCTION ExtractNumbers Create Function ExtractNumbers ( @str_passed varchar(max) ) Returns varchar(50) AS BEGIN declare @val varch...
Thursday, May 21, 2009
RupeeMail
›
Invitation to join Rupee Mail! Hi , I have something interesting for you, RupeeMail! It’s really amazing! You get paid to open & read ...
Monday, February 9, 2009
Scalar User Defined Functions and Computed Columns
›
Scalar User Defined Functions and Computed Columns Came across an interesting SQL problem where a customer has a table with a primary key an...
›
Home
View web version