2. ASPRunner.NET General questions
  3. Event - SQL Query
This topic is locked

Event - SQL Query

 		9/11/2007 9:39:44 AM
ASPRunner.NET General questions
swat author

We have only select and Insert sql commands on events section, how can I exceute Delete or any other SQL query in events.
Thanks
Eugene 9/12/2007

I didn't quite understand your question.

You can try to use standard syntax:
ConnectionStringSettings cts = ConfigurationManager.ConnectionStrings["Project1ConnectionString"];

SqlDataSource sds = new SqlDataSource();

sds.ConnectionString = cts.ConnectionString;

sds.ProviderName = cts.ProviderName;

sds.DeleteCommand = "...";

try

{

sds.DeleteParameters.Add("Param1", TypeCode.Int32, "value1");

sds.Delete();

}

finally

{

sds.Dispose();

}
swat author 9/12/2007

Thanks Eugene,
This is , what I was looking for . To have execute multiple SQL Queries on one event.

ConnectionStringSettings cts = ConfigurationManager.ConnectionStrings["Project1ConnectionString"];
SqlDataSource sdd = new SqlDataSource();

sdd.ConnectionString = cts.ConnectionString;

sdd.ProviderName = cts.ProviderName;

sdd.InsertCommand = "UPDATE";

sdd.Insert();

sdd.Dispose();





SqlDataSource sds = new SqlDataSource();

sds.ConnectionString = cts.ConnectionString;

sds.ProviderName = cts.ProviderName;

sds.InsertCommand = "INSERT INTO....";

sds.Insert();

sds.Dispose();





SqlDataSource sds1 = new SqlDataSource();

sds1.ConnectionString = cts.ConnectionString;

sds1.ProviderName = cts.ProviderName;

sds1.InsertCommand = "DELETE FROM ....";

sds1.Insert();

sds1.Dispose();