updation of o/p of sql query execution
-
hi can i directly update data table from execution of sql query ? or at the time of query execution can i store o/p directly into table?
Thanks bye
nilam11 wrote:
can i directly update data table from execution of sql query ?
By "data table" do you mean the table in the database, or the "DataTable" object in .NET?
nilam11 wrote:
or at the time of query execution can i store o/p directly into table?
What is "o/p"? You can run any SQL through the SqlCommand object. If you want results back use
ExecuteReader(). If you don't expect results back useExecuteNonQuery()
Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
-
nilam11 wrote:
can i directly update data table from execution of sql query ?
By "data table" do you mean the table in the database, or the "DataTable" object in .NET?
nilam11 wrote:
or at the time of query execution can i store o/p directly into table?
What is "o/p"? You can run any SQL through the SqlCommand object. If you want results back use
ExecuteReader(). If you don't expect results back useExecuteNonQuery()
Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
-
hi thanks. i want to store data table of database from query's o/p whatever will come.
Thanks bye
nilam11 wrote:
query's o/p
I asked this before: What is "o/p"? To me it means Original Poster. That is obviously not correct in this context.
Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website