[RaggiTech]

تابع...

ملاحظة : يمكنك وضع شروط الحذف أو التعديل كيف ما تشاء ...مثلا...

كود :

[color=#000000][COLOR=#0000bb]delete from mytable where Age [/color][color=#007700]> [/color][COLOR=#0000bb]15  
[/COLOR][/COLOR]

حيث في هذه الحالة سوف يتم حذف كل شخص عمره فوق ال 15 ...

- إنشاء جدول...

جدول إسمه tb1 يحول على name من نوع nchar(10) و age من نوع bigint الكود:

vb.net :

كود :

[COLOR=#000000][COLOR=#0000bb]
Dim cn [/COLOR][color=#007700]As New [/color][COLOR=#0000bb]SqlConnection
cn[/COLOR][color=#007700].[/color][color=#0000bb]ConnectionString [/color][color=#007700]= [/color][COLOR=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
[/COLOR][color=#0000bb]Dim mycmd [/color][color=#007700]As [/color][color=#0000bb]String [/color][color=#007700]= [/color][COLOR=#dd0000]"create table tb1 (name nchar(10),age bigint);"
[/COLOR][color=#0000bb]Dim cmd [/color][color=#007700]As [/color][color=#0000bb]SqlCommand [/color][color=#007700]= New [/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]mycmd[/color][color=#007700], [/color][color=#0000bb]cn[/color][COLOR=#007700])
[/COLOR][color=#0000bb]cn[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]()
[/COLOR][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteNonQuery[/color][COLOR=#007700]()
[/COLOR][color=#0000bb]cn[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]()  
[/COLOR][color=#0000bb][/color][/COLOR]

c# :

كود :

[color=#000000][COLOR=#0000bb]SqlConnection cn [/color][color=#007700]= new [/color][color=#0000bb]SqlConnection[/color][color=#007700](@[/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]string mycmd [/color][color=#007700]= [/color][color=#dd0000]"create table tb1 (name nchar(10),age bigint);"[/color][COLOR=#007700];
[/COLOR][color=#0000bb]SqlCommand cmd [/color][color=#007700]= new [/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]mycmd[/color][color=#007700], [/color][color=#0000bb]cn[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]cn[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]();
[/COLOR][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteNonQuery[/color][COLOR=#007700]();
[/COLOR][color=#0000bb]cn[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]();  
[/COLOR][color=#0000bb][/color][/COLOR]

يتبع..