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);
}
