Comments by Mike988 (Top 34 by date)

thank you so much

Thank you so much .i did this but how can i recall it from the page , it's first time i use wrapper.

this is the connection . MySQLConnector.txt
//I have a few radio buttons to update before that code and they works fine.

if ($_SESSION['CustomerID']==0) { // Not logged in
$_SESSION['Message'] = "Insert Preferences: Permission Denied";
header("Location: index.php") ;
} else {
include "MySQLConnector.txt";
}

i put the rest of my code

string sql = ("SELECT * FROM Customer WHERE (FirstName LIKE \'%" + (txtSearch.Text + "%\')"));

Thank you so much

i tried it with out {} and it didn't work.

string sql =string.Format("SELECT * FROM Customer, WHERE FirstName LIKE '%txtSearch.text%'");

this code worked for me .
string sql = ("SELECT * FROM Customer WHERE (FirstName LIKE \'%" + (txtSearch.Text + "%\')"));

Thanks for your response ,
i tried like that.
string sql =string.Format("SELECT * FROM Customer, WHERE FirstName LIKE '%{txtSearch.text}%'");
but it gives me error.

it works now , i just make it ddlCategoryID.Items.Add(liC); instead of ddlCategoryID.Items.Add(liC.text);

Thank you so much.

after commented that line
when i click edit user , it doesn't select the category.

it's int

i post it up, thank you so much for your help

is that the right way to do it, i tried your code but still gives me same error

ddlCategoryID.SelectedValue = drP["CategoryID"].ToString();
ddlCategoryID.SelectedItem.Text = drP["Description"].ToString();


ddlVendorID.SelectedValue = drP["VendorID"].ToString();

ddlVendorID.SelectedItem.Text = drP["VendorName"].ToString();

it gives me , this error Input string was not in a correct format.
may be my populating is wrong ?

ddlCategoryID.SelectedValue = drP["CategoryID"].ToString();
ddlCategoryID.SelectedItem.Text = drP["Description"].ToString();


ddlVendorID.SelectedValue = drP["VendorID"].ToString();

ddlVendorID.SelectedItem.Text = drP["VendorName"].ToString();

for new user /
//Loop through the DataReader
ddlCategoryID.Items.Clear();
while (drC.Read())
{
ListItem liC = new ListItem();
liC.Text = drC["Description"].ToString();
liC.Value = drC["CategoryID"].ToString();

ddlCategoryID.Items.Add(liC.Text);

}
drC.Close();
ConnC.Close();

// to open existing user

ddlCategoryID.SelectedItem.Text = drP["Description"].ToString();
ddlCategoryID.SelectedItem.Value = drP["CategoryID"].ToString();

i tested each code by it self. i found the update code work fine , but when i put the code before it , it make it stop, i updated my code.
i am trying to find out what is wrong with the first code (Populate the data)

I am new in C# , I Put a breakpoint on cmd.ExecuteNonQuery and (start debuging) and immediate window but it tell me.,

The expression cannot be evaluated while in run mode.
i am sorry

every time i select different row the id change. and it match the id in the database.

I really appreciate that you trying to help me. i been struggling in this h.w assignment for couple days.

it's like that
http://localhost:15110/Project2/CustomerEdit.aspx?MODE=E&id=1000

i did edited like that, but still doesn't work.

<pre lang="c#">
protected void btnUpdate_Click(object sender, EventArgs e)
{



if (Request.QueryString["id"] != null)
{

int CustomerID = Convert.ToInt32(Request.QueryString["id"]);

//Declare the connection object
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyLocal"].ConnectionString);

//Make the connection
Conn.Open();



string sql = "UPDATE [Customer] SET [FirstName] = @FirstName, [LastName] = @LastName, [Email] = @Email, [Password] = @Password, [Address1] = @Address1, [Address2] = @Address2, [City] = @City, [State] = @State, [zip] = @zip, [Phone] = @Phone, [Fax] = @Fax WHERE CustomerID=@CustomerID";

//Declare the Command
SqlCommand cmd = new SqlCommand(sql, Conn);

//Add the parameters needed for the SQL query
cmd.Parameters.AddWithValue("@CustomerID", CustomerID);
cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text);
cmd.Parameters.AddWithValue("@LastName", txtLastName.Text);
cmd.Parameters.AddWithValue("@Email", txtEmailA.Text);
cmd.Parameters.AddWithValue("@Password", txtPasswordA.Text);
cmd.Parameters.AddWithValue("@Address1", txtAddress1.Text);
cmd.Parameters.AddWithValue("@Address2", txtAddress2.Text);
cmd.Parameters.AddWithValue("@City", txtCity.Text);
cmd.Parameters.AddWithValue("@State", txtState.Text);
cmd.Parameters.AddWithValue("@Zip", txtZip.Text);
cmd.Parameters.AddWithValue("@Phone", txtPhone.Text);
cmd.Parameters.AddWithValue("@Fax", txtFax.Text);



//Execute the query

cmd.ExecuteNonQuery();

Conn.Close();
Response.Redirect("Customers.aspx");



}
</pre>

like that or ? int CustomerID = Convert.ToInt32(Request.QueryString["id"]);

i updated .
CustomerID = Request.QueryString["id"];
how can i convert the querystring to int. i think that is might be the problem.

http://localhost:15110/Project2/CustomerEdit.aspx?MODE=E&id=1000
yeah and when the page load i did this statmenet.


CustomerID = Request.QueryString["id"];
Label1.Text = CustomerID;
and it shows the id number correct on the label.
i also tried to set the customerID when to this label.

cmd.Parameters.AddWithValue("@CustomerID", Label1.Text);

Do you know how i setting customerID to make it work,
i tried to put CustomerID = Request.QueryString["id"];
but it still doesn't work

this is my problem . the customerID is equal to querystring id.

CustomerID = Request.QueryString["id"];