Hello,

Try to keep it simple.
Need ability for sql queries to be executed through various buttons I am coding.
Presently connecting to sql through .vb files and uses {databaseOwner}{objectQualifier} as server verification.
Have found this feature easier for connecting, but more complex with executing script, because all the parameters are located on a few different files.
Because of this, it has been more confusing as the module has grown. 
Almost think simple javascript scripts would be easier, placing all script commands in one location, yet would have to refer to connection parameters, right?

Can I use javascript sql scripts/queries with .vb file?
What is best for least amount of lined coding, but simple sql updates?  java?


More importantly, using either of these methods, what is proper format for adding calculations to script or query?

EX:        if input values are being inserted to database using bind method:  <%# Bind("Score") %>
             How would I grab  <%# Bind("Score") %> + 1, or something to that effect?

Appreciate any feedback,

-Machina12

Wtatters,

Appreciate the feedback.  Havn't tested the calculation portion of the procedure yet, but it seems to make sense.
Before I bridge into calculations, I want to make sure I am using my stored procedures properly.

Within my modules .ascx view file, I am using this code to execute proper stored procedures:

<asp:ObjectDataSource ID="ObjectDataSource_InterACTION" runat="server" DataObjectTypeName="YourCompany.Modules.InterACTION.InterACTIONInfo"
DeleteMethod="InterACTION_Delete" InsertMethod="InterACTION_Insert" OldValuesParameterFormatString="original_{0}"
OnInit="Page_Load" SelectMethod="InterACTION_SelectAll" TypeName="YourCompany.Modules.InterACTION.InterACTIONController"
UpdateMethod="InterACTION_Update">
<SelectParameters>
<asp:Parameter DefaultValue="00" Name="ModuleId" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>

Notes on above code: 

Within this section of code, I have setup commands for regular events, like insert, edit, delete, etc.
Each method then is linked to appropriate stored procedure name.


Notes on code below:
                                
Then within the GridView1, which is where information is being input, I have option within Command Field settings to show certain command buttons.
Does it automatically know when ShowDeleteButton="True" , that ShowDelete Button will link to InterACTION_Delete, because it was dicatted above?
That would see to make sense, except, 1.) what if I want to create my own commands, non-standard, and have them appear within Command Field options as well, but linked to a custom stored procedure?

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="ObjectDataSource_InterACTION" DataKeyNames="ID,UserID,ModuleId" CellPadding="4" CellSpacing="1" EnableViewState="False" Width="650px" Font-Names="Arial" Font-Size="X-Small">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ItemStyle-Width=100 />

So far, this is a list of all components that intect with stored procedures and need updating when adding features:
2.) When I input my own custom command, asumming I can from question #1, within Command Field, do I need to update each of these sections below?
3.) Just want the custom command to be option within Command Field portion and run stored procedure. What is simpliest?

.ASCX File - Presentation
.ASCX.VB - Commands
Controller.VB - System.Collections.Generic
Info.vb - declaring field attributes
SQL - stored procedures




-Machina12