Kumaran1987

In this article, I'm gonna share about how to make login and register form with MS SQL database; 1. Flow Chart Logic 2. Normal Features 3. Form Designs Login Form Design Sign in Form Design Password Retrieve Form 4. Database Design and SQL queries and Stored Procedure Create new Database as "schooldata" create table registerdata (  ID int identity,  Username nvarchar(100),  Password nvarchar(100),  Fullname  nvarchar(100),  MobileNO nvarchar(100),  EmailID nvarchar(100)  ) select * from registerdata create procedure regis (  @Username as nvarchar(100),  @Password as nvarchar(100),  @Fullname as nvarchar(100),  @MobileNO as nvarchar(100),  @EmailID as nvarchar(100)  ) as begin insert into registerdata (Username, Password, Fullname, MobileNO,EmailID) values (@Username, @Password, @Fullname, @MobileNO, @EmailID) ...

1. Design Form  Steps: a. Choose Datagridview tool in tool kit b. Choose new datasource from datagridview c. After choosing particular database and data table the design of form will be look a like in this above acreenshot 2. Class view for data table  3. Code created automatically 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.Data.Sql; namespace DataDisplayForm { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'nameDBDataSet.namedata' table. You can move, or remove it, as needed. this.namedataTableAdapter.Fill(this.nameDBDataSet.name...

Methods Used: 1. Created a database as NameDB and Database table as namedata as follows. --table for saving retrieving datas create table namedata (  ID int identity,  Firstname nvarchar(500),  Secondname nvarchar(500),  Fullname nvarchar(500) ) --get  query result select * from namedata 2. Create a  stored procedure for saving data -- creating stored procedure for saving data create proc nameprocedure  @Firstname as nvarchar(500), @Secondname as nvarchar(500), @Fullname as nvarchar(500) as begin   SET NOCOUNT ON; Insert into  namedata(Firstname,Secondname,Fullname) values(@Firstname,@Secondname,@Fullname) end -- execute strored procedure exec nameprocedure 3. Windows Application design for save and Retrieve data form set formborderstyle as none 4. App.config settings to Connect database <?xml version="1.0"?> <configura...