I have an Access db on webserver. In my ASP webpage I need to return the sum of rows which match criteria.
I am not sure where the sum needs to happen. I tried sum in the sql statement, but got an error when it tried to put it in asp page.this is what I have
strSQL = "Select * from tblApplicantCreditors where ApplicantID = '" & strApplicantID & "'"
i have gridview and having few rows. each rows have checkbox,textbox,combo in each column. how can i loop through gridview using jquery and access each elements in rows in loop for collection the value at client side by jquery.
View 3 RepliesI am trying to create a DataReader to return a counted value from an Access Database. It all works if it finds some rows, but falls apart when there is no total.
My code is as follows (highlights);
[Code]....
The error that gets thrown is:
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IndexOutOfRangeException: BoxesOut
Source Error:
Line 43: if(reader2["BoxesOut"] != System.DBNull.Value)
So I am using C# ASP.NET 3.5 and I would like to add a feature to my site to turn on and off a sort of debug mode for testing purposes.
Is there a best way to have a file or class that stores or returns simply if myDebug is on or off. It has to be accessed fast since it will be used a lot on multiple pages and it should be easy to set using the website itself.
My first thought is just a class with get/set which is stored on every page... perhaps the master page?
I'm using LINQ to query my database, and I don't want all the records returned all at once. Instead, user should be able to select Next 5 and Previous 5 using buttons. As of this moment I have selected the first 5 rows in the Item table in the databas like this:
private void ShowItems()
{
var items = (from p in db.Items
orderby p.ID descending
select new { ID = p.ID, Item = p.itemName,
Qty = p.quantity }).Take(5);
[code]...
i am using master page and one webpage. first home page fired after home page masterpage fired.in the master page one value to be used in Home page how to get value from masterpage to homepage.
View 4 RepliesI need to make an autoupdater for my application. This has been done, and it is working perfectly. However, my application currently downloads version.txt, and reads it to work out whether it needs to download the new application. This is hideous, and slow, and was only supposed to be very temporary. It is also very annoying that we have to update this file every time we release a new version.
My boss wants me to create a webpage that reads the version data from the uploaded .exe, and then returns that to the Desktop application. Therefore, I would be able to call www.example.com/version.aspx, and it would return the version number, such as 1.1. I could then compare to the current version (don't worry, it is generated on the fly, and not hard coded) and then I could download the application if required.
Here comes my question. How would I go about this? I have heard of CGI scripts, and asp.net. Which one of these has the power to solve my problem. If you could just tell me that, then I will be all sorted, as I could read up on it, learn, and broaden my knowledge.
If this is not possible, or not easily possible, is there any way of reading the file version of a remote .exe, without downloading it. This would also be preferable in many ways.
P.S. I did try to explain this to my boss, and suggested that maybe he could either do it, but he is not very good at web applications, and refused, saying that it would broaden my education in this matter.
EDIT: Somehow forgot to add: I normally program in C#, although this application should be so small, that it would not really matter. Also, C# code would be ideal, if there is a way to check the version of a file on a remote server.
How to use Return key to move between rows in gridview
[Code]....
I have a web service method which i'd like to return multiple rows from a datatable.
I am familar with returning values from web service methods but not multiple rows from a datatable. What is the best way to go about doing this? Do I need to return an array or list<>?
My code method is setup like this.
[WebMethod]
public void UpdateBold(int count, float lat, float lng)
{
DataTable dt = new Gallery().DisplayNearestByLatLong(count, lat, lng);
// return code here
}
There are many rows which are displayed in webpage, when user clicks on Name of the user.. a dialog box should open and it should display that user name...
View 3 RepliesI have an SQL database table like the following:
ID // Code // Shape
The ID is the integer identifier.
On one line the Code may be OX01 and shape Hexagon for example
Then the next line the code is still OX01 but the shape is Triangle.
What I want to do is be able to pull back data for every line that is equal to a unique Code column. in the above example OX01 Hexagon would be returned but not OX01 Triangle.
I've tried using SELECT DISTINCT but it brings back all records and doesn't filter them correctly.
I've considered having another column which could have Child/Parent data so that only the parent is returned but i'm sure there must be a better way of doing this.
I want to return single field to a different webpage using hyperlink.
View 12 RepliesI have the below c# method to populate an asp.net frontend control from a linq query. The only valid way I seem to be able to reference the query variable "result" is if I use the attribute "SingleOrDefault" but unfortunately this forces my query to return just the one single set of data for every unique primary key UserId value from my query, where I require the unique data attached to each different UserId value to be returned, how can I achieve this using linq? Note, I am passing the UserId value into my method from a public variable which is also below.
[Code]....
I am working on a small project. I ran the query below to get the maximum userid and increase it by 1 to create a new userid. However, when I run the query, it does not display the values that I enter into the database using insert statement. For example, if I open the table called login, I can see there are three records. If Irun the select statement, it only return one record which is the one that I enter manually when I first created the table. If I run the same select statement and give it a user id that I created, it returns the correct result.
[Code]....
I'm using a table adapter to perform my queries. I'm sure I'm missing something really easy, but I can't figure out how to return the number of rows returned from a query to a dataset used for a GridView.Basically, I want to display a message "No records exist for your selection" by testing for ReturnedRows = 0.
Excerpt of C# code:
handoutDSTableAdapters.handoutTableAdapter handoutsAdapter =
new handoutDSTableAdapters.handoutTableAdapter();
gv_Handout.DataSource = handoutsAdapter.GetDataByDoctor(Int32.Parse(ddl_MD.SelectedValue));
gv_Handout.DataBind();
I have an Ajax call as below
[code]....
I can access data.rows.length in all browsers but In chrome data.rows is null
I am accepting query/queries from user (our support team) in a text box where user can enter only one query or multiple queries. I need to display result of all queries entered in the textbox. If it is SELECT statement then result of that statement in grid which is done. If UPDATE/INSERT/DELETE then total number of rows affected which is also done but if only one UPDATE/INSERT/DELETE statement is entered in the textbox.
If user enters 2 UPDATE statements and then a SELECT statement then how can I get number of rows affected for individual UPDATE statements just like SQL Server Qury Analyzer displays messages in its result pane.
e.g.
(6 row(s) affected) -- first UPDATE statement
(4 row(s) affected) -- second UPDATE statement
(16 row(s) affected) -- for SELECT statement (grid will also be displayed along with these messages).
I tried almost everything, SqlDataSource (returns count of first statement only), SqlCommand.ExecuteNonQuery and DataAdapter.Fill (returns count of last statement only).
I'm trying to filter a DataView to return all the rows whose column x starts with a number: The following works in SQL Server:
select *
from dbo.Page
where Name like '[0-9]%'
However, when I try this:
dataView = new DataView( someDataTable, "Name LIKE '[0-9]%'", "Name ASC", DataViewRowState.CurrentRows);
I get "invalid parameter [0-9] with Operator Like" error message. What is the correct syntax to achieve my goal?
I am adding table rows dynamically, after I return from a post back, these rows disappear.
Is there a way to preserve these rows and add them back on page load?
I have a table in my Database called Creditors.
One of the columns is Paid which is type Bool.
On my aspx I have an objectdatasource and gridview. In the DAL is a method called GetCreditors which
returns all the creditors into the Gridview.
In some cases the "paid" column is ticked and in other not.
I want to run a select query that only gets the rows where PAID is not Ticked. insead
of retrieving all.
I have the SqlCommand Problem. cmd is the sqlcommand and when run cmd.Executescalar(), what will it return??
As I have the problem below code that it always prompt invalid cast which may be in the assigning BAtchno.
What do you think?? How to Correct below code??
--------------------------------------------------------
sSQL = "select max(batchno) from QI_WMS.dbo.WMS_StockRelease_Shipment with(nolock) "
+ " where convert(varchar, SRDate, 111) = @DateReceive and
WarehouseID=@WarehouseID";
[code]...
I have a Table, which contains a list of league players. Each season, we record their Points per Dart. Their total PPD for that season is stored in other tables and extracted through other queries, which in turn are imported to the master table "Player History" at the end of the season for use as historical data.
The current query retrieves each players PPD for each season they played, when they played last, and how many seasons played.
The code for Last season Played has become too long and unstable to use. it was originally created, and split into two separate columns because a single SQL was to long. (LSP1) and LSP2) which work, but as I add seasons, Access does not like the length of code.
In short, i need to find a more simple code that will look at each row, and look in that row for the last non null cell and report which column that last non null value is in.
So if a player played seasons 30 & 31, but did not play 32..but did play 33, the Column with the code should be titled Last Season Played, and for that Player, it would state "33" in that cell, indicating that this player last played season "33"
I've a problem with my web application. I hosted a web site in IIS and initially its working good. After sometime ( i dont know the time diff exactly ), if i try to access my page its not working and after re-starting my application only its working. Let me explain about my project.
I've only 4 pages ( ex: main, a1,b1,c1 ) in my site. In main page i used IFrame to show other 3 pages by clicking the appropriate tab. Before this main page load, i'm connecting to DB (Oracle 10g) and i used "System.Data.OracleClient" class to communicate with oracle. Every time after retrieved data from DB i'll close the connection. Then i'll display the main page and assign other page url's to the tab.
Now the problem is after sometime if i access the main page, its not connecting to DB at all then i'll show some static message like "site is unavailable at this time". And i'm not using connection pooling concept. And also this problem is not occurring all time.
accessing the return value of the SQLDataReader. My code is below. Actually the variable that I assigned my SQLDatareader object to is say HasRows property=true. But I am having trouble accessing the return value. And I get the error when I use the following code .Text =SQLDataReader("Contact Name").ToString I get the following error message: Invalid attempt to read when no data is present.
con = New SqlConnection(ConfigurationManager.ConnectionStrings("Connect").ConnectionString)
Dim getDirectorsCMD As SqlCommand = New SqlCommand("dbo.spGetDirector", con)
getDirectorsCMD.CommandType = CommandType.StoredProcedure
Dim myParm As SqlParameter = getDirectorsCMD.Parameters.Add("@BuildingTID", SqlDbType.Int, 15)
myParm.Value = ddlBuilding.SelectedValue
[code]...
I am working with a client who wants to make his current MS Access 2007 Reports available on demand in his web site. Currently, as I understand it, the managers of the company are being required to actually load MS Access and the active database to run the reports which exposes all of the data and linked tables to people who have no reason to modify them. So my client just wants them to be able to log into the admin section of the company website and request a report which he has already built in Access. I am trying to figure out how to get those reports to an ASP.NET application for the website to consume.
I have already spent a day looking at the Microsoft.Office.Interop library, and I don't think that that will cut it because I can actually get the HTML for the Report directly out of the application. All I can find is an option to save it to the hard disk which is inelegant and could easily cause problems with filename changes when I try to then load the document from ASP.
What I would like to see is a solution by which I can load the mdb or accdb file into the ASP application, access the Reports as a container and select the one I want by name, and then run it and collect the output in HTML to then simply echo to the webpage. Is there anything out there that can:
// Psuedo-code
Dim AccessFile As MSAccessFileOperator
Dim Reports As List(Of MSAccess.Reports)
Dim htmlResult As String
AccessFile = New MSAccessFileOperator("myDatabase.accdb")
Reports = AccessFile.Reports
htmlResult = Reports("MyReportName").toHTML
I haven't found such a method yet, and I am okay with the idea that maybe it isn't possible to do it that easily, but, at the end of the day, I need the HTML result of the Report to exist in memory as a String.