Open source directions for .Net

Some open source directions for .Net :

http://csharp-source.net

http://www.codeplex.com

Simple data access method of ADO .net

ADO .net

1. Simple data access method for scalar exceute.

2. Simple data access method for dataset return.

public object GetQuickPayFee()
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = “select cast(replace(feesamount,’%',”) as decimal(18,3)) from fees where feesid=25″;
            //cmd.CommandText = “select sum(cast(replace(feesamount,’%',”) as decimal(18,3))) from fees where feesid=1 or feesid=20″;
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
            conn.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dbConnection"].ToString();
            conn.Open();
            cmd.Connection = conn;
            try
            {
                return cmd.ExecuteScalar();
            }
            catch
            {
                return 0;
            }
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name=”email”></param>
        /// <returns></returns>
        public DataSet ForgotCardInformation(string email)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = “Select CardNumber,CardCode from Accountinfo where Email = ‘” + email + “‘  and CardStatus <> 1″;//”Proc_GetCardInfo”;
            //cmd.CommandType = CommandType.StoredProcedure;
            //cmd.Parameters.Add(“@email”, SqlDbType.NVarChar, 50).Value = email;
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
            conn.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dbConnection"].ToString();
            conn.Open();
            cmd.Connection = conn;
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            return ds;
        }

programtically add meta tags

How to programtically add  meta tags in C#:

http://www.joshsalwen.com/PermaLink,guid,143b79f6-f235-4a56-8ba0-f0aff98adb99.aspx