ADO.NET :: Error When Try To Delete A Master Record After Changed The Name Of A Foreign Key

Dec 24, 2010

I have two tables one named article and the other article_type, where the articles table have a foreign key column that references the article_type primary table named "article_status". so i change the name of the article_status foreign key to be article_status_id, but now each time i tried to delete an article type column it raised an error said the the article_status column cannot be found , although i did not mentioned that column in my code here is the full error :-

System.Data.SqlClient.SqlException was unhandled by user code
Message=Invalid column name 'Article_status'.
Source=.Net SqlClient Data Provider
Server=\.pipeE97065CB-CF67-4B sqlquery
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
at System.Data.Linq.SqlClient.SqlProvider.CompiledQuery.Execute(IProvider provider, Object[] arguments)
at System.Data.Linq.CommonDataServices.DeferredSourceFactory`1.ExecuteKeyQuery(Object[] keyValues)
at System.Data.Linq.CommonDataServices.DeferredSourceFactory`1.Execute(Object instance)
at System.Data.Linq.CommonDataServices.DeferredSourceFactory`1.DeferredSource.GetEnumerator()
at System.Data.Linq.EntitySet`1.Load()
at System.Data.Linq.EntitySet`1.get_Count()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at System.Data.Linq.Table`1.DeleteAllOnSubmit[TSubEntity](IEnumerable`1 entities)
at ProfessionalNetworkWebApplication.Models.ProfessionalNetworkRepository.Delete(Article_Type article) in C:UsersUserdocumentsvisual studio 2010ProjectsProfessionalNetworkWebApplicationProfessionalNetworkWebApplicationModelsProfessionalNetworkRepository.cs:line
at ProfessionalNetworkWebApplication.Controllers.ArticleTypeController.Delete(Int32 id, String confirmButton) in C:UsersUserdocumentsvisual studio 2010ProjectsProfessionalNetworkWebApplicationProfessionalNetworkWebApplicationControllersArticleTypeController.cs:line
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClassd.<InvokeActionMethodWithFilters>b__a()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)

View 10 Replies

Similar Messages:

DataSource Controls :: TableAdapterManager.UpdateAll Shows Foreign Key Error When Insert Values To Master And Child Table

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;
DAL.Datasets.dsMembers.MemPhonesRow rwmemphn = null;
rwmemphn = m_dsMembers.MemPhones.NewMemPhonesRow();
rwmemphn.u_memberid = ID;
rwmemphn.u_phn = "test";
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

SQL Server :: Delete Child Record And Later Delete The Parent Record?

Dec 3, 2010

how to Delete Child Record And Later Delete The Parent Record if it has no child

Trigger might be the answer but i don t know how!

View 1 Replies

MVC :: How To Update A Changed Foreign Key In 3.5

Jul 24, 2010

I am trying to build the MVC Music Store from ASP.Net, my only problem is that the tutorial is made for 4.0 C# and mvc2 an i am creating it with 3.5 VB mvc 1. For now i found out a lot of thing wich will work much better in the new frameworks, but my webhost still doesnt support it, because they have some problemms with PLESK.

Now i have a problem i cant figure out, i cant update data from a dropdown list, in the database using the updatemodel, that are foreign keys. Just all other data wich are not foreign keys and primary keys are updateable. These are automaticly created in the sql entity model.

Here is my code.


View 3 Replies

DataSource Controls :: Insert A Record Error - Can't Perform Create, Update, Or Delete Operations On 'Table?

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 = "", LinkSubject = "subject" };
db.MainMenuLinks.InsertOnSubmit(li); [code]....

View 2 Replies

Web Forms :: GridView Delete Parameter Doesn't Delete Record

Jan 27, 2011

I have a gridview with edit and delete parameters enabled. When I click on the edit link, I can edit the record successfully. However when I click on the delete link, nothing happens (the record does not get deleted).

View 5 Replies

How To Delete Values In Case Of Foreign Key

Sep 7, 2010

How to delete values in case of foreign key?


View 8 Replies

SQL Server :: How To Delete Foreign Key Rows

Aug 10, 2010

i need to delete some but i am using emp_id primary key in one table and using emp_id foreign key another one table.. now i wanna delete emp_id .. but i cant delete the row .. displaying error message .. how to delete the rows...

View 1 Replies

Forms Data Controls :: Created A ListView And Attempted To Delete A Record Using The Delete Button And Native Procedures?

Sep 14, 2010

I created a ListView and attempted to delete a record using the delete button and native procedures. It failed and threw an error.Pass in a valid dictionary for delete or change your mode to OverwriteChangesIn researching this issue, it appeared there is a problem with the list view when deleteing and
ConflictDetection is set to










View 1 Replies

SQL Server :: Best Method Of Automatically Deleting A Record In A Foreign Table?

Jul 13, 2010

I have two tables with one common field. The field is the primary key in one table, and just a plain field in another. When I delete a record in the table where the common field is the primary key, I want to automaticaly delete a record in the other table that has the same data in the common field.

What is the most effecient method of doign this..triggers?

View 4 Replies

DataSource Controls :: Deleting All Child Record On The Base Of Primary Key And Foreign Key?

Apr 20, 2010

how can i retrieve the all foreign keys against a single primary key. i mean to say that if a table contain a primary key then it becomes as foreign keys in which tables.

i want to take that nam of that tables and on the base of that tables then i am to delete from all the entries. e.g: if a primary key's column entry deleted then all foreing key entries should also be deleted.

there are 988 tables in a single database. it can't be possible to go for each table to setup foreign key to ON DELETE CASCADE.

.can it have any way to delete against foreign key priority wise? mean to say that parent table contain primary key, child table contain foreign key , now there is another child table which dependent previous child table. then how can i delete all record against it?

i want to do it from programatically. i am using sql server 2005

i have completed this till to that , it retrieves all foreign keys but how to delete now on the base of priority.


View 1 Replies

Placing A Foreign Website Into Master Page

Oct 19, 2010

I just started at a new job as a developer. The place I am working, a small college, has several web pages made with old school html, vbscript, php, and asp (not My boss wants their websites to have a menu system to navigate through the pages. I started a master page with a header, footer, and menu on the left. However, now, I am trying to get the school's websites to appear in the contentplaceholder. Is there someway to insert a pages content (example into the contentplaceholder? I was thinking of using a combination of frames and asp master pages but all I get are errors so far.

View 3 Replies

Web Forms :: Why All Session Is Changed To Null When Delete A Folder

Mar 3, 2011

I use the simple code in onunload's body method like this:

onunload="closeIt()"> ... </body>

The closeIt method is call a server method, like this:

function closeIt ()
type: "POST",
url: "mypage.aspx/myFunc",
data: '{}',
contentType: "application/json; charset=utf-8",
dataType: "json",
//async: false,
success: function(response){},
failure: function(response) {
I delete a folder in temp directory in myFunc method. The folder's name is the same of value in Session["id"], like this:
string id = Session["id"];
string temp = "~/temp" + id;
temp = Server.MapPath(temp);
DirectoryInfo dr = new DirectoryInfo(temp);

When the last code( Directory.Delete(dr.FullName) ) is run, the all session in project is changed to null. If i disable the last code( //Directory.Delete(dr.FullName) ) every thing work properly(all session have the value). Why when i enable the last code, all session are null? What's the problem and how can i solve it?

View 7 Replies

JQuery :: Need A Confirm Button When Delete File So I Changed Code?

Dec 27, 2010

i am using jquery upload plugin- jquery.MultiFile.js in my project to upload multiple files in this file now i need a confirm button when delete file so i changed code

if(!MultiFile.trigger('onFileRemove', slave, MultiFile)) return false;

View 1 Replies

C# - Linq Joined Table Record Delete - How To Delete With Using Linq

Feb 27, 2011

I have a question about linq delete.

I have 2 table in database and they are joined.

First Table: UserID, UserName, UserSurname, UserPhone, CompanyId

Second Table: CompanyId, CompanyName

First Table I have many recods with related second table.

I want to delete one company in second record, But firtly I have to delete users (more than 1)

How can I delete it with using linq?

View 2 Replies

Forms Data Controls :: GridView Bind Field Foreign Key's Data Record

Dec 6, 2010

I have two tables

Employee Table : ( EmployeeID,EmployeeName,... Etc )
Bonus Table : ( BonusID,EmployeeID,BonusDate,Bonus Reason,... Etc )

I wanted to list the bonuses in a gridview, so i made a query to return list of bonus records and my data access object returns the result set as Bonus business object ( generic collections of bonus BO ). i have bind my gridview with the bonus collection.

now my problem is that collection has the property "EmployeeID" and it will be displayed but instead of showing EmployeeID, i wanted to show Employee Name in that grid. I have a gridview where i want to list the bonus records ( bonus ID, bonus date, bonus description, employee ID) ,

View 5 Replies

Web Forms :: Alignment Of Background Gets Changed In A Master Page?

Feb 15, 2010

Will master page build in visualstudio 2008 express edition gets changed when the page is opened in visualstudio 2008 professinal edition?

I had created a sample master page in visualstudio 2008 express edition and when I opened the same website on other PC to work on it, I had observed that that alignment of <div> tags gets changed in the masterpage. Why this is happening?

View 2 Replies

Identity_insert Error With Foreign Key

Jun 22, 2010

I've got 2 tables where each has a primary key which is also the identifier (Both fields called "id" in each table) In the "picture" table as one of the fields I've got the photoalbumid (The id of the "photoalbum" table). This field is just an int field. I'm getting the following error: "Cannot insert explicit value for identity column in table 'Picture' when IDENTITY_INSERT is set to OFF" Can anyone give me some advise? It's such a basic thing I would hope that there's just something small in the creation of the database that I've missed out. Let me know if you need more info.

View 9 Replies

MVC :: ADO.NET Framework And Error With Foreign Key?

Apr 21, 2010

I have a database with the structure

ClientID -> PK
AddressID -> FK to Address.AddressID


AdressID -> PK

I created an initial set of address so

0 - London - 1000
1 - Paris - 2000
2 - Madrid - 3000
3 - Lisbon - 4000

I'm using Visual Studio 2008 with MVC.
Framwork to use ADO.NET to create the model

My view is:


My model is just: ... Private _dataModel As New just2testDBEntities

When post it retun erro

{"Can not insert the value NULL into column 'City', table 'dbo.Address'; column does not allow nulls. INSERT fails. ... statement terminated."}What I was intended to do is to insert a client and not a client and an address.

View 5 Replies

Web Forms :: Child Not Updated If Master Dropdownlist Selected Value Changed Programatically

May 28, 2010

In my application i have a 'Result.aspx' page. In this page i have a dropdownlist which is acting as a master for a gridview. I want that when the user loads this page then the dropdownlist automatically has the value which user selected on another page and for this i am using querystring in the page load event as follows

ddlSelectCoupon.SelectedValue =Request.QueryString("partID")

I have set the autopostback of dropdownlist to True

My problem is if i am assigning the value to dropdownlist this way then my child gridview is not updating. Also, what is the best page event for assingning this value

View 4 Replies

ADO.NET :: How To Delete A Table Record

Aug 3, 2010

Is it possible to use LINQ to delete a row in a table within an SQL database? I am using an ADO connected command statement to delete a row where a string column equals a name. But, I would prefer to use an easier way with LINQ, if possible.

View 3 Replies

JQuery :: How To Get Id To Delete A Record

Nov 26, 2010

I have a list of documents and different actions performed for each records. To delete the record i need the id to pass to the controller. I use JQuery to perform deletion. In it I need to Id of the record. The Following is my view:


$.post("/BuildDocument/DeleteBuildDocument", {need to pass id here..}); need the id(BldDocId). How can i get it?

View 3 Replies

C# - Delete A Record In DataGridView?

Mar 22, 2011

I'm trying to delete a record in DataGridView but it is giving me this error:

Must declare the scalar variable "@reg_id".

My reg_id is the primary key column in the table. How can I resolve this?

View 1 Replies

C# - How To Delete Record From DB Having Composite Key

Dec 11, 2010

I have app where I am using gridview for data showing, editing and deleting. Now I want to delete or edit record from table and I need to pass 3 cols in DataBinder.Eval(Container.DataItem,"colName"). how i can do this?


Basically when i need to update or delete record from app, I have to pass values of 3 columns (which are composite keys) to my UDF. Now How I can pass 3 different values to DataBinder.Eval() and reading them in GridView Rowcommand event.

View 2 Replies

Prompt The User Whenever Delete Record Using C#?

Apr 21, 2010

when ever i click on the delete button,then one Message box should come, it must ask "Are You sure Do YOU want to delete this record?" it should have two options YES and NO ,if i click YES the Record should be delete and if I click on NO ,the record will not be deleted. how can i do this in and in

View 13 Replies

Copyrights 2005-15, All rights reserved