Thank you for asking, fortunately I now have the solution, I asked Bob Tabor of "LearnVisualStu dio" and he came up with a solution, but I do very much appreciate your interest.
Once again thank you
Joe
Joe Campanini
Last Activity: May 24 '13, 07:11 AM
Joined: May 21 '11
Location: Home, Durban South Africa
-
Output a UTF-8 file
I am reading a text file, sourced from Germany so there are special characters such as ü and ß. However, on output of the original input record, the special characters are replaced by something else. I believe this is because the output record is in ANSI format and not UTF-8 format. How do I tell C#, or Visual Studio, or Windows, or whatever, that I want the default output to be UTF-8? -
Thank you vijay6, believe it or not my wife who knows absolutely nothing about programming said to me, “Why are all the checkbox’s in that panel not quite as bright as the ones above” that’s when the penny dropped, I went to the properties of the panel, and somehow, don’t ask me how, the enabled property was false. I made it true, and now it’s all working. But once again, thank you Vijay, I had resolved to rewriting, but now I don’t have to....Leave a comment:
-
checkBox_Click misdirecting
I have spent the last twelve hours trying to work out what is going on with my Windows Form program. The program has been working successfully for over a year. Recently I decided to add an additional textbox which would contain a postal code accessed from a bank name file. This was a visual aid only and had no other function. I have various check boxes, which, in the past when clicked would highlight the accompanying textbox to show that it was selected,... -
How do I edit a column in SQL Server Management Studio
OK, using SELECT I can view a database record from one of my tables, but now that I can see the selected record I notice that the first name, for example, is spelt incorrectly, and I wish to manually correct this mistake. Using transact SQL how do I, or can I, instruct SQL Server Management Studio that I wish to make specified column editable. I suppose what I'm asking is, "Is there a special SELECT statement that say's select and allow manually... -
Thanks for your input and sorry I did not reply sooner, but I managed to get round the problem, I think. I opened the txt file with notepad copied and pasted the whole file into a new notepad and saved it as a UTF-8 file. The C# program seems happy with this but exel still doesn't like. I have seen some funny things in my life in the IT world but this is got to be one of the strang ones. I bet the answere is really simple, but don't have time to...Leave a comment:
-
Reply to RhysW
The software is C# 2010 version, and it does recognize it, because I can key in alt 129 in a string and the character ü appears in the software. No, this has something to do with the way that the file is being read, I just don't know what! I have just seen that if I open the txt file using Exel the same thing happens, but if I open the file with notepad the characters are OK. But hey! thank you for at...Leave a comment:
-
An input UTF-8 encoded file is output as a ANSI encoded file. Why?
I am inputing a UTF-8 encoded file into memory using the following code...
...Code:try { StreamReader readFile = new StreamReader(pathNames[0]); while (line != null) { line = readFile.ReadLine(); compareData.Add(line); } } -
Not as far as I am aware. I admit I had Management Studio open, but that was just for me to check if my C# program was picking up the correct record, but at the time of testing my C# program I had not utilized Management Studio for some time, and during that time I had made numerous test runs with the C# program successfully.
Joe...Leave a comment:
-
Could not open a connection to SQL Server
Not to worry I have found a solution For the past two weeks I have been developing a program in C# that uses LINQ to SQL to access the database. Everything has been working just fine, with lots of help from DOTNETPEARLS. I have been testing the program successfully for the past few days, making minor adjustments here and there for cosmetic purposes. Today, while testing, I got error in C#, something about the program could not start, I cannot recall... -
Workstation Components
Can anyone tell me, "What are Workstation Components in SQL 2005"? When I uninstall SQL Express 2005 should I also uninstall the Workstation Componenets?
Joe -
It has been suggested that I use SQL 2008....
A reply to my previous question (see below) was to install SQL Server 2008. Been there, done that… the problem is that then my C# program doesn’t work, and I need my C# program. The programmer did not supply me with any source, and is not contactable, so I am stuck with it until I can re-write the whole system.
PREVIOU QUESTION
I am using a C# program that was...Leave a comment:
-
The database ... is not accessible
I am using a C# program that was written for me to access my database. I recently downloaded Microsoft SQLServer2005_S SMSEE, which I installed successfully, however I am unable to access the database using the Management system, getting the “The database ... is not accessible” message. I am still able to access the database via the C# program. When I look at my profile I am the system administrator,...Leave a comment:
-
Thanks CK, but didn't get a reply for some time and I got despearte and decided to uninstall everything and start from scratch. Managed to uninstall 2005 but can't get 2008 to uninstall. BTW doea one have to manually uninstall all the componenets of sql? Such as Microsoft SQL Server 2008 Data-Tier Application Framework,etc., etc., for example?Leave a comment:
-
Install SQL 2008 and SSMSE 2008
Can someone, anyone, help me, I am pulling my hair out trying to install SQL 2008. I am novice SQL and C# developer, my expertise being with RPG III. I have been using, on my development machine running under Windows 7 (64bit), SQL 2005 and SQL Server Management Studio Express. Everything was dandy until a few weeks ago when I could no longer access my database, I was getting error: “The database ‘database name’ cannot be opened because it... -
Sorry - Done :-) :-)Leave a comment:
-
Thanks guys, you have pointed me in the right direction, the code I didn’t show. Adrian, for brevity purposes I was not totally expicit, the actual code works on a split of a split. So, for the first split I also get the same result with the code I did not supply as you get with the code you supplied. It's when I get to the next step that I ran into the problem, and, as Hamlet say’s, therein lies the rub! I have been sticking the result...Leave a comment:
-
Hello Shilpa,
Thanks for trying, but no, it doesn't work. To be honest I had already tried the data = null rout inside the for loop, but this time I added the string data[] = null also, but without any success, but thank you for making the suggestion.
JoeLeave a comment:
-
Thanks Adriancs, but doesn't answer my question. It was using dotnetperls that gave me the idea to use the split method. Say that I read, using StreamReader, strings of data into memory:
a1 a2 a3
b1 b2 b3
c1 c2 c3 etc.
...Code:ArrayList rawData = new ArrayList(); try { StreamReader readFile = new StreamReader(pathNames); while (line != null) { line = readFile.ReadLine();Leave a comment:
-
Re-use a string array using the split method
I have a list of input strings and I want to take each string and using the split method populate a string array, do some stuff with it and that process is in a "for" loop. After each pass through the "for" loop I want to re-use the same string array. And, as all you fundi's in c# will know, the array just keeps getting added to. How do I say start from scratch each time? I know this is going to be real easy, and I'm going to...
No activity results to display
Leave a comment: