using System;
using System.Data;
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.Web.UI.HtmlControls;
using System.Data.SqlClient;
using Sybase.Data.AseClient;
public partial class delete : System.Web.UI.Page
{
private AseConnection TempDMT_conn = new AseConnection(ConfigurationSettings.AppSettings["connectionString"]);
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string username = txtusername.Text;
TempDMT_conn.Open();
AseDataAdapter adapter = new AseDataAdapter();
adapter.MissingMappingAction = MissingMappingAction.Passthrough;
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
adapter.SelectCommand = new AseCommand(
"SELECT * FROM login WHERE username= @username ",
TempDMT_conn);
adapter.DeleteCommand = new AseCommand(
"DELETE FROM login WHERE username = @username",
TempDMT_conn);
adapter.DeleteCommand.UpdatedRowSource =
UpdateRowSource.None;
AseParameter parm = new AseParameter("@username",
AseDbType.Text, 10);
parm.SourceColumn = "username";
parm.SourceVersion = DataRowVersion.Original;
adapter.DeleteCommand.Parameters.Add(parm);
DataTable dataTable = new DataTable("login");
int rowCount = adapter.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
{
row.Delete();
}
int recordsAffected = adapter.Update(dataTable);
dataTable.Clear();
TempDMT_conn.Close();
}
}
how can i fix this error message
Must declare variable '@username'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Sybase.Data.AseClient.AseException: Must declare variable '@username'.
Source Error:
Line 50: int rowCount = adapter.Fill(dataTable);