¡@
c# Programming Glossary: endWhat are the pros and cons to keeping SQL in Stored Procs versus Code http://stackoverflow.com/questions/15142/what-are-the-pros-and-cons-to-keeping-sql-in-stored-procs-versus-code or in Stored Procs I've been discussing this with a friend on an open source project that we're working on C# ASP.NET Forum.. your C# app whenever you want to change some SQL You'll end up recompiling it anyway when datatypes change or you want to.. from underneath your app is pretty small on the whole You end up reusing SQL code. Programming languages C# included have..
How to inject Javascript in WebBrowser control? http://stackoverflow.com/questions/153748/how-to-inject-javascript-in-webbrowser-control scriptEl.SetAttribute type text javascript head.AppendChild scriptEl scriptEl.InnerHtml function sayHello alert 'hello'.. String value at SForceApp.Form1.button1_Click Object sender EventArgs e in d jsight installs SForceApp SForceApp Form1.cs.. For some reason Richard's solution didn't work on my end insertAdjacentText failed with an exception . This however seems..
TransactionScope automatically escalating to MSDTC on some machines? http://stackoverflow.com/questions/1690892/transactionscope-automatically-escalating-to-msdtc-on-some-machines to not require the MSDTC service to be enabled on our end user's machines. Trouble is on half of our developers machines..
Dependency Inject (DI) “friendly” library http://stackoverflow.com/questions/2045904/dependency-inject-di-friendly-library Inject DI &ldquo friendly&rdquo library I'm pondering the.. Inject DI &ldquo friendly&rdquo library I'm pondering the design of a C# library that.. as possible. As such there will probably be classes intended for consumers to use directly on a regular basis and support..
How To: Execute command line in C#, get STD OUT results http://stackoverflow.com/questions/206323/how-to-execute-command-line-in-c-get-std-out-results wait for the child process to exit before reading to the end of its redirected stream. p.WaitForExit Read the output stream..
Creating a byte array from a stream http://stackoverflow.com/questions/221925/creating-a-byte-array-from-a-stream inputstream share improve this question It really depends on whether or not you can trust s.Length . For many streams.. data soon. BinaryReader.Read will keep going until the end of the stream or your specified size but you still have to know.. size to start with. Likewise you can put a check at the end and if the length of the stream is the same size as the buffer..
When to Use Static Classes in C# http://stackoverflow.com/questions/241339/when-to-use-static-classes-in-c-sharp when we need to pass them around by their interface. This renders us unable to use static classes as part of a strategy pattern... methods usually will have different purposes we'll quickly end up with a large class filled up with non coherent functionality.. through properties or methods to set multiple interdependent values at the same time. Also if a method has grown to this..
Validate a username and password against Active Directory? http://stackoverflow.com/questions/290548/validate-a-username-and-password-against-active-directory It's simple it's reliable it's 100 C# managed code on your end what more can you ask for Read all about it here Managing Directory..
How to Deserialize XML document http://stackoverflow.com/questions/364253/how-to-deserialize-xml-document couldn't use the reader anymore...the position was at the end of the stream . I also took a few liberties with the naming..
WebBrowser Control in a new thread http://stackoverflow.com/questions/4269800/webbrowser-control-in-a-new-thread a new thread per Uri. The problem I'm having is the thread end before the document is fully loaded so I never get to make use.. th.Start void browser_DocumentCompleted object sender WebBrowserDocumentCompletedEventArgs e var br sender as WebBrowser.. sender WebBrowserDocumentCompletedEventArgs e var br sender as WebBrowser if br.Url e.Url Console.WriteLine Natigated..
What is differences between Multidimensional array and Array of Arrays in C#? http://stackoverflow.com/questions/597720/what-is-differences-between-multidimensional-array-and-array-of-arrays-in-c ldarg.2 IL_0004 ldarg.3 IL_0005 stelem.i4 IL_0006 ret end of method Program SetElementAt .method private hidebysig static.. int32 0... 0... Set int32 int32 int32 IL_0009 ret end of method Program SetElementAt When using jagged arrays you..
Is there a reason for C#'s reuse of the variable in a foreach? http://stackoverflow.com/questions/8898925/is-there-a-reason-for-cs-reuse-of-the-variable-in-a-foreach you plan to use the variable outside the scope of the loop end while var finalString s However variables defined in a foreach..
http://stackoverflow.com/questions/898828/c-sharp-finalize-dispose-pattern private void wc_DownloadStringCompleted object sender DownloadStringCompletedEventArgs e Do work here Dispose of.. method be automatically called when execution reaches the end of the using block Or does the client have to manually call.. finalizer share improve this question The recommended IDisposable pattern is here . When programming a class that..
How can I detect the encoding/codepage of a text file http://stackoverflow.com/questions/90838/how-can-i-detect-the-encoding-codepage-of-a-text-file this is what I've done. The files we receive are from end users they do not have a clue about codepages. The receivers.. do not have a clue about codepages. The receivers are also end users by now this is what they know about codepages Codepages.. You can no longer stick your head in the sand and pretend that plain text is ASCII. There Ain't No Such Thing As Plain..
How to read a text file reversely with iterator in C# http://stackoverflow.com/questions/452902/how-to-read-a-text-file-reversely-with-iterator-in-c-sharp buffer.Length int leftOverData 0 String previousEnd null TextReader doesn't return an empty string if there's line.. backwards if lookingAt ' n' lookingAt ' r' continue End of CRLF Swallow the preceding CR if lookingAt ' n' swallowCarriageReturn.. start endExclusive i string stringToYield previousEnd null bufferContents bufferContents previousEnd if firstYield..
http://stackoverflow.com/questions/462270/get-file-icon-used-by-shell c myfile.ico IO.FileMode.CreateNew TheIcon.Save stream End Using End If End Sub Public Function IconFromFilePath filePath.. IO.FileMode.CreateNew TheIcon.Save stream End Using End If End Sub Public Function IconFromFilePath filePath As String.. TheIcon.Save stream End Using End If End Sub Public Function IconFromFilePath filePath As String As Icon..
How do I suspend painting for a control and its children? http://stackoverflow.com/questions/487661/how-do-i-suspend-painting-for-a-control-and-its-children WM_SETREDRAW 1 0 If Redraw Then Target.Refresh End If End Sub Extension Public Sub SuspendDrawing ByVal Target.. WM_SETREDRAW 1 0 If Redraw Then Target.Refresh End If End Sub Extension Public Sub SuspendDrawing ByVal Target As Control.. As Control SendMessage Target.Handle WM_SETREDRAW 0 0 End Sub Extension Public Sub ResumeDrawing ByVal Target As Control..
http://stackoverflow.com/questions/670577/observablecollection-doesnt-support-addrange-method-so-i-get-notified-for-each NotifyCollectionChangedAction.Reset End Sub ''' summary ''' Removes the first occurence of each item.. NotifyCollectionChangedAction.Reset End Sub ''' summary ''' Clears the current collection and replaces.. Public Sub Replace ByVal item As T ReplaceRange New T item End Sub ''' summary ''' Clears the current collection and replaces..
how can i get text formatting with iTextSharp http://stackoverflow.com/questions/6882098/how-can-i-get-text-formatting-with-itextsharp new string Tj previousCharacters resultString End of a text object also go to a new line. if bracketDepth 0 CheckToken.. Vector topRight renderInfo.GetAscentLine .GetEndPoint iTextSharp.text.Rectangle rect new iTextSharp.text.Rectangle.. Not needed public void BeginTextBlock public void EndTextBlock public void RenderImage ImageRenderInfo renderInfo..
How to write a scalable Tcp/Ip based server http://stackoverflow.com/questions/869744/how-to-write-a-scalable-tcp-ip-based-server accept one and I chose to accept the more well known Begin End method. Esac's solution may well be better but it's still new.. System.Net.Dns.GetHostName System.Net.IPEndPoint serverEndPoint try serverEndPoint new System.Net.IPEndPoint.. System.Net.Dns.GetHostName System.Net.IPEndPoint serverEndPoint try serverEndPoint new System.Net.IPEndPoint localhost.AddressList..
Should you make multiple insert calls or pass XML? http://stackoverflow.com/questions/10295326/should-you-make-multiple-insert-calls-or-pass-xml @TargetUDT2 INSERT INTO Target3 SELECT FROM @TargetUDT3 END In .Net Create three data table and fill the value and call..
How to pass an array into a SQL Server stored procedure http://stackoverflow.com/questions/11102358/how-to-pass-an-array-into-a-sql-server-stored-procedure AS BEGIN SET NOCOUNT ON SELECT EmployeeID FROM @List END GO Now in your C# code DataTable tvp new DataTable define populate.. ON SELECT EmployeeID Item FROM dbo.SplitInts @List ' ' END GO And in your C# code you just have to pass the list as '1..
http://stackoverflow.com/questions/11831844/unobservedtaskexception-being-throw-but-it-is-handled-by-a-taskscheduler-unobser if tz null tz.ContinueWith t Console.WriteLine END Task tsk_1 MyClassHere.createHandledTask double x 1 x x 1..
How to execute a stored procedure within C# program http://stackoverflow.com/questions/1260952/how-to-execute-a-stored-procedure-within-c-sharp-program 'I VALUE ' CONVERT varchar 20 @i EXEC @command SET @i @i 1 END EDITED using System using System.Collections.Generic using System.Text..
Sending an array of values to Oracle procedure to use in WHERE IN clause http://stackoverflow.com/questions/13580245/sending-an-array-of-values-to-oracle-procedure-to-use-in-where-in-clause WHERE COL1 IN here I want to put values received from C# END On the ASP.NET application side I have a select element with..
http://stackoverflow.com/questions/1952638/single-assembly-multi-language-windows-forms-deployment-ilmerge-and-satellite-a 1es InputProg.resources.dll IF ERRORLEVEL NEQ 0 GOTO END ProgramFiles Microsoft ILMerge ILMerge.exe t exe out 1SomeFinalProg.exe.. 1fr InputProg.resources.dll IF ERRORLEVEL NEQ 0 GOTO END del 1InputProg.exe del 1InputProg.pdb del 1TempProg.exe del.. 1TempProg.exe del 1TempProg.pdb del 1es . Q del 1fr . Q END UPDATE 3 ILRepack Another quick note One of the things that..
How to catch SQLServer timeout exceptions http://stackoverflow.com/questions/29664/how-to-catch-sqlserver-timeout-exceptions WHILE EXISTS SELECT 1 from sysobjects BEGIN SELECT @i 1 END cmd.ExecuteNonQuery This line will timeout. cmd.Dispose sql.Close..
Insert blob in oracle database with C# http://stackoverflow.com/questions/4902250/insert-blob-in-oracle-database-with-c-sharp 100 1 SELECT photo into 2 from testblob WHERE id 100 END Set command to create Anonymous PL SQL Block OracleCommand cmd..
SQL Server (2008) Pass ArrayList or String to SP for IN() http://stackoverflow.com/questions/519769/sql-server-2008-pass-arraylist-or-string-to-sp-for-in @list_table id VALUES @id SELECT @start_index @index 1 END SELECT @index @index 1 END SELECT @id CAST SUBSTRING @list @start_index.. SELECT @start_index @index 1 END SELECT @index @index 1 END SELECT @id CAST SUBSTRING @list @start_index @index @start_index.. AS INT INSERT @list_table id VALUES @id RETURN END Which accepts an nvarchar comma separated list of ids and returns..
Logoff interactive users in Windows from a service http://stackoverflow.com/questions/5207506/logoff-interactive-users-in-windows-from-a-service Please Enter L list sessions G Logoff a user END exit. input Console.ReadLine if string.IsNullOrWhiteSpace.. LogOffUser input server while input.ToUpper END finally WTSCloseServer server share improve this answer..
Sockets in C#: How to get the response stream? http://stackoverflow.com/questions/523930/sockets-in-c-how-to-get-the-response-stream 0 byteResponse .Length context.Response.OutputStream.Close END NEW CODE After connecting to the socket I don't know how to..
how can i get text formatting with iTextSharp http://stackoverflow.com/questions/6882098/how-can-i-get-text-formatting-with-itextsharp Sorry for the bad formatting heading off to dinner now. END EDIT The code below combines several questions and answers here..
Getting the Current username when impersonated http://stackoverflow.com/questions/7613468/getting-the-current-username-when-impersonated
How to insert a data table into SQL Server database table? http://stackoverflow.com/questions/9075159/how-to-insert-a-data-table-into-sql-server-database-table AS BEGIN insert into dbo .Records select from @myTableType END and send your DataTable directly to sql server using var command..
|