Search:

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...

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...

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...

Hi, Thanks for your suggestion, I will post my question in appropriate forum.

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...

Hi Edgemeal,

Thanks for your support my issue resolved.

Many Thanks...

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...

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

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...

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...
...

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...

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...

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="...

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...

Thank you very much IanS and other vbforums users, I solved this issue with IanS advice...

Thanks .Paul....
I will try your suggestion and let you know...

Thanks make me rain...
can you explain about your 3rd option... how to "control the SQL execution from your front end it self"

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 &...

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...

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...

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

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...

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...

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...

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...

Thank you All... Problem solved

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...

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 &...

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...

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 =...

Any suggestions or advice please...

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...

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...

This is not the pure banking application its just a trade concept and i need this to be done in my app

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,...

Big thanks to all,

My problem is sorted out...
thanks for all for your valuable suggestions

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...

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...

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)...

Hi Ian,

Thanks for guidance...

I will check and let you know...

Thanks.....