Monday, 29 June 2015

Add To List View

 if (sdr.HasRows == true)
            {

                while (sdr.Read())
                {
                    string[] arr = new string[6];
                    arr[0] = Convert.ToString(lsvsupplybranch.Items.Count + 1);
                    arr[1] = sdr["vaitemcode"].ToString();
                    arr[2] = sdr["vaitemname"].ToString();
                    arr[3] = sdr["dtsupplydate"].ToString();
                    arr[4] = sdr["intquantity"].ToString();
                    ListViewItem lst = new ListViewItem(arr);
                    lsvsupplybranch.Items.Add(lst);
                }
            }

Monday, 22 June 2015

Load image to UI from database

//Handler.ashx

 string roll_no = Session["StudentID"]
string sConn = System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ToString();
SqlConnection objConn = new SqlConnection(sConn);
objConn.Open();
string sTSQL = "select img from Images where Roll_no=@roll_no";
SqlCommand objCmd = new SqlCommand(sTSQL, objConn);
objCmd.CommandType = CommandType.Text;
objCmd.Parameters.AddWithValue("@pk_intStudentID", roll_no.ToString());
object data = objCmd.ExecuteScalar();
objConn.Close();
objCmd.Dispose();
context.Response.BinaryWrite((byte[])data);



Image Preview in ASP.NET


//.aspx.cs
    protected void btnPreview_Click(object sender, EventArgs e)
    {

        if (fuplCandidatePhoto.HasFile)
        {
            ImagePreview.Visible = true;
            Session["ImageBytes"] = fuplCandidatePhoto.FileBytes;
            ImagePreview.ImageUrl = "~/ImageHandler.ashx";
        }
  }


//imagehandler.ashx


<%@ WebHandler Language="C#" Class="ImageHandler" %>

using System;
using System.Web;

public class ImageHandler : IHttpHandler, System.Web.SessionState.IRequiresSessionState
{
   
    public void ProcessRequest (HttpContext context)
    {
        //Checking whether the imagebytes session variable have anything else not doing anything

        if ((context.Session["ImageBytes"]) != null)
        {
            byte[] image = (byte[])(context.Session["ImageBytes"]);
            context.Response.ContentType = "image/JPEG";
            context.Response.BinaryWrite(image);
        }
    }

    public bool IsReusable {
        get {
            return false;
        }
    }

}

Thursday, 18 June 2015

WebServices

