Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Listview data stored in the MS access database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi All



      I am using C# windows application!

            I want List view information save in the.mdb(MS access file ).. Please suggest me...

    Excel sheet code working properly

    private void filexelshet(string filename)

    {

    try

    {

    panel1.Visible = true;

    int k = 0;

    int l = 1;

    string tblname = listBox1.SelectedItem.ToString();

    //MessageBox.Show(tblname);

    OleDbConnection olecon = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepathmain + "");

    // cmd.Connection.Open();

    olecon.Open();

    //OleDbDataAdapter dap = new OleDbDataAdapter("select * from "+ tblname +"", olecon);

    OleDbCommand cmd = new OleDbCommand("select * from " + tblname + "", olecon);

    OleDbDataReader r = cmd.ExecuteReader();

    exl.ApplicationClass exel = new exl.ApplicationClass();

    exel.Application.Workbooks.Add(true);

    while (r.Read())

    {

    int m = r.FieldCount;

    if (k == 0)

    {

    for (int p = 0; p < m; p++)

    {

    exel.Cells[1, l] = r.GetName(p).ToString();

    //exel.Cells[1, 2] = r.GetName(1).ToString();

    //exel.Cells[1, 3] = r.GetName(2).ToString();

    //exel.Cells[1, 4] = r.GetName(3).ToString();

    l = l + 1;

    }

    k = 1;

    }

    else

    {

    Application.DoEvents();

    int v = 1;

    for (int q = 0; q < m; q++)

    {

    exel.Cells[i, v] = r[q].ToString();

    //exel.Cells[i, 2] = r[1].ToString();

    //exel.Cells[i, 3] = r[2].ToString();

    //exel.Cells[i, 4] = r[3].ToString();

    //exel.Cells[i, 5] = r[4].ToString();

    v = v + 1;

    }

    v = 1;

    //obj.Controls.

    i = i + 1;

    }

    pictureBox2.Width = pictureBox2.Width + 1;

    }

    exel.Visible = true;

    exel.ActiveWorkbook.SaveAs(filename, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, exl.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

    exl.Worksheet worksheet = (exl.Worksheet)exel.ActiveSheet;

    worksheet.Activate();

    }

    catch (Exception e)

    {

    exel.ActiveWorkbook.SaveAs(filename, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, exl.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

    //exl.Worksheet worksheet = (exl.Worksheet)exel.ActiveSheet;

    //worksheet.Activate();

    }

    }


    The above code I want to Ms access format

    Thanks & Regards
    Rammohan

    ram
    • Moved by jack 321 Thursday, September 18, 2008 8:20 AM not a C# specific issue (Moved from Visual C# General to Off-Topic Posts (Do Not Post Here))
    Monday, September 15, 2008 6:55 AM

Answers