Using Strata Frame's connection to the datasource...

StrataFrame Forum

Back

Using Strata Frame's connection to the datasource...

Author	Message
StarkMike	StarkMike posted 19 Years Ago HOT Topic Details Share Topic
Group: Forum Members Posts: 436, Visits: 944	How do i use the connection to the database that strataframe has made to execute miscellaneous sql? select statements, stored procedures, etc.
	Reply Like 0
Reply
StrataFrame Team	S StrataFrame Team posted 19 Years Ago Post Details Share Post
S Group: StrataFrame Developers Posts: 3K, Visits: 2.5K	Imports MicroFour.StrataFrame.Data DataBasics.DataSources("").ExecuteStoredProcedure("STI80CreateTagsInInvTempTable", _ DbCommandExecutionType.ExecuteScalar, loParams.ToArray) Will work fine. That method will return an object.
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Threaded View

Using Strata Frame's connection to the datasource...

StarkMike - 19 Years Ago

It depends on what you are trying to do. All business objects can...

Trent L. Taylor - 19 Years Ago

I couldnt see the ExecuteNonQuery method on one of my business objects...

StarkMike - 19 Years Ago

If you only have one data source, leave it as an empty string, since...

StrataFrame Team - 19 Years Ago

The default datasource it generally always an empty string (""). The...

Trent L. Taylor - 19 Years Ago

Ok, this was the code I used:
...

StarkMike - 19 Years Ago

Yes, it should have throw an SqlException indicating that a required...

StrataFrame Team - 19 Years Ago

How do I convert this statement to work like the one below it? So that...

StarkMike - 19 Years Ago

Imports MicroFour.StrataFrame.Data...

StrataFrame Team - 19 Years Ago

Is it possible for me to bind these to a transaction and roll them...

StarkMike - 19 Years Ago

If you need manual access to a transaction, you will need to create...

StrataFrame Team - 19 Years Ago

I'm trying to use a transaction with two stored procedures and its not...

StarkMike - 19 Years Ago

I will have to set this up and look at it closer. It will more than...

Trent L. Taylor - 19 Years Ago

Ok, thanks for the heads up.

StarkMike - 19 Years Ago

Whenever you use the .DataSource("") to execute a command, it creates...

StrataFrame Team - 19 Years Ago

Thanks Ben!

StarkMike - 19 Years Ago

I'm glad that worked for you :)

StrataFrame Team - 19 Years Ago

Could you also do it like this?

...

StarkMike - 19 Years Ago

Yes, you can do this. Really the only difference is that is sets the...

Trent L. Taylor - 19 Years Ago

When using the DataBasics.DataSources("")... method of executing...

StarkMike - 19 Years Ago

Yes, it throws an exception if an error occurs, so you can use a basic...

StrataFrame Team - 18 Years Ago

This post has helped me a ton. Quick question, is it important to make...

Robin J Giltner - 18 Years Ago

It's perfectly fine for all transactions to have the same name. But,...

StrataFrame Team - 18 Years Ago

What about with multiple users using the same application on the same...

Robin J Giltner - 18 Years Ago

You can still use the same key with multiple users talking to the same...

StrataFrame Team - 18 Years Ago

Awesome, thanks Ben. That should save some heartache at a later date....

Robin J Giltner - 18 Years Ago

No problem :)

StrataFrame Team - 18 Years Ago

I was just wondering if...

Bradley Marston - 18 Years Ago

please disreguard above thanks

Bradley Marston - 18 Years Ago

Hehe, will do.

StrataFrame Team - 18 Years Ago

Reading This Topic

Login
Remember Me Reset Password Resend Validation Email Login