|
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.
|
|
|
|
|
You can look into C# Database[^] section of this site which has so many examples.
Mazy
"One who dives deep gets the pearls,the burning desire for realization brings the goal nearer." - Babuji
|
|
|
|
|
I'm looking for a button that has an arrow next to it, and the arrow drops a list of buttons, and whichever button is pressed becomes the main button. I'm sure Word and the VS/NET IDE have them, but I can't see any evidence that they are not custom controls. I'm just double checking before writing my own....
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
As a standalone button there is nothing like this in the framework. But the ToolBar has this (its called DropDownButton) as a special button style.
I never tried how this looks but you could just drop a very small toolbar with just one button onto your form...
|
|
|
|
|
Hello,
I have an ImageList of 16x16 images, which I populate by calling AddStrip , so all images come from the same BMP file. Is there a way to get an Image object for one of the images (say, the one with index 3)?
Thanks in advance,
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Try imageList1.Images(3)
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
Yulianto AKA goodmast3r wrote:
Try imageList1.Images(3)
That won't do it. That collection contains the source images (in this case, only one, my single .BMP file.)
I was thinking that I will probably have to create an in-memory image, and draw the corresponding image from the imagelist there.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Been reading CP for over a year - great site! first post (be nice )
smidge of history: I've been working with C# for over a year and a half. This includes two applications with over two months of development each written almost completely by myself in use by customers in a commercial enviroment. I've converted a bunch of my friends from MFC evilness to C# Forms.
My problem: I'm creating a UserControl that shows a Direct3D (9.0C) drawing. I've created the panel and had it just clear the background to blue. Built. Dropped the user control (DXPanel - my name) into the form via the Designer. It runs properly. I then added a simple 2D triangle to the DXPanel, and now the Designer hangs whenever I attempt to touch the position or size of the panel or form. It is rendering the Direct3D within the Designer.
three questions (only need answer to one of them):
1. How do I tell the Designer to not show that custom panel while still allowing the built program to show the panel?
2. How do I tell the Designer to not render Direct3D stuff in general?
3. Is there a fix so that the Designer won't hang when rendering Direct3D?
|
|
|
|
|
Use this where it applies:
if (!this.DesignMode)
{
//Direct3D rendering code
}
|
|
|
|