My Radio Button Can'n Work Properly?

All Are There................

USE [master]

/****** Object: Database [student] Script Date: 23-02-2018 12.37.01 PM ******/

CREATE DATABASE [student]

CONTAINMENT = NONE

ON PRIMARY

( NAME = N'student', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\MSSQL\DATA\student.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )

LOG ON

( NAME = N'student_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\MSSQL\DATA\student_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )

ALTER DATABASE [student] SET COMPATIBILITY_LEVEL = 130

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))

begin

EXEC [student].[dbo].[sp_fulltext_database] @action = 'enable'

end

ALTER DATABASE [student] SET ANSI_NULL_DEFAULT OFF

ALTER DATABASE [student] SET ANSI_NULLS OFF

ALTER DATABASE [student] SET ANSI_PADDING OFF

ALTER DATABASE [student] SET ANSI_WARNINGS OFF

ALTER DATABASE [student] SET ARITHABORT OFF

ALTER DATABASE [student] SET AUTO_CLOSE ON

ALTER DATABASE [student] SET AUTO_SHRINK OFF

ALTER DATABASE [student] SET AUTO_UPDATE_STATISTICS ON

ALTER DATABASE [student] SET CURSOR_CLOSE_ON_COMMIT OFF

ALTER DATABASE [student] SET CURSOR_DEFAULT GLOBAL

ALTER DATABASE [student] SET CONCAT_NULL_YIELDS_NULL OFF

ALTER DATABASE [student] SET NUMERIC_ROUNDABORT OFF

ALTER DATABASE [student] SET QUOTED_IDENTIFIER OFF

ALTER DATABASE [student] SET RECURSIVE_TRIGGERS OFF

ALTER DATABASE [student] SET ENABLE_BROKER

ALTER DATABASE [student] SET AUTO_UPDATE_STATISTICS_ASYNC OFF

ALTER DATABASE [student] SET DATE_CORRELATION_OPTIMIZATION OFF

ALTER DATABASE [student] SET TRUSTWORTHY OFF

ALTER DATABASE [student] SET ALLOW_SNAPSHOT_ISOLATION OFF

ALTER DATABASE [student] SET PARAMETERIZATION SIMPLE

ALTER DATABASE [student] SET READ_COMMITTED_SNAPSHOT OFF

ALTER DATABASE [student] SET HONOR_BROKER_PRIORITY OFF

ALTER DATABASE [student] SET RECOVERY SIMPLE

ALTER DATABASE [student] SET MULTI_USER

ALTER DATABASE [student] SET PAGE_VERIFY CHECKSUM

ALTER DATABASE [student] SET DB_CHAINING OFF

ALTER DATABASE [student] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )

ALTER DATABASE [student] SET TARGET_RECOVERY_TIME = 60 SECONDS

ALTER DATABASE [student] SET DELAYED_DURABILITY = DISABLED

ALTER DATABASE [student] SET QUERY_STORE = OFF

USE [student]

ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;

ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET MAXDOP = PRIMARY;

ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = OFF;

ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET LEGACY_CARDINALITY_ESTIMATION = PRIMARY;

ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = ON;

ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET PARAMETER_SNIFFING = PRIMARY;

ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = OFF;

ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET QUERY_OPTIMIZER_HOTFIXES = PRIMARY;

USE [student]

/****** Object: Schema [db1] Script Date: 23-02-2018 12.37.01 PM ******/

CREATE SCHEMA [db1]

/****** Object: Schema [Iam] Script Date: 23-02-2018 12.37.01 PM ******/

CREATE SCHEMA [Iam]

