private void button1_Click(object sender, EventArgs e) { // SqlConnection connection = new SqlConnection(@"Server=Tambu-PC\SQLEXPRESS; initial catalog=BLOG; Integrated Security=True"); // connection.Open(); BlogDataSet dataSet = new BlogDataSet(); UserSetTableAdapter userAdapter = new UserSetTableAdapter(); userAdapter.Fill(dataSet.UserSet); userAdapter.Insert("Tom"); userAdapter.Update(dataSet); //SqlCommand command = // new SqlCommand(@"SELECT * FROM UserSet Where UserSet.UserName=@pname", connection); //SqlParameter param = new SqlParameter("@pname", "John"); //command.Parameters.Add(param); //SqlDataReader reader = command.ExecuteReader(); //while (reader.Read()) //{ // int id = reader.GetInt32(0); // string name = reader.GetString(1); //} //reader.Dispose(); // connection.Dispose(); }
static void Main(string[] args) { //var c = ConfigurationManager.AppSettings["PathToSourceFile"]; UserSetTableAdapter ad = new UserSetTableAdapter(); DataSet1 ds = new DataSet1(); ad.Fill(ds.UserSet); ds.UserSet.RemoveUserSetRow(ds.UserSet[0]); ad.Update(ds); }
public AdministratorViewModel(User administrator) { _dataSet = new AirlinesDataSet(); _adapter = new UserSetTableAdapter(); _adapter.Fill(_dataSet.UserSet); UsersDataView = _dataSet.UserSet.DefaultView; CurrentUser = administrator; _updateViewTimer = new DispatcherTimer { Interval = TimeSpan.FromMilliseconds(700) }; _updateViewTimer.Tick += async (sender, args) => await ApplyFilter(); Messenger.Default.Register<Message>(this, RefreshDataSet, Context.AddContext); }