When i store this data into my database using Insert into statement, all the characters with accent are replace by a question mark. for instance get "Au secours des coll?ges"
What can i do in order to SQL Server accept the international characters like french's
I am trying to write a regular expression to replace all special chracters within a string so that I am left with just alphanumeric characters and spaces or full stops.
I am using this expression at the moment
[Code]....
But then I test this with the string "This is a test!", it returns "Thisis a test", which would be fine, except for the space it removes between "This" and "is", can anyone else me where I am going wrong or supply a better expression?
I have a basic question about comparing the type of a variable to a specific type. If I have variable A and variable B, both an instance of a certain type, then I know I can compare the types by getting A.GetType and B.GetType, I can also use IsAssignableFrom and IsSubclassOf for more advanced things. However if I only have variable A and I want to know if variable A is of type MyCustomType, as I see it now I first have to create an instance of MyCustome Type, get the type from it and then compare it to the type of A like in the next Example:
string A = "test"; MyCustomType B = new MyCustomType(); Type typeToCompare = B.GetType(); if (A.GetType().FullName == typeToCompare.FullName) {...}
So if I need to know if A is of MyCustomType isn't there an easyer, shorter alternative that I can just try something like the following (which is ofcourse not possible):
if (A.GetType == MyCustomType....) {...}
so without first having to create an instance of the type simply to extract the type from it.?
I'm working on an ASP.NET web application for our corporate intranet users. I have a form where a user should provide a path to the file on the local network (something like "localServersomeFoldersomeFile.ext") without uploading the actual file. The issue is that users don't want to type the whole file path and want to use some kind of visual browse dialog.
The standard HTML <input type=file> element allows to browse for a file, but most of the browsers (except for IE) don't allow to access file's full path, so I think it should be done by some external component like Silverlight, Flash, Java applet etc. I tried to do it with Silverlight, but I'm getting a SecurityException when trying to access file's full path using Silverlight's OpenFileDialog class. This java applet [URL] seems to do something similar to what I'm looking for, but it's focused on uploading files - I only need to be able to get file's full path and pass it to the server as a string.
I'm sure this will need to use javascript but not sure exactly how to do it. I need to count the characters typed in a textbox and when it reaches 10 I want a sub to be called in the code. Or have it click a button on the screen which is probably easier. How to do this? I would think I would call the script with the OnTextChanged? And in the script use the .length property to see if it is 10? Maybe I just answered my question here!!
I have a function that at the moment takes a Type variable. This function sticks it in a list and such and eventually needs will create a class of that type. Right now I do that with
which is pretty hacky and also will not work in medium trust due to reflection(I think). Is there a better way of doing this without reflection? The Type is defined this way as part of a function. I need the class to be created "lazily" because it may not be created in the application if it's not needed. I use it for example like
AddToList(typeof(Whatever));
Note, I'm open to suggestions on changing the function calling. I just need the object to be created lazily and for to store the type(or however to create an object of the type) in a list.
I want to force user to type more than 6 characters in password field.we cannot usee range validator because password characters can be mix(i.e.Numeric or alphabates or special characters)
ERROR MESSAGE: Unclosed quotation mark after the character string ') '.Incorrect syntax near 's'.I am getting this error when adding a value to a table which contains a single quotation, value is: men'sthat value is been pass as the keyword name.this is the query that i am using: Dim sql2 As String = "INSERT INTO keyword_relation_type (business_id, keyword_name, keyword_id) VALUES ('" & business_id & "','" & keywords(i) & "','" & keywordsID(i) & " ') "
I am using Multi-line Textbox through which users will be able to enter data which will be saved on to the SQL Server 2008 database. There is an other process, which reads this data from the table and writes to a text file.
Problem:
If the data entered by users in text box contains <Enter> from keyboard, it is saving to the database with some spaces replacing the <Enter>.
Some how if I read the same data to a text box on webpage, it is being displayed properly.
But, if my second process that reads the data from database and prints to a text file, it is not keeping the text format properly. It is not retaining the <Enter> in the data being printed to text file.
I have 2 table in database 1-State 2-City and bind DropDownList 1-ddlstate  2-ddlCity from these table and when I select item from ddlsate , according to my selected item from ddlState , ddlcity's Item change I used OnSelectedIndexChanged for ddlstate
problem is: I enter some data in tables with persian Alphabet now when I select some Item from ddlstate that contain these alphabet in persian "ی ،پ،... " it didn't show any Item in ddlcity but when I select item that didn't contain above alphabet it show item in ddlcity correctly why this happen?
I need to replace <span> entries in a string to legacy html code because it's going to be used in a report for Crystal Reports. <b> works with Crystal, but the<span>'s do not.
Here's the string which I'm trying to replace: <span style="font-weight: bold">%THIS CAN BE ANY TEXT%</span>. I want to replace it to
i need one query replace all in table.. example of one table have null value replace in "000" .. but null value not only in single column .. it is present in more column.. i need single query... below query only for replace in single column...."SELECT REPLACE(salary, 'null', '000')as new from salary"
I need a linq-to-sql use dbml, then I follow this article : http://www.west-wind.com/weblog/posts/147218.aspxSet the child to internal, set serialzable to unidirection and add updatecheck=never
I just installed SQL Server 2008 Management studio Express on my Vista machine.i tried connecting to local machine using :
.sqlexpress, (local)sqlexpress, or .SQLExpress, MyPCNAMESQLExpress
nothing is working, getting this error:
----------------------------- Cannot connect to PC-NAMESQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) ----------------------------
In fact, I DO NOT want to ask a question but to share one solution to this. One cause of this problem is you did not register your sql express on iis.I installed .net 3.5 sp1, then ran aspnet_iis -i, then installed sql express 2005 advanced. Yes, here came the notorious alert. So, I ran aspnet_regiis again and everything is OK.Run aspnet_regiis before you have installed sql express.
