I am attempting to Insert a Row on a Table, but I cannot seem to pass the TASK_ID as a value/variable/function into the SQL Statement. Throughout the application, to acquire TASK_ID, I use: Dim …
Tag: vb.net
SQL Query to Show When Golfer Not Attached to an Event/Year
I am working on a school assignment that has downright stumped me for days. The task is to, using a view (VAvailableGolfers), populate a list box with Golfers who are not tied to a given event/year selected from a combo box. Here is the data in the tables: The expected output on the form, then, would be: 2015 shows Goldstein
DUAL alternative in ms access database
I am working with windows forms in VB.NET and MS Access database. I need to check that if user already exist in my database or not and take further action accordingly. After searching for awhile I …
Cannot execute SQL query
I have the following code to execute a SQL query in vb.net : opdragaliaens.CommandText = “UPDATE UBH ” & “SET ton = wh.total_net ” & …
VB.Net Function Return MySql Results Two Dimensional Array
The following code pulls data from a MySql connection and returns the array (output). This two dimensional array only works when the number of rows and columns are specified before running the query. …
SQLDataReader does not show value of column with double colon in field name
A Select query works fine when I enter it in SQL Server Management Studio on SQL Server: SELECT [00:00] FROM MY_TABLE WHERE whatevercondition … The column name is “00:00” – it has a double …
Arabic Text Shows Encoded
I have a problem that file encoding was windows-1256 and it shows strange text when using ie11 and arabic text, so i changed the file encoding to utf-8 and it works fine but i need to convert back the …
SQL Server : delete user
I’m trying to write a query to delete a user registration from my SQL Server database, but when I try to delete a user, I get this error: System.InvalidOperationException: ‘ExecuteReader: …
Execute MySQL’s SQL files using .NET
Whenever I make an update to my database (changes in stored procs, changes in tables, new tables ,etc.), I create a new sql file which I run on client’s computer via TeamViewer. I wanted my …
Datagridview update to multiple tables without using bindingsource or tableadapter
I have a working Select query but since it contains multiple tables I can’t update it from my datagridview. I’m sure it can be re-written to allow updates, but my SQL is quite limited. SELECT d….