https://www.syncfusion.com/faq/aspnet/custom-controls/how-can-we-convert-an-asp-net-page-to-html
Saturday, September 14, 2024
Monday, July 8, 2024
Export to CSV in ASP.NET gridview and print a grid
https://stackoverflow.com/questions/10641141/print-multi-page-gridview
https://stackoverflow.com/questions/24151110/printing-certain-row-in-gridview
https://www.aspsnippets.com/demos/71/
https://www.aspsnippets.com/Articles/71/Print-functionality-in-ASP.Net-GridView-control/
Monday, July 1, 2024
How to scan with hp scanjet 200 on window 11
> First download the software from HP website.
> After that run "windows picture acquisition wizard " app by using "
wiaacmgr.exe"
Wednesday, June 19, 2024
Error - Could not load file or assembly 'Telerik.Web.UI, Version=2021.1.224.45, Culture=neutral, PublicKeyToken=121fae78165ba3d4' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)'
Solution :- Exclude Licenses.lics from project.
Thursday, June 13, 2024
Tuesday, June 11, 2024
How to insert date in SQL Server
insert into emp values('20240625')
'YYYYMMDD'
Tuesday, June 4, 2024
How to create event for user control
public delegate void SignatureHandler(object sender, EventArgs e);
public event SignatureHandler SignatureEvent;
public delegate void SignatureJSHandler(object sender, EventArgs e);
public event SignatureJSHandler SignatureJSEvent;
public delegate void SendConfirmationHandler(object sender, EventArgs e);
public event SendConfirmationHandler SendConfirmationEvent;
<uc1:DigitalSignatureButton runat="server" ID="DigitalSignatureButton" OnSignatureEvent="buttonSave_OnClick" OnSignatureJSEvent="buttonSaveJS_OnClick" />
Friday, May 24, 2024
How to convert datatable to excel in ASP.NET C#
protected void ExportToExcel()
{
DataTable dt = new DataTable();
if (!String.IsNullOrEmpty(txtFromDate.Text))
{
FromDate = txtFromDate.Text;
}
if (!String.IsNullOrEmpty(txtToDate.Text))
{
ToDate = txtToDate.Text;
}
//if (!String.IsNullOrEmpty(txtDateOfJournery.Text))
//{
// ReuestDate = txtDateOfJournery.Text;
//}
//if (ddlStatus.SelectedIndex > 0)
//{
StatusId = Convert.ToInt32(ddlStatus.SelectedValue);
//}
dt = GuestHouseBAL.GuestHouseBALInstance.GetGHBookingExportToExelReport(FromDate, ToDate, StatusId);
if(dt.Rows.Count > 0)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=GuestHouseReport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView GridView1 = new GridView();
//To Export all pages
GridView1.AllowPaging = false;
GridView1.DataSource = dt;
GridView1.DataBind();
string reason = "";
// GridView1.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in GridView1.HeaderRow.Cells)
{
cell.BackColor = GridView1.HeaderStyle.BackColor;
}
foreach (GridViewRow row in GridView1.Rows)
{
//row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = GridView1.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = GridView1.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GridView1.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('No Record Found...');", true);
}
}
also add this if error occured
public override void VerifyRenderingInServerForm(Control control)
{
/* Verifies that the control is rendered */
}
Calling a function in javascript anchor tag
<a class="link-offset-2 link-offset-3-hover link-underline link-underline-opacity-0 link-underline-opacity-75-hover" style="cursor: pointer" onclick="showCaseProfile(\'' + value.FileNumber + '\');">' + value.FileNumber + '</a>
Logging in ASP.NET - Create Logs on ASP.NET
public static void LogInfoToTextFile(string message)
{
bool CreateLog = false;
if (ConfigurationManager.AppSettings["CreateLog"] != null)
{
CreateLog = Convert.ToBoolean(ConfigurationManager.AppSettings["CreateLog"]); //"CreateLog";
}
if (CreateLog)
{
string servicesPath = System.AppDomain.CurrentDomain.BaseDirectory + "/Log";
servicesPath += "/LogFile";
if (!Directory.Exists(servicesPath))
{
Directory.CreateDirectory(servicesPath);
}
var files = new DirectoryInfo(servicesPath).GetFiles("*.txt");
foreach (var file in files)
{
if (DateTime.UtcNow - file.CreationTimeUtc > TimeSpan.FromDays(10))
{
File.Delete(file.FullName);
}
}
string filepath = servicesPath + "/";
string fileName = DateTime.Now.Year + DateTime.Now.Month.ToString() + DateTime.Now.Day;
fileName = filepath + fileName + ".txt";
StreamWriter objwriter = new StreamWriter(fileName, true);
objwriter.Write(Environment.NewLine + "" + message);
objwriter.Close();
}
}
public static void LogInfoToTextFile_New(string message)
{
//Komal14486 : 10/11/2019 - Adding log to check the flow
bool CreateLog = true;
if (ConfigurationManager.AppSettings["CreateLog"] != null)
{
CreateLog = Convert.ToBoolean(ConfigurationManager.AppSettings["CreateLog"]); //"CreateLog";
}
if (CreateLog)
{
string servicesPath = System.AppDomain.CurrentDomain.BaseDirectory + "/Log_New";
servicesPath += "/LogFile";
if (!Directory.Exists(servicesPath))
{
Directory.CreateDirectory(servicesPath);
}
var files = new DirectoryInfo(servicesPath).GetFiles("*.txt");
foreach (var file in files)
{
if (DateTime.UtcNow - file.CreationTimeUtc > TimeSpan.FromDays(10))
{
File.Delete(file.FullName);
}
}
string filepath = servicesPath + "/";
string fileName = DateTime.Now.Year + DateTime.Now.Month.ToString() + DateTime.Now.Day;
fileName = filepath + fileName + ".txt";
using (StreamWriter objwriter = new StreamWriter(fileName, true))
{
objwriter.Write(Environment.NewLine + "" + message);
objwriter.Close();
};
}
}
========================================
Call it in Catch
catch (Exception ex)
{
PageUtils.LogInfoToTextFile(string.Format("While fetching data in the method LoadZoneList() in the page CMSReport.aspx.cs:{0} - {1} ", ex.Message, DateTime.Now));
//PageUtils.LogInfoToTextFile(ex.Message);
//ProcessException(ex);
}
==========================================
Using elmah
public void ProcessException(Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
var errorMessage = new StringBuilder();
errorMessage.Append(Environment.NewLine + "DateTime : " + DateTime.Now + Environment.NewLine);
//errorMessage.Append("User : " + userId + Environment.NewLine);
//errorMessage.Append("Class Name : " + className + Environment.NewLine);
//errorMessage.Append("Method Name : " + methodName + Environment.NewLine);
errorMessage.Append("Error Message : " + ex.Message + Environment.NewLine);
errorMessage.Append("Stack Trace : " + ex.StackTrace + Environment.NewLine);
errorMessage.Append("Inner Exception : " + ex.InnerException + Environment.NewLine);
Logger.Write(errorMessage.ToString());
SetErrorMesssage(ex.Message.ToString());
LoggingDTO loggingDTO = new LoggingDTO();
var objUserInfo = new UserInfo();
if (HttpContext.Current.Session[Constants.UserInformation] != null)
{
objUserInfo = (UserInfo)HttpContext.Current.Session[Constants.UserInformation];
loggingDTO.UserId = objUserInfo.UserId;
loggingDTO.RoleId = objUserInfo.RoleMasterId;
loggingDTO.OfficeId = objUserInfo.OfficeId;
loggingDTO.IpAddress = System.Web.HttpContext.Current.Request.UserHostAddress == null ? "" : System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
}
loggingDTO.LoggingType = 2;
loggingDTO.ControlId = Convert.ToString(ex.Message);
loggingDTO.PageName = Convert.ToString(ex.StackTrace);
loggingDTO.ControlName = Convert.ToString(ex.InnerException);
loggingDTO.CreatedDate = DateTime.Now;
using (var client = ServiceClient<IMasterManager>.Create(ObjectConstants.MasterManager))
{
client.Instance.SaveLogging(loggingDTO);
}
//HttpContext.Current.Response.Redirect("/ErrorPage.aspx");
// Navigate to the error page
}
=====================================
catch (Exception ex)
{
ProcessException(ex);
}
Wednesday, May 22, 2024
String.Format in ASP.NET with {0}, {1}
string.Format("While fetching data in the method in the page CMSReport.aspx.cs:{0} - {1} ", ex.Message, DateTime.Now)
Jquery ajax - ASP.NET when exception occur in asp.net
success: function(data) {
if (typeof data == "string")
data = JSON.parse(data);
if (data.success) {
// Code if success.
} else {
// Code if error.
}
},
and when method not found, than it will gone to error or any function not called by ajax call.
$.ajax({
type: "POST",
data: formData,
url: "/Forms/GetJobData",
dataType: 'json',
contentType: false,
processData: false,
success: function (response) {
if (response.success) {
alert(response.responseText);
} else {
// DoSomethingElse()
alert(response.responseText);
}
},
error: function (response) { // // Added this event to capture the failed requests.
alert("error!"); //
}
});
ref:- https://stackoverflow.com/questions/37187699/ajax-error-is-returned-as-success