How to use ExecuteScalar in Ado.Net with C#

How to use ExecuteScalar  in Ado.Net  with  C# create database test use test create table McaStudent(RollNo int identity(1,1),StudentId as 'Mca' + cast(RollNo asvarchar(10)),Name nvarchar(50),Gender nvarchar(50),Course nvarchar(50),Addressnvarchar(max)) insert into McaStudent values('Somesh', 'Male','B. Tech.','Kanpur')************************* using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; public partial class Registration :...

Read More

How to execute stored procedure in another store procedure

How to execute stored procedure in another store procedure --Create Database create database dbtest --Use Database use dbtest --Create table StudentDetails RollNo with primary key create table StudentDetails(RollNo int identity(1,1) primary key,Name nvarchar(50),Age int) --Create table FeeDetails RollNo relation with StudentDetails RollNo(foregin key) create table FeeDetails(RollNo int foreign key references StudentDetails(RollNo),Fee int) --Create...

Read More