CodeKeep C# Feed

ClientScript.RegisterStartupScript

Fri, 10 Oct 2008 20:38:01 GMT

Description: Call javascript method from codebehind

Link: http://www.codekeep.net/snippets/e6119e08-b41c-48d1-ad7d-0296a7605143.aspx

this.Page.ClientScript.RegisterStartupScript(this.GetType(), "myScript", "<script language=JavaScript>window.print();</script>");

Running a command line utility from C#

Thu, 09 Oct 2008 23:17:12 GMT

Description: How to run a command line utility from C#. In this case, I needed to do a secure file copy to a remote server for an activiry report. I chose to use pscp from PuTTY.

Link: http://www.codekeep.net/snippets/7c9e3cc2-9907-4ecc-a5bc-e4b7a7f5e514.aspx

string cmd = "pscp";
string arguments = String.Format("-v -pw {0} \"{1}\" {2}@{3}:{4}",
  _pwd,
  activityReport.UploadFilename,
  _uid,
  _url,
  _uploadDir
);

ProcessStartInfo psi = new ProcessStartInfo();
psi.FileName = cmd;
psi.Arguments = arguments;

Logger.Debug(psi.FileName + " " + psi.Arguments);

psi.RedirectStandardOutput = true;
psi.RedirectStandardError = true;

psi.WindowStyle = ProcessWindowStyle.Normal;
psi.UseShellExecute = false;

Process listFiles = Process.Start(psi);
StreamReader myOutput = listFiles.StandardOutput;
StreamReader myError = listFiles.StandardError;

listFiles.WaitForExit(10 * 60 * 1000);  // timeout when?

if (listFiles.HasExited)
{
  // did it exit gracefully?
  Logger.Debug(myOutput.ToString() + myError.ToString());
  listFiles.Close();
} 
else 
{
  // or did it timeout and need to kill it.
  listFiles.Kill();
  listFiles.Close();
  throw new Exception("Upload timed out. " + myOutput.ToString() + myError.ToString());
}

Return new identity from Strongly Typed Dataset DataTable.Insert method

Thu, 09 Oct 2008 03:26:07 GMT

Description: Return new identity from Strongly Typed Dataset DataTable.Insert method

Link: http://www.codekeep.net/snippets/89bf687f-9c9e-4cee-b76e-12d00e22f13a.aspx


Datasets are pretty good at auto generating stored procedures and wrapping c# code around them for you.

However with the insert method you often want to do something with the object that you have just inserted.

Fortunately there is an easy way to get the Sproc and the c# method to return a reference to the object.

Firstly edit your insert stored procedure adding a @return parameter and a line after the insert to set this to a suitable value.

The exmaple below assumes that you are using bigint identity fields.

ALTER PROCEDURE dbo.insMyRow
(
    @Description varchar(500),
    @Return bigint output
)
AS
    SET NOCOUNT OFF;
INSERT INTO [myTable] ([Description]) VALUES (@Description);
    
SET @Return = SCOPE_IDENTITY()

Note that SCOPE_IDENTITY() is similar to @@IDENTITY except its scope is limited to the current command and so improves scalability.

Now when you save the Dataset you see that the insert method takes two parameters, the second being a nullable long.

My first thought was that Datasets should be the end of editing stored procedures but I am still impressed that the c# method declaration changes accordingly.

You can call the updated method in the following way.

long? objId=null;

myTableAdapter d =new myTableAdapter();

d.Insert("Descriptive text", ref objId);

the long? just means nullable long.

After filling the table you can now use the FindByxxxID functions of the DataTable to return the DataRow object.

Test

Tue, 07 Oct 2008 09:14:17 GMT

Description: Test

Link: http://www.codekeep.net/snippets/793c56cb-e335-4324-aa59-d4c68d94d868.aspx

imgdiv.InnerHtml = "<a href=''>  <img src='http://imshopping.rediff.com/shopping/homepix/rediff-popunder101_070808.gif ' />  </a>";

SendKeys.Send("{TAB}") invalid

