-
Marked Solved Status for Oledb Error
Hi Guys! This code is working fine before I removed other programs from my computer since it is already getting slow. Now, i don't know which program I've deleted that … -
Replied To a Post in Oledb Error
Already worked! I just download MS Office Access Database Engine 2007 Version :) https://www.microsoft.com/en-us/download/details.aspx?id=13255 Thanks! -
Created Oledb Error
Hi Guys! This code is working fine before I removed other programs from my computer since it is already getting slow. Now, i don't know which program I've deleted that … -
Created Concat multiple rows into single row in DB2
i want to combine multiple rows into a single row using **DB2**. I have found this code, but I do not know how can i edit it>? CREATE FUNCTION MySchema/MyUDF … -
Marked Solved Status for Retrieve specific row in SQL
Hi! I have two tables. Table 1 - fields are: no, referenceno, date, marine Table 2 - fields are: no, referenceno, controlno, date What I would like to do is … -
Replied To a Post in Retrieve specific row in SQL
Hi Cereal! Thanks for this one! I already retrieved the data I needed. Thank you so much! ^___^ -
Created Retrieve specific row in SQL
Hi! I have two tables. Table 1 - fields are: no, referenceno, date, marine Table 2 - fields are: no, referenceno, controlno, date What I would like to do is … -
Marked Solved Status for File Upload
Hi Guys! I'm having problem with uploading the file to the server. This is my code. $path = "Files/01 Admin Procedure/" . basename($_FILES["txtFilename"]["name"]); $x = move_uploaded_file($_FILES['txtFilename']['tmp_name'], $path); //Move file to … -
Replied To a Post in File Upload
Got it already! You just need to change the permission settings of C:\Windows\Temp :) -
Replied To a Post in File Upload
I'm using IIS Sir. -
Replied To a Post in File Upload
How do I check if the path has access? This is on the server side. -
Replied To a Post in File Upload
The code is working on my localhost but if I run in on the server, it does not upload the file, do I need to configure anything on php.ini? or … -
Created File Upload
Hi Guys! I'm having problem with uploading the file to the server. This is my code. $path = "Files/01 Admin Procedure/" . basename($_FILES["txtFilename"]["name"]); $x = move_uploaded_file($_FILES['txtFilename']['tmp_name'], $path); //Move file to … -
Marked Solved Status for Import Excel File to DB2
How can I upload the data from an Excel Spreadsheet to my database in DB2? Thanks! :) -
Replied To a Post in Import Excel File to DB2
Got it already! Thanks so much! :) -
Replied To a Post in Import Excel File to DB2
Ok, can you tell me how to code that? :) -
Created Import Excel File to DB2
How can I upload the data from an Excel Spreadsheet to my database in DB2? Thanks! :) -
Replied To a Post in Merge rows in datagridview
Hi! Thanks for suggesting the link. Only problem is where should I put the code? Do I need to create a class and put the code there? After pasting the … -
Replied To a Post in Merge rows in datagridview
Nope, this is a merging function. Actually, it does not merge the cells, it deletes the cells itself. Or if you could teach me another way to merge cells vertically … -
Edited Merge rows in datagridview
Hi! I've found this code in the net that merges rows successfully. However, the data is being written in the last row of the merge rows. What I want is … -
Created Merge rows in datagridview
Hi! I've found this code in the net that merges rows successfully. However, the data is being written in the last row of the merge rows. What I want is … -
Marked Solved Status for Prevent DataGridView from resetting format
Hi! I have an bound datagridview in vb.net. I have it pre-formatted the way I want it. Like for example the `.displayIndex` which columns will come first, etc. This works … -
Replied To a Post in Prevent DataGridView from resetting format
Already tried the code & it worked well. It's just so tedious to re-write the columns one by one. Thanks! :) -
Replied To a Post in Prevent DataGridView from resetting format
I will try to select the columns in the select statement. But how to close the form instance? I have the cmdget.dispose and everything at the end of my db … -
Replied To a Post in Prevent DataGridView from resetting format
This is a sample code. This is how my code executes. dg.DataSource = Nothing dg.ColumnCount = 0 sqlGet = "SELECT * FROM table" With cmdGet .CommandText = sqlGet .Connection = … -
Created Prevent DataGridView from resetting format
Hi! I have an bound datagridview in vb.net. I have it pre-formatted the way I want it. Like for example the `.displayIndex` which columns will come first, etc. This works … -
Marked Solved Status for SQL Query not executed
Hi! I am doing the programming on my computer and it works fine-the program, the database itself, inserting to the database is also working fine. But when I publish it … -
Replied To a Post in SQL Query not executed
AS400 iSeries DB2 needs to be updated to version 6.xx.0800 and did the tweak! Installer can be found here http://www-03.ibm.com/systems/power/software/i/access/windows_sp.html Problem solved! -
Marked Solved Status for Application Crashes during INSERT COMMAND
So here's the error in the Event Viewer. Application crashes when inserting data to the database. DAtabase: AS/400 iSeries DB2 Faulting application name: 242-CEWE.exe, version: 1.0.0.0, time stamp: 0x542a2ac6 Faulting … -
Replied To a Post in Application Crashes during INSERT COMMAND
AS400 iSeries DB2 needs to be updated to version 6.xx.0800 and did the tweak! Installer can be found here http://www-03.ibm.com/systems/power/software/i/access/windows_sp.html Problem solved! -
Created Application Crashes during INSERT COMMAND
So here's the error in the Event Viewer. Application crashes when inserting data to the database. DAtabase: AS/400 iSeries DB2 Faulting application name: 242-CEWE.exe, version: 1.0.0.0, time stamp: 0x542a2ac6 Faulting … -
Replied To a Post in SQL Query not executed
Hi Guys! I am using AS/400 iSeries DB2 as my database. Here's the scenario, on my program I have a `View Data` form wherein it retrieves data from the database … -
Replied To a Post in SQL Query not executed
hi! i've already tried the `try & catch` method but it does not work. The `Message Box` does not appear exactly. targeted platform is also set to X86. -
Replied To a Post in SQL Query not executed
Again, the code above works on my programming PC very well. But on the other PC, it does not. What I would like to know is that, do I need … -
Replied To a Post in SQL Query not executed
This is the parameter already. With cmdAdd .Parameters.AddWithValue("@page", Val(frmPart1.txtPage.Text)) .CommandText = sqlAdd .Connection = conn .ExecuteNonQuery() End With -
Edited SQL Query not executed
Hi! I am doing the programming on my computer and it works fine-the program, the database itself, inserting to the database is also working fine. But when I publish it … -
Edited SQL Query not executed
Hi! I am doing the programming on my computer and it works fine-the program, the database itself, inserting to the database is also working fine. But when I publish it … -
Created SQL Query not executed
Hi! I am doing the programming on my computer and it works fine-the program, the database itself, inserting to the database is also working fine. But when I publish it … -
Marked Solved Status for Create table in Local Report (RDLC)
Hi! I want to display a table in the Local Report using SQL Connection. Parameters will be user-defined. Example. sqlSearch = "SELECT * FROM shipment WHERE " & port & … -
Replied To a Post in Create table in Local Report (RDLC)
Found this on the Internet. It worked! Dim cmdGet, cmdCount As New iDB2Command Dim daGet As New iDB2DataAdapter Dim dsGet As New DataSet Dim sqlGet, dateFrom, dateTo As String dateFrom … -
Replied To a Post in Create table in Local Report (RDLC)
hi sir! could you help me put it in code? I have a DataGridView already. -
Created Create table in Local Report (RDLC)
Hi! I want to display a table in the Local Report using SQL Connection. Parameters will be user-defined. Example. sqlSearch = "SELECT * FROM shipment WHERE " & port & … -
Marked Solved Status for For Loop
Hi! The for loop works and it reads the value of `recno()`. However, the sql code itself is being executed once only. Is there any tweak I need to do … -
Replied To a Post in For Loop
Hi! I tried this code and it worked while I am testing the value of `recno(k)`. This clears everything! For k = 0 To recno.Length - 1 sqlUpdate = "UPDATE … -
Replied To a Post in For Loop
Guys! As I said on my post, the code works well for the variables. If I'm going to use a Msgbox to check the value of `k`, it loops perfectly. … -
Replied To a Post in For Loop
`recno` is a string. Let's say `recno=4` meaning `recno.length = 4` just assume values. As i said, the code works for the variable but not for the sql execution. What … -
Began Watching For Loop
Hi! The for loop works and it reads the value of `recno()`. However, the sql code itself is being executed once only. Is there any tweak I need to do … -
Edited For Loop
Hi! The for loop works and it reads the value of `recno()`. However, the sql code itself is being executed once only. Is there any tweak I need to do … -
Created For Loop
Hi! The for loop works and it reads the value of `recno()`. However, the sql code itself is being executed once only. Is there any tweak I need to do … -
Marked Solved Status for Set Margin of Report Viewer during runtime
Hi! I have this code from the internet but it didn't work well. I want to set the margin of the Report Viewer during runtime. Because I have this form …
The End.