Comments by almounkez

almounkez 10-Jun-19 5:34am View

Declare @Hdate nvarchar(50)
set @Hdate = convert(varchar(10),convert(date,convert(varchar(12),GETDATE(),131),103),112)
select @Hdate

almounkez 26-Nov-12 16:37pm View

for connection string you have to change it by code
my.application.setting.myconnectionstring = "new connection string"

you can also use installaware to install your application with sql server on the client machine

almounkez 26-Nov-12 16:25pm View

in crystal report you have to change the properites of the total fields into running total

almounkez 26-Nov-12 16:12pm View

If "JetVersion" = 8 Then
excelConnectionString = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0;", m_filename)
Else
excelConnectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=Excel 12.0;", m_filename)
End If

almounkez 26-Nov-12 16:10pm View

it depend on the ms office version
if the excel file is 2010 and the processor is 64 bit you need a new jet driver

Comments by almounkez (Top 5 by date)