Developer Project World

Clear All Browser Settings,History,Cache,Cookies

2013-06-06T22:35:00.001-07:00

Path For All Browser Settings,History,Cache,Cookies

string GooglePath = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Local\Google\Chrome\User Data\Default\";
string MozilaPath = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Roaming\Mozilla\Firefox\";
string Opera1 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Local\Opera\Opera";
string Opera2 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Roaming\Opera\Opera";
string Safari1 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Local\Apple Computer\Safari";
string Safari2 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Roaming\Apple Computer\Safari";
string IE1 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Local\Microsoft\Intern~1";
string IE2 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Local\Microsoft\Windows\History";
string IE3 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Local\Microsoft\Windows\Tempor~1";
string IE4 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Roaming\Microsoft\Windows\Cookies";
string Flash = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Roaming\Macromedia\Flashp~1";

//Mozilla Get Path From Profile.Ini

//If IsRelative=1 then Get Folder Name or Get Full Path for Mozilla

public void ClearAllSettings(string[] ClearPath)

{

foreach (string HistoryPath in ClearPath)

{

if (Directory.Exists(HistoryPath))

{

DoDelete(new DirectoryInfo(HistoryPath));

}

void DoDelete(DirectoryInfo folder)

{

try

{

foreach (FileInfo file in folder.GetFiles())

{

try

{

file.Delete();

}

catch

{ }

}

foreach (DirectoryInfo subfolder in folder.GetDirectories())

{

DoDelete(subfolder);

}

catch

{

}

//Call This Method ClearAllSettings and Pass String Array Param

ClearAllSettings(new string[] { GooglePath, MozilaPath, Opera1, Opera2, Safari1, Safari2, IE1, IE2, IE3, IE4, Flash }))

//Read Mozilla Profile ini Use This Method

if (ReadIniValue(MozilaPath + "Profiles.ini", "IsRelative") == "1")

{

MozilaPath = MozilaPath + ReadIniValue(MozilaPath + "Profiles.ini", "path").Replace("/", @"\");// +@"\User.js";

}

else

{

MozilaPath = ReadIniValue(MozilaPath + "Profiles.ini", "path").Replace("/", @"\");// +@"\user.js";

}

Proxy, Set Proxy To Webbrowser in c# Code,Proxy With Webbrowser

2013-05-27T00:50:00.001-07:00

private void SetProxyToBrowser(WebBrowser iWB)

{

try

{

string ProxyEmail = "" ;

string ProxyPass = "" ;

string ProxyUID = "" ;

string ProxyUPass = "" ;

string ProxyIp = "" ;

int ProxyPort = 0;

ProxyIp = "Proxy IP";

ProxyPort = Proxy Port;

ProxyUID = "Proxy User ID"; // IF You Have

ProxyUPass = "Proxy User Password"; // IF You Have

ProxyEmail = "Proxy Email ID";

ProxyPass = "Proxy Email Password";

Application.DoEvents();

HttpWebRequest myRequest = (HttpWebRequest)HttpWebRequest .Create(SignInAddress);

WebProxy myProxy = new WebProxy(ProxyIp, ProxyPort);

if (ProxyUID.Trim() != "" && ProxyUPass.Trim() != "")

myProxy.Credentials = new NetworkCredential (ProxyUID, ProxyUPass);

myRequest.Proxy = myProxy;

HttpWebResponse myResponse = (HttpWebResponse)myRequest.GetResponse();

iWB.DocumentStream = myResponse.GetResponseStream();

}

catch

{

//Code...

}

How To Delete All Files And Folder

2013-05-24T02:36:00.005-07:00

Using System.IO;

public static void CleanFiles(String FolderPath)
     {
            if (Directory.Exists(FolderPath))
            {
                var directory = new DirectoryInfo(FolderPath);
               foreach (FileInfo file in directory.GetFiles())
               { 
                  if(!IsFileLocked(file)) 
                       file.Delete(); 
               }
               foreach (DirectoryInfo subfolder in directory.GetDirectories())
                {
                    CleanFiles(subfolder);
                }
            }
     }

public static Boolean IsFileLocked(FileInfo file)

            FileStream stream = null;

try

                //Don't change FileAccess to ReadWrite,

                //because if a file is in readOnly, it fails.

                stream = file.Open

                    FileMode.Open,

                    FileAccess.Read,

                    FileShare.None

);

            catch (IOException)

                //the file is unavailable because it is:

                //still being written to

                //or being processed by another thread

                //or does not exist (has already been processed)

                return true;

            finally

                if (stream != null)

                    stream.Close();

            //file is not locked

            return false;

How To check File Is Being Another Process ,How To Check File Lock,How To CHeck File is In Used In another Proces

2013-05-24T02:32:00.000-07:00

Using System.IO;

public static Boolean IsFileLocked(FileInfo file)

            FileStream stream = null;

try

                //Don't change FileAccess to ReadWrite,

                //because if a file is in readOnly, it fails.

                stream = file.Open

                    FileMode.Open,

                    FileAccess.Read,

                    FileShare.None

);

            catch (IOException)

                //the file is unavailable because it is:

                //still being written to

                //or being processed by another thread

                //or does not exist (has already been processed)

                return true;

            finally

                if (stream != null)

                    stream.Close();

            //file is not locked

            return false;

How To Zip And Unzip Files And Folder Fast,compressed Files And Folder Fast with ICSharpCode.SharpZipLib.Zip

2013-05-11T02:24:00.001-07:00

///////////Download This Dll From Link
///////////http://sourceforge.net/projects/sharpdevelop/files/SharpZipLib/0.86/SharpZipLib_0860_Bin.zip/dow/nload?use_mirror=kaz
///////////and Add This Dll in project

using ICSharpCode.SharpZipLib.Zip;
//Zip a Folder
public static void ZipToFilder(string ZipFolderPath, string SavePath)
{
StringBuilder newPath = new StringBuilder(SavePath);
ZipInputStream zipIn = new ZipInputStream(File.OpenRead(ZipFolderPath));
ZipEntry entry;
if (Directory.Exists(SavePath) != true)
{
Directory.CreateDirectory(SavePath);
}
while ((entry = zipIn.GetNextEntry()) != null)
{
if (entry.Name.EndsWith("/"))
{
Directory.CreateDirectory(String.Format("{0}{1}", newPath, entry.Name.Replace(@"/", @"\")));
}
else
{
FileStream streamWriter = File.Create(String.Format("{0}{1}", newPath, entry.Name.Replace(@"/", @"\")));
long size = entry.Size;
byte[] data = new byte[size];
while (true)
{
size = zipIn.Read(data, 0, data.Length);
if (size > 0) streamWriter.Write(data, 0, (int)size);
else break;
}
streamWriter.Close();
streamWriter.Dispose();
}
}
zipIn.Close();
}

//UnZip a Folder
public static void FolderToZip(string sTargetFolderPath, string ZipFileName)
{
string sZipFileName = ZipFileName;
string[] filenames = Directory.GetFiles(sTargetFolderPath);
//string ZipPath = Directory.GetParent(sTargetFolderPath).ToString();
string ZipPath = sTargetFolderPath;

using (ZipOutputStream s = new ZipOutputStream(File.Create(ZipPath + "\\" + sZipFileName + "")))
{
s.SetLevel(9); // 0-9, 9 being the highest level of compression
byte[] buffer = new byte[4096];
foreach (string file in filenames)
{
ZipEntry entry = new ZipEntry(Path.GetFileName(file));
entry.DateTime = DateTime.Now;
s.PutNextEntry(entry);
using (FileStream fs = File.OpenRead(file))
{
int sourceBytes;
do
{
sourceBytes = fs.Read(buffer, 0, buffer.Length);
s.Write(buffer, 0, sourceBytes);

} while (sourceBytes > 0);
}
}
s.Finish();
s.Close();
}
//Directory.Delete(sTargetFolderPath + "\\TempZipFile\\", true);
}

strip string ,remove text char from string,get only text string from full string,remove charackter from string

2013-05-03T01:20:00.002-07:00

private string StripString(string StrText)

{

string StripText = "";

foreach (char chritem in StrText.ToCharArray())

{

if (char.IsDigit(chritem) != false)

{

StripText += chritem;

}

return StripText;

}

get only text string from string ,strip number,remove number from string,get only text string from string

2013-05-03T01:18:00.003-07:00

private string StripNumber(string StrText)

{

string StripText = "";

foreach (char chritem in StrText.ToCharArray())

{

if (char.IsDigit(chritem) == false)

{

StripText += chritem;

}

return StripText;

}

Getting Schema Information from the Data Reader

2013-05-02T01:20:00.000-07:00

static void GetSchemaInfo(SqlConnection connection)
{
    using (connection)
    {
        SqlCommand command = new SqlCommand(
          "SELECT CategoryID, CategoryName FROM Categories;",
          connection);
        connection.Open();

        SqlDataReader reader = command.ExecuteReader();
        DataTable schemaTable = reader.GetSchemaTable();

        foreach (DataRow row in schemaTable.Rows)
        {
            foreach (DataColumn column in schemaTable.Columns)
            {
                Console.WriteLine(String.Format("{0} = {1}",
                   column.ColumnName, row[column]));
            }
        }
    }
}

Get multiple results from data reader c#, retrieving data using data reader

2013-05-02T01:17:00.001-07:00

static void RetrieveMultipleResults(SqlConnection connection)
{
    using (connection)
    {
        SqlCommand command = new SqlCommand(
          "SELECT CategoryID, CategoryName FROM dbo.Categories;" +
          "SELECT EmployeeID, LastName FROM dbo.Employees",
          connection);
        connection.Open();

        SqlDataReader reader = command.ExecuteReader();

        while (reader.HasRows)
        {
            Console.WriteLine("\t{0}\t{1}", reader.GetName(0),
                reader.GetName(1));

            while (reader.Read())
            {
                Console.WriteLine("\t{0}\t{1}", reader.GetInt32(0),
                    reader.GetString(1));
            }
            reader.NextResult();
        }
    }
}

Make System Tray Based Application in .NET,Open Application in start menu tray / notification area c#

2013-04-29T06:14:00.002-07:00

Creating an application that lives in the system tray is easy, but it is not entirely obvious how to do so in Visual Studio. This recipe will show you the steps.

1) First, create a new Windows Application project in Visual Studio.NET. This can be either Visual Basic or C#

2) Drag a Notifyicon control and a ContextMenu control from the toolbox onto the form.

3) Click on the NotifyIcon control that you just added, and set the Icon property to whatever icon you want your application to have.

4) Set the ContextMenu property of the Notifyicon to the context menu that you added to your project.

5) Right click on the Context Menu control, and select Edit. Since this menu will be the right-click menu for your tray icon, you will want to add the items that the user will see. Make sure to add an Exit menu item.

6) Double click the Exit menu item, and add the following code:this.Close();

7) Now for the important settings. Click on the form, and go to the Properties window. Set the following settings:

FormBorderSize: Fixed Tool Window
WindowState: Minimized
Opacity: 0%
ShowInTaskbar: False

The key thing to remember is that the default form is not to be used for application functionality, it is only used as the hidden background window. If you want to create a new window, you can just add another form to your application.

How to Loop through Enum Values in C#, Loop on Enum

2013-04-29T03:46:00.000-07:00

enum WeekDays { Sun, Mon, Tue, Wed, Thu, Fri, Sat };

string[] days = Enum.GetNames(typeof(WeekDays));//Hear You Can Set Your Enum Type
foreach (string s in days)
{
Console.WriteLine(s);
}

How can I to clear a selection in a dataGridView c#

2013-04-29T01:35:00.002-07:00

dataGridView1.ClearSelection();

C#: Split String Using a Variable Length Delimiter,Splitting Strings

2013-04-29T00:21:00.003-07:00

Splitting Strings Using char[]

string words = "This is a list of words, with: a bit of punctuation.";string [] split = words.Split(new Char [] {' ', ',', '.', ':'});

This would produce the string array:

{ "This", "is", "a", "list", "of", "words", "with", "a", "bit", "of", "punctuation" }

Splitting Strings Using string[]

string words = "This is a list of words: aesthetics, praefect"; string[] separators = {", ", "ae"};
string[] split = words.Split(separators, StringSplitOptions.None);

This would produce the string array:

{ "This is a list of words: ", "sthetics", "pr", "fect" }

ER Relational Data Model

2013-04-28T22:52:00.001-07:00

ER to Relational Data Model

9.1 An Entity-Relationship (ER) Diagram

9.2 A Relational Data Schema

EMPLOYEE

Fname

Lname

\underline{S S N}

SupervisorSSN

DEPARTMENT

Name

\underline{N U M B E R}

MANAGER-SSN

StartDate

DEPENDENT

Relationship

\underline{E M P L - S S N}

\underline{N a m e}

DEP-LOCATION

Location

DEP-NUMBER

WORKS-FOR

EmployeeSSN

DeptNumber

Comments:

EMPLOYEE (SupervisorSSN)	$→$	EMPLOYEE (SSN)
DEPARTMENT (MANAGER-SSN)	$→$	EMPLOYEE (SSN)
DEPENDENT (EMPL-SSN)	$→$	EMPLOYEE (SSN)
DEP-LOCATION (DEP-NUMBER)	$→$	DEPARTMENT (NUMBER)
WORKS-FOR (EmployeeSSN)	$→$	EMPLOYEE (SSN)
WORKS-FOR (DeptNumber)	$→$	DEPARTMENT (NUMBER)
unique: DEPARTMENT.NAME

create table EMPLOYEE{ 
  Fname... 
  Lname... 
  SSN... primary key 
  SupervisorSSN... reference EMPLOYEE(SSN) 
} 
create table DEPARTMENT{ 
  NAME... 
  NUMBER... primary key 
  MANAGER-SSN... references EMPLOYEE(SSN) 
  StartDate 
} 
create table DEPENDENT{ 
  Relationship... 
  EMPL-SSN... references EMPLOYEE(SSN) 
  Name ... 
  primary key(EMPL-SSN,Name) 
} 
create table DEP-LOCATION{ 
  Location... primary key 
  DEPNUMBER... references DEPARTMENT(Number) 
} 
create table WORKS-FOR{ 
  EmployeeSSN... references EMPLOYEE(SSN) 
 DeptNumber... references DEPARTMENT(Number) 
}  

9.3 The Mapping

(Strong) Entity Type into Relation

Include the simple attributes
Include the simple components of the composite attributes
Identify the primary keys
Don’t include: non-simple components of composite attributes, foreign keys, derived attributes, relational attributes

EMPLOYEE

Fname

Lname

\underline{S S N}

DEPARTMENT

Name	$\underline{N u m b e r}$

Binary 1:1 Relationship Types into Foreign Keys

Include as foreign keys, in the relation of one entity type, the primary keys of the other entity type
Include also the simple attributes of the relationship type
If possible, the first entity type should have total participation in the relationship (to save memory!)

DEPARTMENT

MANAGER-SSN

StartDate

Binary 1:N Relationship Types into Foreign Keys

Add as foreign keys, to the relation of the entity type at the N side, the primary keys of the entity type at the 1 side (don’t duplicate records!)
Include also the simple attributes of the relationship type

EMPLOYEE

SupervisorSSN

Binary M:N Relationship Type into Relation

We don’t want to duplicate records!
Set as foreign keys the primary keys of the participating entity types
Include the simple attributes of the relationship type

WORKS-FOR

EmployeeSSN

DeptNumber

N-Ary Relationship Type

Similar to binary M:N relationship type

Multivalued Attribute into Relation

Include the given attribute
Include as foreign keys the primary attributes of the entity/relationship type owning the multivalued attribute
Keys not designated within primary keys are to be mentioned as such in side comments

DEP-LOCATION

Location

\underline{D E P - N U M B E R}

Resembles the treatment of a relationship type.

Weak Entity+Relationship Types into Relation

Include simple attributes
Add the owner’s primary key attributes, as foreign key attributes
Declare into a primary key the partial keys of the weak entity type combined with those imported from the owner

DEPENDENT

Relationship

\underline{E M P L - S S N}

\underline{N A M E}

Reference: Ch. 7.1 in textbook.

entity-relationship model (ERM or ER model)

2013-04-28T22:46:00.001-07:00

What is entity-relationship model (ERM or ER model)? - Definition from WhatIs.com

append text in file ,append string text to the text File, insert string to the file

2013-04-25T05:32:00.002-07:00

private void WriteToLog(string file, string message)

{

using (StreamWriter w = File.AppendText(file))

{

w.WriteLine( DateTime.Now.ToString() + ": " + message); w.Close();

}

how to get page screen shot, Get Desktop Image ,Capture To the Screen

2013-04-25T05:30:00.003-07:00

http://www.codeproject.com/Articles/21913/TeboScreen-Basic-C-Screen-Capture-Application

String To Csv File,Add string Data to Csv File , Fastest Way to convert String to Csv

2013-04-25T05:27:00.001-07:00

private DataTable StrTOCSV(string content)

{

DataTable tbl = new DataTable();

if (content.Length > 0)

{

string[] rows = content.Split('\n' );

if (rows.Length > 0)

{

//Create Columns in Datatable.

string[] cols = rows[0].Split(new [] { "," }, StringSplitOptions.RemoveEmptyEntries);

if (cols.Length > 0)

{

foreach (var item in cols)

{

tbl.Columns.Add(item);

}

//Add rows in datatable

for (int i = 1; i < rows.Length; i++)

{

string[] coldata = rows[i].Split(new [] { "," }, StringSplitOptions.RemoveEmptyEntries);

DataRow dr = tbl.NewRow();

for (int j = 0; j < cols.Length; j++)

{

if (coldata.Length > 0)

{

if (j <= coldata.Length)

{

dr[j] = coldata[j];

}

tbl.Rows.Add(dr);

}

return tbl;

}

Convert Array To List, Array To List

2013-04-25T05:25:00.002-07:00

List<string > ArrayToList(string[] arr)

{

List<string > retVals = new List<string >();

foreach (string item in arr)

{

retVals.Add(item);

}

return retVals;

}

Download Image from url website,get image from url and set to the image control download bitmap image

2013-04-23T05:56:00.000-07:00

Get image from website and set to the image control

string url = "http://ichart.finance.yahoo.com/b?s=YHOO" ;

WebRequest requestPic = WebRequest .Create(url);

WebResponse responsePic = requestPic.GetResponse();

Image webImage = Image .FromStream(responsePic.GetResponseStream());

ImgChart.Image = webImage;

download data from Url, Uri, And Website,Download Data from Yahoo ,Read Data from Website

2013-04-23T05:53:00.001-07:00

Get Data From Url Or Website

string yahooURL = @"http://download.finance.yahoo.com/d/quotes.csv?s=" + Cmbsym.Text + "&f=sl1d1t1c1hgvbap2" ;

string GetData = GetDataFromURL(yahooURL);

public static string GetDataFromURL( string URL)

{

string Content = "" ;

int Failure = 0;

HttpWebRequest WebReq;

HttpWebResponse WebResp = null ;

StreamReader Strm = null ;

TryAgain:

try

{

if (Failure == 3)

return "" ;

WebReq = ( HttpWebRequest)WebRequest .Create(URL);

WebReq.Timeout = 50000;

WebResp = ( HttpWebResponse)WebReq.GetResponse();

Strm = new StreamReader (WebResp.GetResponseStream());

Content = Strm.ReadToEnd();

Strm.Close();

Strm.Dispose();

WebResp.Close();

}

catch (Exception ex)

{

if (ex.Message.Contains("(404) Not Found" ))

{ }

if (Strm != null )

{

Strm.Close();

Strm.Dispose();

}

if (WebResp != null )

{

WebResp.Close();

}

Failure++;

goto TryAgain;

}

return Content;

}

Send Mail,Send Bulk Mail, Send Mail In Backgroudworker Thread in C#

2013-04-23T05:37:00.002-07:00

Send Mail

using System.Net.Mail;

public static void DoMails( string Msg)

{

BackgroundWorker worker = new BackgroundWorker();

worker.DoWork += new DoWorkEventHandler (worker_DoWork);

worker.WorkerReportsProgress = true;

worker.WorkerSupportsCancellation = false;

worker.RunWorkerAsync(Msg);//passing argument

}

private static void worker_DoWork( object sender, DoWorkEventArgs e)

{

DoMail(e.Argument.ToString());

}

private static void DoMail( string Msg)

{

string MailFrom = "Abc@gmail.com"; //from Mail id

string MailTo = "Xyz@yahoo.com";//to mail id

string SmtpHostServer = "smtp.gmail.com"; // your server

string MailUserID = MailFrom;

string MailPassword = From mail id password;

string MailSubject = "Hello";//your subject

string MailMsg = Msg; //your msg

string MailPort = Properties.Settings .Default.Port;

try

{

MailMessage mail = new MailMessage();

SmtpClient SmtpServer = new SmtpClient(SmtpHostServer);

mail.From = new MailAddress (MailFrom);

mail.To.Add(MailTo);

mail.Subject = MailSubject;

mail.Body = MailMsg;

//if you have attachment file then uncompleted below code

//if (File.Exists(TxtAttechment.Text))

//{

// Attachment FileAttachments = new Attachment(TxtAttechment.Text);

// mail.Attachments.Add(FileAttachments);

//}

SmtpServer.Port = "956";//your server port

SmtpServer.Credentials = new System.Net.NetworkCredential (MailUserID, MailPassword);

SmtpServer.EnableSsl = true;

SmtpServer.Send(mail);

}

catch

{

//MessageBox.Show("Mail Not Send : " + ex.Message.ToString());

}

XML To Treeview

2013-04-23T04:21:00.000-07:00

XML To Treeview

Imports System.Xml

Public Class Form1

Private Sub Form1_Load(ByVal sender As System. Object, ByVal e As System.EventArgs) Handles MyBase.Load

Try

Dim dom As New XmlDocument

dom.Load(TextBox1.Text)

TreeView1.Nodes.Clear()

TreeView1.Nodes.Add( New TreeNode (dom.DocumentElement.Name))

Dim tnode As New TreeNode

tnode = TreeView1.Nodes(0)

AddNode(dom.DocumentElement, tnode)

TreeView1.ExpandAll()

Catch

End Try

End Sub

Private Sub AddNode(ByVal inXmlNode As XmlNode, ByVal inTreeNode As TreeNode)

Dim xNode As XmlNode

Dim tNode As New TreeNode

Dim nodeList As XmlNodeList

Dim i As Integer = 0

If inXmlNode.HasChildNodes Then

nodeList = inXmlNode.ChildNodes

For i = 0 To nodeList.Count - 1

xNode = inXmlNode.ChildNodes(i)

inTreeNode.Nodes.Add( New TreeNode (xNode.Name))

tNode = inTreeNode.Nodes(i)

AddNode(xNode, tNode)

Else

inTreeNode.Text = (inXmlNode.OuterXml).Trim()

End If

End Sub

End Class

Get Page All Links C#,Get Links From Url

2013-04-23T03:47:00.001-07:00

Get Page All Links C#

WebBrowser mWB = new WebBrowser();

mWB.ScriptErrorsSuppressed = true;

WebClient wc = new WebClient();

mWB.DocumentText = wc.DownloadString(mUrl);

{

Application.DoEvents();

} while (mWB.ReadyState != WebBrowserReadyState .Complete);

foreach (HtmlElement item in mWB.Document.Links)

{

string strlinks = item.GetAttribute( "href");

if (Convert .ToInt32(tbl.Compute("Count(link)", "Link='" + strlinks + "'")) == 0)

{

tbl.Rows.Add(strlinks);

}

Get Values Between String , Tags C#

2013-04-23T03:45:00.003-07:00

Get Values Between String , Tags C#

public string GetStringBetween(string src, string findfrom, string findto)

{

try

{

int sIndex = src.IndexOf(findfrom);

int eIndex = src.IndexOf(findto, sIndex + findfrom.Length);

if (sIndex < 0 || eIndex < 0) return "";

string s = src.Substring(sIndex + findfrom.Length, eIndex - sIndex - findfrom.Length);

return s;

}

catch { return ""; }

}