Reply to thread

Message: <blockquote data-quote="heshan123" data-source="post: 1726927" data-attributes="member: 15457">OK guys here is the deal. I some of you are software engineers like me and most of the ppl are into IT in some form. So I believe a knowledge sharing system would be really nice since we have lot of members here. <img src="/styles/default/xenforo/smilies/default/wink.gif"  class="smilie" loading="lazy" alt=";)" title="Wink    ;)" data-shortname=";)" /> OK I will start. This is Visual C# Code that I recently came up with to 'remotely' log into a MySQL database and access records. Its not copy right reserved or anything so feel free to make modifications to it if u like. Im fully open source. <img src="/styles/default/xenforo/smilies/default/D.gif"  class="smilie" loading="lazy" alt=":D" title="Big grin    :D" data-shortname=":D" /> <img src="/styles/default/xenforo/smilies/default/D.gif"  class="smilie" loading="lazy" alt=":D" title="Big grin    :D" data-shortname=":D" /> Before u try this code u will have to download the mysql connector/net, it is located at: <a href="http://dev.mysql.com/downloads/connector/net/1.0.html" target="_blank">Click Here</a>Next add reference to: MySql.Data in your projectNext add "using MySql.Data.MySqlClient;" in your declaration section. Try the code below.[CODE]private void button1_Click(object sender, System.EventArgs e)        {            string conPara = "SERVER=localhost;" +                "DATABASE=db1;" +                "UID=testuser;" +                "PASSWORD=testpassword;";            MySqlConnection connection = new MySqlConnection(conPara);            MySqlCommand statement = connection.CreateCommand();            MySqlDataReader Result;            statement.CommandText = "select * from customers";            connection.Open();            Result = statement.ExecuteReader();            while (Result.Read())            {                string thisrow = "";                for (int i= 0;i<Reader.FieldCount;i++)                        thisrow+=Result.GetValue(i).ToString() + ",";                listBox1.Items.Add(thisrow);            }            connection.Close();        }[/CODE]Ok that should connect you remotely to your MySQL Database and retrieve a record from the table named customers. If there are any questions pls post it here. I will try to answer. <img src="/styles/default/xenforo/smilies/default/wink.gif"  class="smilie" loading="lazy" alt=";)" title="Wink    ;)" data-shortname=";)" /> <img src="/styles/default/xenforo/smilies/default/wink.gif"  class="smilie" loading="lazy" alt=";)" title="Wink    ;)" data-shortname=";)" /></blockquote>

Verification: Hath warak paha keeyada? (hatha wadikireema paha)

Top Bottom