Programing Solution Asp.net & Sql

Save a PDF generated from html2pdf in C#, MVC , html2pdf , Ajax code

2024-10-09T10:47:00.026+05:30

To save on server or disk a PDF generated from HTML in C# code example, you can use the html2pdf js script

html2pdf

converts any webpage or element into a printable PDF entirely client-side using html2canvas and jsPDF

To use html2pdf is to download dist/html2pdf.bundle.min.js to your project folder and include it in your code with

C#, MVC

Create new project in visual studio

Step 1: Create a Model Class


csharp

    public class pdfdata
    {
        public string PDFBase64 { get; set; }
        public string FileName { get; set; }
        
    }

Step 2: Create a Controller

Create a new controller called PdfController.cs


csharp

     public ActionResult Pdf()
        {
           

            
            return View();
        }

// Ajax Call from srcipt

    public JsonResult savepdf(pdfdata pdf)
        {

	 byte[] bytes = Encoding.GetEncoding(28591).GetBytes(pdf.PDFBase64);

 	 System.IO.File.WriteAllBytes(@"yourlocation_path/pdf.Filename"+".pdf", bytes);

  	 var response = new { success = true, responseText = "Your file Saved successfuly !" };
           
  	 return Json(response, JsonRequestBehavior.AllowGet);
	}

Step 3: Create a View


HTML


  <button id="btnsavepdf" class="btn btn-primary btn-xs" >
                    Click here to Save
                </button>

<div name="mycontents">

... my pdf content

<div>

<script src="jquery-3.3.1.min.js" type="text/javascript"></script>
<script src="savepdf.js" type="text/javascript"></script>
<script src="html2pdf.bundle.min.js" type="text/javascript"></script>

Create a javascript code or in seperate js file like i created


Script


window.addEventListener('load', function () {
   
    var btnsavepdf = document.getElementById('btnsavepdf');
   
    function savePdf() {
       
        var element = '';    element = document.getElementsByName('mycontents')[0];
        var opt = {
            margin: [2, 2, 2, 2],
            filename: 'myfile',
            image: { type: 'jpeg', quality: 0.7 },
            html2canvas: { scale: 2, useCORS: true },
            jsPDF: { format: 'a4', unit: 'mm' },
           
        };

        
        html2pdf().from(element).set(opt).toPdf().get('pdf').then(function (pdf) {

            pdf.setFontSize(10);
        }).get('pdf').then(function (pdf) {

            
            var pdfBase64 = pdf.output();
            console.log(pdfBase64);
            var pdfcontent = {};

            pdfcontent.PDFBase64 = pdfBase64;
            pdfcontent.FileName = fileName;


            $.ajax({
                type: "POST",
                url: "/pdf/savepdf",
                data: "{pdfcontent:" + JSON.stringify(pdfcontent) + "}",
                contentType: "application/json;charset=utf-8",
                datatype: "json",
                complete: OnComplete
            });
        })
    }


    btnsavepdf.addEventListener('click', function () {
       
       
        savePdf();
    });
})

Additional Notes

Ensure you have the necessary permissions to write to the directory.
Customize the HtmlContent with your desired HTML and CSS.
You can also load HTML from a body or desired element like div <div name ='pdfcontent'>content...</div>.

Problem To Send Mail C# Asp.net (Hosting Provider)

2024-09-28T14:57:00.010+05:30

How To send mail from asp.net C#

especially when dealing with different hosting providers.

Here is working Code

First Create one email id of your domain From your hosting provider

using System.Net.Mail;

public void sendLocalmail(String from, String to, String Cc, String subject , String Mailbody)

{

MailMessage MM = new MailMessage();

MM.Attachments.Add(new Attachment());

MM.Body = Mailbody;

MM.From = new MailAddress(from);

MM.To.Add(to);

MM.CC.Add(Cc);

MM.Subject = subject ;

MM.IsBodyHtml = true;

MM.BodyEncoding = System.Text.Encoding.UTF8;

MM.Priority = MailPriority.Normal;

SmtpClient client = new SmtpClient();

client.Credentials = new System.Net.NetworkCredential(youremail@domain_name.com, "password");

//use your domain email id as username and its password

client.Port = Convert.ToInt32("25");

//if port 25 not work 'use465 or 587 ports

client.Host = "mail.domain_name.com.";

//SMTP Host address of your domain name not required any gmail,hotmail email id check ur dns setting

client.EnableSsl = true;

//on some server ssl my not suport then try to client.EnableSsl = false;

client.Send(MM);

}

//its working code like php contact form always work

sweetalerts with @ViewBag.Message mvc 5

2023-09-24T11:45:00.003+05:30

