C#

For each(Employee emp in Employees){<br />
  Console.WriteLine(emp.ID.ToString());<br />
}<br />
<br />

samy100 wrote:

i want to write to a file on the client's computer

private void loadBtn_Click(object sender, EventArgs e)<br />
        {<br />
            //select the database & table<br />
            string strFindMovie = "SELECT movie_name FROM movie WHERE movie_id='1'";<br />
<br />
            //create the connection between the program and the database<br />
            MySql.Data.MySqlClient.MySqlConnection conDatabase = new <br />
                MySql.Data.MySqlClient.MySqlConnection("Data Source=localhost; Database=moviesite; username=******; password=*****");<br />
            MySql.Data.MySqlClient.MySqlCommand cmdDatabase = new <br />
                MySql.Data.MySqlClient.MySqlCommand(strFindMovie, conDatabase);<br />
<br />
            //open connection to the dtabase<br />
            conDatabase.Open();<br />
<br />
            MySql.Data.MySqlClient.MySqlDataReader rdrMovie;<br />
            rdrMovie = cmdDatabase.ExecuteReader();<br />
<br />
            while (rdrMovie.Read())<br />
            {<br />
                this.nameTB.Text = rdrMovie.GetString(0);<br />
            }<br />
<br />
            //closes teh reader<br />
            rdrMovie.Close();<br />
            //closes the con to the database<br />
            conDatabase.Close();<br />
        }

shadowhazard wrote:

ok i think i have it now, just need to make some minor alterations, and instead of using a load button i will be using a the Select.Item.Index from a listbox to retrieve the information from the database. if anyone has any comments or notices room for correction please let me know. i enjoy C# but i am new to the combination of C# & MySql.

string strMovieName = this.movieNameTB.Text;<br />
<br />
            try<br />
            {<br />
<br />
                if (strMovieName == "")<br />
                {<br />
                    MessageBox.Show("You must provide the Movie name");<br />
                    return;<br />
                }<br />
<br />
                string strFindMovie = "SELECT * FROM movie WHERE movie_name = '" + strMovieName + "'";<br />
<br />
<br />
                //create the connection between the program and the database<br />
                MySql.Data.MySqlClient.MySqlConnection conDatabase = new<br />
                    MySql.Data.MySqlClient.MySqlConnection("Data Source=localhost; Database=moviesite; Persist Security Info=yes; username=*******; password=*****");<br />
<br />
                MySql.Data.MySqlClient.MySqlCommand cmdDatabase = new<br />
                    MySql.Data.MySqlClient.MySqlCommand(strFindMovie, conDatabase);<br />
<br />
                //open connection to the dtabase<br />
                conDatabase.Open();<br />
<br />
                MySql.Data.MySqlClient.MySqlDataReader rdrMovie;<br />
                rdrMovie = cmdDatabase.ExecuteReader();<br />
<br />
                while (rdrMovie.Read())<br />
                {<br />
                    this.typeTB.Text = rdrMovie.GetString(2);<br />
                    this.movieYearTB.Text = rdrMovie.GetString(3);<br />
                }<br />
<br />
                //closes teh reader<br />
                rdrMovie.Close();<br />
                //closes the con to the database<br />
                conDatabase.Close();<br />
            }<br />
            catch (MySqlException ex)<br />
            {<br />
                MessageBox.Show(ex.Message);<br />
            }

HttpWebRequest webRequest = WebRequest.Create("http://www.codeproject.com") as HttpWebRequest;
string html = "";

if (webRequest != null)
{
    HttpWebResponse response = webRequest.GetResponse() as HttpWebResponse;
    if (response != null)
    {
         using (StreamReader reader = new StreamReader(response.GetResponseStream()))
         {
             html = reader.ReadToEnd();
         }
    }
}
 
if (html.Length > 0)
{
    HtmlParser parser = new HtmlParser();
    HtmlNodeCollection nodes = parser.Parse(html);
 
    // Find all of the table elements
    HtmlNodeCollection tables = nodes.FindByName("table");
 
    // Select the 6th table element
    HtmlNode table = tables[6];
}

XmlDocument xml = new XmlDocument();
xml.LoadXml(table.XHTML);
XmlNodeList tableRows = xml.SelectNodes("//tr");