//Service.cs
 
        [WebMethod]
        public DataSet GetSampleDataDT()
        {
            // getting connection string
            DataSet dt = new DataSet();
            DataTable dt1 = new DataTable();
            SqlDataAdapter sda;
            SqlConnection con = new SqlConnection("Data Source=dxgdfhgfj;Initial Catalog=g);
            con.Open();
            SqlCommand cmd = new SqlCommand("stp_selectall", con);
            cmd.CommandType = CommandType.StoredProcedure;
            sda = new SqlDataAdapter(cmd);
            sda.Fill(dt1);
            dt.Tables.Add(dt1);
            return dt;
        }




//pl



       private void button1_Click(object sender, EventArgs e)
        {
            ServiceSoap obj = new ServiceSoapClient();
            DataSet dtData = new DataSet();
            dtData = obj.GetSampleDataDT();
            DataTable dt = new DataTable();
            dt = dtData.Tables[0];
            ListViewItem lst = new ListViewItem();
            foreach (DataRow r in dt.Rows)
            {
                lst = new ListViewItem(r["id"].ToString());
                lst.SubItems.Add(r["name"].ToString());
                listView1.Items.Add(lst);
            }
        
           
        }

Accessing WebServices in Web Application

Please refer the below link for adding webservice reference to our web application

http://www.c-sharpcorner.com/UploadFile/0c1bb2/consuming-web-service-in-Asp-Net-web-application/

Tuesday, 16 June 2015

File upload in ASP.NET

   if (fuplCandidatePhoto.HasFile)
                {
                    PhotoName = txtEmailId.Text + ".jpg";
                    fuplCandidatePhoto.SaveAs(Server.MapPath("~/CandidatePhotos/" + PhotoName));
                }


Monday, 15 June 2015

Console Application For Mail Sending

 
//MAIL SENDING CODE

 Console.WriteLine("Mail To");
            MailAddress to = new MailAddress(Console.ReadLine());

            Console.WriteLine("Mail From");
            MailAddress from = new MailAddress(Console.ReadLine());

            MailMessage mail = new MailMessage(from, to);

            Console.WriteLine("Subject");
            mail.Subject = Console.ReadLine();

            Console.WriteLine("Your Message");
            mail.Body = Console.ReadLine();

            SmtpClient smtp = new SmtpClient();
            smtp.Host = "smtp.gmail.com";
            smtp.Port = 587;

            smtp.Credentials = new NetworkCredential(
                "username@domain.com", "password");
            smtp.EnableSsl = true;
            Console.WriteLine("Sending email...");
            smtp.Send(mail);

Wednesday, 10 June 2015

Export Details as Excel File

//ExcelHelper.cs

 using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.IO;
using System.Text;

/// <summary>
/// Summary description for ExcelHelper
/// </summary>
public class ExcelHelper
{
public ExcelHelper()
{
//
// TODO: Add constructor logic here
//

}
    //Row limits older Excel version per sheet
        const int rowLimit = 65000;

        private static string getWorkbookTemplate()
        {
            var sb = new StringBuilder();
            sb.Append("<xml version>\r\n<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\"\r\n");
            sb.Append(" xmlns:o=\"urn:schemas-microsoft-com:office:office\"\r\n xmlns:x=\"urn:schemas- microsoft-com:office:excel\"\r\n xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\">\r\n");
            sb.Append(" <Styles>\r\n <Style ss:ID=\"Default\" ss:Name=\"Normal\">\r\n <Alignment ss:Vertical=\"Bottom\"/>\r\n <Borders/>");
            sb.Append("\r\n <Font/>\r\n <Interior/>\r\n <NumberFormat/>\r\n <Protection/>\r\n </Style>\r\n <Style ss:ID=\"BoldColumn\">\r\n <Font ");
            sb.Append("x:Family=\"Swiss\" ss:Bold=\"1\"/>\r\n </Style>\r\n <Style ss:ID=\"s62\">\r\n <NumberFormat");
            sb.Append(" ss:Format=\"@\"/>\r\n </Style>\r\n <Style ss:ID=\"Decimal\">\r\n <NumberFormat ss:Format=\"0.0000\"/>\r\n </Style>\r\n ");
            sb.Append("<Style ss:ID=\"Integer\">\r\n <NumberFormat ss:Format=\"0\"/>\r\n </Style>\r\n <Style ss:ID=\"DateLiteral\">\r\n <NumberFormat ");
            sb.Append("ss:Format=\"mm/dd/yyyy;@\"/>\r\n </Style>\r\n <Style ss:ID=\"s28\">\r\n");
            sb.Append("<Alignment ss:Horizontal=\"Left\" ss:Vertical=\"Top\" ss:ReadingOrder=\"LeftToRight\" ss:WrapText=\"1\"/>\r\n");
            sb.Append("<Font x:CharSet=\"1\" ss:Size=\"9\" ss:Color=\"#808080\" ss:Underline=\"Single\"/>\r\n");
            sb.Append("<Interior ss:Color=\"#FFFFFF\" ss:Pattern=\"Solid\"/> </Style>\r\n</Styles>\r\n {0}</Workbook>");
            return sb.ToString();
        }

        private static string replaceXmlChar(string input)
        {
            input = input.Replace("&", "&");
            input = input.Replace("<", "<");
            input = input.Replace(">", ">");
            //input = input.Replace("\"","""");
            input = input.Replace("'", "&apos;");
            return input;
        }

        private static string getWorksheets(DataSet source)
        {
            var sw = new StringWriter();
            if (source == null || source.Tables.Count == 0)
            {
                sw.Write("<Worksheet ss:Name=\"Sheet1\"><Table><Row> <Cell  ss:StyleID=\"s62\"><Data ss:Type=\"String\"></Data> </Cell></Row></Table></Worksheet>");
                return sw.ToString();
            }
            foreach (DataTable dt in source.Tables)
            {
                if (dt.Rows.Count == 0)
                    sw.Write("<Worksheet ss:Name=\"" + replaceXmlChar(dt.TableName) + "\"><Table><Row><Cell  ss:StyleID=\"s62\"> <Data ss:Type=\"String\"></Data></Cell></Row> </Table></Worksheet>");
                else
                {
                    //write each row data
                    var sheetCount = 0;
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        if ((i % rowLimit) == 0)
                        {
                            //add close tags for previous sheet of the same data table
                            if ((i / rowLimit) > sheetCount)
                            {
                                sw.Write("</Table></Worksheet>");
                                sheetCount = (i / rowLimit);
                            }
                            sw.Write("<Worksheet ss:Name=\"" +
replaceXmlChar(dt.TableName) +
                                     (((i / rowLimit) == 0) ? "" :
Convert.ToString(i / rowLimit)) + "\"><Table>");
                            //write column name row
                            sw.Write("<Row>");
                            foreach (DataColumn dc in dt.Columns)
                                sw.Write(
                                    string.Format(
                                        "<Cell ss:StyleID=\"BoldColumn\"> <Data ss:Type=\"String\">{0}</Data></Cell>", replaceXmlChar(dc.ColumnName)));
                            sw.Write("</Row>\r\n");
                        }
                        sw.Write("<Row>\r\n");
                        foreach (DataColumn dc in dt.Columns)
                            sw.Write(
                                string.Format(
                                    "<Cell ss:StyleID=\"s62\"><Data ss:Type=\"String\">{0}</Data></Cell>",
                                    replaceXmlChar
(dt.Rows[i][dc.ColumnName].ToString())));
                        sw.Write("</Row>\r\n");
                    }
                    sw.Write("</Table></Worksheet>");
                }
            }

            return sw.ToString();
        }
        public static string GetExcelXml(DataTable dtInput, string filename)
        {
            var excelTemplate = getWorkbookTemplate();
            var ds = new DataSet();
            ds.Tables.Add(dtInput.Copy());
            var worksheets = getWorksheets(ds);
            var excelXml = string.Format(excelTemplate, worksheets);
            return excelXml;
        }

        public static string GetExcelXml(DataSet dsInput, string filename)
        {
            var excelTemplate = getWorkbookTemplate();
            var worksheets = getWorksheets(dsInput);
            var excelXml = string.Format(excelTemplate, worksheets);
            return excelXml;
        }

        public static void ToExcel
(DataSet dsInput, string filename, HttpResponse response)
        {
            var excelXml = GetExcelXml(dsInput, filename);
            response.Clear();
            response.AppendHeader("Content-Type", "application/vnd.ms-excel");
            response.AppendHeader
("Content-disposition", "attachment; filename=" + filename);
            response.Write(excelXml);
            response.Flush();
            response.End();
        }

        public static void ToExcel
(DataTable dtInput, string filename, HttpResponse response)
        {
            var ds = new DataSet();
            ds.Tables.Add(dtInput.Copy());
            ToExcel(ds, filename, response);
        }
}

