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.
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;..............
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.
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.
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.
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.
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.
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
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?
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 ?
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 .
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:
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.
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.
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:
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
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)
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 ?
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" />
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 .
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.
