How to edit and delete in sql server

Question

Hi friends

I will post another old publication

I hope I find someone who can help me

This is my problem

I have a problem is that I had a table named authorisation in this structure

create table autorisation

(

Id_autorisation int primary key identity NOT NULL,

Id_user int foreign key references utilisateur (Id_user),

Id_site int foreign key references site (Id_site),

Id_profil int foreign key references profil (Id_profil)

)

In visual studio I have this interface

update ===>

Program.cmd.CommandText="update autorisation set Id_site = (select top 1 Id_site from site where Libelle_site = '"+comboBox2.Text+"') , Id_user = (select top 1 Id_user from utilisateur where User_name = '"+comboBox1.Text+"') , Id_profil = (select top 1 Id_profil from profil where Libelle_profil = '"+comboBox3.Text+"') where Id_user = (select top 1 Id_user from utilisateur where User_name = @par1)";

Program.cmd.Parametrers.AddWithValue("@par1",comboBox1.Text);

Program.cmd.ExecuteNonQuery();

delete ====>

Program.cmd.CommandText = "delete from autorisation where Id_user = (select top 1 Id_user from utilisateur where User_name = @par2)";

Program.cmd.Parametrers.AddWithValue("@par2",comboBox1.Text);

Program.cmd.ExecuteNonQuery();

How to modify and delete without specifying in the where clause the id of the current table

Is there is another method for editing and deleting without working with Id_autorisation

thanks for advance

Dharmraj Thakur · Answer

Just CTE (Common Table Expression)... Refer This: http://stackoverflow.com/questions/11562536/update-records-in-table-from-cte https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql ; WITH cte AS ( // execute you select query with join (take that column which you need) ) UPDATE cte SET --yourValue WHERE --yourCondition

Dharmraj Thakur · Answer

https://www.codeproject.com/Questions/191252/Data-grid-view-selected-cell-value-how-to-get-it refer it and try to pass value old values in where condition

ma ouml · Answer

Dharmraj Thakur

Karthi Keyan · Answer

Hi ouml you want to update or delete the single user means you must nedd the unique id. if you excute the update or delete query without where condidtion it will affect the whole table.