public bool SaveData(StudentList st)
{
SqlConnection con = new SqlConnection("Data Source=POLO_DEV_PC\\SQLEXPRESS;Initial Catalog=PFMSDB;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Insert into StudentDetail (id,name,address,section,marks) Values(@id,@name,@address,@section,@marks) ", con);
cmd.Parameters.AddWithValue("@id",st.Id);
cmd.Parameters.AddWithValue("@name", st.Name);
cmd.Parameters.AddWithValue("@address", st.Address);
cmd.Parameters.AddWithValue("@section", st.Section);
cmd.Parameters.AddWithValue("@marks", st.Marks);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return true;
}
public ActionResult Create(FormCollection c)
{
StudentList s = new StudentList();
s.Id = c["id1"].ToString();
s.Name = c["name1"].ToString();
s.Address = c["address1"].ToString();
s.Section = c["section1"].ToString();
s.Marks = int.Parse(c["marks1"].ToString());
if (SaveData(s))
{
ViewBag.Msg = "Successfully Added";
}
else
ViewBag.Msg = "Error";
return View();
}
public List<StudentList> GetStudentList()
{
List<StudentList> s=new List<StudentList>();
SqlConnection con = new SqlConnection("Data Source=POLO_DEV_PC\\SQLEXPRESS;Initial Catalog=PFMSDB;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Select * from StudentDetail", con);
SqlDataReader dr;
con.Open();
dr=cmd.ExecuteReader();
while(dr.Read())
{
StudentList stud = new StudentList();
stud.Id = dr.GetValue(0).ToString();
stud.Name = dr.GetValue(1).ToString();
stud.Address = dr.GetValue(2).ToString();
stud.Section = dr.GetValue(3).ToString();
stud.Marks = int.Parse(dr.GetValue(4).ToString());
s.Add(stud);
}
con.Close();
return s;
}
public StudentList ShowData(string id)
{
StudentList s = new StudentList();
SqlConnection con = new SqlConnection("Data Source=POLO_DEV_PC\\SQLEXPRESS;Initial Catalog=PFMSDB;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Select id,name,address,section,marks from StudentDetail where id=@id ", con);
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader dr;
con.Open();
dr = cmd.ExecuteReader();
while(dr.Read())
{
s.Id = dr.GetValue(0).ToString();
s.Name = dr.GetValue(1).ToString();
s.Address = dr.GetValue(2).ToString();
s.Section = dr.GetValue(3).ToString();
s.Marks = int.Parse(dr.GetValue(4).ToString());
}
con.Close();
return s;
}