Mon, 06 Oct 2008 07:47:34 GMT

Description: can not use "Sendkeys.Send" when run unikey

Link: http://www.codekeep.net/snippets/416f5d95-8674-47a9-b6e3-13a3935436f2.aspx

SendKeys.Send("{TAB}");

Coverage Exclude attribute.

Fri, 03 Oct 2008 13:58:20 GMT

Description: An attribute used to mark pieces of code that are to be excluded from test code coverage metric.

Link: http://www.codekeep.net/snippets/fd777edd-471d-4aed-b362-76f6f14832c4.aspx

using System;

public enum Reason {
    GeneratedCode,
    Framework,
    Delegate,
    Humble
}

public class CoverageExcludeAttribute : Attribute {
    public CoverageExcludeAttribute(Reason reason) {}
}

client - server validation

Wed, 01 Oct 2008 23:17:54 GMT

Description: client - server validation

Link: http://www.codekeep.net/snippets/c643890b-bf29-411d-8de3-3ba3ecdb9172.aspx

<script type="text/javascript" language="javascript">
function clientvalidation(src, args)
{
      if (args.Value != "")
            args.IsValid = true;
      else
            args.IsValid = false;
}
</script>

-------------------
<asp:textbox ID="textbox1" runat="server"/>

<asp:CustomValidator ValidateEmptyText="true" id="valCustom" runat="server" ControlToValidate="textbox1" ValidationGroup="vg" ClientValidationFunction="clientvalidation" OnServerValidate="ServerValidate" ErrorMessage="This box1 is not valid" Display="Dynamic">*</asp:CustomValidator>

------------------

 protected void ServerValidate(object source, ServerValidateEventArgs args)
    {
        //   args.IsValid = (args.Value != null);

        //args.IsValid = (args.Value.Length >= 8);
        
        Response.Write(args.Value);

        if (args.Value != "")
        {
            args.IsValid = true;
        }
        else
        {
            args.IsValid = false;
        }

    }
 protected void btn_click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            Response.Redirect("http://www.packingmaterials.com");
        }
    }

ConnectionString

Wed, 01 Oct 2008 16:28:08 GMT

Description: Default connection String

Link: http://www.codekeep.net/snippets/aa1e3b7a-3c10-44ad-ba58-6c2a4e9f4eed.aspx

public  static string __ConnectionString = "server=.;uid=sa;pwd=sapass; database=GulerMUhasebe";

DeepCode

Tue, 30 Sep 2008 07:57:43 GMT

Description: Use to deep clone an object

Link: http://www.codekeep.net/snippets/bef5e8e3-afab-4a9f-ab8f-80084ff5a672.aspx

public class MyObject  : ICloneable {
    public object Clone()
    {
        return ObjectUtility.CloneObject(this);
    }
  
}
public static class ObjectUtility {
	public static object CloneObject(object obj)
	{
   	 using (MemoryStream memStream = new MemoryStream())
   	 {
   	     BinaryFormatter binaryFormatter = new BinaryFormatter(null, 
   	          new StreamingContext(StreamingContextStates.Clone));
   	     binaryFormatter.Serialize(memStream, obj);
  	      memStream.Seek(0, SeekOrigin.Begin);
     	   return binaryFormatter.Deserialize(memStream);
	    }
}
}

SqlCommandBuilder

Tue, 30 Sep 2008 02:19:00 GMT

Description: SqlCommandBuilder object to automatically generate the DeleteCommand, the InsertCommand, and the UpdateCommand properties of the SqlCommand object for a SqlDataAdapter object,

Link: http://www.codekeep.net/snippets/9a6c1dd3-76d0-4490-8fb4-3b8d149d91aa.aspx

using System.Data;
using System.Data.SqlClient;
using System;
namespace Q308507 {

