I have a VS.NET 2005 C# Windows Application. The same cab use one of a number of different DBMSs including SQL Server, MySQL, Access.
Is there a way of creating dynamic crystal reports that can use any of the DBMSs as datasources without having to design a report for each of the databases?
User Profile
Collapse
-
How to Create Dynamic Cross-DBMS Crystal Reports
-
How do i Optimize this Query
I have 2 tables with a parent-child relationship. Parent table's primary key field is Entry_no and is of type VarChar(50). This parent table has about 50 fields. The child has 3 fields, Entry_No (varchar(50), Requestor char(3) and id (integer).
I need the following query
...Code:QUERY 1. select p.entry_no, p.reg_date from tparent p, tchild c where p.entry_no<>c.entry_no and c.requestor='KPA' order by p.reg_date, p.
-
The reason I posted this request is that I am not getting helpful material when i search. I am searching using terms such as 'application integration' 'technologies' etc. -
Application Integration Technologies
Apart from Web Services, what other options/technologies exist/used to exist for integrating disparate applications? I am particularly interested in knowing the way applications in different organizations used to exchange data. Just a hint I can use to investigate more is all i need. -
I solved it using interfaces as illustrated below. This way, i did not need to have any overloads.
...Code:private void xx (IDbCommand c, IDbDataAdapter a) { c.CommandText = "statement1"; c.ExecuteNonQuery(); c.CommandText = "select * from sometable"; a.SelectCommand=c; DataSet d = new DataSet(); a.Fill(d,"Table1"); foreach(DataRow rLeave a comment:
-
How Do I Avoid Code Duplication in Overloaded Functions?
I want to write an overloaded function. Each overload will take as parameter one of different command objects like MySqlCommand, SqlCommand, OledbCommand etc and different DataAdapters. The function has many lines of code and the command object passed as a parameter will be referenced many times in the code. However, most lines of code do not reference the passed parameter value. My question is, do i have to repeat the whole function (duplicate... -
How To customize VS 2005 Setup
I have a Visual Studio 2005 Windows Application. I want to customize the setup. Specifically, I want the following.
1. If not already done, the database to be created and configured as necessary
2. To have forms to allows users to enter some information and save them to the database e.g. company name etc.
3. To install third party programs necessary for the application's functionality e.g. Acrobat Reader
4. Ensure the... -
There is only one Form1. Breakpoints stay solid red.
Anyway, i recreated a new solution and imported all the forms and other classes. Its working now, but old one still does not. So I would still be very intrerested to know what could have happened. And remember it also affected another completely different solution the same way!
Thanks very much for your help....Leave a comment:
-
There is no code in particular. Remember the problem is not only startup form, but even any changes i make is not reflected when i run the application e.g. I place new controls on the form, they wont be seen even though visible is set to true. When i place breakpoints in the code, its like they are not recognized....Leave a comment:
-
I have realized there is a Value property for each cell which i am using as follows:-
Thanks.Code:string GeneratedVal=SomeFunction(); dataGridView1.Rows[0].Cells[3].Value = GeneratedVal;
Leave a comment:
-
Application-Generated Column Values in DataGridView on New Record
Application-Generated Column Values in DataGridView on New Record
I have a DataGridView which I am using to enter new records to a table with 5 columns/fields. However, values for two of the fields are generated by the program automatically using some algorith (not the database AutoNumber). As such, they should not be entered in the datagrid view. The idea is that when i click a "New Record" button, the corresponding two... -
Thanks for your reply. I had actually checked the main() function. No problem there. I even restarted the IDE and the Laptop to no avail. Its now the second day and I have been forced to create another solution and imported the files. Everything works ok now, bugt I don't know for how long....Leave a comment:
-
Changes To Visual Studio 2005 Forms/Project Not Reflected at Runtime
I have a Visual Studio 2005 C# Windows application. I suddenly realized that when i changed the startup object to another form, the initial startup form would still be first to appear on running the application. I thought i would look at it later and opened a different C# solution that i am also working on. On this one, I made some changes to a form by placing controls on it. But the controls dont appear at runtime, although their visible property... -
Error in Crystal Report Formula: "A number is Required Here"
Crystal Report for Visual Studio.NET 2003.
I have a formula that brings an error " .. A number is required here ... ". See the code snippet below which i have simplified. In the actual formula, the function NthLargest is being accessed in a loop hence the need to have the first parameter being a variable (pos):
This will throw an error...Code:numberVar pos := 1; NthLargest (pos, {Table1.score}); -
CrossTab Query: FieldName/Expression not Recognized
1. I have a table 'Table1' with the fields (student,subjec t,score ).
2. I create a CrossTabQuery 'QryXTab' to return students performance per subject plus the total. The subject names now appear as colum names of the query and the totalScores for each subject as well.
The following is the query in access.
...Code:TRANSFORM Sum(Table1.score) AS TotalOfScore SELECT Table1.student, Sum(Table1.score) AS Total_Score
-
Am hoping i understand you. You are trying to do something like this:-
NOTE THE Single Quote within the stringCode:dim sumVariable as string sumVariable = "password" strSQL = "Select Usernames from login_details WHERE Passwords = '" & sumVariable & "'"
Leave a comment:
-
Thank you very much. I had actually seen this article earlier. But this article prescribes that you create a maximum number of FormulaFields at design time then suppress those to which there are no values assigned at run time. My question is, is there a way of creating the Fields at Runtime rather than DesignTime?Leave a comment:
-
gkinu replied to Implementing a DropDownList to Select a Value of a Property of a Custom UserControlin .NETYes. It is a windows form. The new usercontrol should have a property that shows a dropdown list of names of other controls in the form just like the ImageList property of a ToolBar will contain dropdownlist of all ImageList controls in the form; from which you can select one.Leave a comment:
-
Crystal Report for VS.NET 2003: Adding a new FieldObject at Runtime
Hello,
I am creating a report that can have a varying number of columns that are only determined at run time.
I saw a solution that comes near what i want. I downloaded a collection of sample applications at businessobjects .com . The application a VB.NET windows application in vbnet_win_dynam ic_report_formu la.zip in the downloaded folder.
The slight problem with this solution is that you have to insert... -
gkinu replied to Implementing a DropDownList to Select a Value of a Property of a Custom UserControlin .NETThanks a lot. May be to make myself clearer.
1. I am creating a usercontrol that inherits from a TextBox.
2. One of the new properties is called 'ControlsInForm ' which is basically a list of all controls in the form, just like the ImageList property of a ComboBox.
3. When i drop this usercontrol onto a from at design time, i expect a list of the names of all controls in the form to be displayed as a list in this property...Leave a comment:
No activity results to display
Show More
Leave a comment: