[ad_1]
hello guys I’m a newbie in MS visual studio and I want to make a database system that allows the user to insert, update, delete and search data using windows form application.
I already watched 3 tutorial how but I’m getting the same error. when I delete my “executenonquery()” it doesn’t have any error but the data I putted in my textbox is not inserted into my database. when I put it back I’m getting this kind of error
CODE:
`using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Threading.Tasks;
namespace EaglePlannersDatabase
{
public partial class Form1 : Form
{
SqlConnection connection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Adrian\Documents\EaglePlannersDataBase.mdf;Integrated Security=True;Connect Timeout=30");
public Form1()
{
InitializeComponent();
}
private void label1_Click(object sender, EventArgs e)
{
}
private void InsertButton_Click(object sender, EventArgs e)
{
connection.Open();
SqlCommand cmd = new SqlCommand("Insert Into EAGLEPLANNERS(policy number,plan type,renewal date,name,age,address,birthday,email,home/office number,mode of payment,ammount) values (@policy number,@plan type,@renewal date,@name,@age,@address,@birthday,@email,@home/office number,@mode of payment,@ammount)", connection);
cmd.Parameters.AddWithValue("@policy number", int.Parse(policyNumbertxtbox.Text));
cmd.Parameters.AddWithValue("@plan type", planTypetxtbox.Text);
cmd.Parameters.AddWithValue("@renewal date", int.Parse(renewalDatetxtbox.Text));
cmd.Parameters.AddWithValue("@name", nametxtbox.Text);
cmd.Parameters.AddWithValue("@age", int.Parse(agetxtbox.Text));
cmd.Parameters.AddWithValue("@address", addresstxtbox.Text);
cmd.Parameters.AddWithValue("@birthday", int.Parse(birthdaytxtbox.Text));
cmd.Parameters.AddWithValue("@email", (emailtxtbox.Text));
cmd.Parameters.AddWithValue("@home/office number", int.Parse(homeofficetxtbox.Text));
cmd.Parameters.AddWithValue("@mode of payment", (modeofpaymenttxtbox.Text));
cmd.Parameters.AddWithValue("@ammount", int.Parse(ammounttxtbox.Text));
cmd.ExecuteNonQuery();
connection.Close();
policyNumbertxtbox.Text = "";
planTypetxtbox.Text = "";
renewalDatetxtbox.Text = "";
nametxtbox.Text = "";
agetxtbox.Text = "";
addresstxtbox.Text = "";
birthdaytxtbox.Text = "";
emailtxtbox.Text = "";
homeofficetxtbox.Text = "";
modeofpaymenttxtbox.Text = "";
ammounttxtbox.Text = "";
MessageBox.Show("Record Inserted Successfully!");
}
}
}`
[ad_2]