  class Class1 {
     static void Main(string[] args)	{
  
        SqlConnection cn = new SqlConnection();
        DataSet CustomersDataSet = new DataSet();
        SqlDataAdapter da;
        SqlCommandBuilder cmdBuilder;
  
        //Set the connection string of the SqlConnection object to connect
        //to the SQL Server database in which you created the sample
        //table.
        cn.ConnectionString = "Server=server;Database=northwind;UID=login;PWD=password;";

        cn.Open();      

        //Initialize the SqlDataAdapter object by specifying a Select command 
        //that retrieves data from the sample table.
        da = new SqlDataAdapter("select * from CustTest order by CustId", cn);

        //Initialize the SqlCommandBuilder object to automatically generate and initialize
        //the UpdateCommand, InsertCommand, and DeleteCommand properties of the SqlDataAdapter.
        cmdBuilder = new SqlCommandBuilder(da);

        //Populate the DataSet by running the Fill method of the SqlDataAdapter.
        da.Fill(CustomersDataSet, "Customers");

        //Display the Update, Insert, and Delete commands that were automatically generated
        //by the SqlCommandBuilder object.
        Console.WriteLine("Update command Generated by the Command Builder : ");
        Console.WriteLine("==================================================");
        Console.WriteLine(cmdBuilder.GetUpdateCommand().CommandText);
        Console.WriteLine("         ");

        Console.WriteLine("Insert command Generated by the Command Builder : ");
        Console.WriteLine("==================================================");
        Console.WriteLine(cmdBuilder.GetInsertCommand().CommandText);
        Console.WriteLine("         ");        

        Console.WriteLine("Delete command Generated by the Command Builder : ");
        Console.WriteLine("==================================================");
        Console.WriteLine(cmdBuilder.GetDeleteCommand().CommandText);
	Console.WriteLine("         ");

        //Write out the value in the CustName field before updating the data using the DataSet.
        Console.WriteLine("Customer Name before Update : " + CustomersDataSet.Tables["Customers"].Rows[0]["CustName"]);

        //Modify the value of the CustName field.
        CustomersDataSet.Tables["Customers"].Rows[0]["CustName"] = "Jack";

        //Post the data modification to the database.
        da.Update(CustomersDataSet, "Customers");        

        Console.WriteLine("Customer Name updated successfully");

        //Close the database connection.
        cn.Close();

        //Pause
        Console.ReadLine();
      }
   }

}

SqlCommandBuilder

Tue, 30 Sep 2008 02:18:37 GMT

using System.Data;
using System.Data.SqlClient;
using System;
namespace Q308507 {

  class Class1 {
     static void Main(string[] args)	{
  
        SqlConnection cn = new SqlConnection();
        DataSet CustomersDataSet = new DataSet();
        SqlDataAdapter da;
        SqlCommandBuilder cmdBuilder;
  
        //Set the connection string of the SqlConnection object to connect
        //to the SQL Server database in which you created the sample
        //table.
        cn.ConnectionString = "Server=server;Database=northwind;UID=login;PWD=password;";

        cn.Open();      

        //Initialize the SqlDataAdapter object by specifying a Select command 
        //that retrieves data from the sample table.
        da = new SqlDataAdapter("select * from CustTest order by CustId", cn);

        //Initialize the SqlCommandBuilder object to automatically generate and initialize
        //the UpdateCommand, InsertCommand, and DeleteCommand properties of the SqlDataAdapter.
        cmdBuilder = new SqlCommandBuilder(da);

        //Populate the DataSet by running the Fill method of the SqlDataAdapter.
        da.Fill(CustomersDataSet, "Customers");

        //Display the Update, Insert, and Delete commands that were automatically generated
        //by the SqlCommandBuilder object.
        Console.WriteLine("Update command Generated by the Command Builder : ");
        Console.WriteLine("==================================================");
        Console.WriteLine(cmdBuilder.GetUpdateCommand().CommandText);
        Console.WriteLine("         ");

        Console.WriteLine("Insert command Generated by the Command Builder : ");
        Console.WriteLine("==================================================");
        Console.WriteLine(cmdBuilder.GetInsertCommand().CommandText);
        Console.WriteLine("         ");        

        Console.WriteLine("Delete command Generated by the Command Builder : ");
        Console.WriteLine("==================================================");
        Console.WriteLine(cmdBuilder.GetDeleteCommand().CommandText);
	Console.WriteLine("         ");

        //Write out the value in the CustName field before updating the data using the DataSet.
        Console.WriteLine("Customer Name before Update : " + CustomersDataSet.Tables["Customers"].Rows[0]["CustName"]);

        //Modify the value of the CustName field.
        CustomersDataSet.Tables["Customers"].Rows[0]["CustName"] = "Jack";

        //Post the data modification to the database.
        da.Update(CustomersDataSet, "Customers");        

        Console.WriteLine("Customer Name updated successfully");

        //Close the database connection.
        cn.Close();

        //Pause
        Console.ReadLine();
      }
   }

}

