matching recordes from two table and pop up messsage

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi ...

I have two table Requirements and New products and three forms in windows application.

for ex. When i insert any recorde in Requirements table and after that if i enter same recorde in New products table then one message should be prompt at my first form if both the table value matched.

In this case do i need work on java script?

i need this concept in my project becoz my project is based on customer call center.

Thanks in advance !!!

Posted 5-Jul-12 1:57am

Sanna_001

Add a Solution

Comments

Stephen Hewison 5-Jul-12 10:40am

You will only need Javascript if this was a web based project. But in your question you reference a "windows application". Windows application don't natively support Javascript. In c# for pop up messages there is a MessageBox class for creating Javascript "alert" style pop up messages.

Sanna_001 6-Jul-12 2:43am

Stephen Hewison Thanks :)
I have tried that also but its not working as i want.. can you please give me any other code, which will help me better way.

ZurdoDev 5-Jul-12 11:11am

If it is a windows app you do not need javascript. However, what you are doing is very unclear.

Sanna_001 6-Jul-12 2:41am

ryanb31 I have two tables and For example,
If in Requirement table i have inserted one record... Sony Lcd0012 30000
and after that i
inserted one record in New product table...Sony Lcd0012 30000

So in this case if both the value are same message will prompt.

MAU787 6-Jul-12 8:05am

while adding in New products table why dont you make a query in db for checking whether that value is already available in Requirements table..it will make simple

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tejas Vaishnav · Answer 1 · 2012-07-05T20:04:00

First of all "THERE IS NO CONCEPT FOR JAVASCRIPT IN WINDOWS APPLICATION", so forgot that way.

you can achive your requirement with many ways in windows application.

first one is using thread

http://msdn.microsoft.com/en-us/library/5xt1dysy%28VS.80%29.aspx[^]

The key to multi-threaded Windows Forms UI interaction[^]

the other way is using windows service

Simple Windows Service Sample[^]

http://www.c-sharpcorner.com/uploadfile/mahesh/window_service11262005045007am/window_service.aspx[^]