Friday, May 15, 2009

Simple steps for starting program

BASEDB.CS


using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using DataAccessLayer;
using BusinessLogic;


///
/// Summary description for BaseDB
///

namespace DataAccessLayer
{
public class BaseDB
{
///
/// This is a comman function which is used by various class files for getting dataset.
///

/// sqlcommand type object
/// Dataset which holds all the values
internal static DataSet GetDataset(SqlCommand oCommand)//Accepts sqlcommand and procedure name as parameters and makes connection with database to bring required data and returns dataset
{
using (DataSet oDataSet = new DataSet())
{
using (SqlConnection oConn = new SqlConnection(CommonClass.getConnectionPath()))
{
oCommand.Connection = oConn;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.CommandTimeout = 3600;
using (SqlDataAdapter oAdapter = new SqlDataAdapter())
{
oAdapter.SelectCommand = oCommand;
try
{
oAdapter.Fill(oDataSet);

}
catch (Exception e)
{
throw e;
}
}
}
return oDataSet;
}
}

///
/// This is a commen function used by various class files to get scalar values from databae.
///

/// sqlcommand type object
/// object
internal static object ExecuteScalar(SqlCommand oCommand)
{
object objectToRead = null;
using (SqlConnection oConn = new SqlConnection(CommonClass.getConnectionPath()))
{
if (oConn.State == ConnectionState.Closed)
{
oConn.Open();
}
oCommand.Connection = oConn;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.CommandTimeout = 3600;
try { objectToRead = oCommand.ExecuteScalar(); }
catch (Exception e) { throw e; }
}
return objectToRead;
}


///
/// Commen function shared by all the class file to execute update , delete queries and return nothing.
///

/// sqlcommand type object
internal static int ExecuteNonQuery(SqlCommand oCommand)
{
using (SqlConnection oConn = new SqlConnection(CommonClass.getConnectionPath()))
{
if (oConn.State == ConnectionState.Closed)
{
oConn.Open();
}
oCommand.Connection = oConn;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.CommandTimeout = 3600;
try { return oCommand.ExecuteNonQuery(); }
catch (Exception e) { return 0; }
}
}

///
/// Commen function shared by all the class file to execute update , delete queries
/// and return no. of rows affected, because in file we perform other operations on the base
/// of rows affected.
///

/// sqlcommand type object
///
internal static int ExecuteNonQuery_ReturnVal(SqlCommand oCommand)
{
int RowsAffected = 0;
using (SqlConnection oConn = new SqlConnection(CommonClass.getConnectionPath()))
{
if (oConn.State == ConnectionState.Closed)
{
oConn.Open();
}
oCommand.Connection = oConn;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.CommandTimeout = 3600;
try
{
RowsAffected = oCommand.ExecuteNonQuery();
return RowsAffected;
}
catch (Exception e)
{
return RowsAffected;

}
}
return RowsAffected;
}
}
}


COMMON CLASS


using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
//--
using System.Data.SqlClient;



///
/// Summary description for CommonClass
///

///
namespace BusinessLogic
{
public class CommonClass
{
public CommonClass()
{
//
// TODO: Add constructor logic here
//
}

public static string getConnectionPath()
{
return ConfigurationManager.ConnectionStrings["connStr"].ConnectionString.ToString();
}

public static string Trim( TextBox tb)
{
return tb.Text.Trim();

}

public static void AddParameter(SqlCommand cmd, string parmName, string value)
{
parmName = "@" + parmName.Trim();
cmd.Parameters.AddWithValue(parmName, value);
}

///
/// This function used for bind GridView with dataset.
///

///
///
///
public static int Bind(DataSet dst, GridView gv)
{
try
{
if (dst.Tables[0].Rows.Count > 0)
{
gv.DataSource = dst;
gv.DataBind();
return 1;
}
else
{
return 2;
}
}
catch
{
return 0;/// Error

}

}

public static string StyleforSelectedRow()
{
return "this.originalstyle=this.style.backgroundColor;this.style.backgroundColor='#add8e6'";
}

///
/// Function is used for insert - between strings etc phone number
///

///
///
///
public static string PhoneString(string str, int len)
{
string retString = string.Empty;;
if (str.Length == len)
{
retString ="("+ str.Substring(0, 3) +") "+ str.Substring(3, 3) +"-"+ str.Substring(6, 4);
return retString;
}
return str;
}
///
/// This function break the email from @ when lenthh is > 25
///

public static string EMailBreak(string str, int len)
{
string retString = string.Empty; ;
if ((str.Length > len) && ( str.Contains("@")))
{

retString = str.Replace("@", "
@");
return retString;
}
return str;
}




}
}


APPLICATION PATH TO FIND WHERE APPLICATION

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
//--
using System.Data.SqlClient;



///
/// Summary description for CommonClass
///

///
namespace BusinessLogic
{
public class CommonClass
{
public CommonClass()
{
//
// TODO: Add constructor logic here
//
}

public static string getConnectionPath()
{
return ConfigurationManager.ConnectionStrings["connStr"].ConnectionString.ToString();
}

public static string Trim( TextBox tb)
{
return tb.Text.Trim();

}

public static void AddParameter(SqlCommand cmd, string parmName, string value)
{
parmName = "@" + parmName.Trim();
cmd.Parameters.AddWithValue(parmName, value);
}

///
/// This function used for bind GridView with dataset.
///

///
///
///
public static int Bind(DataSet dst, GridView gv)
{
try
{
if (dst.Tables[0].Rows.Count > 0)
{
gv.DataSource = dst;
gv.DataBind();
return 1;
}
else
{
return 2;
}
}
catch
{
return 0;/// Error

}

}

public static string StyleforSelectedRow()
{
return "this.originalstyle=this.style.backgroundColor;this.style.backgroundColor='#add8e6'";
}

///
/// Function is used for insert - between strings etc phone number
///

///
///
///
public static string PhoneString(string str, int len)
{
string retString = string.Empty;;
if (str.Length == len)
{
retString ="("+ str.Substring(0, 3) +") "+ str.Substring(3, 3) +"-"+ str.Substring(6, 4);
return retString;
}
return str;
}
///
/// This function break the email from @ when lenthh is > 25
///

public static string EMailBreak(string str, int len)
{
string retString = string.Empty; ;
if ((str.Length > len) && ( str.Contains("@")))
{

retString = str.Replace("@", "
@");
return retString;
}
return str;
}




}
}


Thanks
Helpondesk Team

Friday, May 1, 2009

user to select value from dropdown list

For validating user selection in dropdownlist we can use rangevalidator. and values of drop down must be in integer type.
syntax is follows :-
[asp:RangeValidator ID="RVddRegistrationType" runat="server" ControlToValidate="ddRegistrationType" ErrorMessage="Select registration type" Display="None"
MaximumValue="100" MinimumValue="1" Type="Integer"][/asp:RangeValidator]


Thanks
Helpondesk Team