start exe

Mon, 29 Sep 2008 23:00:08 GMT

Description: start exe

Link: http://www.codekeep.net/snippets/9f355e19-1955-4874-87c7-656963978355.aspx

            Process notePad = new Process();

            notePad.StartInfo.FileName   = "notepad.exe";
            notePad.StartInfo.Arguments = "ProcessStart.cs";

            notePad.Start();

open a document

Mon, 29 Sep 2008 22:59:17 GMT

Description: open a document

Link: http://www.codekeep.net/snippets/1af1459d-0491-4b33-82b0-043e26fdb879.aspx

    System.Diagnostics.Process.Start(fileName);

StringBuilder instantiation

Mon, 29 Sep 2008 13:54:53 GMT

Description: Instantiates a StringBuilder and returns the result

Link: http://www.codekeep.net/snippets/d0a474c9-6536-4579-9c76-9bde52606162.aspx

StringBuilder sb = new StringBuilder();

return sb.ToString();

How to Get Window NT Logged User Name Using ASP.NET

Mon, 29 Sep 2008 06:37:23 GMT

Description: How to Get Window NT Logged User Name Using ASP.NET

Link: http://www.codekeep.net/snippets/24ed5597-f3d1-4022-a9ca-af4a20f5eac2.aspx

1) System.Security.Principal.WindowsPrincipal p = System.Threading.Thread.CurrentPrincipal as System.Security.Principal.WindowsPrincipal;

string strName = p.Identity.Name;

[ OR ]

2) string strName = HttpContext.Current.User.Identity.Name.ToString();

[ OR ]

3) string strName = Request.ServerVariables["AUTH_USER"]; //Finding with name

string strName = Request.ServerVariables[5]; //Finding with index

Get current windows user - username

Mon, 29 Sep 2008 06:32:12 GMT

Description: Get current windows user - username

Link: http://www.codekeep.net/snippets/47a962c3-eaa1-419f-b2be-7298b69947be.aspx

using System.Security.Principal;

namespace ConsoleApplicationWindowsUser
{
    class Program
    {
        static void Main(string[] args)
        {
            string a;
            a = System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString();

            Console.WriteLine(a);
            Console.Read();
        }
    }
}

Tokenizer with delimeters

Sun, 28 Sep 2008 14:52:32 GMT

Description: tokenizer with delimeters

Link: http://www.codekeep.net/snippets/cb1142ef-cf37-4f95-b328-7bea2723ac9a.aspx

using System;
using System.Text.RegularExpressions;
 
public static string[] Tokenize(string equation)
{
   Regex RE = new Regex(@"([\+\-\*\(\)\^\\])");
   return (RE.Split(equation));
}

public void TestTokenize( )
{
   foreach(string token in Tokenize("(y - 3)(3111*x^21 + x + 320)"))
      Console.WriteLine("String token = " + token.Trim( ));
}

string to Color convertion

Sun, 28 Sep 2008 02:26:40 GMT

Description: string to Color convertion

Link: http://www.codekeep.net/snippets/d8cfe6ef-6dd0-4534-8170-216a84ec3aeb.aspx

            System.Drawing.ColorConverter ccv = new System.Drawing.ColorConverter();
            return (Color)ccv.ConvertFromString(color);

