This is the result of a simple try-out.
using System;
// Generated by http://www.csharpfriends.com
namespace DotNetJunkies
{
public class WebLogs
{
// private members
string _strName;
string _strAuthor;
DateTime _dtLastUpdate;
int _iNumberOfPosts;
object _oLastEntry;
// empty constructor
public WebLogs ()
{
}
// full constructor
public WebLogs (string Name, string Author, DateTime LastUpdate, int NumberOfPosts, object LastEntry)
{
this._strName = Name;
this._strAuthor = Author;
this._dtLastUpdate = LastUpdate;
this._iNumberOfPosts = NumberOfPosts;
this._oLastEntry = LastEntry;
}
// public accessors
public string Name
{
get { return _strName;}
set { _strName = value; }
}
public string Author
{
get { return _strAuthor;}
set { _strAuthor = value; }
}
public DateTime LastUpdate
{
get { return _dtLastUpdate;}
set { _dtLastUpdate = value; }
}
public int NumberOfPosts
{
get { return _iNumberOfPosts;}
set { _iNumberOfPosts = value; }
}
public object LastEntry
{
get { return _oLastEntry;}
set { _oLastEntry = value; }
}
}
}
using System;
using System.Data;
using System.Data.Client;
namespace DotNetJunkies.Data
{
public class SqlDataProvider
{
public SqlDataProvider(){}
public void AddWebLogs(WebLogs WebLogs)
{
// Initialize SPROC
SqlConnection conn = new SqlConnection(Globals.ConnectionString);
SqlCommand cmd = new SqlCommand("DotNetJunkies_WebLogs_Add", conn);
cmd.CommandType = CommandType.StoredProcedure;
// Add Parameters
cmd.Parameters.Add("@Name", WebLogs.Name;)
cmd.Parameters.Add("@Author", WebLogs.Author;)
cmd.Parameters.Add("@LastUpdate", WebLogs.LastUpdate;)
cmd.Parameters.Add("@NumberOfPosts", WebLogs.NumberOfPosts;)
cmd.Parameters.Add("@LastEntry", WebLogs.LastEntry;)
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public void UpdateWebLogs(WebLogs WebLogs)
{
// Initialize SPROC
SqlConnection conn = new SqlConnection(Globals.ConnectionString);
SqlCommand cmd = new SqlCommand("DotNetJunkies_WebLogs_Update", conn);
cmd.CommandType = CommandType.StoredProcedure;
// Update Parameters
cmd.Parameters.Add("@Name", WebLogs.Name;)
cmd.Parameters.Add("@Author", WebLogs.Author;)
cmd.Parameters.Add("@LastUpdate", WebLogs.LastUpdate;)
cmd.Parameters.Add("@NumberOfPosts", WebLogs.NumberOfPosts;)
cmd.Parameters.Add("@LastEntry", WebLogs.LastEntry;)
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public void DeleteWebLogs(WebLogs WebLogsID)
{
// Initialize SPROC
SqlConnection conn = new SqlConnection(Globals.ConnectionString);
SqlCommand cmd = new SqlCommand("DotNetJunkies_WebLogs_Delete", conn);
cmd.CommandType = CommandType.StoredProcedure;
// Delete Parameters
cmd.Parameters.Add("@WebLogsID", WebLogsID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public WebLogs GetWebLogsByID(WebLogs WebLogsID)
{
// Initialize SPROC
SqlConnection conn = new SqlConnection(Globals.ConnectionString);
SqlCommand cmd = new SqlCommand("DotNetJunkies_WebLogs_GetByID", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = null;
WebLogs webLogs = null;
// GetByID Parameters
cmd.Parameters.Add("@WebLogsID", WebLogsID);
// Execute
conn.Open();
reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if(reader.Read())
{
webLogs = SqlDataHelpers.PopulateWebLogsFromSqlDataReader(reader);
{
conn.Close();
return webLogs;
}
public static WebLogs PopulateWebLogsFromSqlDataReader(SqlDataReader dr)
{
WebLogs webLogs = WebLogs;
webLogs.Name = Convert.ToString(dr["Name"]);
webLogs.Author = Convert.ToString(dr["Author"]);
webLogs.LastUpdate = Convert.ToDateTime(dr["LastUpdate"]);
webLogs.NumberOfPosts = Convert.ToInt32(dr["NumberOfPosts"]);
webLogs.LastEntry = (dr["LastEntry"]);
}
}
}