467,859 Members | 1,383 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,859 developers. It's quick & easy.

Writing two times instead of one in an database

I have a project in C# that do the followings:

From an csv text file it is taking datas and inserted into an paradox
database. My problem it is that when writing into the paradox database it is
writing two times same datas instead of course one time.

Could be a hel please?
Nov 16 '05 #1
  • viewed: 1255
Share:
3 Replies
hi,
i can help you out provided you have to show me the code.
Nov 16 '05 #2
Hi,
Please find the code bellow:
Thank you

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.Odbc;
using System.IO;

namespace purchaseorder2
{
/// <summary>
/// Summary description for Form1.
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Data.Odbc.OdbcConnection odbcConnection1;
private System.Data.Odbc.OdbcDataAdapter odbcDataAdapter1;
private purchaseorder2.DataSet1 dataSet11;
private System.Data.Odbc.OdbcCommand odbcSelectCommand1;
private System.Windows.Forms.Label label1;
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.Container components = null;
//mai jos sunt variabilele in care avem informatiile din fisier
String nrpo1;
String cui1;
String numef1;
String data1;
String nrfac1;
String lc1;
String ic1;
String desc1;
String compid1;
String numecomp1;
String nrgest1;
String lc1;
String ic1;
String qtty1;
String pretu1;
String pdisc1;
String vtf1;
String nrfac1;
String codt1;
String numed1;
String cnr;

public Form1()
{
//
// Required for Windows Form Designer support
//

InitializeComponent();
StreamReader sr=new StreamReader("C:\\poclarisys\\po-dupamodificare.txt");
int end;
String result="";
char[] vc={','};
while((result=sr.ReadLine())!=null)
{
string[] vs;
//result=sr.ReadLine();
vs=result.Split(vc);
//scoatem din fisier nr ordinului de cumparare
String nrpo=vs[0];
try
{
end=nrpo.LastIndexOf('"');
nrpo1=nrpo.Substring(1,end-1);
//Console.WriteLine("Numarul ordinului de cumparare: {0}\n",nrpo1);
}
catch(System.Exception){}

//scoatem din fisier codul unic de identificare al furnizorului

try
{
String cui=vs[1];
end=cui.LastIndexOf('"');
String cui1=cui.Substring(1,end-1);
//Console.WriteLine("Nr unic de identif furnizor: {0}\n",cui1);
}
catch(System.Exception){};

//scoatem numele furnizorului
try
{
String numef=vs[2];
end=numef.LastIndexOf('"');
String numef1=numef.Substring(1,end-1);
//Console.WriteLine("Nume furnizor: {0}\n",numef1);
}
catch(System.Exception){};

//scoatem data tranzactiei

try
{
String data=vs[3];
end=data.LastIndexOf('"');
String data1=data.Substring(1,end-1);
//Console.WriteLine("Data tranzactiei: {0}\n",data1);
}
catch(System.Exception){};

//scoatem identificatorul companiei

try
{
String compid=vs[6];
end=compid.LastIndexOf('"');
String compid1=compid.Substring(1,end-1);
//Console.WriteLine("Nr de identif al companiei: {0}\n",compid1);
}
catch(System.Exception){};

//scoatem numele companiei
try
{
string numecomp=vs[7];
end=numecomp.LastIndexOf('"');
String numecomp1=numecomp.Substring(1,end-1);
//Console.WriteLine("Numele companiei: {0}\n",numecomp1);
}
catch(System.Exception){};

//scoatem numarul gestiunii

try
{
String nrgest=vs[8];
end=nrgest.LastIndexOf('"');
String nrgest1=nrgest.Substring(1,end-1);
//Console.WriteLine("Numarul gestuinii: {0}\n",nrgest1);
}
catch(System.Exception){};

//scoatem line code
try
{
String lc=vs[9];
end=lc.LastIndexOf('"');
String lc1=lc.Substring(1,end-1);
//Console.WriteLine("Codul grupei de produse: {0}\n",lc1);
}
catch(System.Exception){};

//scoatem item code

try
{
String ic=vs[10];
end=ic.LastIndexOf('"');
String ic1=ic.Substring(1,end-1);
//Console.WriteLine("Item code: {0}\n",ic1);
}
catch(System.Exception){};

//scoatem descrierea produsului

try
{
String desc=vs[11];
end=desc.LastIndexOf('"');
String desc1=desc.Substring(1,end-1);
//Console.WriteLine("Descrierea produsului cumparat: {0}\n",desc1);
}
catch(System.Exception){};

//scoatem cantitatea cumparata

try
{
String qtty=vs[12];
end=qtty.LastIndexOf('"');
String qtty1=qtty.Substring(1,end-1);
//Console.WriteLine("Cantitatea achizitionata: {0}\n",qtty1);
}
catch(System.Exception){};

//scoatem pretul unitar
try
{
String pretu=vs[13];
end=pretu.LastIndexOf('"');
String pretu1=pretu.Substring(1,end-1);
//Console.WriteLine("Pretul unitar: {0}\n",pretu1);
}
catch(System.Exception){};

//scoatem procentul de discount acordat
try
{
String pdisc=vs[14];
end=pdisc.LastIndexOf('"');
String pdisc1=pdisc.Substring(1,end-1);
//Console.WriteLine("Procent discount: {0}\n",pdisc1);
}
catch(System.Exception){};

//scoatem valoare totala marfa fara TVA
try
{
String vtf=vs[15];
end=vtf.LastIndexOf('"');
String vtf1=vtf.Substring(1,end-1);
//Console.WriteLine("Valoarea marfii fara TVA: {0}\n",vtf1);
}
catch(System.Exception){};

//scoatem numarul facturii
try
{
String nrfac=vs[16];
end=nrfac.LastIndexOf('"');
String nrfac1=nrfac.Substring(1,end-1);
//Console.WriteLine("Numarul facturii: {0}\n",nrfac1);
}
catch(System.Exception){};

//scoatem codul tranzactiei
try
{
String codt=vs[17];
end=codt.LastIndexOf('"');
String codt1=codt.Substring(1,end-1);
//Console.WriteLine("Codul tranzactiei: {0}\n",codt1);
}
catch(System.Exception){};

//scoatem numele delegatului

try
{
String numed=vs[18];
end=numed.LastIndexOf('"');
String numed1=numed.Substring(1,end-1);
//Console.WriteLine("Numele delegatului: {0}\n",numed1);
}
catch(System.Exception){};

//scoatem nr masina

try
{
String cnr=vs[19];
end=cnr.LastIndexOf('"');
String cnr1=cnr.Substring(1,end-1);
//Console.WriteLine("Numarul masinii: {0}\n",cnr1);
}
catch(System.Exception){};
}
//Console.Read();

//sfarsit parte de fisier

try
{
odbcConnection1.Open();
//'111122','BAR','13','Coca-Cola mea','99','99','1111','0','109989','1'

//,Cfrdet_order_number,Cfrdet_line_code,Cfrdet_item_ code,Cfrdet_desc,Cfrdet_qty_order,Cfrdet_qty_recei ved,Cfrdet_price,Cfrdet_discount,Cfrdet_total,Cfrd et_from_po
OdbcCommand cmd=new OdbcCommand("insert into
cfrdet(Cfrdet_paking_slip,Cfrdet_order_number,Cfrd et_line_code,Cfrdet_item_code,Cfrdet_desc,Cfrdet_q ty_order,Cfrdet_qty_received,Cfrdet_price,Cfrdet_d iscount,Cfrdet_total,Cfrdet_from_po)"+
"values(?,?,?,?,?,?,?,?,?,?,?)",odbcConnection 1);
cmd.Parameters.Add("@nrpo",OdbcType.Text);
cmd.Parameters["@nrpo"].Value=nrpo1.ToString();

cmd.Parameters.Add("@nrfac",OdbcType.Text);
cmd.Parameters["@nrfac"].Value=nrfac1.ToString();

cmd.Parameters.Add("@lc",OdbcType.Text);
cmd.Parameters["@lc"].Value=lc1.ToString();

cmd.Parameters.Add("@ic",OdbcType.Text);
cmd.Parameters["@ic"].Value=ic1.ToString();

cmd.Parameters.Add("@desc",OdbcType.Text);
cmd.Parameters["@desc"].Value=desc1.ToString();

cmd.Parameters.Add("@",OdbcType);
cmd.Parameters["@"].Value=.ToString();

cmd.Parameters.Add("@",OdbcType);
cmd.Parameters["@"].Value=.ToString();

cmd.Parameters.Add("@",OdbcType);
cmd.Parameters["@"].Value=.ToString();

cmd.Parameters.Add("@",OdbcType);
cmd.Parameters["@"].Value=.ToString();

cmd.Parameters.Add("@",OdbcType);
cmd.Parameters["@"].Value=.ToString();

cmd.Parameters.Add("@",OdbcType);
cmd.Parameters["@"].Value=.ToString();

cmd.ExecuteNonQuery();
}
catch(OdbcException ex){}
finally
{
odbcConnection1.Close();
}

//
// TODO: Add any constructor code after InitializeComponent call
//
//Provider=MSDASQL.1;Persist Security Info=False;Extended
Properties="DSN=bdpo;DBQ=C:\CLARISYS040802\PPAK\DA TA4\BDPO;DefaultDir=C:\CLARISYS040802\PPAK\DATA4\B DPO;DriverId=538;FIL=Paradox
5.X;MaxBufferSize=2048;PageTimeout=5;"
}

/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}

