Comments by Member 11052105

Member 11052105 12-Jan-15 1:13am View

Team_District(District_Id)

Yeah it is existed

Member 11052105 11-Jan-15 7:02am View

My stored procedure is

create procedure SP_InsertPoliticalLeaders
(
@SelectPosition nvarchar(100),
@State_Id int ,
@District_Id int ,
@Area_Id int,
@Village_Id int,
@IsPM bit,
@IsCM bit,
@IsCentralMinister bit,
@IsStateMinister bit,
@IsCorporator bit,
@IsActive bit,
@PartyName varchar(250),
@ImagePath nvarchar(Max),
@Name varchar(150),
@Position varchar(500),
@StartPeriod nvarchar(100),
@EndPeriod nvarchar(100),
@DOB nvarchar(150),
@PlaceOfBirth varchar(250),
@Religion varchar(50),
@Education nvarchar(500),
@PermenentAddress nvarchar(500),
@OfficialAddress nvarchar(500),
@MobileNumber nvarchar(15),
@EmailId nvarchar(100),
@Website nvarchar(500),
@Spouse varchar(150),
@Children nvarchar(100),
@PoliticalCareer nvarchar(max),
@ImportantPositions nvarchar(max),
@Achievements nvarchar(max)
)
as begin
insert into Team_PoliticalLeaders(SelectPosition,State_Id,District_Id,Area_Id,Village_Id,IsPM,IsCM,IsCentralMinister,IsStateMinister,IsCorporator,IsActive,PartyName,ImagePath,Name,Position,StartPeriod,EndPeriod,DOB,PlaceOfBirth,
Religion,Education,PermenentAddress,OfficialAddress,MobileNumber,EmailId,Website,Spouse,Children,PoliticalCareer,
ImportantPositions,Achievements)
values(@SelectPosition,@State_Id,@District_Id,@Area_Id,@Village_Id,@IsPM,@IsCM,@IsCentralMinister,@IsStateMinister,@IsCorporator,@IsActive,@PartyName,@ImagePath,@Name,@Position,@StartPeriod,@EndPeriod,@DOB,@PlaceOfBirth,
@Religion,@Education,@PermenentAddress,@OfficialAddress,@MobileNumber,@EmailId,@Website,@Spouse,@Children,@PoliticalCareer,
@ImportantPositions,@Achievements)
end

Please give me suggestion....

Member 11052105 11-Jan-15 2:43am View

Deleted

My table is

create table Team_PoliticalLeaders
(
Id int primary key identity(1,1),
SelectPosition nvarchar(100),
State_Id int foreign key references Team_States(State_Id),
District_Id int foreign key references Team_District(District_Id),
Area_Id int foreign key references Team_Area(Area_Id),
Village_Id int foreign key references Team_Village(Village_Id),
IsPM bit,
IsCM bit,
IsCentralMinister bit,
IsStateMinister bit,
IsCorporator bit,
IsActive bit,
PartyName varchar(250),
ImagePath nvarchar(Max),
Name varchar(150),
Position varchar(500),
StartPeriod nvarchar(100),
EndPeriod nvarchar(100),
DOB nvarchar(150),
PlaceOfBirth varchar(250),
Religion varchar(50),
Education nvarchar(500),
PermenentAddress nvarchar(500),
OfficialAddress nvarchar(500),
MobileNumber nvarchar(15),
EmailId nvarchar(100),
Website nvarchar(500),
Spouse varchar(150),
Children nvarchar(100),
PoliticalCareer nvarchar(max),
ImportantPositions nvarchar(max),
Achievements nvarchar(max),
)

Member 11052105 4-Jan-15 5:51am View

after clicking link the page was redirecting to another page,the link was not highlighting.

Member 11052105 21-Dec-14 4:37am View

i have got confused sir. how can i show a message(Please select your area) if user click the link without selecting area from dropdownlist,can you please attach the sample sir

Member 11052105 20-Dec-14 5:14am View

Hi sir ..i have a little confusion.

<img src="~/Images/@Student.Picture" alt="Student Picture" />

All the student details have to redirected to Profile page only.
if don't mind can you explain briefly

Comments by Member 11052105 (Top 6 by date)