I use this Code for save TextBox Data into DataBase, but I have a Problem when I click save Button code run without any error and MessageBox Show "Recourd is saved",
but Data Not save in my DataBase,
I think Problem Not in My DataBase Connection Because My AutoNumber Code Work Fine
this is my Code
<configuration>
<configsections>
<sectiongroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
<section name="Project1.Properties.Settings">
<connectionstrings>
<add name="Project1.Properties.Settings.DataFileConnectionString"
connectionstring="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Data\DataFile.mdf;Integrated Security=True" providername="System.Data.SqlClient"/>
<startup>
<supportedruntime version="v4.0" sku=".NETFramework,Version=v4.5">
What I have tried:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Configuration;
using System.Data.SqlClient;
namespace Project1
{
public partial class NewStudantEntry : Form
{
public NewStudantEntry()
{
InitializeComponent();
}
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Project1.Properties.Settings.DataFileConnectionString"].ConnectionString);
private void NewStudantEntry_Load(object sender, EventArgs e)
{
Autonumber();
}
private void Autonumber()
{
string Query = "select MAX(StudantNumber) from StudantData";
SqlCommand cd = new SqlCommand(Query, con);
try
{
con.Open();
var cont = cd.ExecuteScalar();
var count = (cont == DBNull.Value ? 1 : Convert.ToInt32(cont) + 1);
txtStudantNumber.Text = count.ToString("000");
txtStudantNumber.Enabled = false;
}
finally
{
con.Close();
}
}
private void SaveRecord()
{
string cmdstring = "Insert into StudantData (StudantNumber, ApplicationDate, StudantName, FatherName, Address, Address1, MobileNo, SecMobileNo, City, District, State, PinCode, Remark, UserID) VALUES (@StudantNumber, @ApplicationDate, @StudantName, @FatherName, @Address, @Address1, @MobileNo, @SecMobileNo, @City, @District, @State, @PinCode, @Remark, @UserID)";
{
using (SqlCommand cmd = new SqlCommand(cmdstring, con))
{
con.Open();
cmd.Parameters.AddWithValue("@StudantNumber", txtStudantNumber.Text);
cmd.Parameters.AddWithValue("@ApplicationDate", dtpApplicationDate.Value.Date);
cmd.Parameters.AddWithValue("@StudantName", txtStudantName.Text);
cmd.Parameters.AddWithValue("@FatherName", txtFatherName.Text);
cmd.Parameters.AddWithValue("@Address", txtAddress.Text);
cmd.Parameters.AddWithValue("@Address1", txtAddress1.Text);
cmd.Parameters.AddWithValue("@MobileNo", txtMobileNo.Text);
cmd.Parameters.AddWithValue("@SecMobileNo", txtSecMobileNo.Text);
cmd.Parameters.AddWithValue("@City", txtCity.Text);
cmd.Parameters.AddWithValue("@District", txtDist.Text);
cmd.Parameters.AddWithValue("@State", txtState.Text);
cmd.Parameters.AddWithValue("@PinCode", txtPinCode.Text);
cmd.Parameters.AddWithValue("@Remark", txtRemark.Text);
cmd.Parameters.AddWithValue("@UserID", "Admin");
cmd.ExecuteNonQuery();
MessageBox.Show("Recourd is saved", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
con.Close();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
SaveRecord();
}
}
}