C# Discussion Boards - CodeProject

Syntaxo31-Jan-05 5:27

31-Jan-05 5:27

Ahh! Tested it again now more thoroughly. My deepest apologies to both lainoo and You mav, the code works it just don't apply to tabs (\t) which the regexp "\s" seem to do. Blush | :O

I got confused when I saw the big gaps in my string but when looked at closely they are mixed blanks and tabs. The method works way faster than the regular expression I used, now I need to find a way to include tabs.

I guess I'll have to go with a double run to first remove all tabs?

Thanks a lot!

Best regards,
Daniel

Re: Remove multiple blanks in a string?

mav.northwind31-Jan-05 6:15

mav.northwind

31-Jan-05 6:15

Nice to see you were persistent enough to actually try Smile | :)

I think a simple call to

st = st.Replace("\t"," ");

before the loop does the trick.
You don't have to care about double (or more) tabs, since the resulting double (or more) blanks are taken care of in the loop anyway.

mav

Re: Remove multiple blanks in a string?

Corinna John31-Jan-05 2:51

Corinna John

31-Jan-05 2:51

//split string
String[] parts = strIn.split(' ');

//re-build string
StringBuilder newString = new StringBuilder();
for(int n=0; n<parts.Length; n++){
  if(parts[n].Length > 0){
     newString.Append(parts[n]);
     newString.Append(" ");
  }
}

//remove trailing space and return
newString.Remove(newString.Length-1, 1);
return newString.ToString();

_________________________________
Vote '1' if you're too lazy for a discussion

Re: Remove multiple blanks in a string?

Syntaxo31-Jan-05 3:42

Syntaxo

31-Jan-05 3:42

Can't get that to work since it seems to split directly after the first blank found and leaving the remaining blanks in the string-array items Cry | :((

Best regards,
Daniel

Re: Remove multiple blanks in a string?

leppie31-Jan-05 7:32

leppie

31-Jan-05 7:32

Create a static instance of the Regex object with Compiled flags, and reuse that object to do the replace. Much of the processing is used when the method u are calling is being constructed internally.

^{top secret
Download xacc-ide 0.0.3 now!
See some screenshots}

connect to mySQL

Jassim Rahma31-Jan-05 0:57

Jassim Rahma

31-Jan-05 0:57

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..

Re: connect to mySQL

Colin Angus Mackay31-Jan-05 5:16

Colin Angus Mackay

31-Jan-05 5:16

jrahma wrote:
How can I directlly connect to mySQL server from C# without an ODBC drive?

Use the MySql ADO.NET connector: http://www.mysql.com/products/connector/net/[^]

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Displaying Interactive Diagrams

Mridang Agarwalla31-Jan-05 0:14

Mridang Agarwalla

31-Jan-05 0:14

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[^]

Re: Displaying Interactive Diagrams

DavieB31-Jan-05 4:50

DavieB

31-Jan-05 4:50

I would say whatever tool best suits your current skills. Are you a programmer?

Check out Mappoint http://www.microsoft.com/mappoint/default.mspx although this maybe much more than you need.

Re: Displaying Interactive Diagrams

Steve Maier31-Jan-05 10:43

Steve Maier

31-Jan-05 10:43

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

Re: Displaying Interactive Diagrams

Mridang Agarwalla1-Feb-05 19:55

Mridang Agarwalla

1-Feb-05 19:55

its a windows application. I couldnt figure out what you meant to say above so could you please elaborate what you meant...

Re: Displaying Interactive Diagrams

Steve Maier2-Feb-05 4:39

Steve Maier

2-Feb-05 4:39

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

SQL transactions commit and rollback

ppp00130-Jan-05 21:52

ppp001

30-Jan-05 21:52

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

Re: SQL transactions commit and rollback

lainoo31-Jan-05 2:18

lainoo

31-Jan-05 2:18

two databases in same server?

Sorry ...

Re: SQL transactions commit and rollback

DavieB31-Jan-05 4:44

DavieB

31-Jan-05 4:44

Have you looked at Microsoft DTC (Distributed Transaction Co-ordinator)?

C# dll VBA Excel Addin

mitsemaj30-Jan-05 18:58

mitsemaj

30-Jan-05 18:58

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

Re: C# dll VBA Excel Addin

Robert Rohde30-Jan-05 19:06

Robert Rohde

30-Jan-05 19:06

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.

Re: C# dll VBA Excel Addin

mitsemaj30-Jan-05 19:35

mitsemaj

30-Jan-05 19:35

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

how to used unmanaged class library on a C# web application

smallcase30-Jan-05 16:54

smallcase

30-Jan-05 16:54

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

sending file using UDP error

Sakkijha30-Jan-05 11:16

Sakkijha

30-Jan-05 11:16

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.

Re: sending file using UDP error

Dave Kreskowiak31-Jan-05 1:34

Dave Kreskowiak

31-Jan-05 1:34

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

Re: sending file using UDP error

Sakkijha31-Jan-05 4:02

Sakkijha

31-Jan-05 4:02

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

How can we program databases in C#?

Kiran Satish30-Jan-05 10:06

Kiran Satish

30-Jan-05 10:06

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

Re: How can we program databases in C#?

Luis Alonso Ramos30-Jan-05 10:13

Luis Alonso Ramos

30-Jan-05 10:13

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!

Re: How can we program databases in C#?

Kiran Satish30-Jan-05 17:54

Kiran Satish

30-Jan-05 17:54

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

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.