Sunday, August 25, 2019
Home > dotnet > Public Information Navigation

Public Information Navigation

Value: 7$
Ranking: zero

Follow me on Codecanyon

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.

Options

  • Scale back the programming time
  • Scale back this system code
  • Appropriate with any sort
  • N-tier programming

Necessities

  • 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 :

  • Create_DB.square
  • Create_Tbl.square
  • Create_SP.square

In short you wish to have to exchange your box title via your want in 3 portions:

  1. Exchange the parameter title of saved process
  2. (
    @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 
    
  3. Exchange the array of arr1 and arr2 in .cs document
  4.  
    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();
  5. Exchange the regulate title in design shape aspx

Purchase Now