This is the code I’m working on it to insert an image into database. I think there is nothing wrong with the first part. However, somehow this code is not functioning as it supposed to (no image …
Tag: vb.net
Can’t retrieve data from Access DB query to my VB program
So this is my code so far… I have 2 DateTimePickers in which the user selects the first day of the week and the last day of the week, once selected these two I want to calculate the hours worked on each day and add them so I can display the amount of hours worked of the interval of days
How to use SUM and GROUP BY(SQL) with Visual FoxPro in VB.NET?
I do not have much experience with VB. I have built a VB app that can retrieve data from a table(FoxPro). The code is given below: But I need to run the following SQL instead of SELECT * FROM inventory I replaced the SQL and it does not work. How can I implement that SQL or GROUP BY statement into
select NULL and false but not true in sql
i an new in vb.ner sql and what i am asking may be silly question. I have a table in sql server 2005 and a column name activated. this column contain NULL, true or false. I want to select only NULL …
SQL server Nvarchar parameters
I Have created an SP to search against many tables in the db based on string sent form ado the Vb code and the SQL SP is : As you can see I have declared argument in VB as Nvarchr and SQL parameter @SearchKey as Nvarchar also if I send english data in @SearchKey search returns correct data, but if
SQL Like statement not working in Visual Basic
Dim strText As String = tbRefine.Text Dim sql As String = “SELECT user_name,forename,surname,game_cash,reg_group FROM tblGame WHERE user_name LIKE ‘” + strSearchText + “‘ & ‘*'” Dim dsRefine As …
VB.net SQL error Must Declare the Scalar Variable
Hi I have been stuck for a long time on this simple but obtuse message “Must Declare the Scalar Variable” I have a vb.net and SQL code that inserts data into a simple table. It works OK with sample …
The parameterized query expects the parameter which was not supplied
I’m having a problem with my code: Once I typed in the string in the textbox to search for an item I get this error: The parameterized query ‘(@Parameter1 nvarchar(4000))SELECT * FROM borrow where (Departme’ expects the parameter ‘@Parameter1’, which was not supplied. Can anyone help me? Answer If you pass null value to parameter,you will get this error even
Decoding T-SQL CAST in C#/VB.NET
Recently our site has been deluged with the resurgence of the Asprox botnet SQL injection attack. Without going into details, the attack attempts to execute SQL code by encoding the T-SQL commands in …