|
I had following two tables
Emp Table
EmpId Ename Sal Deptno
101 A 10000.00 10
102 B 20000.00 20
103 C 25000.00 30
104 D 30000.00 20
105 E 40000.00 10
Dept Table
Deptno Dname Loc
10 Marketing Hyderabad
20 Sales Mumbai
30 Purchase Delhi
40 Computers Banglore
50 Physics Chennai
I want to display deptno,dname not in the emp table
the following output from both the tables by using Joins
(Note: without use subquerys )
Deptno Dname
40 Banglore
50 Chennai
|
|
|
|
|
This is not the SQL forum
I don't see how the first table defines which items you want from the second ?
Oh, you want to seleect where deptno not in (select distinct deptno from Emp) ? I don't see how else to do that.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
i am not able to connect to a MySQL database.
i am using this connectionstring "Driver={MySQL};SERVER=myserver; DATABASE=newdatabase;USER=root;PASSWORD=nvish;option=3;"
is there anything special i need to get installed i.e. any connecter / driver or need to include any namespace ?
Ashish Sehajpal
|
|
|
|
|
|
Any specific error message? Do you have the MySQL ODBC drivers in your system installed?
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Hi,
I am using application and that will be access using
www.abc.com
With the Register.aspx form I am creating directory on the server say user1
Now other site is called www.xyz.com I am using same application that is used in www.abc.com but when I registered on abc.com using Register.aspx I have to create same directory on xyz.com server which is(user1) created on abc.com server.
How can I do?
Thanks
|
|
|
|
|
You can have an ASPX page on the other website to which you can send a request through XmlHttp or a WebRequest to complete this action.
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
i want to find out difference between two times as 8:00am and 12:00pm
|
|
|
|
|
Subract one datetime from another and you will get a timespan
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi,
I want to make a Horizontal Menu control
should list only 5 menus in a row .
Means if menu Items are 10 then it should list in following manner
Menu1 | Menu2 |Menu3| Menu4 | Menu5
Menu6 | Menu7 |Menu8| Menu9 | Menu10
Please Help
Thanks
Kaushal Kishore
|
|
|
|
|
Did you check out http://www.dynamicdrive.com/[^]?
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Hi,
I am adding radion buttons dynamically using Radiobutton list control. after that added Radiobuttonlist to panel control. now when ever I click Next button I have to get which radion button has selected... how to loop through the panel and radio button list control to get selected radionbutton. Can anyone help me. this is very urgent.
Thanks.
|
|
|
|
|
Dynamcially added controls don;t have viewstate,but I think the button names will appear in the post data.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi,
Can anyone let me know how to add Scrolling facility to TabContainer if the number of tabs is more than 10.
I can get the tabs in a new row.But I need to display only 10 tabs at a time and rest of the tabs will come when u scroll.
Thanks in advance
Vijay Mesa
|
|
|
|
|
i have a page with " marquee " showing some images scrolling left. Its well displayed with internet explorer but not with mozilla firefox
coolsatty
|
|
|
|
|
You may want to check whether MARQUEE is actually supported in the version of Firefox you are targeting.
cheers,
Chris Maunder
CodeProject.com : C++ MVP
|
|
|
|
|
i want to convert binary my text and then write it in stream . how can i do this?
|
|
|
|
|
I don't know what you mean - what is binary and you want it converted ?
Response.Write or Response.BinaryWrite are probably part of the solution, but I don't know what the problem is.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
string txt = "a text string";
System.Text.Encoding encode = System.Text.Encoding.ASCII;
byte[] myByteArray = enc.GetBytes(txt);
i convert the string to binary with this code. and now i want write myByteArray in stream. ????
|
|
|
|
|
This is a waste of time.
Response.Write("a text string") will work just fine.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hello friends
I am using Modal Popup control in my aspx page...its working fine
I want to redirect the page to another page when the Ok button is clicked
I tried with writing click event ...result ..!
I tried with writing postback url result ....!
please tell me how to do this
thank you
If You win You need not Explain............
But If You Loose You Should not be there to Explain......
|
|
|
|
|
I think BASE tag to indicate the operations should work on the same window should apply right?
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Currently i m using ASP.NET with C# (.net 2005, 2.0 framework)
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=test.doc");
Response.Charset = "";
Response.ContentType = "application/vnd.doc";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
DataGrid123.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
The above coding i used to EXPORT data datagrid to excel.
The same i did for TEXTBOX to MS-WORD like.........
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=test.doc");
Response.Charset = "";
Response.ContentType = "application/vnd.doc";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
txterrorbox.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
But i m getting error "Control 'txterrorbox' of type 'TextBox' must be placed inside a form tag with runat=server."
Note : The textbox is placed inside the form tag and assigned runat=server
how to export the TEXTBOX content to an MS-WORD document?
how to achieve it? - KARAN
modified on Monday, May 5, 2008 7:02 AM
|
|
|
|
|
Karan_TN wrote: Note : The textbox is placed inside the form tag and assigned runat=server
I doubt that. Note, the error is talking abuot a different textbox to the one you are trying to read from.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
sorry chris... pardon....
right now i have changed the line properly.
actually i checked all.
coding is right.
but this error is pop-up'ing.......
help me.............
|
|
|
|