Search Results - VBForums

Search:

Type: Posts; User: ADQUSIT

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. VS 2008 How to enable the menus that are assigned to a user

    Hi. After long time i picked up a project to work upon, I'm working on its design phase, where I'm making a user control panel, where user rights and type will be available. My tables are:
    Users
    ...
  2. Replies
    9
    Views
    758

    Re: My first c# error

    Thanks to you JMC. But i told you earlier that i'm new to this. I'm not that much picky picky that you said somthing and i get the exact point. You said to remove the line of code, but there was...
  3. Replies
    9
    Views
    758

    Re: My first c# error

    When i double click on the error the control took me here:

    112577

    Should i remove the entire form1 code block? Please guide me.
  4. Replies
    9
    Views
    758

    Re: My first c# error

    John. Is it necessary to use ReSharper with C#? I mean i was suggested by one of my friend to ReShaper with C#. But he is very old in C#. So what you advise me as I'm baby to this language.
  5. Replies
    9
    Views
    758

    My first c# error

    I don't know what to select in Prefix ComboBox.

    I tried to start work in C#.

    I just added a button on a Windows Form and decided to work on something in load event of the form. I double clicked...
  6. VS 2012 Re: vB Project - Databases and Forms Connection

    There are lots of differences in vb and vb.net. I would say that you spend sometime on google to search it. That won't be much difficult to understand.
  7. VS 2012 Re: vB Project - Databases and Forms Connection

    Do you want a query that shows you whether a requested user exists in the DB or not?
    Well there are lots of ways.

    Lets say if you have fields in UserInfo table like:


    The Query is supposed to...
  8. Thread: sum in report

    by ADQUSIT
    Replies
    3
    Views
    178

    Re: sum in report

    Your thread seems to be related to Reporting Forum. :)
  9. Thread: sum in report

    by ADQUSIT
    Replies
    3
    Views
    178

    Re: sum in report

    Nice day too.
    You are using the Crystal Report Viewer and you want to sum up the field on Crystal Report and want to get the sum result.
    Have you tried the Summary option in Crystal Report?
  10. VS 2008 Re: Visual Studio Error for application.designer.vb

    I remember, i have another copy of the same project, in another partition of my hard disk. That copy is running absolutely fine and the application.designer.vb file is existing there. If i copy that...
  11. VS 2008 Re: Visual Studio Error for application.designer.vb

    No. The file does not exist there. I did it from IDE. I clicked on the form ( frmDailyIncome.vb) and then another click and it enabled for rename and i renamed it with another name. Thats it.

    What...
  12. VS 2008 Visual Studio Error for application.designer.vb

    Hi. I was working on my project, during which i added a new form and copied a crystal report and pasted and renamed it. Then I ran the project and i received the following message.

    112009



    I...
  13. Re: How to alter my DB Tables and add the old data into new structure tables

    HI. My problem has been solved with this query:

    The following inner join query, takes the original values from TempPrice Table and update the ProductBasicInfo table ProdPrice field with those...
  14. Replies
    8
    Views
    937

    How to make the CD bootable

    Hi. I need to make my CD or DVD bootable. Is there anyone who has used some software to make a CD bootable, because there are lots of software available in GooGle, but don't know whether they are...
  15. Re: How to copy one table column data into another table in sql server 2008

    Aah, dear sapator this is what i exactly needed. It really worked form. Thank you so much for this.
  16. [RESOLVED] How to copy one table column data into another table in sql server 2008

    Hi. I have a table ProductBasicInfo, which has following fields:


    ProdID (PK)
    ProdName
    Description
    Manufacturer
    Store
    ProdPrice
  17. Re: How to alter my DB Tables and add the old data into new structure tables

    Ok. For solving it i got an idea, i created a new table in which i put the prices (actual prices taken from the client). Here is the table.



    TempID (PK)
    ProdID (FK)
    PriceList

    The price...
  18. Re: How to alter my DB Tables and add the old data into new structure tables

    Dear lamany,
    1). If this is the solution so yes for # 1 option.

    2). If i am not inferring your statement wrong so it means that a sql command which inserts the data into the ProdPrice entire...
  19. Re: How to alter my DB Tables and add the old data into new structure tables

    Hm.. what else then you want me to provide you, sir?



    I've never faced this thing before, so i don't know how to do that. But if i am wrong, i might be, then please tell me that what is the...
  20. Re: How to alter my DB Tables and add the old data into new structure tables

    Look Dear Tyson. I have a standalone PC application, where DB and application setup both are residing on same PC. After deployment of my app, the client demanded for some changes, for which I need to...
  21. Re: How to alter my DB Tables and add the old data into new structure tables

    Everytime i double click on any product it gets loaded into fields and then i update the record, but this way is very difficult to do for lots of records. I hope that now the problem will be a bit...
  22. Re: How to alter my DB Tables and add the old data into new structure tables

    I post # 24 the first image is my DB image in which The ProdPrice has to be updated, this is what i really want. If the records were few so i would update them one by one by there are hundreds of...
  23. Re: How to alter my DB Tables and add the old data into new structure tables

    I'll try to use SPROC, as i have never faced with this. For the time, Yes i cannot stop using the incline queries but i have to complete it. And my thread is not resolved yet. My post # 15 is still...
  24. Re: How to alter my DB Tables and add the old data into new structure tables

    I'm regret to say that i did not get what is written in your post sir szlamany. It came into my notice after developing this application that straight queries has so many fatal issues, but now I'm...
  25. Re: How to alter my DB Tables and add the old data into new structure tables

    You are right Tyson, this won't be done again, but right now, I'm still working on the same (old) project, where i had used the straight sql queries. I"m trying to finish it, but the client everytime...
  26. Re: How to alter my DB Tables and add the old data into new structure tables

    So. Here is my altered table after alter statement.
    111445
    The table has to be updated now. I tried a simple code, but its very cumbersome way to do it. I cannot make logic for this.

    The...
  27. VS 2008 Re: How to convert to parametrized query fashion

    E_Gir, so do you refer the Execute function to this??:




    Public Function Connect()

    Try
    If cnSql.State = ConnectionState.Closed Then
    cnSql.Open()
  28. VS 2008 Re: How to convert to parametrized query fashion

    Oh.. Thats very informative. Please guide me that in post # 11 i used the cmdSql.executeNonQuery while i was advised in post # 3 to use Execute. Please guide me that where is to use the Execute...
  29. VS 2008 Re: How to convert to parametrized query fashion

    Meaning thereby that ADdWithValue will automatically detect what it receives form user input. Right?
    Well, What way is more better to use? .Add or .AddWithValue, which is safe to use? and does it...
  30. Re: How to alter my DB Tables and add the old data into new structure tables

    Oh.. Yess... Okay. I will follow this.
  31. VS 2008 Re: How to convert to parametrized query fashion

    In my post # 6, i was using:


    With cmdSql

    .Parameters.Add("@Prod_Name", SqlDbType.VarChar).Value = dt.Rows(i)("Product Name")
    .Parameters.Add("@Prod_Pri", SqlDbType.Int).Value =...
  32. VS 2008 Re: How to convert to parametrized query fashion

    E_G, using the loop in my way was actually needing in my app. I had to submit multiple records with single submit button, so therefore i needed to use the loop.

    I made a new practice of your...
  33. Re: How to alter my DB Tables and add the old data into new structure tables

    Hmm. Well, there is no such option in my app so far to take backup of the application? Should i just copy the .mdf and .ldf files into some safe place? :)
  34. Re: How to alter my DB Tables and add the old data into new structure tables

    Hello Tyson... Sorry to pick you, but what backups? Do you mean that i take backup of client DB, before altering it?
  35. VS 2008 Re: How to convert to parametrized query fashion

    Hello E_G, what you say about my post# 6. Is it right way to do the parametrized way of coding.?
  36. Re: How to alter my DB Tables and add the old data into new structure tables

    My dearest John, everytime you answer me, i feel more comfortable that you are with me.. I feel my track is safe to go forward.... :(... :)

    You said that You want me to execute UPDATE statements...
  37. Re: How to alter my DB Tables and add the old data into new structure tables

    I found the alter statement and applied it on one my DB as a practice it worked great for me. Now what to do now.
    This is original table:



    ContactId
    Father_NIC
    Contact1
    Contact2
  38. Re: How to alter my DB Tables and add the old data into new structure tables

    Nah Nah John, you started guiding me and here i am going to start how to work on alter statement.
  39. Re: How to alter my DB Tables and add the old data into new structure tables

    Dearest John, there are so much things i have never faced before... So if you and other precious members are with me so we can reach to the destination.
    Please guide me stepwise that from where do i...
  40. [RESOLVED] How to alter my DB Tables and add the old data into new structure tables

    Hi. It is first time that I'm having this problem; I had developed an application which has been deployed on client's computer. Now he requested for some changes in application for which i have to...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.