Forms Data Controls :: Gridview Results By Date - Visual Studios Code Doesn't Work
May 27, 2010
I have a gridview that shows when something is check out. I would like to only show results from todays date and forward. I have done this in Expression Web but when I tried to use the same code in Visual Studios it doesn't work.
I have a gridview connected to my objectdatasource, i wrote a class for the database queries.Now when i do an update of record i get the id form the grid, when i click on delete i don't get the id, its 0.Is there an option to set the id? i can't find it in the gridview.
Im using File Upload Control in every row of a GridView.... Like tis
Name UploadFile textBox FileUpload TextBox FileUpload . . Submit
On Submit im first uploading all files present in the grid and then saving other values in database....No Problem when uploading Small Set of filesIf i browse more than 10(approx) files(i.e 10 files in 10 rows) and Submit... Internet Explorer-Page Cannot Be displayed Error occurs but no problem when uploading < 10(approx) files....
I have a GridView; one of the columns displays concatenated records from a tables. to extract the records that are going to be concatenated and put in this column, i have used: FOR XML path('') and it works just fine for displaying those records. the problem now is the whole gridview can not be sorted anymore and gives me a 404, document not found, error whenever i try to click the columns to sort. here is my select statement for my sql datasource select command:
SqlDataSource2.SelectCommand = "Select a1.*, keyword = substring( ( SELECT DISTINCT ', ' + keywordName FROM keywords JOIN key_mm_articles ON key_mm_articles.keywordID = keywords.keywordID WHERE key_mm_articles.articleID = a1.articleID FOR XML path(''), elements ),2,500) FROM articles a1 WHERE title LIKE '" & titles & "' Order By a1.articleID"
I'm using the code below to extract data from a gridview and populate it into textboxes for the days and two drop downs for Project and Category.
For some rows in the gridview everything but the category ddl populates correctly. If I click the row a second time the category ddl displays the correct category.
why I have to click twice for some rows? And how do I fix this?
I would like to know if there is a way to debug the gridview and work around the code that is behind it.Right now i'm getting an error when i try to modify a record with this control. So, if any of you guys know a way to get this done,
i have table that trace views of my page. every row has the id, date view (dd/mm/yyyy hh/mm/ss) how can i distinct the data into gridview (or something else) and display only the days (01/03/2011, 02/03/2001, 03/03/2011) and to sum the numbers of views (01/03/2011 1,290 views, 02/03/2011 867 views.....)
I have a datalist and want the results paged I have written a pager.ascx page and have an aspx and aspx.cs page to display the results. I have a stored procedure to pull the data out of the database and a class to talk between the stored procedure and presentation controls I have the pager being displayed when the results get over the limit I have set to 10 in the web.config file but when i click on the next link to display the next page of results it doesn't do anything. my aspx page is
<uc1:Pager ID="topPager" runat="server" Visible="False" /> <asp:DataList ID="newsList" runat="server" CssClass="List" align="center"> <ItemStyle CssClass="ItemList" /> <ItemTemplate> <h2><%# Eval("Title") %></h2> <p>Posted <%# Eval("Date") %></p> <p><%# Eval("News").ToString().Replace(" ", "<br />") %></p> </ItemTemplate> </asp:DataList> <uc1:Pager ID="bottomPager" runat="server" Visible="False" /> my aspx.cs page is protected void Page_Load(object sender, EventArgs e) { // Retreive page from the query string string page = Request.QueryString["Page"]; if (page == null) page = "1"; // How many pages of posts int howManyPages = 1; // pager links format string firstPageUrl = ""; string pagerFormat = ""; //DataAccess.GetNews returns a DataTable object containing news data which is read into datalist newsList.DataSource = DataAccess.GetNews(page, out howManyPages); // Bind the data to the data source newsList.DataBind(); // have the current page as interger int currentPage = Int32.Parse(page); // Display pager controls topPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, false); bottomPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, true); } my pager.ascx page is <p> Page <asp:Label ID="currentPagelabel" runat="server" /> of <asp:Label ID="howManyPageLabel" runat="server" /> | <asp:HyperLink ID="previousLink" runat="server">Previous</asp:HyperLink> <asp:Repeater ID="pagesRepeater" runat="server"> <ItemTemplate> <asp:HyperLink ID="hyperlink" runat="server" Text='<%# Eval("Page") %>' NavigateUrl='<%# Eval("Url") %>' /> </ItemTemplate> </asp:Repeater> <asp:HyperLink ID="nextLink" runat="server">Next</asp:HyperLink> </p> my pager.aspx.cs page is using System; // Simple struct that represents a (page number, url) association public struct PageUrl { private string page; private string url; // Page property definition public string Page { get { return page; } } // Url property definition public string Url { get { return url; } } // Constructor public PageUrl(string page, string url) { this.page = page; this.url = url; } } // The pager control public partial class UserControls_Pager : System.Web.UI.UserControl { protected void Page_Load(object sender, EventArgs e) { } // Show the pager public void Show(int currentPage, int howManyPages, string firstPageUrl, string pageUrlFormat, bool showPages) { // Display paging controls if (howManyPages > 1) { // make the pager visable this.Visible = true; // Display the current page currentPagelabel.Text = currentPage.ToString(); howManyPageLabel.Text = howManyPages.ToString(); // Create the Previous link if (currentPage == 1) { previousLink.Enabled = false; } else { previousLink.NavigateUrl = (currentPage == 2) ? firstPageUrl : String.Format(pageUrlFormat, currentPage - 1); } // Create the Next link if (currentPage == howManyPages) { nextLink.Enabled = false; } else { nextLink.NavigateUrl = String.Format(pageUrlFormat, currentPage + 1); } // Create the page links if (showPages) { // The list of pages and their URLs as an array PageUrl[] pages = new PageUrl[howManyPages]; // Generate (page, url) elements pages[0] = new PageUrl("1", firstPageUrl); for (int i = 2; i <= howManyPages; i++) { pages[i - 1] = new PageUrl(i.ToString(), String.Format(pageUrlFormat, i)); } // Do not generate a link for current page pages[currentPage - 1] = new PageUrl((currentPage).ToString(), ""); // Feed the pages to the repeater pagesRepeater.DataSource = pages; pagesRepeater.DataBind(); } } } } my class file is // Retreive the list of news posts public static DataTable GetNews(string pageNumber, out int howManyPages) { // Get a configured DbCommand object DbCommand comm = GenericDataAccess.CreateCommand(); // Set the stored procedure name comm.CommandText = "GetNews"; // create a new parameter for page number DbParameter param = comm.CreateParameter(); param.ParameterName = "@PageNumber"; param.Value = pageNumber; param.DbType = DbType.Int32; comm.Parameters.Add(param); // create a new parameter for products per page param = comm.CreateParameter(); param.ParameterName = "@PostsPerPage"; param.Value = PlatiumMindProductionsConfiguration.PostsPerPage; param.DbType = DbType.Int32; comm.Parameters.Add(param); param = comm.CreateParameter(); param.ParameterName = "@HowManyPosts"; param.Direction = ParameterDirection.Output; param.DbType = DbType.Int32; comm.Parameters.Add(param); // Execute the stored procedure and saven the results in a DataTable DataTable table = GenericDataAccess.ExecuteSelectCommand(comm); // Calculate how many pages of posts and set the out parameter int howManyPosts = Int32.Parse(comm.Parameters["@HowManyPosts"].Value.ToString()); howManyPages = (int)Math.Ceiling((double)howManyPosts / (double)PlatiumMindProductionsConfiguration.PostsPerPage); // return the page of posts return table; } my stored procedure is ALTER PROCEDURE [dbo].[GetNews] (@PageNumber INT, @PostsPerPage INT, @HowManyPosts INT OUTPUT) AS -- Declare a new table DECLARE @News TABLE (RowNumber INT, NewsID INT, Title NVARCHAR(50), Date DATETIME, News NVARCHAR(MAX)) -- Populate the table with the complete list INSERT INTO @News SELECT ROW_NUMBER() OVER (ORDER BY NewsID desc), NewsID, Title, Date, News FROM News -- return the total number of posts SELECT @HowManyPosts = COUNT(NewsID) FROM News -- extract the request page of posts SELECT NewsID, Title, DATE, News FROM @News WHERE RowNumber > (@PageNumber - 1) * @PostsPerPage AND RowNumber <= @PageNumber * @PostsPerPage
I have the gridview inside another gridview, i want to sort that both gridviews, I don't know how to achieve using asp.net 3.5 visual studio 2008 c# code behind. Following are my aspx page,
that aspx page contains gridview that contain one more gridview inside in it.Now i want to sort out both the grid i.e)claimgrid and Gdclmline1 i want code in c#.
I am trying to set the Backcolor of this TabPanel in code behind. But the color of the TabPanel is still white. I also tried the TabContainer with no success.
I have recently come across a problem that hopefully someone may be able to help me with. I have checked the FAQs regarding Logins but am unable to find my problem. Basically I have been working on a simple web application using C# on VS2008. The application contains a private folder which contains web forms that can only be accessed after logging in as admin. When I run this application through Visual Studios it works fine and I am able to login and view the private database pages.
I am trying to do some code where a user will be able to upload a .JPG picture from the users computer. I have put the controls and also written the C# code wich in my eyes seems to be correct. What happens in the code is that the uploaded picture will replace the existing "TopHeader.JPG" picture.
However when I run the code after I have choosen a .JPG picture from the desktop on my computer. Nothing happens except of a postback of the page.
I wonder what I can be missing out in order to make this work. (I attach both the HTML code and the C# code, I will be happy to know what I could be missing out)
I inherited a .Net website project. Except for just 3 .aspx.cs files, pretty much every other file is a .aspx file.
I don't see any .csproj or any .sln files.
If I want to load up this website on my localhost, how would I go about doing it? Am I supposed to load up Visual Studios and "import" these *.aspx.cs and *.aspx file?
I already successfully set up the SQL Server database and updated the web.config with the appropriate credentials.
I've got in a gridview with two EditItemTemplate, which are dropdownlist. for the fisrt one I need autopostback because it's used in the second.So to bind the second dropdownlist, I'm useing the GridView1_ItemUpdating, but it doesn't work. It never goes into this funktion and so on updating the column with the second dropdownlist has Null values.What's wrong?That's my code:
I'm trying to run the performance wizard on an ASP.Net website. However, whenever I try to start it I get the following error.
"The website contains unexpected information or you do not have permission to access the metabase. You must be a member of the Administrators group on the local computer to access the IIS matabase. Therefore, you cannot create or open a local IIS website. If you have Read, Write, and Modify Permissions for the folder where the files are located, you can create a file system website that points to the folder in order to proceed"
I am an Administrator on my machine. Tried googling but came up with nothing. Anyone run it before and know how to deal with it?