I am using SqlServer 2008 when ever I execute following query
[Code]...
I get error: error is mentioned in subject part.after this error connection is automatically closed.
I am facing the following problem when i try to add record in database. "System.Data.SqlClient.SqlException: A severe error occurred on the current command.The results, if any, should be discarded." This exception occurs occasionally, and the sql server log shows the following error whenever the above exception occurs:
Server,Unknown,A user request from the session with SPID 54 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
I have develop a function in which insert textbox value and grid view value into database.
Problem is that my web method call but it will add some time value into database and give me the following error. Its work once time other can’t work.
An error occurred while executing the command definition. See the inner exception for details.
function addData() {
debugger;
var Customers = new Array();
var desigantion = $("#TextBox4").val();
$('[id*=GridView1]').find('tr:has(td)').each(function () {
var Customer = {};
[Code] ....
My web method
public class Customerdata {
public string code { get; set; }
public string Product { get; set; }
public string Rate { get; set; }
[Code] ....
After once time run then it give me an error.
An error occurred while executing the command definition. See the inner exception for details.
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.
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 RepliesI am getting System.OutOfMemoryException exception in my Web Application (ASP.NEt with C# and MySql ) hosted on IIS.
The problem is popping up randomly once every few days when i enter username and password to enter..
What is the actual reason of this Error and suggest somthing to kill this problem permanently..
Server Error in '/' Application.
Exception of type 'System.OutOfMemoryException' was thrown.
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.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
Source Error:
[Code]....
I recently bought domain and hosting from godaddy.com and uploaded my website files based on asp.net on server.
The problem is when i run Default.aspx file in visual studio it runs properly but same set set of files when ran after uploading on server gives error in web.config file.
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".
<?xml version="1.0"?>
<!--
Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
WindowsMicrosoft.NetFrameworkv2.xConfig
-->
[Code] ....
I have built a webform as part of my project that grabs all the data out of a particular table in an Access database on the server. I have allowed the ability to update said table via the DetailsView form however when you change the details and then click on "update" it throws back an error.
No value given for one or more required parameters.
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.Data.OleDb.OleDbException: No value given for one or more required parameters.
Source Error:
[Code]....
Stack Trace:
[Code]....
I am not sure what has happened but it simply will not allow me to update any data. Here is a copy of the select, update and delete statement.
<asp:AccessDataSource
ID="UserDetails"
runat="server"
ConflictDetection="CompareAllValues"
DataFile="\xxx.xxx.xx.xxDatabaseCSBEDBv1.0_be.mdb"
DeleteCommand="DELETE FROM [tbl_mmstafflist] WHERE [EngID] = ? AND (([EngCode] = ?) OR ([EngCode] IS NULL AND ? IS NULL))
AND (([EngName] = ?) OR ([EngName] IS NULL AND ? IS NULL)) AND (([EmailAddress] = ?) OR ([EmailAddress] IS NULL AND ? IS NULL)) AND (([Ext No] = ?) OR ([Ext No] IS NULL AND ? IS NULL)) AND (([Mobile No] = ?) OR ([Mobile No] IS NULL AND ? IS NULL)) AND (([Home
No] = ?) OR ([Home No] IS NULL AND ? IS NULL)) AND (([Address 1] = ?) OR ([Address 1] IS NULL AND ? IS NULL)) AND (([Address 2] = ?) OR ([Address 2] IS NULL AND ? IS NULL)) AND (([Address 3] = ?) OR ([Address 3] IS NULL AND ? IS NULL)) AND (([Town] = ?) OR
([Town] IS NULL AND ? IS NULL)) AND (([County] = ?) OR ([County] IS NULL AND ? IS NULL)) AND (([Postcode] = ?) OR ([Postcode] IS NULL AND ? IS NULL)) AND (([Other email address] = ?) OR ([Other email address] IS NULL AND ? IS NULL)) AND [Visa card] = ? AND
[Ex staff] = ? AND (([ExternalDirectDialNumber] = ?) OR ([ExternalDirectDialNumber] IS NULL AND ? IS NULL)) AND (([PayrollNumber] = ?) OR ([PayrollNumber] IS NULL AND ? IS NULL)) AND [NeedstoSeekApproval] = ? AND [IsStockController] = ? AND (([Group] = ?)
OR ([Group] IS NULL AND ? IS NULL)) AND (([ContractedWeeklyHours] = ?) OR ([ContractedWeeklyHours] IS NULL AND ? IS NULL)) AND (([Grade] = ?) OR ([Grade] IS NULL AND ? IS NULL)) AND (([IP] = ?) OR ([IP] IS NULL AND ? IS NULL)) AND (([StaffTitle] = ?) OR ([StaffTitle]
IS NULL AND ? IS NULL))"
InsertCommand="INSERT INTO [tbl_mmstafflist] ([EngID], [EngCode], [EngName], [EmailAddress], [Ext No], [Mobile No],
[Home No], [Address 1], [Address 2], [Address 3], [Town], [County], [Postcode], [Other email address], [Visa card], [Ex staff], [ExternalDirectDialNumber], [PayrollNumber], [NeedstoSeekApproval], [IsStockController], [Group], [ContractedWeeklyHours], [Grade],
[IP], [StaffTitle]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT * FROM [tbl_mmstafflist] where ([EngID] = @EngID)"
UpdateCommand
="UPDATE [tbl_mmstafflist] SET [EngCode] = ?, [EngName] = ?, [EmailAddress] = ?, [Ext No] = ?, [Mobile No] = ?, [Home No] = ?, [Address 1] = ?, [Address 2] = ?, [Address 3] = ?, [Town] = ?, [County]
= ?, [Postcode] = ?, [Other email address] = ?, [Visa card] = ?, [Ex staff] = ?, [ExternalDirectDialNumber] = ?, [PayrollNumber] = ?, [NeedstoSeekApproval] = ?, [IsStockController] = ?, [Group] = ?, [ContractedWeeklyHours] = ?, [Grade] = ?, [IP] = ?, [StaffTitle]
= ? WHERE [EngID] = ? AND (([EngCode] = ?) OR ([EngCode] IS NULL AND ? IS NULL)) AND (([EngName] = ?) OR ([EngName] IS NULL AND ? IS NULL)) AND (([EmailAddress] = ?) OR ([EmailAddress] IS NULL AND ? IS NULL)) AND (([Ext No] = ?) OR ([Ext No] IS NULL AND ?
IS NULL)) AND (([Mobile No] = ?) OR ([Mobile No] IS NULL AND ? IS NULL)) AND (([Home No] = ?) OR ([Home No] IS NULL AND ? IS NULL)) AND (([Address 1] = ?) OR ([Address 1] IS NULL AND ? IS NULL)) AND (([Address 2] = ?) OR ([Address 2] IS NULL AND ? IS NULL))
AND (([Address 3] = ?) OR ([Address 3] IS NULL AND ? IS NULL)) AND (([Town] = ?) OR ([Town] IS NULL AND ? IS NULL)) AND (([County] = ?) OR ([County] IS NULL AND ? IS NULL)) AND (([Postcode] = ?) OR ([Postcode] IS NULL AND ? IS NULL)) AND (([Other email address]
= ?) OR ([Other email address] IS NULL AND ? IS NULL)) AND [Visa card] = ? AND [Ex staff] = ? AND (([ExternalDirectDialNumber] = ?) OR ([ExternalDirectDialNumber] IS NULL AND ? IS NULL)) AND (([PayrollNumber] = ?) OR ([PayrollNumber] IS NULL AND ? IS NULL))
AND [NeedstoSeekApproval] = ? AND [IsStockController] = ? AND (([Group] = ?) OR ([Group] IS NULL AND ? IS NULL)) AND (([ContractedWeeklyHours] = ?) OR ([ContractedWeeklyHours] IS NULL AND ? IS NULL)) AND (([Grade] = ?) OR ([Grade] IS NULL AND ? IS NULL)) AND
(([IP] = ?) OR ([IP] IS NULL AND ? IS NULL)) AND (([StaffTitle] = ?) OR ([StaffTitle] IS NULL AND ? IS NULL))">
<SelectParameters>
<asp:QueryStringParameter
Name="EngID"
QueryStringField="EngID"
Type="Decimal"
/>
</SelectParameters>
The SelectParameter is used because this page is a details page that is selected from a list. I would appreciate any help that you can offer. Unfortunately Access errors are not forth coming with information.
string connectionstring = WebConfigurationManager.ConnectionStrings["AdventureWorks"].ConnectionString;
SqlConnection con = new SqlConnection(connectionstring);
DataSet ds = new DataSet();
DataRelation dr = new DataRelation("show", ds.Tables["HumanResources.Employee"].Columns["EmployeeID"], ds.Tables["HumanResources.EmployeeAddress"].Columns["EmployeeID"],false);
ds.Relations.Add(dr);
foreach (DataRow row1 in ds.Tables["HumanResources.Employee"].Rows)
{
Response.Write("customertitle:" + row1["Title"].ToString());
foreach (DataRow row2 in row1.GetChildRows(dr))
{
Response.Write("customer add" + row2["ModifiedDate"].ToString());
}
}
Object reference not set to an instance of an object. 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.NullReferenceException: Object reference not set to an instance of an object. Source Error:
[Code]....
Line 31: Line 32: DataSet ds = new DataSet();Line 33: DataRelation dr = new DataRelation("show", ds.Tables["HumanResources.Employee"].Columns["EmployeeID"], ds.Tables["HumanResources.EmployeeAddress"].Columns["EmployeeID"],false);Line 34: //ds.Tables["HumanResources.Employee"].ParentRelations.Add(dr);Line 35: ds.Relations.Add(dr);
Source File: d:databaseDataset showing selected
field of 2 tables.aspx.cs Line: 33
Stack Trace:
[Code]....
[NullReferenceException: Object reference not set to an instance of an object.] dataset__with_two_tables.Page_Load(Object sender, EventArgs e) in d:databaseDataset showing selected field of 2 tables.aspx.cs:33 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
I am using Asp.Net MVC 2.0 for creating a user and assigning properties to the user at the same time. I am using my Windows account to access database on my local computer. I am using pre-installed MVC code o create a user with unique user name and password. User is created OK. Then I want to add profile properties like First and Last name at the same time.
I am creatingProfileBase object:
ProfileBase profileBase = ProfileBase.Create(profileInformation.UserName);
where profileInformation is a RegisterModel and has user info.
When I am trying to:
profileBase.SetPropertyValue(.....);
I am getting the following error # 2147467259 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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)"}
Why is my connection string works fine the first time and not working now? And how to configure connection to use TCP-IP?
I have SQL Server Browser running ander Local account and openned port in my Firewall.
when i am executing xmlreader in enterprise library 4.1, iam getting an error like below
error: Invalid command sent to ExecuteXmlReader. The command must return an Xml result.
my code:
SqlDatabase
db = (
cmd = db.GetSqlStringCommand(
xmlReader = db.ExecuteXmlReader(cmd);
db = null;DbCommand cmd =
null;XmlReader xmlReader =
null;SqlDatabase)DatabaseFactory.CreateDatabase();"select
* from emp");DataSet ds = db.ExecuteDataSet(cmd);
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]....
i am using paging technique from this tutorial [URL] and it is working fine, i used asp.net 2.0 with sql server 2005 then i upgraded to visual studio 2008, and converted the asp.net 2.0 application to 3.0 and now using sql server 2008 all the existingpages and .xsd files are working, fine, i can see data in .xsd files when i preview it but i cannot add new stored procedures it gives me an error "An unexpected error has occured" Error message:unexpected error i dont know what it is, already configured dataset (.xsd) works fine, it is just that iam unable to add stored procedures to new datasets my connection string
<add name="jobcon" connectionString="Server=HOME-46CTBUROCXSQLEXPRESS; Database=jobdhundo; User ID=; Password=;Timeout=200; Trusted_Connection=True" providerName="System.Data.SqlClient"/>
it is fine with the entire application there is no coding involved
I have a simple page with a gridview who's select and delete are enabled. It is bound to a dataset using the object data source. Clicking delete, I get
No parameterless constructor defined for this 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.MissingMethodException: No parameterless constructor defined for this object.
Source Error:
[Code]....
Stack Trace:
[Code]....
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
I have seen other articles stating the dataset doesnt make a parameterless constrcutor, trouble is I don't know how to make one.
I want to issue an INSERT command for an SQL Server table using DataAdapter without first issuing a SELECT command. Could anybody send me lines of code to handle this? Also how do i manage INSERT into selective table columns (I have 10 columns but i only want to update 2 of them)?
View 2 Repliesi have a radiobutton list and i want the select statement of a SqlDataSource to change according to which radiobutton is selected. My code is as follows
[Code]....
It is giving me the following error when i put jon in the Text Box provided for searching Incorrect syntax near 'kae'. Incorrect syntax near 'Jon'. 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.Data.SqlClient.SqlException: Incorrect syntax near 'jon''.Source Error:
[Code]....
Line 29: query = query + "WHERE ([Ufname] LIKE '%'" + txtSrch.Text + "'%')";
Line 30: SqlDataSource1.SelectCommand = query;
Line 31: SqlDataSource1.Select(DataSourceSelectArguments.Empty);
Line 32: }
Line 33:
i use a wizard in my page the first step contains a Gridview.
[Code]....
It runs very well until i use the Gridview paging. In this case i get following error-message."Unable to cast object of type 'System.Web.UI.WebControls.Wizard' to type 'System.Web.UI.WebControls.GridViewRow'." If i use this code to get the gridview-rowDim row As GridViewRow = _ grid.Rows(Convert.ToInt32(e.CommandArgument)) paging runs, but i cannot use the commandDropdown.This is my control. I use commanddorpdown [Code]....
I have downloaded the Control form this page.
[URL]19606_On_ASP_NET_Forums_How_to_develop_a_command_capable_DropDownList.aspxHas anybody an idea to solve my problem?
I need values for 6 years that's 72months
if (i <= 72)
{
values[i] += C158_Calc;
}
B162_Calc = Financial.IRR(ref values, 0.1) * 12;
row9["Month1"] = String.Format("{0:#,###,###,###.##}", B162_Calc);
Description: An unhandled exception occurred during the execution of the current web request.
I have the following sql command:
SqlCommand cmd = new SqlCommand("SELECT * FROM tbl WHERE ID = 'john' ", con);
How can i output the results of the following command in C# to my webpage?
in local it works. when i load server, i got this error.
Using themed css files requires a header control on the page. (e.g. <head runat="server" />).
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.InvalidOperationException: Using themed css files requires a header control on the page. (e.g. <head runat="server" />).
[code]....
I am following the tutorial on the webmatrix site (http://www.microsoft.com/web/post/web/post/Web-Development-101-Part-6-Creating-an-Add-Data-page). Ifinished creating the AddMovie.cshtml page, but when I try to execute it, I get the following exceptionAn SqlCeParameter with ParameterName '3' is not contained by this SqlCeParameterCollection.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.
View 1 RepliesWhen I set Autopostback="true" in RadioButtonList and in its Items setting Enable=true, Select=false. I have select All Item as false so that when page is loaded on screen, it does not showing any value as selected (as per client requirement).Then run a application and selecting any value of this RadioButtonList, it generate an error like Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm.AutoGenerate cannot be used in a cluster.Description: An unhandled exception occurred during the execution of Please review the stack trace for more information about the error and where it originated in the code.
View 3 RepliesMy web application has user control which uses third party controls called Devexpress controls. The user control is a menu and is part of the Master page. It is placed there because this needs to be available in all the pages. My user controls raises a even on item clicked. Now, My question is that Is there any way to know that the event has occurred in page_load of the current page in which I am in?
View 3 RepliesCurrently, I am programming a web-based application with Visual Studio.NET 2003, and having a problem with an err below :
An error has occurred because a control with auto-generated id 'dgPreventiveMaintenanceSchedule:_ctl5:_ctl3' could not be located to raise a postback event. To avoid this error, explicitly set the ID property of controls that raise postback events.
That err occurs while I am rendering my datagrid for certain data. In the other words, it occasionally happens.
I've been trying to debug one by one, but I still don't any clues for this kind of err.
I'm receiving the following error occasionally when calling web service using a .NET 4.0 web application."The underlying connection was closed: An unexpected error occurred on a send."All of the articles I've read regarding this issue are for the Framework 1.1.Is there any solution to this issue for using .NET framework 4.0?
View 1 Replies