Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / General / May 2008

Tip: Looking for answers? Try searching our database.

Specified argument was out of the range of valid values.Parameter     name: index

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chapi - 26 May 2008 16:16 GMT
hi, i'm having problems with a datagrid paging.
it's populates fine, but when i click the paging button appears this
error:"Specified argument was out of the range of valid
values.Parameter name: index"

I paste the code here in case someone can help me.

Sub paginaNueva(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.DataGridPageChangedEventArgs)
       DataGrid1.CurrentPageIndex = e.NewPageIndex
       binddata()
   End Sub

Sub binddata()
       Dim myConnection As New
System.Data.SqlClient.SqlConnection("myconnection_string")
       Dim strSQL As String = "SELECT * FROM
SISTEMAS_SIOPELMEETING_FOTOS WHERE titulo LIKE '%'+'almuerzos'+'%'"
       Dim strSQL2 As String = "SELECT * FROM
SISTEMAS_SIOPELMEETING_FOTOS WHERE titulo LIKE
'%'+'presentaciones'+'%'"
       Dim strSQL3 As String = "SELECT * FROM
SISTEMAS_SIOPELMEETING_FOTOS WHERE titulo LIKE '%'+'hotel'+'%'"
       Dim strSQL4 As String = "SELECT * FROM
SISTEMAS_SIOPELMEETING_FOTOS WHERE titulo LIKE '%'+'estancia'+'%'"
       Dim myCommand As New System.Data.SqlClient.SqlCommand(strSQL,
myConnection)
       Dim myCommand2 As New
System.Data.SqlClient.SqlCommand(strSQL2, myConnection)
       Dim myCommand3 As New
System.Data.SqlClient.SqlCommand(strSQL3, myConnection)
       Dim myCommand4 As New
System.Data.SqlClient.SqlCommand(strSQL4, myConnection)
       Dim myAdapter As New
System.Data.SqlClient.SqlDataAdapter(myCommand)
       Dim myAdapter2 As New
System.Data.SqlClient.SqlDataAdapter(myCommand2)
       Dim myAdapter3 As New
System.Data.SqlClient.SqlDataAdapter(myCommand3)
       Dim myAdapter4 As New
System.Data.SqlClient.SqlDataAdapter(myCommand4)
       Dim ds As New System.Data.DataSet()
       Dim ds2 As New System.Data.DataSet()
       Dim ds3 As New System.Data.DataSet()
       Dim ds4 As New System.Data.DataSet()
       myAdapter.Fill(ds)
       myAdapter2.Fill(ds2)
       myAdapter3.Fill(ds3)
       myAdapter4.Fill(ds4)
       DataGrid1.DataSource = ds
       Datagrid2.DataSource = ds2
       Datagrid3.DataSource = ds3
       Datagrid4.DataSource = ds4
       DataGrid1.DataBind()
       Datagrid2.DataBind()
       Datagrid3.DataBind()
       Datagrid4.DataBind()
       myConnection.Close()
   End Sub

Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load
       If Not Page.IsPostBack Then
           binddata()
       End If
   End Sub

Thanks.
Jeff Winn - 26 May 2008 17:11 GMT
This response doesn't have anything to do with what your question was about,
but i feel that the issue must be addressed. I see below from your code
example that you're starting to build build dynamic sql statements within
your application.

Before you continue any further, you should read this article on SQL
injection:
http://msdn.microsoft.com/en-us/library/ms161953.aspx

You should avoid using dynamic sql statements like you would avoid getting
the black plague. Parameterized statements are a much better approach and
much more secure than simply concatenating strings together. You're exposing
your application to all sorts of problems doing what you're doing below. As
for your problem, the error tells you what the problem is - and if you read
the stack trace it will more than likely tell you the exact line that is
causing the problem.

That error means you're trying to use something that the application doesn't
want. If the application expects a value from 0 to 2, and you pass in a 4
that's the exception that will get thrown. Look at the stack trace or post
more information about the error if you want a more definitive answer. The
amount of information you've given us isn't enough to give you a specific
answer to fix your problem.

> hi, i'm having problems with a datagrid paging.
> it's populates fine, but when i click the paging button appears this
[quoted text clipped - 64 lines]
>
> Thanks.
Chapi - 26 May 2008 18:38 GMT
> This response doesn't have anything to do with what your question was about,
> but i feel that the issue must be addressed. I see below from your code
[quoted text clipped - 87 lines]
>
> > Thanks.

Hi Jeff!
Thanks for the answer, you where totally right.

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.