Database

Thanks for your suggestions, i will be share this on Tips/Tricks sections sunaSaRa Imdadhusen +91 99095 44184 +91 02767 284464

What you need to do is use the LPAD function in SQL Server to pad the number to a set size. So, suppose you want to have it padded out to 10 characters, you'd use UPDATE TableName SET AccountNumber = LPAD(AccountNumber, 10, '0') I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be Forgive your enemies - it messes with their heads My blog | My articles | MoXAML PowerToys | Onyx

third method:- 2) Initialise 1st data adapter 3) Initialise 2nd data adapter 4) Initialise 3rd data adapter 1) Open sql connection 2) fill for the data table 1. 3) fill for the data table 2. 4) fill for the data table 3. 6) close connection. 5) Process my work As to your second method... you do know that the DataAdapter will handle the open/close for you don't you? Better yet, don't use DataAdapters, but that's another subject. P.S. And why use separate ones rather than only one?

Hmm 2000 is a long time ago but I'd try this, attempt to connect using your existing IP address, when that does not work think about your question. If you are using a named server you may not need to change the connection information. Never underestimate the power of human stupidity RAH

These are all wonderful, thank you so much for the valuable incite! :)

The google force is weak in you. Have a look here.[^] "When did ignorance become a point of view" - Dilbert

Are you sure you got the instance name correct? To find out the installed instances, follow the steps in this answer I posted for a similar question http://www.codeproject.com/Messages/3614783/Re-How-to-find-SQL-Server-name.aspx[^] Cheers, Karthik

Since your SQL query seems to be OK it could be one of two things. It could be that you conversion from strinw to stringc is doing something with the query (eg you are getting strange characters in your query because of conversion issues). A second potential cause could be that the pManager->SQLdb.Query function doesn't actually execute the query but just prepares the internal object for execution (but I can't say this for sure as I have no idea what the buildup of that class is). There is also a note in SQLite that case insensative unicode matching doesn't work see point 18. I hope this helps you a bit along.

Good Day David This is exactly my problem. So the workaround this is to split the XML. Thanks Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

There are times I just use List<> or Dictionary<> when I don't need anything more than that. The main reason I use what I described is that 1) I want to encapsulate the CRUD operations at that level so the item classes are lighter weight, and 2) I want to provide other functionality than I get with List<> or Dictionary<>. I could, and have, used factory classes, but for some reason I am partial to strong encapsulation.

Logging is probably a good idea. My GUI already makes automatic backups :rolleyes:

I assume mysql has similar sorts of functions but I have not had the pleasure, but in T-SQL / SQL Server you could do: select ID = right('0000000' + convert(varchar(20),ID),7) from MyTable -- ID can be int or varchar or select ID = right('0000000' + ID,7) from MyTable -- OK only when ID is varchar. Likewise you could put this into an update statement if for example you are in the process of converting your ID column from type int to varchar/text etc.

With SQL Enterprise Manager Query Results in grid view you can't display new lines - I came across the same only this week. I think they get converted to spaces deliberately prior to being dumped into the grid so everything stays on the one line. Microsoft made the call - most developers, most of the time, want to see most of their data without stretching the row-height every time they run the query. But trust me, those 13-10s/CR-LFs are working. As someone else said - you are the only person who will see this grid. If you want to whack this query into a .NET winforms grid view, it is possible to get the multi-lines to show there by setting a couple of properties (I could look it up for you, but I won't). And of course, make that query a view, link to the view from Microsoft Access as a linked table and you will see multi-lines. I will now run for cover.

Why would the number of clients really matter if your indexes are correct? I understand that the record set has an affect on total time but I don't see how that really relates to a CONCAT for example. If you are going to have to CONCAT last and first name on 1000 clients what benefit would you have from doing it locally instead of the server? Also in either case the concatenation I think the concatenation would be happening in memory so in theory the server should have more... and I would think that the CONCAT statement written in my case mySQL is probably more efficient than the equivalent code in .NET. Thanks for your thoughts I do appreciate your input just want to have a full understanding of your reasoning. Humble Programmer

So up vote the answer in appreciation! Never underestimate the power of human stupidity RAH

Can you clarify 'locked' is it encrypted, is it read only is you source control stopping you from checking it out. Never having used the CLR to create a stored proc we need more info to help. Never underestimate the power of human stupidity RAH

Hi, Would the example[^] on the bottom of that page work? I are Troll :suss:

Error 5 indicates that the access has been denied; your share probably needs a username/password combination. If you want to share your data, create a TCP/IP connection to the server from a remote machine, putting the database on a unc-path is asking for problems; MSDN states:[^] If access to a disk resource requires that a share be mapped, or if the disk resource appears as a remote server through a UNC path, (for example, \\Servername\Sharename), on the network, then by default, the disk storage system is not supported as a location for SQL Server databases. I are Troll :suss: