I am getting the erorr "Index (zero based) must be greater than or
equal to zero and less than the size of the argument list." when using
the following code, any ideas?:
Dim intID As Integer
Dim txtAdvertiser As TextBox
Dim txtUsername As TextBox
Dim advertiser As String
Dim username As String
Dim Conn As SqlConnection
Dim cmdSql As SqlCommand
Dim strSql As String
intID = myDataGrid.DataKeys(e.Item.ItemIndex)
txtAdvertiser = e.Item.FindControl("txtAdvertiser")
txtUsername = e.Item.FindControl("txtusername")
Conn = New SqlConnection(AppSettings("sqlConnect"))
strSql = "Update USERS Set [EMAIL PROTECTED],
[EMAIL PROTECTED] WHERE [EMAIL PROTECTED]"
cmdSql = New SqlCommand(strSql, Conn)
cmdSql.Parameters.Add("@advertiser", txtAdvertiser)
cmdSql.Parameters.Add("@username", txtUsername)
cmdSql.Parameters.Add("@id", intID)
Conn.Open()
cmdSql.ExecuteNonQuery()
Conn.Close()
myDataGrid.EditItemIndex = -1
BindDataGrid()
Here is the long error in detail:
Index (zero based) must be greater than or equal to zero and less than
the size of the argument list.
at System.Text.StringBuilder.AppendFormat(IFormatProvider provider,
String format, Object[] args)
at System.String.Format(IFormatProvider provider, String format,
Object[] args)
at System.Data.Res.GetString(CultureInfo culture, String name, Object[] args)
at System.Data.Common.ADP.UnknownDataType(Type dataType)
at System.Data.SqlClient.MetaType.GetMetaType(Object value)
at System.Data.SqlClient.SqlParameter.SetTypeInfoFromComType(Object value)
at System.Data.SqlClient.SqlParameter.set_Value(Object value)
at System.Data.SqlClient.SqlParameter..ctor(String parameterName,
Object value)
at System.Data.SqlClient.SqlParameterCollection.Add(String
parameterName, Object value)
at *********.com.home.myDataGrid_UpdateCommand(Object s,
DataGridCommandEventArgs e) in C:\Documents and
Settings\mappenzellar\VSWebCache\*********.com\admin\home.aspx.vb:line
114
at System.Web.UI.WebControls.DataGrid.OnUpdateCommand(DataGridCommandEventArgs
e)
at System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source,
EventArgs e)
at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object
source, EventArgs e)
at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)
at
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain()
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/