/****** Object: Table [dbo].[stud] Script Date: 23-02-2018 12.37.01 PM ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[stud](

[studentId] [int] IDENTITY(1,1) NOT NULL,

[name] [varchar](30) NOT NULL,

[gender] [varchar](6) NOT NULL,

[brithDate] [date] NOT NULL,

[emailid] [varchar](50) NOT NULL,

[mobilenumber] [varchar](10) NOT NULL,

[status] [int] NULL,

[createOn] [datetime] NULL,

[modifyOn] [datetime] NULL,

PRIMARY KEY CLUSTERED

(

[studentId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

/****** Object: StoredProcedure [dbo].[studIUD] Script Date: 23-02-2018 12.37.01 PM ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE PROCEDURE [dbo].[studIUD]

(

@StatementType nvarchar(255)='',

@studentId int,

@name varchar(30),

@gender varchar(6),

@brithDate date,

@emailid varchar(50),

@mobilenumber varchar(10),

@status int,

@createOn datetime,

@modifyOn datetime

)

begin

if @StatementType ='INSERT'

begin

INSERT into stud (name,gender,brithDate,emailid,mobilenumber,status,createOn,modifyOn) values (@name,@gender,@brithDate,@emailid,@mobilenumber,@status,@createOn,@modifyOn)

end

else if @StatementType ='SELECT'

begin

SELECT * FROM STUD

end

else if @StatementType ='UPDATE'

begin

UPDATE stud set name=@name ,gender=@gender,brithDate=@brithDate, emailid=@emailid,mobilenumber=@mobilenumber,createOn=@createOn,modifyOn=@modifyOn where studentId=@studentId

end

else if @StatementType ='DELETE'

begin

DELETE stud where studentId=@studentId

end

USE [master]

ALTER DATABASE [student] SET READ_WRITE

create database student

use student

create table stud

(

studentId int Primary key IDENTITY(1,1),

name varchar(30) not null,

gender varchar(6) not null,

brithDate date not null,

emailid varchar(50) not null,

mobilenumber varchar(10) not null,

status int,

createOn datetime,

modifyOn datetime

)

CREATE PROCEDURE studentIUD

(

@StatementType nvarchar(255)='',

@studentId int,

@name varchar(30),

@gender varchar(6),

@brithDate date,

@emailid varchar(50),

@mobilenumber varchar(10),

@status int,

@createOn datetime,

@modifyOn datetime

)

begin

if @StatementType ='INSERT'

begin

INSERT into stud (name,gender,brithDate,emailid,mobilenumber,status,createOn,modifyOn) values (@name,@gender,@brithDate,@emailid,@mobilenumber,@status,@createOn,@modifyOn)

end

else if @StatementType ='SELECT'

begin

SELECT * FROM STUD

end

else if @StatementType ='UPDATE'

begin

UPDATE stud set name=@name ,gender=@gender,brithDate=@brithDate, emailid=@emailid,mobilenumber=@mobilenumber,createOn=@createOn,modifyOn=@modifyOn where studentId=@studentId

end

else if @StatementType ='DELETE'

begin

DELETE stud where studentId=@studentId

end

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dhimesh Parmar8y ago
Hello Manav Sir You Have A Solution Then Give Me
Dhimesh Parmar8y ago
Sir I Can Not perform Radiobutton Edit in GridView and also can'n perform editing of all filed of record
Manav Pandya8y ago
what problem exactly you are facing
Dhimesh Parmar8y ago
All Are There................

USE [master]
GO
/****** Object: Database [student] Script Date: 23-02-2018 12.37.01 PM ******/
CREATE DATABASE [student]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'student', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\MSSQL\DATA\student.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N'student_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\MSSQL\DATA\student_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO
ALTER DATABASE [student] SET COMPATIBILITY_LEVEL = 130
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [student].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [student] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [student] SET ANSI_NULLS OFF
GO
ALTER DATABASE [student] SET ANSI_PADDING OFF
GO
ALTER DATABASE [student] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [student] SET ARITHABORT OFF
GO
ALTER DATABASE [student] SET AUTO_CLOSE ON
GO
ALTER DATABASE [student] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [student] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [student] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [student] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [student] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [student] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [student] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [student] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [student] SET ENABLE_BROKER
GO
ALTER DATABASE [student] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [student] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [student] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [student] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [student] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [student] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [student] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [student] SET RECOVERY SIMPLE
GO
ALTER DATABASE [student] SET MULTI_USER
GO
ALTER DATABASE [student] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [student] SET DB_CHAINING OFF
GO
ALTER DATABASE [student] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [student] SET TARGET_RECOVERY_TIME = 60 SECONDS
GO
ALTER DATABASE [student] SET DELAYED_DURABILITY = DISABLED
GO
ALTER DATABASE [student] SET QUERY_STORE = OFF
GO
USE [student]
GO
ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET MAXDOP = PRIMARY;
GO
ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = OFF;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET LEGACY_CARDINALITY_ESTIMATION = PRIMARY;
GO
ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = ON;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET PARAMETER_SNIFFING = PRIMARY;
GO
ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = OFF;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET QUERY_OPTIMIZER_HOTFIXES = PRIMARY;
GO
USE [student]
GO
/****** Object: Schema [db1] Script Date: 23-02-2018 12.37.01 PM ******/
CREATE SCHEMA [db1]
GO
/****** Object: Schema [Iam] Script Date: 23-02-2018 12.37.01 PM ******/
CREATE SCHEMA [Iam]
GO
/****** Object: Table [dbo].[stud] Script Date: 23-02-2018 12.37.01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[stud](
[studentId] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](30) NOT NULL,
[gender] [varchar](6) NOT NULL,
[brithDate] [date] NOT NULL,
[emailid] [varchar](50) NOT NULL,
[mobilenumber] [varchar](10) NOT NULL,
[status] [int] NULL,
[createOn] [datetime] NULL,
[modifyOn] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[studentId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: StoredProcedure [dbo].[studIUD] Script Date: 23-02-2018 12.37.01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[studIUD]
(
@StatementType nvarchar(255)='',
@studentId int,
@name varchar(30),
@gender varchar(6),
@brithDate date,
@emailid varchar(50),
@mobilenumber varchar(10),
@status int,
@createOn datetime,
@modifyOn datetime
)
as
begin
if @StatementType ='INSERT'
begin
INSERT into stud (name,gender,brithDate,emailid,mobilenumber,status,createOn,modifyOn) values (@name,@gender,@brithDate,@emailid,@mobilenumber,@status,@createOn,@modifyOn)
end
else if @StatementType ='SELECT'
begin
SELECT * FROM STUD
end
else if @StatementType ='UPDATE'
begin
UPDATE stud set name=@name ,gender=@gender,brithDate=@brithDate, emailid=@emailid,mobilenumber=@mobilenumber,createOn=@createOn,modifyOn=@modifyOn where studentId=@studentId
end
else if @StatementType ='DELETE'
begin
DELETE stud where studentId=@studentId
end
end
GO
USE [master]
GO
ALTER DATABASE [student] SET READ_WRITE
GO
Dhimesh Parmar8y ago
schema are there

USE [student]
GO
/****** Object: Schema [db1] Script Date: 23-02-2018 12.34.57 PM ******/
CREATE SCHEMA [db1]
GO
/****** Object: Schema [Iam] Script Date: 23-02-2018 12.34.57 PM ******/
CREATE SCHEMA [Iam]
GO
Dhimesh Parmar8y ago
create database student
use student
use student
create table stud
(
studentId int Primary key IDENTITY(1,1),
name varchar(30) not null,
gender varchar(6) not null,
brithDate date not null,
emailid varchar(50) not null,
mobilenumber varchar(10) not null,
status int,
createOn datetime,
modifyOn datetime
)
CREATE PROCEDURE studentIUD
(
@StatementType nvarchar(255)='',
@studentId int,
@name varchar(30),
@gender varchar(6),
@brithDate date,
@emailid varchar(50),
@mobilenumber varchar(10),
@status int,
@createOn datetime,
@modifyOn datetime
)
as
begin
if @StatementType ='INSERT'
begin
INSERT into stud (name,gender,brithDate,emailid,mobilenumber,status,createOn,modifyOn) values (@name,@gender,@brithDate,@emailid,@mobilenumber,@status,@createOn,@modifyOn)
end
else if @StatementType ='SELECT'
begin
SELECT * FROM STUD
end
else if @StatementType ='UPDATE'
begin
UPDATE stud set name=@name ,gender=@gender,brithDate=@brithDate, emailid=@emailid,mobilenumber=@mobilenumber,createOn=@createOn,modifyOn=@modifyOn where studentId=@studentId
end
else if @StatementType ='DELETE'
begin
DELETE stud where studentId=@studentId
end
end
Dhimesh Parmar8y ago
In Zip File Table Code Are There