Search results for query: *

Good idea. Thank you.

Could someone help me with the proper syntax to loop through the records in a Formview? Something like For i = 0 To FormView1.DataItemCount - 1 Response.Write(FormView1.DataKey(i).Value.ToString()) Next I keep getting an 'index out of range' error or a 'Value not found ...' no matter...

I found the problem with the UPDATE and DELETE SQL statements. Seems VFP doesn't like the square brackets [] surrounding the field names.

Whoops, I thought I was there but not quite. I can now read the data in the Formview and I can INSERT new records. Paging works also. However the UPDATE fails with an error that says "Column '' is not found". DELETE does not throw an error but does not work either. The screen looks like it...

I found the problem. Apparently the wizard doesn't build the connection string properly. When I coded it in by hand it works OK. Now can someone tell me how to safely change the name of a project and the folder it resides in? Thanks

Seems like the problem is still in the definition of the connection. In the Modify Connection dialog there are 3 text entries: Data Source = ".NET Framework Data Provider for OLE DB" OLE DB Provider = "Microsoft OLE DB Provider for Visual FoxPro" Server or filename = "" I can't figure out...

OK folks. Thanks to all of you who have responded to this thread thus far. I was able to resolve (I think) the problem with the data source configuration. It seems the table must have a designated keyfield index before the GENERATE INSERT, UPDATE, AND DELETE options will be made available. So I...

OK if I understand jbenson001 advice, its better to build the connection in code rather than using the wizards built in to the data controls. So, suppose you do something like this: <% session("dataloc") = "c:\inetpub\wwwroot\myproject\app_data\" dim oConn Set oConn =...

Whoops! I think we've gone full circle. I was (am) trying to use the data objects for the very reason you point out. BUT, I'd like to use them with a VFP database. If I build the connection myself in code, how would I associate it with a formview for example? I can (and have) written several...

So, do you use the old oConn = "some string" and oRS = oConn.execute(sql) etc? If we do this I don't see much benefit in moving from ASP to ASPX. I still have to write a complete routine to manage any editing and paging.

OK, I have a simple VFP table with only 2 character fields in it. The table is in a database DBC. When I configure the datasource for the formview the options to generate UPDATE and INSERT statements is not available. (grayed out) Why? and how do I fix it? Thanks

Thanks!!

Aah, but then I might become embarrassed. Can you answer my first question?

Is it true that in order to use the full functionality of the new datacontrols (formview, gridview, etc) you have to maintain the data in a SQL server/express database? I have tables in a VFP database and can't seem to get them to work with a proper connection definition for...

Thanks. Works great!

Thanks. I got it with an ONLOAD script.

This from a total newbie. When using a formview, is it possible to change to appearance of the pager buttons to regular buttons rather than the default linkbuttons? Thanks

When switching from asp to aspx, is there a new technique for binding data to a textbox control, or do we continue to use code like: <input name="txtZip" value='<%=oRS("zip")%>' > I have gone through the videos that discuss the new data controls such as grid and formview but have seen nothing...

I have been experimenting with the aspx login controls. Can someone tell me where the actual data is stored and can additional data fields be created? Thanks

Suppose the web page contains a SELECT control that is disabled by default. As the user makes choices, the SELECT becomes enabled. Then with the SELECT enabled, he proceeds to a different page. After viewing the second page he clicks the back button to return to the first page. The selections he...