How To Show success alert with sweetalert

Show Success Message On Create, Edit Mvc 5

Controller:

Add ViewBag.Message in Controller --> ActionResult Edit, Create

[HttpPost]

public ActionResult Edit(model)

{

--your Code here

ViewBag.Message = "Details Edited successfully";

}

return View();

}

View:

From your Scripts lib folder

<script src="~/Scripts/jquery-1.11.3.min.js"> </script>

CDN

<link href="https://cdn.jsdelivr.net/npm/sweetalert2@11.7.28/dist/sweetalert2.min.css />

<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11.7.28/dist/sweetalert2.all.min.js">

</script>

@if (ViewBag.Message != null)

{

<script type="text/javascript">

$(window).load(function () {

new swal({

text: "@ViewBag.Message",

type: "success"

}).then(okay => {

if (okay) {

window.location.href = "@Url.Action("Index", "any")";

}

});

</script>

sweetalert alert

Adding multiple series in asp.net chart dynamically (from sql table for each rows) Asp.net

2013-04-16T12:49:00.001+05:30

Add Chart Control on design

In Code behind getdata from dataset for each row from table create series dynamically and add to chart series look in code it will be easy

public void Bindchart()
{
DataSet myDataSet2 = getdatafromsql();
string series="series";

foreach (DataRow row in myDataSet2.Tables[0].Rows)
{
  series=series+row.ToString();
chart1.Series.Add(series);

for (int colIndex = 1; colIndex < myDataSet2.Tables[0].Columns.Count; colIndex++)
{

// for each column (column 1 and onward), add the value as a point

string columnName1 = myDataSet2.Tables[0].Columns[colIndex].ColumnName.ToString();



int YVal1 = Convert.ToInt32(row[columnName1]);

string emp = Convert.ToString(row[0]);
chart1.Series[series].Points.AddXY(columnName1, YVal1);
  chart1.Series[series].LegendText = emp;
chart1.Series[ser].ToolTip = emp + "= #VALY";

}
}

}

Find duplicate record from table -sql server database

2013-03-05T15:58:00.000+05:30

Use fallowing query For searching duplicate Record from table

SELECT record_feild,
COUNT(record_feild) AS Occurrences_count
FROM Record_table
GROUP BY record_feild
HAVING ( COUNT(record_feild) > 1 )

Use fallowing query deleting duplicate Record from table
delete
FROM Record_table
WHERE record_id NOT IN
(
SELECT MAX(record_id)
FROM Record_table
GROUP BY record_feild)

aggregate functions in where/having clause

2012-07-10T11:39:00.003+05:30

sum, avg, count, min, max, and count(*).these are sql functions to calculate and
summarize data

but it can be possible to use these function in query condition clause
Example : product_stock contains purchase sale

detail of product we have to find product
whose stock is greater than 100
here is,

select product_id, product_name from
product_master inner join on product_stock on
product_master.product_id=product_stock.product_id
group by product_id, product_name
having Sum(product_stock.stock_value)>100

Alter Query sql Sever

2012-07-09T13:12:00.004+05:30

Alter Commands in sql Server

Change Datatype of sql server database table column

ALTER TABLE MyTable ALTER COLUMN NullCOl NVARCHAR(20) NOT NULL;

drop Column from sql server database table column

ALTER TABLE table_name
DROP COLUMN column_name

Change Coloumn Name of sql server database table column

Alter table table_name change old_column_name new_column_name type size

Change primery key CONSTRAINT of sql server database table
ALTER TABLE table_name
DROP CONSTRAINT PK_table_name_Col1 new_column_name old_column_name column_name datatype

Web service in asp.net

2012-07-05T15:40:00.000+05:30

A Web Service is programmable application logic accessible via standard Web protocols. One of these Web protocols is the Simple Object Access Protocol (SOAP)

Consumers of a Web Service do not need to know anything about the platform, object model, or programming language used to

implement the service; they only need to understand how to send and receive SOAP messages (HTTP and XML).

A Web Service Example

In the following example we will use ASP.NET to create a simple Web Service that adds two numbers

VB.
<%@ WebService Language="VB" Class="MyMath" %>
Public Class MyMath
Public Function Add(a As Integer, b As Integer) As Integer
    Return a + b
End Function
End Class

C#.

<%@ WebService Language="VB" Class="MyMath" %>
Public Class MyMath
{

[WebMethod]
Public int Add( Int a, Int b )
{
    Return a + b;
}

}

Consuming (Calling) Web Service

Web Services can be consumed in 2 ways :

    Select Project / Web site > right-click > Add Web Reference

        Follow the wizard. If you select option “Web service in this solution”, it will do following things

            Creates App_WebReferences folder
            Create localhost having 2 files – .disco & .wsdl
            Then write following code in .aspx > Button click event :
            [Here, WebService is the name of the web service.]

Get the Table Column data in a single row with comma separator in SQL

2012-06-26T13:03:00.004+05:30

explaining how to get one column data in a single row with comma separator.

by sql function in sql- 2005/sql- 2008

Create Table tbl_Mail_ids Contains email_ids

CREATE TABLE [dbo].[ tbl_Mail_ids](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Email_ID] [nvarchar](150) NULL,

Create Function Get_Emails That return email ids in single row seperated by comma

ALTER FUNCTION [dbo].[Get_Emails]
(
@id int
)
RETURNS nvarchar(4000)
AS
BEGIN

declare @email_list Nvarchar(Max);

With MyCte AS(

SELECT ' '+ Email_ID
FROM tbl_Mail_id
)
select @ email_list =
stuff((
select email_list +'# ' from mycte
for xml path('') ),1,1,'') ;

Set @email_list = REPLACE(@email_list , '#', ',')

RETURN @email_list

END
Execute function >> select dbo.Get_Emails()

enable database Service broker in sql server 2005 -2008

2012-05-31T16:49:00.000+05:30

Enabling Sevice broker in sql server

Step 1. Go to Sql server management studio & open Database properties >> options>> Broker enabled set to true

OR

STEP 2 :

Exeute query >> alter database [your database name] set enable_broker

Alter Database column change size

Query >>ALTER TABLE MyTable ALTER COLUMN NullCOl NVARCHAR(20) NOT NULL;

Calculate number of days in month in sql server

2012-05-28T16:35:00.001+05:30

Create simple Scalar - Valued function (UDF) with input parameter month & Year

Create FUNCTION [dbo].[Days_in_Month]
    (
    @month int,
    @year int

    )
RETURNS int
AS
BEGIN


DECLARE @Days int

select @Days= datepart(dd,dateadd(dd,-1,dateadd(mm,1,cast(cast(@year as varchar)+'-'+cast(@month as varchar)+'-01' as datetime))))

    RETURN @Days
END

Run following script in Query Editor:
SELECT dbo.Days_in_Month(1,2012) as NumDaysInMonth

Asp.net Questions

2012-05-22T12:01:00.002+05:30

1. What is ASP?

Active Server Pages (ASP), also known as Classic ASP, is a Microsoft's server-side technology, which helps in creating dynamic and user-friendly Web pages. It uses different scripting languages to create dynamic Web pages, which can be run on any type of browser. The Web pages are built by using either VBScript or JavaScript and these Web pages have access to the same services as Windows application, including ADO (ActiveX Data Objects) for database access, SMTP (Simple Mail Transfer Protocol) for e-mail, and the entire COM (Component Object Model) structure used in the Windows environment. ASP is implemented through a dynamic-link library (asp.dll) that is called by the IIS server when a Web page is requested from the server.

2. What is ASP.NET?

ASP.NET is a specification developed by Microsoft to create dynamic Web applications, Web sites, and Web services. It is a part of .NET Framework. You can create ASP.NET applications in most of the .NET compatible languages, such as Visual Basic, C#, and J#. The ASP.NET compiles the Web pages and provides much better performance than scripting languages, such as VBScript. The Web Forms support to create powerful forms-based Web pages. You can use ASP.NET Web server controls to create interactive Web applications. With the help of Web server controls, you can easily create a Web application.

3. What is the basic difference between ASP and ASP.NET?

The basic difference between ASP and ASP.NET is that ASP is interpreted; whereas, ASP.NET is compiled. This implies that since ASP uses VBScript; therefore, when an ASP page is executed, it is interpreted. On the other hand, ASP.NET uses .NET languages, such as C# and VB.NET, which are compiled to Microsoft Intermediate Language (MSIL).

4. In which event are the controls fully loaded?

Page load event guarantees that all controls are fully loaded. Controls are also accessed in Page_Init events but you will see that view state is not fully loaded during this event

5. How can we identify that the Page is Post Back?

Page object has an "IsPostBack" property, which can be checked to know that is the page posted back.

6. What is the lifespan for items stored in ViewState?

The items stored in ViewState live until the lifetime of the current page expires including the postbacks to the same page.
7.What are the advantages of the code-behind feature?

Makes code easy to understand and debug by separating application logic from HTML tags
Provides the isolation of effort between graphic designers and software engineers
Removes the problems of browser incompatibility by providing code files to exist on the Web server and supporting Web pages to be compiled on demand.

Listbox to Listbox Data transfer in Asp.net C#

2012-05-16T13:17:00.000+05:30

List Box control is a standard control in Asp.net. It is similar to a dropdownlist.

An article to demonstrate How to Move List Box Items to another List Box in ASP.NET and C#.

CODE

Listbox1 items adding to listbox2

protected void btnadditemlist_Click(object sender, EventArgs e)
     {
         foreach (ListItem item in listbox1.Items)
         {
             if (item.Selected)
             {
                 if (listbox2.Items.Contains(item))
                 {
                     // Display message
                     return;
                 }

                 string _value = item.Value; //Gets the value of items in list.
                 string _text = item.Text; // Gets the Text of items in the list.

   ListItem items = new ListItem(); //create a list item
                 items.Text = _text;               //Assign the values to list item
                 items.Value = _value;


                 listbox2.Items.Add(items);
             }
         }
     }

Removing Data from Listbox 2

protected void Remove_Click(object sender, EventArgs e)
    {
        foreach (ListItem item in ListBox2.Items)
        {
            if (item.Selected)
            {

                //ListBox2.Items.Remove(item);
                selectedItems.Add(item);

            }
        }
        for (var i = 0; i < selectedItems.Count; i++)
        {
                       ListBox2.Items.Remove((ListItem)selectedItems[i]);

        }
    }

Clear Drop Down List of Recent Connection From SQL Server Management Studio

2012-05-11T19:20:00.003+05:30

Delete mru.dat file in xp-os in Windows7 Delete SqlStudio.bin

Sql 2005
C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat
If you can not find mru.dat at above location look for mru.dat in following folder.
C:\Documents and Settings\[user]\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\mru.dat
For SQL Server 2008:
C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\mru.dat
If you can not find mru.dat at above location look for mru.dat in following folder.
C:\Documents and Settings\[user]\Application Data\Microsoft\Microsoft SQL Server\100\Tools\ShellSEM\mru.dat
For SQL Server 2008 R2:
in Windows7 Delete SqlStudio.bin file from location
C:\Users\[user]\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\

Calling WebMethod From Javascript

2012-03-15T13:46:00.002+05:30

<asp:ScriptManager ID="ScriptManager1" runat="server" 
  EnablePageMethods="true" />

 <script language="javascript">
 function UpdateTime() {
   PageMethods.GetCurrentDates(OnSucceeded, OnFailed); 
 }
 
 function OnSucceeded(result, userContext, methodName) {
   $get('lbldate').innerHTML = result; 
 }
 
 function OnFailed(error, userContext, methodName) {
   $get('lbldate').innerHTML = "An error occured.";
 }
script>
<asp:Label runat="server" ID="lbldate" Text="Update Me!" /><br />
<input type="button" id="Button2" value="Web Method Update" 
  onclick="UpdateTime();" />

[WebMethod]
public static string GetCurrentDate()
{
  return DateTime.Now.ToLongDateString();
}

Paging in Repeater

2012-03-10T13:52:00.003+05:30

Repeater and DataList controls offer a quick and flexible means of displaying data on a ASPX page. But they offer no paging functionality built in. The DataGrid control has in-built paging but its structure is more rigid. There are several articles on various ASP.NET Resource Sites that offer solutions, but I'm going to show you how to use the PagedDataSource class.
The PagedDataSource class encapsulates the properties of the DataGrid control that allow it to perform paging. But we can use the class with Repeater and DataList controls to perform paging in much the same way as a DataGrid.

Private Sub Page_Load(ByVal sender As System.Object, _
        ByVal e As System.EventArgs) Handles MyBase.Load
    'Put user code to initialize the page here
    Dim myConnection As New _
      SqlConnection(ConfigurationSettings.AppSettings("connectionString"))
    Dim myDA As New SqlClient.SqlDataAdapter("Select * from dtsDefect", _
                                                             myConnection)
    myDA.Fill(ds, "t1")
    pageds.DataSource = ds.Tables("t1").DefaultView
    pageds.AllowPaging = True
    pageds.PageSize = 4
    Dim curpage As Integer

    If Not IsNothing(Request.QueryString("Page")) Then
        curpage = Convert.ToInt32(Request.QueryString("Page"))
    Else
        curpage = 1
    End If

    pageds.CurrentPageIndex = curpage - 1
    lblCurrpage.Text = "Page: " + curpage.ToString()

    If Not pageds.IsFirstPage Then
        lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + _
                                       "?Page=" + CStr(curpage - 1)
    End If

    If Not pageds.IsLastPage Then
        lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + _
                                       "?Page=" + CStr(curpage + 1)
    End If

    Repeater1.DataSource = pageds
    Repeater1.DataBind()
End Sub