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]
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
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
Bu iş için 44 freelancer ortalamada $101 teklif veriyor
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
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
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
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
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
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
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
Sr. Software developer with 5.0+yrs experience. Sr. Software developer with 5.0+yrs experience. Sr. Software developer with 5.0+yrs experience.
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
hey there, this can be done using command line... please share your ms sql server details, thanks !
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
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
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
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
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
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
Hello, I am a software engineer student. This is just a simple task to me. Hope I can help you this time.
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