sqldatasource
How to programmatically iterate through pages of a GridView
I\'ve created a wallboard application to display outstanding support calls for my ICT department. I\'ve bound a number of gridviews to sqldatasources which execute a stored procedure. This is automate[详细]
2023-01-22 13:15 分类:问答Problem with ASP Repeater and SQL Data Source
Here\'s my data table in my SQL DB, and below that is the code for my Repeater control: ArticleID int NOT NULL,[详细]
2023-01-20 14:56 分类:问答gridview filtering via joined tables
I\'m trying to display data which comes from a join on two tables (or more) in a gridview I want to be able to filter the result set via user given input (text boxes on page)[详细]
2023-01-20 13:04 分类:问答Hiding/disabling ASP.NET controls when SqlDataSource is empty
I need t开发者_Python百科o be able to hide or disable a multitude of items (detailsviews, gridviews) when an SqlDataSource returns no rows. So if the page is reposted and no rows are selected, all the[详细]
2023-01-20 11:39 分类:问答Ways to detect changed account/no account found in ASP.NET/C#
I have an ASP.NET page where at the top of the page is a search box. There are 2 text boxes - one is an autocomplete extender for the Name on a database, and one is just inputting the ID.[详细]
2023-01-20 06:36 分类:问答What's wrong with my IF statement?
I\'m creating an auditting table, and I have the easy Insert and Delete auditting methods done. I\'m a bit stuck on the Update method - I need to be able to get the current values in the database, the[详细]
2023-01-19 14:22 分类:问答Returning PK of gridview when updating or inserting (ASP.NET, C#)
I require all changes such as inserts, updates and deletes to a table to be auditted, and I\'m using a simple SQLDataSource and GridView with automagically generated INSERT/UPDATE/DELETE statements. P[详细]
2023-01-19 14:08 分类:问答SqlDataSource1_Selected not working
I need to be able to change a Boolean variable if a datasource actually retrieves any data, so gridviews/detailsviews a开发者_如何学Cren\'t displayed. I\'ve placed all the data inside a PlaceHolder ta[详细]
2023-01-19 12:32 分类:问答Accessing rows PK after Insert (SqlDataSource)
I need to be able to get the primary key of an nserted row in C#, and so far I\'m unsure how. I\'ve put SELECT SCOPE_IDENTITY() into my SQL query, but how do I access this from the SqlDataSource_Inser[详细]
2023-01-18 21:54 分类:问答How to use User.Identity.Name as a parameter for SqlDataSource in ASP.NET?
For SqlDataSource I can configure the external source for the incoming paramater. For example it might be a QueryString, Session, Profile and so on.[详细]
2023-01-18 15:48 分类:问答