public ActionResult edit(string id, string gid) { Populate DropDown = new Populate(); Db_Connection dbconn = new Db_Connection(); try { dbconn.openConnection(); string strSQL = @"SELECT ACCESSORIES FROM ACCESSORIES WHERE ID=@ID AND GID=@GID"; SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn); cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = id; cmd.Parameters.Add("GID", SqlDbType.VarChar).Value = gid; SqlDataReader dr = cmd.ExecuteReader(); mdlAccessories record = new mdlAccessories(); record.ID = id; record.GID = gid; if (dr.HasRows) { dr.Read(); record.ID = id; record.GID = gid; record.ACCESSORIES = dr["ACCESSORIES"].ToString(); } return(PartialView(record)); } finally { dbconn.closeConnection(); } }
// // GET: /en/Firearmtype/ public ActionResult Index() { Db_Connection dbconn = new Db_Connection(); Utility util = new Utility(); try { dbconn.openConnection(); string strSQL = ""; strSQL = @"SELECT ID,GID,ACCESSORIES FROM ACCESSORIES ORDER BY ACCESSORIES ASC"; SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn); SqlDataReader dr = cmd.ExecuteReader(); List <mdlAccessories> record = new List <mdlAccessories>(); if (dr.HasRows) { while (dr.Read()) { mdlAccessories list = new mdlAccessories(); list.ID = dr["ID"].ToString(); list.GID = dr["GID"].ToString(); list.ACCESSORIES = dr["ACCESSORIES"].ToString(); record.Add(list); } } dr.Dispose(); cmd.Dispose(); dbconn.closeConnection(); return(View(record)); } finally { dbconn.closeConnection(); } }