Asp.net - Single Quote In LINQ Results Causing Error
Jul 14, 2011
I have the following LINQ query:
Dim find_id = From p In dbContext.Residents _
Where p.person_name = occupant _
Select p
I then pull the first returned ID like so:
Dim building_id As String = find_building_id.FirstOrDefault.id
This works fine, except with the person has a ' in their last name, like M'arta. In this case I get a NullReferenceException.
Okay, the problem appears to be that when I am capturing the name initially from a GridView it is inserting into the value a #39 instead of ' and then LINQ is keeping things correct, so I end up with a non-match since it is attempting to match:
I use SqlParameters when executing database statements. I know that I can replace a single quote with two single quotes... but in the past SqlParameters took care of this for me. I have two projects.. in one, the SqlParameter does this and it handles single quotes fine, in another, it does not and I'm at a loss why (I even copied and pasted the code):
I'm trying to use a nested multi-line lambda Function in VB.NET and am getting an error. Here's what my code looks like:
cartItems = cartItems.Select(Function(ci) New With {.CartItem = ci, .Discount = discountItems.FirstOrDefault(Function(di) di.SKU = ci.SKU)}) .Select(Function(k) If k.Discount Is Not Nothing Then
I have a Linq-to-SQL class diagram in my web application containing the two tables in my database (held in a DBPro database project in the same solution). All was working fine yesterday. I start doing some work tonight and note that the solution compiles fine in Visual Studio, but when I run the web app I get a compilation error:
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30002: Type 'FrostAlertDatabaseDataContext' is not defined.
I have this block of code that sets up my sql parameters for a stored proc that does an insert.
Dim sproc As StoredProcedure = New StoredProcedure("UsersInsert2", DataAccessConfiguration) sproc.AddInput("@ID", SqlDbType.NVarChar, 10, entity.UserId) sproc.AddInput("@PCode", SqlDbType.SmallInt, entity.PriviledgeCode) sproc.AddInput("@Pwd", SqlDbType.NVarChar, 10, entity.Password.ToString())
[code]...
I've tested the stored proc in SSMS and it works.The problem is when I try to call it from the application. it fails. the @@rowcount = -1. I've tried returning an error code from the db... no dice. keeps coming back as -1 what is going to get executed looks like this
I have a filter expression that contains a single quote (Al ' ABC), and i am using the Select statment of the datatable where i want to select all rows containing the filter expression, but i am encountering an error. how can i resolve it?
I have a filter expression that contains a single quote (Al ' ABC), and i am using the Select statment of the datatable where i want to select all rows containing the filter expression, but i am encountering an error. how can i resolve it
My application produces this error System.Data.SqlClient.SqlException: Login failed for user..This started after I added a stored proc in my dbml file. It works fine in my local enviroment, but throws that error when deploy to staging sever. the user it displays is foreign to me?
While searching on how to escape a single quote in String.Format, I found the answer at SO: Escaping single quote in String.Format(). It seems to be different for VB though. I tested it, and indeed C# needs
string s = DateTime.Now.ToString("MMM d \'yy 'at' H:mmm"); while VB needs Dim s As String = Now.ToString("MMM d 'yy 'at' H:mmm")
Why does C# need a double backslash, and VB a single backslash? This might be a bit of a silly question to C# users, but while I can read C#, I'm not used to writing it.
I have a function in VB.NET that runs a query from an MS SQL DB, puts the results into temporary variables, then updates an Oracle DB. My question is, if the string in the MS SQL contains a single quote ( ' ), how do I update the Oracle DB for something that has that single quote?
For example: Jim's request Will produce the following error: ORA-01756: quoted string not properly terminated The ueio_tmpALM_Comments (coming from MS SQL) is the culprit that may or may not contain the single quote.
I have a string like "Hello'World" and a Data Table with some records in it. One of those records is "Hello'World".he problem is, when I do a .Select in the Data Table, it only tries to search for the "Hello" part and throws an error on "World" because it interprets the ' (single. cuote) like the closing cuote on sql.DataTable.select("text = 'Hello'World'")I have gone through msdn doc, and it says I can escape some characters with [] brackets or f.slashes , but I just can't figure out: .select("text = 'Hello[']world'")
I am saving a text field that may contain a single of double quote.' or "If i use a double quote in my SQL save funciton I can save and use single Quotes. When I use a Single quote I can save Double Quotes. Yet not both.People use both, so I would like to know how I could change the delimiter to something other than a Double Quote for my text saves
I am trying to make a list, separated by a comma, of entries from a single column in a SQL database. I have been spending the last several days searching for a way to do this, but every thing I found either didn't work, or wasn't exactly what I was looking for.
The query will pull all the email address that are not null. What I need to know is how to take the result of that query and make it look like this:
I noticed that if I leave off the terminating double quote for a string constant in Visual Studio 2010, there is no error or even a warning, i.e.
Dim foo as String = "hi
However, the continuous integration tool we are using flags an error:
error BC30648: String constants must end with a double quote.
Is there some language rule in VB.Net that makes a terminating double quote optional "sometimes"? Is there some setting in Visual Studio that will make it flag this as an error, so I can avoid "breaking the build" in this way?
somehow combine the results of separate Fill queries on a single dataset?Basically, I'm trying to implement a 'Filter' function, whereby, the user can filter the records in a DataSet according to specific criteria.
I am currently having a headache on how to solve this problem that i am facing.here is the situation:I have a combobox and a list box on the main form. The combobox will get the data from the ms access database.In the database, i have the details of a person's IC, Name and DOB say for eg on one entry I have D215311523C,SHAWN,13/04/1987
So now, my combobox on form load will show the list of dates in the database to allow the user to search base on the date itself by clicking on the selected date. So when the user clicks on the particular date say 13/04/1987, people in the database whose birthday is 13/04/1987 will be shown on the listbox.Meaning to say if i have 3 entries whose dates are the same 13/04/1987, 3 entries will appear. If there is only two entry, then two results will be shown.
Ok i have a query i use to parse an xml file to get an id number of a movie that allows me to get more detailed information about that movie from a database.Now the problem is the id is returned correctly with xml files stored on my hard drive (c:\desktop\movies)but when i try and parse an xml file on an external drive it dont get a hit on the <id>1123</id> node.
query Function movieID(ByVal directory) 'Get the movie name
I am currently programming a complicated inheritance structure for an Insurance Application. One DLL has classes that can be used and inherited from. DLL Two has Classes specific for our Auto Line of business, however when i attempt to use Object 2 from a Web Application it errors out because one of the classes is ambiguous because it appears that DLL Two inherits a class from DLL One which appears to pull in the entire inherited class. Since the Web app has a reference to both DLL One and Two, One has the class, Two seems to also have it and so compilation errors out with an ambiguous class in the same namespace.
To attempt to get more specific ill try a quick run down.DLL One - PGPolicy.dll contains standard classes with properties and methods needed for every line of business such as:
Policy, Name, NamedInsured, Unit DLL Two - PGPolicyAuto.dll contains the following Auto specific classes: Vehicle Inherits from Unit Driver Inherits from Name
Since PGPolicy.dll contains classes needed by all lines of business and PGPolicyAuto.dll has more specific classes for the Auto line of business, the web application references both of them. The problem is that since Driver inherits the Name class, it appears to create a Name class in the same name space that the PGPolicy.dll has the namespace in, which gives me an Ambiguous class "Name" in the PG.Policy Namespace.
I have a CSV file where the values are in double quotes and seperated by a comma. I'm getting incorrect data if I try to seperate the string with my Split function. How do I do it?
Ok, the basic situation: Due to a few mixed up starts, a project ends up with not one, but three separate databases, each containing a portion of the overall project data. All three databases are the same, it's just that, say 10% of the project was run into the first, then a new DB was made due to a code update and 15% of the project was run into the new one, then another code change required another new database for the rest of the project. Again, the pertinent tables are all exactly the same across all three databases.
Now, assume I wanted to take all three of those databases - bearing in mind that they can't just be compiled into a single databases due to Primary Key issues and so on - and run a single query that would look through all three of them, select a given set of data from each, then compile those three sets into one single result and return it to the reporting page I'm working on.
I've got some code to try and loop through LINQ results, but it doesn't seem to be working.
HERE'S THE CODE
Public Sub ProcessRequest(ByVal context As System.Web.HttpContext) Implements System.Web.IHttpHandler.ProcessRequest ''# the page contenttype is plain text'
What I'm trying to do is build 16 forms dynamically at runtime (all will be identical). These 16 forms each will display a camera, which is using an ActiveX control made by a 3rd party. I am able to create the forms correctly and provide all necessary parameters for each control, but since I have to declare my own AddHandler event which checks if the camera connected, I need to somehow reference the ActiveX control at runtime, but I can't tell it which form it's on because it says it's not declared.[code]...
I have a project in VSTO/VB using a BackgroundWorker that works fine. It is a form that calls for a web page of information. The web page can take a while, so I have the form calling with the BackgroundWorker.I then have an Excel Addin project that has added the BackgroundWorker project. When I call up the form from the Excel Addin project and use the BackgroundWorker to request the web page, it grabs the web page ok. But the work done upon completion, during the BackgroundWorker1_RunWorkerCompleted method, is resulting in an error message:
I create an empty boolean array check_state(), and then if a condition is met later in the script, I redim it and save a list of check box states as booleans into the array, and later check the array values, but I can't work out how to do this without causing an error if the array was not defined to begin with
I am trying to develop a web application to populate data to three datagrids(datagrid control) using 2003 version, each datagrid has three columns and about 10,000 rows. The problem I got is it only allow load data once, whenever I changed the setting and reloaded data, the Page Can Not Be Displayed error will popout. I tried to remove one or two datagrids, it would allow populate data few more times, eventually will error out.
