Hello Guys!
I got adopted this code from this website written by Hammad Maqbool. I found it very interesting but i just want to clarify if how would i going to use this in Windows Forms Applications like in "Try" Statement.
This is the class i modified:
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using MySql.Data.MySqlClient;
- using System.Data;
-
- namespace myssfasys
- {
- public class myconnstring1
- {
- string ConnString = "Server=localhost; User Id=root; Password=deityshasm911; Database=ssfasys";
- MySqlConnection con;
-
- public void OpenConection()
- {
- con = new MySqlConnection(ConnString);
- con.Open();
- }
-
-
- public void CloseConnection()
- {
- con.Close();
- }
-
-
- public void ExecuteQueries(string Query_)
- {
- MySqlCommand cmd = new MySqlCommand(Query_, con);
- cmd.ExecuteNonQuery();
- }
-
-
- public MySqlDataReader DataReader(string Query_)
- {
- MySqlCommand cmd = new MySqlCommand(Query_, con);
- MySqlDataReader dr = cmd.ExecuteReader();
- return dr;
- }
-
-
- public object ShowDataInGridView(string Query_)
- {
- MySqlDataAdapter dr = new MySqlDataAdapter(Query_, ConnString);
- DataSet ds = new DataSet();
- dr.Fill(ds);
- object dataum = ds.Tables[0];
- return dataum;
- }
- }
- }