C#

Vikram A Punathambekar wrote:

You can get files from a directory using the DirectoryInfo and FileInfo classes.

void Whatever()<br />
{<br />
try<br />
{<br />
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=datacapt.mdb";<br />
OleDbConnection conn = new OleDbConnection(strConnection);<br />
conn.Open();<br />
string strCommand = "INSERT INTO compdata(ID,CompanyName,ContactName) Values ('" + txID.Text + "','" + txtName.Text + "','" + txtcontact.Text + "')";<br />
<br />
OleDbDataAdapter adapter = new OleDbDataAdapter();<br />
adapter.InsertCommand = new OleDbCommand(strCommand, conn);<br />
<br />
<br />
adapter.InsertCommand.ExecuteNonQuery(); <br />
conn.Close();<br />
<br />
{<br />
MessageBox.Show("Added successfully!");<br />
}<br />
}<br />
catch (Exception exc)<br />
{<br />
MessageBox.Show("An error occured :" + exc.ToString());<br />
}<br />
}

string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=datacapt.mdb";
OleDbConnection conn = new OleDbConnection(strConnection);
conn.Open();
string strCommand = "INSERT INTO compdata(ID,CompanyName,ContactName) Values ('" + txID.Text + "','" + txtName.Text + "','" + txtcontact.Text + "')";

OleDbCommand comm = new OleDbCommand(strCommand, conn);

int t1 = command.ExecuteNonQuery(); 
conn.Close();

if (t1 > 0)
{
MessageBox.Show("added successfully!");
}

OpenFileDialog ofd = new OpenFileDialog();
ofd.ShowDialog();

MussaratAziz wrote:

Hi dears

private void yourListBoxes_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
{
	//Not really DoubleClick, but maybe ok for you
	if(e.Clicks>1)
	{
		ListBox ActListBox = sender as ListBox;
		int YactHeight;
		if(ActListBox.BorderStyle == BorderStyle.None)
		{
			YactHeight= ActListBox.PreferredHeight;
		}
		else
		{
			YactHeight= ActListBox.PreferredHeight - 8;	//Offset needed
		}
		if(e.Y<=YactHeight)
		{
                        //Is inside Items region
                        //Do stuff here
                }
	}
}