Mohan on Sep 22, 2008 0209 AM pl help me about hw to convert data or text in the image file like. Spire. XLS for. NETC,VB. NET,ASP. NET is an industryleading, standalone Excel component for developers to read, write, format and convert all versions of Excel files. SQL Server Stored Procedure with C. Net. I will show you about how to insert the data into data table from user interface page using Stored Procedures and view the data in Grid. View. UI page is like this Designing code. Its fairly easy to convert a C String to a Stream and viceversa. Gold Spot Tally Of The Yes Men Rare. Convert String to Stream. To convert a C String to a MemoryStream object, use the GetBytes. Hi I am new to C 2005. My requirement is to convert a csv file ito a XLS file and need to save that. Any help on this Thanks sk5567. Data Type and Type Conversion in C. NET. In this article I will explain about one of the main topics in C Data Types. You will also learn about the value and. Code behind page. Download Link After inserting all the fields click on the Save button. Word-to-Word-XML-2.png' alt='Convert Text File To Xml C#.Net' title='Convert Text File To Xml C#.Net' />The Grid. View will show all the records. Now I will tell you the process. After click in Save button, then the Button Click Event Fires. Button. Clickobject sender, Event. Args e            if Sessionupdate. To. String View. Stateupdate. To. String                    Insertingthe. Data            Clearall Sessionupdate Server. Url. EncodeSystem. Date. Time. Now. To. String                first1        publicvoid Insertingthe. Data    creating a variable and insert the field values into it. Convert. To. Int. Employee. Id. Text                Sql Stuff. Sql. Connection sqlconn Sql. Command sqlcomm sqlconn new. Sql. ConnectionConfiguration. Manager. App. SettingsSqlserver sqlconn. Open sqlcomm new. Sql. Command sqlcomm. Connection sqlconn Here I am definied command type is Stored Procedure. Command. Type Command. Type. Stored. Procedure Here I mentioned the Stored Procedure Name. Command. Text EMPMASTERTESTINGI Here I fix the variable values to Stored Procedure Parameters. You can easily understand if you can see the Stored Procedure Code. Parameters. Addnew. Sql. Parameterempid, Sql. Db. Type. Int. Value employeeid sqlcomm. Parameters. Addnew. Sql. Parameterempdesgid, Sql. Db. Type. Int. Value employeedesignationid sqlcomm. Parameters. Addnew. Sql. Parameterempdob,Sql. Db. Type. Date. Time. Value employeedob sqlcomm. Execute. Non. Query sqlcomm. Dispose sqlconn. Close    Clear all fields values like this. Clearall            txt. Bankacc. No. Text         txt. Bankname. Text     This is the Stored Procedure Code. Available Down. Load Link. ALTER PROCEDURE dbo. EMPMASTERTESTINGI                   empid         int,            empdesgid      int,            empdob        Datetime,            empdoj        Datetime,            empfname      varchar1. Varchar5. 0,            empphone      varchar5. Datetime,            createdon         Datetime,            createdby     int            status           bit,            updatedon     int      AS      Begin            Insert into                               EMPMASTERTESTING                                                                   EMPID,                                     EMPDESGID,                                     EMPDOB,                                     EMPDOJ,                                     EMPFNAME,                                     EMPLNAME,                                     EMPGENDER,                                 EMPPSTREET,                                     EMPPCITY,                                     EMPPSTATE,                                     EMPPCOUNTRY,                                     EMPPPIN,                                     EMPPhone,                                     EMPLOCID,                                     EMPBANKNAME,                                     EMPBANKACNO,                                     PANNO,                                     EMPOFFEMAIL,                                     EMPDOR,                                        CREATEDON,                                                       CREATEDBY                                                       Values                                                                   empid,                                     empdesgid,                                     empdob,                                     empdoj,                                     empfname,                                     emplname,                                     empgender,                                 emppstreet,                                     emppcity,                                     emppstate,                                     emppcountry,                                     empppin,                                     empphone,                                     emplocid,                                     empbankname,                                     empbankacno,                                     panno,                                     empoffemail,                                     empdor,                                       convertDatetime, getdate, 1. End. After that first method calls. Grid. View will show all the columns. Insert. Page. Visible true            tblgv. Visible false                if a 1                    tblgv. Visible true            tbl. Insert. Page. Visible false            When page Refresh occurs the values are again inserted into the database. So to avoid that I wrote these lines in Page load event, Button Click event and Pre. Render event. In PageLoad Eventif SessionupdatenullSessionupdate Server. Url. EncodeSystem. Date. Time. Now. To. String In Button Click Eventif Sessionupdate. To. String View. Stateupdate. To. StringInsertingthe. Data Clearall Sessionupdate Server. Url. EncodeSystem. Date. Time. Now. To. String  In Pre. Render Event    privatevoid PagePre. Renderobject sender, Event. Args e                View. Stateupdate Sessionupdate    Before you write a Stored Procedure you have the Data table that you are using in the SP. So I wrote an insert command. Insert command values are Stored Procedure input parameters. And Run the Stored Procedure. I wrote a single command in stored procedure, but you can write as many commands as you like. We can write conditional statements like If, while etc and looping statements like for loop and switch case etc. We can see Grid. View like this. I hope you like this article. Let me know if you have any concerns. ASP. NET,C. NET,VB. NET,JQuery,Java. Script,Gridview.