■ GridControl 클래스에서 SQL 데이터베이스 변경 사항을 저장하는 방법을 보여준다.
▶ MainWindow.xaml
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
<Window x:Class="TestProject.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid" Width="800" Height="600" Title="SQL 데이터베이스 변경 사항 저장하기" FontFamily="나눔고딕코딩" FontSize="16"> <Grid Margin="10"> <Grid.RowDefinitions> <RowDefinition Height="*" /> <RowDefinition Height="Auto" /> </Grid.RowDefinitions> <dxg:GridControl x:Name="gridControl" Grid.Row="0" Grid.Column="0" AutoGenerateColumns="AddNew" EnableSmartColumnsGeneration="True"> <dxg:GridControl.View> <dxg:TableView Name="tableView" ShowGroupPanel="False" /> </dxg:GridControl.View> </dxg:GridControl> <Button x:Name="button" Grid.Row="1" Grid.Column="0" Margin="0 10 0 0" Width="100" Height="30" Content="Update" Click="button_Click" /> </Grid> </Window> |
▶ MainWindow.xaml.cs
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 |
using System.Data; using System.Data.SqlClient; using System.Windows; namespace TestProject { /// <summary> /// 메인 윈도우 /// </summary> public partial class MainWindow : Window { //////////////////////////////////////////////////////////////////////////////////////////////////// Field ////////////////////////////////////////////////////////////////////////////////////////// Private #region Field /// <summary> /// SQL 데이터 어댑터 /// </summary> private SqlDataAdapter sqlDataAdapter; #endregion //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor ////////////////////////////////////////////////////////////////////////////////////////// Public #region 생성자 - MainWindow() /// <summary> /// 생성자 /// </summary> public MainWindow() { InitializeComponent(); InitializeSQLDataAdapter(); this.gridControl.ItemsSource = GetData(); } #endregion //////////////////////////////////////////////////////////////////////////////////////////////////// Method ////////////////////////////////////////////////////////////////////////////////////////// Private //////////////////////////////////////////////////////////////////////////////// Event #region 버튼 클릭시 처리하기 - button_Click(sender, e) /// <summary> /// 버튼 클릭시 처리하기 /// </summary> /// <param name="sender">이벤트 발생자</param> /// <param name="e">이벤트 인자</param> private void button_Click(object pSender, RoutedEventArgs e) { this.gridControl.View.CommitEditing(); this.sqlDataAdapter.Update((this.gridControl.ItemsSource as DataView).Table); } #endregion //////////////////////////////////////////////////////////////////////////////// Function #region SQL 데이터 어댑터 초기화 하기 - InitializeSQLDataAdapter() /// <summary> /// SQL 데이터 어댑터 초기화 하기 /// </summary> private void InitializeSQLDataAdapter() { SqlConnection sqlConnection = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=Northwind;Integrated Security=True"); this.sqlDataAdapter = new SqlDataAdapter("SELECT [RegionID], [RegionDescription] FROM [Region]", sqlConnection); this.sqlDataAdapter.UpdateCommand = new SqlCommand("UPDATE Region SET RegionDescription = @RegionDescription WHERE RegionID = @RegionID", sqlConnection); this.sqlDataAdapter.UpdateCommand.Parameters.Add("@RegionID" , SqlDbType.Int , 4, "RegionID" ); this.sqlDataAdapter.UpdateCommand.Parameters.Add("@RegionDescription", SqlDbType.VarChar, 50, "RegionDescription"); } #endregion #region 데이터 구하기 - GetData() /// <summary> /// 데이터 구하기 /// </summary> /// <returns>DataView 객체</returns> private DataView GetData() { DataSet dataSet = new DataSet(); this.sqlDataAdapter.Fill(dataSet); return dataSet.Tables[0].DefaultView; } #endregion } } |
