<div>
// &nbsp;new SqlConnection(&quot;&quot;); instead of this<br />
<br />
&nbsp;new SqlConnection(urconnection<wbr />string);
</div>


//  new SqlConnection(""); instead of this

 new SqlConnection(urconnectionstring);

<div>
and also after <br />
System.Data.SqlClient.SqlC<wbr />onnection Connection = new SqlConnection(&quot;&quot;);<br />
Connection.Open()
</div>


and also after
System.Data.SqlClient.SqlConnection Connection = new SqlConnection("");
Connection.Open()

<div>
Thanks gauthampj, I will try it shortly and let you know
</div>


Thanks gauthampj, I will try it shortly and let you know

<div>
<div class="content wysiwyg-content">
Hey guys,<br />
<br />
I am trying to create a more secure login for my Windows App using Visual Studio 2005 C#. &nbsp;I have a MS Access Database, which has the following collums:<br />
UserName &nbsp; Password<br />
<br />
And these are the details inside:<br />
username1 &nbsp;password1<br />
username2 password2<br />
username3 password3 <br />
etc<br />
<br />
I have used a DataGridView to connect the database to the program, I am unsure if that's correct. &nbsp;Anyway what I want to do is the user types their username, then password. &nbsp;When they click Accept (button) then I want the program to check the database, see if the user name is correct with the right password, and then return whether it is correct or not. &nbsp;<br />
<br />
After that I think I should be able to handle the permissions side. &nbsp;So can anybody help me out please? &nbsp;I am not great with C# so will need it explain in idiot terms lol, with as much help with the code as possible.
</div>
</div>


Hey guys,

I am trying to create a more secure login for my Windows App using Visual Studio 2005 C#.  I have a MS Access Database, which has the following collums:
UserName   Password

And these are the details inside:
username1  password1
username2 password2
username3 password3 
etc

I have used a DataGridView to connect the database to the program, I am unsure if that's correct.  Anyway what I want to do is the user types their username, then password.  When they click Accept (button) then I want the program to check the database, see if the user name is correct with the right password, and then return whether it is correct or not.  

After that I think I should be able to handle the permissions side.  So can anybody help me out please?  I am not great with C# so will need it explain in idiot terms lol, with as much help with the code as possible.

Accessing Database - Login System C#

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).