{"id":2086,"date":"2013-10-11T18:09:12","date_gmt":"2013-10-11T21:09:12","guid":{"rendered":"http:\/\/brasilwebhost.blog.br\/?p=2086"},"modified":"2013-10-10T11:11:37","modified_gmt":"2013-10-10T14:11:37","slug":"tutorial-c-insercao-de-dados-em-mysql","status":"publish","type":"post","link":"https:\/\/www.brasilwebhost.com.br\/blog\/tutorial-c-insercao-de-dados-em-mysql\/","title":{"rendered":"Tutorial C# \u2013 Inser\u00e7\u00e3o de dados em MySQL"},"content":{"rendered":"<p>hoje irei mostrar como inserir dados numa base de dados MySQL. Apesar de a liga\u00e7\u00e3o C# \u2013 MySQL n\u00e3o ser a mais utilizada, visto o C# ser uma linguagem mais orientada para o ambiente Windows, e o MySQL orientado para a Web, ir\u00e3o poder verificar que n\u00e3o existe nenhum \u201csegredo\u201d, e \u00e9 at\u00e9 bastante simples a inser\u00e7\u00e3o de dados.<!--more--><\/p>\n<p><a href=\"http:\/\/brasilwebhost.blog.br\/wp-content\/uploads\/2013\/10\/csharp_0.jpg\"><img loading=\"lazy\" class=\"size-full wp-image-2087 alignleft\" alt=\"csharp_0\" src=\"http:\/\/brasilwebhost.blog.br\/wp-content\/uploads\/2013\/10\/csharp_0.jpg\" width=\"347\" height=\"346\" srcset=\"https:\/\/www.brasilwebhost.com.br\/blog\/wp-content\/uploads\/2013\/10\/csharp_0.jpg 347w, https:\/\/www.brasilwebhost.com.br\/blog\/wp-content\/uploads\/2013\/10\/csharp_0-150x150.jpg 150w, https:\/\/www.brasilwebhost.com.br\/blog\/wp-content\/uploads\/2013\/10\/csharp_0-300x300.jpg 300w\" sizes=\"(max-width: 347px) 100vw, 347px\" \/><\/a>Antes de come\u00e7ar a ler este tutorial, \u00e9 muito importante que tenha compreendido o anterior tutorial relacionado com este tema (<a href=\"http:\/\/pplware.sapo.pt\/tutoriais\/tutorial-c-ligacao-a-base-de-dados-mysql\/\" target=\"_blank\">Tutorial C# \u2013 Liga\u00e7\u00e3o a Base de Dados MySQL<\/a>), visto que os primeiros passos s\u00e3o iguais.<\/p>\n<p>Primeiro criamos uma base de dados no\u00a0<strong>phpMyAdmin<\/strong>. Neste caso criei a base de dados com o nome\u00a0<strong>pplware_bd<\/strong>.<\/p>\n<p>Esta base de dados, ter\u00e1 uma tabela com o nome\u00a0<strong>tabela_dados<\/strong>, com tr\u00eas campos:<\/p>\n<ul>\n<li>id (INT (5), AUTO_INCREMENT, Chave Prim\u00e1ria)<\/li>\n<li>titulo (VARCHAR(25))<\/li>\n<li>descricao (VARCHAR(100))<\/li>\n<\/ul>\n<p>Para que seja poss\u00edvel inserir dados numa base de dados MySql em C#, \u00e9 necess\u00e1rio adicionar a refer\u00eancia<strong>MySql.Data<\/strong>. Para isso \u00e9 necess\u00e1rio efectuar o download do\u00a0<a href=\"http:\/\/www.pplware.com\/downloads2010\/software\/mysql-connector-net-6.2.3.rar\">mysql-connector-net-6.2.3<\/a>. Depois \u00e9 s\u00f3 correr o setup. (No fim \u00e9 necess\u00e1rio reiniciar o Visual Studio)<\/p>\n<p><strong>Para adicionar uma refer\u00eancia:<\/strong><\/p>\n<ul>\n<li>Clicar com o bot\u00e3o direito em Refer\u00eancia e fazer \u201cAdd Reference\u201d.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/pplware.sapo.pt\/wp-content\/uploads\/2010\/11\/csharp_1.jpg\" rel=\"lightbox[47120]\"><img loading=\"lazy\" title=\"csharp_1\" alt=\"\" src=\"http:\/\/pplware.sapo.pt\/wp-content\/uploads\/2010\/11\/csharp_1.jpg\" width=\"303\" height=\"218\" \/><\/a><\/p>\n<ul>\n<li>Seleccionar na lista MySql.Data no separador .NET<\/li>\n<\/ul>\n<p><a href=\"http:\/\/pplware.sapo.pt\/wp-content\/uploads\/2010\/11\/csharp_2.jpg\" rel=\"lightbox[47120]\"><img loading=\"lazy\" title=\"csharp_2\" alt=\"\" src=\"http:\/\/pplware.sapo.pt\/wp-content\/uploads\/2010\/11\/csharp_2.jpg\" width=\"500\" height=\"359\" \/><\/a><\/p>\n<ul>\n<li>Como a refer\u00eancia j\u00e1 est\u00e1 adicionada, temos de a inserir no c\u00f3digo.<\/li>\n<\/ul>\n<div>\n<table>\n<tbody>\n<tr>\n<td>\n<pre>using MySql.Data.MySqlClient;<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><strong>Agora vamos ao c\u00f3digo<\/strong><\/p>\n<p><strong>1\u00ba \u2013 Temos de adicionar um MySqlConnection, MySqlDataAdapter e um DataSet.<\/strong><\/p>\n<div>\n<table>\n<tbody>\n<tr>\n<td>\n<pre>private MySqlConnection mConn;\r\nprivate MySqlDataAdapter mAdapter;\r\nprivate DataSet mDataSet;<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>O\u00a0<strong>MySqlConnection<\/strong>,\u00a0<strong>MySqlDataAdapter<\/strong>\u00a0e o\u00a0<strong>DataSet<\/strong>, s\u00e3o necess\u00e1rios para a conex\u00e3o e leitura da base de dados.<\/p>\n<p><strong>2\u00ba \u2013 Criar o \u201clayout\u201d da mini aplica\u00e7\u00e3o.<\/strong><\/p>\n<p><a href=\"http:\/\/pplware.sapo.pt\/wp-content\/uploads\/2010\/11\/csharp_5.jpg\" rel=\"lightbox[47120]\"><img loading=\"lazy\" title=\"csharp_5\" alt=\"\" src=\"http:\/\/pplware.sapo.pt\/wp-content\/uploads\/2010\/11\/csharp_5.jpg\" width=\"373\" height=\"518\" \/><\/a><\/p>\n<p><strong>3\u00ba \u2013 C\u00f3digo do bot\u00e3o \u201cGravar\u201d<\/strong><\/p>\n<div>\n<table>\n<tbody>\n<tr>\n<td>\n<pre>private void bt_Gravar_Click(object sender, EventArgs e)\r\n{\r\n\t\/\/ In\u00edcio da Conex\u00e3o com indica\u00e7\u00e3o de qual o servidor, nome de base de dados e utilizar\r\n\r\n\t\/* \u00c9 aconselh\u00e1vel criar um utilizador com password. Para acrescentar a password \u00e9 somente\r\n\tnecess\u00e1rio acrescentar o seguinte c\u00f3digo a seguir ao uid=root;password=xxxxx*\/\r\n\r\n\tmConn = new MySqlConnection(\"Persist Security Info=False; server=localhost;database=pplware_bd;uid=root\");\r\n\r\n\t\/\/ Abre a conex\u00e3o\r\n\tmConn.Open();\r\n\r\n\t\/\/Query SQL\r\n\tMySqlCommand command = new MySqlCommand(\"INSERT INTO tabela_dados (titulo,descricao)\"+\r\n\t\"VALUES('\" + tb_titulo.Text + \"','\" + tb_descricao.Text + \"')\", mConn);\r\n\r\n\t\/\/Executa a Query SQL\r\n\tcommand.ExecuteNonQuery();\r\n\r\n\t\/\/ Fecha a conex\u00e3o\r\n\tmConn.Close();\r\n\r\n\t\/\/Mensagem de Sucesso\r\n\tMessageBox.Show(\"Gravado com Sucesso!\",\"Informa\u00e7\u00e3o\",MessageBoxButtons.OK,MessageBoxIcon.Information);\r\n\r\n\t\/\/ M\u00e9todo criado para que quando o registo \u00e9 gravado, automaticamente a dataGridView efectue um \"Refresh\"\r\n\tmostraResultados();\r\n}<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><strong>4\u00ba \u2013 C\u00f3digo do m\u00e9todo de visualiza\u00e7\u00e3o de dados<\/strong><\/p>\n<div>\n<table>\n<tbody>\n<tr>\n<td>\n<pre>private void mostraResultados()\r\n{\r\n\tmDataSet = new DataSet();\r\n\tmConn = new MySqlConnection(\"Persist Security Info=False; server=localhost;database=pplware_bd;uid=root\");\r\n    mConn.Open();\r\n\r\n    \/\/cria um adapter utilizando a instru\u00e7\u00e3o SQL para aceder \u00e0 tabela\r\n    mAdapter = new MySqlDataAdapter(\"SELECT * FROM tabela_dados ORDER BY id\", mConn);\r\n\r\n    \/\/preenche o dataset atrav\u00e9s do adapter\r\n    mAdapter.Fill(mDataSet, \"tabela_dados\");\r\n\r\n    \/\/atribui o resultado \u00e0 propriedade DataSource da dataGridView\r\n    dataGridView1.DataSource = mDataSet;\r\n    dataGridView1.DataMember = \"tabela_dados\";\r\n}<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Este m\u00e9todo ser\u00e1 \u201cchamado\u201d no bot\u00e3o Visualizar, como exemplificado na imagem abaixo.<\/p>\n<div>\n<table>\n<tbody>\n<tr>\n<td>\n<pre>private void bt_visualizar_Click(object sender, EventArgs e)\r\n{\r\n\tmostraResultados();\r\n}<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><strong>E o resultado ser\u00e1:<\/strong><\/p>\n<p><a href=\"http:\/\/pplware.sapo.pt\/wp-content\/uploads\/2010\/11\/csharp_9.jpg\" rel=\"lightbox[47120]\"><img loading=\"lazy\" title=\"csharp_9\" alt=\"\" src=\"http:\/\/pplware.sapo.pt\/wp-content\/uploads\/2010\/11\/csharp_9.jpg\" width=\"373\" height=\"518\" \/><\/a><\/p>\n<p><a href=\"http:\/\/pplware.sapo.pt\/wp-content\/uploads\/2010\/11\/csharp_10.jpg\" rel=\"lightbox[47120]\"><img loading=\"lazy\" title=\"csharp_10\" alt=\"\" src=\"http:\/\/pplware.sapo.pt\/wp-content\/uploads\/2010\/11\/csharp_10.jpg\" width=\"371\" height=\"517\" \/><\/a><\/p>\n<p>E assim finalizamos este tutorial.<\/p>\n<p>Como certamente verificaram, \u00e9 extremamente simples fazer uma liga\u00e7\u00e3o e inser\u00e7\u00e3o com MySQL utilizando C#.<br \/>\nEspero que tenham gostado.<\/p>\n<p><img loading=\"lazy\" alt=\"\" src=\"http:\/\/pplware.sapo.pt\/wp-content\/images\/ico_03.jpg\" width=\"32\" height=\"35\" \/>Download:\u00a0<a href=\"http:\/\/www.pplware.com\/downloads2010\/software\/mysql-connector-net-6.2.3.rar\">Mysql Connector Net (6.2.3)<\/a><br \/>\n<img loading=\"lazy\" alt=\"\" src=\"http:\/\/pplware.sapo.pt\/wp-content\/images\/ico_04.jpg\" width=\"32\" height=\"35\" \/>\u00a0Homepage:\u00a0<a href=\"http:\/\/www.mysql.com\/downloads\/connector\/net\/6.2.html\" target=\"_blank\">MySql<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Via <a href=\"http:\/\/pplware.sapo.pt\/tutoriais\/tutorial-c-%E2%80%93-insercao-de-dados-em-mysql\/\">PPLWare<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>hoje irei mostrar como inserir dados numa base de dados MySQL. Apesar de a liga\u00e7\u00e3o C# \u2013 MySQL n\u00e3o ser a mais utilizada, visto o C# ser uma linguagem mais orientada para o ambiente Windows, e o MySQL orientado para a Web, ir\u00e3o poder verificar que n\u00e3o existe nenhum \u201csegredo\u201d,&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[10],"tags":[419,526,182],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tutorial C# \u2013 Inser\u00e7\u00e3o de dados em MySQL | Blog - Brasil Web Host<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.brasilwebhost.com.br\/blog\/tutorial-c-insercao-de-dados-em-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tutorial C# \u2013 Inser\u00e7\u00e3o de dados em MySQL | Blog - Brasil Web Host\" \/>\n<meta property=\"og:description\" content=\"hoje irei mostrar como inserir dados numa base de dados MySQL. Apesar de a liga\u00e7\u00e3o C# \u2013 MySQL n\u00e3o ser a mais utilizada, visto o C# ser uma linguagem mais orientada para o ambiente Windows, e o MySQL orientado para a Web, ir\u00e3o poder verificar que n\u00e3o existe nenhum \u201csegredo\u201d,&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.brasilwebhost.com.br\/blog\/tutorial-c-insercao-de-dados-em-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Brasil Web Host\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/brasilwebhost\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-11T21:09:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-10-10T14:11:37+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/brasilwebhost.blog.br\/wp-content\/uploads\/2013\/10\/csharp_0.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@brasilwebhost\" \/>\n<meta name=\"twitter:site\" content=\"@brasilwebhost\" \/>\n<meta name=\"twitter:label1\" value=\"Written by\">\n\t<meta name=\"twitter:data1\" value=\"Caio Zanzarini\">\n\t<meta name=\"twitter:label2\" value=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" value=\"2 minutos\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/#organization\",\"name\":\"Brasil Web Host\",\"url\":\"https:\/\/www.brasilwebhost.com.br\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/brasilwebhost\/\",\"https:\/\/www.instagram.com\/brasilwebhost\/\",\"https:\/\/www.linkedin.com\/company\/35638258\/admin\/\",\"https:\/\/www.youtube.com\/user\/brasilwebhost\",\"https:\/\/br.pinterest.com\/empresabwh\/\",\"https:\/\/twitter.com\/brasilwebhost\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/#logo\",\"inLanguage\":\"pt-BR\",\"url\":\"https:\/\/www.brasilwebhost.com.br\/blog\/wp-content\/uploads\/2019\/09\/logo.png\",\"width\":330,\"height\":54,\"caption\":\"Brasil Web Host\"},\"image\":{\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/#website\",\"url\":\"https:\/\/www.brasilwebhost.com.br\/blog\/\",\"name\":\"Blog - Brasil Web Host\",\"description\":\"Conhe\\u00e7a as vantagens de ser nosso cliente e usufruir do melhor atendimento.\",\"publisher\":{\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.brasilwebhost.com.br\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/tutorial-c-insercao-de-dados-em-mysql\/#primaryimage\",\"inLanguage\":\"pt-BR\",\"url\":\"http:\/\/brasilwebhost.blog.br\/wp-content\/uploads\/2013\/10\/csharp_0.jpg\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/tutorial-c-insercao-de-dados-em-mysql\/#webpage\",\"url\":\"https:\/\/www.brasilwebhost.com.br\/blog\/tutorial-c-insercao-de-dados-em-mysql\/\",\"name\":\"Tutorial C# \\u2013 Inser\\u00e7\\u00e3o de dados em MySQL | Blog - Brasil Web Host\",\"isPartOf\":{\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/tutorial-c-insercao-de-dados-em-mysql\/#primaryimage\"},\"datePublished\":\"2013-10-11T21:09:12+00:00\",\"dateModified\":\"2013-10-10T14:11:37+00:00\",\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.brasilwebhost.com.br\/blog\/tutorial-c-insercao-de-dados-em-mysql\/\"]}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/tutorial-c-insercao-de-dados-em-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/tutorial-c-insercao-de-dados-em-mysql\/#webpage\"},\"author\":{\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/#\/schema\/person\/2fcc3074bb781735dca2c69b3ba73a71\"},\"headline\":\"Tutorial C# \\u2013 Inser\\u00e7\\u00e3o de dados em MySQL\",\"datePublished\":\"2013-10-11T21:09:12+00:00\",\"dateModified\":\"2013-10-10T14:11:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/tutorial-c-insercao-de-dados-em-mysql\/#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/tutorial-c-insercao-de-dados-em-mysql\/#primaryimage\"},\"keywords\":\"Banco de dados,c#,mysql\",\"articleSection\":\"Dicas\",\"inLanguage\":\"pt-BR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/#\/schema\/person\/2fcc3074bb781735dca2c69b3ba73a71\",\"name\":\"Caio Zanzarini\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.brasilwebhost.com.br\/blog\/#personlogo\",\"inLanguage\":\"pt-BR\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7df2c531eec13be1ed30a226f612eaa0?s=96&d=mm&r=g\",\"caption\":\"Caio Zanzarini\"},\"description\":\"Gerente administrativo e s\\u00f3cio-propriet\\u00e1rio da Brasil Web Host.\",\"sameAs\":[\"http:\/\/www.brasilwebhost.com.br\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.brasilwebhost.com.br\/blog\/wp-json\/wp\/v2\/posts\/2086"}],"collection":[{"href":"https:\/\/www.brasilwebhost.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.brasilwebhost.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.brasilwebhost.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.brasilwebhost.com.br\/blog\/wp-json\/wp\/v2\/comments?post=2086"}],"version-history":[{"count":1,"href":"https:\/\/www.brasilwebhost.com.br\/blog\/wp-json\/wp\/v2\/posts\/2086\/revisions"}],"predecessor-version":[{"id":2088,"href":"https:\/\/www.brasilwebhost.com.br\/blog\/wp-json\/wp\/v2\/posts\/2086\/revisions\/2088"}],"wp:attachment":[{"href":"https:\/\/www.brasilwebhost.com.br\/blog\/wp-json\/wp\/v2\/media?parent=2086"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.brasilwebhost.com.br\/blog\/wp-json\/wp\/v2\/categories?post=2086"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.brasilwebhost.com.br\/blog\/wp-json\/wp\/v2\/tags?post=2086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}