User Profile

Collapse

Profile Sidebar

Collapse
rusdyrip
rusdyrip
Last Activity: Mar 31 '08, 02:29 AM
Joined: Jan 23 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rusdyrip
    started a topic Problem Using Sum with Join
    in SQL Server

    Problem Using Sum with Join

    pls help me solve this problem

    i have
    Table StockTransactio n
    field:
    Code |In |Out

    Table StockMaster
    field:
    Code |Name

    now i want to show Last Stock
    i use this query

    Code:
    SELECT 
STOCKTRANSACTION.CODE,
SUM(STOCKTRANSACTION.IN-STOCKTRANSACTION.OUT) AS TOTAL
FROM STOCKTRANSACTION 
GROUP BY STOCKTRANSACTION.CODE
    ...
    See more | Go to post
    Last edited by rusdyrip; Mar 28 '08, 04:32 AM. Reason: bad english
    • rusdyrip
      replied to Inserting Flash in Visual Basic 2005
      in Visual Basic
      i think u must delete something on your bin folder,or obj folder,
      something like flash file, i don't remember the name,but u can test delete it and try add again....
      See more | Go to post

        Leave a comment:

      • rusdyrip
        replied to Loading Database Slow VB 2005
        in Visual Basic
        i use my code just to load to datagrid without bound it to data source,
        i have try load 10000 row not from database, and it seems like the slow come from the grid.
        but i confuse why another application can show it on grid fast, i look at application like Firebird Maestro,it shows the row faster and it using grid too.

        thx for the information...
        See more | Go to post

          Leave a comment:

        • rusdyrip
          replied to about performance vb.net
          in .NET
          but it makes my report become slow to load

          i have application load 1500 item
          and this 1500 item have all about 10000 row to calculate

          and it's take time about 20 sec to display all,is this normal?
          my customer always comment slow about it

          my cpu spec is AMD Turion X2 and have Memory 1 gb

          thx...
          See more | Go to post

            Leave a comment:

          • rusdyrip
            started a topic about performance vb.net
            in .NET

            about performance vb.net

            hi all,

            i am bit confused about logic for performance

            what is the best way :

            process on transaction or process on report

            ex : sum for last stock,
            i calculate every transaction or i calculate just on report

            sory bad english
            See more | Go to post
            • rusdyrip
              replied to show new form that same like old form
              in Visual Basic
              thx,it works perfect :)...
              See more | Go to post

                Leave a comment:

              • rusdyrip
                started a topic show new form that same like old form
                in Visual Basic

                show new form that same like old form

                hi all

                sory about the title

                i don't know how to tell the problem,

                i have sales form that have complete design,coding
                i name it salesform

                so if i want to show it, i call
                salesform.show

                but how if i want to show it double or more

                thx
                See more | Go to post
                • rusdyrip
                  replied to Compare 2 database structure
                  in Visual Basic
                  i am using firebird sql

                  and using firebird maestro for the gui

                  so is there no syntax that check if the field does'nt exist then it will add on old database?


                  thx...
                  See more | Go to post

                    Leave a comment:

                  • rusdyrip
                    started a topic Compare 2 database structure
                    in Visual Basic

                    Compare 2 database structure

                    hi all,

                    i have problem update database.
                    currently if i have create new table on database.
                    i must manually add new table on other client (old database)
                    is there any vb.net syntax to compare 2 database
                    and make the 2 database have same structure


                    thx

                    sory bad english
                    See more | Go to post
                    • rusdyrip
                      replied to Loading Database Slow VB 2005
                      in Visual Basic
                      i understand
                      so the grid that takes long time to load

                      i just confuse what the reason ,cause my customer always complaint.

                      thx for the info
                      See more | Go to post

                        Leave a comment:

                      • rusdyrip
                        replied to Loading Database Slow VB 2005
                        in Visual Basic
                        some times my client need to view data from 2005 to 2007
                        and i display it on grid.

                        if i not load to grid,where should i load it?

                        thx...
                        See more | Go to post

                          Leave a comment:

                        • rusdyrip
                          started a topic Loading Database Slow VB 2005
                          in Visual Basic

                          Loading Database Slow VB 2005

                          hi all,

                          i have problem on loading large database
                          i am using Firebird Database and VB.NET 2005

                          it seems really slow to load 10.000+ row on DataGrid

                          currently i use DataReader to open the database.

                          is there any method to make it more faster.

                          should I use DataSet or Data Adapter,
                          i am confuse what should i use

                          thx
                          See more | Go to post
                          • rusdyrip
                            replied to Multithread Problem
                            in Visual Basic
                            if i use do event i scared that it will make application slow,
                            cause i call this do event every loop data

                            i read some artikel ,
                            it like use something like x process communication
                            but i don't know how to use it
                            See more | Go to post

                              Leave a comment:

                            • rusdyrip
                              started a topic Multithread Problem
                              in Visual Basic

                              Multithread Problem

                              hi

                              i am trying to make simple application to learn multi thread

                              but i have problem to make it

                              the problem is the form can't respond while loading data

                              i want to make it loading,but i can open new form

                              thx

                              this my sample


                              [CODE=vbnet]
                              Imports System.Componen tModel
                              Imports System.Threadin g

                              Public Class Form1...
                              See more | Go to post
                              Last edited by debasisdas; Feb 8 '08, 05:13 AM. Reason: added code=vbnet tags
                              • rusdyrip
                                replied to Make Global Property Application
                                in Visual Basic
                                thx

                                it solve my problem
                                See more | Go to post

                                  Leave a comment:

                                • rusdyrip
                                  started a topic Make Global Property Application
                                  in Visual Basic

                                  Make Global Property Application

                                  hi all,

                                  anyone to know how to make Global Property
                                  so if i change Font size, all form on my application will change

                                  did i must change the designer every form?

                                  thx
                                  See more | Go to post
                                  • rusdyrip
                                    replied to Animated Gif Problem
                                    in Visual Basic
                                    if anybody have spare time,
                                    pls take a look at my sample project.

                                    this is my problem


                                    http://rapidshare.com/files/88986964/WindowsApplicat ion1.rar.html

                                    thx
                                    See more | Go to post

                                      Leave a comment:

                                    • rusdyrip
                                      replied to Animated Gif Problem
                                      in Visual Basic
                                      i am use vb2005 express
                                      on normal condition it can animate on the form.
                                      but if i load while processing it don't animate...
                                      See more | Go to post

                                        Leave a comment:

                                      • rusdyrip
                                        started a topic Animated Gif Problem
                                        in Visual Basic

                                        Animated Gif Problem

                                        hi all
                                        i want to make Loading Form with animated gif

                                        i make like this

                                        Code:
                                        'do events
formloading.showdialog()
'do events

'process loading data to grid

'do events
formloading.close
'do events
                                        but the problem is the animated gif won't animated.
                                        if don't make loading process the animated gif work perfectly

                                        ...
                                        See more | Go to post
                                        • rusdyrip
                                          replied to VB2005 : Help Making Splash Screen To Load Reference
                                          in Visual Basic
                                          so the function of splash screen just to show some animation before the form load. then is there any way to load form on background,or i must use thread?


                                          i am confused how to increase load performance my vb application.
                                          cause i am use several component and it take my memory resource about 70mb++.

                                          on vb6 i can hide it by make the form visible a while, then after everything load,i show it
                                          but on...
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...