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 polymorphism and example?

1047

---

class type to basic type conversion

2408

---

Why is abstraction needed?

1037

---

assume the program must insert 4 elements from the key board and then do the following programs.sequential search(search one of the elements),using insertion sort(sort the element) and using selection sort(sort the element).

2114

---

What does sksksk mean in text slang?

2121

---

What are oops functions?

1018

---

What do you mean by variable?

1038

---

What is oops and why we use oops?

1045

---

What is class encapsulation?

1095

---

What language is oop?

1009

---

how to get the oracle certification? send me the answer

2159

---

Give an example where we have to specifically use C programming language and C++ programming language cannot be used?

1635

---

Will I be able to get a picture in D drive to the c++ program? If so, help me out?

2197

---

Why we use classes in oop?

1040

---

What is object and example?

1178

---