tag:blogger.com,1999:blog-3047453204299143917.post5031887450528439444..comments2024-03-27T22:50:35.596-07:00Comments on C#, JAVA,PHP, Programming ,Source Code: C# - How To Create Login Form In C# With MySQL Database1bestCsharp Bloghttp://www.blogger.com/profile/16545655918634138486noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-3047453204299143917.post-30828376669062555102018-05-11T15:28:47.557-07:002018-05-11T15:28:47.557-07:00hi bro .. i need your help about this login please...hi bro .. i need your help about this login pleaseAnonymoushttps://www.blogger.com/profile/08919310090909571905noreply@blogger.comtag:blogger.com,1999:blog-3047453204299143917.post-10273065645907009492017-06-11T03:54:56.999-07:002017-06-11T03:54:56.999-07:00Can anyone help me? I am unable to loginCan anyone help me? I am unable to loginAnonymoushttps://www.blogger.com/profile/14031283782610942531noreply@blogger.comtag:blogger.com,1999:blog-3047453204299143917.post-67088617216978976662017-06-11T03:53:51.254-07:002017-06-11T03:53:51.254-07:00using MySql.Data.MySqlClient;
using System;
using ...using MySql.Data.MySqlClient;<br />using System;<br />using System.Data;<br />using System.Linq;<br />using System.Windows.Forms;<br /><br />namespace LoginForm_PhpMyAdmin<br />{<br /> public partial class Form1 : Form<br /> {<br /> public Form1()<br /> {<br /> MySqlConnection con = new MySqlConnection("datasource=localhost;port=3306;Initial Catalog='visual';username=root;password=root");<br /> con.Open();<br /> InitializeComponent();<br /> }<br /><br /> <br /><br /> private void btnlgn_Click(object sender, EventArgs e)<br /> {<br /><br /> MySqlConnection con = new MySqlConnection("datasource=localhost;port=3306;Initial Catalog='visual';username=root;password=root");<br /> con.Open();<br /> string query = "SELECT * FROM `login` WHERE `Username` = '" + textuser.Text + "' and `Password` = '" + textpswd.Text + "'";<br /><br /> MySqlCommand myCommand = new MySqlCommand(query,con);<br /> MySqlDataAdapter MyAdapter = new MySqlDataAdapter(myCommand);<br /> <br /> DataTable dt = new DataTable();<br /><br /> MyAdapter.Fill(dt);<br /><br /> if (dt.Rows.Count > 0)<br /> {<br /> MessageBox.Show("Login Successful.");<br /> }<br /> else<br /> {<br /> MessageBox.Show("Please Enter Valid Username Or Password!");<br /> }<br /> }<br /> }<br />}<br />Anonymoushttps://www.blogger.com/profile/14031283782610942531noreply@blogger.comtag:blogger.com,1999:blog-3047453204299143917.post-68333493209294844682015-11-08T23:10:40.949-08:002015-11-08T23:10:40.949-08:00try adapter.Fill(table);not fill
and add the conne...try adapter.Fill(table);not fill<br />and add the connection name to the MySqlDataAdapter Constructor adapter = new MySqlDataAdapter("SELECT `username`, `password` FROM `users` WHERE `username` = '"+textBox_Username.Text+"' AND `password` = '"+textBox_Password.Text+"'", connection);1bestCsharp Bloghttps://www.blogger.com/profile/16545655918634138486noreply@blogger.comtag:blogger.com,1999:blog-3047453204299143917.post-45556521049650763252015-11-08T23:04:52.551-08:002015-11-08T23:04:52.551-08:00Hello you could help me in my project? http://prnt...Hello you could help me in my project? http://prntscr.com/90md0ttoniHCKhttps://www.blogger.com/profile/07092425836996053157noreply@blogger.com