Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
Guy's kung sino merong installer for Visual Studio 2008, pa share naman dyan.
Na delete kasi yung akin, nahihirapan ako maghanap xD
Pa share naman
public void updateData() {
try
{
using (System.Data.SqlServerCe.SqlCeConnection cnn = new SqlCeConnection(ConnectionString))
{
cnn.Open();
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE Student_Information SET ");
sql.Append("FirstName =@FirstName, MiddleName=@MiddleName, LastName=@LastName, ");
sql.Append("SuffixName =@SuffixName, Gender=@Gender, ");
sql.Append("Address=@Address, Age=@Age, Birthdate=@Birthdate, ");
sql.Append("FatherName=@FatherName, FatherOccupation=@FatherOccupation, ");
sql.Append("MotherName=@MotherName, MotherOccupation=@MotherOccupation ");
sql.Append("WHERE ");
sql.Append("StudentID = @StudentID");
string sqlUpdate = sql.ToString();
System.Data.SqlServerCe.SqlCeCommand cmd = new SqlCeCommand(sqlUpdate, cnn);
cmd.Parameters.AddWithValue("@StudentID", ReferenceID);
cmd.Parameters.AddWithValue("@FirstName", Firstname);
cmd.Parameters.AddWithValue("@MiddleName", Middlename);
cmd.Parameters.AddWithValue("@LastName", Lastname);
cmd.Parameters.AddWithValue("@SuffixName", Suffixname);
cmd.Parameters.AddWithValue("@Age", Age);
cmd.Parameters.AddWithValue("@Birthdate", Birthdate);
cmd.Parameters.AddWithValue("@Gender", Gender);
cmd.Parameters.AddWithValue("@Address", Address);
cmd.Parameters.AddWithValue("@FatherName", FatherName);
cmd.Parameters.AddWithValue("@FatherOccupation", FatherOccupation);
cmd.Parameters.AddWithValue("@MotherName", MotherName);
cmd.Parameters.AddWithValue("@MotherOccupation", MotherOccupation);
cmd.ExecuteNonQuery();
}
}
catch (Exception)
{
throw;
}
}public DataSet customSelectData() {
try
{
StringBuilder sql = new StringBuilder();
sql.Append("SELECT StudentID, FirstName, MiddleName, LastName, SuffixName, ");
sql.Append("Age, Birthday, Gender, Address ");
sql.Append("FROM Student_Information");
sql.Append(" WHERE StudentID = @ID");
string sqlSelect = sql.ToString();
System.Data.SqlServerCe.SqlCeConnection cnn = new SqlCeConnection(ConnectionString);
System.Data.SqlServerCe.SqlCeCommand cmd = new SqlCeCommand(sqlSelect, cnn);
cmd.Parameters.AddWithValue("@ID",ReferenceID);
System.Data.SqlServerCe.SqlCeDataAdapter da = new SqlCeDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
catch (Exception ex)
{
ErrorMessage(ex.ToString());
}
return null;
}@kudeta21, nice active...... minsan yun mga ngtatanong dito hindi muna naggoogle e..
active na active to ahhh
gusto ko sana matuto nito pero layo ng course ko dito
pwede po ba paturo?from zero