#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.odbcConnection1 = new System.Data.Odbc.OdbcConnection();
this.odbcDataAdapter1 = new System.Data.Odbc.OdbcDataAdapter();
this.odbcSelectCommand1 = new System.Data.Odbc.OdbcCommand();
this.dataSet11 = new purchaseorder2.DataSet1();
this.label1 = new System.Windows.Forms.Label();
((System.ComponentModel.ISupportInitialize)(this.d ataSet11)).BeginInit();
this.SuspendLayout();
//
// odbcConnection1
//
this.odbcConnection1.ConnectionString = "MaxBufferSize=2048;FIL=Paradox
5.X;DSN=bdpo;PageTimeout=5;DefaultDir=C:\\CLARISYS 0" +
"40802\\PPAK\\DATA4\\BDPO;DBQ=C:\\CLARISYS040802\\ PPAK\\DATA4\\BDPO;DriverId=538";
//
// odbcDataAdapter1
//
this.odbcDataAdapter1.SelectCommand = this.odbcSelectCommand1;
this.odbcDataAdapter1.TableMappings.AddRange(new
System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table",
"Table", new System.Data.Common.DataColumnMapping[] {
new
System.Data.Common.DataColumnMapping("Cfrdet_pakin g_slip",
"Cfrdet_paking_slip"),
new
System.Data.Common.DataColumnMapping("Cfrdet_line" , "Cfrdet_line"),
new
System.Data.Common.DataColumnMapping("Cfrdet_order _number",
"Cfrdet_order_number"),
new
System.Data.Common.DataColumnMapping("Cfrdet_line_ code", "Cfrdet_line_code"),
new
System.Data.Common.DataColumnMapping("Cfrdet_item_ code", "Cfrdet_item_code"),
new
System.Data.Common.DataColumnMapping("Cfrdet_desc" , "Cfrdet_desc"),
new
System.Data.Common.DataColumnMapping("Cfrdet_qty_o rder", "Cfrdet_qty_order"),
new
System.Data.Common.DataColumnMapping("Cfrdet_qty_r eceived",
"Cfrdet_qty_received"),
new
System.Data.Common.DataColumnMapping("Cfrdet_price ", "Cfrdet_price"),
new
System.Data.Common.DataColumnMapping("Cfrdet_disco unt", "Cfrdet_discount"),
new
System.Data.Common.DataColumnMapping("Cfrdet_total ", "Cfrdet_total"),
new
System.Data.Common.DataColumnMapping("Cfrdet_bin_l oc", "Cfrdet_bin_loc"),
new
System.Data.Common.DataColumnMapping("Cfrdet_from_ po", "Cfrdet_from_po"),
new
System.Data.Common.DataColumnMapping("Cfrdet_Cylin dersReceived",
"Cfrdet_CylindersReceived")})});
this.odbcDataAdapter1.RowUpdated += new
System.Data.Odbc.OdbcRowUpdatedEventHandler(this.o dbcDataAdapter1_RowUpdated);
//
// odbcSelectCommand1
//
this.odbcSelectCommand1.CommandText = "SELECT * FROM cfrdet";
this.odbcSelectCommand1.Connection = this.odbcConnection1;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US");
//
// label1
//
this.label1.Location = new System.Drawing.Point(40, 16);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(144, 40);
this.label1.TabIndex = 0;
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(504, 273);
this.Controls.Add(this.label1);
this.Name = "Form1";
this.Text = "Form1";
this.TransparencyKey = System.Drawing.Color.Silver;
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.d ataSet11)).EndInit();
this.ResumeLayout(false);

}
#endregion

