Hello friend,
I am trying to add something using "StoredProcedure" with
SCommd.Parameters.Add.
Pls have a look at the following code....., can u pls tell me where the prob
is ?
public bool AddLinkExchangeDetails(ArrayList LinkDetails)
{
try
{
SqlCommand SCommd=new
SqlCommand("sp_AddLinkExchangeOffer",ObjConn.mysqlconn);
SCommd.CommandType=CommandType.StoredProcedure;
SCommd.Parameters.Add("@OrgName",LinkDetails[0].ToString());
SCommd.Parameters.Add("@OrgDetails",LinkDetails[1].ToString());
SCommd.Parameters.Add("@OrgEmail",LinkDetails[2].ToString());
SCommd.Parameters.Add("@OrgURL",LinkDetails[3].ToString());
SCommd.Parameters.Add("@LinkWord",LinkDetails[4].ToString());
ObjConn.OpenConnection();
SCommd.ExecuteNonQuery(); // problem at this point
ObjConn.closeConnection();
return true;
}
catch
{
return false;
}
}
Thanks & Regards
Arindam
Web Designer & Developer
Yahoo! India Matrimony: Find your life partneronline.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
