Select empid, fname, LName, Grade, Desination, Dept_name from Employee JOIN department on Department.Dept_id = Employee.Dept_id (you cqn use LEFT JOIN to get all employees, even those have Dept_Id=null.)
Rédha.
R
RedhaDev
@RedhaDev
Posts
-
Help required in joins -
Error : "Operation must use an updateable query"Hi every one. I have this message error each time I try to update my DB in my website. System.Data.OleDb.OleDbException: Operation must use an updateable query it works so fine on my PC but not on the remote server. my code is :
this.Adapter.InsertCommand.ExecuteNonQuery(); return returnValue;Can anybody help me please ?Rédha.
-
securing web pages using forms authenticationIn my example I used the authentication form of Visual Studio and its "Authenticate" event. There's no use of cookies.
The novice.
-
securing web pages using forms authenticationI prefer using Session variables rather than cookies because some users disable cookies of their navigators. It's so easy to use !! 1. Authenticate event in the login page :
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { if ((username.text="pradip") && (password.text="pkc" )) Session["Authenticated"] = "Ok"; }2. on_Load event of every Secured page :if (Session["Authenticated"].ToString() != "Ok") RedirectToLognPage().....The novice.
-
Please Help.Hi, I need to get the IP Adress (and many othe infos) of any user of my ASP.Net (web) application. I looked arround the 'System.Web.HttpBrowserCapabilities' but there is no way to get the IP Adress. Thanks a lot The novice.
-
Code protectionHi, Is there any way to protect my ASP.Net code before installing it ? The novice.
-
SessionThe server will close automatically any session after 20 minutes of inaticity. you can modify this parameter (20 min) in your Web.config file. or by using the command "Session.timeout = 44;" (44 minutes for exp). To clear all Session variables => "Session.Clear();" Regards The novice.
-
Where to insert the codeif (!this.IsPostBack) { // Your code } The novice.
-
Hash Table in C#Hi, yes of course, by using the "Hashtable" class. Hashtable myHashTable = new Hashtable(); to instantiate a Hashtable object. myHashTable.Add("theKey", "theValue"); to add an element myHashTable["theKey"]...; to retrieve a "value" usig its "key" myHashTable.Keys; to retrieve the Keys Collection property and myHashTable.Values; to retrieve the Values Collection property Regards. -- modified at 5:03 Friday 14th April, 2006