Data Controls :: How To Show Only Logged In User Details In GridView
Dec 12, 2013
I hv used datagridview control to show specific details about users health infomation. what i want to achieve is that when a user logs in he should be displayed only dat information which he had added in data grid view.... bt as in nw whenever i login i m able to display all the info. present in the db.... m using asp.net vb and sql server 2008.
View 1 Replies
Similar Messages:
Nov 2, 2010
Im making a gridview that need to show the information of a user that is logged in, but i got the "?" ERROR whole the time.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
View 1 Replies
Apr 12, 2010
I have on a page a gridview that can be filtered with one text box. I set up the gridview to show select and wanted to then connect a details view so that when you selected a row the entire details would show up. When I run it I get this error. Data keys must be specified on GridView 'GridView1' before the selected data keys can be retrieved. Use the DataKeyNames property to specify data keys.
<%@ Page language="C#" masterpagefile="MainContent.master" title="Electrical Storage" EnableEventValidation="false" %>
<asp:Content id="Content1" runat="server" contentplaceholderid="Content">
<div id="Rightside">
<h2>Search Electrical Storage
</h2>
<li><a href="EStorageResultsAll.aspx">View All Files</a></li>
<li>Specify Projects to View</li>
<br />
<br />
<form>
Search: <asp:TextBox id="Search" runat="server"></asp:TextBox>
(% is wildcard)<br /><br />
<asp:Button runat="server" Text="Search" id="Button1"
PostBackUrl="electrical_storage.aspx" Height="26px" BackColor="#000066" ForeColor="White" Width="129px"></asp:Button>
<br />
<hr />
<asp:GridView id="GridView1" runat="server" AutoGenerateColumns="False" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" DataSourceID="AccessDataSource1" ForeColor="Black" Width="820px" AllowSorting="True">
<RowStyle BackColor="White" />
<Columns>
<asp:commandfield ShowSelectButton="True">
</asp:commandfield>
<asp:boundfield DataField="CoID" HeaderText="Co ID" SortExpression="CoID">
</asp:boundfield>
<asp:boundfield DataField="ProjClass" HeaderText="Project Class" SortExpression="ProjClass">
</asp:boundfield>
<asp:boundfield DataField="Project" HeaderText="Project" SortExpression="Project">
</asp:boundfield>
<asp:boundfield DataField="FileName" HeaderText="File Name" SortExpression="FileName">
</asp:boundfield>
<asp:boundfield DataField="FileAddInfo" HeaderText="File Add Info" SortExpression="FileAddInfo" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="FileNumber" HeaderText="File Number" SortExpression="FileNumber" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="BoxNumber" HeaderText="Box Number" SortExpression="BoxNumber" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="Location" HeaderText="Location" SortExpression="Location" Visible="False">
</asp:boundfield>
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000066" Font-Bold="True" ForeColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="\Elec1DATABASEStorageElectricalFilesBook.mdb" SelectCommand="SELECT [CoID], [ProjClass], [Project], [FileName], [FileAddInfo], [FileNumber], [BoxNumber], [Location] FROM [FilesWithLocation]
WHERE (([CoID] LIKE '%' + ? + '%') OR ([ProjClass] LIKE '%' + ? + '%') OR ([Project] LIKE '%' + ? + '%')OR ([FileName] LIKE '%' + ? + '%')OR ([FileAddInfo] LIKE '%' + ? + '%')OR ([BoxNumber] LIKE '%' + ? + '%'))">
<SelectParameters>
<asp:controlparameter ControlID="Search" Name="CoID" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="ProjClass" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="Project" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileName" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileAddInfo" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileNumber" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="BoxNumber" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource id="AccessDataSource2" runat="server" DataFile="\Elec1DATABASEStorageElectricalFilesBook.mdb" SelectCommand="SELECT * FROM [FilesWithLocation] WHERE ([SearchString] = ?)">
<SelectParameters>
<asp:controlparameter ControlID="GridView1" Name="SearchString" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:DetailsView id="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="AccessDataSource2" Height="50px" Width="442px">
<Fields>
<asp:boundfield DataField="CoID" HeaderText="Company ID" SortExpression="CoID">
</asp:boundfield>
<asp:boundfield DataField="ProjClass" HeaderText="Project Class" SortExpression="ProjClass">
</asp:boundfield>
<asp:boundfield DataField="Project" HeaderText="Project" SortExpression="Project">
</asp:boundfield>
<asp:boundfield DataField="FileName" HeaderText="File Name" SortExpression="FileName">
</asp:boundfield>
<asp:boundfield DataField="FileAddInfo" HeaderText="File Additional Info" SortExpression="FileAddInfo">
</asp:boundfield>
<asp:boundfield DataField="PeriodBegin" DataFormatString="{0:d}" HeaderText="Period Begin" SortExpression="PeriodBegin">
</asp:boundfield>
<asp:boundfield DataField="PeriodEnd" DataFormatString="{0:d}" HeaderText="Period End" SortExpression="PeriodEnd">
</asp:boundfield>
<asp:boundfield DataField="FileType" HeaderText="File Type" SortExpression="FileType">
</asp:boundfield>
<asp:boundfield DataField="FileNumber" HeaderText="File Number" SortExpression="FileNumber">
</asp:boundfield>
<asp:boundfield DataField="BoxNumber" HeaderText="Box Number" SortExpression="BoxNumber">
</asp:boundfield>
<asp:boundfield DataField="SearchString" HeaderText="Search String" ReadOnly="True" SortExpression="SearchString">
</asp:boundfield>
<asp:boundfield DataField="Location" HeaderText="Location" SortExpression="Location">
</asp:boundfield>
</Fields>
</asp:DetailsView>
</form>
</div>
</asp:Content>
<asp:Content id="Content2" runat="server" contentplaceholderid="head">
<style type="text/css">
table {
width: 820px;
}
.gridview {
width: 820px;
position: fixed;
}
</style>
</asp:Content>
View 5 Replies
Aug 26, 2010
I want to show all the activities of the logged in user in a gridview. I am using VS 2010.
View 3 Replies
Jan 13, 2010
i have a login form where it validates 'username' and 'password' against a datbase table. After a user logs in, i would like to show their details such as image, name, etc in a detailsview.
View 16 Replies
Mar 22, 2011
I new to ASP.net and have created the registration form and login using the wizzard. This data is now stored in the relevent tables provided by asp. I also have created an extra table with profile information like address, phone number etc and a USer ID field that links with the aspnet_users table.
I am trying to display the details of the user when they log in so for example...
User logs on, clicks profile page, profile information can be added and viewed.
Now the problem is I am using a Select statement to get the data but when I do a Where statement im not sure what to put to basically say where userid = current user id logged on.
View 5 Replies
Sep 20, 2015
I have tried your script when loaded more rows in Gridview, multiple panels are getting open onwards 2nd row button click of gridview.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Panel3.aspx.cs" Inherits="pnlCallback.Panel3" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
[code]....
View 1 Replies
Sep 6, 2010
In an asp.net webform app, I need to restrict the logged in user to show data only for their company. This is a primary key of my topmost table. How to I set that based off the user. I imagine I would have another table with some user ID mapped to company ID?
View 1 Replies
May 7, 2015
I have a Gridview in my form(c#) and used Textbox to Bind values to gridview cells.i need to Show One of the coloumn value which is in textbox in Popup.while click the cell the popup should show the cell value.
View 1 Replies
Apr 25, 2014
I have Gridview in UpdatePanal but their is problem with template field
<asp:TemplateField HeaderText="EDIT">
<ItemTemplate>
<asp:LinkButton ID="lnkEdit" runat="server" ToolTip="Edit Unit" OnClick="lnkEdit_Click"
CausesValidation="False"><img src="IMG/screw-driver.png" alt="" /></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
and link button click event is
protected void lnkEdit_Click(object sender, EventArgs e)
{
GridViewRow clickedRow = ((LinkButton)sender).NamingContainer as GridViewRow;
ScriptManager sm = (ScriptManager)Page.Master.FindControl("smanager");
sm.RegisterPostBackControl(clickedRow);
lblUnitID.Text = clickedRow.Cells[0].Text;
txtUnitName.Text = clickedRow.Cells[1].Text;
txtDecimal.Text = clickedRow.Cells[2].Text;
btnUnit.Text = "Update";
}
but text box value is not set but when we do it in PostBackTrigger is work.
can we do this AsyncPostBackTrigger.
View 1 Replies
Jun 7, 2012
i have logged in using a login control
how can i transfer the login details to all other pages and how can i logout
View 1 Replies
Jun 16, 2015
I am referring below url , there is one column which has some large data i dont want to show in grid, but on clicking show detail i want to show detail in Modal Popup, right now it shows blank data, is there any solution for it. URL..
View 1 Replies
Dec 18, 2013
How to show Gridview selected row in popup using Jquery asp.net 2010
View 1 Replies
Jan 4, 2011
I'm new with programming. I have a GridView that have the specific user data. When the user log in I retrieve the data for that specific user. All I need is; How do I make the gridview get the data of the logged user using a datatable that has a query. Just bind it with the datatable.This is some code that other programmer made, I continue his work.
[Code]....
View 3 Replies
Mar 11, 2011
I have a gridview control with a details column. I want the user to click details and it give me a pop-up showing details of the particular row. Any idea on how to do this using JQuery?? Looking for an example with code..
View 1 Replies
Apr 14, 2014
I gone through your "Display details of ASP.Net DataList Item in jQuery Dialog Modal popup on button click" Example it is very nice but i want to Display image also With the information it can display i assign image src like
$("#imgpopup").html($("[id*=img]", $(this).closest("tr")).html());
imgpopp is the id belong from pop up. But Image canot be Display I tried it from te last Five Days. How to assign image source.
View 1 Replies
Feb 22, 2010
I try to use the ADO.net to retrive the basic data in details view or gride view of logged In person using 3-tire architecher. I don't want to use LINQ.
EmployeeBLL
EmployeeDLL
and basic information. after login user while click on the basic information page he will able to see his details only. do i need to bound the details in DLL class file if it is so giude me through sample page coding or or we can join the remote support using team viewer so you can guide me from the web also.
View 2 Replies
Jan 13, 2011
Just starting from starter program in VS 2010 there are link/tabs like "Home" and "About". I intend to add additional tabs like "Settings" and "Contacts". What is the best way to make these invisible until the user has registered or logged in?
View 5 Replies
Jan 20, 2014
I have a gridview which display when person start n stop the project if same person do muliple projects it save n retrives eaisly i want to do that when i press select in gridview it give me the all about the person means if ali is working on 2 projects so it give me details like ali firsrt project is this time n date this , second project is this how can i do this ?
View 1 Replies
Jan 5, 2012
I am have done a basic asp.net application User Module with out using any authentication classes.
Now I need to store last user login details in my asp page when user performs any operation. and need to show to other User who next login that ( the last user has made changes before ).
View 1 Replies
Jan 8, 2011
My goal is to load a row details from db to a webform and let the user update it's value .
The user searches an id (i have a stored procedure for that), how i show that data from the row nicely in the web page through the dal layer. After the data is shown on the page the user need to update a cell in the row and send it.(the part of updating is not the problem).
in other questions how should the dal method should look and how i integrate it's result in the presentation layer (the aspx webform).
View 2 Replies
Aug 31, 2010
<asp:templatecolumn headertext="Purchase Order">
View 4 Replies
May 30, 2010
I have a datalist bound to a sql source having two columns: Name and Description. The datalist contains a "Show Description" link as follows on clicking on which it calls the javascript which shows the description div.
[Code]....
The asp.net page source for itemtemplate of the datalist is as follows.The problem is that since the div id "Description" is applicable to multiple records, no matter I click on whichever "show details" link, the description of first record in the datalist is shwon and hidden since its the first div encountred by the javascript. In other words, I want a way to show/hide the description of each record in datalist indivigdually.
[Code]....
View 8 Replies
Oct 5, 2013
How to show datalist item details in jquery popup window...
View 1 Replies
Mar 15, 2011
In my project i have a need to select some check boxes in a GridView and show the details in another gridview. I use an arraylist to keep all the values of the checkbox using the foreach loop, but i can't able to display the records in another Grid view.
View 1 Replies