Visual C# Samples
OLE DB Sample

This sample demonstrates how to use a Microsoft Access database from C#. It shows how you can create a dataset and add tables to it from a database. The BugTypes.mdb database used in the sample program is a Microsoft Access 2000 .mdb file.

To get samples and instructions for installing them

  • Do one or more of the following:

    • On the Help menu, click Samples.

      The Readme displays information about samples.

    • Visit the Visual Studio 2008 Samples Web site. The most recent versions of samples are available there.

    • Locate samples on the computer on which Visual Studio is installed. By default, samples and a Readme file are installed in drive:\Program Files\Microsoft Visual Studio 9.0\Samples\lcid. For Express editions of Visual Studio, all samples are located online.

For more information, see Locating Sample Files.

0za0czk6.alert_security(en-us,VS.90).gifSecurity Note:

This sample code is intended to illustrate a concept, and it shows only the code that is relevant to that concept. It may not meet the security requirements for a specific environment, and it should not be used exactly as shown. We recommend that you add security and error-handling code to make your projects more secure and robust. Microsoft provides this sample code "AS IS" with no warranties.

To build and run the OLE DB sample within Visual Studio

  • On the Debug menu, click Start Without Debugging.

    0za0czk6.alert_note(en-us,VS.90).gifNote:

    If you are building the solution in Release mode, copy BugTypes.mdb into the \bin\release folder.

To build and run the OLE DB sample from a command prompt

  • Type the following at a command prompt: 

    csc oledbsample.cs
oledbsample
See Also

Concepts

Visual C# Samples
C# Programming Guide

Other Resources

Accessing Data (Visual Studio)
Tags :


Community Content

Thomas Lee
MP3 Player
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;

namespace mp3player
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
int i;
private void button1_Click(object sender, EventArgs e)
{
file.FileName = "";
file.ShowDialog();
if (file.FileName == "")
{
MessageBox.Show("Şarkı Şeçilmedi...", "HATA", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
listBox1.Items.Add(file.FileName);
}
}

private void listBox1_Click(object sender, EventArgs e)
{
if (listBox1.Items.Count==0)
{
MessageBox.Show("Playlist e şarkı eklemediniz...","HATA",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
else
{

mp3.URL = listBox1.SelectedItem.ToString();
i = listBox1.SelectedIndex;
mp3.Ctlcontrols.play();
button2.Text = "Durdur";
label2.Text = listBox1.SelectedItem.ToString();
}

}



private void button2_Click(object sender, EventArgs e)
{
if (button2.Text == "Durdur")
{
mp3.Ctlcontrols.pause();
button2.Text = "Oynat";
}
else
{
button2.Text = "Durdur";
mp3.Ctlcontrols.play();
}
}

private void button3_Click(object sender, EventArgs e)
{
mp3.Ctlcontrols.stop();
button2.Text = "Oynat";
}

private void button5_Click(object sender, EventArgs e)
{
i++;
if (listBox1.Items.Count == i)
{
i=0;
mp3.URL = listBox1.Items[i].ToString();
mp3.Ctlcontrols.play();
label2.Text = listBox1.Items[i].ToString();
}
else
{

mp3.URL = listBox1.Items[i].ToString();
mp3.Ctlcontrols.play();
label2.Text = listBox1.Items[i].ToString();
}
}

private void button4_Click(object sender, EventArgs e)
{
i--;
if (i ==-1)
{
i = 0;
mp3.URL = listBox1.Items[i].ToString();
mp3.Ctlcontrols.play();
label2.Text = listBox1.Items[i].ToString();
}
else
{
mp3.URL = listBox1.Items[i].ToString();
mp3.Ctlcontrols.play();
label2.Text = listBox1.Items[i].ToString();
}
}

private void mp3_EndOfStream(object sender, AxWMPLib._WMPOCXEvents_EndOfStreamEvent e)
{
MessageBox.Show("sjıjı");
}
}
}

Tags : c# sample

Page view tracker