dcsimg

Search:

Type: Posts; User: tnncprojects

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: VS 2010 - Using SQL Sub Query with Left Join

    Now I populated my result with two different data set and tries to merge it, I came to know that we can combine two data set with common id to get as single row. in my data sets i have a common...
  2. Re: VS 2010 - Using SQL Sub Query with Left Join

    Hi Chris, Thanks for your reply. I am having issue to get the report as mentioned in my thread and i am not sure how to add/modified my existing sql. I need forums member advise or help to re-write...
  3. VS 2010 - Using SQL Sub Query with Left Join

    Hi All,

    I am currently doing an Library Books Tracking System for internal purpose. I have table design in SQL 2008r2 and I created SQL query to achieve the desire output but i unable to get the...
  4. Re: SQL 2008 R2 - Generate Report using SQL Sub Query with Left Join

    Hi, Thanks for your suggestion, I will post my question in appropriate forum.
  5. SQL 2008 R2 - Generate Report using SQL Sub Query with Left Join

    Hi All,

    I am currently doing an Library Books Tracking System for internal purpose. I have table design and I created SQL query to achieve the desire output but i unable to get the required output...
  6. VS 2010 Re: Show / Activate already opened Tab Page on Menu click

    Hi Edgemeal,

    Thanks for your support my issue resolved.

    Many Thanks...
  7. VS 2010 [RESOLVED] Show / Activate already opened Tab Page on Menu click

    I am doing a small VB.net application using MDI forms, Main form contains menu strip and menus like Employee, Department etc.

    If user clicks on the menu (Employee) it will open form “frmemp” in...
  8. Re: EAN-13,CODE39,UPC,CODE128 Code Bar Generator

    wild_bill - Thanks for your reply...

    I tried your suggestion before posting this thread, when i convert the bar code its like (A) but i need as (B) please refer below images (A) and (B)

    112119
  9. Re: EAN-13,CODE39,UPC,CODE128 Code Bar Generator

    Dear All,

    Can any one tell me how to convert numbers to EAN-13 bar codes using the below code, usually i got series of numbers in notepad file and i need to convert those numbers to EAN-13 and...
  10. VS 2010 Re: My Global Connection method is correct ???

    Thanks for your reply dunfiddlin...

    Its works me prefect...
    But I like to know "Pros and Cons" of this connection methodology used in my application and in long run how it will serve...
    ...
  11. VS 2010 My Global Connection method is correct ???

    Dear All,

    I am doing a project in vb.net with back end ms-access 2003, I decided my application to works on LAN (Database in one node(server) and many nodes (client) accessing the DB... through...
  12. VS 2010 Re: How to connect access 2003 DB dynamically at run time

    How do i read connection string using .ini File were database location keep on changes in LAN

    Eg:
    In .ini file below mentioned connection settings will be there

    ServerName=HostName or Local...
  13. VS 2010 Re: How to connect access 2003 DB dynamically at run time

    Thanks jm...
    I changed my connection settings what you advice please refer below...


    Dim Con As OleDb.OleDbConnection = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="...
  14. VS 2010 How to connect access 2003 DB dynamically at run time

    Hi,

    I am doing a project in VB 2010 with back end access 2003, where i will retrieve, insert, update data in DB, currently i am using the connection string in my source like below mentioned before...
  15. VS 2010 Re: How to update rows if exists else insert new rows in access table

    Thank you very much IanS and other vbforums users, I solved this issue with IanS advice...
  16. VS 2010 Re: How to update rows if exists else insert new rows in access table

    Thanks .Paul....
    I will try your suggestion and let you know...
  17. VS 2010 Re: How to update rows if exists else insert new rows in access table

    Thanks make me rain...
    can you explain about your 3rd option... how to "control the SQL execution from your front end it self"
  18. VS 2010 Re: How to update rows if exists else insert new rows in access table

    This is my code to insert the rows in TableA


    Dim Cnn_TableA As New OleDbConnection
    Dim Conn_String1 As String = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath &...
  19. VS 2010 Re: How to update rows if exists else insert new rows in access table

    Thanks for your reply .Paul
    My DGV (Table A) is not binded
    Below is are the code to update TableB



    Dim Con As OleDb.OleDbConnection
    Dim MyCom As OleDb.OleDbCommand
    Dim Sql As String...
  20. VS 2010 [RESOLVED] How to update rows if exists else insert new rows in access table

    Hi,

    I am doing a window application using VB2010 and Access as back end.
    I have tried many ways to check if the rows exists then update a particular field else insert new rows.
    I am using...
  21. VS 2010 Re: Validate DGV rows contains "0" value before inserting into Access DB

    Bunch of Thanks tg...
    As per your code logic its works perfect, now i want to learn more on flag concept, and many more thanks for teaching me
  22. VS 2010 Re: Validate DGV rows contains "0" value before inserting into Access DB

    yes exactly you understand my problem...
    loop should check all the rows before inserting into DB and i unable to find where my logic goes wrong...
  23. VS 2010 Re: Validate DGV rows contains "0" value before inserting into Access DB

    Hi tg...

    I have cleared all the bin files and check with the break points, if i enters value in two rows out of that 1st rows has value and the 2nd row has zero and i run through the break point...
  24. VS 2010 Re: Validate DGV rows contains "0" value before inserting into Access DB

    Thanks for your reply...

    Even if i remove the line Exit For its validating only the 1st row.



    For Each item As DataGridViewRow In Me.DataGridView2.Rows
    If item.Cells(3).Value = 0 Then...
  25. VS 2010 [RESOLVED] Validate DGV rows contains "0" value before inserting into Access DB

    Dear All,

    I am doing an application with DGV to get the user input.
    There are five column and n number of rows which user can add, now i want to validate if the user enters 0 (zero quantity) in a...
  26. VS 2010 Re: How to add selected rows from Form2 DGV to Form1 Data Bound DGV

    Thank you All... Problem solved
  27. VS 2010 Re: How to add selected rows from Form2 DGV to Form1 Data Bound DGV

    Thanks for your reply jmc..
    Yes The data is being passed from Form2 to Form1, Form1 contains a button which opens the Form2 and in the Form2 there is a DGV with chk box column so users can select...
  28. VS 2010 Re: How to add selected rows from Form2 DGV to Form1 Data Bound DGV

    My targeted DGV data table is myDataSet for your reference see below code


    Dim Con = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath &...
  29. VS 2010 [RESOLVED] How to add selected rows from Form2 DGV to Form1 Data Bound DGV

    Dear All,

    I am struck with an issue when adding selected rows from form2 DGV to form1 DGV which is already binded with access DB rows (data) and its throwing error "Rows cannot be programmatically...
  30. VS 2010 Re: How to Update the access table rows with relative rows from another table

    Dear all...
    After trying and find the below update query but i am not able to achieve what i required.



    Dim conn1 As New OleDbConnection("My Connection String")

    Dim query1 As String =...
  31. VS 2010 Re: How to Update the access table rows with relative rows from another table

    Any suggestions or advice please...
  32. VS 2010 Re: How to Update the access table rows with relative rows from another table

    Its a kind of application with my college guidance and I regret for saying that this is banking or trade application...
    And this also helps me to learn how to over come this scenario...
    I am...
  33. VS 2010 Re: How to Update the access table rows with relative rows from another table

    Thanks for your reply...

    In CashDepositTran table i am showing the transaction details for a entry it may be 1 or more entries so i am identifying those trans by CRegID so there will be a ref for...
  34. VS 2010 Re: How to Update the access table rows with relative rows from another table

    This is not the pure banking application its just a trade concept and i need this to be done in my app
  35. VS 2010 How to Update the access table rows with relative rows from another table

    Dear All,
    I am creating a simple banking application for my college project in VB.net 2010 with access 2003 as back end.
    I have created four tables as CashDepositReg, CashDepositTran,...
  36. VS 2010 Re: How to display the selected values in Label

    Big thanks to all,

    My problem is sorted out...
    thanks for all for your valuable suggestions
  37. VS 2010 Re: How to display the selected values in Label

    Hello make me rain,

    Big Thanks for your code it works me perfect and displays the result in txtbox as 12340
    the above result should be
    1
    2
    3
    40

    and now i want to update the access table...
  38. VS 2010 [RESOLVED] How to display the selected values in Label

    Hi All,

    I need help to show the selected values from access DB to label box below is my access query to select the identical values exists in two tables and shown as "Result" column

    Result
    1...
  39. VS 2010 Error when opening crystal report in vb.net windows application

    Hi,

    I have done a simple window application using vb.net 2010 with crystal report and back end ms access 2007 and i deployed.

    And i installed in my friend's PC (Windows 7 home basic 64 bit OS)...
  40. VS 2010 Re: Load data in DGV based on the values using NOT IN Clause

    Hi Ian,

    Thanks for guidance...

    I will check and let you know...

    Thanks.....
Results 1 to 40 of 76
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width