amir_arsalan_k2
دوشنبه 20 آبان 1387, 15:28 عصر
من کد login به سایت نوشتم اما یه پیغام میده من نفهمیدم کسی میدونه مشکلم کجا ؟؟
using
System.Collections.Generic;
using
System.Data;
using
System.Data.SqlClient;
using
System.Configuration;
using
System.Collections;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System;
using
System.Web.UI.HtmlControls;
public
partialclassDefault2 : System.Web.UI.Page
{
protectedvoid Page_Load(object sender, EventArgs e)
{
}
protectedvoid Button1_Click(object sender, EventArgs e)
{
if (tbusername.Text == "" || tbpassword.Text == "")
{
Label1.Text = "نام کاربری و رمز عبور وارد نشده";
Label1.Visible = true;
}
else
{
Label1.Visible = false;
SqlConnection co = newSqlConnection();
SqlCommand com = newSqlCommand();
SqlDataAdapter da = newSqlDataAdapter();
DataSet ds = newDataSet();
co.ConnectionString = "Data Source=AMIR-K2;Initial Catalog=user;Integrated Security=True";
da.SelectCommand = com;
com.Connection = co;
com.Parameters.AddWithValue("@uname", tbusername.Text);
com.Parameters.AddWithValue("@pass", tbpassword.Text);
com.CommandText = "SELECT username, password" + "FROM login" + "WHERE username=@uname, password=@pass";
da.Fill(ds);
co.Open();
com.ExecuteNonQuery();
co.Close();
}
}
}
error :Line 1: Incorrect syntax near 'username'.------ روی این کد
da.Fill(ds); mamnon
using
System.Collections.Generic;
using
System.Data;
using
System.Data.SqlClient;
using
System.Configuration;
using
System.Collections;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System;
using
System.Web.UI.HtmlControls;
public
partialclassDefault2 : System.Web.UI.Page
{
protectedvoid Page_Load(object sender, EventArgs e)
{
}
protectedvoid Button1_Click(object sender, EventArgs e)
{
if (tbusername.Text == "" || tbpassword.Text == "")
{
Label1.Text = "نام کاربری و رمز عبور وارد نشده";
Label1.Visible = true;
}
else
{
Label1.Visible = false;
SqlConnection co = newSqlConnection();
SqlCommand com = newSqlCommand();
SqlDataAdapter da = newSqlDataAdapter();
DataSet ds = newDataSet();
co.ConnectionString = "Data Source=AMIR-K2;Initial Catalog=user;Integrated Security=True";
da.SelectCommand = com;
com.Connection = co;
com.Parameters.AddWithValue("@uname", tbusername.Text);
com.Parameters.AddWithValue("@pass", tbpassword.Text);
com.CommandText = "SELECT username, password" + "FROM login" + "WHERE username=@uname, password=@pass";
da.Fill(ds);
co.Open();
com.ExecuteNonQuery();
co.Close();
}
}
}
error :Line 1: Incorrect syntax near 'username'.------ روی این کد
da.Fill(ds); mamnon