|
Hi All,
I am currently working on a part of my project (using windows forms in C#.Net) which involves creating connection string based on values.
I have a simple form where the user can specify the type of database (SQL Server, Access etc.) and then give specific connection information based on the database type selected.
One thing I would like to be able to do is to allow the user to specify the OleDb provider when using an access database. I can easily allow free text entry for the provider but it would be much more user friendly if I could give the user a drop down of available providers for selection.
So... Does anybody know have I could retrieve such a list?
Thanks
...Oh, and before anybody wants to complain, I have had no luck with google
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Hi
I`m searching for the same thing.
The only thing i have found is using SQL function
EXEC master..xp_enum_oledb_providers
|
|
|
|
|
so that a customized user function can access it in order to search through it? The array should not be stored in a spreadsheet but it should be stored programmatically as a global variable.
It appears that there are limitations to the size of a function file so it cannot be stored in the customized function file itself. Plus, it does not make sense for the function to load the array each time that the function is called.
modified on Wednesday, May 13, 2009 10:27 AM
|
|
|
|
|
What are you trying to achieve? Why the need for the large array? What is it doing currently? How large is large?
Have you considered storing the array data in a table in whatever database you are using, and accessing it that way? Much better than trying to mangle Excel to behave like a database.
|
|
|
|
|
I need to develop a specialized user function that will search an array consisting of 16500+/- records and two columns. If I were to load the array each time the function is used, and if there were 10,000 records in the spreadsheet to whic the formula should be applied, it would take a great deal of time. Thus, it would be more appropriate to store the array as a global variable and to only search throuh the array in the function.
Is it possible to store the array as a global variable and to access the variable inside a customized function? To create a customized function, press Alt-F11 key at the same time and then "Insert > Module". A new customized function can be written here, but it has a certain file size limitation that will not accommodate the two dimensional array. To use the new function select "Insert > Function".
|
|
|
|
|
How is the array going to help you more then having the 16500 records in a table, and using SQL to extract the records you want?
What specifically are you doing?
|
|
|
|
|
Read this article:
http://office.microsoft.com/en-us/excel/HA011117011033.aspx?pid=CL100570551033[^]
OK. I have an array created inside the function, and then I search through the array for a match of a value and return the second value as the result. The problem is that it does not make sense to create the array each time the function is run. Can it be stored some place else so that the function has access to it?
|
|
|
|
|
How to colorize partial background of item in rowset of listview?
example:
have my_var=75 colorize 3/4 of item, have my_var=50 colorize 1/2 of itema, have my_var=72 colorize ecc...
Similar a progressbar but stop for filling based value in my_var...
|
|
|
|
|
sal21 wrote: How to colorize partial background of item in rowset of listview?
You can "enable" drawing your own stuff by using owner-drawing[^] for the ListBox. Next, use the e.Graphics.FillRectangle method to fill your cell to the desired value. There's an example on drawing your own ListBox-parts.
Good luck 
I are troll
|
|
|
|
|
but i need for vb6 classic, no net.
tks.
|
|
|
|
|
When i try to add a SQL Database item from "Add New Item" menu to my ASP.NET project i always get this error message
an error occurred while processing the local data file:
key not valid for use in specified state.
Help, thanks
|
|
|
|
|
Hi,
Kindly let me know that, How may I use following Oracle Query into MSACCESS ?
SELECT PCODE,PNAME FROM PRODUCT WHERE PNAME LIKE('%APPLE%')
Thank you in Advance
(Riaz)
|
|
|
|
|
Try exchanging the "%" for "*".
|
|
|
|
|
You can use * instead of %.
|
|
|
|
|
Hi man,
In Ms Access, it can be achieved by
SELECT PCODE,PNAME FROM PRODUCT WHERE PNAME LIKE('*APPLE*')
Just replace '%' sign by '*' sign
Hope this helps
Niladri Biswas
|
|
|
|
|
I've developed this project that uses SQL Server CE. I've got my reference in and everything works fine for me. But when the user tries to install the program, she gets an error that says she's unable to load sqlceme35.dll.
So now I'm really confused. I could just include a reference to sqlceme but then when I send it to her again she'll probably get another error for another dll with my luck. I'm not sure what all files I need to include to make sure she can run this program. And I'm not sure where to look....help?
Denise "Hypermommy" Duggan
|
|
|
|
|
I had this same error here while migrating a windows CE system from VS 2003 to VS 2008.
There were a number of workarounds suggested on Google, none of which worked for me. I ended up re-writing quite a lot of code on the forms that were causing that error, however, I also installed the following on my Windows Mobile device.
sqlce.ppc.wce4.armv4.CAB
sqlce.repl.ppc.wce4.armv4.CAB
They can be found on your computer at this location: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\wce400\armv4
Whether it was the change in my code or the files I installed, I can't say (I was getting a massive set of random errors in the converted code, which went round in circles for quite some time, so can't remember off the top of my head if it was the code change or files installed that sorted out that specific error).
Good luck with it!
|
|
|
|
|
I found something on another board that answered this question for me. I hope I'm not breaking the rules, but I do wish to give credit where it's due. The link to what I found is http://www.eggheadcafe.com/conversation.aspx?messageid=31741425&threadid=31741420[^]
Basically, four files need to be included. These are:
System.Data.SqlServerCe.dll
sqlceme35.dll
sqlceqp35.dll
sqlcese35.dll
I had the first and 2nd, but not the other two. These just need to be included in the project, not installed or anything.
Whew!!!! At least that's that.
Denise "Hypermommy" Duggan
|
|
|
|
|
Forgot to mark previous as an answer.
Denise "Hypermommy" Duggan
|
|
|
|
|
I am using the free version of SQL 2008 that comes with Visual Studio. If i wanted my windows VB program to allow more than one user to add, edit, delete info is that possible? Are there limits to number of people accessing the database or limits on installing that on our server at work for 2-3 people to access?
|
|
|
|
|
|
|
If 'C' is constant or it is positional you can use substring to identify the following #n characters and isolate them into a variable. Then just include it in your insert.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi friends
Has anyone done a db for a multi-level compensation structure? I'm talking about a company that is MLM or a multi-level marketing network. Where distributors sign up under other distributors and the "downline" can go down many levels(but limited levels!). I need a sample MLM structure.Could anybody help me please.
Thank You
http://tutorialcode.blogspot.com/
|
|
|
|
|
wajans wrote: Has anyone done a db for a multi-level compensation structure?
Yes, lots of people
wajans wrote: I need a sample MLM structure
Think in terms of parent/child relationships, that should get you going in the right direction.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
