Open Visual Studio
Go to - File - New - Website - Select
Asp.Net Website – Name change – DbConnection - OK.
Next - Add To New Form - Go to Solution Explorer - Select Project Name - Right Click - Add - Add New Item - Click - Select -Web Form - Rename - Register.aspx - Click - ADD - Display The Form in Solution Explorer-Register.aspx
Next - Click Design Show like that Below
Next - Click Tool Box and then Select Label,TextBox,Button Double Click Show like that Below
Next - Click Tool Box and then Select Label,TextBox,Button Double Click Show like that Below
Next - Select Label or Textbox or Button Press F4 Button - Property Window Open
Property Window Change the Name Text = Name,
Like that Same For all Label and Button Press F4
Change Name for Text
Next - Add to the Database Go To-Solution Explorer -Project Name-Right Click-Add-Add New Item-Select Sql Server Database .mdf -Add-To Display Solution Explorer -First Load 1 Minutes After Display Database.mdf
Yes Button Click
Next - Select Table - Right Click - Add New Table -Click - Open Like that
Next - Fill Column Name to Required Column Name Like That Below
Id name want to Use or Delete right click Like that Below
Next - Visual Studio 2005,2008,2010 press save Button After Filling the Column Name Like that Below
Click Show Table1 delete after fill register -Next -Again Click Save Button
Visual Studio 2012 fill table name like that below
Next - Change Name from Table to register
Next - Click Update Button and Update DataBase Button Click
Next - Refresh Button Press
Next - Click Database -Table - register
Next - want to any update in Column name - Select - table - table name(register) - Right Click -Open Table Defination - Click-Show - Visual Studio 2005,2008,2010,2012 Like that Below
Next - want to Delete or Set Primary Key or New column Name Add
But Datatype Varchar(50) is Common for All
Varchar want increase Varchar(100)or Varchar(200) or Varchar(MAX)
Allow Null Values Remove
Same For All Visual Studio 2005,2008,2010,2012 Like that Below
Next - Sql Connection
Go to - Design Page register.aspx and Select -ToolBox - Select Data - Select SqlDataSource -Double Click Show Like That Below
If Did't Show SqlDataSource in Data use Below
Right Click - Select - Choose Items Select Required Tools Select like that Below
Required tools Selected After Click - OK Button Selected Files Show ToolBox
Next - Click SqlDataSource Aero (>) Mark Click Show Configuration Data Source and Click
Next - Select Database.mdf like that below
Next - Click - Next Button
Next - Click - Next - Button Press
Next - Select Table Name register and * Select and Press - Next Button
Next - Register.aspx Page Select SqlDataSource
and F4 press Property Window Open Connected Path Like that Below
Next - Go To - Solution Explore - Click Web.Config - Change Name From connection String to Dbcon
Change the Name
After Change Name Save and Close Web.config Go To Design Page register.aspx
Change the Name from connectionString to dbcon ( if your choice dbcon or else)
Next - Save and Go - To Register.aspx and Double Click Register Button Like That Below
Next - Add - NameSpaces for Library Function Calls Like that below
using system.data // access Datatable and Dataset
using system.data.sqlclient // access Sqlconnnection & sqlCommand
Next - Create - Database Connection Publically
SqlCommand cmd; // Create object for calling
SqlConnection con; // Create object for calling
SqlDataAdapter adp; // Create object for calling
DataTable dt; // Create object for calling
DataSet ds; // Create object for calling
string query; // Assign String Variable
Next - Insert Values to Database Table
Go to - Register.aspx page and then Double Click Register Button
Next - Coding For Insert Command
Above give the TextBox Id Name now Go To Register.aspx page give is name to TextBox
Now Change the Textbox Id to your Identification like that below
Same as all Textbox like that Below
Next - Go to - Coding Part register.aspx.cs
Given Insert Coding Completely
Next - Go To - register.aspx
Next - Run the Program to Press F5 or internet Explorer or Google Chrome (your default Browser)
Press - Ok - button Go To Browser (your PC Default Browser)
And
Enter Values & Register Button Click
Next - Register Button Click
IF Program without Error Pop Up Display
OR
IF Error Occurred Show Like that below Clear the Error
Next - Go To Coding Page register.aspx.cs
Clear the Error
Same Id Given Clear Below
Correct Order given to Id and Column Name
txtName.Text & txtMobile.Text & txtemail.Text Importants
After clear the Error Run The Program Click F5 or Google Chrome
Display POP UP
Show the Data Go to Database - Right Click - Table Show Table Data
Next - Close Register Table Go To Add New Form
After Show Solution Explorer Display.aspx
Next - Select Tool Box Add Button to Display Registered Data's
Go To Data-Select Data Grid View Select
Button Name Change to F4 Press - Property Windows open - Text Change to Dispaly
Display Button Double Click & Give Coding
Common For All Form Above DataBase Connection
And Select command Coding Below
Next - Run the Program Press F5
Click the Display Button Show the Data's Grid View
Error occurred Table Name Not Correctly given
Give the Correct Name
Run & display button Click Show the Output
Next - Update the Already Inserted Data's
Register.aspx Form Uses Update Button add
Double Click - Update Button - Write Coding
Run the Program
Insert values to TextBox and Update Button Click
Updated Values Display Display.aspx Form
Changed abcd Name mobile number & email Id
Delete Table
Next - Delete Particular Table Name from Register.aspx Form
Go To - Coding Part Double Click Delete Button
Run the Program to Delete
Give column name only Delete Particular Data
Delete Button Click Delete Values
Next - Display.aspx Run
0 comments:
Post a Comment