DataSource Controls :: Use The ADO.net To Retrieve The Basic Data In Details Or Grid View Of Logged In Person Using 3 - Tire Architecher
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
Similar Messages:
Jun 1, 2010
I have a method that retreives data from table and needs to display in details view. The method is give below: The problem I am facing is I did put some break points to figure out if all the lines are executed but the problem I am facing is that the compiler is not going in the while(reader.read()) loop(I have made to loop bold so that would be easy to locate) and hence unable to retreive data.
public static Workstation GetWorkstationByName(string workstationName)
{
Workstation computer = new Workstation();
string key = "workstation_workstation_" + workstationName;
if (workstationName == null)
return null;
if (SiteUtility.Cache[key] == null)
{
string con = SiteProvider.Instance.AltirisConnectionString;
List<Workstation> workstationlist = new List<Workstation>();
SqlConnection cn = new SqlConnection(con);
SqlCommand cmd = new SqlCommand("Select [Server] from vComputer where Name = '@workstationName';", cn);
cn.Open();
cmd.Parameters.Add("@workstationName", SqlDbType.VarChar).Value = workstationName;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Workstation ws = new Workstation();
ws.Server = reader["Server"] as string;
workstationlist.Add(ws);
}
string ADSPath = "LDAP://" + SiteProvider.Instance.DomainString;..............
View 3 Replies
Mar 18, 2010
iam using grid view.i am using in it one templete filed like image button.i want when i click on image.the id which i want to pass passes and new pop up window is open and shows details....can i use Row databound or RowCreated which is better to setting onclick event on each image...if i would success on this i get associate id,s of each row.
View 2 Replies
Apr 28, 2010
I have a vb.net page that has a editable detailsview. When a user wants to erase the data for a field, they highlight the data, and delete/backspace over it, and click update. However, the original data is still saved. If they are replacing the current data with new data, that works fine and updates/saves correctly. This problem only happens when the current data needs to be removed.
View 6 Replies
Feb 3, 2011
Iam using DETAILs VIEW TO insert data i have several controls inside Using sql datasouce to insert the data. How can i achieve this?
View 2 Replies
Feb 19, 2010
I am working to retrieve list of values from database according to the dropdownlist value in view page in asp.net using linq to sql.I am having the dropdown values as static values.I am using table view to display the details.
View 2 Replies
Mar 24, 2011
I have placed grid view in update panel with first row as empty and it is not bound with any data base. Rather I have bound grid view with data table. Whenever I click on 'Add New Row' button, a new row is created in grid view there by retaining the data field in old rows but my problem is whenever I click on save button, at that time data of first row is not retried but I can get the data that is filled in second row and onwards. I have saved my data table in session and again retrieving it after each post back.
Here is the code of my .aspx.cs page
[Code]....
View 1 Replies
Nov 25, 2010
I wan to retrieve spesific data from northwind and list in my compare page.
in the first page i used gridview with checkboxes. all selected values get with session and then
send to my second page. I can display this values in the page but how can i retrieve all product details from my northwind db i dont know.
here is my second page code behind.
[Code]....
and aspx page
[Code]....
View 3 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
May 27, 2010
i have a grid view with some coulmns like Name,Phone no etc with Edit,Delete column in grid view. I click a row in grid view to Edit,it goes another page where i can edit all fields .Once i update i redirect the page to gridview. I want the grid view to remain in that particular page say 4 of the grid view
View 5 Replies
Apr 11, 2010
I have a details view that appears when record is selected in a GridView. Can this details view be opened in it's own modal window that would allow me to use the full event model?
View 3 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
Aug 24, 2010
It happened to add an extra Gridveiw Header in row_databound event , It did worked fine on !Postback but disappered on Page.Postback . Quick google search guided me to move the event to Row_Created event and every thing is okay .
Can any expert post some pointers , differnces between grid row_created vs row_databount with some sample table data created dynamically behaviour of both the events in !Postback and page.Postback .
View 2 Replies
Feb 9, 2011
I am doing a online web application whereby user is able to enter in new template as well as search for template. The Add template is located outside the grid view and if user clicks on the button, it will load the grid view that is populated with data as there is a row of empty fields at the bottom. However when I click on the Add Template button, the grid view does not appear.
This is my business logic that I used it to search for records as well to click on the Add Template button to add in new records:
[Code]....
[Code]....
[Code]....
View 6 Replies
Jan 23, 2011
I was trying to incorporate a functionality in my ASP.NET such that a DIV tag which contains the Profile Navigation Menu should only be visible if a person is logged in. I know the condition on how to if the person is logged in or not but wanted to know the method to toggle the div tag on/off based on person's logged in status.
if(loggedin==yes)
{
//?
}
View 3 Replies
Jun 8, 2010
i have a grid view which displays only one value and i need to extract that value and display it in a textbox?
View 4 Replies
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
Jun 26, 2010
I'm trying to get a record to show up in a details view as part of a Master Details. I was able to get this to work by setting the visibility to true for the Details View in the Page Load event. I now want the details view to show up when the Select button is clicked in the GridView's template field using the onClick event for the button. I don't seem to be assigning the correct properties to get this to work though. what property I should use with this? I know I have to get it from the GridView and assign it to the details but haven't gotten it to work. this is the GridView:
[Code]....
View 4 Replies
May 14, 2013
How can we find the ip address of a person who has logged in?
View 1 Replies
Dec 22, 2010
I'm populating a grid view with data from an SQL datasource. The database has a a list of performing artists and lots of details. The gridview initially, shows the ArtisID (Primary key) , and artist name and music style. So far this is all simple and easy. This is done.
Now I want to be able to click on the ArtistId (Select Column) and move the customer to another page where I show indepth details about the artist. How do I do this???
In Vb.net I had a 'Celldoubleclick' event, and I redirect the client. But how do I accomplish the same in asp.net? I already have the primary key value
primekey = datagridview.selecteddatakey.value
View 4 Replies
Aug 12, 2010
I use a DetailsView to update data using an object data source. Everything works fine except the date time values
following is a the code of the object datasource and the details view binding:
[Code]....
when data reach my BLL class to update the fields the project id and project Title have the expected binded values from the details view edit template textboxes but the date value is the value of the item tempate's label box (EVAL)
View 2 Replies
Jan 9, 2011
How to retrieve the particular row of detailsview into textbox on page load event if details view defaultmode is readonly i want to retrieve the email id from detailsview email row in textbox1 on page load event ?
View 1 Replies
Jun 30, 2010
I'm getting some Xml back from a service. I would like it to be the datasource of a grid view on my aspx page. Here is a sample of the Xml
<?xml version="1.0" encoding="utf-16" ?>
<ArrayOfTripTollCompleteDC xmlns:xsi=[URL]"
xmlns:xsd=[URL]>
<TripTollCompleteDC>
<TripTollId>5</TripTollId>
<DMSLaneModeID xsi:nil="true" />
<HOVOnly>false</HOVOnly>
<CreateDateTime>2010-06-07T15:54:01.023</CreateDateTime>
<ConfigVTMSDelaySeconds>5</ConfigVTMSDelaySeconds>
</TripTollCompleteDC>
and here is my code that parses the xml and tries to bind the grid. What am I missing here?
var retVal = service.GetTripDetailsByTripID(tripId);
var xmlTrips = XDocument.Parse(retVal);
var tripTolls =
from t in xmlTrips.Elements("TripTollCompleteDC")
select new {
TripTollId = (int)t.Element("TripTollId")
, DMSLaneModeID = (int?)t.Element("DMSLaneModeID")
, HOVOnly = (bool)t.Element("HOVOnly")
, CreateDateTime = (DateTime)t.Element("CreateDateTime")
, ConfigVTMSDelaySeconds = (int)t.Element("ConfigVTMSDelaySeconds")
};
grdTripDetails.DataSource = tripTolls;
grdTripDetails.DataBind();
I realize these are anonymous types. Is that a problem? I have verified the service is returning the Xml as stated above. Can anyone out there point me in the right direction? Just for completeness, here is the grid markup <asp:GridView runat="server" ID="grdTripDetails" />
View 1 Replies
Jun 23, 2010
Have a GridView with a templated select button hidden and using
e.Row.Attributes.Add("onclick",Page.ClientScript.GetPostBackEventReference(this.grdMaster, "Select$" + e.Row.RowIndex.ToString())); to select a row .
When user like to update the datasource he will select one row from gridview then in selected indexchanged event i would display the selected row values beneath the form under the grid , Then user will update the contents displayed from grid and click an update button which is outside the grid . After updating the displayed row , i got to get the values of the next row in the grid and display them for next updation , i'e if users maually selects row 3 from grid then he can update the values using the update button and then on update click itself i'll have to display next row contents of row 4 and this process could go on .
View 3 Replies
Sep 29, 2010
I have a grid view that does add, edit update and delete. ( I draged the grid to the aspx page ) it is working. I would like to have the following : once I lick on edit, I open a form inside the grid view to edit the fields. How can I do that.
View 4 Replies
