select EnrollmentNo =(select enrollmentNo from StudentMst where Student_ID = a.Student_ID),
 a.Hobbies,a.MedicalConditions,

 a.Emergency_Note,a.FatherOccupation,a.FatherDesignation,a.Father_Qual,
   a.Monthly_Income,a.MotherOccupation,a.MotherDesignation,
   Parent_MobileNo =(select Mobile from ParentMst where ParentID = (select top 1 ParentID from Parent_Student_Rel where Student_ID = a.Student_ID )),
   a.Prev_School_Percentage,
   a.Prev_School_Rank,a.Prev_School_FromDate,a.Prev_School_Todate,a.Father_FirstName,a.Father_LastName,a.Mother_FirstName

 from Student_Detail a

Comments

Post a Comment

Popular posts from this blog

ASP.NET Interview Questions – Beginner Level (Part 1)

What is ASP.NET?     Microsoft ASP.NET is a server side technology that enables programmers to build dynamic Web sites, web       applications, and XML Web services. It is a part of the .NET based environment and is built on the Common        Language Runtime (CLR) . So programmers can write ASP.NET code using any .NET compatible language. What are the differences between ASP.NET 1.1 and ASP.NET 2.0? A comparison chart containing the differences between ASP.NET 1.1 and ASP.NET 2.0 can be found ove r Which is the latest version of ASP.NET? What were the previous versions released? The latest version of ASP.NET is 2.0. There have been 3 versions of ASP.NET released as of date. They are as follows : ASP.NET 1.0 – Released on January 16, 2002. ASP.NET 1.1 – Released on April 24, 2003. ASP.NET 2.0 – Released on November 7, 2005. Additionally, ASP.NET 3.5 is tentatively to be released by the end of the 2007. Explain the...
Read more
string file_name = "D:\\Project\\test1.sql";         string text_line = "";         string obj;         obj = txtWrite.Text.ToString();         System.IO.StreamWriter  objwriter;         objwriter = new System.IO.StreamWriter(file_name);         string[] aryLines = new string[1];         aryLines[0] = "use";           for (int i = 0; i < 1; i++)         {             text_line = text_line + aryLines[i];             objwriter.Write(aryLines[i]);             objwriter.Write(txtWrite.Text);         }                     objwriter.Close();
Read more

Asp Login Form

SQL Procedure alter PROCEDURE [dbo].[LoginPro]   @Email as varchar(50), @password as varchar(50)   AS   BEGIN   SELECT Email, Password FROM Registration WHERE Email=@Email AND Password=@Password --we compare the values from the application we got with the values in the database       END Login Page protected void Btn_Login_Click(object sender, EventArgs e)     {        // int k = 0;         string user;         string pass;             user = txtusername.Text.ToString();             pass = txtpassword.Text.ToString();             if (user == "" || pass == "")             {                 lblMsg.Text = "can't blank user name and password";             }   ...
Read more