DataSource Controls :: Error Accesing BLL In WAP With 2 Projects?
Jan 31, 2011
I have a solution with 2 projects:mainProject with all the forms dataProject with the BLL and DAL code for data access.the issue is, if a put a sample from on the dataProject with a grid to display info. from a table (througth BLL object) works fine,but, if I try to access data from mainProject with the same grid and BLL object, I get an execution error specifing that
"The object doesnt exist PagosActividades" (Where PagosActividades is the tableName, used in GetPagoActividadPorID )
'THIS CODE IS IN dataProject BLL
[code]...
View 1 Replies
Similar Messages:
Jan 31, 2011
I just moved to a new PC and installed VS 2010. I copied all of my websites over from the old machine and now when I open the old websites on the new machine, they do not show up in my recent projects list on the start page. New websites that I make do show up there but the old ones do not. This is very inconvenient. Is there a way to make old projects that I open show up in the list?
This brings up another question. Is there a way to make a shortcut that will open VS2010 up with a website already loaded so that I don't have to go through the file open dialog every time?
View 3 Replies
Jul 29, 2010
I've seen some teams that start breaking into multiple projects from the beginning and others build behemoth single projects. The large project teams say that one massive project is easier to maintain than multiple smaller projects.
View 4 Replies
Apr 8, 2010
I have a FormView component, that includes an EditItemTemplate. From my code behind, i would like to access some of the components that are children from this EditItemTemplate. I tried with FindComponent() but it doesnt seems to work.
View 2 Replies
Nov 23, 2010
So I've create a solution with multiple projects... one is for my website, the other for my data. I've added the reference and everything seems to be working just fine. Until now...
I recently created a model.edmx for a table and a stored procedure. When I trying and create a variable of that model, I get this error:
The type 'System.Data.Objects.ObjectContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
I'm assuming this is because I'm using multiple projects.
View 2 Replies
Nov 1, 2010
I need to create a sample project (for educational purposes) and I'm faced with the choice between Web Site Projects or Web Application Projects. This feels similar to the choice between C# and VB. My question isn't about the differences between these 2 choices, but rather which is more popular (relevant, recognizable) to the general ASP.NET community.Has anyone seen any statistics in terms of adoption/usage of these 2 different project types? What project type should I use to reach the widest audience?Update: I created a poll on this subject - http://poll.fm/2e6cy
View 4 Replies
Jun 7, 2010
I have a multi-tiered application. I would like to publish the class libraries to UI developers to let them add to their web or windows projects to add all the functionality.
I would like to restrict access so only a certain project can be referenced. The reason is so that they do not refer to the data access layer directly and start making calls that would bypass the business logic built into the business tier.
UI->>Business Logic->>Data Access
So in other words, BL and DA are deployed as compiled assemblies. BL references DA. UI will reference BL, but I would like to strictly prevent any other project from referencing DA directly.
View 1 Replies
May 25, 2010
When I upgraded my Web Deployment Project from VS2008 to the VS2010 beta version, I was able to execute the build locally on my development box. However, when I tried to execute the build on our TeamCity build server, I began getting the following exception:
[code]....
View 1 Replies
Jun 6, 2010
Error:
Executed as user: MACSTEELUSA.COMsa. ...9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:17 PM Error: 2010-06-02 20:00:18.56 Code: 0xC0202009 Source: CRM_ORACLE_ARSUMMARY Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle client
and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.". End Error Error: 2010-06-02 20:00:18.58 Code: 0xC020801C Source: Data Flow Task Source - Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireCon... The package execution fa... The step failed.
Tasks Taken:Went to this folder checked for tnsnames.ora file but it is in good shape.
C:ORACLEproduct11.2.0client_1
etworkadmin
View 2 Replies
Dec 6, 2010
The request failed with HTTP status 401: Unauthorized.accesing the server report in ssrs2008
View 2 Replies
Dec 21, 2010
Basically what I am trying to do is have my webpage project folder located directly on my local machine (ex. Local #1). Our database is located on a server (ex. Server #1) . I am building my web applications on my local machine and then trying to debug them in Visual Studio 2008. Only every single time I click to debug my project I get a "Security Exception" error that looks something like the following...
"Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.
Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."
I'm somewhat leaning towards the fact that I need to connect to the database to pull information from it and I don't have the proper permissions is the reason why this is happening but I've also read that it can be something that deals with improper configuration of my Web.Config file (i.e. I do not have something enabled).
Note #1: A co-worker of mine is having the same problem if he tries to put the project locally and then debug it. He has full administrative access to the DB and everything else.
View 6 Replies
Apr 15, 2010
im working with visualstudio 2005 and sql server 2005 c#,and i tried to insert an items to the sql but it gave me this error
Application server error '/ WebSite6'.
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_StudentToCourse_Students".The conflict occurred in database "TopseaUser", table "dbo.Students", column 'id'.
The statement has been terminated.Description: The exception is unhandled occurred during the implementation of the current web request. the stack trace for more information about the error and where the source code.
Details exception: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_StudentToCourse_Students". The conflict occurred in database "TopseaUser", table "dbo.Students", column 'id'.The statement has been terminated.
This error: Line 243: sql_comm.Parameters.AddWithValue ("@ studentId", Convert.ToInt32 (id));
Line 244: sql_comm.Parameters.AddWithValue ("@ CourseId", Convert.ToInt32 (ListBox3.Items [j]. Text.ToString
()));
Line 245: sql_comm.ExecuteNonQuery ();
Line 246: split_listbox2 ();
Line 247: sql_conn.Close ();
Source File: c: Documents and Settings Ronen My Documents Visual Studio 2005 WebSites WebSite6 SiteMembers CourseSignUp.aspx.cs line: 245
this it the code :[Code].... !
View 7 Replies
Mar 24, 2010
I have written some vb code that inserts whatever has been written on my page into an Access database. Only problem is VWD throws up an error saying that the syntax of my SQL statement is wrong. I am 95% sure that this statement is correct because when I saw the statement in Text Visualizer and tried that statement in MYSQL the data went in perfectly.
I have pasted the code below:
strSQL = "INSERT INTO User (UserID, FirstName, LastName, Password) VALUES "
View 27 Replies
Apr 22, 2010
Following is the error I am getting while accessing some of the pages on my website.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
It is trowing an exception and giving the about mentioned error.
View 5 Replies
Feb 28, 2010
i get error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
View 4 Replies
Jun 19, 2010
I have a website which displays news information. It displays the titles at the default (home) page and when click it shows the full story.
I use object datasource to load the news titles.
Now, sometimes the database server lose its connection or changes to the database and it affects the whole website because error is reported at the Application level. I would like the Home page to still show but the section where the news titles usually appears will now show an error message that the database is down (Refer below my part of my code).
How can I achieve that?? I tried to do that at the page_error level but it displays nothing. I don't want to pass the error to application level, I want to handle at datasource load/binding level so that it display this error message at the news section and other home website information can still be shown.
[Code]....
View 1 Replies
May 10, 2010
I used visual studio 2008 and sql server 2005(for database) in my website project. After finishing my project i used publish to web option and got the files into an folder. I have installed .NET framework ,IIS, i have also set the remote connection ,firewall setting etc. But when i run i.e., In the IIS manager when i click browse it gives me the following error. Can anyone pls tell me what went wrong in this. My code works fine when run on visual studio 2008. Server Error in '/EBUSINESS' Application.
View 1 Replies
Dec 10, 2010
I have a piece of code that is just HTML. It was previously created as a user control. Within the application i'm working with there are two seperate websites that are interlinked to make one website. There is a documents section where users do not need to login and a data section where users need to login. The design was implemented long before I was hired. My problem is I want to use the code from the documents website with the data website but I can't seem to register the control. I only one this piece of code in one place so when it is updated it doesn't have to be in multiple places. I tried setting "src=http://website/doc/doc.ascx" but this errors out saying
<%@ Register Src="http://website/doc/doc.ascx" TagName="docs" TagPrefix="temp" %>
Parser Error Message: The file '/documents/http://website/doc/doc.ascx' does not exist.
It adds the directory as part of the src. How can I have it point to this location http://website/doc/doc.ascx ?
View 7 Replies
Jan 27, 2010
Can anyone tell me why I get this error:
I'm trying to output my query results:
SELECT * FROM sites LEFT JOIN pages ON sites.siteid=pages.siteid LEFT JOIN subpages ON Pages.pageid=subpages.pageid WHERE sites.siteID = 1 ORDER BY sites.siteid ASC
using the code:
[code]....
Source Error:
[Code]....
Line 35: Line 36: While reader.Read()Line 37: mydata &= reader.Item("sitename") & " " & reader.Item("pageid") & " " & reader.Item("pagetitle") & "<br>" & reader.Item("subpages.pageid")Line 38: Line 39:
View 14 Replies
Jun 23, 2010
I am getting this error on my Web Server
Event code: 3005, An Unhandled exception has occurred, Event ID 1309
Application domain: /LM/W3SVC/1/Root/GLI Survey-1-129217809326257882, Trust Level: full, application Virtual Path /GLI Survey, Application path c:inetpubwwrootGLI SURVEY, Machine name: WEBSVR
Here is my SQL Data source parameter:
<
top: -197px"
asp:Label
ID="Label3"
runat="server"
CssClass="Label"
Style="left: -304px; position: relative;
Text="On a scale of 0-5 how would you rate:"></asp:Label><asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
ConnectionString="Integrated Security=SSPI;Persist Security Info=False;database=GLIPurchasingSales;Data Source=sqlsvr"
VALUES (@Branch, CONVERT(Varchar(12), GetDate(), 1), @fatigue, @Q1, @Q2, @Q3, @Q4, @Q5, @Q6, @Q7, @Name, @Company, @Comments, @Recommend, @ConComments)"
InsertCommand="INSERT INTO PurchasingSales([Branch], dt, fatigue, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Name, Company, comments,
Recommend, ConComments)
ProviderName="System.Data.SqlClient">
<InsertParameters>
<asp:ControlParameter
ControlID="ddlfatigue"
Name="fatigue"
PropertyName="SelectedValue"
/>
<asp:ControlParameter
ControlID="ddlQ1"
Name="Q1"
PropertyName="SelectedValue"
/>
<asp:ControlParameter
ControlID="ddlQ2"
Name="Q2"
PropertyName="SelectedValue"
/>
<asp:ControlParameter
ControlID="ddlQ3"
Name="Q3"
PropertyName="SelectedValue"
/>
<asp:ControlParameter
ControlID="ddlQ4"
Name="Q4"
PropertyName="SelectedValue"
/>
<asp:ControlParameter
ControlID="ddlQ5"
Name="Q5"
PropertyName="SelectedValue"
/>
<asp:ControlParameter
ControlID="ddlQ6"
Name="Q6"
PropertyName="SelectedValue"
/>
<asp:ControlParameter
ControlID="ddlQ7"
Name="Q7"
PropertyName="SelectedValue"
/>
<asp:ControlParameter
ControlID="txtBranch"
Name="Branch"
PropertyName="Text"
/>
<asp:ControlParameter
ControlID="txtName"
Name="Name"
PropertyName="Text"
/>
<asp:ControlParameter
ControlID="txtCompany"
Name="Company"
PropertyName="Text"
/>
<asp:ControlParameter
ControlID="txtComment"
Name="Comments"
PropertyName="Text"
/>
<asp:ControlParameter
ControlID="ddlRecommend"
Name="Recommend"
PropertyName="SelectedValue"
/>
<asp:ControlParameter
ControlID="ddlComments"
Name="ConComments"
PropertyName="SelectedValue"
/>
</InsertParameters>
</asp:SqlDataSource>
This is not occurring for all users. If you need the structure of the database please let me know.
View 1 Replies
Jan 2, 2010
I am getting error messages for the last two lines of the following button click event handler code where I am attempting to create a new record in my Profiles table with 3 column entries:
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
string Callsign = Server.HtmlEncode(Textbox1.Text);
string Password = Server.HtmlEncode(Textbox2.Text);
string Email = Server.HtmlEncode(TextBox3.Text);
DataClassesDataContext db = new DataClassesDataContext();
Profile profile = new Profile();
profile.Callsign = Callsign;
profile.Password = Password;
profile.Email = Email;
db.Profiles.Add(profile);
db.SubmitChanges(profile);
}
The first error message refers to the "Add" statement in the second to last line. It states, 'Syatem.Data.Linq.Table<Profile>' does not contain a definition for 'Add'. The last 2 errors refer to the last line. They state "The best overloaded method match
for 'Syatem.Data.Linq.DataContext.SubmitChanges(Syatem.Data.Linq.ConflictMode)' has some invalid arguments" and "Argument '1': cannot convert from 'profile' to 'Syatem.Data.Linq. ConflictMode'".
View 3 Replies
Mar 29, 2011
Dim connStr As String = " Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=W:PatioOrderApp_DataPatio.mdb"
Dim con As New OleDb.OleDbConnection(connStr)
Dim instr As String = " INSERT INTO tOrders([first_name],[last_name],[order],[comment]) Valuse(?,?,?,?)"
If IsValid Then
Using con
Using cmd As New OleDb.OleDbCommand(instr, con)
cmd.CommandType = CommandType.Text
cmd.Parameters.AddWithValue("first_name", DBNull.Value)
cmd.Parameters.AddWithValue("last_name", DBNull.Value)
cmd.Parameters.AddWithValue("order", DBNull.Value)
cmd.Parameters.AddWithValue("comment", menuDrinks.SelectedItem.ToString)
con.Open()
cmd.ExecuteNonQuery()
End Using
End Using
con.Close()
End If
View 1 Replies
Jan 9, 2010
I suing this code to upload csv file data to sql table.
BULK
INSERT uploadtemp
FROM 'F:ArruniArruniRaj-NathanSchoolcvsparents_with_pupil_adm_nos.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '
'
)
END
After i upload data each and every data inside double quatation like
"Mr J and Mrs P Abbott"
"Abbott"
"Gemma"
"N00390"
"Olivia Abbott"
"N00595"
"T"
How can i upload data without " . And also i want start upload data start from second row. How can i do that? [URL]
View 1 Replies
Feb 9, 2010
I am using the SQLDataReader to execute a Stored Procedure that accepts two parameters (BuildingTID and Department) to return the appropritae Value in my case The Director of the Department. My problem is I get the following error when I run the code that I added below for review. Let me also add that the user is selecting the values that I am using for the stored procedure from 2 DropDownLists. I am getting it when I try to assign the value that is in the Department DropDown
list to the first parameter.
Dim myParm As SqlParameter = getDirectorsCMD.Parameters.Add("@BuildingTID", SqlDbType.Int, 15).Value = (ddlDepartment.SelectedValue)
Also obviously there are more issues with my code than just the error because the datareader records property is false meaning I am not returning a row
View 12 Replies
Apr 27, 2010
[Code]....
Stack Trace:
[Code]....
[code]....
getting Incorrect syntax near error
View 2 Replies
