Загрузка...

Registration Form using VS Code + SQL Server +SSMS | Beginner friendly | University Project| Easy

This is the code which I used in my form .
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Registration_Form__
{
public partial class Form1: Form
{
string connectionString = "Data Source=DESKTOP-8PCQ1Q8;Initial Catalog=REGISTRATION FORM;Integrated Security=True;";
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
LoadData();
}
private void LoadData()
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
try
{
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM myTable", conn);
DataTable dt = new DataTable();
adapter.Fill(dt);
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show("Error loading data: " + ex.Message);
}
}
}

private void button1_Click(object sender, EventArgs e)
{

using (SqlConnection conn = new SqlConnection(connectionString))
{
try
{
conn.Open();
string query = "INSERT INTO myTable (Name, Email, Phone, Gender, Address) VALUES (@Name, @Email, @Phone, @Gender, @Address)";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@Name", txtN.Text);
cmd.Parameters.AddWithValue("@Email", txtEmail.Text);
cmd.Parameters.AddWithValue("@Phone", txtPhone.Text);
cmd.Parameters.AddWithValue("@Gender", cmbGender.Text);
cmd.Parameters.AddWithValue("@Address", txtAdd.Text);
cmd.ExecuteNonQuery();

MessageBox.Show("Student registered successfully!");
LoadData();

txtN.Clear();
txtEmail.Clear();
txtPhone.Clear();
txtAdd.Clear();
cmbGender.SelectedIndex = -1;
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message);
}
}
}
}
}

Видео Registration Form using VS Code + SQL Server +SSMS | Beginner friendly | University Project| Easy канала Sania Mubasher
Яндекс.Метрика
Все заметки Новая заметка Страницу в заметки
Страницу в закладки Мои закладки
На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.
О CookiesНапомнить позжеПринять