I have a complex SQL query in which I cannot get the ModuleID, UserID & ItemID to store correctly.
The values for the three fields are presently going in as zero:

"INSERT INTO TableName (ModuleID, UserID, ItemID, Field1, Field2)  VALUES ( ' " + Me.ModuleID.ToString() + " ' , ' " + Me.UserID.ToString() + " ' , ' " + Me.ItemID.ToString() + " ' , 1, 2)"

I had a previous thread where I was having the same issue using the controller.vb and stored procedures, but the issue was resolved there.
For whatever reason I cannot get these values to store correct within a standard sql query.
Referring back to the previous posts advice, ModuleID and UserID are stored automatically.
I went back and included the following within the .ascx file  (invisible)(one for each):

<asp:TextBox ID="ModuleIdTextBox" runat="server" Text='<%# Bind("ModuleId") %>' Width="14px" Visible="False">

But still no luck. What do I need to do to store unique ModuleID, UserID & ItemID within SQL Query?


Feedback Appreciated,

-machina12

I am presently Inheriting from Entities.Modules.PortalModuleBase.
But when I tried your recommendation several ways (as listed below), it throws an error to the module.

- VALUES (Me.ModuleID, Me.UserID etc...
- VALUES (ModuleID, UserID etc...
- VALUES (" Me.ModuleID ", " Me.UserID " etc...
- VALUES (" ModuleID ", " UserID " etc...
- VALUES ( ' " + Me.ModuleID + " ', ' " + Me.UserID + " ' etc...
- VALUES ( ' " + ModuleID + " ', ' " + UserID + " ' etc...

What should the VALUES input be to store correctly?

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim myConnection As New SqlConnection("Connection String Here")

myConnection.Open()

Dim myTrans = myConnection.BeginTransaction()

Dim myCommand As New SqlCommand()

myCommand.Connection = myConnection

myCommand.Transaction = myTrans

Try

myCommand.CommandText = "INSERT INTO Calendar (ModuleID, UserID, Field1, Field2, Field3, Field4) VALUES (ModuleId,UserID,1,1,1,1)"

myCommand.ExecuteNonQuery()

myTrans.Commit()

Me.Response.Text = "Records have been written successfully to database."

Catch ep As Exception

myTrans.Rollback()

'Response.Write(ep.ToString())

Me.Response.Text = "No records where written to database."

Finally

myConnection.Close()

End Try

End Sub

============================================================================

The 1,1,1 values store fine, but the ModuleID & UserID storing as zero, also in these variations of code:

- VALUES (Me.ModuleID, Me.UserID etc...

- VALUES (ModuleID, UserID etc...

- VALUES (" Me.ModuleID ", " Me.UserID " etc...

- VALUES (" ModuleID ", " UserID " etc...

- VALUES ( ' " + Me.ModuleID + " ', ' " + Me.UserID + " ' etc...

- VALUES ( ' " + ModuleID + " ', ' " + UserID + " ' etc...

.ToString() as well ????
I have also added the texboxes to the .ascx file, as mentioned in the first post. 
They should bind he ModuleId & UserID, and I am not sure if I need them or not.

What should the VALUES input be to store correctly within SQL statement?