StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POsql user detection not working as it should be
primarykey
Id
19172353
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
12
CommunityOwnedDate
CreationDate
2013-10-04T02:44:27.733
FavoriteCount
0
LastActivityDate
2013-10-04T02:44:27.733
LastEditDate
LastEditorUserId
0
OwnerUserId
2844994
ParentId
0
PostTypeId
1
Score
1
ViewCount
74
LastEditorDisplayName
text
Body
Im having trouble getting my program to detect admin users. I have created a login system, but when an admin logs in, it skips past the sql query and moves on to open a user screen, not an admin. When a user registers, they are presented with a pair of radio buttons to choose their user type. Depending on which one is selected, the User type (admin or user) is written into the database in a column User. Here is my code: <pre><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; using System.Data.SqlTypes; namespace myLoginProject { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(@"server=.\SQLEXPRESS; database=loginTest;Trusted_Connection=yes"); connection.Open(); string selection = "select * from Logins where Name = '" + userNameBox.Text + "' and Password = '" + passwordBox.Text + "' "; SqlCommand command = new SqlCommand(selection, connection); SqlDataAdapter da = new SqlDataAdapter(command); DataSet ds = new DataSet(); da.Fill(ds); DataTable dt = ds.Tables[0]; } private void registerButton_Click(object sender, EventArgs e) { adminAuthScreen aas = new adminAuthScreen(); aas.Show(); } private int myMethod(string user, string pass) { user.Trim(); pass.Trim(); SqlConnection connection = new SqlConnection(@"server=.\SQLEXPRESS; database=loginTest;Trusted_Connection=yes"); connection.Open(); string selection = "select * from Logins where Name = '"+user+"' and Password = '"+pass+"' "; SqlCommand command = new SqlCommand(selection, connection); if (command.ExecuteScalar() != null) return 1; else return 0; } private void loginButton_Click(object sender, EventArgs e) { if (myMethod(userNameBox.Text,passwordBox.Text)>0) { MessageBox.Show("Welcome back, "+userNameBox.Text); SqlConnection myConnection = new SqlConnection(@"server=.\SQLEXPRESS; database=loginTest;Trusted_Connection=yes"); try { myConnection.Open(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } string checkAdmin1 = "SELECT * FROM Logins WHERE Name = '"+userNameBox.Text+"' AND User='Admin'"; SqlCommand checkIfAdmin = new SqlCommand(checkAdmin1, myConnection); if (checkIfAdmin.ExecuteScalar() != null) { adminScreen admnscrn = new adminScreen(); admnscrn.Show(); } else { userScreen usrscrn = new userScreen(); usrscrn.Show(); } } } public SqlConnection connection { get; set; } } } </code></pre> It seems like this bit is the problem (at least its the problem during debugging): <pre><code> private void loginButton_Click(object sender, EventArgs e) { if (myMethod(userNameBox.Text,passwordBox.Text)>0) { MessageBox.Show("Welcome back, "+userNameBox.Text); SqlConnection myConnection = new SqlConnection(@"server=.\SQLEXPRESS; database=loginTest;Trusted_Connection=yes"); try { myConnection.Open(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } string checkAdmin1 = "SELECT * FROM Logins WHERE Name = '"+userNameBox.Text+"' AND User='Admin'"; SqlCommand checkIfAdmin = new SqlCommand(checkAdmin1, myConnection); if (checkIfAdmin.ExecuteScalar() != null) { adminScreen admnscrn = new adminScreen(); admnscrn.Show(); } else { userScreen usrscrn = new userScreen(); usrscrn.Show(); } } } </code></pre> Can anyone help me find out what the problem is??? Ive tried googling, reading up, i just cant seem to find the answer anywhere... P.S. Its a winforms app, written in C# and will be run on a single computer
Tags
<c#><sql><sql-server><winforms>
Title
sql user detection not working as it should be
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. UStony b
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.