要写一个数据操作类,操作的表是Contac,字段:title,content,inputtime如何实现以下5个方法,应该怎么写呢?谢谢!!!! 1、public DataSet GetAllContacts() //获取Contact表的所有记录
{
try
{
// TO DO: Implement
return new DataSet();
}
catch (Exception ex)
{
return new DataSet();
}
} 2、public DataSet SearchContacts() //搜索Contact中符合要求的纪录
{
try
{
// TO DO: Implement return new DataSet();
}
catch (Exception ex)
{
return new DataSet();
}
} 3、public DataSet GetContactDetails(int aContactId) //获取某条详细记录。
{
try
{
// TO DO: Implement return new DataSet();
}
catch (Exception ex)
{
return new DataSet();
}
} 4、public void UpdateContact(int aContactId) //修改记录
{
try
{
// TO DO: Implement
}
catch (Exception ex)
{
}
} 5、public void AddContact(string aFirsName, string aSurname, string aCompany,
string aJobTitle, string aEmail, DateTime aStartDate) //添加记录
{
try
{
}
catch (Exception ex)
{
string str=ex.ToString();
} }
{
try
{
// TO DO: Implement
return new DataSet();
}
catch (Exception ex)
{
return new DataSet();
}
} 2、public DataSet SearchContacts() //搜索Contact中符合要求的纪录
{
try
{
// TO DO: Implement return new DataSet();
}
catch (Exception ex)
{
return new DataSet();
}
} 3、public DataSet GetContactDetails(int aContactId) //获取某条详细记录。
{
try
{
// TO DO: Implement return new DataSet();
}
catch (Exception ex)
{
return new DataSet();
}
} 4、public void UpdateContact(int aContactId) //修改记录
{
try
{
// TO DO: Implement
}
catch (Exception ex)
{
}
} 5、public void AddContact(string aFirsName, string aSurname, string aCompany,
string aJobTitle, string aEmail, DateTime aStartDate) //添加记录
{
try
{
}
catch (Exception ex)
{
string str=ex.ToString();
} }
{
try
{
SqlClient.SqlDataAdapter adpt = new SqlClient.SqlDataAdapter("select * from Contac",myConnection);
DataSet ds = new DataSet();
adpt.Fill(ds);
return ds;
}
catch (Exception ex)
{
return new DataSet();
}
}
2、public DataSet SearchContacts(string filter) //搜索Contact中符合要求的纪录
{
try
{
SqlClient.SqlDataAdapter adpt = new SqlClient.SqlDataAdapter("select * from Contac where " + filter ,myConnection);
DataSet ds = new DataSet();
adpt.Fill(ds);
return ds;
}
catch (Exception ex)
{
return new DataSet();
}
}
3、public DataSet GetContactDetails(int aContactId) //获取某条详细记录。
{
try
{
SqlClient.SqlDataAdapter adpt = new SqlClient.SqlDataAdapter("select * from Contac where ContactId=" + aContactId.ToString()) ,myConnection);
DataSet ds = new DataSet();
adpt.Fill(ds);
return ds;
}
catch (Exception ex)
{
return new DataSet();
}
} 4、public void UpdateContact(int aContactId,string atitle,string acontent,string ainputtime) //修改记录
{
try
{
SqlClient.SqlCommand cmd = new SqlClient.SqlCommand ("update Contac set title='" + atitle + "',content='" +acontent+ "',inputtime='" + ainputtime + "' where ContactId=" +aContactId.ToString(),MyConnection);
cmd.Conection.Open();
int re =cmd.ExecuteNonQuery();
if(re==0)
{
//失败;
}
else
{
//成功;
}
}
catch (Exception ex)
{
}
}
5、public void AddContact(string aFirsName, string aSurname, string aCompany,
string aJobTitle, string aEmail, DateTime aStartDate) //添加记录
{
try
{ SqlClient.SqlCommand cmd = new SqlClient.SqlCommand ("insert Contac (FirsName,Surname,Company,JobTitle,Email,StartDate) Values ('"+ aFirsName + "','" + aSurname + "',"" + aCompany + "','" + aJobTitle + "','" + aEmail + "','" + aStartDate.ToString() + "')" ,MyConnection);
cmd.Conection.Open();
int re =cmd.ExecuteNonQuery();
if(re==0)
{
//失败;
}
else
{
//成功;
}
}
catch (Exception ex)
{
string str=ex.ToString();
} }