hard to tell, but let's try setting the parms as text instead of controls...
cmdSql.Parameters.Add("@advertiser", txtAdvertiser.Text)
cmdSql.Parameters.Add("@username", txtUsername.Text)
and see if that helps
On Apr 1, 2005 1:40 PM, Mike Appenzellar <[EMAIL PROTECTED]> wrote:
>
> 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
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com
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/
