Review Public Data Navigation (Miscellaneous)
Public Data Navigation (Miscellaneous) Description:
What is Public Data Navigation?
Public data navigation is a template code with c-sharp language ADO.NET and SQL database that does procedures such as select, insert, update, delete and filter.
Features
- Reduce the programming time
- Reduce the program code
- Compatible with any type
- N-tier programming
Requirements
- SQl Server 2008 R2 or earlier
- Visual Studio 2010 or earlier
How to use this product
It is very simple to use and the way of use this product is explained in help document completely.
For create database, table and stored procedure you need to run 3 queries as below which placed in SQL folder :
- Create_DB.sql
- Create_Tbl.sql
- Create_SP.sql
Briefly you need to change your field name by your need in three parts:
- Change the parameter name of stored procedure
- Change the array of arr1 and arr2 in .cs file
- Change the control name in design form aspx
( @StatementType nvarchar(20) = '', @ID nvarchar(50)=Null, @Name nvarchar(50)=Null, @Pic nvarchar(50)=Null, @Birthday nvarchar(50)=Null, @Birthdayt nvarchar(50)=Null, @Married nvarchar(50)=Null, @Status nvarchar(50)=Null, @Sex nvarchar(50)=Null ) AS BEGIN IF @StatementType = 'Insert' BEGIN insert into P_User ( [Name],[Pic],[Birthday],[Married],[Status],[Sex]) values ( @Name,@Pic,Convert(Date,@Birthday),@Married,Convert( bit,@Status),@Sex) END
string spName = "__User_InsertUpdateDelete"; DataTable dt = new DataTable(); string[] arr1 = new string[] { "@StatementType", "@ID", "@Name", "@Pic", "@Birthday", "@Married", "@Status", "@Sex" }; string[] arr2 = new string[] { "Insert", "", txt_Name.Text, FileUpload1.FileName, txt_birthday.Text, ddl_mar.SelectedValue, Convert.ToString(chk.Checked), rb_sex.SelectedValue }; DataNavigate.GDao.DataNav(spName, arr1, arr2, out dt); gridviewupdate(); emptyform(); Buy it Now