iebidan

I think you know the cell the user is standing at the moment he uses the edit button right?, how many rows or columns your datagrid has?

Try to use SelectedIndex instead of SelectedItem, if the item is the last one, you can select it by counting the items

mmmm I missed the web application part, why I always think ppl develop only in WIndows Forms? lol, sorry about that, yeah connection pooling to speed up things is what .NET implements in web applications. Thanks PlausiblyDamp :P today is not my day... too much stuff to check in so little time.

you want to reset the array during the execution of the method? because when the method ends the array will be reseted, unless you're using it as part of the whole object instead of the method.

You can use multiple catchs depending on the errors you expect and a generic catch. What I do is in the generic catch send a fatal error or try to do some code, if everything fails that's when I send the fatal error message or capture it with the AppDomain Exception Handler I use in my apps.

What happens if you remove this??? you're telling your current thread to wait / sleep for 5 minutes.

I'm talking about .NET free IDE's I don't know about the others, actually at this moment I don't have to worry about other languages besides C# and SQL, if one day I need to worry about VB or C or Java or anything I will do it, so far I've enough stuff going on with C#

use Query Analyzer to check your code and use the Execution Plan to get a good idea on what's going with your SP's that's how I do it. Execution Planes gives you a really good report on each thing going on in your code.

I'll support Marble_Eater, use arrays, you can't do a dynamic variable naming

Most free IDE's are C# oriented, I don't think you'll be able to find an IDE for Progress with the intellisense stuff like VS .NET, remember that VS .NET has a huge team working in it, while the other IDE's are just a school project or don't have the team VS .NET has. I think you will need to code your own plug ins, as for me I'm not interested in writting a plug in that I will never use, C# and SQL Server are what I use, from time to time (very very few times) Oracle. But if I find something in the internet I will let you know, good luck :cool:

lol yeah, I trie dto use the VARIANT data type, I was doing something really stupid to check .NET, surprise surprise variant is no longer available. So after checking all the apps and the variants I was using (API calls or web apps) we cried a lot, but we managed to upgrade from VB6 to .NET in a very smooth way

This is my experience, I was a VB developer, when .NET was a BETA I decided to take a look to it, sheesh!!!!!! VB changed!!!! where are my VARIANTS???, after reading a lot about .NET I understood that the main goal for VB was to be a OOPL not a sem OOPL. Moving to .NET won't be that hard, yeah you will need to read a lot about OOP and maybe some C syntax (if you're planning on using C# instead of VB), but after that everything will be smooth and easy. .NET is a nice platform and you won't regret it, moving form VB to C# is nice and easy too. Yeah upgrading large applications is a pain, but at the end you won't regret to do that too.

will be the same that happened with VS 2002 and 2003, you can't use FW 1.1 in side VS 2002, but you've compatibility in 2003 for FW 1.0 In VS 2005 same thing, you'll have compatibility with FW 1.0 and 1.1 but you won't be able to use FW 2.0 inside VS 2003 or 2002. Anyway, why should I worry about using FW 2.0 in VS 2003?? if I upgrade to 2005 I'll upgrade all my apps, when I did it from 2002 to 2003 was simple.

the wild card in SQL Server (Microsoft) is % SELECT * FROM TABLE001 WHERE COLUMN001 LIKE 'ABC%'

I will answer your questions, you can find information on companies using Microsoft products and their cases at Microsoft's Case Studies yeah it's a Microsoft 's page, but you can find tons of information, now you'll get a case from me. I currently work at BP , we merged with several big companies around the world in the last 5 years (Castrol, Mobil, Arco, Amoco, Aral, TNK Russia and several more), those companies had their own applications based on Unix, Lotus, Linux, etc. It was a major movement, but currently we've 95% of all employees and contractors moved to Exchange Server, 100% of all users using Windows Servers and Windows Desktop OS, 100% of all user are with Office System 2003, 85% of all databases were moved to SQL Server 2000, still working on some Oracle databases and so on, why we did this?, the answer is, TCO cheaper, Help Desk Support faster and more reliable, Development is faster, we don't need to give specialized training to users. We still have and will have Unix Systems, but this is because the specialized applications we have and they only exist for Unix. BP is one of the companies that I can say 85 to 90% of the platform is Microsoft.

As penfold69 said, but having a case sensitive or not database depends on the collation you are using, check the SQL Books documents to see which collation is cases-insensitive in your language

Work as a BIS (Business Information Supervisor) for British Petroleum

You need to create your own control and add the styles you need or want, custom control

I'm not a natural portuguese speaker, but you can contact me in portuguese if you find it hard to do it in english (I speak portuguese and spanish besides english)

I'm a C# developer, if you want to add me, go ahead (rodrigo_sandoval_V@msn.com), but I'm pretty busy the whole day, so I don't know how useful I'll be for what you want, sometimes I won't answer for hours.

I'm not talking about storing emails or junk, piracy is a federal crime, so, yeah, transfering MP3's using a peer to peer software is a crime, using email is a crime, so my point is, who cares about 1Gb for storage.

Who wants GMAIL? 1GB? I can't use my 250Mb in Hotmail, worst, I can't use 1Mb of my hotmail account, do you really need 1GB???? you will not use it for company purpose are you? what other use you can give to it? store really old mails? junk mail? transfer MP3's, remember that doing that you're breaking a couple laws, so who cares about 1Gb. I recieve 400 emails everyday in the company's account, and I don't have 1Gb used, 80% of the mails end deleted, so tell me a good reason to get GMAIL. Cheers

hmmmm let me see what I asked and what I got Wish List: - New BMW (330 will be nice) - Only 40 hours a week at the office (currently working 60 hours at least) - Clothes, lots of clothes - X-Files DVD collection (all seasons) - PS2, XBox Games (any game will do) - A house (I live in an apartment) What I got: - 1 tshirt - More debts in the credit cards bah, Santa hates me

Yeah, I did, I found out this 10 minutes after posting this, thanks anyway, sorry for the delay on posting the solution, I was trying to set the timeout in the connection string. Sometimes my brains seems to work in a very slow way

Hi guys, hey I've been out of the forums for a long time, also out of programming, but now we've a problem and prolly you know the answer to this I've a stored procedure that takes too long to execute, it processes large amounts of information (up to 750 million rows) but when we call it (using the following code) we get a timeout, how can I make my application wait til the procedure is done? also this stored procedure calls 11 user defined functions. If I execute the procedure using Query Analyzer it runs perfectly and I never get a timeout. How can I solve this? string sDate = "20041130"; string sLastDate ="20041031"; string sConnect = "server=--;UID=--;PWD=--;DATABASE=--;"; SqlConnection Conn = new SqlConnection(sConnect); SqlCommand ObjCmd = new SqlCommand("sp_inv",Conn); ObjCmd.CommandType = CommandType.StoredProcedure; SqlParameter DateParam = new SqlParameter("@DATE",sDate); ObjCmd.Parameters.Add(DateParam); SqlParameter LastDateParam = new SqlParameter("@LASTDATE",sLastDate); ObjCmd.Parameters.Add(LastDateParam); try { Conn.Open(); ObjCmd.ExecuteNonQuery(); } catch (SqlException ex) { MessageBox.Show(ex.Message.ToString()); } finally { Conn.Close(); Conn.Dispose(); } Thanks in advance