Monday, 8 June 2015

Crystal Reports in Windows Forms



//PL

  Dim _objreport As New datalayer.clsreport

    Private Sub btnsaerch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsaerch.Click

 reportcustomer()

 End Sub
    '-----------fetch purchasing-----------------'
    Public Sub reportcustomer()
        If (cmbtype.SelectedItem = "purchasing") Then
            Dim dt As New DataTable
            Dim dst As New goldserchreport
            dt = _objreport.Fetchsearchpurchasereport(dtpsearchstart.Value, dtpsearchend.Value)
            dst.Tables.Add(dt)
            Dim objCrystal As New reporetpurchasing
            objCrystal.SetDataSource(dt)
            CrystalReportViewer1.ReportSource = objCrystal
        End If
        '-----------feach sales-----------------'
        If (cmbtype.SelectedItem = "sale") Then
            Dim dt As New DataTable
            Dim dst As New goldserchreport
            dt = _objreport.Fetchsearchpsalereport(dtpsearchstart.Value, dtpsearchend.Value)
            dst.Tables.Add(dt)
            Dim objCrystal As New salesreport
            objCrystal.SetDataSource(dt)
            CrystalReportViewer1.ReportSource = objCrystal
        End If
        If (cmbtype.Text = "select") Then
            MsgBox("select type")
        End If
    End Sub




//clsReport



 Public Function Fetchsearchpurchasereport(ByVal dtstart As Date, ByVal dtend As Date) As DataTable
            Dim dt As New DataTable
            sqlcommand = New SqlCommand("purchasereport", serverconnection)
            sqlcommand.CommandType = CommandType.StoredProcedure
            Try

                sqlcommand.Parameters.AddWithValue("@dtstart", dtstart)
                sqlcommand.Parameters.AddWithValue("@dtend", dtend)
                sqlcommand.ExecuteNonQuery()
            Catch ex As Exception
                Throw ex
            End Try

            Dim sql As New SqlDataAdapter(sqlcommand)
            sql.Fill(dt)
            Return dt

        End Function

Tuesday, 2 June 2015

css


CSS, or Cascading Styles Sheets, is a way to style and present HTML. Whereas the HTML is

the meaning or content, the style sheet is the presentation of that document.


PLEASE REFER THE LINK  

 http://htmldog.com/guides/css/beginner/