- Популярные видео
- Авто
- Видео-блоги
- ДТП, аварии
- Для маленьких
- Еда, напитки
- Животные
- Закон и право
- Знаменитости
- Игры
- Искусство
- Комедии
- Красота, мода
- Кулинария, рецепты
- Люди
- Мото
- Музыка
- Мультфильмы
- Наука, технологии
- Новости
- Образование
- Политика
- Праздники
- Приколы
- Природа
- Происшествия
- Путешествия
- Развлечения
- Ржач
- Семья
- Сериалы
- Спорт
- Стиль жизни
- ТВ передачи
- Танцы
- Технологии
- Товары
- Ужасы
- Фильмы
- Шоу-бизнес
- Юмор
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
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
Комментарии отсутствуют
Информация о видео
16 мая 2025 г. 23:46:12
00:07:07
Другие видео канала

