|
SimonH76 wrote: Does anyone know of any best practices winforms projects in C#?
Best Practices are a fundamental thing. They don't change whether is is ASP.NET or WinForms or a Windows Service and so on.
There may be slightly different patterns for applying those best practices but thats it.
|
|
|
|
|
|
|
|
hi to all,
i m using the sdk editor for Windows CE 6.0 platform
i want to change the settings of default keys like for menu if i access the
popup item of menu using the up down keys and Enter key to select that item.
Instead of these keys i want to use char keys like 'P'key for 'Enter' Key
i hope i'll get the soln
thnx in advance
Pankaj
|
|
|
|
|
I’m trying to emulate the look and feel of something like MS Office Accounting, with a common form layout of two lists of label-control pairs, one at the top left of the form, and the other at the top right. Below these is normally a grid, or other controls that span the whole width of the form, e.g.
-|-
-|-
_|_
___
Now it seems to me that the TableLayoutPanel should be the basis of this, allowing the two top sections to dynamically size as the form sizes horizontally. However, I don’t know whether to use four columns, for left label-control and right label-control, and one row for each two label-control pairs, or to use two columns, and a separate container in each column for a vertical list of label-control pairs.
I’ve never used these layout controls before so any advice will be much appreciated.
|
|
|
|
|
Brady Kelly wrote: I’m trying to emulate the look and feel of something like MS Office Accounting
I've never seen it. A screenshot posted to ImageShack might help.
|
|
|
|
|
I have a VB.NET application that runs perfectly on my development machine but when deployed on the customer's machine runs horibly. Both my development machine and the customer machine are alike in that they have both a core2 duo and 2 gigs of ram. The appplication uses SQL Server Express as the data backend. Any time the application performs a function the program hangs before finally completing. "Program Not Responding" is displayed in the title bar during the time the program hangs. I observed the machine resources during this time and there are plenty of resources available. Has anyone run into a simular situation and if so what is the resolution to this problem.
|
|
|
|
|
Run it in debug mode to find out exactly where it is hanging
led mike
|
|
|
|
|
It runs perfecly on my machine. I can't debug it on the customer's machine and there are no errors and it hangs on everything the customer does.
|
|
|
|
|
nathan22405 wrote: I can't debug it on the customer's machine
Are you sure?[^]
nathan22405 wrote: Both my development machine and the customer machine are alike in that they have both a core2 duo and 2 gigs of ram.
It must be something that is different then. So you ruled out processor types and amount of physical ram as the problem. Good start.
led mike
|
|
|
|
|
I hangs on anything that requires access to the database. It's a bit unpredictable though, I can open lets say the inventory screen and it hangs while opening. Once it finally opens I'll close it right away and then reopen it The next time it opens right away and it will for the next 10 or 15 times back to back and then it goes back to hanging again. It's like windows of time will open up and it will work fine and then it goes back to hanging again. I'm thinking it has something to do with the SQL Express and the way I'm using it. Creating connections ect. On my development machine I connect to SQL 2005 Server and not to SQL Express and I never have problems like this.
|
|
|
|
|
nathan22405 wrote: I'm thinking it has something to do with the SQL Express and the way I'm using it. Creating connections ect. On my development machine I connect to SQL 2005 Server
Possible that SQL Server Connections are being pooled by DTS on your machine while the SQL Express version is not. Depending on how you developed your code you may be creating a new connection in many cases.
led mike
|
|
|
|
|
That's what it was. I created a global variable for the connection object. I opened the connection once on the start of the program and ran all commands through it. The Problem went away. THANKS!
|
|
|
|
|
nathan22405 wrote: The Problem went away.
Yes but by using a global variable you may very well have created new problem(s) that you may have to deal with in the future. You might want to study some topics like:
Object Oriented Programming specifically Principles of Object Oriented Programming
Software Design Patterns
Software Development Best Practices and Principles
there are certainly more but that would be a good start
led mike
|
|
|
|
|
That's a HUGE bad practice. In an SQL Servce environment, you've just grabbed a very expensive connection license and are holding it indefinitely. That connection won't be doing anything for about 95% of the lifetime of your app. Does that sound like a good use for a license that costs $$$??
You also didn't solve the problem. You merely got around it by opening the connection once, which will probably have that delay.
What does the connection string look like?? How are you opening the connection when you want to make a query?? How are you USING the connection?? Is it being closed properly when you're done with it??
|
|
|
|
|
Let me clarify this a little bit. We are using SQL 2005 Express. No licenses needed here. Actually what I'm doing in our application is we have a wrapper class that encapsulates all the data access functionality throughout the program. (Execute, ExecuteScalar, ExecuteNonQuery, ...) Additionally we have functions that return datasets and update datasets) Our program can run on a local database or through web services to our hosted databases. I have a global variable (g_Data) that is an instance of our wrapper class. When this class is initialized a connection to the database is made and when the class is disposed the connection is closed. What I have found when using the SQL Express is that when opening connections, running a command, then closing right away a bottleneck occurs when several calls are made back to back to the database because SQL Express does not handle multiple connections at a time. It hangs and waits for a connection to close before continuing. I forgot to mention our program is multithreaded. It has a few background threads that run and perform various maintenance routines. These maintenance routines require data access so if one of the threads has a hold of a connection then the user will experience a wait and often times will get a "program not responding" message in the title bar. When I changed the wrapper class so that only one connection was made upon initialization and all sub sequential commands run through that connection. The problem went away.
|
|
|
|
|
nathan22405 wrote: Let me clarify this a little bit. We are using SQL 2005 Express. No licenses needed here
Not yet. But if you apply the same solution to a full SQL Server database, or if you existing app is scaled up to the full version, your "solution" would get you escorted to the door pretty quick.
nathan22405 wrote: What I have found when using the SQL Express is that when opening connections, running a command, then closing right away a bottleneck occurs when several calls are made back to back to the database
I've never run into the problem, doing just that.
nathan22405 wrote: SQL Express does not handle multiple connections at a time.
Wanna bet? SQL Server Express doesn't have a connection limit, other than machine resources. It uses the same communications engine as the full SQL Server.
It's possible that your code, or connection string, isn't allowing ADO.NET to cache/pool connections or is not doing it efficiently.
|
|
|
|
|
I will look more into this. Thank You. On my development machine I in fact do connect to our Full SQL Server 2005 and did not have these issues even prior to the change I made. It was only when connecting to the SQL Express upon deployment on the cutomers machine. Would the fact that it connects by attaching at runtime have any effect on this? I am new to using SQL Express.
|
|
|
|
|
Hello
How can i move a rectangle with Mouse on C# form.
|
|
|
|
|
By handling the mouse move event and invalidating the form in there, then drawing the rectangle in your paint event.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Ask a simple question, get a simple answer...  
It has become appallingly obvious that our technology has exceeded our humanity. - Albert Einstein
|
|
|
|
|
hi all,
please help me in this problem.how can we import data from excel sheet to ms access database table .i am using c# windows application.
thank you.
regards
obalesu n
|
|
|
|
|
Access can import an excel spreadsheet directly, without using C#. If you go to the File/Get External Data/Import menu you will see that one of the file types is Excel. This is in Excel XP, I do not have Excel 2007 but I assume it will be the same.
Hopefully this will solve your problem.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
thank you. and i have faced another problem in my windows application(c#,ms access).i am using backend as ms access.i have written code like this.
string s="datasource=C:\\cms\\cmsaccess.mdb";
string q="select * from users";
OledbConnection con=new OledbConnection(s);
OledbDataAdapter adp=new OledbDataAdapter(q,con);
DataSet ds=new DataSet();
adp.fill(ds,"users");
i have written like this in every form .but if i installed in server how the application access that database(C:\\cms\\cmsaccess.mdb) in clients .the database location may be changed in clients.i am facing this problem. this application must be run in network.please send solution for this problem.
thank you
regards
obalesu n
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
