// API callback
leerpostetiquetas({"version":"1.0","encoding":"UTF-8","feed":{"xmlns":"http://www.w3.org/2005/Atom","xmlns$openSearch":"http://a9.com/-/spec/opensearchrss/1.0/","xmlns$blogger":"http://schemas.google.com/blogger/2008","xmlns$georss":"http://www.georss.org/georss","xmlns$gd":"http://schemas.google.com/g/2005","xmlns$thr":"http://purl.org/syndication/thread/1.0","id":{"$t":"tag:blogger.com,1999:blog-9172140862204193875"},"updated":{"$t":"2023-12-01T01:34:11.391-06:00"},"category":[{"term":"Videotutoriales"},{"term":"Windows"},{"term":"Programas"},{"term":"Windows 8"},{"term":"Windows 7"},{"term":"Electrónica"},{"term":"C Sharp"},{"term":"Programación"},{"term":"Tutoriales"},{"term":"Arduino"},{"term":"Hardware"},{"term":"Curso Aprender a Formatear e instalar Windows"},{"term":"Cursos"},{"term":"Photoshop"},{"term":"Cinema 4D"},{"term":"Teoría"},{"term":"Base de datos"},{"term":"Blogger"},{"term":"Descargas"},{"term":"IPod Touch"},{"term":"Revisiones"}],"title":{"type":"text","$t":"J E Tutoriales"},"subtitle":{"type":"html","$t":""},"link":[{"rel":"http://schemas.google.com/g/2005#feed","type":"application/atom+xml","href":"https:\/\/www.tutorialesje.com\/feeds\/posts\/default"},{"rel":"self","type":"application/atom+xml","href":"https:\/\/www.blogger.com\/feeds\/9172140862204193875\/posts\/default\/-\/Base+de+datos?alt=json-in-script\u0026max-results=50"},{"rel":"alternate","type":"text/html","href":"https:\/\/www.tutorialesje.com\/search\/label\/Base%20de%20datos"},{"rel":"hub","href":"http://pubsubhubbub.appspot.com/"}],"author":[{"name":{"$t":"Jeovani Martinez"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/06991244172484822798"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"32","src":"\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEhs7BwcUJ8SHvIPEBaEx6nhIpCBwTgwHNlWS5ojiPZvHF1qNRxAi5gBCH8YKPdIRp7fjym9vpjZ70kTyxGysy13AXcIOC3bmPEjJGuft6taCCeVr7eZ7vSOlr57jjabyQ\/s126\/Nueva+imagen.jpg"}}],"generator":{"version":"7.00","uri":"http://www.blogger.com","$t":"Blogger"},"openSearch$totalResults":{"$t":"1"},"openSearch$startIndex":{"$t":"1"},"openSearch$itemsPerPage":{"$t":"50"},"entry":[{"id":{"$t":"tag:blogger.com,1999:blog-9172140862204193875.post-7154913398895431177"},"published":{"$t":"2017-04-24T18:57:00.002-05:00"},"updated":{"$t":"2017-04-24T18:58:48.641-05:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Base de datos"},{"scheme":"http://www.blogger.com/atom/ns#","term":"C Sharp"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Programación"}],"title":{"type":"text","$t":"Inicio de Sesión (Login) con C Sharp y SQL Server"},"content":{"type":"html","$t":"\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\n\u003Ca href=\"https:\/\/2.bp.blogspot.com\/-qM6X64bHvcE\/WP6BJaGciGI\/AAAAAAAAA1o\/JIxqxAuFQCo7KDLb6gi0tOzaAsQpbWk3gCLcB\/s1600\/Imagen.png\" imageanchor=\"1\" style=\"clear: left; float: left; margin-bottom: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" height=\"360\" src=\"https:\/\/2.bp.blogspot.com\/-qM6X64bHvcE\/WP6BJaGciGI\/AAAAAAAAA1o\/JIxqxAuFQCo7KDLb6gi0tOzaAsQpbWk3gCLcB\/s640\/Imagen.png\" width=\"640\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cspan style=\"text-align: justify;\"\u003EUn tutorial sobre cómo desarrollar una aplicación en Visual Studio con el lenguaje de programación C Sharp que permita iniciar sesión e identificar al tipo de usuario en una base de datos, utilizando el sistema de bases de datos Microsoft SQL Server.\u003C\/span\u003E\u003Cbr \/\u003E\n\u003Cspan style=\"text-align: justify;\"\u003E\u003Cbr \/\u003E\u003C\/span\u003E\n\u003Cbr \/\u003E\n\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\n\u003Ciframe allowfullscreen=\"\" class=\"YOUTUBE-iframe-video\" data-thumbnail-src=\"https:\/\/i.ytimg.com\/vi\/TrWxfcp4UgI\/0.jpg\" frameborder=\"0\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/TrWxfcp4UgI?feature=player_embedded\" width=\"640\"\u003E\u003C\/iframe\u003E\u003C\/div\u003E\n\u003Cbr \/\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"text-align: center;\"\u003E\n\u003Cb\u003E\u003Cspan style=\"font-size: large;\"\u003ECódigo Fuente\u0026nbsp;\u003C\/span\u003E\u003C\/b\u003E\u003Cbr \/\u003E\n\u003Cb\u003E\u003Cspan style=\"font-size: large;\"\u003E\u003Cbr \/\u003E\n\u003C\/span\u003E\u003C\/b\u003E \u003Cb\u003E\u003Cspan style=\"font-size: large;\"\u003EScript Base de Datos\u003C\/span\u003E\u003C\/b\u003E\u003C\/div\u003E\n\u003Cdiv style=\"background: #ffffff; border-width: 0.1em 0.1em 0.1em 0.8em; border: solid gray; overflow: auto; padding: 0.2em 0.6em; width: auto;\"\u003E\n\u003Ctable\u003E\u003Ctbody\u003E\n\u003Ctr\u003E\u003Ctd\u003E\u003Cpre style=\"line-height: 125%; margin: 0;\"\u003E1\n 2\n 3\n 4\n 5\n 6\n 7\n 8\n 9\n10\n11\n12\n13\n14\n15\n16\n17\u003C\/pre\u003E\n\u003C\/td\u003E\u003Ctd\u003E\u003Cpre style=\"line-height: 125%; margin: 0;\"\u003EUSE master\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003ECREATE\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003EDATABASE\u003C\/span\u003E escuela\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003EGO\u003C\/span\u003E\nUSE escuela\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003ECREATE\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003ETABLE\u003C\/span\u003E usuario\n(\nnombreUsuario nvarchar(\u003Cspan style=\"color: #0000dd; font-weight: bold;\"\u003E20\u003C\/span\u003E) \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003EPRIMARY\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003EKEY\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enot\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enull\u003C\/span\u003E,\ncontrasena nvarchar(\u003Cspan style=\"color: #0000dd; font-weight: bold;\"\u003E20\u003C\/span\u003E) \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enot\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enull\u003C\/span\u003E,\nnombre nvarchar(\u003Cspan style=\"color: #0000dd; font-weight: bold;\"\u003E50\u003C\/span\u003E) \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enot\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enull\u003C\/span\u003E,\napellidoPaterno nvarchar(\u003Cspan style=\"color: #0000dd; font-weight: bold;\"\u003E50\u003C\/span\u003E) \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enot\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enull\u003C\/span\u003E,\napellidoMaterno nvarchar(\u003Cspan style=\"color: #0000dd; font-weight: bold;\"\u003E50\u003C\/span\u003E),\ntipoUsuario nvarchar(\u003Cspan style=\"color: #0000dd; font-weight: bold;\"\u003E20\u003C\/span\u003E) \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enot\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enull\u003C\/span\u003E\n)\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003EGO\u003C\/span\u003E\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003EINSERT\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003EINTO\u003C\/span\u003E usuario \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003EVALUES\u003C\/span\u003E(\u003Cspan style=\"background-color: #fff0f0;\"\u003E'jesus'\u003C\/span\u003E, \u003Cspan style=\"background-color: #fff0f0;\"\u003E'123A'\u003C\/span\u003E, \u003Cspan style=\"background-color: #fff0f0;\"\u003E'Jesús'\u003C\/span\u003E, \u003Cspan style=\"background-color: #fff0f0;\"\u003E'Morales'\u003C\/span\u003E, \u003Cspan style=\"background-color: #fff0f0;\"\u003E'Campos'\u003C\/span\u003E, \u003Cspan style=\"background-color: #fff0f0;\"\u003E'Administrador'\u003C\/span\u003E)\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003EINSERT\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003EINTO\u003C\/span\u003E usuario \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003EVALUES\u003C\/span\u003E(\u003Cspan style=\"background-color: #fff0f0;\"\u003E'roberto'\u003C\/span\u003E, \u003Cspan style=\"background-color: #fff0f0;\"\u003E'123456'\u003C\/span\u003E, \u003Cspan style=\"background-color: #fff0f0;\"\u003E'Roberto'\u003C\/span\u003E, \u003Cspan style=\"background-color: #fff0f0;\"\u003E'Castro'\u003C\/span\u003E, \u003Cspan style=\"background-color: #fff0f0;\"\u003E'Morales'\u003C\/span\u003E, \u003Cspan style=\"background-color: #fff0f0;\"\u003E'Profesor'\u003C\/span\u003E)\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003EGO\u003C\/span\u003E\n\u003C\/pre\u003E\n\u003C\/td\u003E\u003C\/tr\u003E\n\u003C\/tbody\u003E\u003C\/table\u003E\n\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"text-align: center;\"\u003E\n\u003Cb\u003E\u003Cspan style=\"font-size: large;\"\u003E\u003Cbr \/\u003E\n\u003C\/span\u003E\u003C\/b\u003E \u003Cb\u003E\u003Cspan style=\"font-size: large;\"\u003EClase BaseDatos.cs\u003C\/span\u003E\u003C\/b\u003E\u003C\/div\u003E\n\u003Cdiv style=\"background: #ffffff; border-width: 0.1em 0.1em 0.1em 0.8em; border: solid gray; overflow: auto; padding: 0.2em 0.6em; width: auto;\"\u003E\n\u003Ctable\u003E\u003Ctbody\u003E\n\u003Ctr\u003E\u003Ctd\u003E\u003Cpre style=\"line-height: 125%; margin: 0;\"\u003E1\n 2\n 3\n 4\n 5\n 6\n 7\n 8\n 9\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n24\n25\n26\n27\n28\n29\n30\n31\n32\n33\n34\n35\n36\n37\n38\n39\n40\n41\n42\n43\n44\n45\n46\n47\n48\n49\n50\n51\n52\n53\u003C\/pre\u003E\n\u003C\/td\u003E\u003Ctd\u003E\u003Cpre style=\"line-height: 125%; margin: 0;\"\u003E\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Collections.Generic\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Linq\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Text\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Threading.Tasks\u003C\/span\u003E;\n\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Data.SqlClient\u003C\/span\u003E;\n\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enamespace\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003EInicioSesion\u003C\/span\u003E\n{\n    \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eclass\u003C\/span\u003E \u003Cspan style=\"color: #bb0066; font-weight: bold;\"\u003EBaseDatos\u003C\/span\u003E\n    {\n        \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eprivate\u003C\/span\u003E \u003Cspan style=\"color: #333399; font-weight: bold;\"\u003Estring\u003C\/span\u003E cadenaConexion = \u003Cspan style=\"background-color: #fff0f0;\"\u003E\"Data Source=JEOVANI-PC; Initial Catalog=escuela; Integrated Security=true;\"\u003C\/span\u003E;\n\n        \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Epublic\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Estatic\u003C\/span\u003E \u003Cspan style=\"color: #333399; font-weight: bold;\"\u003Estring\u003C\/span\u003E nombreCompleto = \u003Cspan style=\"background-color: #fff0f0;\"\u003E\"\"\u003C\/span\u003E;\n        \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Epublic\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Estatic\u003C\/span\u003E \u003Cspan style=\"color: #333399; font-weight: bold;\"\u003Estring\u003C\/span\u003E tipoUsuario = \u003Cspan style=\"background-color: #fff0f0;\"\u003E\"\"\u003C\/span\u003E;\n\n        \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Epublic\u003C\/span\u003E Boolean \u003Cspan style=\"color: #0066bb; font-weight: bold;\"\u003EiniciarSesion\u003C\/span\u003E(\u003Cspan style=\"color: #333399; font-weight: bold;\"\u003Estring\u003C\/span\u003E nomus, \u003Cspan style=\"color: #333399; font-weight: bold;\"\u003Estring\u003C\/span\u003E con)\n        {\n            nombreCompleto = \u003Cspan style=\"background-color: #fff0f0;\"\u003E\"\"\u003C\/span\u003E;\n            tipoUsuario = \u003Cspan style=\"background-color: #fff0f0;\"\u003E\"\"\u003C\/span\u003E;\n\n            SqlConnection conexion = \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enew\u003C\/span\u003E SqlConnection(cadenaConexion);\n            conexion.Open();\n\n            SqlParameter parnomus = \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enew\u003C\/span\u003E SqlParameter(\u003Cspan style=\"background-color: #fff0f0;\"\u003E\"@nomus\"\u003C\/span\u003E, nomus);\n            SqlParameter parcon = \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enew\u003C\/span\u003E SqlParameter(\u003Cspan style=\"background-color: #fff0f0;\"\u003E\"@con\"\u003C\/span\u003E, con);\n\n            SqlCommand comando = \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enew\u003C\/span\u003E SqlCommand(\u003Cspan style=\"background-color: #fff0f0;\"\u003E\"SELECT nombre, apellidoPaterno, apellidoMaterno, tipoUsuario FROM usuario WHERE nombreUsuario = @nomus AND contrasena COLLATE Latin1_General_CS_AS = @con\"\u003C\/span\u003E, conexion);\n            comando.Parameters.Add(parnomus);\n            comando.Parameters.Add(parcon);\n\n            SqlDataReader lector = comando.ExecuteReader();\n            \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Ewhile\u003C\/span\u003E (lector.Read())\n            {\n                nombreCompleto = lector.GetString(\u003Cspan style=\"color: #6600ee; font-weight: bold;\"\u003E0\u003C\/span\u003E) + \u003Cspan style=\"background-color: #fff0f0;\"\u003E\" \"\u003C\/span\u003E + lector.GetString(\u003Cspan style=\"color: #6600ee; font-weight: bold;\"\u003E1\u003C\/span\u003E) + \u003Cspan style=\"background-color: #fff0f0;\"\u003E\" \"\u003C\/span\u003E + lector.GetString(\u003Cspan style=\"color: #6600ee; font-weight: bold;\"\u003E2\u003C\/span\u003E);\n                tipoUsuario = lector.GetString(\u003Cspan style=\"color: #6600ee; font-weight: bold;\"\u003E3\u003C\/span\u003E);\n            }\n\n            lector.Close();\n            conexion.Close();\n\n            \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eif\u003C\/span\u003E (String.IsNullOrEmpty(tipoUsuario))\n            {\n                \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Ereturn\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Efalse\u003C\/span\u003E;\n            }\n            \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eelse\u003C\/span\u003E\n            {\n                \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Ereturn\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Etrue\u003C\/span\u003E;\n            }\n        }\n    }\n}\n\u003C\/pre\u003E\n\u003C\/td\u003E\u003C\/tr\u003E\n\u003C\/tbody\u003E\u003C\/table\u003E\n\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"text-align: center;\"\u003E\n\u003Cb\u003E\u003Cspan style=\"font-size: large;\"\u003E\u003Cbr \/\u003E\n\u003C\/span\u003E\u003C\/b\u003E \u003Cb\u003E\u003Cspan style=\"font-size: large;\"\u003EForm1.cs\u003C\/span\u003E\u003C\/b\u003E\u003C\/div\u003E\n\u003Cdiv style=\"background: #ffffff; border-width: 0.1em 0.1em 0.1em 0.8em; border: solid gray; overflow: auto; padding: 0.2em 0.6em; width: auto;\"\u003E\n\u003Ctable\u003E\u003Ctbody\u003E\n\u003Ctr\u003E\u003Ctd\u003E\u003Cpre style=\"line-height: 125%; margin: 0;\"\u003E1\n 2\n 3\n 4\n 5\n 6\n 7\n 8\n 9\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n24\n25\n26\n27\n28\n29\n30\n31\n32\n33\n34\n35\n36\n37\n38\n39\n40\n41\n42\n43\n44\n45\n46\n47\n48\n49\n50\n51\n52\u003C\/pre\u003E\n\u003C\/td\u003E\u003Ctd\u003E\u003Cpre style=\"line-height: 125%; margin: 0;\"\u003E\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Collections.Generic\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.ComponentModel\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Data\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Drawing\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Linq\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Text\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Threading.Tasks\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Windows.Forms\u003C\/span\u003E;\n\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enamespace\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003EInicioSesion\u003C\/span\u003E\n{\n    \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Epublic\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Epartial\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eclass\u003C\/span\u003E \u003Cspan style=\"color: #bb0066; font-weight: bold;\"\u003EForm1\u003C\/span\u003E : Form\n    {\n        \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Epublic\u003C\/span\u003E \u003Cspan style=\"color: #0066bb; font-weight: bold;\"\u003EForm1\u003C\/span\u003E()\n        {\n            InitializeComponent();\n        }\n\n        \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eprivate\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Evoid\u003C\/span\u003E \u003Cspan style=\"color: #0066bb; font-weight: bold;\"\u003Ebtiniciarsesion_Click\u003C\/span\u003E(\u003Cspan style=\"color: #333399; font-weight: bold;\"\u003Eobject\u003C\/span\u003E sender, EventArgs e)\n        {\n            \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eif\u003C\/span\u003E (!String.IsNullOrEmpty(tbnombreusuario.Text) \u0026amp;\u0026amp; !String.IsNullOrEmpty(tbcontrasena.Text))\n            {\n                \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Etry\u003C\/span\u003E\n                {\n                    BaseDatos bd = \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enew\u003C\/span\u003E BaseDatos();\n\n                    Boolean res = bd.iniciarSesion(tbnombreusuario.Text, tbcontrasena.Text);\n\n                    \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eif\u003C\/span\u003E (res)\n                    {\n                        Principal p = \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enew\u003C\/span\u003E Principal();\n                        p.Show();\n                        \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Ethis\u003C\/span\u003E.Hide();\n                    }\n                    \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eelse\u003C\/span\u003E\n                    {\n                        MessageBox.Show(\u003Cspan style=\"background-color: #fff0f0;\"\u003E\"Datos Incorrectos\"\u003C\/span\u003E);\n                    }\n                }\n                \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Ecatch\u003C\/span\u003E\n                {\n                    MessageBox.Show(\u003Cspan style=\"background-color: #fff0f0;\"\u003E\"Error\"\u003C\/span\u003E);\n                }\n            }\n            \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eelse\u003C\/span\u003E\n            {\n                MessageBox.Show(\u003Cspan style=\"background-color: #fff0f0;\"\u003E\"Complete los datos\"\u003C\/span\u003E);\n            }\n        }\n    }\n}\n\u003C\/pre\u003E\n\u003C\/td\u003E\u003C\/tr\u003E\n\u003C\/tbody\u003E\u003C\/table\u003E\n\u003C\/div\u003E\n\u003Cbr \/\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"text-align: center;\"\u003E\n\u003Cb\u003E\u003Cspan style=\"font-size: large;\"\u003EPrincipal.cs\u003C\/span\u003E\u003C\/b\u003E\u003C\/div\u003E\n\u003Cdiv style=\"background: #ffffff; border-width: 0.1em 0.1em 0.1em 0.8em; border: solid gray; overflow: auto; padding: 0.2em 0.6em; width: auto;\"\u003E\n\u003Ctable\u003E\u003Ctbody\u003E\n\u003Ctr\u003E\u003Ctd\u003E\u003Cpre style=\"line-height: 125%; margin: 0;\"\u003E1\n 2\n 3\n 4\n 5\n 6\n 7\n 8\n 9\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n24\n25\n26\n27\n28\n29\n30\n31\n32\n33\n34\n35\n36\n37\n38\n39\n40\u003C\/pre\u003E\n\u003C\/td\u003E\u003Ctd\u003E\u003Cpre style=\"line-height: 125%; margin: 0;\"\u003E\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Collections.Generic\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.ComponentModel\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Data\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Drawing\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Linq\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Text\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Threading.Tasks\u003C\/span\u003E;\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eusing\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003ESystem.Windows.Forms\u003C\/span\u003E;\n\n\u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Enamespace\u003C\/span\u003E \u003Cspan style=\"color: #0e84b5; font-weight: bold;\"\u003EInicioSesion\u003C\/span\u003E\n{\n    \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Epublic\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Epartial\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eclass\u003C\/span\u003E \u003Cspan style=\"color: #bb0066; font-weight: bold;\"\u003EPrincipal\u003C\/span\u003E : Form\n    {\n        \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Epublic\u003C\/span\u003E \u003Cspan style=\"color: #0066bb; font-weight: bold;\"\u003EPrincipal\u003C\/span\u003E()\n        {\n            InitializeComponent();\n\n            labelusuario.Text = BaseDatos.nombreCompleto;\n\n            \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eif\u003C\/span\u003E (BaseDatos.tipoUsuario == \u003Cspan style=\"background-color: #fff0f0;\"\u003E\"Administrador\"\u003C\/span\u003E)\n            {\n                paneladministrador.Visible = \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Etrue\u003C\/span\u003E;\n                panelprofesor.Visible = \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Efalse\u003C\/span\u003E;\n\n            }\n            \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eelse\u003C\/span\u003E \u003Cspan style=\"color: #0066bb; font-weight: bold;\"\u003Eif\u003C\/span\u003E (BaseDatos.tipoUsuario == \u003Cspan style=\"background-color: #fff0f0;\"\u003E\"Profesor\"\u003C\/span\u003E)\n            {\n                paneladministrador.Visible = \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Efalse\u003C\/span\u003E;\n                panelprofesor.Visible = \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Etrue\u003C\/span\u003E;\n            }\n\n        }\n\n        \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Eprivate\u003C\/span\u003E \u003Cspan style=\"color: #008800; font-weight: bold;\"\u003Evoid\u003C\/span\u003E \u003Cspan style=\"color: #0066bb; font-weight: bold;\"\u003EPrincipal_FormClosed\u003C\/span\u003E(\u003Cspan style=\"color: #333399; font-weight: bold;\"\u003Eobject\u003C\/span\u003E sender, FormClosedEventArgs e)\n        {\n            Application.Exit();\n        }\n    }\n}\n\u003C\/pre\u003E\n\u003C\/td\u003E\u003C\/tr\u003E\n\u003C\/tbody\u003E\u003C\/table\u003E\n\u003C\/div\u003E\n\u003Cbr \/\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"https:\/\/www.tutorialesje.com\/feeds\/7154913398895431177\/comments\/default","title":"Enviar comentarios"},{"rel":"replies","type":"text/html","href":"https:\/\/www.tutorialesje.com\/2017\/04\/inicio-de-sesion-login-con-c-y-sql.html#comment-form","title":"1 comentarios"},{"rel":"edit","type":"application/atom+xml","href":"https:\/\/www.blogger.com\/feeds\/9172140862204193875\/posts\/default\/7154913398895431177"},{"rel":"self","type":"application/atom+xml","href":"https:\/\/www.blogger.com\/feeds\/9172140862204193875\/posts\/default\/7154913398895431177"},{"rel":"alternate","type":"text/html","href":"https:\/\/www.tutorialesje.com\/2017\/04\/inicio-de-sesion-login-con-c-y-sql.html","title":"Inicio de Sesión (Login) con C Sharp y SQL Server"}],"author":[{"name":{"$t":"Jeovani Martinez"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/06991244172484822798"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"32","src":"\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEhs7BwcUJ8SHvIPEBaEx6nhIpCBwTgwHNlWS5ojiPZvHF1qNRxAi5gBCH8YKPdIRp7fjym9vpjZ70kTyxGysy13AXcIOC3bmPEjJGuft6taCCeVr7eZ7vSOlr57jjabyQ\/s126\/Nueva+imagen.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"https:\/\/2.bp.blogspot.com\/-qM6X64bHvcE\/WP6BJaGciGI\/AAAAAAAAA1o\/JIxqxAuFQCo7KDLb6gi0tOzaAsQpbWk3gCLcB\/s72-c\/Imagen.png","height":"72","width":"72"},"thr$total":{"$t":"1"}}]}});