Having problem connecting to database

Chidiebere Mgbemena

6y950

Please i need help!!!

What can i do?

my login form is giving error when i try to login after running the application. Below is the

error message:

My source code:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace Sales_Invoice

{

public partial class frmLogin : Form

{

private object txtUserName;

private object txtPassword;

public frmLogin()

{

InitializeComponent();

}

private void label1_Click(object sender, EventArgs e)

{

}

private void btnExit_Click(object sender, EventArgs e)

{

this.Close();

}

private void btnLogin_Click(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection(@"Data Source=ABJ-DEVSVR-01\MINTSQL;Initial Catalog=Contacts;Integrated Security=True");

SqlDataAdapter sda = new SqlDataAdapter("Select Count(*) From Login where Username='" + txtUserName + "' and Password='" + txtPassword + "'", con);

DataTable dt = new DataTable();

sda.Fill(dt);

if (dt.Rows[0][0].ToString() == "1")

{

this.Hide();

Main ss = new Main();

ss.Show();

}

else

{

MessageBox.Show("Please check your Username and Password");

}

private void frmLogin_Load(object sender, EventArgs e)

{

}

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh6y ago
Hi
As said please check you connection strinng. In this you need to check few points

1. Data Source name
2. If data source name is corect on that case check weather yiu are able to connect SQL studio manager by using windows aithentication.
3. If still issue is there then contact to ur DBS

Thanks
0
Jignesh Kumar6y ago
Hi,

As per your error in screen, now you are able to connect to databse but you do not have table name with Login in your database,

check here your table name in your database SalesInvoicemgr do you have table name with login,

first run below query in SQL server if it run successfuly then table is exists in database elase you need to change table name in query as per correct table name,

Select Count(*) From Login
-1
Amit Gupta6y ago
Do check the table name is login (spelling) to which you are accessing
0
Chidiebere Mgbemena6y ago
Thanks everyone for your comment!

@jignesh Kumar i copied and pasted the codes, this is the error message i recieved

Please help
0
Jignesh Kumar6y ago
Hi, You missed to open connection, Please try below code and your datasouce should be instance of sqlserver, privatevoid btnLogin_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=ABJ-DEVSVR-01\MINTSQL;Initial Catalog=Contacts;Integrated Security=True"); con.Open(); SqlDataAdapter sda = new SqlDataAdapter("Select Count(*) From Login where Username='" + txtUserName + "' and Password='" + txtPassword + "'", con); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows[0][0].ToString() == "1") { this.Hide(); Main ss = new Main(); ss.Show(); } else{ MessageBox.Show("Please check your Username and Password"); } }
-1
Ravi Patel6y ago
Hi ,

Check your database connection string.
0
Amit Gupta6y ago
Re check your connection string's DataSource, credentials plus check the service of sql is running
-1