DataSource Controls :: Insert An Items To The Sql Gives Error Application Server Error '/ WebSite6'
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
Similar Messages:
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
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 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
Apr 9, 2010
I can't find my syntax error. Here is my code behind:
[Code]....
View 3 Replies
Jan 31, 2010
I have uploaded all files to my server. and while im checking the site it shows the following error." Server Error in '/' Application. Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster,ensure that <machineKey> configuration specifies the same validationKey"what i have to do/how to fix it.
View 3 Replies
Aug 7, 2010
I have hosted a service in the IIS server, while consuming the service i am getting some error. I have mentioned the error code below.
Error code:
Server Error in '/' Application.
The type 'EchoTunnelService.EchoService', provided as the Service attribute value in the ServiceHost directive could not be found.
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: The type 'EchoTunnelService.EchoService', provided as the Service attribute value in the ServiceHost directive could not be found.
Source Error: [Code]....
Version Information: Microsoft .NET Framework Version:2.0.50727.3607; ASP.NET Version:2.0.50727.3614
View 1 Replies
May 5, 2010
Server Error in '/' Application. Attempted to read or write protected memory. This is often an indication that other memory is corrupt.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.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[code]....
View 1 Replies
Oct 2, 2010
created website in VS2008 with createuser and login page.I was able to run the createuser page, but while trying to run the login page i received error:Server Error in '/' application.resources not found.
View 1 Replies
May 12, 2010
I got this error
Description:
An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message:
Default Role Provider could not be found.
Source Error:
[Code]....
Source File: C:utvPlaygroundxxxweb.config Line: 44
I have OS windows 7(64 bits), Visual studio 2008 and Oracle 11g I have run "InstallAllOracleASPNETProviders.sql" who comes with the Oracle installation. When I run in debug I can run this application, but not otherwise. And in IIS manager, I can't se the Oracle provider? Version Information: Microsoft .NET Framework Version:2.0.50727.4927; ASP.NET Version:2.0.50727.4927
View 2 Replies
Dec 6, 2010
//Server Error in '/ECommerceWebSite' Application. Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.TypeLoadException: Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [TypeLoadException: Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.] AjaxControlToolkit.ToolkitScriptManager.OnResolveScriptReference(ScriptReferenceEventArgs e) in d:hgactServerAjaxControlToolkitToolkitScriptManagerToolkitScriptManager.cs:276 System.Web.UI.ScriptManager.RegisterScripts() +261 System.Web.UI.ScriptManager.OnPagePreRenderComplete(Object sender, EventArgs e) +117 System.Web.UI.Page.OnPreRenderComplete(EventArgs e) +2063008 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2247 Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
i am using ajax modal popup control and when i run my web page i am getting this error....
View 4 Replies
Feb 5, 2010
On one server I have my ASP.NET 3.5 website running just fine. That server is the one we use for testing (IIS6 with ASP.NET 2.0.50727). I went to the live server where ASP.NET is also installed (IIS6 with ASP.NET 2.0.50727). I right-clicked on the folder I wanted my website to go in, and I set it as an application in IIS. But when I go to the website on the live server, I get the Runtime Error. Like the error told me to do, customErrors mode is "Off" in the web.config file. I even changed authentication mode to "None" (it was set to Windows on the test server). Yet I still get this error. Is there something I should change about the web.config file? Is there something I should check in IIS?
For reference, here is the full error message. Server Error in '/' Application. Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
[Code]....
View 8 Replies
Feb 3, 2011
i am experiencing thi error when i click on the application in the remote machine.
Server Error in '/please-god' Application.
Security Exception 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.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Source Error:
Line 7: Dim oBF As New BinaryFormatter()
Line 8: Dim oFS As FileStream
Line 9: Dim strPath As String = Path.GetTempPath & "schedule.Bin"
Line 10:
Line 11: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Source File: D:Hosting4423045htmlplease-godappointmentscheduler.aspx.vb Line: 9
the full codes for the application is this :
Imports System.IO
Imports System.Runtime.Serialization.Formatters.Binary
Partial Class appointmentscheduler
Inherits System.Web.UI.Page
Dim arrCalendar(12, 31) As String
Dim oBF As New BinaryFormatter()
Dim oFS As FileStream
Dim strPath As String = Path.GetTempPath & "schedule.Bin"
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If (Cache("arrCalendar") Is Nothing) Then
If (File.Exists(strPath)) Then
oFS = New FileStream(strPath, FileMode.Open)
arrCalendar = DirectCast(oBF.Deserialize(oFS), Array)
oFS.Close()
Cache("arrCalendar") = arrCalendar
End If
Else
arrCalendar = Cache("arrCalendar")
End If
End Sub
Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSave.Click
arrCalendar(Me.myCalendar.SelectedDate.Month, Me.myCalendar.SelectedDate.Day) = Me.myNotes.Text
oFS = New FileStream(strPath, FileMode.Create)
oBF.Serialize(oFS, arrCalendar)
oFS.Close()
Cache("arrCalendar") = arrCalendar
End Sub
Protected Sub btnDelete_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDelete.Click
arrCalendar(Me.myCalendar.SelectedDate.Month, Me.myCalendar.SelectedDate.Day) = ""
oFS = New FileStream(strPath, FileMode.Create)
oBF.Serialize(oFS, arrCalendar)
oFS.Close()
Cache("arrCalendar") = arrCalendar
Me.myNotes.Text = ""
End Sub
Protected Sub myCalendar_DayRender(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DayRenderEventArgs) Handles myCalendar.DayRender
If arrCalendar(e.Day.Date.Month, e.Day.Date.Day) <> "" Then
e.Cell.BackColor = Drawing.Color.Red
End If
End Sub
Protected Sub myCalendar_SelectionChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles myCalendar.SelectionChanged
Me.myNotes.Text = ""
If arrCalendar(Me.myCalendar.SelectedDate.Month, Me.myCalendar.SelectedDate.Day) <> "" Then
Me.myNotes.Text = arrCalendar(Me.myCalendar.SelectedDate.Month, Me.myCalendar.SelectedDate.Day)
End If
End Sub
End Class
What do i have to do to eliminate this error message?
View 2 Replies
Mar 19, 2010
I am trying to deploy a simple page that just has 3 textboxes and a button that calculates 2 numbers.I copied the site to my server and when I try to go to the site throught IE I get the error below. How do I reslove this runtime error?
Server Error in '/' Application.
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
[Code]....
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
[Code]....
View 1 Replies
Apr 6, 2010
when i try to login i get this error Server Error in '/' Application.
Index was outside the bounds of the array.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.
Source Error: [Code]....
Stack Trace: [Code]....
[IndexOutOfRangeException: Index was outside the bounds of the array.] login.ImageButton3_Click(Object sender, ImageClickEventArgs e) +775 System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +86 System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
View 23 Replies
Feb 28, 2010
i would like to insert a picture on a gridview, but i allways get the error:
Must declare the scalar variable "@IMAGEM"
somme one can on tihs code ? here is my code:
[code]....
View 13 Replies
May 11, 2010
when i want insert a record i see an error like this Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key. with this codes:
MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext();
MainMenuLink li = new MainMenuLink { Link = "www.tprogrammer.com", LinkSubject = "subject" };
db.MainMenuLinks.InsertOnSubmit(li); [code]....
View 2 Replies
Mar 18, 2010
I am trying to use the TableApapterManager.UpdateAll to insert values to master and child table. I had set the relation to cascade for update in the dataset and the HierarchicalUpdate to true. But stil when I run TableApapterManager.UpdateAll(dataset), I get a foriegn key violation error. Following is the code I used:
int ID;
DAL.Datasets.dsMembers.MembersRow rwMem = m_dsMembers.Members.NewMembersRow();
rwMem.u_name = mem.Name;
m_dsMembers.Members.AddMembersRow(rwMem);
DAL.Datasets.dsMembers.MemPhonesRow rwmemphn = null;
rwmemphn = m_dsMembers.MemPhones.NewMemPhonesRow();
rwmemphn.u_memberid = ID;
rwmemphn.u_phn = "test";
m_dsMembers.MemPhones.AddMemPhonesRow(rwmemphn);
m_adpMgr.UpdateAll(m_dsMembers);
return ID;
The error I get is "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MemPhones_Members". The conflict occurred in database "Family", table "dbo.Members", column 'i_memeberid'.
The statement has been terminated."
View 2 Replies
Jul 8, 2010
I recently converted a web application of ours to VS 2008 so that we could upgrade to .net 3.51 framework.
I have been making some changes to the layout, to take advantage of ajax and minimize the amout of data needing to be loaded and the number of postbacks processed.
The problem I am having is when I try to save the data.
The page postback calls a local Sub which reads the form data into local variables and then passes these variables to our assembly.
The primary assembly has 70 parameters which are used to populate one of the tables in our database.
So I have 70 local variables just for this call plus a variable reference to the output of the assembly which contains a property for each of the columns in the associated database record.
There are some additional assemblies called to update other tables so, in all there are 121 locally defined variables in this sub.
Bear in mind that this sub is called from the page load event which has 93 of it's own locally declared variables.
Here is what is happening, when I run the code I am using cdate() to convert the value of a text box to datetime and pass it to my assembly. When doing so it throws a conversion error.
So I created a local datetime variable and converted the value of the control to the datetime and passed the variable to the assembly.
No more error, but the proc did not save the data as it was supposed to.
What I noticed in debugging, on the locals tab, is that every local datetime variable displayed the following message:
Cannot evaluate expression because we are stopped in a place where garbage collection is impossible, possibly because the code of the current method may be optimized
I also noticed that on the watch window the same message would display if I attempted to reference any of the datetime controls on the form.
There are only 3 variables and 3 datetime controls that appear to be affected. the controls are all html input boxes. Every other variable and control on the form behaves normally and I can see their values while debugging, it is just these six that are exhibiting the problem, whats more is that they are not new controls to the form.
View 1 Replies
Mar 5, 2010
Not sure why it works if i connect to SQL 2005 on another server, but now that i have SQL Express on the same server as the pages, im getting the following error: I have attached my connection string within my web.config and also how its being called within the code behind. Now this page was written by another programmer some time back.. so not sure if the method he used to do this is the best or only way. But i have connected to other SQL database with other applications with alot less code.
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)
Source Error: Line 131:
Line 132: //connect to this sql server
Line 133: c.Open(); -----> this is the line it complains about.[Code]....
View 8 Replies
Apr 22, 2010
everything .net works fine, but when i try to run a .asp file i get this error: Server Error in '/xx' Application. This type of page is not served. Description: The type of page you have requested is not served because it has been explicitly forbidden. The extension '.asp' may be incorrect. Please review the URL below and make sure that it is spelled correctly. Requested URL: /index.asp Version Information: Microsoft .NET Framework Version:2.0.50727.3607; ASP.NET Version:2.0.50727.3082 is there something i need to enable?
View 3 Replies
May 17, 2010
i am trying to install SQL Server R2 on my windows 2003 server (I downloaded the x64 version) but on the installation directory, just before i click next, to get the error, the path is as follows: C:ProgramFiles(x86)Microsoft Sql Server im not too sure if thats the problem though, just guessing, since i dont know anyother problem, and its a new server. I also tried multiple server restarts and still got the same error.
View 6 Replies
Apr 1, 2010
When ever I try to connect to server through Microsoft sql server management studio express then an error is generated saying that
Cannot connect to .//SQLEXPRESS
Additional Information
A network related or instance specfic error occured while connecting to SQL server. The server not found or not accessible verify that instance name is correct and that SQL server is configured to allow remote connections.(Provider: Named Pipes Provider, error 40-could not open connection to SQL server )(Microsoft SQL server, Error:53)
View 5 Replies
