i've created a dataset, and created inside it a datatable and its table adapter.
when i try to reference the table adapter in a .cs class i get an error message that i'm missing some namespace:
Compiler Error Message: CS0246: The type or namespace name 'DataSet1TableAdapters' could not be found (are you missing a using directive or an assembly reference?)
environment: W7ULT64, VS2008, SQL Express.I'm changing from an OLD (MSAccess, VS 2003) environment to SQL exp / VS2008!
Now I'm stuck with adding 'DataRows' using the 'DataSet.xsd'.
PS: the very last peace of code is just to test that I'm able to read the DB! I.e. I assume it's NOT a SQL issue!
Problem: (Vs2008)With below code I'm able to fill 'newRow' with the correct values! But because I do NOT have an 'add' mechanism
the '.update(newRow)' doesn't do anything (also no error!)
Problem: somehow I'm NOT able to find a way (intellisense!) to create the appropriate/correct statements to .add(newRow).
Code in VS2008:
Dim TherapieAdapter As New DataSetTherapieTableAdapters.therapieTableAdapter
Dim values As New DataSetTherapie.therapieDataTable
Dim newRow As DataSetTherapie.therapieRow = values.NewtherapieRow()[code]....
In my project's earlier version I used Stored Procedures (SPs) & directly used them inside presentation layer. SP contains multiple Insert & Update queries for multiple tables.
Now I have decided to use a DAL(Typed DataSets & TableAdapters)
How can i use the same SPs with TableAdapters or If not possible how to wrap Multiple TableAdapters inside Transactions.
1 more thing in my earlier version i was using Transaction in SPs & Presentation Layer.
I'm using VS 2008 and SQL 2008.
I have created the tables and the stored procedures in SQL 2008.
In VS 2008, I created DataSet1.xsd in App_Code and created the connectionString in web.config file.
Then when I go into the DataSet1.xsd and try to add a TableAdapter, strange things happened.
First I chose the data connection, then selected "Use existing stored procedure", then there was nothing listed in the dropdownlists (in Select, Insert, Update, or Delete).
I'm sure the connectionString is correct because if I choose "Use SQL statement" and type in a "select * from mytable1", the TableAdapter can be created without any problem.
I am using VS2005, and a newbie at table adapters, DAL & BLL. I have a single dataset (in DAL) and 2 classes (in BLL) named Class1.vb and Class2.vb.
When I try to call a function from Class1 within Class2 I get the error "Reference to a non-shared member requires an object reference".
Here is a sketch of my code structure:
[Code]....
am using class diagram of visual studio 2008as you can see the image i need show to user that the period and calendar classes have the idMarket property that refers to market classhow can i do this?
View 1 RepliesIs there a class library reference for the AJAX toolkit controls. I would like to see all of the properties and methods of the Accordian control.
View 4 RepliesI am really having a hard time trying to write something from scratch I created a 'Person' Class.Public Class Person
Private _FirstName As String = ""
Private _LastName As String = ""
Private _Age As Integer = 0
Public Sub New(ByVal FirstName As String, ByVal LastName As String, ByVal Age As Integer)
FirstName = FirstName
_LastName = LastName
_Age = Age
[code]...
I have two BLL classes ItemsBLL & BalanceBLL. When ever a new Items gets Added to Items table few details needs to be added to Balance Table.
I am using the following code to perform the operation, is this code efficient or something needs to be changed.
The function that needs to be checked is the Insert function in ItemsBLL Class.
[Code]....
Is this function effective?
[Code]....
[Code]....
In my initial cycle, I put the package configuration on a shared drive. This works great for my dev box and the dev db box, as they have the drive mapped in the same way.Unfortunately, the proposed production server has E mapped elsewhere. "Easy," I thought, "I'll just change to use the UNC version of that path."When I attempt to run the package on my development box, I get an error in BIDS that says it can't copy to the deployment utility output directory.This is wrong, as I delete the file, start the package, and it magically appears in my deployment/bin directory. Itdoes, in fact, copy the file, then has this error.I changed my reference back to the mapped drive, and the build works.
View 2 RepliesI'm trying to remove Sharepoint in its entirety from my server (2003). I've uninstalled Sharepoint, but in SQL Server Management Studio, I still have a reference to the OfficeServers database, in the dropdown, though I can't find it anywhere in the SQL Server folder hierarchy
View 1 RepliesHave a C# application. I have made reference to a vb class (.dll) called Cat_Feed_Export_to_JDE and I need to instantiate and call this class with a string parameter. I do not know C# and not sure how to code this.
Code:
public void HandleMessage(Object message)
{
Here, instantiate class and call with string parameter
}
I have a web site project where I need to use the System.Security.Cryptography.Xml.SignedXml class. I added the Dll System.Security as a reference and imported the namespace into my project. It compiles successfully but when I debug the project I get a compilation error:Compiler Error Message: BC30002: Type 'System.Security.Cryptography.Xml.SignedXml' is not defined.What gives?Edit: I run Windows XP Pro 64bit OS
View 1 RepliesI'm reading a bit of Pro ASP.NET MVC Framework and following a few tutorials written in the book. In the very first tutorial, creating a MVC site for dinner (PartyInvites), I encoutered this problem. While I try to reference some properties from Model class, the compilation error occured. Eg. the following code failed.
[Code]....
and the error message
Compiler Error Message:
CS1061: 'object' does not contain a definition for 'Name' and no extension method 'Name' accepting a first argument of type 'object' could be found (are you missing a using directive or an assembly reference?) I imported the Model folder into the controller too. I dunno what I'm missing here. Sorry, if it sounds a bit umm hard to understand cuz I just started picking up MVC this morning. Looking for any input.
I have downloaded Visual Web Developer 2010 Express and am trying to use LINQ. In order to do that I have added a LINQ to SQL class to the web site and have dragged tables from the database view into the LINQ designer, which worked fine.But..When I add: using System.Data.Linq;to MainPage.xaml.cs, I receive an error:
Error 3 The type or namespace name 'Data' does not exist in the namespace 'System' (are you missing an assembly reference?)Even although I have references to System.Core, System.Data, System.Data.Linq in the website references.
The whole bit about SQL Server is missing in the Add Reference window in :
Microsoft Visual Studio 2010
Version 10.0.30128.1 RC1Rel
Microsoft .NET Framework
Version 4.0.30128 RC1Rel
Installed Version: Ultimate
Microsoft Office Developer Tools 01019-315-4422943-70530
Microsoft Office Developer Tools
Microsoft Visual Basic 2010 01019-315-4422943-70530
Microsoft Visual Basic 2010
Microsoft Visual C# 2010 01019-315-4422943-70530
Microsoft Visual C# 2010
Microsoft Visual C++ 2010 01019-315-4422943-70530
Microsoft Visual C++ 2010
Microsoft Visual F# 2010 01019-315-4422943-70530
Microsoft Visual F# 2010
Microsoft Visual Studio 2010 Architecture and Modeling Tools 01019-315-4422943-70530
Microsoft Visual Studio 2010 Architecture and Modeling Tools
UML® and Unified Modeling Language™ are trademarks or registered trademarks of the Object Management Group, Inc. in the United States and other countries.
Microsoft Visual Studio 2010 Team Explorer 01019-315-4422943-70530
Microsoft Visual Studio 2010 Team Explorer
Microsoft Visual Studio Code Analysis Spell Checker 01019-315-4422943-70530
Microsoft Visual Studio Code Analysis Spell Checker
Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V. All rights reserved.
The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company. Electronic version licensed from Lernout & Hauspie Speech Products N.V. All rights reserved.
Microsoft Visual Web Developer 2010 01019-315-4422943-70530
Microsoft Visual Web Developer 2010
Crystal Reports Templates for Microsoft Visual Studio 2010
Crystal Reports Templates for Microsoft Visual Studio 2010
Microsoft Visual Studio 2010 SharePoint Developer Tools 10.0.30128
Microsoft Visual Studio 2010 SharePoint Developer Tools
Microsoft XNA Game Studio 4.0
Microsoft XNA Game Studio 4.0
Build 4.0.20304.
Where do I find them and how do I bring them into the IDE?
The DELETE statement conflicted with the REFERENCE constraint "FK_EquipmentStatus_MeetEquip". The conflict occurred in database "D:MEETINGROOMAPAPP_DATADATABASE.MDF", table "dbo.EquipmentStatus", column 'Fk_MeetEquip'.
I'm getting this error when i'm trying to delete a listboxitem. It's true that an other table (EquipmentStatus) is using the primary key attached to the listboxitem, but how can i delete all the rows that causes this problem? I've seen an example using stored procedure, but i dont understand it, since i haven't really worked with it before:
ALTER TABLE t2
DROP CONSTRAINT FK_t1id
ALTER TABLE t2
ADD CONSTRAINT FK_t1id FOREIGN KEY (t1id) REFERENCES t1 (t1id) ON DELETE
CASCADE
My listbox is using MeetEquip table which p-key is MeetEquip.ID, and the fk-key (which generates the problem) is fk_MeetEquip from EquipmentStatus table.
For a Table A defined in the DB like this:
A :{ id, selfId, name,} where selfId is a foreign key refered to Table A itself.
I generated the Entity automatically like this:
A :{ string id; A self; string name,} when i update the entity in gridview Edit/Update CommandField
i got the exception:
Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error:
[Code]....
Stack Trace:
[Code]....
I guess maybe this is caused by:
A is to be updated, and when the EntityDataSource construct the new A, the reference "self" is invalid at that moment. I do not want to modify my DB structure and do not want to lose the self reference, The event EntityDataSource_Updating is not triggered while the exception hit. so i can not access my entity at any time. Maybe the worst idea is deal the whole Update Procedure myself. However, is there any better workaround?
I have a Crystal report with a datasource of tables from two different typed datasets.
Two of the tables come from one typed ds, and one the other ds. They logically share a common key.
In the webform backend of the crystal report, I populate datatables using the methods of the respective tableadapters. Every time I run the report, it is prompting me for username and password info, which it then doesn't accept. The code to populate the dataset in the backend is as follows:
[Code]....
I'm trying to add a LINQ datasource to my ListView control but it doesn't pick up the data context that I created. All it shows as options in the dropdown list are AJAX objects. What could be the possible causes for this?
View 3 RepliesI receive the following error in the code below: System.NullReferenceException: Object reference not set to an instance of an object. When I am logged into the page I do not receive the error. My Code:
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub SqlDataSource4_Selecting(ByVal sender As Object, ByVal e As SqlDataSourceCommandEventArgs) Handles SqlDataSource4.Selecting
Dim MemUser As MembershipUser
MemUser = Membership.GetUser()
UserID.Text = MemUser.ProviderUserKey.ToString()
e.Command.Parameters("@UserId").Value = MemUser.ProviderUserKey.ToString()
End Sub
End Class
I read the following online: You are trying to use a reference variable who's value is Nothing/null. When the value is Nothing/null for the reference variable, that means it is not actually holding a reference to an instance of any object that exists on the heap. You either never assigned something to the variable, never created an instance of the value assigned to the variable, or you set the variable equal to Nothing/null manually, or you called a function that set the variableto Nothing/null for you. The following is the Arthur's code example and his suggested fix which I am sure is right:
Private Sub TestString()
Dim a As String
If a.Length = 0 Then
Console.Write("Yes")
End If
End Sub
I am writing an application that does it's own logging in a SQL table. On each page, I statically assign this variable: Dim page = "page_01.aspx" I've noticed that page is ALWAYS equal to the name of the Partial Class of the code-behind + the suffix ".aspx" Is there any way to programatically set the string to equal the name of the Partial Class, so I don't have to statically code it on each page? Basically, I want to assign the name of the current class to a string, and append ".aspx" to it. Can I do this, or does that get lost in the compilation?
View 1 RepliesWhy do we use the reference of abstract class (or base class) to create object of it's sub-class. eg: TextWriter is the abstract class for StreamWriter & StreamWriter.
TextWriter writer = new StreamWriter();
why can't we simply use :
StreamWriter writer = new StreamWriter();
i have 2 class file business logic layer in c sharp but my application is in vb.net ie my code (aspx.vb) file contains the code for th epage is it possible to reference the same csharp class files in the .aspx.vb file.
View 12 RepliesI'm working on an internet application that has been set up as a web SITE project (I know...) in Visual Studio. I need to add additional features/functionality so have added a class library to the project and referred to it in the main web site project.
The issue now arises because I need to make use of core objects which live inside the App_Code directory in the web site project but this project doesn't appear to expose its DLL like web app/ code library projects do. Because of this I can't add a reference to the web site project in the class library to leverage the common site-wide code/objects.
I can't move the stuff out of App_Code so I'm looking for a way to refer to the website project dll from the new class library.