debasisdas 580 Posting Genius Featured Poster

496

debasisdas 580 Posting Genius Featured Poster

500

debasisdas 580 Posting Genius Featured Poster

500

debasisdas 580 Posting Genius Featured Poster

496.

debasisdas 580 Posting Genius Featured Poster

496

debasisdas 580 Posting Genius Featured Poster

496

debasisdas 580 Posting Genius Featured Poster

what happens when you comment this line

sd.InitialDirectory = "C:\"

and then try to create the file by browsing the file dialog ?

debasisdas 580 Posting Genius Featured Poster

In this case important question is what are going to do with all those data .

debasisdas 580 Posting Genius Featured Poster

494

debasisdas 580 Posting Genius Featured Poster

Your PK should be based on the combination of

booking_code and type.

debasisdas 580 Posting Genius Featured Poster

494

debasisdas 580 Posting Genius Featured Poster

494

debasisdas 580 Posting Genius Featured Poster

why the fields

name
buying price

are repeating in both the tables ?

are you trying to create something like inventory management, where you maintain the incoming and outgoing stock and finally prepare reports on the transaction on periodic basic ?

debasisdas 580 Posting Genius Featured Poster

496

debasisdas 580 Posting Genius Featured Poster

500

debasisdas 580 Posting Genius Featured Poster

MCA from Sikkim Manipal University is good option for working professionals like you.

Yes age will be a factor, only if you are interested in big MNCs.
And the other concern will be any gap in education, because most of the IT farms opt for 16 years of continued education. Local companies may ignore that.

debasisdas 580 Posting Genius Featured Poster

500.

debasisdas 580 Posting Genius Featured Poster

500

debasisdas 580 Posting Genius Featured Poster

500

debasisdas 580 Posting Genius Featured Poster

hope you can understand them :(

How ?

you can rename the tables to A ,B,C and post the structure and their relations.

debasisdas 580 Posting Genius Featured Poster

500

debasisdas 580 Posting Genius Featured Poster

since the tables are related, once the data in the master table changes its dependent records can be made to change accordingly (by implementing some business logic) using a trigger.

can you please post your table structure for reference.

debasisdas 580 Posting Genius Featured Poster

500

debasisdas 580 Posting Genius Featured Poster

use this.

UPDATE runquery.table1 SET runquery.table1.Column1 = (SELECT (runquery.table2.Col1/runquery.table2.Col2*100) FROM  runquery.table2 WHERE runquery.table2.itemid = 3 AND runquery.table1.Userids = runquery.table2.userid),
runquery.table1.Column2 = (SELECT (runquery.table2.Col1/runquery.table2.Col2*100) FROM  runquery.table2 WHERE runquery.table2.itemid = 5 AND runquery.table1.Userids = runquery.table2.userid)
tomato.pgn commented: Nice work!!! +5
debasisdas 580 Posting Genius Featured Poster

500

debasisdas 580 Posting Genius Featured Poster

if you wan to automate the process, a trigger will do the trick for you .

debasisdas 580 Posting Genius Featured Poster

try this

select code, description, count(code) as total
group by code
debasisdas 580 Posting Genius Featured Poster

are the tables related ?

debasisdas 580 Posting Genius Featured Poster

I want to decide what to do due to the data values !

i really did not understand.

can you post some sample data for reference.

debasisdas 580 Posting Genius Featured Poster

i was asking about database not dataset.

debasisdas 580 Posting Genius Featured Poster

repeat the same for other column also.

debasisdas 580 Posting Genius Featured Poster
UPDATE runquery.table1 
SET runquery.table1.Column1 = (SELECT (runquery.table2.Col1/runquery.table2.Col2*100) FROM  runquery.table1 , runquery.table2 WHERE runquery.table2.itemid = 3 AND runquery.table1.Userids = runquery.table2.userid

is this working ?

debasisdas 580 Posting Genius Featured Poster

500

debasisdas 580 Posting Genius Featured Poster

try this, may work for you.

UPDATE runquery.table1 
SET runquery.table1.`Column1` = (select (runquery.table2.`Col1`/runquery.table2.`Col2`*100) from  runquery.table1 , runquery.table2 WHERE runquery.table2.`itemid` = 3 AND runquery.table1.`Userids` = runquery.table2.`userid`, runquery.table1.`Column2` = select (runquery.table2.`Col1`/runquery.table2.`Col2`*100) from  runquery.table1 , runquery.table2 WHERE runquery.table2.`itemid` = 5 AND runquery.table1.`Userids` = runquery.table2.`userid`;
debasisdas 580 Posting Genius Featured Poster

what is the underlying database ?

What is the query that you are using ?

debasisdas 580 Posting Genius Featured Poster

504

debasisdas 580 Posting Genius Featured Poster

508

debasisdas 580 Posting Genius Featured Poster

is the data being stored is case sensitive ?

Better to use LIKE inplace of = for character search.

try something like this

"select * from Movies WHERE upper(Movie_Name) like %'" & upper(txtMovieNamesearch.Text) & "'%"
debasisdas 580 Posting Genius Featured Poster

508

debasisdas 580 Posting Genius Featured Poster

508..

debasisdas 580 Posting Genius Featured Poster

5 0 8

debasisdas 580 Posting Genius Featured Poster

508

debasisdas 580 Posting Genius Featured Poster

502.

debasisdas 580 Posting Genius Featured Poster

502

debasisdas 580 Posting Genius Featured Poster

5 00

debasisdas 580 Posting Genius Featured Poster

500

debasisdas 580 Posting Genius Featured Poster

498

debasisdas 580 Posting Genius Featured Poster

488

debasisdas 580 Posting Genius Featured Poster

4 9 2

debasisdas 580 Posting Genius Featured Poster

492