|
O my god ! I am developing my Application with SQL Database, thinking that it will be stand alone distributable. Now If I change my Datbase to OLEDB ( Microsoft Access ) ? then will it be stand alone ? I read your previous posting where you said that if I use Access then it will be ok. I am thinking If I just change the database file and Connection String, will be all code be working ? And I hope the SAME SQL will will be working just Parameters sign ( @ or ? )is different, right ?
-- modified at 16:35 Sunday 5th February, 2006
|
|
|
|
|
I don't know much about Access. It used to be (and this is getting on for 10 years ago) that you'd need some additional files installed to use the Access database through ODBC, but I really don't know about .NET. It may be possible.
The SQL is similar but there are differences. You've already spotted the parameter one. Access doesn't support Stored Procedures, so if you have any of them they will have to be re-written.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
Hi colin,
thanks for your time.
yes, ADO .NET supports Access and C# Express can help me to use the Access same as SQL. But I have done some research on google and Realized that, If I started with Access, that was a different story, but at the middle of this time of my application development, it will be very hard to go through all Conversion. I was thinking how can i manage SQL database to make Stand Alone. One thing I can do, I can put the SQL Express executable in my installer file so that whenver user install my software, my installer will install SQL server from CD. Or I can learn about MSDE, I got a nice article about MSDE from Code Project, http://www.codeproject.com/cs/database/msdeinstaller.asp[^]
Can you tell me which one is efficient solution !!
Regards,
Emran
|
|
|
|
|
Hi,
I have checked the link VISTA DB that you provided in the last posting. Excellent Solution exactly what I wanted. thanks for the information. Have you used that ?
|
|
|
|
|
I'vw played with it a little, but I've not found a project that I'd use it on - I work mostly with large enterprise applications where the database is arround a Terrabyte in size.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
Hello.
I am writing a new component that has a property that gets an Enum type.
I want the designer of the project, that is using my component, to show that property in the Visual Studio Propery Viewer with a drop down property that lets the user select from a list of Enums that are decleared in his project.
How can I do such a thing ? (in C# 2003)
How do I control the Property view of my control ?
Thanks.
|
|
|
|
|
|
hello
how can i making sound & video transfert in my c# or VB.NET application
11111111111111111111111111111
|
|
|
|
|
I have an application that needs to save settings while exiting. In which eveny should i write the code for saving the settings. Does the Form.Closing event tigger when the form was in focus and the user closed it? The UI of my application may not be visible because it runs in the system tray and it is closed from a system tray icon context menu.
|
|
|
|
|
You can also handle the application's ThreadExit or ApplicationExit event. This may be a more robust way of saving your application's settings - I believe (but am not certain) that these events are fired even if the app is forcibly shutdown via the task manager.
/ravi
My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com
|
|
|
|
|
hello folks.
if my user is behind a firewall that only allows connection through port 80 how can i make my application get binary data and respond to the outside world also in binary data through port 80 . How can my application distinguish the binary content coming from http request from internet explorer (suppose the user is currently browsing the internet and opening my client application). How can i distinguish between the data comes from my server and the data comes from any webserver during browsing through port 80.
Thanks Everybody.
Human Knowledge belongs to the world
|
|
|
|
|
Well, you can easily recognise HTTP traffic. RFC[^] for HTTP defines the format of a HTTP header, so you can look for it to identify requests from a web browser.
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
Hi,
I am trying to see what i can do with dynamically use with ContectMenu and a Database.
I have build a structure up where the ContectMenu is static and where i hoped to use a database with ToolStripMenuItem, and it works quite ok to add an item with ToolStripMenuItem.DropDownItems.Add(readdba.GetString(1) but do any have an idea on how to get either an index or the name of the Contextmenu field that comes from the database when it is selected?
Cheers,
Marker
|
|
|
|
|
I made a website in asp.net. but now i want to make a program in c# to add news,... in the database but this should be in html format. Does anybody now how i can format a textbox to html.
gtz stijn
|
|
|
|
|
What is it in the text that you need in html format?
If the string just has to be html encoded, don't do that before you put it in the database. Do that when you read the data and display it in the web page. Use the Server.HtmlEncode method to encode the string.
---
b { font-weight: normal; }
|
|
|
|
|
The problem is when something is underlined or there is a new line in the textbox the asp page should also display this.
gtz stijn
|
|
|
|
|
What kind of textbox are you using, as it can contain underlined text?
Line breaks are easy. Store the lines in the database separated by Environment.NewLine. When you read the data to display on the web page, replace the Environment.NewLine occurances with the html code for line break, e.g. <br> or <br/>.
---
b { font-weight: normal; }
|
|
|
|
|
I think its a rich textbox so how should i replace the underlined words. i copy them from word into the rich textbox. But i'd like to make an editor like here on the forum but then in c#. The output should be a string off course that i can put in the database.
gtz stijn
|
|
|
|
|
Then you will get the text in rtf format.
The rtf format is quite different from html, so there is no simple solution like just replacing some tags.
I don't know of any library that can convert rtf to html, but there probably exists something out there. I can't reach any search engines right now so you have to do the searching yourself.
---
b { font-weight: normal; }
|
|
|
|
|
I found a library who does this but its a trail version and i don't want to pay for this. Maybe an explanation how i can replace simple rtf to html. I already found how to replace new lines and spaces but i want to know how to convert underlined words too.
gtz stijnbe
|
|
|
|
|
I am using Excel 11.0 object library. In MSDN I've found this example http://msdn2.microsoft.com/en-us/library/891ydsx9.aspx[^].
Excel opening, but on creating new workbook it fails and on string: 41 returns error:
_Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
, I receive error message
Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
What does this error mean? I am using Excel 2003
p.s. this example was the best what I've found ... so if someone have some links to working examples please write 
|
|
|
|
|
If you open Registry Tab of Skype program, you can see a list of the same controll repeated much time.
It contain an image, a label and sometime a linklabel.
On the right side there is a scrollbar.
So how can i create controlls like that? Is it overloaded a simple multiline textbox or what?
thanks if someone try with me to get an answer
|
|
|
|
|
You asked the exact same question yesterday. Don't spam the forum.
---
b { font-weight: normal; }
|
|
|
|
|
I'm new to the printing aspects of .Net and have a question.
I have implemented the basic printing capabilities and have been able to direct a RichTextBox to a printer. I figured that when printing occured that same series of "drawing" routines called to display the text in the TextBox would be called again when drawing on the graphics object for the printer. However, what I have found is that my drawing methods are not called again to draw on the printer's graphics object (at least I assume so since the debugger dosen't break on my drawing code when printing).
So my question is how is printing done? Does .Net take the control's output and format it on the graphics object without actually calling my drawing code? If so, is there a way to choose what parts of the TextBox get printed or for that matter reformat the appearance of the text to make it look different than "what you see"?
Thanks,
Eric
|
|
|
|
|
Is there an easy way to create a thumbnail from a Windows Media Video file ?
Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
They are called TypeConverters, very handy stuff 
