Small application to take data from one table (text field in SQLServer database) and convert it to JPG using .Net component.
1. Select * from Table1 where file reference column is Null, join Table1 to Table2 via refno column.
2. Cycle through return rows list to process data
3. Get data from column in Table2
4. Change data (a. remove prefix string, b. replace all instances of "space" with "+"
5. Write data back to column (now a valid Base64 string)
6. Pass data to function that decodes Base64 (vb.Net function) and write out JPG image to file
7. Write filepath/filename to [login to view URL] column
Use setup tables to control:
a. SQLServer name and user name/login
b. Base JPG file location (e.g.: c:\data\pics\)
c. Log level (0,1) for normal, debug
No user interface, to be called from command line.
Support XP, Win7, and Windows Server 2003-2010
Dear Sir,
I understood the requirement. Here is my interpretation, its getting data from column of table2 and convert it into a Base64 string which further is converted into a jpeg and the path is stored in the Table1 column.
Its an easy task and am certified and have enough experience to complete it with ease and professionalism.
I will be glad if i get an opportunity.
Looking forward for a response.
Thanks
hi leec3, I am a .net professional of more than 10 years and am also very proficient SQL Server administrator. I'm sure I can help you get those JPEGS for you quickly and accurately. Please check PM!
Hello Sir,
I would like to take this opportunity to do the said work, and establish a fair relation with your firm, which can lead to carry out the business smoothly.
Please have a look at the private message.
Thanks & Regards,
Ninad Patil
Hi leec3 ,
I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 5 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you'll come to us again and again to avail our services.
I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project.
Thanks,
Murtaza