TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Raunaq Seth
NA
1
1.3k
problem in db connectionusing System; using System.Collectio
Jun 17 2014 8:15 AM
this is my login page and its showing error in connecting to db and can you also help me out if i can user same login for admin and user using a reader
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;
using System.Data.SqlTypes;
namespace Gateway_Security_System_and_Logs
{
public partial class bsl_login : Form
{
public bsl_login()
{
InitializeComponent();
}
private void label1_Click(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
textBox2.Clear();
textBox1.Focus();
}
private void button1_Click(object sender, EventArgs e)
{
string userName = textBox1.Text;
string Pass = textBox2.Text;
if (userName == "" && Pass == "")
{
MessageBox.Show("Please Enter Login Id and Password");
}
else
{
SqlConnection con = new SqlConnection(@"server=.\SQLEXPRESS ; database=bsl_login; Trusted_Connection=yes");
string query = "userlogin"; //stored Procedure Name
SqlCommand com = new SqlCommand(query, con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Usename", userName);
com.Parameters.AddWithValue("@Pass", Pass);
con.Open();
int usercount = (Int32)com.ExecuteScalar();
if (usercount == 1) //if user credential is matched then Usercount value is 1 otherwise it is 0
{
this.Hide(); //hiding form 1
bsl_user M1 = new bsl_user();//passing user Name to Second form so we can user Logged user Name
M1.Show();
}
else
{
bsl_login Lg = new bsl_login();
Lg.Show();
MessageBox.Show("LoginId or Password Is wrong"); //if user Name is not available in database
}
}
}
private void bsl_login_Load(object sender, EventArgs e)
{
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
this.Hide();
bsl_admin ad1 = new bsl_admin();
ad1.Show();
}
}
}
Reply
Answers (
1
)
Updation in Sql Server.
asp.net Connection issue