Answer Questions
boondoggle Delayed Datareader column error
In a live application which i created, i noticed that after a day or two, i get a datareader error, specifically the error which returns a column name as it's message. i.e if i had written reader["col_name"] i get col_name as the error message. The problem is that i read 5 column names in a single read, and the messages vary, it not always the same column name. However, whenever i restart the server, the problem goes away for another day or two. Recently i increased my max pool size because i was having pooling issues, this had an effect on the datareader error in that it now occurs every 2-3 hours instead of the 1-2 days. pls i need help on this one Thanks Dear Micheal, Thank your ...Show All
sqlguy12 Performance question about string
Hi, I wonder,.. what code has the highest performance public class Test { private static readonly string MyStr = "abcdefghijklmnop"; public void DoTest() { StringBuilder sb = new StringBuilder(); for (int i=0;i<10000;i++) sb.Append(MyStr); } } -or- public class Test { public void DoTest() { const string MyStr = "abcdefghijklmnop"; StringBuilder sb = new StringBuilder(); for (int i=0;i<10000;i++) sb.Append(MyStr); } } Stephan Smetsers stephansmetsers@hotmail.com http://www.inchl.nl hi, I know,... that solution will win by far,... but I used the example just for illustr ...Show All
fdc2005 Unwanted Escape Codes In String...
Hi, I'm working on web services client. We are connecting to an Axis web server which returns user defined exception in SoapException. The xml stream I got contains some unwanted Escape codes. When I tried to deserialize, it trows invalidOperationException since the namespace contains some invalid escape sequences ('\'). This is the XML string I get from the service: < ns1:fault xmlns:ns1 = \"http: Sapphire\">< ns1:error >< ns1:code > Err_Imp_26 </ ns1:code >< ns1:englishMsg > Invalid Sapphire Case ID </ ns1:englishMsg >< ns1:japaneseMsg xsi:nil = \"true\" xmlns:xsi = \"http: //www.w3.org/2001/XMLSchema-instance\" />< ns1:severity > 2 </ ns1:seve ...Show All
oaix MissingPrimaryKey
I have created table with the following columns - EmployeeID, EmployeeName, Address, Salary and EmployeeID is set as primary key. When I fill the DataSet ds with the contents of table above and use Find command to get the row containing a particular EmployeeID, I get MissingPrimaryKey Exception. ds.Tables[0].Rows.Find(Name) What is happening Never mind, I found the answer. I had to get the table schema before filling in the Dataset ' Get Schema such as primary key from the database. da.FillSchema(ds, SchemaType.Mapped, "Employee") 'Get the data from database. da.Fill(ds, "Employee") ...Show All
CemSharp How to use PATH environment variable for an application
Hi all, I am not understanding the concept of PATH variable. we are defining different path in this PATH variable. I am using one zip file and not specifying the path. See the ziputility variable in below code.. { string arguments = @" -o " + ZipFileName; string zipUtility = @"unzip.exe"; ProcessStartInfo startInfo = new ProcessStartInfo(zipUtility, arguments); startInfo.CreateNoWindow = true ; startInfo.UseShellExecute = false ; startInfo.WindowStyle = ProcessWindowStyle.Hidden; startInfo.RedirectStandardOutput = false ; startInfo.WorkingDirectory = directoryName; Process proc = Process.Start(startInfo); proc.WaitForExit(); } i am not giving the path ...Show All
biffpixel Adding new records via OleDbConnection
I'm writing a console .net app (vs2005). I've an open OleDbConnection, using it, how do I add new records to a specific table Is it possible to add records with code rather than using SQL If so, how I believe both classes will return same information for same failure and there is no difference. Errors would vary depending on situation, but it is hard to predict specific errors. Thanks for your reply. Before adding new records, is it mandatory to call the "Fill" function from OleDbDataAdapter first If so, why My example is shown below, where "da_p" is an instance of "OleDbDataAdapter". ////////////////////////////////////////////////////////////////// DataSet^ ds_p = gcnew DataSet( ...Show All
Siteadm Couples questions on derived control
I'm writing a derived control inherits from DropDownList. The first question is after I added a private variable in the derived class and added a public property for that variable. That variable is visible in the property grid in the design mode but not editable. How can I fix this The second question is how to use the "DesignerCategory" attribute I have set the DesignerCategory for my derived control. However, it still can't group under my expected category in the toolbox. Thanks! Yes. I found that I got typo in my code. I have fixed it now. Thanks. I dont think so.if you use a private property and set that in the public indexer the variable in the property grid will be editable and i tried myself ,its working.Che ...Show All
Part Time Australian XML is not visible in Internet Explorer 7
XML documents are not visible when I try to open them with Internet Explorer on my desktop. The same documents are visible in Internet Explorer on my laptop. Why would XML documents be visible on one copy of Internet Explorer and not another. Netscape and Mozilla will open XML documents on my desktop. At this point I'm relegated with using Mozilla to work with and view XML documents when I'm working on my desktop. Mozilla is not my first choice of browsers, but it's the only workaround at my disposal at this point. I've checked the XML settings in Internet Explorer and they seem to be fine. Windows XP shouldn't be the problem, but there is probably some setting in the registry that needs to be changed. Does anyone have a suggestion ...Show All
genius13 Install .NET Framework 2.0 Error. Please help me !
I installed .NET Framework 2.0, but it has a error. I found the solve way for this problem on Internet and i found a blog for fixing a failed .NET Framework installing. But when i retry it, it still be error. Please help me! + I installed and received a error message: "Error 25013 failed to install assembly C:/windows/microsoft.net/framework/v2.0.50727/System.Design.dll because strong name signature couldn't be verified. Was the assembly built delay-signed " + And i received 2 log files: dd_netfx20MSI55AF.txt; dd_netfx20UI55AF.txt. The content of [dd_netfx20MSI55AF.txt] file is over 8Mb, so that i could not paste it here. * This's content of [dd_netfx20UI55AF.txt] file: -------------------------------------- ...Show All
Ning Uploding text file to Remote Server from Local Windows Application
HI, I am running into a huge road block which I am not able to upload files from windows application to a remote server. I know this can done on the server side (ASP.NET). Is there anyway that I can upload the file to a remote server from a local windows application How can I achieve this Please help! Thank you ahmed, that was great help. I have completed my task with your help. thank you again. indeed there is. you could use the FTP Classes in .NET 2.0 or perhaps also consider using the WebClient class.... System.Net.NetworkCredential credentials = new System.Net.NetworkCredential(" username ", " password "); FtpWebRequest theRequest = (FtpWebRequest)WebRequest.Create(" ftp://yoursite.com/file ...Show All
ahmedWebDev Async Socket's callback method runs in same thread with caller
My problem is sometimes the caller and callback of async socket method are run in same thread. I think caller and callback must run in different thread, but sometimes they do not. Why the following is the unit test of my problem. Do you have any idea using Microsoft.VisualStudio.TestTools.UnitTesting; using System.Threading; using System.Net.Sockets; using System.Net; using System; namespace CallbackUnitTest { [TestClass] public class UnitTest1 { AutoResetEvent sync = new AutoResetEvent(false); int callerThreadID; int callbackThreadID; [TestMethod] public void TestMethod1() { for (int i = 0; i < 10000; i++) { // initialize sockets and event Socket server = new ...Show All
Darren Grove event log class
I have an evet log code in my forms which connects to my evetlog database and add the log. Currently I am copying the same code to each and every form. i need to keep in a common class and use it whenever and whereever i need but i never tried to that before.. can you please guide add a new class in your project (right click project in solution, add > new item) then code in this class. then to call this class from other forms, create an instance of it, or pass it around: Class1 myClass = new Class1(); myClass.DoSomeMethod(args); etc... http://www.aspfree.com/c/a/C-Sharp/C-Sharp-Classes-Explained/ http://www.learnvisualstudio.net/videos/2308_CSharp_Classes.htm ...Show All
TalhaAziz Removing lines in a TextFile
Hi, I want to read n lines from a text file, and then after I've read them, I want to remove those lines from my text file. The only way to do it is to rewrite the file Here you go, this shoudl work. Notice how the for-loop starts at 2 so it misses the first 2 lines. string [] lines = File.ReadAllLines("source.txt"); using (StreamWriter writer = File.CreateText("dest.txt")) { for ( int i = 2; i < lines.Length; i++) { writer.WriteLine(lines[ i ]); } writer.Close(); } Ok that's what i thought. I want to ...Show All
komomomo How can I copy a whole table from MS Access database to another?
Hello, I have 2 MS Acess database, in each one I have a table named Catlog, what I want is to open the two tables and copy the Catlog table from the a database to the other, at runtime for sure! Is there an easy solution or I should use SQL to delete all the rows from the first table and then read the rows from the second table and write it again to the first one!!! Please help. Thanks in advance. Assuming it's a database password and not a user-level security password it would look like the following: AccessCommand.CommandText = "INSERT INTO [Catlog] SELECT * FROM [MS Access;DATABASE=C:\Test Files\db1 XP.mdb; Jet OLEDB:Database Password=mypassword; ].[Catlog]" ...Show All
Jeremy Grand palcing multiple datasets in the form performance will be decresed
yes no because datasets are used to temporary storage of data ...Show All
