I have a function in which i pass through some SQL and attempt to execute it against a database. The function completes fine and a SQL trace shows me that the query is being executed against the database, but when i refresh my select statement, the data has not updated. In this instance, the query is a simple: No errors
Tag: vb.net
Creating a PIVOT with dynamic rows and columns – SQL Server 2016
First, let’s define the tables: The following query gets all the answers with questions for a specific reviewee: And the output looks more or less like this: What I want is output that looks like this: The number of questions and reviews/review_dates is not known until runtime. I am ultimately writing this query for a VB/ASP front end, so if
SqlCommandBuilder Update Command is Generating Command but Not Updating Database From DataGridView
I am inheriting a form class (Form1) for Form 2. Form 1 code works without error. In Form 1, I use SqlCommandBuilder(SQL.DBDA).GetUpdateCommand to generate the update command for my Datagrid to pass to SQL data table which again works perfectly and the table is updated successfully. The SQL command text for Form 1 Update is shown here: In Form 2,
VB.NET SQL statement doesn’t return any rows form Access database
I have the following code for a login winform. When I make the connection to the database and make a select statement I get no rows back. I’m getting the message “No data exists for the row/column.” …
Displaying Data From Database With Vb.net with combobox
I face an error in my syntax which is indicating near the AND Operator If ComboBox1.Text = “” And ComboBox2.Text = “” Then MsgBox(“Please Fill In The Details”) Else Try con.Open() …
Problem with connecting Crystal Reports to SQL Server
I have a problem I am a project worker vb.net 2015 with sql After I cleared the project and tried the project at the client An error appears when the reports are shown by the crystal Report whereas mserver = server mdb = the name of the database muser = username sql mpass = sql password They are retrieved from
SQL counting in table
I’ve got a table that has a name, and a month in. What would the SQL look like to make a table, that counts how many entries there is per month against each name. e.g. Im confident to modify the vb….
Need to retrieve additional values based on Name key in table from DB within VB.NET
So initially I retrieved all values with the name identifier within a table I have, and placed them into a combo box. The data that was loaded into the table is: I used the Query builder within the table adapter configuration wizard to create a string inquiry And in VB implemented it with the selected value of the combobox But,
SQL Server client String to (forced) integer conversion issue [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 2 years ago. Improve this question Okay I’m using VB.net and added a SQL Server connection (.mdf file), and a table. I have CHANGED the input
SQL Query String Works in SQL Server Management Studio, But Not in VB.net with SQLCommand.ExecuteReader
I have an ASPX page using VB.net code, and it is set up to run a series of SQL queries and populate a SQLDataReader with the results. Each SQL query is pulled from a specific field in a table within the SQL database. This code works perfectly for literally every query I run through it, except one. The VB code