What’s Public Information Navigation?
Public information navigation is a template code with c-sharp language ADO.NET and SQL database that does procedures corresponding to choose, insert, replace, delete and clear out.
- Scale back the programming time
- Scale back this system code
- Appropriate with any sort
- N-tier programming
- SQl Server 2008 R2 or previous
- Visible Studio 2010 or previous
How one can use this product
It is vitally easy to make use of and the way in which of use this product is defined in assist file utterly.
For create database, desk and saved process you wish to have to run three queries as underneath which positioned in SQL folder :
In short you wish to have to exchange your box title via your want in 3 portions:
- Exchange the parameter title of saved process
- Exchange the array of arr1 and arr2 in .cs document
- Exchange the regulate title in design shape aspx
( @StatementType nvarchar(20) = '', @ID nvarchar(50)=Null, @Title nvarchar(50)=Null, @% nvarchar(50)=Null, @Birthday nvarchar(50)=Null, @Birthdayt nvarchar(50)=Null, @Married nvarchar(50)=Null, @Standing nvarchar(50)=Null, @Intercourse nvarchar(50)=Null ) AS BEGIN IF @StatementType = 'Insert' BEGIN insert into P_User ( [Name],[Pic],[Birthday],[Married],[Status],[Sex]) values ( @Title,@%,Convert(Date,@Birthday),@Married,Convert( bit,@Standing),@Intercourse) END
string spName = "__User_InsertUpdateDelete"; DataTable dt = new DataTable(); string arr1 = new string ; string arr2 = new string ; DataNavigate.GDao.DataNav(spName, arr1, arr2, out dt); gridviewupdate(); emptyform();