/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());

//DSN=bdpo;DBQ=C:\CLARISYS040802\PPAK\DATA4\BDPO;Def aultDir=C:\CLARISYS040802\PPAK\DATA4\BDPO;DriverId =538;FIL=Paradox
5.X;MaxBufferSize=2048;PageTimeout=5;

}

private void Form1_Load(object sender, System.EventArgs e)
{

}

private void odbcDataAdapter1_RowUpdated(object sender,
System.Data.Odbc.OdbcRowUpdatedEventArgs e)
{

}

private void dataGrid1_Navigate(object sender,
System.Windows.Forms.NavigateEventArgs ne)
{

}
}
}
"Sreejith S S Nair" wrote:
hi,
i can help you out provided you have to show me the code.

Nov 16 '05 #3
Sorry, last post I put an wrong code. This is the correct code:

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.Odbc;
using System.IO;

namespace purchaseorder2
{
/// <summary>
/// Summary description for Form1.
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Data.Odbc.OdbcConnection odbcConnection1;
private System.Data.Odbc.OdbcDataAdapter odbcDataAdapter1;
private purchaseorder2.DataSet1 dataSet11;
private System.Data.Odbc.OdbcCommand odbcSelectCommand1;
private System.Windows.Forms.Label label1;
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.Container components = null;
//mai jos sunt variabilele in care avem informatiile din fisier
String nrpo1;
String cui1;
String numef1;
String data1;
String nrfac1;
String lc1;
String ic1;
String desc1;
String compid1;
String numecomp1;
String nrgest1;
String qtty1;
String pretu1;
String pdisc1;
String vtf1;
String codt1;
String numed1;
String cnr1;

public Form1()
{
//
// Required for Windows Form Designer support
//

InitializeComponent();
StreamReader sr=new StreamReader("C:\\poclarisys\\po-dupa
modificare.txt");
int end;
String result="";
char[] vc={','};
while((result=sr.ReadLine())!=null)
{
string[] vs;
//result=sr.ReadLine();
vs=result.Split(vc);
//scoatem din fisier nr ordinului de cumparare
String nrpo=vs[0];
try
{
end=nrpo.LastIndexOf('"');
nrpo1=nrpo.Substring(1,end-1);
//Console.WriteLine("Numarul ordinului de cumparare: {0}\n",nrpo1);
}
catch(System.Exception){}

//scoatem din fisier codul unic de identificare al furnizorului

try
{
String cui=vs[1];
end=cui.LastIndexOf('"');
cui1=cui.Substring(1,end-1);
//Console.WriteLine("Nr unic de identif furnizor: {0}\n",cui1);
}
catch(System.Exception){};

//scoatem numele furnizorului
try
{
String numef=vs[2];
end=numef.LastIndexOf('"');
numef1=numef.Substring(1,end-1);
//Console.WriteLine("Nume furnizor: {0}\n",numef1);
}
catch(System.Exception){};

//scoatem data tranzactiei

try
{
String data=vs[3];
end=data.LastIndexOf('"');
data1=data.Substring(1,end-1);
//Console.WriteLine("Data tranzactiei: {0}\n",data1);
}
catch(System.Exception){};

//scoatem identificatorul companiei

try
{
String compid=vs[6];
end=compid.LastIndexOf('"');
compid1=compid.Substring(1,end-1);
//Console.WriteLine("Nr de identif al companiei: {0}\n",compid1);
}
catch(System.Exception){};

//scoatem numele companiei
try
{
string numecomp=vs[7];
end=numecomp.LastIndexOf('"');
numecomp1=numecomp.Substring(1,end-1);
//Console.WriteLine("Numele companiei: {0}\n",numecomp1);
}
catch(System.Exception){};

//scoatem numarul gestiunii

try
{
String nrgest=vs[8];
end=nrgest.LastIndexOf('"');
nrgest1=nrgest.Substring(1,end-1);
//Console.WriteLine("Numarul gestuinii: {0}\n",nrgest1);
}
catch(System.Exception){};

//scoatem line code
try
{
String lc=vs[9];
end=lc.LastIndexOf('"');
lc1=lc.Substring(1,end-1);
//Console.WriteLine("Codul grupei de produse: {0}\n",lc1);
}
catch(System.Exception){};

//scoatem item code

try
{
String ic=vs[10];
end=ic.LastIndexOf('"');
ic1=ic.Substring(1,end-1);
//Console.WriteLine("Item code: {0}\n",ic1);
}
catch(System.Exception){};

//scoatem descrierea produsului

try
{
String desc=vs[11];
end=desc.LastIndexOf('"');
desc1=desc.Substring(1,end-1);
//Console.WriteLine("Descrierea produsului cumparat: {0}\n",desc1);
}
catch(System.Exception){};

//scoatem cantitatea cumparata

try
{
String qtty=vs[12];
end=qtty.LastIndexOf('"');
qtty1=qtty.Substring(1,end-1);
//Console.WriteLine("Cantitatea achizitionata: {0}\n",qtty1);
}
catch(System.Exception){};

//scoatem pretul unitar
try
{
String pretu=vs[13];
end=pretu.LastIndexOf('"');
pretu1=pretu.Substring(1,end-1);
//Console.WriteLine("Pretul unitar: {0}\n",pretu1);
}
catch(System.Exception){};

//scoatem procentul de discount acordat
try
{
String pdisc=vs[14];
end=pdisc.LastIndexOf('"');
pdisc1=pdisc.Substring(1,end-1);
//Console.WriteLine("Procent discount: {0}\n",pdisc1);
}
catch(System.Exception){};

//scoatem valoare totala marfa fara TVA
try
{
String vtf=vs[15];
end=vtf.LastIndexOf('"');
vtf1=vtf.Substring(1,end-1);
//Console.WriteLine("Valoarea marfii fara TVA: {0}\n",vtf1);
}
catch(System.Exception){};

//scoatem numarul facturii
try
{
String nrfac=vs[16];
end=nrfac.LastIndexOf('"');
nrfac1=nrfac.Substring(1,end-1);
//Console.WriteLine("Numarul facturii: {0}\n",nrfac1);
}
catch(System.Exception){};

//scoatem codul tranzactiei
try
{
String codt=vs[17];
end=codt.LastIndexOf('"');
codt1=codt.Substring(1,end-1);
//Console.WriteLine("Codul tranzactiei: {0}\n",codt1);
}
catch(System.Exception){};

//scoatem numele delegatului

try
{
String numed=vs[18];
end=numed.LastIndexOf('"');
numed1=numed.Substring(1,end-1);
//Console.WriteLine("Numele delegatului: {0}\n",numed1);
}
catch(System.Exception){};

//scoatem nr masina

try
{
String cnr=vs[19];
end=cnr.LastIndexOf('"');
cnr1=cnr.Substring(1,end-1);
//Console.WriteLine("Numarul masinii: {0}\n",cnr1);
}
catch(System.Exception){};

//Console.Read();

//sfarsit parte de fisier
try
{
odbcConnection1.Open();
//'111122','BAR','13','Coca-Cola mea','99','99','1111','0','109989','1'
//,Cfrdet_order_number,Cfrdet_line_code,Cfrdet_item_ code,Cfrdet_desc,Cfrdet_qty_order,Cfrdet_qty_recei ved,Cfrdet_price,Cfrdet_discount,Cfrdet_total,Cfrd et_from_po
OdbcCommand cmd=new OdbcCommand("insert into
cfrdet(Cfrdet_paking_slip,Cfrdet_order_number,Cfrd et_line_code,Cfrdet_item_code,Cfrdet_desc,Cfrdet_q ty_order,Cfrdet_qty_received,Cfrdet_price,Cfrdet_d iscount,Cfrdet_total,Cfrdet_from_po)"+
"values(?,?,?,?,?,?,?,?,?,?,?)",odbcConnection 1);
cmd.Parameters.Add("@nrfac",OdbcType.Text);
cmd.Parameters["@nrfac"].Value=nrfac1.ToString();

cmd.Parameters.Add("@nrpo",OdbcType.Text);
cmd.Parameters["@nrpo"].Value=nrpo1.ToString();

cmd.Parameters.Add("@lc",OdbcType.Text);
cmd.Parameters["@lc"].Value=lc1.ToString();

cmd.Parameters.Add("@ic",OdbcType.Text);
cmd.Parameters["@ic"].Value=ic1.ToString();

cmd.Parameters.Add("@desc",OdbcType.Text);
cmd.Parameters["@desc"].Value=desc1.ToString();

cmd.Parameters.Add("@qtty",OdbcType.Double);
cmd.Parameters["@qtty"].Value=Convert.ToDouble(qtty1);

cmd.Parameters.Add("@qtty2",OdbcType.Double);
cmd.Parameters["@qtty2"].Value=Convert.ToDouble(qtty1);

cmd.Parameters.Add("@pret",OdbcType.Double);
cmd.Parameters["@pret"].Value=Convert.ToDouble(pretu1);

cmd.Parameters.Add("@pdisc",OdbcType.Double);
cmd.Parameters["@pdisc"].Value=Convert.ToDouble(pdisc1);

cmd.Parameters.Add("@vtf",OdbcType.Double);
cmd.Parameters["@vtf"].Value=Convert.ToDouble(vtf1);

if(nrpo1!="")
{
cmd.Parameters.Add("@fpo",OdbcType.Bit);
cmd.Parameters["@fpo"].Value=1;
}
else
{
cmd.Parameters.Add("@fpo",OdbcType.Bit);
cmd.Parameters["@fpo"].Value=0;
}

cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
catch(OdbcException ex){}
finally
{
odbcConnection1.Close();
}
}
//
// TODO: Add any constructor code after InitializeComponent call
//
//Provider=MSDASQL.1;Persist Security Info=False;Extended
Properties="DSN=bdpo;DBQ=C:\CLARISYS040802\PPAK\DA TA4\BDPO;DefaultDir=C:\CLARISYS040802\PPAK\DATA4\B DPO;DriverId=538;FIL=Paradox
5.X;MaxBufferSize=2048;PageTimeout=5;"
}

/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}

#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.odbcConnection1 = new System.Data.Odbc.OdbcConnection();
this.odbcDataAdapter1 = new System.Data.Odbc.OdbcDataAdapter();
this.odbcSelectCommand1 = new System.Data.Odbc.OdbcCommand();
this.dataSet11 = new purchaseorder2.DataSet1();
this.label1 = new System.Windows.Forms.Label();
((System.ComponentModel.ISupportInitialize)(this.d ataSet11)).BeginInit();
this.SuspendLayout();
//
// odbcConnection1
//
this.odbcConnection1.ConnectionString = "MaxBufferSize=2048;FIL=Paradox
5.X;DSN=bdpo;PageTimeout=5;DefaultDir=C:\\CLARISYS 0" +
"40802\\PPAK\\DATA4\\BDPO;DBQ=C:\\CLARISYS040802\\ PPAK\\DATA4\\BDPO;DriverId=538";
//
// odbcDataAdapter1
//
this.odbcDataAdapter1.SelectCommand = this.odbcSelectCommand1;
this.odbcDataAdapter1.TableMappings.AddRange(new
System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table",
"Table", new System.Data.Common.DataColumnMapping[] {
new
System.Data.Common.DataColumnMapping("Cfrdet_pakin g_slip",
"Cfrdet_paking_slip"),
new
System.Data.Common.DataColumnMapping("Cfrdet_line" , "Cfrdet_line"),
new
System.Data.Common.DataColumnMapping("Cfrdet_order _number",
"Cfrdet_order_number"),
new
System.Data.Common.DataColumnMapping("Cfrdet_line_ code", "Cfrdet_line_code"),
new
System.Data.Common.DataColumnMapping("Cfrdet_item_ code", "Cfrdet_item_code"),
new
System.Data.Common.DataColumnMapping("Cfrdet_desc" , "Cfrdet_desc"),
new
System.Data.Common.DataColumnMapping("Cfrdet_qty_o rder", "Cfrdet_qty_order"),
new
System.Data.Common.DataColumnMapping("Cfrdet_qty_r eceived",
"Cfrdet_qty_received"),
new
System.Data.Common.DataColumnMapping("Cfrdet_price ", "Cfrdet_price"),
new
System.Data.Common.DataColumnMapping("Cfrdet_disco unt", "Cfrdet_discount"),
new
System.Data.Common.DataColumnMapping("Cfrdet_total ", "Cfrdet_total"),
new
System.Data.Common.DataColumnMapping("Cfrdet_bin_l oc", "Cfrdet_bin_loc"),
new
System.Data.Common.DataColumnMapping("Cfrdet_from_ po", "Cfrdet_from_po"),
new
System.Data.Common.DataColumnMapping("Cfrdet_Cylin dersReceived",
"Cfrdet_CylindersReceived")})});
this.odbcDataAdapter1.RowUpdated += new
System.Data.Odbc.OdbcRowUpdatedEventHandler(this.o dbcDataAdapter1_RowUpdated);
//
// odbcSelectCommand1
//
this.odbcSelectCommand1.CommandText = "SELECT * FROM cfrdet";
this.odbcSelectCommand1.Connection = this.odbcConnection1;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US");
//
// label1
//
this.label1.Location = new System.Drawing.Point(40, 16);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(144, 40);
this.label1.TabIndex = 0;
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(504, 273);
this.Controls.Add(this.label1);
this.Name = "Form1";
this.Text = "Form1";
this.TransparencyKey = System.Drawing.Color.Silver;
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.d ataSet11)).EndInit();
this.ResumeLayout(false);

}
#endregion

/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
//DSN=bdpo;DBQ=C:\CLARISYS040802\PPAK\DATA4\BDPO;Def aultDir=C:\CLARISYS040802\PPAK\DATA4\BDPO;DriverId =538;FIL=Paradox
5.X;MaxBufferSize=2048;PageTimeout=5;

}

private void Form1_Load(object sender, System.EventArgs e)
{

}

private void odbcDataAdapter1_RowUpdated(object sender,
System.Data.Odbc.OdbcRowUpdatedEventArgs e)
{

}

private void dataGrid1_Navigate(object sender,
System.Windows.Forms.NavigateEventArgs ne)
{

}
}
}


"Sreejith S S Nair" wrote:
hi,
i can help you out provided you have to show me the code.

Nov 16 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Google Mike | last post: by
6 posts views Thread by Jeff Thies | last post: by
12 posts views Thread by Chris Springer | last post: by
8 posts views Thread by Jon Harrop | last post: by
118 posts views Thread by Chuck Cheeze | last post: by
30 posts views Thread by Cramer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.