Find Jobs
Hire Freelancers

C# MySQL insert data issue

$10-30 USD

Ditutup
Dibuat sekitar 8 tahun yang lalu

$10-30 USD

Dibayar ketika dikirim
I am currently having an issue in inserting data into the MySQL database. Our code inserts null values when the form is submitted with no errors. This is the first time we are working with MySQL for the first time. We usually work with SQL Server and it works with no problems. We need some one to look into why it is entering in null values. Please see the script below and see if we are doing wrong. string insertSQL; insertSQL = "INSERT INTO vendors ("; insertSQL += "fname,"; insertSQL += "lname,"; insertSQL += "company_name,"; insertSQL += "address_1,"; insertSQL += "address_2,"; insertSQL += "city,"; insertSQL += "state_id,"; insertSQL += "postal_code,"; insertSQL += "phone,"; insertSQL += "fax,"; insertSQL += "email,"; insertSQL += "web_url,"; insertSQL += "password,"; insertSQL += "active,"; insertSQL += "status,"; insertSQL += "date_entered) "; insertSQL += "VALUES ("; insertSQL += "@fname,"; insertSQL += "@lname,"; insertSQL += "@company_name,"; insertSQL += "@address_1,"; insertSQL += "@address_2,"; insertSQL += "@city,"; insertSQL += "@state_id,"; insertSQL += "@postal_code,"; insertSQL += "@phone,"; insertSQL += "@fax,"; insertSQL += "@email,"; insertSQL += "@web_url,"; insertSQL += "@password,"; insertSQL += "@active,"; insertSQL += "@status,"; insertSQL += "NOW());"; insertSQL += " SELECT last_insert_id()"; MySqlConnection connection = null; try { connection = new MySqlConnection([login to view URL]["DataBaseConnection"].ToString()); [login to view URL](); MySqlCommand cmd = new MySqlCommand(); [login to view URL] = connection; [login to view URL] = insertSQL; [login to view URL](); [login to view URL]("@fname", fname); [login to view URL]("@lname", lname); [login to view URL]("@company_name", company_name); [login to view URL]("@address_1", address_1); [login to view URL]("@address_2", address_2); [login to view URL]("@city", city); [login to view URL]("@state_id", state); [login to view URL]("@postal_code", postal_code); [login to view URL]("@phone", phone); [login to view URL]("@fax", fax); [login to view URL]("@email", company_email); [login to view URL]("@web_url", website_url); [login to view URL]("@password", company_name); [login to view URL]("@active", 1); [login to view URL]("@status", 1); int id = [login to view URL]([login to view URL]()); [login to view URL](id); } finally { if (connection != null) [login to view URL](); }
ID Proyek: 9221700

Tentang proyek

