|
Hi
i want to insert datatable object to database, i know which can do this by SqlDataAdapter.Update() or TableAdapter.Update() methods, but my question is that is this work correctly for enterprise systems ?
have it high performance ?
what's best approach for this aim ?
(beacuse currently, i am develping a large application (enterprise system) for at least 800 concurrent users).
any idea would be appreciated
thanks
|
|
|
|
|
It sounds like you are using the MS data wizard objects. You should build a data access layer (DAL) and use dataset.fill, datareader and datatable. You should also be doing the CRUD via stored procedures.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi All,
In both my last job and my current job we have had applications that sit on (very) busy PC's which typically run anywhere between 10-20 spreadsheets in Excel, several internet explorers, market data systems etc. In both cases our C# application always runs out of handles and stops working (throws exceptions etc) with problems in the call to CreateHandle. Clearly whats happening is we are hitting the internal win32 handle limits. I know of a registry entry that I can change that will increase the limit but this at best still only stalls the problem - not fixes it. Others among you must have seen this problem so what did you do about it?
Cheers,
E.
|
|
|
|
|
I had many applications which works on busy systems and working without any issues. Looks like you have some design issues. Hard to help without getting more information on what you are trying to do.
|
|
|
|
|
Hello community,
I'm writing a programm which shell set other windows to the foreground. So I would like to know how I can check which process a window has, that I select via a mouse click. Is this possible with a API function?
Best regards
MyPiano
|
|
|
|
|
Hy,
Try the WindowFromPoint & GetWindowThreadProcessId APIs
|
|
|
|
|
Okay, thank you very much. 
|
|
|
|
|
Hi,
1) Can anybody tell me how can generate the connection string to my SQL Database from the solution explorer in VisualStudio2008.
2) Also can anybody tell me how i can resolve his error in my SQL;I tried the settings from Surface Area Config: but it didn't help 
Error "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
Many Thanks,
modified on Sunday, October 19, 2008 12:32 PM
|
|
|
|
|
new2pgrmg wrote: Can anybody tell me how can generate the connection string to my SQL Database from the solution explorer in VisualStudio2008.
The solution explorer displays the files in your solution. It can not be used to create a connection string.
new2pgrmg wrote: Also can anybody tell me how i can resolve his error in my SQL;I tried the settings from Surface Area Config: but it didn't help
What error?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Hi Guffa;
Thanks for trying to help.
For my first question i found the soln from server explorer.
"http://kb.seekdotnet.com/ViewArticle/119data.aspx"
For the second question this is my error message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
Thanks for the help
|
|
|
|
|
The error message simply means that no SQL Server is responding on the server address that you specified in the connection string.
Have you checked the address in the connection string?
If you have a firewall between the application server and the database server, you need to make sure that the port used by SQL Server is forwarded to the database server.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Hi Guffa,
Thanks for the help.
I resolved the issue.There was some issue with the connection string ;after resolving it my connection is working fine.The take away for me from here is if there is any issue with the connection string this error will happen.
Thanks Again for your replies.....
Keep up the spirit....
|
|
|
|
|
I m doing a customized crystal report having 30 feilds.based upon the font size of the feild and text object incresing an decresing the with . i know tht all the monospaced courier new having same width.so if i knw how many pixcel of each character occupied of each and every fon size from 6-12,it will easier to me .what i thinking if there 5 charcter in a text object ,so i can calculate each character*number of pixel=total pixel.based upon that tht i can set width of the text object through coding.same applicable for field object also.but i am new to crystal report programming .i m not getting all this .can anybody help me how to find of number of pixel in each character in diff font size and how to set the width of that text and field object through coding .I need urgebt help and plz help me by giving sample code for VS 2005 in c#.net.thanks and waiting 4 early reply.
|
|
|
|
|
I don't know anything about Crystal Reports, but allow me to share some of my knowledge about this forum:
0. If your post includes 'urgent', or in your case 'urgebt' you are actually less likely to get an answer (in fact, it's more likely you'll get flamed...). You should remember everyone here helps because they want to, so they might be a bit slow about it.
1. A spell-checked post, using full English words instead of this 'plz' rubbish, with proper capitalisation and spacing is far easier to read, and so more likely to get an answer (I, for example, run all my posts through MS Word's spellchecker before posting).
2. It is generally considered rude to double-post. It definitely won't get your problem answered any faster. The better thing to do would have been to alter your original post with the new info.
|
|
|
|
|
sure.I will definately keep into mind next time and thanks for ur advice.
|
|
|
|
|
how to change font size of the formula fields of crystal report dynamically ?????its urgent ....
|
|
|
|
|
First, the code that i´m using:
HttpWebRequest hRequest = ((HttpWebRequest)WebRequest.Create(url));
hRequest.UserAgent = "Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3";
HttpWebResponse resp = (HttpWebResponse)hRequest.GetResponse();
StreamReader reader = new StreamReader(resp.GetResponseStream());
string res = reader.ReadToEnd().ToString();
reader.Close();
textBox1.Text = res;
The problem is when i see html source into the textbox it appears bad formatted, dont know if each line of a texbox has a limit of characters and this is why it jumps to another line or what happens.
I set the wordwrap property of the textbox to false and added both scrolls bars, but it still bad formatted.
Can someone help me?
Thanks in advance.
|
|
|
|
|
Nothing is wrong with the TextBox. It's just the string you're getting get from the response is not formatted, the textbox outputs it as it is. Most, if not all, compilers and interpreters don't generate formatted response. If you're calling a static webpage, it's just the way it is.
Eslam Afifi
|
|
|
|
|
Ok, and how can i format the response because if i see the html of google.com into firefox it appears formatted, but into my textbox no.
Any idea how can i output the html source formatted into a textbox??
Thanks in advance. 
|
|
|
|
|
You'll have to format it yourself. Google and see if someone wrote something you can use or code it yourself.
Do NOT use the method where you put the html in xml and output it formatted simply because html can be not well formatted xml.
Eslam Afifi
|
|
|
|
|
Mmmz... using a richtextbox instead a textbox seems that solve the problem.
Thanks for the replies.
|
|
|
|
|
You're welcome. The problem was that the TextBox uses the Environment.NewLine while the RichTextBox uses any of '\n' and '\r' too as line breaks. I didn't know that, thanks for the info.
Eslam Afifi
|
|
|
|
|
Hi
I'm Using LandScape Property Of PrintDocument by this code :
void printDocument_PrintPage(object sender, PrintPageEventArgs e)
{
e.PageSettings.Landscape = true;
}
all page is LandScape except First Page that in not LandScape !!!!
|
|
|
|
|
Could you set the PrintDocument.DefaultPageSettings.Landscape to true, before you start printing.
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
