How to write data into an existing PDF file

Hi,

I am having a three text box. I want to write the fields given in text boxes to xml file and the xml file should be open as save dialog box for the user to

Hi.,

I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query

(eg)

Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");

Gridview1.DataBind();

Plz Post the link if there is any open source !    

Hi all

can anybody help me to solve my problem : writing in .dbf  , as following is my code with this error :

[ ERROR [07002] [Microsoft][ODBC dBase Driver] Too few parameters. Expected 3 ]

SqlConnection cn = new SqlConnection("Data Source=(local);Initial Catalog=test;Integrated Security=True");
        SqlDataAdapter da = new SqlDataAdapter("select * from test", cn);
        DataSet ds = new DataSet();
        da.Fill(ds, "test");
      
        string odbccon = "Dsn=TEST.DBF;dbq=E:\\FOX;defaultdir=E:\\FOX;driverid=533;fil=dBase 5.0;maxbuffersize=2048;pagetimeout=5";

        OdbcConnection connection = new OdbcConnection(odbccon);
        connection.Open();
        OdbcCommand createCommand = connection.CreateCommand();
      

     
        createCommand.CommandText = "CREATE TABLE test (ID int, name varchar(50),last_name varchar(50))";
   &n

I was assigned to create a app to convert SQL data to EDI 835 file. (Electronic Data Interchange file for Health Care Claim Payment/Advice,  outbound process only).

Can someone help me where to start?

Hi,

My requirement is that i upload an excel file then i need to validate that data.

Approach

1. Uploading file using using upload control saving binary in SqlServer

2. Then i am creating file from binary data  on Sql Server using below command and then using OPENROWSET to dump data to Sql table

3. Then reading Sql Table row wise and validating data.

Alter Procedure spUploadExcelFile
(
  @PKID int,
  @BatchID int
)
AS

BEGIN

	Declare @VarBin varbinary(max)
	Declare @FileName varchar(100)
	DECLARE @sql nvarchar(MAX)
                DECLARE @errMsg nvarchar(MAX)
	DECLARE @ObjectReturn INT
	DECLARE @ErrorSource VARCHAR(255)
	DECLARE @ErrorDesc VARCHAR(255)
	DECLARE @ObjectToken INT

	Select @VarBin  = Content , @FileName = [FileName] from MultilangBinaryData Where PKID = @PKID
	SET @FileName = 'C:\'  + @FileName
 
	EXEC sp_OACreate 'ADODB.Stream' @ObjectToken OUTPUT
	EXEC sp_OASetProperty @ObjectToken, 'Type', 1
	EXEC sp_OAMethod @ObjectToken, 'Open'
	EXEC sp_OAMethod @ObjectToken, 'Write', NULL, @VarBin
	EXEC sp_OAMethod @ObjectToken, 'SaveToFile', NULL, @FileName, 2
	EXEC sp_OAMethod @ObjectToken, 'Close'
	EXEC sp_OADestroy @ObjectToken  
	
	SET @sql = 'INSERT INTO dbo.UserBulkData SELECT 0,NULL,'+ @BatchI

I've created a set of CrystalReports (*.rpt files) for an ASP.NET web app on a development server. I call each report using the following code:

protected void BTN_RunReport_Click(object sender, ImageClickEventArgs e)
        {
            CrystalReportViewer_ClientLetter.Visible = true;

            ConnectionInfo con = new ConnectionInfo();
            con.ServerName = Constants.ServerIP;
            con.DatabaseName = Constants.DatabaseName;
            con.UserID = Constants.UserID;
            con.Password = Constants.Password;

            CrystalReportViewer_ClientLetter.ReportSource = Server.MapPath(Constants.ClientLetters);
            ParameterFields parameter = CrystalReportViewer_ClientLetter.ParameterFieldInfo;
            ParameterField batchdate = new ParameterField();
            batchdate.Name = "@BatchDate";
            ParameterDiscreteValue batchdate_value = new ParameterDiscreteValue();
            batchdate_value.Value = Convert.ToDateTime(txtBatchDate.Text);
            batchdate.CurrentValues.Add(batchdate_value);
            parameter.Add(batchdate);

            foreach (TableLogOnInfo tlf in CrystalReportViewer_ClientLetter.LogOnInfo)
            {
                tlf.ConnectionInfo = con;