Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows;
- using System.Windows.Controls;
- using System.Windows.Data;
- using System.Windows.Documents;
- using System.Windows.Input;
- using System.Windows.Media;
- using System.Windows.Media.Imaging;
- using System.Windows.Navigation;
- using System.Windows.Shapes;
- using System.Data.SqlClient;
- namespace WpfApplication12
- {
- /// <summary>
- /// Interaction logic for MainWindow.xaml
- /// </summary>
- public partial class MainWindow : Window
- {
- SqlConnection myConnection = new SqlConnection("server=localhost; Trusted_Connection=yes; database=stuff");
- public MainWindow()
- {
- SqlCommand myCommand = new SqlCommand();
- InitializeComponent();
- try
- {
- myConnection.Open();
- }
- catch (Exception e)
- {
- MessageBox.Show(e.ToString());
- }
- myCommand.Connection = myConnection;
- myCommand.CommandText = "INSERT INTO things (secondcolumn) " +
- "Values ('string')";
- myCommand.ExecuteNonQuery();
- try
- {
- SqlDataReader myReader = null;
- SqlCommand myReadCommand = new SqlCommand("select * from things",
- myConnection);
- myReader = myCommand.ExecuteReader();
- while (myReader.Read())
- {
- MessageBox.Show(myReader["id"].ToString());
- MessageBox.Show(myReader["secondcolumn"].ToString());
- }
- }
- catch (Exception e)
- {
- MessageBox.Show(e.ToString());
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement