Comments by NooobieCoder (Top 43 by date)

alright now everything is working up till this line
cmd.ExecuteNonQuery();

Incorrect syntax near '='

alright now everything is working up till this line
cmd.ExecuteNonQuery();

Incorrect syntax near '='

hmm still the same error

ok thanks!

@CHill60 - thanks for helping me make it look nicer!

hi, can u teach me on how to start a regex?

thanks

i change it but now my DAL class having problem
my deleteitem method have error say not all code paths return a value

ok so i change it to String sql =.... already
but now my DAL class having problem
my deleteitem method have error say not all code paths return a value

but my shoppingCartId is int data type
when i change it now my BLL have error

public int DeleteItem(int ShoppingCartID)
{
BQ_DAL dlSc = new BQ_DAL();
return dlSc.DeleteItem(ShoppingCartID);// this line the same error
}

my shoppingcartID is int datatype, but the SqlCommand cmd = new SqlCommand(sql.ToString(),myConnection) is where by the (sql has to be string)

SqlCommand(sql, myConnection);
i change it to sqlCommand(sql.ToInt32, myConnection)
however same problem occur again
ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'DeleteItem' that has parameters: ShoppingCartID, original_shoppingCartID.

now they say BQ_DAL.deleteitem(int) : not all code paths return a value?
is it because i allow null in my db table?

SqlConnection myConnection = new SqlConnection("DKGWConnectionString");

string sql = "Delete from BQ_ShoppingCart" + " where shoppingCartID = @shoppingCartID"; SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@shoppingCartID", ShoppingCartID);
cmd.CommandType = CommandType.Text;

myConnection.Open();

myCommand.ExecuteNonQuery();

myConnection.Close();

isit like that?
i have error on myCommand and conn

from the link u gave,

SqlConnection myConnection = new SqlConnection(ConnectionString);

SqlCommand myCommand = new SqlCommand(SP_DELETE_USER, myConnection);

myCommand.Parameters.AddWithValue("@UserID", id);

myConnection.Open();

myCommand.ExecuteNonQuery();

myConnection.Close();

the sp_delete_user what shd i changed to?

after changing it, now my error is

ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'DeleteItem' that has parameters: ShoppingCartID, original_shoppingCartID

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="ObjectDataSource1"
style="margin-right: 0px" onrowdatabound="GridView1_RowDataBound"
AllowPaging="True" DataKeyNames="shoppingCartID"
onrowcommand="GridView1_RowCommand">
<columns>
<asp:TemplateField>
<itemtemplate>
<asp:Button ID="Button1" runat="server" Text="delete"
CommandArgument="shoppingCartID" CommandName="DeleteRecord" />


<asp:BoundField DataField="productID" HeaderText="ID" />
<asp:BoundField DataField="productName" HeaderText="Name" />
<asp:BoundField DataField="quantity" HeaderText="Qty" />
<asp:BoundField DataField="productPrice" DataFormatString="{0:c}"
HeaderText="Price" />
<asp:BoundField DataField="productDescription" HeaderText="Desc" />
<asp:BoundField HeaderText="Sub Total" />

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strId = e.CommandArgument.ToString();
//int ShoppingCartID = GridView1.DataKeys[e.RowIndex].Value;
int ShoppingCartID = Convert.ToInt32(e.CommandArgument);
using (SqlConnection conn = new SqlConnection())
{
string sql = "Delete from BQ_ShoppingCart" +
" where shoppingCartID = @shoppingCartID";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue(
"@shoppingCartID", ShoppingCartID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}

when i put that it show me : input string was not in correct format.

system.web.ui.webcontrols.gridviewCommandeventargs does not contain a definition for rowindex and no extension method rowindex accepting a first argument of type system.web.ui.webcontrols.gridviewcommandeventargs could be found.

but there an error with RowIndex

hmm it not working

isit something like that?
int ShoppingCartID = GridView1.DataKeys[e.RowIndex].Value;
using (SqlConnection conn = new SqlConnection())
{
string sql = "Delete from PersonalDetail" +
" where shoppingCartID = @shoppingCartID";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue(
"@shoppingCartID", ShoppingCartID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}

SP?

so i should change to what code?

bad at*

how to write the deletion method?sry I am very bad CRUD especially with gridview

i got this code from online:x

but my itemtemplate only have button no hiddenfield.

sry but how do i check for the shoppingCartID?

i add a button in the item template in gridview which i wan to use. Html of which one?

i have tried this and get a new problem instead.

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
GridViewRow gRow = (GridViewRow)(((Button)e.CommandSource).NamingContainer);
int RowIndex = gRow.RowIndex;
}
}

i get this problem :

ObjectDataSource 'ObjectDataSource' could not find a non-generic method 'Delete' that has parameters

it is still the same.

I get this error when i click on my addtoCart btn and there a insert method in my btn

My DLL have no namespace, however my BLL have namespace

by right the method should appear right?

and my BLL:
public DataSet GetShoppingCart(string userID)
{
BQ_DAL dlSc = new BQ_DAL();
return dlSc.GetShoppingCart(userID);
}

this is my DAL
public DataSet GetShoppingCart(string userID)
{

SqlConnection conn;
StringBuilder sql;
SqlDataAdapter da;
DataSet PCData;

conn = dbConn.GetConnection();
PCData = new DataSet();
sql = new StringBuilder();
sql.AppendLine("SELECT * FROM BQ_ShoppingCart");
sql.AppendLine("WHERE userID = @userID");

try
{
conn.Open();
da = new SqlDataAdapter(sql.ToString(), conn);
da.SelectCommand.Parameters.AddWithValue("@userID", userID);
da.Fill(PCData);
}

catch (Exception ex)
{
errMsg = ex.Message;

}

finally
{
conn.Close();

}

return PCData;
}