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

More Search Options

RSS Available

• ObjectDataSource and TypeNames

  Hi I've just split up my main class into smaller more manageable ones but I now have the problem that the methods I need to populate my ObjectDataSources CRUD all reside in different classes. What is my best approach? Should I... Leave all my classes in seperate files which make them easy to manage but give them all the same partial class name Create a seperate class to be used as the ObjectDataSources TypeName which references methods in multiple classes Any advice would be appreciated Cheers

  Posted to Architecture (Forum) by kagool on 9/30/2009

• Re: DataSet Computed Column Expression problem

  Hi Naom This is my procedure so far... I added a table adapter in Visual Studio using the dataset designer. The datatable is populated using stored procedures which pull fields from various SQL tables which all relate to various educational courses. The 3 queries used in the datatable all return the same fields and all the fields used in the expression for the computed column are columns present in the datatable. The full query I'm trying to use as the expression for the computed column is: CASE

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by kagool on 7/22/2009

• Re: DataSet Computed Column Expression problem

  Yeah there is an error in that expression but I still get the error At the moment I'm just testing with the following expression. case qualification when 'Taster' then subjectarea end I get the error message Syntax error: Missing operand after 'qualification' operator.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by kagool on 7/22/2009

• DataSet Computed Column Expression problem

  Hi I am trying to add a computable column in the Visual Studio dataset designer but I keep recieving an error when I enter the expression. I've stripped the expression down for clarity. case when qualification = 'Taster' then subjectarea end when I click out of the expression property box I recieve the following error. Syntax error: Missing operand after 'when' operator. According to the following links my syntax is correct http://www.asp.net/learn/data-access/tutorial-71-vb.aspx

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by kagool on 7/21/2009

• Re: DataSet Computed Column Expression problem

  Speedy response limno! I've tried your suggestion but I still recieve the error Syntax error: Missing operand after 'when' operator. I've also tried case qualification when 'Taster' then subjectarea end Syntax error: Missing operand after 'qualification' operator.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by kagool on 7/21/2009

• Re: Custom Paging with Filter - Count Method Problem

  Thanks for your advice guys but dare I say it, it appears to be a bug in .NET!!! I noticed this morning that I also recieved the error when I removed the parameter from the SelectCountMethod in the DAL and updated the BLL accordingly. I tried deleting the method from the DAL and recreating it and finally everything compiles. I tried this approach a number of times before so this fix appears to be a bit temperamental. but I don't sem to be the only one who has experienced this prblem and fixed

  Posted to Data Access and ObjectDataSource Control (Forum) by kagool on 6/19/2009
  Filed under: +

• Re: Custom Paging with Filter - Count Method Problem

  Hi Wencui Qian Thanks for replying, I thought this post had slipped through the cracks. I'm a bit unsure as to what you mean [quote user="Wencui Qian - MSFT"] No, I guess it may not have any parameter. Thanks. [/quote]

  Posted to Data Access and ObjectDataSource Control (Forum) by kagool on 6/17/2009

• Custom Paging with Filter - Count Method Problem

  Hi I've been working through Scott Mitchell's Data Access Tutorials to learn about custom paging. http://www.asp.net/LEARN/data-access/tutorial-25-cs.aspx In this tutorial a method is added to the DAL to count the total number of products SELECT COUNT(*) FROM Products and a method is added to the BLL which calls down to the method public int TotalNumberOfProducts() { return Adapter.TotalNumberOfProducts().GetValueOrDefault(); } I'm trying to amend the above to allow a parameter to be

  Posted to Data Access and ObjectDataSource Control (Forum) by kagool on 6/15/2009

• Re: Accessing Label Value on RowCreated

  Hi Samu Zhang I tried your solution but when I clicked on 'Edit' in the gridview it raised the following error: 'There is no source code available for the current location' Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. By changing the method from databound to rowcreated I no longer recieve the error which is great. Thank you. All that remains now is to modify the method so that the fundingbodyid for the row is used

  Posted to Data Presentation Controls (Forum) by kagool on 5/5/2009

• Re: Accessing Label Value on RowCreated

  Here you go Mo Meng. Thanks for your help <%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="CheckList.aspx.cs" Inherits="EnrolledStudents_Checklist" MaintainScrollPositionOnPostback="true" %> <asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="Server"> <div id="adminform2"> <h2> Course Checklist<

  Posted to Data Presentation Controls (Forum) by kagool on 4/28/2009