[RaggiTech]

تابع...

لحذف الجدول الذي قمنا به ...

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]"drop table tb1 cascade"
[/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]

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]"drop table tb1 cascade"[/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]

إضافة حقول إلى جدول ما ...

بفرض أننا نريد أن نضيف عامود brithday إلى mytable يحوي على يوم الميلاد ..

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]"alter table mytable add brithday datetime"
[/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]

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]"alter table mytable add brithday datetime"[/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]

إلى اللقاء في الدرس القادم إن شاء الله ...