Реферат База даних технологічного обладнання для виробництва друкованих плат

id Height= 28 HorizontalAlignment= Left Margin= 6,151,0,0 Name= label24 VerticalAlignment= Top Width= 94 Visibility= Hidden / gt;

lt; Label Content= Staff id Height= 28 HorizontalAlignment= Left Margin= 6,151,0,0 Name= label25 VerticalAlignment= Top Width= 94 Visibility= Hidden / gt;

lt; Button Content= Змінити Height= 23 HorizontalAlignment= Left Margin= 328,150,0,0 Name= addBtn VerticalAlignment= Top Width= 75 Click= editBtn_Click / gt;

lt;/Grid gt;

lt;/Grid gt;

lt;/Window gt;

8.3.2 Файл вихідного коду edit. xaml. cs

using System; System. Collections. Generic; System. Linq; System. Text; System. Windows; System. Windows. Controls; System. Windows. Data; System. Windows. Documents; System. Windows. Input; System. Windows. Media; System. Windows. Media. Imaging; System. Windows. Shapes; System. Data; System. Data. SqlClient; Motherboard

{

/// lt; summary gt;

///Логіка взаємодії для edit. xaml

/// lt;/summary gt; partial class edit: Window

{public string tblName, key; edit (string tableName, string field)

{();=tableName;=field; (tblName);

} void createrControls (string tableName)

{(tableName)

{ Printers :

{. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible; _id. Visibility=Visibility. Visible; _printer. Visibility=Visibility. Visible; _printer. Visibility=Visibility. Visible ;;

} Mounters :

{. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible; _id. Visibility=Visibility. Visible; _mounter. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;;

} Staff :

{. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible; _id. Visibility=Visibility. Visible; _name. Visibility=Visibility. Visible; _name. Visibility=Visibility. Visible ;;

} Customers :

{. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible; _id. Visibility=Visibility. Visible; _customer. Visibility=Visibility. Visible ;;

} Boards :

{. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible; _id. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible; _board. Visibility=Visibility. Visible; _board. Visibility=Visibility. Visible; _board. Visibility=Visibility. Visible ;;

} Assemblies :

{. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible; _id_assembl. Visibility=Visibility. Visible; _id_assembl. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;;

} Productions :

{. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible ;. Visibility=Visibility. Visible; _id_prod. Visibility=Visibility. Visible; _id_prod. Visibility=Visibility. Visible; _id_prod. Visibility=Visibility. Visible; _id_prod. Visibility=Visibility. Visible ;;

}: break;

}

} void editBtn_Click (object sender, RoutedEventArgs e)

{connStr=@ Data Source=(local); +

Initial Catalog=DB_motherboard; +

Integrated Security=True; raquo ;; conn=new SqlConnection (connStr);

{. Open ();

} (SqlException se)

{. Show (se. Message) ;;

}

//основна команда

/* SqlCommand cmd=new SqlCommand ( Update + tblName +

set + Window. dataGrid1. CurrentCell. Column. Header + =@ ID raquo ;, conn); param=new SqlParameter () ;. ParameterName= @ ID raquo ;;. Value=Convert. ToInt32 (field) ;. SqlDbType=SqlDbType. Int ;. Parameters. Add (param); */

//(tblName)

{ Pr...