sir i was used my gridview asp.net 4.0 controls,,
-------------------------------------------------------------------
<table class="adminContent">
<KMMatrimony:AMIZGridView ID="gvEventMemberEntry" runat="server" AutoGenerateColumns="false"
Visible="true" Width="100%" AllowPaging="true" ShowHeaderWhenEmpty="true" EnablePersistedSelection="true"
DataKeyNames="Regno,ProcessFlag,Caste,Subsect" PageSize="20" EmptyDataText="No Records Found!">
<Columns>
<asp:TemplateField HeaderText="RegNo" ItemStyle-Width="8%">
<ItemTemplate>
<%#Server.HtmlEncode(Convert.ToString(Eval("RegNo")))%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name" ItemStyle-Width="15%">
<ItemTemplate>
<%#Server.HtmlEncode(Convert.ToString(Eval("FirstName")))%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Gender" ItemStyle-Width="10%">
<ItemTemplate>
<%#Server.HtmlEncode(Convert.ToString(Eval("Gender")))%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Process Flag" ItemStyle-Width="15%">
<ItemTemplate>
<%#Server.HtmlEncode(Convert.ToString(Eval("ProcessFlag")))%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</KMMatrimony:AMIZGridView>
</table>
this is mygridview....
sql stored procedure:
------------------------------
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[KMM_ViewEventRegistration]
@Regno varchar(8000)= NULL,
@ProcessFlag varchar(1)= 'A',
@Caste VARCHAR(1000) = NULL,
@Subsect VARCHAR(1000) = NULL
AS
BEGIN
IF (@ProcessFlag='' OR @ProcessFlag IS NULL)
set @ProcessFlag='A'
IF @ProcessFlag='A' OR @ProcessFlag='M'
BEGIN
IF (@regno='' OR @regno IS NULL)
begin
SELECT eventmemberentryprocessid ,
REGNO,
FIRSTNAME,
(select B.commonmastername from kmm_commonmaster B WHERE B.commonmasterid=A.GENDER) GENDER,
dbo.fn_getage( DATEOFBIRTH,getdate()) as AGE,
(select B.castename from kmm_caste B WHERE B.casteid=A.CASTE) CASTE,
(select B.subsectname from kmm_subsect B WHERE B.subsectid=A.SUBSECT) SUBSECT,
GOTHRAM,
(select B.starname from kmm_star B WHERE B.starID=A.STAR) STAR,
(select B.educationname from kmm_education B WHERE B.educationID=A.QULIFICATION) QULIFICATION,
QULIFICATIONDETAILS,
(select B.professionname from kmm_profession B WHERE B.professionID=A.PROFESSION) PROFESSION,
PROFESSIONDETAILS,
PHOTOGIVEN,
CREATEDDATE,
CREATEDBY,
TEMPNUMBER,
PROCESSFLAG,
RECORDSTATUS,viewed,ENTRYFROM FROM dbo.KMM_EventMemberEntryProcess A
WHERE recordstatus='A' AND PROCESSFLAG=@ProcessFlag and
(CASTE IN (select * from dbo.fnSplit(@CASTE ,',')) or (@CASTE is null or @CASTE='')) and
(SUBSECT IN (select * from dbo.fnSplit(@SUBSECT ,',')) or (@SUBSECT is null or @SUBSECT=''))
order by Entryfrom desc,regno asc
end
ELSE
begin
SELECT eventmemberentryprocessid ,
REGNO,
FIRSTNAME,
(select B.commonmastername from kmm_commonmaster B WHERE B.commonmasterid=A.GENDER) GENDER,
dbo.fn_getage( DATEOFBIRTH,getdate()) as AGE,
(select B.castename from kmm_caste B WHERE B.casteid=A.CASTE) CASTE,
(select B.subsectname from kmm_subsect B WHERE B.subsectid=A.SUBSECT) SUBSECT,
GOTHRAM,
(select B.starname from kmm_star B WHERE B.starID=A.STAR) STAR,
(select B.educationname from kmm_education B WHERE B.educationID=A.QULIFICATION) QULIFICATION,
QULIFICATIONDETAILS,
(select B.professionname from kmm_profession B WHERE B.professionID=A.PROFESSION) PROFESSION,
PROFESSIONDETAILS,
PHOTOGIVEN,
CREATEDDATE,
CREATEDBY,
TEMPNUMBER,
PROCESSFLAG,
RECORDSTATUS,viewed,ENTRYFROM FROM dbo.KMM_EventMemberEntryProcess A WHERE REGNO IN
(select * from dbo.fnSplit(@regno ,',')) and recordstatus='A' AND PROCESSFLAG=@ProcessFlag order by Entryfrom desc,regno asc
update KMM_EventMemberEntryProcess set viewed='Viewed' where REGNO=@regno
end
END
if (@ProcessFlag='M' AND @regno <> '' AND @regno IS NOT NULL)
begin
delete from dbo.KMM_EventMemberCurrentProcess;
insert into dbo.KMM_EventMemberCurrentProcess ( regno,createddate)
values (@regno,getdate())
end
IF @ProcessFlag='C'
SELECT eventmemberentryprocessid ,
REGNO,
FIRSTNAME,
(select B.commonmastername from kmm_commonmaster B WHERE B.commonmasterid=A.GENDER) GENDER,
dbo.fn_getage( DATEOFBIRTH,getdate()) as AGE,
(select B.castename from kmm_caste B WHERE B.casteid=A.CASTE) CASTE,
(select B.subsectname from kmm_subsect B WHERE B.subsectid=A.SUBSECT) SUBSECT,
GOTHRAM,
(select B.starname from kmm_star B WHERE B.starID=A.STAR) STAR,
(select B.educationname from kmm_education B WHERE B.educationID=A.QULIFICATION) QULIFICATION,
QULIFICATIONDETAILS,
(select B.professionname from kmm_profession B WHERE B.professionID=A.PROFESSION) PROFESSION,
PROFESSIONDETAILS,
PHOTOGIVEN,
CREATEDDATE,
CREATEDBY,
TEMPNUMBER,
PROCESSFLAG,
RECORDSTATUS,viewed,ENTRYFROM FROM dbo.KMM_EventMemberEntryProcess A WHERE REGNO IN
(SELECT REGNO FROM KMM_EventMemberCurrentProcess) and recordstatus='A' order by Entryfrom desc,regno asc
END
my usercontrol page in asp .net
----------------------------------------------------
private void BindGrid()
{
string regNo = string.Empty;
string processFlag = string.Empty;
string createdby = string.Empty;
string flag = string.Empty;
EventViewRegistrationService entryProcess = new BusinessLogic.Events.EventViewRegistrationService(AMIZConfig.ConnectionString);
IMultipleResults results = entryProcess.KMM_EventRegistrationInsert(regNo, processFlag, createdby, flag);
List<EventMemberEntryProcess> manualResultValues = results.GetResult<EventMemberEntryProcess>().ToList();
gvEventMemberEntry.DataSource = manualResultValues;
gvEventMemberEntry.DataBind();
}
i have no results above the code ..give me some idea...how can i bind my gridview using stored procedur asp dot net 4.0 C# sir....
