Gammelt access-login til MS SQL
Jeg har et gammel Access login-system, som jeg gerne vil "konvertere" til MS SQL. Desværre virker systemet ikke "bare lige" ved at ændre lidt i koden:Nogen der kan finde en fejl?
<%@ page language="c#" runat="server" debug="true"%>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.SqlClient"%>
<script runat="server">
void Authorize(Object Sender, EventArgs e)
{
int Login_ID = DBAuthenticate(Brugernavn.Text, Adgangskode.Text);
if (Login_ID > 0)
{
Session["Godkendt"] = "Godkendt";
Response.Redirect("cms.aspx");
}
else
{
Response.Redirect("login_fejl.html");
}
}
int DBAuthenticate(string username,string password)
{
SqlConnection OurConnection;
SqlCommand OurCommand;
SqlDataReader OurDataReader;
string SQLString;
int Login_ID;
SQLString = "Select Login_ID, Password from Logins where Username = '" + username + "' and Password = '" + password + "'";
string strResultat = "<p>Data: <br>";
OurConnection = new SqlConnection("user id=sa;password=hej;Initial Catalog=KattensVaern;data source=(local)");
OurConnection.Open();
OurCommand = new SqlCommand(SQLString ,OurConnection);
OurDataReader = OurCommand.ExecuteReader();
if (OurDataReader.Read())
{
if (OurDataReader["Password"].ToString() == password)
{
Login_ID = Int32.Parse(OurDataReader["Login_ID"].ToString());
}
else
{
Login_ID = 0;
}
}
else
{
Login_ID = 0;
}
OurDataReader.Close();
OurConnection.Close();
return Login_ID;
}
</script>