public static void boolLoadFromCSV(string fileName) { List<StudentModel> studentModel = new List<StudentModel>(); StudentModel tempStudent = new StudentModel(); _studentToDBObject = new StudentToDB(_connectionString); using (var fileReader = new StreamReader(fileName)) { string line; string[] details; while ((line = fileReader.ReadLine()) != null) { details = line.Split(','); tempStudent.Name = details[0]; tempStudent.EnrollmentNumber = Convert.ToInt32(details[1]); tempStudent.Marks = Convert.ToInt32(details[2]); tempStudent.Age = Convert.ToInt32(details[3]); tempStudent.Gender = details[4]; studentModel.Add(tempStudent); } } _studentToDBObject.InsertStudent(studentModel); }
public void WriteToCsvFile() { FileStream writerObject = File.Create("C:\\hack\\Write.csv"); writerObject.Close(); SqlConnection connection = new SqlConnection(_connectionString); connection.Open(); string query = @"select * from Student"; SqlCommand command = new SqlCommand(query, connection); SqlDataReader reader = command.ExecuteReader(); StudentModel studentModelObject; using (StreamWriter writer = new StreamWriter("C:\\hack\\Write.csv")) { while (reader.Read()) { studentModelObject = new StudentModel(); studentModelObject.Name = reader["Name"].ToString(); studentModelObject.EnrollmentNumber = Convert.ToInt32(reader["EnrollmentNumber"].ToString()); studentModelObject.Marks = Convert.ToInt32(reader["Marks"].ToString()); studentModelObject.Age = Convert.ToInt32(reader["Age"].ToString()); studentModelObject.Gender = reader["Gender"].ToString(); writer.Write(studentModelObject.Name + ","); writer.Write(studentModelObject.EnrollmentNumber + ","); writer.Write(studentModelObject.Marks + ","); writer.Write(studentModelObject.Age + ","); writer.Write(studentModelObject.Gender); } } connection.Close(); }