Ir al contenido principal

C# - Datagridview inyect a MySql DataSource

Datagridview 

To inyect a DataSource to a Datgridview to update it automatically


  • Create your query to fetch the data
            query = "SELECT id, signum as Signum, name as Name, 
                 remote_IP as 'Remote IP', remote_port as 'Remote Port' " +
                "FROM eterminal.rel_user_session where signum = '" + signum + "'";


  • Create a MySqlDataAdapter, this object will update your datagridview
    • The Second parameter is an active connection of type MySqlConnection

MySqlConnection mconnection = new MySqlConnection("Server=146.250.116.2; Database=MydB; Uid=User; Pwd=pwd2@");         
MySqlDataAdapter adapter = new MySqlDataAdapter(query,  connection.getActiveConnection());



  • This help to create the proper commands to update, delete, add
            MySqlCommandBuilder cb = new MySqlCommandBuilder(adapter);

  • The DataSet is where the information is allocated and is used to fill the datagridview
    • The adapater will perform all the changes
            ds = new DataSet();
            adapter.Fill(ds, "session");


  • Assign the DataSet to fill the datagridview
            datagridview.DataSource =  ds.Tables[0];


  • The last step is update the datageridview, in the event you want. Ex in a click button to save the chage you need to add
    • you are indicating to the adapter that need to update all the changes
            adapter.Update(ds, "session");


























Comentarios

Publicar un comentario

Entradas populares de este blog

C# Using tabs

To use tabs in C# use the TabContainer element from AjaxControlToolkit Include AjaxControlToolkit  Include in the Web.config file, inside the tag <system.web> the following code  <pages>       <controls>         <add tagPrefix="ajaxCTK" namespace="AjaxControlToolkit" assembly="AjaxControlToolkit"/>       </controls>     </pages>   Include TabContainer element First  include TabContainer element that is the section where all the tabs will be displayed. <ajaxCTK:TabContainer ID="TabContainerUpdate" runat="server"                 Height="800"                 CssClass="ajax__tab_style"> </ajaxCTK:TabContainer> Second per each tab include the following code corresponding to each ...
Publicar un comentario
Leer más

Python create package

Create a root folder Create a sub-folder "example_pkg" that contains the funtionallity packaging_tutorial/ example_pkg/ __init__.py In the root folder create the following structure  packaging_tutorial/ example_pkg/ __init__.py tests/ setup.py LICENSE README.md in the setup.py contains the configuration of the packages your package is found by find_packages() import setuptools with open ( "README.md" , "r" ) as fh : long_description = fh . read () setuptools . setup ( name = "example-pkg-YOUR-USERNAME-HERE" , # Replace with your own username version = "0.0.1" , author = "Example Author" , author_email = "author@example.com" , description = "A small example package" , long_description = long_description , long_description_content_type = "text/markdown" , url = "https://github.com/pypa/sam...
Publicar un comentario
Leer más

Rails - Basic Steps III

pValidations Validations are a type of ActiveRecord Validations are defined in our models Implement Validations Go to   root_app/app/models Open files  *.rb for each model Mandatory field validates_presence_of   :field Ex:   validates_presence_of    :title Classes The basic syntax is class MyClass        @global_variable                def my_method              @method_variable        end end Create an instance myInstance = MyClass.new Invoke a mehod mc.my_method class() method returns the type of the object In Ruby, last character of method define the behavior If ends with a question -> return a boolean value If ends with an exclamation -> change the state of the object Getter / Setter method def global_variable       return @global_variable end ...
Publicar un comentario
Leer más