How to create custom error reporting in ASP.NET (C#)

Thu, 25 Sep 2008 20:47:08 GMT

Description: This sample shows how to use Visual C# .NET code to trap and respond to errors when they occur in ASP.NET, using Page_Error and Application_Error.

Link: http://www.codekeep.net/snippets/b42334d2-afe6-4c53-a62a-6fba533a8739.aspx

How to use the Page_Error method:
public void Page_Error(object sender,EventArgs e)
{
	Exception objErr = Server.GetLastError().GetBaseException();
	string err =	"<b>Error Caught in Page_Error event</b><hr><br>" + 
			"<br><b>Error in: </b>" + Request.Url.ToString() +
			"<br><b>Error Message: </b>" + objErr.Message.ToString()+
			"<br><b>Stack Trace:</b><br>" + 
	                  objErr.StackTrace.ToString();
	Response.Write(err.ToString());
	Server.ClearError();
}

How to use the Application_Error method (Global.asax):
protected void Application_Error(object sender, EventArgs e)
{
	Exception objErr = Server.GetLastError().GetBaseException();
	string err =	"Error Caught in Application_Error event\n" +
			"Error in: " + Request.Url.ToString() +
			"\nError Message:" + objErr.Message.ToString()+ 
			"\nStack Trace:" + objErr.StackTrace.ToString();
	EventLog.WriteEntry("Sample_WebApp",err,EventLogEntryType.Error);
	Server.ClearError();
	//additional actions...
}

Sting IsIP Extension (C# 3.0)

Thu, 25 Sep 2008 18:34:59 GMT

Description: When put into a static class, extends the string class to include an IsIP function.

Link: http://www.codekeep.net/snippets/28224f54-4eb9-4f74-b4ab-bab629f52390.aspx

public static bool IsIP( this string strIPAddressField )
{
	return regIP.IsMatch( strIPAddressField );
}

private static Regex regIP = new Regex(@"(?<First>  2[0-4]\d | 25[0-5] | [01]?\d\d? )\.
                                         (?<Second> 2[0-4]\d | 25[0-5] | [01]?\d\d? )\.
                                         (?<Third>  2[0-4]\d | 25[0-5] | [01]?\d\d? )\.
                                         (?<Fourth> 2[0-4]\d | 25[0-5] | [01]?\d\d? )",
		            RegexOptions.IgnoreCase | 
		            RegexOptions.CultureInvariant |
		            RegexOptions.IgnorePatternWhitespace |
		            RegexOptions.Compiled
		            );

Log an Error to Event Viewer

Wed, 24 Sep 2008 13:32:15 GMT

Description: Log an Error to Event Viewer

Link: http://www.codekeep.net/snippets/725edbe3-b354-4419-bd41-95e2a9beabf6.aspx

EventLog.WriteEntry("Your category", "Your error message", EventLogEntryType.Error);

Class Regions

Tue, 23 Sep 2008 11:45:00 GMT

Description: Empty regions for a new class

Link: http://www.codekeep.net/snippets/12aadb9c-ad4d-4126-b17e-5d21cf386482.aspx

        #region Fields

        #endregion

        #region Constructors

        #endregion

        #region Properties

        #endregion

        #region Methods

        #endregion

To Check weather typed text in combobox exists in combobox members.

Tue, 23 Sep 2008 08:54:36 GMT

Description: To Check weather typed text in combobox exists in combobox members.

Link: http://www.codekeep.net/snippets/aae33d50-d779-49e2-b747-1cb43761cb65.aspx

  let combobox name is "cmbcity"
------------------------------------ 

int index = cmbcity.FindStringExact(cmbcity.Text);
                    if (index >= 0)
                    {
                        MessageBox.Show("City already exists in dropdownlist.");
                       
                    }

Scurve forecast calculation

Tue, 23 Sep 2008 04:56:07 GMT

Description: If you need to calculate the percentage for a Scurve, this function will do it for you. Input parameters - The actual period - Number of periods - The percentage to be used. (ie 25%, 45% etc)

Link: http://www.codekeep.net/snippets/7901a587-1c49-4ca1-b043-1f0212c07619.aspx

        public static double DeterminePercentage(double Period, double NumberOfPeriods, int RPercentage)
        {
            switch (RPercentage)
            {
                case 25: //25%
                    if (Period * 10.0 / NumberOfPeriods == 0.0)
                        return 0.0;

                    if (Period*10.0/NumberOfPeriods==10.0)
                        return 100;

                    return  -0.524475524475441 + (8.91608391608395 * (Period * 10 / NumberOfPeriods)) - 
                            (4.23193473193476 *  Math.Pow((Period * 10 / NumberOfPeriods), 2)) + 
                            (0.970862470862476 * Math.Pow((Period*10/NumberOfPeriods),3)) -                                                                                                                                                                                                                                                                                                                                                                         
                            (0.0536130536130539* Math.Pow((Period*10/NumberOfPeriods),4));

                case 35: //35%
                    if (Period * 10.0 / NumberOfPeriods == 0.0)
                        return 0.0;

                    if (Period * 10.0 / NumberOfPeriods == 10.0)
                        return 100;

                    return 0.104895104895199 + 6.35722610722612*(Period * 10 / NumberOfPeriods) - 
                           2.19201631701633 * Math.Pow((Period*10/NumberOfPeriods),2) + 
                           0.666083916083919* Math.Pow(( Period * 10/NumberOfPeriods),3) - 
                           0.0410839160839162*Math.Pow((Period * 10/ NumberOfPeriods),4);

                case 45: //45%
                    if (Period * 10.0 / NumberOfPeriods == 0.0)
                        return 0.0;

                    if (Period * 10.0 / NumberOfPeriods == 10.0)
                        return 100;

                    return 0.769230769230784 + 4.05244755244754*(Period *10/NumberOfPeriods)+ 
                           0.403846153846159*Math.Pow((Period*10/NumberOfPeriods),2) +
                           0.22144522144522*Math.Pow((Period*10/24),3)-
                           0.0203962703962703*Math.Pow((Period*10/NumberOfPeriods),4);
                case 55: //55%
                    if (Period * 10.0 / NumberOfPeriods == 0.0)
                        return 0.0;

                    if (Period * 10.0 / NumberOfPeriods == 10.0)
                        return 100;

                    return 0.94405594405594 + 4.25602175602171*(Period*10/NumberOfPeriods)+ 
                           1.81351981351983*Math.Pow((Period*10/NumberOfPeriods),2)-
                           0.0788655788655822*Math.Pow((Period*10/NumberOfPeriods),3) -
                           0.00466200466200449*Math.Pow((Period*10/NumberOfPeriods),4);
                case 65: //65%
                    if (Period * 10.0 / NumberOfPeriods == 0.0)
                        return 0.0;

                    if (Period * 10.0 / NumberOfPeriods == 10.0)
                        return 100;

                    return 1.08391608391604 + 3.95979020979014*(Period*10/NumberOfPeriods) +
                           3.80681818181822*Math.Pow((Period*10/NumberOfPeriods), 2) -
                           0.505244755244762*Math.Pow((Period*10/NumberOfPeriods), 3) +
                           0.0183566433566437*Math.Pow((Period*10/NumberOfPeriods), 4);

                case 99: //SL
                    if (Period * 10.0 / NumberOfPeriods == 0.0)
                        return 0.0;

                    if (Period * 10.0 / NumberOfPeriods == 10.0)
                        return 100;

                    return 10*(Period*10/NumberOfPeriods);
            }

            return 0;
        }

Remove an item from an ArrayList

Tue, 23 Sep 2008 04:48:26 GMT

Description: If you want to remove an array item, this routine will do it for you.

Link: http://www.codekeep.net/snippets/eb9a18c1-b9b9-4ef9-a064-9b5b0bcc426c.aspx

int count = myArrayList.Count;
for(int i=0; i<count;)
{
        myArrayListItem item = (myArrayListItem)myArrayList[i];
        if (myArrayListItem.MyPropery > someValue)
        {
                myArrayList.RemoveAt(i);
                count--;
        } else {
                i++;
        }

}