CodeKeep C# Feed Giugno 27th, 2008
Description: Code sample
Link:
http://www.codekeep.net/snippets/fbdaa254-1727-4421-92c4-f1656a0d9360.aspxusing System;
using System.Collections.Generic;
using System.Text;
namespace testclass
{
public class Ram_Class
{
private int XX =20;
private int YY = 10;
public delegate int mycal(int zz, int qq);
public event mycal myevent;
static void Main(string[] args)
{
testclass.Ram_Class obj = new testclass.Ram_Class();
obj.Sum(2, 2);
}
public int sum
{
get
{
throw new System.NotImplementedException();
}
set
{
}
}
public int Sum(int xx, int yy)
{
myevent += new mycal(add);
myevent(2, 3);
return (this.XX + this.YY);
}
public int add(int zz, int qq)
{
//zz = this.XX;
//qq = this.YY;
return (zz-qq);
}
public int multiplication(int aa, int bb)
{
aa = this.XX;
bb = this.YY;
return (aa * bb);
}
}
}
CodeKeep C# Feed Giugno 27th, 2008
Description: This code allows to merge two different datatable into one datatable with the common Id field
Link:
http://www.codekeep.net/snippets/7750345b-e751-4a45-8b0d-a2e542d9c517.aspx public DataTable MergeTables(DataTable dtFirst, DataTable dtSecond, string CommonColumn)
{
DataTable dtResults = dtFirst.Clone();
int count=0;
for (int i = 0; i < dtSecond.Columns.Count; i++)
{
if (!dtFirst.Columns.Contains(dtSecond.Columns[i].ColumnName))
{
dtResults.Columns.Add(dtSecond.Columns[i].ColumnName, dtSecond.Columns[i].DataType);
count++;
}
}
DataColumn []columns = new DataColumn[count];
int j = 0;
for (int i = 0; i < dtSecond.Columns.Count; i++)
{
if (!dtFirst.Columns.Contains(dtSecond.Columns[i].ColumnName))
{
columns[j++] = new DataColumn(dtSecond.Columns[i].ColumnName, dtSecond.Columns[i].DataType);
}
}
dtResults.BeginLoadData();
foreach(DataRow dr in dtFirst.Rows)
{
dtResults.Rows.Add(dr.ItemArray);
}
foreach(DataRow dr in dtSecond.Rows)
{
foreach(DataRow dr1 in dtResults.Rows)
{
if(dr1[CommonColumn].ToString().Equals(dr[CommonColumn].ToString()))
{
foreach(DataColumn c in columns)
{
dr1[c.ColumnName] = dr[c.ColumnName];
}
}
}
}
dtResults.EndLoadData();
return dtResults;
}
CodeKeep C# Feed Giugno 26th, 2008
Description: Add Tooltip to dropdown list
Link:
http://www.codekeep.net/snippets/ba1a41c6-aec9-40b4-80ff-9e4021ecd97e.aspx this.ddlMeasure.Attributes.Add("onMouseOver", string.Format("var tip = document.getElementById('{0}'); tip.innerHTML = this.options[this.selectedIndex].title;tip.style.display = '';", this.ClientID + "_tooltip"));
this.ddlMeasure.Attributes.Add("onMouseOut", string.Format("document.getElementById('{0}').style.display = 'none';", this.ClientID + "_tooltip"));
writer.Write(string.Format("<SPAN id='{0}' style='BORDER:#646464 1px solid; z-index:1000; Margin-left:200px; PADDING-RIGHT:3px; DISPLAY:none; PADDING-LEFT:3px;FONT-SIZE:10px; Font-weight:normal; PADDING-BOTTOM:3px; PADDING-TOP:3px; FONT-FAMILY:Verdana; BACKGROUND-COLOR:#FAFAFA; Color:#646464; Position:absolute;'></SPAN>", this.ClientID + "_tooltip"));
CodeKeep C# Feed Giugno 26th, 2008
Description: Code snippet for db2 transaction
Link:
http://www.codekeep.net/snippets/379350b6-26af-4560-a5a7-be809e655118.aspx using(DB2Connection connection = new DB2Connection(ConnectionString))
{
connection.Open();
using(DB2Transaction transaction = connection.BeginTransaction())
{
try
{
transaction.Commit();
}
catch
{
if(transaction != null)
transaction.Rollback();
throw;
}
}
}
CodeKeep C# Feed Giugno 25th, 2008
Description: how to Read text from a word document using C#
Link:
http://www.codekeep.net/snippets/42920bef-805c-4321-940b-26c9eb059de9.aspx1>click Add reference to ur project select 'com' add reference for microsoftword
note: The name of your assemblies will vary based upon the version of Word that you have - in my case, it is version 11, or "Microsoft Word 11.0 Object Library."
2>For C# windows Application
-----------------------------
add namespace: using Word;
Code to get text from doc to textbox
-------------------------------------
openFileDialog1.ShowDialog();
string path = openFileDialog1.FileName.ToString();
Word.ApplicationClass wordApp = new ApplicationClass();
object file = path;
object nullobj = System.Reflection.Missing.Value;
Word.Document doc = wordApp.Documents.Open(ref file,ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj);
doc.ActiveWindow.Selection.WholeStory();
doc.ActiveWindow.Selection.Copy();
IDataObject data = Clipboard.GetDataObject();
txtload.Text = data.GetData(DataFormats.Text).ToString();
WebReference News Giugno 25th, 2008
Last time we looked at how to use the dnd module. This week, we look at how it's implemented. Like all GWT modules, our drag-and-drop module has an XML configuration file. It also has some Java classes and interfaces. David Geary and Rob Gordon. 0505
CodeKeep C# Feed Giugno 17th, 2008
CodeKeep C# Feed Giugno 17th, 2008
Description: To Open form by creating instance of it.
Link: http://www.codekeep.net/snippets/eac1283b-10ef-4314-a427-c88fb31f4205.aspx
private void addUserToolStripMenuItem_Click(object sender, EventArgs e)
{
if (MidAtlanticBaseClasses.BaseClass.objfrmAddUser == null || MidAtlanticBaseClasses.BaseClass.objfrmAddUser.IsDisposed == true)
{
MidAtlanticBaseClasses.BaseClass.objfrmAddUser = null;
MidAtlanticBaseClasses.BaseClass.CreateUserInstance("frmAddUser");
}
//MidAtlanticBaseClasses.BaseClass.UserEditMode = 0;
//((MidAtlanticUser.AddUser)MidAtlanticBaseClasses.BaseClass.objfrmAddUser).Mode = (int)MinAtlanticBusinessLayer.clsUserInformation.enUserEditMode.Add;
MidAtlanticBaseClasses.BaseClass.objfrmAddUser.MdiParent = this;
// frmAddUser.Mode = (int)MinAtlanticBusinessLayer.clsUserInformation.enUserEditMode.Add;
PropertyInfo[] objProperties = MidAtlanticBaseClasses.BaseClass.objfrmAddUser.GetType().GetProperties();
foreach (PropertyInfo objProperty in objProperties)
{
if (objProperty.Name == "FormMode")
{
objProperty.SetValue(MidAtlanticBaseClasses.BaseClass.objfrmAddUser, (int)MinAtlanticBusinessLayer.clsUserInformation.enUserEditMode.Add, null);
break;
}
}
CodeKeep C# Feed Giugno 17th, 2008
Description: MidAtlantic Base Class
Link: http://www.codekeep.net/snippets/0800d7c5-35ab-4d69-8b32-ad3d1beb3cf8.aspx
using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.Configuration;
using System.Reflection;
using System.Resources;
namespace MidAtlanticBaseClasses
{
public class BaseClass
{
//Property Declaration - SystemConfiguration
/// <summary>
/// public and static variable for MidAtlantic Connection String
/// </summary>
public static String strConnectingString = "";
public static String strDatabseName = "MidAtlanticAdmin";
public static AppSettingsReader objSettingReader;
public static string LoginId = string.Empty;
public static string UserName = string.Empty;
public static bool IsApplicationExitFlag = false;
//Reference Declaration - System Configurations
/// <summary>
/// public static variable for the System Configurations form
/// </summary>
public static Form objfrmSystemConfigurations = null;
//Reference Declaration - User Component
/// <summary>
/// public static variable for the Login form
/// </summary>
public static Form objfrmLogin = null;
public static Form objfrmAddUser = null;
public static Form objfrmUserManagement = null;
public static Form objfrmChangePassword = null;
/// <summary>
/// Public static variable for Manage Categories
/// </summary>
public static Form objfrmManageCategory = null;
public static Form objfrmAddEditCategory = null;
/// <summary>
/// Public static variable for Company Management
/// </summary>
public static Form objfrmManageCompany = null;
public static Form objfrmAddEditCompany = null;
/// <summary>
/// Public static variable for product Management
/// </summary>
public static Form objfrmAddEditProduct = null;
/// <summary>
/// This method is used to create the instance of User Module
/// </summary>
/// <param name="strClassName"></param>
public static void CreateUserInstance(String strClassName)
{
try
{
String strAssemblyPath = "";
objSettingReader = new AppSettingsReader();
strAssemblyPath = objSettingReader.GetValue("MidAtlanticUser", strAssemblyPath.GetType()).ToString();
strAssemblyPath = AppDomain.CurrentDomain.BaseDirectory.ToString() + strAssemblyPath;
if (System.IO.File.Exists(strAssemblyPath))
{
Assembly userAssembly = Assembly.LoadFile(strAssemblyPath);
System.Type[] ExistingTypes = userAssembly.GetTypes();
foreach (Type type in ExistingTypes)
{
if (type.Name.Equals(strClassName))
{
switch (type.Name)
{
case "frmLogin":
{
if (MidAtlanticBaseClasses.BaseClass.objfrmLogin == null)
{
MidAtlanticBaseClasses.BaseClass.objfrmLogin = ((Form)Activator.CreateInstance(type));
}
break;//
}
case "frmAddUser":
{
if (MidAtlanticBaseClasses.BaseClass.objfrmAddUser == null)
{
MidAtlanticBaseClasses.BaseClass.objfrmAddUser = ((Form)Activator.CreateInstance(type));
}
break;
}
case "frmUserManagement":
{
if (MidAtlanticBaseClasses.BaseClass.objfrmUserManagement == null)
{
MidAtlanticBaseClasses.BaseClass.objfrmUserManagement = ((Form)Activator.CreateInstance(type));
}
break;
}
}
}
}
}
}
catch (Exception objEx)
{
MidAtlanticDataLibrary.Database.logManager objLogManager = new MidAtlanticDataLibrary.Database.logManager();
objLogManager.AddErrorLogToDatabase(objEx, MidAtlanticBaseClasses.BaseClass.strConnectingString);
objLogManager = null;
}
}
/// <summary>
/// This Method is used to create Company management objects
/// </summary>
/// <param name="strClassName"></param>
public static void CreateCompanyInstance(String strClassName)
{
try
{
String strAssemblyPath = "";
objSettingReader = new AppSettingsReader();
strAssemblyPath = objSettingReader.GetValue("CompanyManagement", strAssemblyPath.GetType()).ToString();
strAssemblyPath = AppDomain.CurrentDomain.BaseDirectory.ToString() + strAssemblyPath;
if (System.IO.File.Exists(strAssemblyPath))
{
Assembly userAssembly = Assembly.LoadFile(strAssemblyPath);
System.Type[] ExistingTypes = userAssembly.GetTypes();
foreach (Type type in ExistingTypes)
{
if (type.Name.Equals(strClassName))
{
switch (type.Name)
{
case "frmManageCompany":
{
if (MidAtlanticBaseClasses.BaseClass.objfrmManageCompany == null)
{
MidAtlanticBaseClasses.BaseClass.objfrmManageCompany = ((Form)Activator.CreateInstance(type));
}
break;
}
case "AddEditCompany":
{
if (MidAtlanticBaseClasses.BaseClass.objfrmAddEditCompany == null)
{
MidAtlanticBaseClasses.BaseClass.objfrmAddEditCompany = ((Form)Activator.CreateInstance(type));
}
break;
}
}
}
}
}
}
catch (Exception objEx)
{
MidAtlanticDataLibrary.Database.logManager objLogManager = new MidAtlanticDataLibrary.Database.logManager();
objLogManager.AddErrorLogToDatabase(objEx, MidAtlanticBaseClasses.BaseClass.strConnectingString);
objLogManager = null;
}
}
/// <summary>
/// This Method is used to create Product management objects
/// </summary>
/// <param name="strClassName"></param>
public static void CreateProductInstance(String strClassName)
{
try
{
String strAssemblyPath = "";
objSettingReader = new AppSettingsReader();
strAssemblyPath = objSettingReader.GetValue("productManagement", strAssemblyPath.GetType()).ToString();
strAssemblyPath = AppDomain.CurrentDomain.BaseDirectory.ToString() + strAssemblyPath;
if (System.IO.File.Exists(strAssemblyPath))
{
Assembly userAssembly = Assembly.LoadFile(strAssemblyPath);
System.Type[] ExistingTypes = userAssembly.GetTypes();
foreach (Type type in ExistingTypes)
{
if (type.Name.Equals(strClassName))
{
switch (type.Name)
{
case "frmAddEditProduct":
{
if (MidAtlanticBaseClasses.BaseClass.objfrmAddEditProduct == null)
{
MidAtlanticBaseClasses.BaseClass.objfrmAddEditProduct = ((Form)Activator.CreateInstance(type));
}
break;
}
//case "AddEditCompany":
// {
// if (MidAtlanticBaseClasses.BaseClass.objfrmAddEditCompany == null)
// {
// MidAtlanticBaseClasses.BaseClass.objfrmAddEditCompany = ((Form)Activator.CreateInstance(type));
// }
// break;
// }
}
}
}
}
}
catch (Exception objEx)
{
MidAtlanticDataLibrary.Database.logManager objLogManager = new MidAtlanticDataLibrary.Database.logManager();
objLogManager.AddErrorLogToDatabase(objEx, MidAtlanticBaseClasses.BaseClass.strConnectingString);
objLogManager = null;
}
}
/// <summary>
/// This Method is used to create MidAtlanticSystem System Configurations objects
/// </summary>
/// <param name="strClassName"></param>
public static void CreateSystemConfigurationsInstance(String strClassName)
{
try
{
String strAssemblyPath = "";
objSettingReader = new AppSettingsReader();
strAssemblyPath = objSettingReader.GetValue("MidAtlanticSystem", strAssemblyPath.GetType()).ToString();
strAssemblyPath = AppDomain.CurrentDomain.BaseDirectory.ToString() + strAssemblyPath;
if (System.IO.File.Exists(strAssemblyPath))
{
Assembly userAssembly = Assembly.LoadFile(strAssemblyPath);
System.Type[] ExistingTypes = userAssembly.GetTypes();
foreach (Type type in ExistingTypes)
{
if (type.Name.Equals(strClassName))
{
switch (type.Name)
{
case "frmSystemConfig":
{
if (MidAtlanticBaseClasses.BaseClass.objfrmSystemConfigurations == null || MidAtlanticBaseClasses.BaseClass.objfrmSystemConfigurations.IsDisposed == true)
{
MidAtlanticBaseClasses.BaseClass.objfrmSystemConfigurations = ((Form)Activator.CreateInstance(type));
}
break;
}
}
}
}
}
}
catch (Exception objEx)
{
MidAtlanticDataLibrary.Database.logManager objLogManager = new MidAtlanticDataLibrary.Database.logManager();
objLogManager.AddErrorLogToDatabase(objEx, MidAtlanticBaseClasses.BaseClass.strConnectingString);
objLogManager = null;
}
}
/// <summary>
/// Function to Reterive System Configuration values from the specified Resource File.
/// </summary>
public static Boolean GetSystemConfigurationValues()
{
ResourceReader objResource = null;
String strDatabaseConnection = "";
String strDatabaseUsername = "";
String strDatabasePassword = "";
Boolean blnIsValid = true;
try
{
System.IO.FileInfo objFileInfo = new System.IO.FileInfo(@AppDomain.CurrentDomain.BaseDirectory.ToString() + @"\Mid-Atlantic.Mid-AtlanticResource.resources");
if (objFileInfo.Exists == false)
{
return false;
}
objResource = new ResourceReader(@AppDomain.CurrentDomain.BaseDirectory.ToString() + @"\Mid-Atlantic.Mid-AtlanticResource.resources");
foreach (DictionaryEntry objEntry in objResource)
{
switch (objEntry.Key.ToString())
{
case "Mid-AtlanticDatabaseSource":
{
strDatabaseConnection = objEntry.Value.ToString();
break;
}
case "Mid-AtlanticDatabaseUsername":
{
strDatabaseUsername = objEntry.Value.ToString();
break;
}
case "Mid-AtlanticDatabasePassword":
{
strDatabasePassword = objEntry.Value.ToString();
break;
}
}
}
if (strDatabaseConnection.Trim().Length > 0)
{
strConnectingString = "Server=" + strDatabaseConnection.Trim() + ";Initial Catalog="+MidAtlanticBaseClasses.BaseClass.strDatabseName+";User ID=" + strDatabaseUsername.Trim() + ";Password=" + strDatabasePassword.Trim() + ";";
}
}
catch (Exception objEx)
{
blnIsValid = false;
MidAtlanticDataLibrary.Database.logManager objLog = new MidAtlanticDataLibrary.Database.logManager();
objLog.AddErrorLogToDatabase(objEx, MidAtlanticBaseClasses.BaseClass.strConnectingString);
objLog = null;
}
finally
{
if (objResource != null) objResource.Close();
objResource = null;
}
return blnIsValid;
}
}
}
CodeKeep C# Feed Giugno 17th, 2008
Description: a simple encryptor/decryptor
Link: http://www.codekeep.net/snippets/bf47b389-24ba-41c5-9b23-2f2ffb64d0c9.aspx
/// <summary>
/// Class to encrypt and decrypt the password
/// </summary>
public static class EncryptorDecryptor
{
public static int key = 3;
/// <summary>
/// Encrypts and decrypts a given string.
/// </summary>
/// <param name="textToEncrypt">The text to encrypt or decrypt.</param>
/// <returns></returns>
public static string EncryptDecrypt(string textToEncrypt)
{
StringBuilder inSb = new StringBuilder(textToEncrypt);
StringBuilder outSb = new StringBuilder(textToEncrypt.Length);
char c;
for (int i = 0; i < textToEncrypt.Length; i++)
{
c = inSb[i];
c = (char)(c ^ key);
outSb.Append(c);
}
return outSb.ToString();
}
}
