Problemes with udpate,insert and delete options

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
watiero
Posts: 1
Joined: Wed 10 Dec 2008 18:38
Location: Montreal

Problemes with udpate,insert and delete options

Post by watiero » Wed 10 Dec 2008 18:54

Hi,

I'm trying to use LINQ for the first time and something very simple doesn't seem to work...

I have a single table that I'm linking with a LinqDataSource. I enabled the update, insert and delete options.

The problem is that I am not given permission to modify anything in my gridview...

Here is my .aspx

Code: Select all

 
  
  
  
    
      
      
      
      
        
            
                
            
         
      
      
    
  
  
  
//     Ce code a été généré par un outil.
//     Version du runtime :2.0.50727.3053
//
//     Les modifications apportées à ce fichier peuvent provoquer un comportement incorrect et seront perdues si
//     le code est régénéré.
// 
//------------------------------------------------------------------------------

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;



[System.Data.Linq.Mapping.DatabaseAttribute(Name="MSPlanif")]
public partial class DataClassesDataContext : System.Data.Linq.DataContext
{
	
	private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
	
  #region Extensibility Method Definitions
  partial void OnCreated();
  partial void InsertHelpRequests(HelpRequests instance);
  partial void UpdateHelpRequests(HelpRequests instance);
  partial void DeleteHelpRequests(HelpRequests instance);
  #endregion
	
	public DataClassesDataContext() : 
			base(global::System.Configuration.ConfigurationManager.ConnectionStrings["MSPlanifConnectionString"].ConnectionString, mappingSource)
	{
		OnCreated();
	}
	
	public DataClassesDataContext(string connection) : 
			base(connection, mappingSource)
	{
		OnCreated();
	}
	
	public DataClassesDataContext(System.Data.IDbConnection connection) : 
			base(connection, mappingSource)
	{
		OnCreated();
	}
	
	public DataClassesDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) : 
			base(connection, mappingSource)
	{
		OnCreated();
	}
	
	public DataClassesDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) : 
			base(connection, mappingSource)
	{
		OnCreated();
	}
	
	public System.Data.Linq.Table HelpRequests
	{
		get
		{
			return this.GetTable();
		}
	}
}

[Table(Name="PLANIF.HelpRequests")]
public partial class HelpRequests : INotifyPropertyChanging, INotifyPropertyChanged
{
	
	private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
	
	private int _HelpRequestID;
	
	private int _TeamPlanningResourceID;
	
	private System.DateTime _RequestDate;
	
	private string _RequestComment;
	
	private System.Nullable _RequestedBy;
	
	private System.Nullable _RequestSolved;
	
    #region Extensibility Method Definitions
    partial void OnLoaded();
    partial void OnValidate(System.Data.Linq.ChangeAction action);
    partial void OnCreated();
    partial void OnHelpRequestIDChanging(int value);
    partial void OnHelpRequestIDChanged();
    partial void OnTeamPlanningResourceIDChanging(int value);
    partial void OnTeamPlanningResourceIDChanged();
    partial void OnRequestDateChanging(System.DateTime value);
    partial void OnRequestDateChanged();
    partial void OnRequestCommentChanging(string value);
    partial void OnRequestCommentChanged();
    partial void OnRequestedByChanging(System.Nullable value);
    partial void OnRequestedByChanged();
    partial void OnRequestSolvedChanging(System.Nullable value);
    partial void OnRequestSolvedChanged();
    #endregion
	
	public HelpRequests()
	{
		OnCreated();
	}
	
	[Column(Storage="_HelpRequestID", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
	public int HelpRequestID
	{
		get
		{
			return this._HelpRequestID;
		}
		set
		{
			if ((this._HelpRequestID != value))
			{
				this.OnHelpRequestIDChanging(value);
				this.SendPropertyChanging();
				this._HelpRequestID = value;
				this.SendPropertyChanged("HelpRequestID");
				this.OnHelpRequestIDChanged();
			}
		}
	}
	
	[Column(Storage="_TeamPlanningResourceID", DbType="Int NOT NULL")]
	public int TeamPlanningResourceID
	{
		get
		{
			return this._TeamPlanningResourceID;
		}
		set
		{
			if ((this._TeamPlanningResourceID != value))
			{
				this.OnTeamPlanningResourceIDChanging(value);
				this.SendPropertyChanging();
				this._TeamPlanningResourceID = value;
				this.SendPropertyChanged("TeamPlanningResourceID");
				this.OnTeamPlanningResourceIDChanged();
			}
		}
	}
	
	[Column(Storage="_RequestDate", DbType="SmallDateTime NOT NULL")]
	public System.DateTime RequestDate
	{
		get
		{
			return this._RequestDate;
		}
		set
		{
			if ((this._RequestDate != value))
			{
				this.OnRequestDateChanging(value);
				this.SendPropertyChanging();
				this._RequestDate = value;
				this.SendPropertyChanged("RequestDate");
				this.OnRequestDateChanged();
			}
		}
	}
	
	[Column(Storage="_RequestComment", DbType="VarChar(4000)")]
	public string RequestComment
	{
		get
		{
			return this._RequestComment;
		}
		set
		{
			if ((this._RequestComment != value))
			{
				this.OnRequestCommentChanging(value);
				this.SendPropertyChanging();
				this._RequestComment = value;
				this.SendPropertyChanged("RequestComment");
				this.OnRequestCommentChanged();
			}
		}
	}
	
	[Column(Storage="_RequestedBy", DbType="Int")]
	public System.Nullable RequestedBy
	{
		get
		{
			return this._RequestedBy;
		}
		set
		{
			if ((this._RequestedBy != value))
			{
				this.OnRequestedByChanging(value);
				this.SendPropertyChanging();
				this._RequestedBy = value;
				this.SendPropertyChanged("RequestedBy");
				this.OnRequestedByChanged();
			}
		}
	}
	
	[Column(Storage="_RequestSolved", DbType="Bit")]
	public System.Nullable RequestSolved
	{
		get
		{
			return this._RequestSolved;
		}
		set
		{
			if ((this._RequestSolved != value))
			{
				this.OnRequestSolvedChanging(value);
				this.SendPropertyChanging();
				this._RequestSolved = value;
				this.SendPropertyChanged("RequestSolved");
				this.OnRequestSolvedChanged();
			}
		}
	}
	
	public event PropertyChangingEventHandler PropertyChanging;
	
	public event PropertyChangedEventHandler PropertyChanged;
	
	protected virtual void SendPropertyChanging()
	{
		if ((this.PropertyChanging != null))
		{
			this.PropertyChanging(this, emptyChangingEventArgs);
		}
	}
	
	protected virtual void SendPropertyChanged(String propertyName)
	{
		if ((this.PropertyChanged != null))
		{
			this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
		}
	}
}
#pragma warning restore 1591

Thanks in advance!

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 11 Dec 2008 11:04

Unfortunately, LinqDataSource component is not supported in dotConnects yet.

Post Reply