November 19, 2008 12:27am pst

1. hielo 210,225
2. logudotcom 183,525
3. b0lsc0tt 141,132
4. Ray_Pas... 98,287
5. jason1178 82,463
6. tedbilly 54,191
7. TheLearn... 48,265
8. mplungjan 46,587
9. lunadl 43,414
10. julianopolito 39,265
11. hernst42 36,784
12. naspinski 33,875
13. angelIII 32,125
14. ahoffmann 32,121
15. Zvonko 31,600
16. Squinky 30,550
17. meverest 29,875
18. erikTsomik 29,044
19. Roonaan 29,030
20. samtran0... 28,630
21. scrathcyboy 25,700
22. Xyptilon2 24,450
23. GreenGho... 23,475
24. raterus 23,165
25. prairiedog 22,300

1. hielo 218,225
2. logudotcom 191,075
3. b0lsc0tt 167,751
4. lunadl 118,526
5. jason1178 114,484
6. Ray_Pas... 98,287
7. TheLearn... 98,065
8. tedbilly 90,479
9. samtran0... 89,689
10. hernst42 87,372
11. mplungjan 83,319
12. Zvonko 56,300
13. angelIII 48,707
14. ahoffmann 47,199
15. DropZone 46,530
16. steelseth12 44,927
17. glcummins 41,864
18. nizsmo 40,218
19. julianopolito 39,265
20. Roonaan 37,635
21. erikTsomik 34,094
22. rdivilbiss 34,074
23. naspinski 33,875
24. meverest 33,375
25. objects 33,322

10.09.2008 at 10:21AM PDT, ID: 23801672

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.1

Manual Insert Fails

Asked by AkAlan in WebApplications, Programming for ASP.NET, SQL Server 2005

I'm trying to insert a record to a sql server using an objectdatasource but I'm getting an exception when it gets to inserting the date field. The exception is:
"Object reference not set to an instance of an object."

The variable has the correct date in it so I'm not really sure what this means. I will post a copy of all the code I'm using in case someone can see what I'm doing wrong. Thanks for any help on this.
Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:

           
           
             Code Behind on the Onclick event:
 
        Dim strWorkOrderID As String = txtWorkOrderID.Text
        Dim datDateWorked As Date = txtDateWorked.Text
        Dim strWorkPerformed As String = txtWorkDone.Text
       
        odsWorkOrderDetail.InsertParameters("WorkOrderID").DefaultValue = strWorkOrderID.ToString()
        odsWorkOrderDetail.InsertParameters("WorkDone").DefaultValue = strWorkPerformed.ToString()
        odsWorkOrderDetail.InsertParameters("DateWorked").DefaultValue = datDateWorked.ToShortDateString()  ****Fails Here****
        odsWorkOrderDetail.Insert()
 
 
 
ObjectDataSource:
 
 
 
<asp:ObjectDataSource ID="odsWorkOrderDetail" runat="server" 
                    InsertMethod="AddWorkOrderDetail" OldValuesParameterFormatString="{0}" 
                    SelectMethod="GetWorkOrderDetails" TypeName="WorkOrderBLL">
                    <SelectParameters>
                        <asp:Parameter Name="WorkOrderID" Type="String" />
                    </SelectParameters>
                    <InsertParameters>
                        <asp:Parameter Name="WorkOrderID" Type="String" />
                        <asp:Parameter Name="WorkDate" Type="DateTime" />
                        <asp:Parameter Name="WorkDone" Type="String" />
                    </InsertParameters>
                </asp:ObjectDataSource>
 
 BLL:
 
 <System.ComponentModel.DataObjectMethod(System.ComponentModel.DataObjectMethodType.Insert, False)> _
   Public Function AddWorkOrderDetail _
                  (ByVal workOrderID As String, _
                   ByVal workDate As Date, _
                   ByVal workDone As String) As Boolean
        Dim workOrderDetail As New WorkOrderDAL.FAC_WorkOrderDetailsDataTable
        Dim workOrderDetailRecord As WorkOrderDAL.FAC_WorkOrderDetailsRow = workOrderDetail.NewFAC_WorkOrderDetailsRow()
 
        workOrderDetailRecord.WorkOrderID = workOrderID
        workOrderDetailRecord.WorkDate = workDate
        workOrderDetailRecord.WorkDone = workDone
 
        workOrderDetail.AddFAC_WorkOrderDetailsRow(workOrderDetailRecord)
        Dim rowsAffected As Integer = DetailsAdapter.Update(workOrderDetail)
        Return rowsAffected = 1
    End Function
 
 
 
 
Stored Procedure:
 
 
 
ALTER PROCEDURE dbo.spInsertFAC_WorkOrderDetails
(
@WorkOrderID varchar(15),
@WorkDate datetime,
@WorkDone varchar (1000))
AS 
SET NOCOUNT OFF;
 
 
INSERT INTO dbo.FAC_WorkOrderDetails ([WorkOrderID], [WorkDate], [WorkDone])
     VALUES (@WorkOrderID, @WorkDate, @WorkDone);
SELECT WorkOrderID, WorkDate, WorkDone FROM dbo.FAC__WorkOrderDetails 
WHERE (WorkOrderDetailID = SCOPE_IDENTITY())

           
         

Keywords: Manual Insert Fails

	Title
1	Insert statement
2	xml data insert into relational table?
3	Insert TIME only into DateTime field
4	inserting datetime values manually
5	INSERT and UPDATE with blank from fi…
6	DISTINCT INSERT SQL statement

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Manual Insert Fails

Asked by AkAlan in WebApplications, Programming for ASP.NET, SQL Server 2005

About this solution