Answer Posted / lalit

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[sp_VIEWQUALIFICATIONINFO]
@StdId INT
AS
SELECT * FROM Qualification
WHERE StdId=@StdId
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[sp_VIEWPERSONALINFO]
@StdId INT
AS
SELECT
FName,MName,LName,FatherName,Gender,DOB,MStatus,Email,Phone,
Mobile,CourseID,Status FROM personalinfo
WHERE StdId=@StdId\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

protected void Button1_Click(object sender, EventArgs e)
{
ds = objd1.GetDetailsById(Convert.ToInt32
(txtstudentid.Text));
ds =objd1.GetPersonalInfoById(Convert.ToInt32
(txtstudentid.Text));
grdqualificationinfo.DataSource=ds.Tables
["Qualification"];
grdqualificationinfo.DataBind();
grdpersonalinfo.DataSource=ds.Tables
["personalinfo"];
grdpersonalinfo.DataBind();
lblqualinfo.Visible = true;
lblpersonalinfo.Visible = true;
//objrd = objd1.GetDetailsById(Convert.ToInt32
(txtstudentid.Text));
//objrd.Read();


//txtcoursename.Text = objrd[0].ToString();
//txtcoursefees.Text = objrd[1].ToString();

lblcoursefees.Visible = true;
lblcoursename.Visible = true;
txtcoursename.Visible = true;
txtcoursefees.Visible = true;


}
//////////////////////////////////////////
class////////////////////////

public DataSet GetPersonalInfoById(int StdId)
{
con.Close();
con.Open();
cmd = new SqlCommand("sp_VIEWPERSONALINFO", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StdId",StdId);
adap = new SqlDataAdapter(cmd);
adap.Fill(ds, "personalinfo");
return ds;
}

public DataSet GetDetailsById(int StdId)
{
con.Close();
con.Open();
cmd = new SqlCommand("sp_VIEWQUALIFICATIONINFO",
con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("StdId",StdId);
adap = new SqlDataAdapter(cmd);
adap.Fill(ds, "Qualification");
return ds;
}

What is abstraction in oops with example?

1216

---

What is ambiguity in inheritance?

1050

---

What is the full form of oops?

1120

---

What is multilevel inheritance in oop?

970

---

Why oops is important?

1026

---

How many human genes are polymorphic?

1000

---

Why do we use class in oops?

914

---

What are oops functions?

961

---

What is overriding vs overloading?

1004

---

What is difference between inheritance and polymorphism?

975

---

What is interface? When and where is it used?

2105

---

What is encapsulation and abstraction? How are they implemented in C++?

1064

---

What causes polymorphism?

1067

---

program for insertion ,deletion,sorting in double link list

2629

---

What is new keyword in oops?

992

---