WorldWideScripts.net Delivering the best Add-Ons in more than 37 languages.

中文(简体), English, हिन्दी/हिंदी, Español/Castellano, العربية, Русский язык, Français, 中文 (台灣), বাংলা, Bahasa Indonesia, اردو, Português, Deutsch, Bahasa Melayu (بهاس ملايو‎), 日本語 (にほんご), فارسی, Italiano, తెలుగు, Türkçe, ગુજરાતી, Język polski/polszczyzna, Tiếng Việt, ಕನ್ನಡ, Українська мова, ไทย
.NET / Miscellaneous

Public Data Navigation

— Add-On to WorldWideScripts.net

Subscribe to our feed to stay up to date!

New! Follow us as you want it!


Public Data Navigation - CodeCanyon Item for Sale

Ads

Ad: Bluehost hosting

Follow me on Codecanyon

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:

  1. Change the parameter name of stored procedure
  2.  ( @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 
  3. Change the array of arr1 and arr2 in.cs file
  4.  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();
  5. Change the control name in design form aspx

Download
Other components in this categoryAll components of this author
CommentsFrequently asked questions and answers

Properties

Created:
3 January 13

Last Update:
N/A

Compatible Browsers:
IE7, IE8, IE9, Firefox, Chrome

Files Included:
Active Server Page ASPX, C# CS, SQL, HTML, CSS

Software Version:
.NET 2.0,.NET 3.0,.NET 3.5,.NET 3.7,.NET 4.0

Keywords

eCommerce, eCommerce, All Items, ado.net, asp.net, c-sharp, delete, filter, insert, n-tier programming, navigation data, sql, stored procedure, update