Completed

new c#.net console application

this project require to develop a new console application in c#.net for retrieving data from a table called utenti_log on MSSQL database and exporting them on excel file.

The connection string must be defined in a config file so that I can modify it without compile the project.

As you can see from the name the table is about user's log. I need to know which urls have been seen and by which users.

So, the table has the following structure:

create TABLE [Utenti_log] (

[id] [int] IDENTITY (1, 1)

[AUTH_TYPE] [varchar] (500)

[URL] [varchar] (500) NULL ,

[Date] [datetime] NULL

) ON [PRIMARY]

GO

the information I need to export in excel are the following (you can use different excel worksheets if you need):

1. how many AUTH_TYPE unique are logged in from the Date >= 01/01/2014

2. the list of AUTH_TYPE unique are logged in from the Date >= 01/01/2014

3. the list of the URL unique from the Date >= 01/01/2014 with the total log for each of them order by the url with major total

4. the list of the URL unique from the Date >= 01/01/2014 for each user of point 2 (AUTH_TYPE unique).

I will need a little description how to setup and run.

my skype_contact: luca_archivist

Beceriler: C# Programlama, SQL

Daha fazlasını gör: string in data structure, string in c programming, string data structure, new data structure, data structure programming in c, c string programming, console programming in c#.net, application of list in data structure, application of data structure in c, application of data structure, excel to my sql, create new c, console sql, console c, Console application, c#net, c# net, c# MSSQL, net excel programming, compile excel file

İşveren Hakkında:
( 209 değerlendirme ) Luserna S.G., Italy

Proje NO: #6712232

Seçilen:

amusto

Contattami e dimmi esattamente cosa ti serve. Faccio questo tipo di applicazioni tutti i giorni. Dai un'occhiata al mio profilo. Un consiglio rimuovi il link del tuo contatto dalla descrizione del progetto. Potrebb Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 111%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(73 Değerlendirme)
7.2

Bu iş için 44 freelancer ortalamada $101 teklif veriyor

OShuqair

hi Luca, thank you for the invitation to bid I have 8 years of .net programming experience can do this project for you Please award the project to start immediately thanks Othman

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(88 Değerlendirme)
7.9
sumon355

Hello, I am very much interested to do this project as i am experienced a lot in c# as well as ms sql related tasks. I already did similar type of works, so i think i can do it easily & efficiently. Looking forward to Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(168 Değerlendirme)
7.0
customizedata

i have gone through the description, what we can do is we can make select dataadapter for getting the data or otherwise we can make Stored procedure and show the selected data on Console application. I will setup the Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(136 Değerlendirme)
6.7
armteamvw

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde147%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)
6.2
XeeChaun

hi. I've worked a lot in C# using databases (MySQL, MS-SQL, Access etc). I've also done a lot of Excel automation projects. here's one of my past projects which involved picking the data from database and populating it Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(54 Değerlendirme)
6.3
sflogics

Hi, We’ve had a good look at your project description and we’re very interested in providing a solution. We are a professional development company head-quartered in Pakistan. We are 100% sure that we can achieve Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(32 Değerlendirme)
5.7
goswamiarpit475

Hi Sir, I am ready to work for you.I have 5 years of experience in .Net/C#/sql. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. Ple Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(31 Değerlendirme)
5.5
schungur

TOP SQL freelancer

in %bids___i_period_sub_35% gün içinde133%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)
5.4
urmate

HI Contact me for an efficient, perfect, well documented development of your project according to 100% accuracy and requirements, with dedicated support. Thanks Farah Saif

in %bids___i_period_sub_35% gün içinde60%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(61 Değerlendirme)
5.3
khp31

Sr. Software developer with 5.0+yrs experience. Sr. Software developer with 5.0+yrs experience. Sr. Software developer with 5.0+yrs experience.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(32 Değerlendirme)
5.2
angnut

hi, you can find my skill and references on LinkedIn. I am italian backend developer with a lot of experience on [login to view URL] can you share more details on chat to understand better the task and the deadlines. thank Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
4.6
expertatwork

hey there, this can be done using command line... please share your ms sql server details, thanks !

in %bids___i_period_sub_35% gün içinde55%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(29 Değerlendirme)
4.6
vland

I'm working as .NET Developer for 4 years and I really enjoy my job. I have strong experience with MSSQL and desktop applications. And I also work with Italians for one year and it was very good working year in my life Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
4.7
kultech

Dear Sir, I'm expert C#, ms sql server, oracle, db2, informix. I have create more winservices, windows form, webservices and website. I can do it. Happy working with sir. Thanks

in %bids___i_period_sub_35% gün içinde133%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)
4.6
imchinmaya14

We are a group of few people having experience ranging from 4 to 7 years of industry experience. We have experience of various technologies like ASP.NET MVC, C#, IoC, DI, EF, Web API, KnockoutJS, AngularJS, JQuery, WPF Daha Fazla

in %bids___i_period_sub_35% gün içinde83%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
4.3
AliSafder

I have over 6 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like MVC, .Net technologies(Asp.Net, Vb.Net / C# ) ,PHP, WordPress, ASP CLASSIC etc. Scri Daha Fazla

in %bids___i_period_sub_35% gün içinde90%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(22 Değerlendirme)
4.4
Alethor

Hi! I can do this job for you. I will deliver a quality job. Let me know if you want to talk. Thank you very much

in %bids___i_period_sub_35% gün içinde66%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)
3.9
RKYSP

Hi, I am an individual freelance, having more than 10yrs of exp in developing applications, window & web based, using .Net (C#.Net, Asp.Net (MVC), XML, WPF, WCF (Webservices) kendo ui, MySQL and SQL Server etc). Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
4.0
dutsoftware

Hello, I am a software engineer student. This is just a simple task to me. Hope I can help you this time.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
3.2
catalinIL

I have experience in creating .Net based application and your requirements for this projects I think are easy to fulfill. I am thinking to split the project internally in 4 phases: 1. Get data from database. 2. Man Daha Fazla

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
3.2