User Profile

Collapse

Profile Sidebar

Collapse
nzkks
nzkks
Last Activity: May 13 '09, 04:26 AM
Joined: Mar 27 '09
Location: New Zealand
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nzkks
    replied to Help needed to create BLL class for storeprocedure which updates multiple tables
    in ASP .NET
    I couldn't find what is wrong and where by seeing the exception details. Somebody please help.

    Error below:

    Code:
    Column 'ProductID' does not allow nulls

Exception Details: System.Data.NoNullAllowedException: Column 'ProductID' does not allow nulls.

Line 9190:        <Global.System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
Line 9191:        Public Overloads Sub AddProductsFeaturesRow(ByVal
    ...
    See more | Go to post

      Leave a comment:

    • nzkks
      replied to Help needed to create BLL class for storeprocedure which updates multiple tables
      in ASP .NET
      Now I changed the VB code to:

      Code:
          <System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, True)> _
    Public Function AddProductFullDetails(ByVal categoryID As Nullable(Of Integer), ByVal description As String, ByVal isRound As Boolean, _
    ByVal productStory As String, ByVal materialID As Integer, ByVal isActive As Boolean, ByVal featureName As String, ByVal modifiedDate
      ...
      See more | Go to post

        Leave a comment:

      • nzkks
        replied to Help needed to create BLL class for storeprocedure which updates multiple tables
        in ASP .NET
        Sorry for the misunderstandin g. BLL - Business Logic Layer. Any way, I am sure you know the 3-tier architechure (Data Access Layer(DAL) | BLL | Presentation Layer (ASP.Net pages + all supporting documents)). May be this is a Microsoft term?!

        But I am very much sure you can solve this problem. OK the scenario below.

        After I created the SQL tables + all data modification store procedures in SQL server 2005, In Visual studio...
        See more | Go to post

          Leave a comment:

        • nzkks
          started a topic Help needed to create BLL class for storeprocedure which updates multiple tables
          in ASP .NET

          Help needed to create BLL class for storeprocedure which updates multiple tables

          Hi I am using these: ASP.Net 2.0 with VB.Net, Visual Studio 2005, SQL Server 2005

          I suspect, there is something missing in BLL class.

          I created the ASP.Net form also and checked whether it is working or not. When I submit after entering the data, an error comes.



          Please help me to solve this problem. Thanks

          The details below:

          I have created a store procedure...
          See more | Go to post
          • nzkks
            started a topic How to Synchronize 2 multiviews with menu control-Help needed
            in ASP .NET

            How to Synchronize 2 multiviews with menu control-Help needed

            Hi, I am using these: ASP.Net 2.0, VB.Net, Visual Studio 2005, SQL Server 2005

            In a asp.net page, I have two multiview controls each has 2 views & its corresponding 2 menu items named Metric & Imperial. Individually both works fine.

            But when I click "Metric", the other "Metric" should also be switched on and vice-versa for Imperial. How to achieve that?

            The catch here is, one of the...
            See more | Go to post
            • nzkks
              started a topic Nested webcontrols from the same objectdatasource - Help needed
              in ASP .NET

              Nested webcontrols from the same objectdatasource - Help needed

              Hi, I am using these: ASP.Net 2.0, VB.Net, Visual Studio 2005, SQL Server 2005, Objectdatasourc e using DAL & BLL classes

              My objectdatasourc e can produce below output by CategoryID parameter: (stored procedure: GetProductsByCa tegoryID )

              CategoryID | CollectionID | ProductID | CategoryName | CollectionName | ProductName | ProductPhoto

              1 1 3 XYZ ...
              See more | Go to post
              • nzkks
                replied to How to set & show default value in dropdownlist from databound items (not static)
                in ASP .NET
                Thanks. But still not working.
                See more | Go to post

                  Leave a comment:

                • nzkks
                  replied to How to set & show default value in dropdownlist from databound items (not static)
                  in ASP .NET
                  OK, I tried this way and worked for 2 instances. But 3rd ddl onwards are not working and giving the error "Object reference not set to an instance of an object".
                  Code:
                  Protected Sub FormView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormView1.DataBound
        Dim ddl1 As DropDownList = CType(FormView1.FindControl("ddlProductSizeUnit"), DropDownList)
        ddl1.SelectedItem.Text
                  ...
                  See more | Go to post

                    Leave a comment:

                  • nzkks
                    started a topic How to set & show default value in dropdownlist from databound items (not static)
                    in ASP .NET

                    How to set & show default value in dropdownlist from databound items (not static)

                    Hi I am using these: ASP.Net 2.0, VB.Net, Visual Studio 2005, SQL Server 2005, Formview controls

                    In a ASP.Net form I have 20 textboxes and 20 dropdownlists(d dl). All ddl(s) are databound and get the data from a single objectdatasourc e. All textboxes and ddl(s) support null values. Textboxes are for entering numbers and ddl(s) are for selecting the unit (mm, cm, in, m3, oz, qt like these.).

                    I am using the below code to achieve...
                    See more | Go to post
                    • nzkks
                      started a topic Dataset - data adapter related help please
                      in ASP .NET

                      Dataset - data adapter related help please

                      Hi, I am trying the following SQL to fetch the needed data. The query works in query analyzer in SQL Server 2005. But in data adapter in a dataset in Visual Studio 2005, I am getting the data with all other empty cells. What mistake I am doing? The expected result is only a concatenated value (~/images/logos/Somelogo.jpg)

                      Code:
                      SELECT (SELECT FilePath FROM dbo.FilePaths WHERE (FilePathID = dbo.Brands.BrandLogoImageFilePath)) + BrandLogoImageName
                      ...
                      See more | Go to post
                      No activity results to display
                      Show More
                      Working...