I have a gridview which sources information dynamically from database.
Here when i go for the default "AllowSorting" flag equal to true, i am able to achieve sorting of all displayed columns except the textBox control column whose values refreshes to zero.
So I have been trying to follow serenarules posts about persistence layers, but I seem to be missing something.
The persistence layer is an architectural layer whose job is to provide an abstract interface to information storage mechanism(s).
This makes sense to me, but I am still having a hard time with this.
So in what cases is this necessary? When you are pulling similar data from multiple information sources?
I need to display some data in a gridview. Its shipping data.
Part of the data can come from a generic database query. Static shipping data that can be looked up from the database. Part of the data is external and has to be queryed from USPS. Any suggestions on what is the best way to accomplish this.
Should I just programmatically fill the gridview from the code behind doing the database lookup manual and filling the gridview with manual data then going out and filling the rest of the gridview with the data obtained from the USPS service?
I m developing attendence report sheet into the gridview.My gridview content the textbox which i want load the data from the database on page load event.Plz anyone help me how can i set the textbox value from database.
View 2 Replieshow to change gridview cell value for a checked row without affecting any changes in database for ex if a row contains quantity of item 6 i want to change it value to 5,4 upto 0 that is on click event of delete quantity button i have identified row with a checkbox in grid view.
View 1 RepliesI have a website that displays information from my database into a gridview. The gridview has a checkbox, that once selected, is suppose to move a 'Y' into the field that has the checkbox selected. I have it generating the code, and displaying the code on my page to confirm, but the database is not being updated. Here is my code,
[Code]....
i have followed this article and created dynamic rows in gridview on button click: URL....Now i want to save the dynamically created rows data in database/
View 1 RepliesHow to retrieve selected value of dropdownlist in gridview when dropdown is added dynamically from database.
View 1 RepliesI am writing a currency converting module for one of our applications. I have a list of products, a list of currencies we are interested in seeing prices for, and a list of currency rates. I want the user to be able to select which currencies from the list they see in the GridView. I also want to be able to amend my list of currencies and include a new currency, without having to make additional changes to this module. So my GridView display has to be "dynamic". Essentially I am planning on ending up with a GridView that has the following columns:
Part No - Description - USD Price - AUD Price - GBP Price
The USD price would be static as it's our base currency, the AUD and GBP are user selected and could have potentially any number of currencies listed. I would normally use a DataSet and DataTables for this work, but I am sure there is a "better" way to do it using System.Collections.Generics. Right now I have all of the data I need in List collections, but there does not seem to be a way to define how these collections relate to each other, or combine these collections into one so it can be bound to a GridView. Should I be looking at something other than List to achieve this or do I need to go back to my original approach of a DataSet and DataTables.
**UPDATE / SOME CODE**
I will explain a little bit more about what I have setup so far.
1) List of Products & Currencies - These come from an SQL DB via LINQ, so they can be any of the System.Collections.Generics objects, e.g. List, IEnumerable etc.
2) Currency Rates - These I am pulling from the European Bank public XML file. I download the file, strip the data I need out of it and currently store that as a List object.
I could store the currency rates in the database table as well, but then I have to have some sort of background process that goes and updates the rates each day. This way the rates only get updated when someone accesses the report function (which is only going to happen occasionally). So I would rather grab the latest rates "on demand". What I know I need to end up with is some object that has the following structure:
PartNo - Description - Base Price - Currency Price 1, Currency Price 2, Currency Price 3
Where the number of Currency Prices is undefined, as it's based on what currencies the user wants the report to display. It's the undefined part that I am struggling with, essentially how can I create a structured object, that I don't know the complete structure of until runtime?
I have a stored procedure written using dynamic SQL in the SQL Server and I am calling it on the code behind and adding parameters to it and filling a dataset and binding the data set to a Gridview. But I am getting this error when I bind it.
Can someone please tell me how to fix this?
It used to work fine when I did not use dynamic sql.
Line 237: da.Fill(ds);Line 238: gviewInvestigations.DataSource = ds;Line 239: gviewInvestigations.DataBind();Line 240: Line 241: }
Source File: s:Cybage2CybageSourceCodeGulfcoastGulfcoastControlsInvestigationsControl.ascx.cs Line:
239
Stack Trace:
[Code]....
[HttpException (0x80004005): The IListSource does not contain any data sources.] System.Web.UI.DataSourceHelper.GetResolvedDataSource(Object dataSource, String dataMember) +8665698 System.Web.UI.WebControls.ReadOnlyDataSource.System.Web.UI.IDataSource.GetView(String viewName) +41 System.Web.UI.WebControls.DataBoundControl.ConnectToDataSourceView() +128 System.Web.UI.WebControls.DataBoundControl.GetData() +4 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +60 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73 System.Web.UI.WebControls.GridView.DataBind() +4 Controls_InvestigationsControl.bindSearch() in s:Cybage2CybageSourceCodeGulfcoastGulfcoastControlsInvestigationsControl.ascx.cs:239 Controls_InvestigationsControl.btnSearch_Click(Object sender, EventArgs e) in s:Cybage2CybageSourceCodeGulfcoastGulfcoastControlsInvestigationsControl.ascx.cs:323 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
i wan to use gridview to display that few products that belong to that particular staff only instead of showing all available products in the whole datase
View 7 RepliesI want to have one datagrid use two different data sources, the two datasaet I use have all the same cloumn names, the only difference is that the come form different databases. I wan tto have the data source be chosen by a dropdown list box. Is this possible or do I have to use two datagrid and just make on invisiable as needed.
View 1 RepliesI have a button on info.aspx and I would like a situation whenever the button is pressed to display two gridview containing certain information on a new web page called full_info.aspx.
View 5 Repliesso I know that DataTables are often used as the DataSources for gridviews. Lately, I have found that I can also use generic lists as data sources for gridviews. But I figured that out by simply trying it to see if it worked.
I have looked all over the web and simply cannot find any kind of inclusive list or description of exactly which data structures can be used as the data source for a gridview. Does anyone know if there is such a list, or some kind of reference that I can look to for this info?
Although it sounds like an obvious question, like there is obviously one out there and I just haven't looked, my experience has been that it's just not so.
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"
I am using an SQL Express server hosted on a different machine and it is listed in my server explorer just fine. It is listed as my connection string in my web.config just fine as well and lastly it seems to sync just fine with my asp.net membership tables. My question is does it need to be listed in my app data folder of my site? Currently I have the ASPNETDB.mdf connection listed, which is apparently just a local sql express connection. The database I am using in my webconfig and other files is not listed so do I need to add it there?
Second question is about DAL, Data Access Layers. I have mostly been using presentation level SQL commands with my data presentation controls. Manually entering separate select, insert and update statements. I just went through a tutorial that stated the best way to interact with your database in asp.net is with DAL using table adapters. It mentioned that it gives you the ability to use strongly-typed references to each row. My question is can I use the same method multiple times on a single page. For instance a method inside an adapter named GetProductsByID(@ID) ? What if I want this bound to three different gridviews on a single page? Anyone have any other general things to point out about using DAL over presentation level commands?
I build a webpage to edit the data entry, all the textbox wroks fine. However when I update the value originally took in using dropdown list , I get error and couldn't get correct update.
View 2 RepliesI have searched and have found master detail tutorials.found other sites with links to controls you have to buy but i thought some time back i saw a great tutorial on building this setup and it was somewhat pretty simple and detailed in steps.
Here is what im trying to do and maybe someone can point me in the right direction to links or suggestion on controls to use that may already exist that are free,We have a search page that i have setup to handle a number of different searches as well as differnet result views..we have 1 search that returns/needs to return alot of details.to much for a gridview layout.Currently i have it setup to return to
a formview and paging each record.BUT at the moment,in our test server we have over 400 records.so no one is going to page thru 400 records.so the 2 methods used are not going to work for us.so after meeting and discussing it.we want to see if the following can be accomplished in a practical way.
We want to setup the results to be returned initially in a gridview.. ( just a few key columns,kinda high level view ).then if you want to view details about any specific record,you can click on it or select it and the row is expanded to display the rest of the details.this will allow us to display all 400 records.25 or so per page of the gridview and allow them to chose what they want to see in more details.
Like i said i found a few examples online already,but not all of them are really detailed in the steps.so can anyone suggest a good source for accomplishing something like this.what would be cool.if possible is to open the formview that is already built under the selected record.kinda like CollapsiblePanelExtender that is within ajax
store textbox(inside the gridview) information in single variable"
View 3 RepliesI need to create a query which does a join between two tables which are in different databases. I can easily connect to each database, and write queries in each, however, I can't seem to find a way of generating a query which does a join between two tables from different databases.
View 2 RepliesScenario : I want to add data from database to checklistbox on page_load and checked data should be stored in other table.I want to bind data to checklistbox like a gridview, i m trying but i m not able to.
View 2 RepliesI would like to find out if there is anyone who would know how to read from a database then returns the same number of records that a stored procedure returns and display those records on the webpage there after pass the ID of the record to a variable to another stored procedure that displays the data related to the record that was clicked, I tried doing this in a asp.net repeater but I can't seem to be able to reference the controls inside the repeater.
<Repeater HTML Code>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="OpenLogs.aspx.cs" Inherits="OpenLogs" EnableEventValidation="false" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
[Code]....
I just installed the SmallBusiness Starter kit from MSDN. I believe the starter kit by default points to MDF and LDF files in App_Data folder but I would like to use my SQL server instead. Could you please provide me with instructions on how to convert these two files in actuate tables in SQL server?
View 5 Replieshow can i dynamically insert datas from database into Table and display the table
View 1 RepliesI have a nested gridview dynamically added. It seems I resolved all issues with the loading this control on a parent page along with other controls and I can trigger the edit of the first level - the master part of the gridview. However, I cannot trigger the edit on a child gridview.
OnRowEditing="grdChildGridEdit_RowEditing"
The master and the child gridviews have objectdatasources in a markup but I have to do the additional data binding after the loading the control on the parent page (see the code below). I'm doing that additional data binding only for the master gridview that is working fine and shows the data for the master and the child gridviews. When I click the Edit button on the master gridview it shows text boxes for the editing but when I click the Edit button on the child gridview it's doing nothing and moreover the editing mode for the master gridview is going back to the initial stage (labels).
I was trying to trigger it throughuse the registering the event:
[code]....