ExecuteNonQuery в SQL Server Express Edition - C#
Формулировка задачи:
........
using System.Data.SqlServerCe;
namespace WpfApplication1
{
/// <summary>
/// Логика взаимодействия для MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
SqlCeConnection con = new SqlCeConnection(Properties.Settings.Default.Database1ConnectionString);
con.Open();
SqlCeCommand com = new SqlCeCommand("INSERT INTO english SET word='Hello'", con);
com.ExecuteNonQuery();
con.Close();
}
}
}Решение задачи: «ExecuteNonQuery в SQL Server Express Edition»
textual
Листинг программы
private void Window_Loaded(object sender, RoutedEventArgs e)
{
SqlCeConnection con = new SqlCeConnection(Properties.Settings.Default.Database1ConnectionString);
con.Open();
SqlCeCommand com = new SqlCeCommand("INSERT INTO english VALUES ('word')", con);
com.ExecuteNonQuery();
com = new SqlCeCommand("SELECT * FROM english", con);
SqlCeDataReader read = com.ExecuteReader();
while (read.Read())
{
textBlock1.Text = read[0].ToString();
}
}