I have three XML files that are auto-generated and placed into my wwwroot directory. From there, I need to be able to search through these XML files looking for a record by either first name or last name. So, I have three xml files: a_results.xml, b_results.xml, and c_results.xml.
I'm having trouble reading / scanning these files so I really need some hand holding here. Very novice ASP/asp.net programmer here. Basically, I want a "search page" where the user will enter their search criteria into a text box (either first or last name) and the page will search the first and last name fields in all three of my xml files and return the results in a table, including the resulting first and last names plus their extension number.here is an example of one of the xml files
So, as an example... I go to the page - enter "test" into the search box and click "find". The page should search all three xml files for the word "test" in the first OR last name fields and then return ALL of the combined results in a table which shows first name, last name, location and extension number (all available in the XML file(s) as shown above).
As a newbie coming from a Java background with tag libraries I wonder if there is a simple possibility to render areas depending on backend values.For example if I have search form I do not want to render the table for the search results as long as the user hasn't pressed the search button. Of course I can iterate over the model containing an empty list but this does not allow to suppress rendering the whole table.Using web forms I would just control the visibility of the affected tag(s) in the code behind file but how do I do this with ASP.NET MVC?Can I use a partital view for a case like this? But I think I would have the same problem. How can I determine if a partial view is rendered (e.g. the whole result table with header)?
I have Visual Studio 2005 and 2008 installed on my machine. When I bring up the Find and Replace box in 2008 in any project the 'Look at these file types:' option is blank however in 2005 it keeps defaulting to the file type of RemoveFile. If I don't remember to clear it then it causes my search to fail. Does any one know how do I reset this value or remove this default option so the file type is not set and it looks at every file type when I search for a word.
I'm assuming I need to use a pivot table from what I've found so far. However, every one that I've seen has not had the date setup like I have.
I have a Gridview on my page which I need to be populated like so
Date NCMR
1/1/10-1/31/10 #
2/1/10-2/28/10 #
I want to do this for 10 months... bottom record being the current month (or last month). I would also like the Date to format to January 2010 I used the above date format because that is how it is in the table. Basically, I need to know how to create the pivot table to search the table for 1/*/10, 2/*/10, etc
I have a scenario where i want user to open a popup or other page from a web form to search contacts from database and add them to list and when done return that list back to parent form field and continue filling other fields.I have 2-3 user input which should take multiple values for each field from list of values and i wanted to implement this using pop up based search and add method (other alternative was to use dropdown with checkbox but the list is so big and it is not user friendly to use that)
Is this feasible using asp.net or is there a better architecture/method in .NET to implement this type other than popup based search and retrieval.
i know how do the paging with normal return query using row number in sql server, but i'm looking how to do the paging , sql server full text search returning result.
Can i use the same row number function or any good perfomance way?
whcih sql server full text search(FREETEXT,CONTAINS and etc) is best article site?
I'm trying to do the equivalent of a "Are you sure you wish to delete?" and then if yes, return to a function in the aspx.vb code. Here is what I have:
And then on the form, the btnCancel does popup the menu, with Yes / No and the text "Are you Sure?"But, even though I have a button called "btnCancelYes", I cannot get the code in there to trigger. Ie:
Code: Protected Sub btnCancelYes_Click(sender As Object, e As EventArgs) Handles btnCancelYes.Click DeleteRecord() End Sub
I am building a webservice that reads some HTML source code from a website and sends it back to the client. The service however is failing to send the data because it is too large. I keep getting this error:
The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter [URL]..... The InnerException message was 'There was an error deserializing the object of type iRacingForumServiceTest.ForumService.GetForumListResponseBody. The maximum string content length quota (8192) has been exceeded while reading XML data. This quota may be increased by changing the MaxStringContentLength property on the XmlDictionaryReaderQuotas object used when creating the XML reader. Line 153, position 247.'. Please see InnerException for more details.
I have been googling this problem for ages and I cannot figure out how to apply the answers I keep finding.
The problem is simple: the default configuration doesn't allow such large strings. I just don't know how to change this. All I keep finding is things related to WCF, I'm not sure if that applies for me.
What I keep finding is that I need to change the web.config file in various ways. However I cannot figure out where I need to put the config sections. I've tried everything but without a complete web.config file example I can't get it to work
I figured out where to put it without getting errors (just as a child of the <configuration> element), but it just doesn't work. I get the same error no matter what values I try here... This shouldn't be such a difficult issue, how can I solve it?
So I've created a default Visual Studio project for a webservice and I invoked the HelloWorld method. What I get is indeed a "Hello World" string, but with some additional "crap" attached:
I want to add a search to my ASP.NET app, and I would like to show suggestions in a window just below the text box where the user is typing (as they type), just like Google search. I think it has to be done with AJAX, right ?
I am working on a website hosted with GoDaddy, SQL Server 2005. I have a table in my SQL Server database with a full-text index. On my website, a user can type in search terms and the terms are then passed to a stored procedure in the database which performs the search. The first search takes about 45 seconds to get results. Subsequent searches return results immediately. I found a description of this problem in a Microsoft knowledgebase article:http://support.microsoft.com/kb/915850/en-usGoDaddy tech support says I need to purchase a dedicated server to make the changes suggested in this article.Surely there is some other solution. Does anyone know how to avoid this delay without changing the server configuration?
Return myDataReader I have a function which is retuning a datareader to various sections of my website which is then being bound to dropdown lists, gridviews, etc. Normally the last line in a function when is the data reader and connection getting closed? Is it best practive to return a data reader or a dataset/datatable (or something even better than these two)?
I have a array list and am using like a database trying to search for ChildID and ParentID based on certain criteria.
My example below has the following keywords to search for:
Yellow, Mustard, Honey, Orange, Flame, Talisman
I also have a category volume value which I grab the first 2 characters to determine another filter.
My code isn't returning all matches with using 'Contains'. Right now it finds the 'Orange, Flame, Talisman'/AV record and returns 50, 28. My keywords also has 'Yellow, Mustard, Honey'/AV which should return 55 and 28 as well.
HTML Code: <%@ Page Language="VB" AutoEventWireup="false" CodeFile="temp2.aspx.vb" Inherits="temp2" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">
I have the following code that i call from the page behind code.
when no records are in the table i get an error message
invalidcastexception
conversion from type DBNULL to type Decimal is not valid
I would prefare if the procedure did not throw this error message and returned a value to notify me that no records found when zero records returned
Public Shared Function invoicetotal(ByVal CustEmail As String) As Decimal ' Dim selectcommand As New SqlCommand Dim CONNECTION As SqlConnection = MaintainDB.GetConnectionString Dim sel As String _
I am new to Sql server 2005. I have a table in which contains many data. I need to take particular data. For example, I want to take value of 110652.795813712 from FTEBASEPAY column. So i have wrote the sql statment like in below. SELECT * From tblEmployees where FTEBASEPAY='53842.7782655718' But i am not able to get the particular value. Manually i have seen the tblEmployees table, in which contains the particular data ('53842.7782655718'). When i execute the above select statement, there is no result for it. What i have to for overcome this issue?I have to give one more information, the FTEBASEPAY dataType is float in tblEmployees table.
This question is regarding the ASP.NET webservice that i am creating using the DAL-BLL architecture for my final school project.I have a stored procedure, which is a select query with an inner join for 2 tables.Hence the stored procedure returns multi-table value. One of my DAL tableAdapter methods accesses this stored procedure. How do i retrieve the return value in the BLL? Do i have to create a class structure similar to the one supposed to be returned by the stored proc? or is there a direct way to achieve the same? Here is some more information:I am using the SQL dataset (.xsd) in DAL. So i have a datatable called "Insurance", which has a tableAdapter. One of the queries in the adapter references to a stored procedure, which has an inner join. So my SP looks like:
ALTER PROCEDURE dbo.GetInsurancesPaged ( @startRowIndex int,
I am inserting data into Employee table using stored procedure.In employee table EmpNo is identity column.Once i insert data into table stored procedure should EmpNo i.e identitycolumn value.
correct my stored procedure to returm EMpNo Identity column after inserting row.
alter procedure SAR_Sp_AddEmployee(@EmpName varchar(10),@CampaignID int,@startDate datetime) as insert into EmpMaster values(@EmpName,@CampaignID,@startDate)
I'm not so familiar with stored procedures but I'm interesting in moving most of my web selects to stored procedures. I'm working with .net based website and all my data access is something like this:
[Code]....
But now I want to improve some process and make tunings. For that I want to use stored procedures, so instead of the "SELECT ...." sentence I'll put stored procedure name. My problem is how to return a table from one.
Basically I want to have a page do a search on first name(textbox), last name(textbox), gender(dropdown). and return a grid result back. it's so easy in web forms. how do i do in mvc? So far I have: Controller
[Code]....
View: Search.aspx
[Code]....
I didn't modify the route. When I put in [URL], it says resource not found.