I have an asp.net page connected to a MySql DB.When I try to insert/update values from the webpage into the DB the chars are shown in the DB as question marks (I am using SP).If i will write a query directly in the DB, It will work and the chars will be displayed correctly.
The DB default charset is utf8, and the column collation is utf8_general_ci.
I have a problem with saving hebrew into sqlserver.I've done it before in another computer but did not have problem.Now the hebrew is saved as '???'.About the field collation, it is latin1_general_cp1_ci_as in another DB I have in another computeranf also in the current field in the current DB.I guess it not the collation.Ialso tried to change the text field to varchar, but it still saves '???'.
I am trying to implement URL rewriting technique in my Web application.I have found some articles on net 2 rewrite URL. But i m not able to understand. tell me any API or DLL which will take care of all url rewriting techniques in my Web applications.
I have heard something abt UrlRewriter.ddl . But i have not used it yet. provide me the easiest way to do that. If any sample application is there then it will be better ti understand
I have a asp.net page with .net controls. For a long time, many years, pages was run correctly. But lately some signs were change from their normal display mode to squares. Looks like some encoding issue, but changing it, dosen't .How can I resolve this issue? Why do I see square boxes instead of some signs?
I would like to know what the expression for "letters only" is for my asp.net web application. I tried ^[A-Za-z] but it does not work I would also like a regular expression for "numbers only except "-"
I receive lists from a web service and then I convert the lists to datatable and then I add the datatables to a dataset and from there I get the xml from the dataset where I can save it into a sql database. But the problem is that the xml has /r/n between all attributes and elements. I dont know how to get this out of the xml. Can this be because of my converter. If so can anyone give me a better way to get multiple lists into a dataset.
In short, I want to implement a search engine. I pass the search string as a http querystring and my database uses it as a filter in Select. The problem occurs when I enter some non-standard english letters. Let me elaborate: on Main.aspx page, when I click on "Search", a function calls "Main.apsx?search=something". The querystring is passed as a filter to the database which returns values depending on the filter. The database holds correct data at the moment.
After that, I dynamically modify some hyperlinks' url to something like this: hlink[i].NavigateUrl = "Detail.aspx?search=" + base.Request.QueryString["search"] + some integers;. I want users to be able to click on the link to get details on the result. If they click the link, since a new page is now opened, the database has to be refilled (from cache). The same function for filtering the main database is called with a querystring which should be the same as the search string, but somehow it isn't. It looks like something was lost in a conversion or something. If I use standard english letters, everything works fine. I noticed that prior clicking the link the query string had a value like /u0100d for the non-standard letter, but after clicking the link the value had changed to something like /u0ffff. It obviously isn't the same when typing something in the search box and hitting "search", and when putting this search string into NavigateUrl and clicking on it.
In my database MYDB i have a table called MYTABLE and inside it I have a column called NAME. I want to only return the first 100 characters of the column NAME. (NAME can be up to 2000 characters).How can this be done in SQL as I want to set the first 100 characters to a ASP.NET label.
I have a system where I salt and hash passwords before saving them to the database, using FormsAuthentication in asp.net
What I want to do is, rather than ask the customer for their password each time, I just want 3 random letters from their password. How can I compare this to the hash in the database? Will hashing still work in this case? From what I gather hashing is only designed to be a one way process and shouldn't be decrypted, so is checking 3 random letters for a hash even possible?
In login.aspx I have used login control to enter user name and password, the problem is: even my caps lock is off when I enter user name it prints in capital letters but size is small size (when I copy and paste in note pad or msword it paste in small letters not in capital letters), when I turn on my caps lock on and type - it prints in bigger size as if I am typing in capital letters. ex: 1. temp is my user name if my caps lock is off it shows like this TEMP (but size in smaller than 2nd one) 2. if my caps lock is on is shows like this as if I am typing capital letters TEMPwhat do you think the problem is how can I fix it?
Text box has to allow digits and alphabets using ajax server side controls and in this if the user types small alphabets it has to convert capital how to do this using ajax server side controls?
I need to create a process of merging letters and/or envelope templates from a web app. We are using VS2010, C# (.net 4.0), asp.net, and Office 2007. The user selects a bunch of accounts from a list, and I need to collect the info for those accounts for merge. One catch is that if I look up an account and one of the two account holders has passed away, I need to change the greeting based on that info. For example, in most cases the letter would say something like Mr. and Mrs. Bob Smith. But if bob is dead, then it would just say Mrs. Mary Smith.
I also need it to open on the client side in word ready to print. So if the letter is 1 page, and the user selects 100 accounts, the word doc should have the letter merged with the 100 accounts just waiting for print. What is the best way to do this?
I use some code to encrypt & decrypt string in C# but i want a good one that can generate encrypted string that contain only letters or numbers not any other ( + , / , ...)
I have a text box which accepts CVV code of 3 or 4 numbers and im using regular expression validator this is wat im using : is this correct way of using or not
I have a vb.net local application that reports to a web server with POST method.
Unfortunately, like it says in the title, the swedish characters (among others I guess) comes back in ASCII (I think).
local app:
Code: Function doHtmlPost(ByVal url As String) As String Dim strResult As String = "" Dim myWriter As StreamWriter Dim mystring As String Dim strR As New StreamReader("c: estmytext.txt", Encoding.UTF8)
I have spent a long time to find a decent solution, but without success. I have a ListView where I want to make an alphabetical pager that can handle the letters from A-Z + ÆØÅ to be at the end of the pager after the letter Z. If the first letter of a word found in the database, it must come in the pager as a link. The letters of a word that is not in the database must appear in the pager without a link.