User Profile

Collapse

Profile Sidebar

Collapse
gkinu
gkinu
Last Activity: May 23 '08, 02:35 PM
Joined: Sep 13 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • gkinu
    started a topic How to Create Dynamic Cross-DBMS Crystal Reports
    in .NET

    How to Create Dynamic Cross-DBMS Crystal Reports

    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?
    See more | Go to post

  • gkinu
    started a topic How do i Optimize this Query

    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.
    ...
    See more | Go to post

  • gkinu
    replied to Application Integration Technologies
    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.
    See more | Go to post

    Leave a comment:


  • gkinu
    started a topic Application Integration Technologies

    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.
    See more | Go to post
    Last edited by gkinu; Mar 7 '08, 06:10 AM. Reason: Additional Information

  • 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 r
    ...
    See more | Go to post

    Leave 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...
    See more | Go to post

  • gkinu
    started a topic How To customize VS 2005 Setup
    in .NET

    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...
    See more | Go to post

  • 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....
    See more | Go to post

    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....
    See more | Go to post

    Leave a comment:


  • I have realized there is a Value property for each cell which i am using as follows:-

    Code:
               
    string GeneratedVal=SomeFunction();
    dataGridView1.Rows[0].Cells[3].Value = GeneratedVal;
    Thanks.
    See more | Go to post

    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...
    See more | Go to post

  • 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....
    See more | Go to post

    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...
    See more | Go to post

  • 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):

    Code:
    numberVar pos := 1;
    NthLargest (pos, {Table1.score});
    This will throw an error...
    See more | Go to post

  • gkinu
    started a topic CrossTab Query: FieldName/Expression not Recognized

    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
    ...
    See more | Go to post

  • gkinu
    replied to Access Database in VB.NET
    in .NET
    Am hoping i understand you. You are trying to do something like this:-


    Code:
    dim sumVariable as string
    sumVariable = "password"
    strSQL = "Select Usernames from login_details WHERE Passwords = '" & sumVariable & "'"
    NOTE THE Single Quote within the string
    See more | Go to post

    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?
    See more | Go to post

    Leave a comment:


  • Yes. 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.
    See more | Go to post

    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...
    See more | Go to post

  • Thanks 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...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...