Search:

I have created a single checkbox in the DetailsView of my Asp page. I then created VB code behind to set the value =1 if the checkbox is checked and value =0 if checkbox is not checked. I cannot get...

Yes, I'm a little new to VB and writing to a DB, so a little help is appreciated. Thanks.

My original code was this, but not sure how to incorporate the SQL parameter part into the rest of the...

I have spent hours online trying to find VB code to write multiple selections from a ListBox to SQL database. The closest code I could find for what I need to do is below, but it does not work....

Thanks. I didn't realize that 2nd one was in there. Now my code looks like this and I get an error "Operand type clash: int is incompatible with date"



Protected Sub Button1_Click(sender As...

Now I have this but still getting the same error that the Procedure or function InsertVtg has too many arguments specified.



Protected Sub Button1_Click(sender As Object, e As...

Do I need to keep the following in there?
cmd.Parameters.AddWithValue("@Meeting_Date", SqlDbType.Date)
cmd.Parameters.AddWithValue("@Committee", SqlDbType.nvarchar)...

Am I supposed to list all of the parameters in the code from the stored procedure? Which MID should I take out?

Which code would you like me to post to determine where the issue is? I debugged it and get the following error "An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll...

I am trying to run a stored procedure from my asp page on the button click but keep running into error after error. The syntax is incorrect somewhere in the code and need some help finding it....

Firstly, I really appreciate you helping me.

Here are the table structures for the two tables that need inserting.
131041

Here are the other two tables that are part of the inner joins:...

By following your code example I now get an error "Cannot insert the value NULL into column 'Meeting_ID', table 'ServiceLine_Committee.dbo.tblVotings'; column does not allow nulls. INSERT fails.
"....

Ugghhhh! I guess nobody on here can help!!! :-(

I fixed the code samples so that they are more readable. All that I am trying to do is have an "Add" button so that users can add a record by clicking the Add button in which the record gets added to...

I understand about the SCOPE IDENTITY, but I have also tried the below stored procedure and get the same result of it pulling back the previous ID and not the new:

ALTER PROCEDURE...

I need help! I am able to get this code to work, but it passes the previous Meeting ID, not the newly added Meeting ID. I am still somewhat new to VB and Asp.net so I cannot figure out where the...

The Meeting id is created when you click the Add button from the gridview.

There must be a way it can pass the ID without having to specify it. I added the stored procedure my code above.

Hi All. I am trying to run a stored procedure in a button. When the button is clicked the new record gets added to the tblMeetings table, after a stored procedure runs to take ID from the tblMeetings...