Skip to main content

Posts

Showing posts with the label Save and Retrieve Data

C# Windows Application Data Form sample Module: Save and Retrieve Data using MS SQL database

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...