65 proposal
Proyek remot
Aktif 8 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
65 freelancer menawar dengan rata-rata $20 USD untuk pekerjaan ini
Avatar Pengguna
I can fix it in 10 minutes ............................................................................
$25 USD dalam 1 hari
4,9 (402 ulasan)
7,1
7,1
Avatar Pengguna
Hi sir, Please send the cs file...I will fix right away. thanks.............................////////////////
$10 USD dalam 1 hari
4,9 (166 ulasan)
6,1
6,1
Avatar Pengguna
Can u please describe the error that you are having now? I can solve it asap
$20 USD dalam 1 hari
4,8 (27 ulasan)
5,7
5,7
Avatar Pengguna
Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 6+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net,Asp.net MVC - Linq to SQL,Entity Framework - Javascript,Jquery,KnockoutJS,AngularJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Facebook Graph API - Application Security Remediation - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are asking for. We can discuss further on chat(Skype:mahajan344). Looking forward from your end. Thanks Nikhil Mahajan
$25 USD dalam 1 hari
4,7 (37 ulasan)
5,9
5,9
Avatar Pengguna
Hi, Please feel free to discuss the project with me ..................................................................................................... Thanks, Murtaza
$50 USD dalam 1 hari
5,0 (11 ulasan)
4,5
4,5
Avatar Pengguna
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), SignalR, XML,WPF, WCF (Webservices) kendo ui, Angular JS, MySQL and SQL Server etc). By worked with Giants clients as a vendor, got expertise in delivering the quality code with in the time, please see my profile. Time and cost may vary based on the complexity and the requirements. Awaiting for your positive response
$10 USD dalam 0 hari
4,8 (19 ulasan)
4,3
4,3
Avatar Pengguna
Hello sir, I am an experienced Software engineer based in INDIA.. I have 5 years of experience in software development, documentation and requirements elicitation. My experience revolves around web application development. I have expertise in following technologies: ASP.NET MVC, AngularJS, Ionic Framework , Django, Django Rest Framework, GeoDjango,Javascript , Jquery, Openlayers, Apache Cardova, MYSQL, SQLServer, PostgreSQL, Postgis, MongoDb and Bootstrap. I have been worked in E-Commerce web applications, developed own E-commerce CMS, GIS applications. Property management systems, Rent a car application and deals web applications. I love to work in new technologies and can’t stick myself just in one thing. I believe I am well qualified to undertake the task at hand. Would love to further discuss this project and your exact requirement. I am confident can provide you with top notch application that will fit your needs. Thank you Parimal
$14 USD dalam 1 hari
5,0 (4 ulasan)
4,0
4,0
Avatar Pengguna
.net expert here. I can do your job. Further details on message please.
$20 USD dalam 1 hari
4,8 (14 ulasan)
4,3
4,3
Avatar Pengguna
Hello. Happy new year!!! I saw your description I have done several project like this. I'm an expert in Data Structures and Algorithms. And I know Java ,C/C++, C# , MySQL and Python well. I'm interested this project. I want to discuss with you about this project. If it's possible,please contact me and explain more detail. I wait your good reply. Bye.
$25 USD dalam 1 hari
4,6 (10 ulasan)
3,9
3,9
Avatar Pengguna
A proposal has not yet been provided
$23 USD dalam 1 hari
4,9 (8 ulasan)
3,6
3,6
Avatar Pengguna
Hi! I can solve the issue, only I need identify the null fields to control them Regards!
$30 USD dalam 1 hari
5,0 (2 ulasan)
3,0
3,0
Avatar Pengguna
I have around 2 years of working experience in MySQL. As an professionally experienced and young Software developer I really like to take on the task and will really appreciate if my first assignment can be from you. I assure that i will deliver the project timely and with no quality compromise.
$21 USD dalam 2 hari
4,0 (3 ulasan)
3,9
3,9
Avatar Pengguna
Hello. I am a senior level engineer and C# expert. In my full time job as a software engineer for a medical device company, I use C#/WPF with a MySQL database so I am very familiar with this development environment. I'm confident I can determine why NULL values are being inserted into your database tables. Please award me the project and I will get started. Do not hesitate to send me a private message with any questions you have for me. You do not need to pay me until I've delivered a working solution, no milestone payments necessary. Thanks and I look forward to working with you.
$25 USD dalam 2 hari
5,0 (6 ulasan)
2,9
2,9
Avatar Pengguna
A proposal has not yet been provided
$10 USD dalam 0 hari
5,0 (8 ulasan)
3,0
3,0
Avatar Pengguna
Hello, I am a computer engineer and I have skills and experience in software development so if you give me a chance I can prove it to you. If you want we can chat further for details and so you can know more about me. So please give me a chance. Thanks
$10 USD dalam 0 hari
4,9 (10 ulasan)
2,7
2,7
Avatar Pengguna
A proposal has not yet been provided
$20 USD dalam 1 hari
5,0 (3 ulasan)
2,7
2,7
Avatar Pengguna
Eight years of experience in developing applications on various platforms. Feel free to contact me.
$10 USD dalam 1 hari
5,0 (5 ulasan)
2,6
2,6
Avatar Pengguna
A proposal has not yet been provided
$25 USD dalam 1 hari
5,0 (1 ulasan)
2,4
2,4
Avatar Pengguna
Hi, I have a very good experience in c# development and how to use it to connect to mysql database. Regards,
$20 USD dalam 1 hari
2,8 (1 ulasan)
2,8
2,8
Avatar Pengguna
I see what's going on with your code. Won't take more than an hour to fix this issue from what I see on your code.
$30 USD dalam 1 hari
5,0 (1 ulasan)
0,9
0,9

Tentang klien

Bendera UNITED STATES
Port Murray, United States
4,9
12
Memverifikasi Metode pembayaran
Anggota sejak Jan 3, 2007

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.