public int InsertData(StudentDetailsData data)
{
DbHandiler.DbHandiler DbHandle = new DbHandiler.DbHandiler();
string sql = @"insert into student_data (SUBJECT1,SUBJECT2,ADDRESS,MARKS1,MARKS2,NAME,CLASS,AGE,SEX,UID) VALUES (@SUBJECT1,@SUBJECT2,@ADDRESS,@MARKS1,@MARKS2,@NAME,@CLASS,@AGE,@SEX,@UID);";
return(DbHandle.SaveData <StudentDetailsData>(sql, data));
}
public object UpdateToDb(StudentDetailsData data)
{
DbHandiler.DbHandiler DbHandle = new DbHandiler.DbHandiler();
string sql = @"UPDATE student_data SET SUBJECT1 = @SUBJECT1,SUBJECT2 = @SUBJECT2,ADDRESS = @ADDRESS ,MARKS1 = @MARKS1,
MARKS2 = @MARKS2,NAME = @NAME,CLASS = @CLASS ,AGE = @AGE,SEX = @SEX,UID = @UID
where ID = @ID ";
return(DbHandle.SaveData <StudentDetailsData>(sql, data));
}