The Engineering Behind Enterprise AI

  • Upload CSV File And Read Using ASP.net

    steps : 1) Create Simple Web Application Using (ASP.Net with C#). 2) Create Class CSVReader (CSVReader.cs) 1: using System; 2: using System.Data; 3: using System.Configuration; 4: using System.Web; 5: using System.Web.Security; 6: using System.Web.UI; 7: using System.Web.UI.WebControls; 8: using System.Web.UI.WebControls.WebParts; 9: using System.Web.UI.HtmlControls; 10: using System.IO; 11: using System.Text; 12: using System.Collections; 13: 14: public…

    Amit Patriwala

  • Export GridView Data into CSVFile In Asp.net 2.0

    Steps. 1) Create Simple Web Application ( asp.net using C#). 2) put the below control in to the page (.aspx) 2.1) GridView (id= GridView1) 2.2) Button (id=button1 and Text =Create CSV File) or put the below code   <form id=”form1″ runat=”server”> <center> <div> <table> <tr> <td> Create CSV File </td> </tr> <tr> <td> <asp:GridView ID=”GridView1″…

    Amit Patriwala

  • Create Zip File Using Dotnet

    in the dotnet framework there are two method for compressing data 1) GZip 2)Deflate here i am using GZip Stream (System.IO.Compression). Steps 1) Create Simple Web Application (asp.net with C#). 2) put below control in to page. 2.1) Button (id=”btnCompress”) 3) put below code in to click event of button. //create one folder in the…

    Amit Patriwala

  • Create Round Form in C# Application

    1) Create Simple Window Application (C#). 2) in the form set below property. startposition : CenterScreen MaximizeBox :False MinimizeBox :False Size : Width :400 Height:400 FormBorderStyle :none 3)  in the form paint event put below code. private void Form1_Paint(object sender, PaintEventArgs e) { System.Drawing.Drawing2D.GraphicsPath objGP = new System.Drawing.Drawing2D.GraphicsPath(); objGP.AddEllipse(new Rectangle(0, 0,this.Width, this.Height)); this.Region = new…

    Amit Patriwala

  • Read Excel using Dotnet application

    steps: 1) create simple dotnet application(here i am used C#.net) 2) put the below code //add namespace using System.Data.OleDb; //read Excel File string FilePath =”c:\test.xls”; OleDbConnection con = new OleDbConnection(@”Provider=Microsoft.Jet.OLEDB.4.0;Data Source=”+ FilePath +”;Extended Properties=Excel 8.0″); OleDbDataAdapter da = new OleDbDataAdapter(“select * from [sheet1$]”, con); DataTable dt = new DataTable(); //get data in datatable da.Fill(dt); Thnx

    Amit Patriwala

  • Debugging SQL Server 2005 Stored Procedures Using Visual Studio

    Steps : 1) Open Visual Studio Interface. 2) Open Server Explorer (short cut key for that is ctrl + alt + S or Go to View Menu and Select) . 3)Now Select you database. 3.1) Right Click On Data Connections. 3.2) Select Add Connection. below interface is open. in Interface fill the below information. 1)…

    Amit Patriwala

  • Create Thumb Image In Asp.net

    here is the steps: 1) create the simple web application (Asp.net using C#). Add Name Space using System.IO 2) put the image file in to the application (here i used Sunset.jpg it’s resolution is (800 ,600)). 3) put the one button (id =btnGenerateThumbImage) 4) put the below code in to the click event of the…

    Amit Patriwala

  • Difference Between Environment.CurrentDirectory And Application.ExecutablePath

    here i am using simple windows application. steps: 1) Create Simple Windows Application using VB.net 2.0. 2) put the button (id=button1) on the form. 3) On the Button Click Event put the below code. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click ‘get the EnvironmentPath MsgBox(” EnvironmentPath ” & Environment.CurrentDirectory.ToString()) ‘get…

    Amit Patriwala

  • Create Template In DotNet

    Microsoft Visual Studio Provided the inbuilt facility to create Template.I just Explain how to use that thing. Steps: 1) Create Simple Web Application (Asp.net with C#). now Open the File Menu and Check Whether Export Template Exist there.if Export Template Option there then skip the step2. ( Figure 1) 2) if the Export Template Option…

    Amit Patriwala