RIG000
یک شنبه 19 اردیبهشت 1389, 20:19 عصر
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\database.mdb");
// OleDbConnection cn = new OleDbConnection("Provider = Microsoft.ACE.Oledb.12.0;Data Source=database.mdb");
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbCommand cm = new OleDbCommand();
DataSet ds = new DataSet();
Report1 rpt = new Report1();
public Form1()
{
// OleDbConnection cn = new OleDbConnection("Provider = Microsoft.ACE.Oledb.12.0;Data Source=database.accdb");
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
da = new OleDbDataAdapter("SELECT id as rid,fname as rfname,lname as rlname,mcode as rmcode,tel as rtel,bdate as rbdate,cdate as rcdate from table1 order by id", cn);
cn.Open();
DataSet1 dss = new DataSet1();
da.Fill(dss, "tb1");
rpt.SetDataSource(dss);
crv1.ReportSource = rpt;
cn.Close();
}
تو قسمت
da.Fill(dss, "tb1"); مشکل میگیره در مورد این جداول و کل کد خط به خط توضیح میدین؟ چون کد نوشته من نیست .
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\database.mdb");
// OleDbConnection cn = new OleDbConnection("Provider = Microsoft.ACE.Oledb.12.0;Data Source=database.mdb");
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbCommand cm = new OleDbCommand();
DataSet ds = new DataSet();
Report1 rpt = new Report1();
public Form1()
{
// OleDbConnection cn = new OleDbConnection("Provider = Microsoft.ACE.Oledb.12.0;Data Source=database.accdb");
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
da = new OleDbDataAdapter("SELECT id as rid,fname as rfname,lname as rlname,mcode as rmcode,tel as rtel,bdate as rbdate,cdate as rcdate from table1 order by id", cn);
cn.Open();
DataSet1 dss = new DataSet1();
da.Fill(dss, "tb1");
rpt.SetDataSource(dss);
crv1.ReportSource = rpt;
cn.Close();
}
تو قسمت
da.Fill(dss, "tb1"); مشکل میگیره در مورد این جداول و کل کد خط به خط توضیح میدین؟ چون کد نوشته من نیست .