Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / based on logged username to filter data in gridview
Ask Question

Based on logged username to filter data in Gridview

Munikumar G 8786 15 Feb 2012
Post is removed by the User.
asp.net asp.net
Updated 25 Feb 2012
Munikumar G
Munikumar G

Other

Good softwaresolution

Message

4 Answers

Chris Anderson
Chris Anderson 25 Feb 2012
Report Abuse
hi,
If you want to display data of logged in user, you have to create the following sql query:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:workbookConnectionString %>"
            SelectCommand="SELECT * FROM [clientDetails] WHERE ([id] = @id)">
            <SelectParameters>
                <asp:SessionParameter DefaultValue="" Name="id" SessionField="clientID" 
                    Type="Int32" />
            </SelectParameters>
</asp:SqlDataSource>

In the above query a session field is created (id) in which you have to pass the id of user in order to display data in gridview.
Thanks.
Munikumar G
Munikumar G 24 Feb 2012
Report Abuse

Hi,

This is my code

who has to login in the site display user details only on gridview.  

please send me the code asap.

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
AutoGenerateColumns="False" DataKeyNames="ApptId" DataSourceID="SqlDataSource1" 
CellPadding="4" ForeColor="#333333" GridLines="None" AllowSorting="True">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField DataField="ClientId" HeaderText="ClientName" 
SortExpression="ClientId" />
<asp:BoundField DataField="UserId" HeaderText="UserName"  
SortExpression="UserId" />
<asp:BoundField DataField="ApptTime" HeaderText="ApptTime" 
SortExpression="ApptTime" />
<asp:BoundField DataField="ApptDate" HeaderText="ApptDate" 
SortExpression="ApptDate" />
<asp:BoundField DataField="Duration" HeaderText="Duration" 
SortExpression="Duration" />
<asp:BoundField DataField="MOM" HeaderText="MOM" SortExpression="MOM" />
<asp:BoundField DataField="SalesExecutiveObjects" 
HeaderText="SalesExecutiveObjects" SortExpression="SalesExecutiveObjects" />
<asp:BoundField DataField="SalesProjection" HeaderText="SalesProjection" 
SortExpression="SalesProjection" />
<asp:BoundField DataField="NextFollowUpDate" HeaderText="NextFollowUpDate" 
SortExpression="NextFollowUpDate" />
<asp:BoundField DataField="ExecutedClosingDate" 
HeaderText="ExecutedClosingDate" SortExpression="ExecutedClosingDate" />
<asp:BoundField DataField="Remarks" HeaderText="Remarks" 
SortExpression="Remarks" />
<asp:BoundField DataField="StatusId" HeaderText="StatusName" 
SortExpression="StatusId" />
</Columns>
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<SortedAscendingCellStyle BackColor="#FDF5AC" />
<SortedAscendingHeaderStyle BackColor="#4D0000" />
<SortedDescendingCellStyle BackColor="#FCF6C0" />
<SortedDescendingHeaderStyle BackColor="#820000" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MarketingSheetConnectionString %>" 
SelectCommand="SELECT*FROM [Appointment]" ></asp:SqlDataSource>
Thanks
Munikumar G
Munikumar G 17 Feb 2012
Report Abuse
Post is removed by the User.
Anonymous User
Anonymous User 15 Feb 2012
Report Abuse

Hi,         

  In gridview display data as login username.

Thanks 

MuniKumar,

What you trying to ask?
 You can paste you code here.

Here I am providing some links related with datagridview in asp.net which might be useful for you.

1.    GridView Decoration in ASP.NET

2.   GridView inside GridView in ASP.NET(Nested GridView)

3.   GridView Control in ASP.Net

Thanks

MindStick Training