Posts

Online Post Product

The Projects using web api to implemented (asp.net,sqlserver) Abstract: 1.Seller can interact with the  system to post the product 2.Buyer can interact with system to buy the product 3.Chat between two of them Singn up And Login using web api             1.Create sign_up page                       its used to be create and update new user in the system in the data base in sql server        2.Login page                   login with help user name or email and password 
Post a Comment
Read more

Stored procedures DONOT increase performance(.NET and SQL training video)

Image
Post a Comment
Read more

NEW TECHNOLOGY AND APPLICATION: NEW TECHNOLOGY AND APPLICATION: Stored Procedure ...

NEW TECHNOLOGY AND APPLICATION: NEW TECHNOLOGY AND APPLICATION: Stored Procedure ... : NEW TECHNOLOGY AND APPLICATION: Stored Procedure CURD Operation : Table Creation:  -->CREATE TABLE User  (     Id INT primary key NO...
Post a Comment
Read more

NEW TECHNOLOGY AND APPLICATION: Stored Procedure CURD Operation

NEW TECHNOLOGY AND APPLICATION: Stored Procedure CURD Operation : Table Creation:  -->CREATE TABLE User  (     Id INT primary key NOT NULL,   Name VARCHAR(50) NOT NULL,   Email_id VARCHAR(50)NOT NU...
Post a Comment
Read more

Stored Procedure CURD Operation

Image
Table Creation:  -->CREATE TABLE User  (     Id INT primary key NOT NULL,   Name VARCHAR(50) NOT NULL,   Email_id VARCHAR(50)NOT NUL   );  1.Table To Insert The data CREATE PROCEDURE [dbo].[InsertUser] (   @ID int,  @Name varchar(50),  @Email_id varchar(50) ) AS Begin insert into User(Id,Name, Email_id )values(@Id,@Name,@Email_id) END 2.Table To Delete The data CREATE PROCEDURE [dbo].[delete_all] (@ID INT) AS BEGIN       delete from   User where ID = @ID END 3.Table To Select The data ALTER PROCEDURE [dbo].[select_all] AS BEGIN SELECT * FROM [dbo].[User] END  4.Table To Select By Id The data ALTER PROCEDURE [dbo].[SelectById](@ID INT) AS BEGIN       SELECT * FROM User WHERE ID = @ID END 5.Table To Update Id The data ALTER PROCEDURE [dbo].[update_all] (@ID INT,@name varchar(50)) AS BEGIN       UPDATE  Userset...
Post a Comment
Read more
Image
Login And Sign Up Using Angular js with help of local storage 1.index.html <html ng-app='LogIn'> <head>     <meta charset="utf-8">     <meta http-equiv=="X-UA-Compatible" content="IE=edge">     <meta name="viewport" content="width=device-width, initial-scale=1">     <title>LOG IN</title>     <!-- styling css -->     <link href="assets/css/bootstrap.min.css" rel="stylesheet" />     <link href="assets/css/style.css" rel="stylesheet">     <link href="assets/css/font-awesome.min.css" rel="stylesheet">     <!-- min scripts -->     <script src="assets/js/angular.min.js"></script>     <script src="assets/js/angular-route.min.js"></script>     <script src="assets/js/jquery.min.js"></script>   ...
Post a Comment
Read more