You searched for the word(s): userid:816150

More Search Options

RSS Available

• Re: Implementing custom paging is messing with data retrieval.

  Class 1 is the class for the ODS to reference its methods to. It would usually be the BLL of the project. The typename property is required with the ODS to know what class to use (you could also use just the Dataset here if need be). I have set breakpoints in the method you mentioned, and it is getting the correct data. As is the ODS (I checked the Selected event of the ODS, it is getting the correct data, but the Gridview is not displaying it).

  Posted to Data Access and ObjectDataSource Control (Forum) by aaron1991 on 7/13/2009

• Re: "Property Evaluation Failed"

  Apparently if you have a function that receives a total input over a given size (some number of bytes), then the debugger does something different with the function and the values are not explicity available. Either make your function have a smaller total input or live with it if you get this error in an ordinary coding circumstance. - Aaron

  Posted to Visual Studio 2008 (Forum) by aaron1991 on 7/12/2009

• Re: Implementing custom paging is messing with data retrieval.

  After much frustration, I have still not figured out a way to do this. I have replicated my error in a totally independent project, but still have no understanding of why it is happening. Here is the entireity of the code in my test project. Could someone test and see if this is replicable? SQL Database: Table1 ColumnName Datatype Allow Nulls Number bigint False - Primary Key and Auto-increment. seed of 1, add 1 String1 nchar(50) False String2 nchar(50) False Boolean bit True ALTER PROCEDURE dbo

  Posted to Data Access and ObjectDataSource Control (Forum) by aaron1991 on 7/12/2009

• "Property Evaluation Failed"

  Hi there. On a web page I am developing, I am using a dataset to retrieve data from a database, and am filling a datatable with said information. I noticed upon attempting to debug that several of the properties of this table were not visible to me (such as count), but the program was still running with the values correct. I couldn't find a whole lot on this issue anywhere, does anyone know what it might be? Thanks!

  Posted to Visual Studio 2008 (Forum) by aaron1991 on 7/2/2009

• Re: TableAdapters and the Date datatype

  [quote user="vinz"]I'm not sure about the statement above...[/quote] Basically, I have in my SQL database a column in a table that has the datatype of datetime and allows nulls (because I need it to either be a datetime value or blank) and I need to be able to read this value and then display it in a textbox. The problem is that on inserting and updating, the autogenerated tableadapter (when dragged from the server explorer to the dataset designer) sets all columns that are datetimes

  Posted to Data Access and ObjectDataSource Control (Forum) by aaron1991 on 6/29/2009

• Re: Implementing custom paging is messing with data retrieval.

  Hey, I tried to make my asp.net code mimic yours as much as possible. This is what I have, but, unfortunately, I still get a blank screen when I run the page. I'm wondering if it's possible if there is some setting I could have accidentally messed up somewhere somehow... <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="ObjectDataSource1" PageSize="10"> <Columns>

  Posted to Data Access and ObjectDataSource Control (Forum) by aaron1991 on 6/29/2009

• Re: TableAdapters and the Date datatype

  Okay, I like the idea, but I have two problems. 1) I unfortunately do not how to convert that from C to VB. I know it's something along the lines of Dim date As Datetime? = Nothing, but I don't think I have the datatype correct... 2) I don't know how I'd do that with the auto generated tableadapters. The only datatype option i have that fits is datetime, and there is a separate property on the column of what to do in the circumstance of a null, and I won't let me put anything

  Posted to Data Access and ObjectDataSource Control (Forum) by aaron1991 on 6/27/2009

• TableAdapters and the Date datatype

  Hi there! I have a nullable datetime field in my SQL database, and am accessing it through a table adapter. I am having trouble inserting a null value into the database because the tableadapter wants to convert the value to a datetime value, which don't allow nulls or empty strings. Is there any way to insert a null value into the datetime value in the database without the tableadapter trying to convert my value?

  Posted to Data Access and ObjectDataSource Control (Forum) by aaron1991 on 6/24/2009

• Re: Implementing custom paging is messing with data retrieval.

  Here is the BL code that is being called by the ODS: 1 Option Explicit On 2 Imports Microsoft.VisualBasic 3 Imports DSTableAdapters 4 5 Public Class BL_T_Forum_Threads 6 Private T_Forum_Threads_Adapter As T_Forum_ThreadsTableAdapter = Nothing 7 Private ReadOnly Property Adapter() As T_Forum_ThreadsTableAdapter 8 Get 9 If T_Forum_Threads_Adapter Is Nothing Then 10 T_Forum_Threads_Adapter = New T_Forum_ThreadsTableAdapter 11 End If 12 Return T_Forum_Threads_Adapter 13 End Get 14 End Property 15 Public

  Posted to Data Access and ObjectDataSource Control (Forum) by aaron1991 on 6/23/2009

• Re: Implementing custom paging is messing with data retrieval.

  Okay, so I have simplified as much as possible. I created a new default page with no masterpage, I added only the Gridview and ObjectDataSource, only have paged selecting available as a method, and made the gridview autogenerate columns. I still get the issue of the gridview not showing any data. I debugged the ODS's 'selected' event and found the e.ReturnValue to be the DataTable that has the data I need on the first time the event is raised and then on the second time the event is raised

  Posted to Data Access and ObjectDataSource Control (Forum) by aaron1991 on 6/22/2009