|
Hi,
How can I directlly connect to mySQL server from C# without an ODBC drive? connecting through ODBC means I have to include mySQL Connecter/ODBC in my distribution media.. I want to only distibute my application..
|
|
|
|
|
|
hello,
i have been told to develop an application that has a country map displayed along with all its states. now whenever i move my mouse over a state, the stae gets highlighted and when i click on a particular state an event gets trigerred and some data is displayed on the map. what tool should i do to accomplish this.
see this example
http://www.lq.com/lq/map/index.jsp[^]
|
|
|
|
|
|
Well the link that you gave as an example used Macromedia Flash to do the animation and the mouseover type of information. You could use an html map function to create a map on an image,it might allow you to put a mouseover type of event in, but it has been a while since I have done that. You could make evach state into an image in the application and then just use the custom drawing routines on CP to draw them for each state.
Is this a web app or a Windows App?
Steve Maier, MCSD MCAD
|
|
|
|
|
its a windows application. I couldnt figure out what you meant to say above so could you please elaborate what you meant...
|
|
|
|
|
Well you could use a flash plugin (OCX) in your application and then let the flash coding do all of the highlighting and animation. You could also make a custom drawn image or button that has the correct shape as each state, but that is alot of manual work.
Steve Maier, MCSD MCAD
|
|
|
|
|
Hi all,
I have a problem for data transactions across two databases.
That is one object's data is comprised of two tables from
two different databases. I can perform rollback and commit within
one database. But for this case, how can I perform rollback and commit
across two databases for the object ?
Thanks
|
|
|
|
|
two databases in same server?
Sorry ...
|
|
|
|
|
Have you looked at Microsoft DTC (Distributed Transaction Co-ordinator)?
|
|
|
|
|
Giday Dudes!!!
I have written a c# dll Shared Addin for Excel. In this dll Addin I reference a COM dll for Axapta. This COM is excluded in the dependencies as it will already exist on client computer.
An initial problem I am having is that when the VBA goes to create my C# object it says "Cannot create object". (I can see the object properties and methods though) Is this because vba does not like constructors in C# or you cannot pass parameters in the constructor. Or should I just be using Regasm tool
Another problem is that when I build the project it references my Axapta COM object from the folder it exists in. It seems to expect and needs the dll to be in the same folder on the client machine which it is often not. How can I get around this (build with reference to the dll in my project folder?). VB 6.0 takes the dll on the local machine that is registered.
Slightly confused, help needed
Cheers
mit
notsnoj
|
|
|
|
|
Jsut can help you with the last one:
If you have referenced your COM component via the COM tab in 'Add References' it will all work well. Although there is an absolute path in the properties your app will always use the registered one.
|
|
|
|
|
Thanks Robert, you are right but as you can imagine the first problem prevents me from testing this. Hope somebody has something for the first problem.
notsnoj
|
|
|
|
|
Hi, guys
I am trapped into a big trouble on how to use unmanaged class library code in a C# web application.
Now, I am working on a project to develop a web interface for SPlus, a statistical software tool. By intuitive, I plan to apply C# to develop web side, which will invoke some unmanaged code to use functions of SPlus. I have developed a unmanaged C++ class UM_A to use SPlus functions, and also developed a wrapped managed C ++ class M_A for that unmanaged class UM_A, and used managed M_A in the C# application.
First, I tried those unmanaged and managed classes in a window-based C# application, they are really working, and then, I move them to web application. They are failed. The failure is related to an exception of "FileNotFoundException", suggesting that
File or assembly name M_A, or one of its dependencies was not found.
I am very puzzled. Could you guys tell me what is going on? I know that C# web application can use Pinvoke c to reuse window DLL, and Marshaling to visit COM. But can it reuse old class library by way of wrapped managed class, and how to do?
I read many articles on how to utilize wrapped managed class for the reuse of unmanaged class library, but all of them are related to windows application.
Thanks
david
|
|
|
|
|
hi every 1 ,
i'm working on simple chat program that sends files throw the netowrk , i'm using UDPClient.send method to send data and when i'm try to send large files the following error pop's up :
a message sent on a datagram socket was longer than the
internal message buffer or some other network limit, or
the buffer used to recieve a datagram into was smaller
than the datagram it self .
any 1 can help me PLZ.
|
|
|
|
|
Sending files using UDP is a bad idea. UDP comes with no guarantees that the packets will get to the recipient at all and does not guarantee that that they will arrive in the correct order! TCP would be a much better choice.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi again,
thanx for ur replay, I know that TCP is better but i have to use the UDP
i can send small files , but when i try to send a .PPS te message pop's up "the message is an exception"
any other idea ????
help realy needed in here
|
|
|
|
|
Hi all,
I want to use C# for programming databases. I want to create dynamic tables and also add insertion, update and deletion commands along with query processing on the tables created and also some operations like join, project, add etc. My question is
1) Can we do the above in C#
2) If we can, how can we do tht?
3) If not, Is there any other method by which we can do tht in C#, like using other applications as front end or beck end?
4) Are there any good tutorials on this application of c# other than using google plz?
My problem is to create a couple of tables and have to try all those functionalities (add, delete, insertion, multiplication, join, queries etc)
any kind of help is appreciated...
thanks in advance,
Suman
|
|
|
|
|
Suman Somanchi wrote:
I want to create dynamic tables and also add insertion, update and deletion commands along with query processing on the tables created and also some operations like join, project, add etc.
Do you want to create your own database engine?? or just create tables and perform queries on the tables you create?
Suman Somanchi wrote:
3) If not, Is there any other method by which we can do tht in C#, like using other applications as front end or beck end?
Try using SQL Server (or MSDE, which essentially is SQL Server for free) as your database back end. Search MSDN for information on where to download MSDE.
Suman Somanchi wrote:
2) If we can, how can we do tht?
With SQL Server/MSDE, you can use C# with ADO.NET, which is a set of classes to execute SQL queries and read resultsets. There are many articles about ADO.NET here in CodeProject.
If you use SQL Server/MSDE, it's actually very easy to do what you want. The only thing is that the MSDE license doesn't allow you to create applications that will compete with Access.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Hi LuciR,
Thanks for ur informative reply. Actually i want to do my course project of database design in C#. Previously I use Oracle SQL for doing this and visual basic as front end. Now i want to implement this using C#, but i want someone to guide me in right direction as i am new to C# databases. Here is wht i am plannin to implement...
1) To design and implement a database (with more than 3 tables) for an application (planning to implement aitport database).
2) To Design a set of transactions for my database and application. But my prof has given the following options. "Each transaction can be implemented in
C, Visual C++, Visual Basic, Access Basic, or any other high-level language that
can embed SQL statements.". But I want to use C# instead of those. I want to know whether it is possible and whether it is easy to implement.
I also want to implement dynamic creation of tables if possible.
Hope you will guide me in right direction and gimme some suggestions.
Thanks,
Suman
|
|
|
|
|
Suman Somanchi wrote:
1) To design and implement a database
The database design depends on the specific project and its requirements. I don't know what it is about, so I can't help here.
Suman Somanchi wrote:
2) To Design a set of transactions for my database and application
The transactions can be something like add record (INSERT SQL statement, whatever you are storing), delete record (DELETE), edit (UPDATE) o get info (SELECT).
You can do it in C# very easily with ADO.NET. Search CP for the articles on ADO.NET and you will find how easy is to execute a query and examine the results.
As for the database backend, you say you have used Oracle before. Using SQL Server is almost the same (well, basically) so you should have no problems getting started.
Good luck!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Hi LuisR,
Thanks again for ur reply. Ok here is the thing I will use access to create database tables. But can you guide me or gimme some good starting tutorials on how i can use ADo and SQL query to update my access database. Like inserting, updating, deleting, retreiving, joining, projecting etc.
Thanks again for ur help,
Suman
|
|
|
|
|
|
Hi,
Thanks for your tutorial/article. Can you tell me how i can start/begin programming in c#, like which form i have to open and wht i have to do.
I am askin too much details, sorry for that. I am new to this section of C# databases. If i use access database how i can do my programming in c#. Orelse i there any other easy or new way to create database(more importantly data tables)?
thanks in advance,
Pavan.
Suman
|
|
|
|
|
Suman Somanchi wrote:
Can you tell me how i can start/begin programming in c#
If you`re a beginner in C#,then I suggest you try learning the language first and understand the difference between c++ and C#. If you started from C. Try http://www.codeproject.com/csharp/[^] , there are many tutorial about C# there. That`s where I got started. Good luck with your learning.
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|