I want to filter my recordset using IN clause is it possible? The filter should be like the SQL statement below.
Select * from employees where emp_no in (1,2,3,4,5)
I have a datagrid that uses dataview for displaying the records. I want to hide some columns in the datagrid but
It returns an error but when using a dataset it has no problem. The reason why I use dataview is because I am filtering some information base on the criteria set by the user. Is...
Is it possible to execute a stored procedure and return a value within a stored procedure? If so, how will I do it?
Thank you in advance for the reply.
I have a toolbar and imagelist.. i loaded the images in toolbar from the imagelist in properties. when i deployed the program in the target pc, the images in toolbar is missing... what should i do with this? any help out there? thank you in advance. by, the way i also tried loading the images...
I am getting a "Query Engine Error" when showing up my report in CRViewer. Why is this happening? Any solution or suggestion so that I can solve the problem? I am trying to figure out this problem for about 3 days now. Other report works well with dataset being passed using plain "SELECT *...
I have a datagrid and it contains a records from the dataset. How do I search a record on it and if the record is found, It will point to the said record.
Thank you in advance for your reply.
I am having trouble in getting the position of a record being search in dataset. How will I do that? Is there a way to get the position of the record return by the following code below:
Dim myDataCol(1) As DataColumn
Dim myDataRow As DataRow
myDataCol(0) = dtaSet.Tables(0).Columns("AcctCode")...
Before that, prior to running the WinXP SP2, the computer hangs and it says, "uxTheme.dll is missing". I had the problem fixed by copying a uxTheme.dll from another PC with WinXP SP1. Then this time I run the Win XP SP2 and after extraction of file process, and Error pops out saying "The Handle...
Good day!
I have 2 forms in my project. One is the record navigation form and the other is a search form. In a search form, I have a textbox called txtSearchValue and a datagrid. I am planning to create a reusable search form that can be used by other modules in my project.
1. How do I...
Hello I am new to JAVA using JDBC. But I already have and understanding how it works. I just want to ask a question what is wrong with my source code because I keep on getting an error saying Driver is not found: the source code is below:
import java.sql.*;
public Connection cnn = null...
I am working on a program in AutoCAD 2004 using VBA. I want to make make a the drawing and the form active. It seems that when I run the macro, with the form loaded, the form becomes Modal. Is there a way to make it non modal? so that my form and drawing interacts. The form will stay on top...
hello there!
does anyone there has created a code for getting the drive list in the computer? I'm trying to make a component in VB.Net for getting the list of hard drives attached in the computer. Pls. give me a sample code. thanks a lot!
I have a code below but it always return an error...
Hello everyone!
I have a report and almost all of the values are taken from recordset. I am using Field Definition to design my report in Crystal Report 8.5 for ease deployment of the application. I only know how to pass data from recordset to CR with no sub report inside. To pass the...
Hello everyone!
I have a report and almost all of the values are taken from recordset. I am using Field Definition to design my report in Crystal Report 8.5 for ease deployment of the application. I only know how to pass data from recordset to CR with no sub report inside. To pass the...
Hello everyone!
I have a report and almost all of the values are taken from recordset. I am using Field Definition to design my report in Crystal Report 8.5 for ease deployment of the application. I only know how to pass data from recordset to CR with no sub report inside. To pass the...
hello out there! I'm new to AutoCAD 2000. I just want to ask if anyone has succeeded in making a database connection to autoCAD Drawing using MS SQL and VBA? Please help. I need to finish a project which is due next week. Also if there is any sample codes? so that i can learn how to do...
I am new to autoCAD 2002 programming using VBA. Using VBA for AutoCAD, how do I Get the Block Reference Name of the object when I double click it. Please provide me a sample code if possible. Thank you.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.