Simple Error Log Creator

1. Add This as Common in Your Application.

public static void WriteError(string errorMessage)

{

try

{

string path = "~/LogFile/" + DateTime.Today.ToString("dd-MM-yy") + ".txt";

if (!File.Exists(System.Web.HttpContext.Current.Server.MapPath(path)))

{

File.Create(System.Web.HttpContext.Current.Server.MapPath(path)).Close();

}

using (StreamWriter w = File.AppendText(System.Web.HttpContext.Current.Server.MapPath(path)))

{

w.WriteLine("\r\nLog Entry : ");

w.WriteLine("{0}", DateTime.Now.ToString(CultureInfo.InvariantCulture));

string err = "Error in: " + System.Web.HttpContext.Current.Request.Url.ToString() +

". Error Message:" + errorMessage;

w.WriteLine(err);

w.WriteLine("__________________________");

w.Flush();

w.Close();

}

}

catch (Exception ex)

{

WriteError(ex.Message);

}

}

2. ErrorLog is as Class Name. (Example --> Below)

How to Convert XML String to XML and Get Values With LINQ

XDocument XMLdoc = XDocument.Parse(XMLString);

try

{

string body;

string CcMailid = "";

string Path = Server.MapPath("~/Imgs/Logo.gif");

string rootUrl = Page.Request.ServerVariables["HTTP_HOST"].ToString() + RequestDetails;

var XMLVales = (from _Doc in XMLdoc.Descendants("Product")

select new

{

ProductName = _Doc.Element("ProductName").Value,

Quantity = _Doc.Element("ProductQuanity").Value,

Amount = _Doc.Element("ProductAmt").Value,

TotalAmount = _Doc.Element("ProductTotalAmt").Value

}).Last();

body = ObjHtmlBody.BodyContentNew(RequesterName, SubmitterName, ReqId, XMLVales.ProductName, XMLVales.Quantity, XMLVales.Amount, XMLVales.TotalAmount, rootUrl);

string[] _ReqCode = ddlRequestFrom.SelectedValue.Split('^');

if (Convert.ToString(Session["EmpCode"]) != Convert.ToString(_ReqCode[0]))

{

CcMailid = _ReqCode[1].Trim();

}

ObjSendMail.SendEmail(ToMailId, CcMailid, "New Requst", body, Path);

}

catch (Exception Ex)

{

ErrorLog.WriteError("FrmRequest() --> : buildAndSendEmail() : --> " + Ex);

}

How to check IN Clause Condition in LINQ

List<int> ObjCircleList = null;

ObjCircleList = new List<int>();

for (int i = 0; i < ddlCircle.SelectedValue.Split(',').Count(); i++)

{

ObjCircleList.Add(Convert.ToInt32(ddlCircle.SelectedValue.Split(',')[i]));

}

string CentreNames = "", CentreIds = "";

foreach (Center c in Dbi.Contactss.ListContacts(db, 10).Where(p => ObjCircleList.Contains(p.CorpCenterId)).OrderBy(p => p.Center_name))

{

CentreNames = CentreNames + c.Center_name.Trim().TrimEnd() + "|";

CentreIds = CentreIds + c.id.ToString() + "|";

}

How to Convert PdfBinary to PDF

In Html Page

<table width="100%">

<tr>

<td align="right">

</td>

</tr>

<tr>

<td>

<iframe id="ipdfviewer" width="100%" height="400px" runat="server"></iframe>

</td>

</tr>

</table>

In Cs Page

void ShowPdf()

{

Con.Open();

string Qry = "Select * from TblLabTempReport";

SqlCommand Cmd = new SqlCommand(Qry, Con);

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter(Cmd);

da.Fill(ds);

string FileName;

byte[] byteArray;

if (ds != null && ds.Tables[0].Rows.Count > 0)

{

string LocationPath = "PdfContent/";

string WriteFilePath = Server.MapPath("~/PdfContent/");

byteArray = (byte[])ds.Tables[0].Rows[0]["PdfBinary"];

FileName = "Sample.pdf";

LocationPath = LocationPath + FileName;

WriteFilePath = WriteFilePath + FileName;

if (!File.Exists(WriteFilePath))

{

System.IO.File.WriteAllBytes(WriteFilePath, byteArray);

}

ipdfviewer.Attributes.Add("src", LocationPath);

}

Con.Close();

}

Command Parameters Declaration

Type 1

Con.Open();

string Qry = "Update tblcentreselection set ImgHeaderBinayByte=@ImgBinary,ImgExtension=@ImgExtention where Centreid=@CenterId";

SqlCommand cmd = new SqlCommand(Qry, Con);

cmd.Parameters.Add("@ImgBinary", SqlDbType.VarBinary);

cmd.Parameters["@ImgBinary"].Value = ImgBinary;

cmd.Parameters.Add("@ImgExtention", SqlDbType.VarChar);

cmd.Parameters["@ImgExtention"].Value = StrExtension;

cmd.Parameters.Add("@CenterId", SqlDbType.Int);

cmd.Parameters["@CenterId"].Value = Convert.ToString(Session["_SelCen"]);

cmd.ExecuteNonQuery();

Con.Close();

Type 2

Con.Open();

string Qry = "Update tblcentreselection set ImgHeaderBinayByte=@ImgBinary,ImgExtension=@ImgExtention where Centreid=@CenterId";

SqlCommand cmd = new SqlCommand(Qry, Con);

Cmd.Parameters.AddWithValue("", OrgId);

Cmd.Parameters.AddWithValue("", ExVisitId);

Cmd.Parameters.AddWithValue("", ReportType);

Cmd.Parameters.AddWithValue("", LabPdfBinary);

cmd.ExecuteNonQuery();

Con.Close();

How to Clear All Textboxs, All Dropdowns, All Validators in C#

private void ClearEditCustomerForm()

    {

        //Empty out text boxes

        var textBoxes = new List<Control>();

        FindControlsOfType(this.phrEditCustomer, typeof(TextBox), textBoxes);

        foreach (TextBox textBox in textBoxes)

            textBox.Text = "";

        // Dropdowns

        var dropdowns = new List<Control>();

        FindControlsOfType(this.phrEditCustomer, typeof(DropDownList), dropdowns);

        foreach (DropDownList drop in dropdowns)

        {

            drop.SelectedValue = "0";

        }

        //Clear validators

        var validators = new List<Control>();

        FindControlsOfType(this.phrEditCustomer, typeof(BaseValidator), validators);

        foreach (BaseValidator validator in validators)

            validator.IsValid = true;

    }

    static public void FindControlsOfType(Control root, Type controlType, List<Control> list)

    {

        if (root.GetType() == controlType || root.GetType().IsSubclassOf(controlType))

        {

            list.Add(root);

        }

        //Skip input controls

        if (!root.HasControls())

            return;

        foreach (Control control in root.Controls)

        {

            FindControlsOfType(control, controlType, list);

        }

    }

How to Get GridView Header Name With Cell Values and Convert to XML

sb.Append("<Results>");
            foreach (GridViewRow item in GridView1.Rows)
            {
                if (item.RowType == DataControlRowType.DataRow)
                {
                    for (int i = 0; i < item.Cells.Count; i++)
                    {
                        sb.Append("<" + GridView1.HeaderRow.Cells[i].Text + ">" + item.Cells[i].Text + "</" + GridView1.HeaderRow.Cells[i].Text + ">");
                    }
                }
            }
            sb.Append("</Results>");