See the following scenario: Tables for the question:

Table : T1
c10 c12

---

e1 A
e2 B
e3 C

Table: T2

c1 c2 c3 c4 c5 C6

---

1 P e1 e2 null X
2 Q e3 null null Y
3 R e2 e1 null X
4 S e3 e1 e2 Z

The c3, c4 and c5 columns of T2 table depends on c12 column of T1 table.

I want the following output:

c1 c2 c3 c4 c5

---

1 P A B null
2 Q C null null
3 R B A null
4 S C A B

Can you help me to write an SQL to retrieve the above output from the table T1 and T2? The SQL may be like:

Select c1, c2, t1.c12 as c3....... from t1, t2 where join condition

But I am not getting the actual sql in my mind. So please help me regarding this.

Thanks for your suggestion. There are lots of online help for detecting face. There are some API to detect face from an image. But I am not getting any efficient code to detect teeth from face using c#. I am reading different articles but still can't code them. thanks.

Still not got any good solution..

if there is not teeth then it will show a message. But if it detect teeth then it will show another message.

sorry for using the wrong words. Actually I really need this..

Hi all, I can detect face and specific color using c# and open cv. I hardly need code/ link/ help to detect teeth using c# and openCV. Waiting for your helps.

You have done this using sql server. But How can I do this for oracle??

Thanks for your nice suggestion!!!. My above case is just an example. Actually I need something that will do insert/update/delete on a table every week or after a specific period of time. Is there any type of trigger can do this type of operation??

Suppose some one purchased a ticket online. [Here the value of a column is pending] If the person does not pay the cash money within 24 hours than the ticket will be automatically cancelled. [The value of the status column will be cancelled after 24 hours] So, How can I do automatic update of a table after 24 hours???

I am having another problem after showing the notifier in my console application. I have added context menu. But this is not showing any menu after right click in my notifier. How to solve this???

I need answer please help meee...

I don't have any idea about message pump. My console application is working as a server (in client server socket programming). I wrote the code for notify icon in the main function. Can I have links or example code that will help me to display the context menu in the notify icon of my console application??

I have written the following code. It displays the notify icon in the system tray. But when I right click on the icon in the system it's not showing any menu there. I can't understand why this is not showing the menu. Can someone help me to show this?

ContextMenuStrip cms = new ContextMenuStrip();

        ToolStripMenuItem mI1 = new ToolStripMenuItem();
        mI1.Text = "Exit";

        mI1.Click += new EventHandler(Click\_Handler); //Add 

        cms.Items.Add(mI1);
       
        notifyIcon1.ContextMenuStrip = cms;
        notifyIcon1.Visible = true;
        
        
        notifyIcon1.Visible = true;
        notifyIcon1.BalloonTipTitle = "My service";
        notifyIcon1.Icon = new Icon("utility1.Ico");
        notifyIcon1.BalloonTipText = "Started Successfully";
        notifyIcon1.Text = "Service is running";
        notifyIcon1.ShowBalloonTip(500);

Actually I tried it without adding the references. Now this is working fine. thanks.

Thanks a lotz.......

I want a notifier in the system tray for my c# console application. When I will start my console application it should should notify me and will stay in the system tray. That means in the task bar like antivirus, DAP etc). I can create it for windows application. But I need help to do it for console application...

suppose your treeview name is treeview1. use treeview1.nodes.add(your desired form name); for child node : treeview1.nodes[index].nodes.add(your control name); from the treeview1 property true the value of checkbox property. handle the afterselect event and check whither the e.Node.Checked return true or false. Then take necessary action as you want

if you want to run it pragmatically then you can use socket programming to do that.

you can change the dropdownstyle property of combobox to dropdownlist. Then the user will not be able to change the content.

add a string variable int the form that has the grid view. overload the constructor that take a string argument. You have to initialize the string variable by the given parameter.Then call the constructor from the form that has the texbox as follows: gridviewform f = new gridviewform(texbox1.text); f.Show(); write this code in the formload event of form that has the grid view. int p = dataGridView1.Rows.Add(); dataGridView1.Rows[p].Cells[0].Value = your string variable