public void InsertTest2() { SqlDataSource ds = CreateDataSource(); ds.SelectCommand = "SELECT * FROM Table1 WHERE UserName = ?"; ds.SelectParameters.Add(new Parameter("UserName", TypeCode.String, "newuser2")); ds.InsertCommand = "INSERT INTO Table1 (UserId, UserName, Description) VALUES (?, ?, ?)"; ds.InsertParameters.Add(new Parameter("UserId", TypeCode.Int32, "5")); ds.InsertParameters.Add(new Parameter("UserName", TypeCode.String, "newuser")); ds.InsertParameters.Add(new Parameter("Description", TypeCode.String, "newuser")); SqlDataSourceView view = (SqlDataSourceView)((IDataSource)ds).GetView(""); OrderedDictionary values = new OrderedDictionary(); values.Add("UserId", "17"); values.Add("UserName", "newuser2"); values.Add("Description", "newuser2"); int records = view.Insert(values); DataView dataView = (DataView)ds.Select(new DataSourceSelectArguments()); Assert.AreEqual(1, dataView.Count); Assert.AreEqual(1, records); }
protected void SqlDataSource3_Selecting(object sender, SqlDataSourceSelectingEventArgs e) { System.Data.Common.DbCommand command = e.Command; SqlDataSourceView dsv = (SqlDataSourceView)sender; Label1.Text += "<br/>SqlDataSource3: " + genSQLCmd(command.CommandText, command.Parameters); }
public void UpdateTest2() { SqlDataSource ds = CreateDataSource(); ds.SelectCommand = "SELECT * FROM Table1 WHERE UserName = ?"; ds.SelectParameters.Add(new Parameter("UserName", TypeCode.String, "SimpleUser")); ds.UpdateCommand = "UPDATE Table1 SET UserName = ? WHERE UserId = ?"; ds.UpdateParameters.Add(new Parameter("UserName", TypeCode.String, "superuser")); ds.UpdateParameters.Add(new Parameter("UserId", TypeCode.Int32, "5")); ds.OldValuesParameterFormatString = "original_{0}"; SqlDataSourceView view = (SqlDataSourceView)((IDataSource)ds).GetView(""); OrderedDictionary keys = new OrderedDictionary(); keys.Add("UserId", 7); OrderedDictionary values = new OrderedDictionary(); values.Add("UserName", "SimpleUser"); OrderedDictionary oldvalues = new OrderedDictionary(); oldvalues.Add("UserName", "user7"); int records = view.Update(keys, values, oldvalues); DataView dataView = (DataView)ds.Select(new DataSourceSelectArguments()); Assert.AreEqual(1, dataView.Count); Assert.AreEqual(1, records); }