Click here to Skip to main content
15,910,471 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
this is the sql code error

XML
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        InsertCommand="INSERT INTO [Case Development] ([Case Writer], [Case Number], [Case Title], [Company Source], [Geographic Location], [Supervisor name], [supervisor Contact Information], [Case status], [Case Synopsis], [Target Course], [Target program], [Instructors], [Instructors contact Info], [Date Assigned ], [Case Length], [Revistion Date], [Subject area], [Learning Objectives], [Key Words], [No of Modules], [Case Implimentaion Methods], [Language], [Comment], [Multimedia availablity]) VALUES (@Case_Writer, @Case_Number, @Case_Title, @Company_Source, @Geographic_Location, @Supervisor_name, @supervisor_Contact_Information, @Case_status, @Case_Synopsis, @Target_Course, @Target_program, @Instructors, @Instructors_contact_Info, @Date_Assigned_, @Case_Length, @Revistion_Date, @Subject_area, @Learning_Objectives, @Key_Words, @No_of_Modules, @Case_Implimentaion_Methods, @Language, @Comment, @Multimedia_availablity)"
        SelectCommand="SELECT * FROM [Case Development]"
        DeleteCommand="DELETE FROM [Case Development] WHERE [ID] = @ID" >

        <DeleteParameters>
            <asp:Parameter Name="ID" Type="Int32" />
        </DeleteParameters>

        <InsertParameters>
            <asp:Parameter Name="Case_Writer" Type="String" />
            <asp:Parameter Name="Case_Number" Type="String" />
            <asp:Parameter Name="Case_Title" Type="String" />
            <asp:Parameter Name="Company_Source" Type="String" />
            <asp:Parameter Name="Geographic_Location" Type="String" />
            <asp:Parameter Name="Supervisor_name" Type="String" />
            <asp:Parameter Name="supervisor_Contact_Information" Type="String" />
            <asp:Parameter Name="Case_status" Type="String" />
            <asp:Parameter Name="Case_Synopsis" Type="String" />
            <asp:Parameter Name="Target_Course" Type="String" />
            <asp:Parameter Name="Target_program" Type="String" />
            <asp:Parameter Name="Instructors" Type="String" />
            <asp:Parameter Name="Instructors_contact_Info" Type="String" />
            <asp:Parameter Name="Date_Assigned_" DbType="Date"  />
            <asp:Parameter Name="Case_Length" Type="Int32" />
            <asp:Parameter Name="Revistion_Date"  DbType="Date" />
            <asp:Parameter Name="Subject_area" Type="String" />
            <asp:Parameter Name="Learning_Objectives" Type="String" />
            <asp:Parameter Name="Key_Words" Type="String" />
            <asp:Parameter Name="No_of_Modules" Type="Int32" />
            <asp:Parameter Name="Case_Implimentaion_Methods" Type="Boolean" />
            <asp:Parameter Name="Language" Type="String" />
            <asp:Parameter Name="Comment" Type="String" />
            <asp:Parameter Name="Multimedia_availablity" Type="Boolean" />
        </InsertParameters>

        <UpdateParameters>
            <asp:Parameter Name="Case_Writer" Type="String" />
            <asp:Parameter Name="Case_Number" Type="String" />
            <asp:Parameter Name="Case_Title" Type="String" />
            <asp:Parameter Name="Company_Source" Type="String" />
            <asp:Parameter Name="Geographic_Location" Type="String" />
            <asp:Parameter Name="Supervisor_name" Type="String" />
            <asp:Parameter Name="supervisor_Contact_Information" Type="String" />
            <asp:Parameter Name="Case_status" Type="String" />
            <asp:Parameter Name="Case_Synopsis" Type="String" />
            <asp:Parameter Name="Target_Course" Type="String" />
            <asp:Parameter Name="Target_program" Type="String" />
            <asp:Parameter Name="Instructors" Type="String" />
            <asp:Parameter Name="Instructors_contact_Info" Type="String" />
            <asp:Parameter DbType="Date" Name="Date_Assigned_" />
            <asp:Parameter Name="Case_Length" Type="Int32" />
            <asp:Parameter DbType="Date" Name="Revistion_Date" />
            <asp:Parameter Name="Subject_area" Type="String" />
            <asp:Parameter Name="Learning_Objectives" Type="String" />
            <asp:Parameter Name="Key_Words" Type="String" />
            <asp:Parameter Name="No_of_Modules" Type="Int32" />
            <asp:Parameter Name="Case_Implimentaion_Methods" Type="Boolean" />
            <asp:Parameter Name="Language" Type="String" />
            <asp:Parameter Name="Comment" Type="String" />
            <asp:Parameter Name="Multimedia_availablity" Type="Boolean" />
            <asp:Parameter Name="ID" Type="Int32" />
        </UpdateParameters>

    </asp:SqlDataSource>
</asp:Content>
Posted
Updated 17-Dec-11 16:07pm
v3
Comments
Wendelius 17-Dec-11 0:50am    
Pre tags added
Wendelius 17-Dec-11 1:09am    
This is the same question you sent a bit earlier. Should be removed.
Sunasara Imdadhusen 17-Dec-11 1:22am    
Please provide SQL code so we can check!
sriman.ch 17-Dec-11 5:42am    
the issue is related to your sql query, provide your sql query.....
Sergey Alexandrovich Kryukov 17-Dec-11 19:42pm    
Not a question; not enough information.
--SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900