C#

himanshu_roy81 wrote:

How to insert the values in to two database tables in C#.

Anjani Poornima wrote:

I tried this by the event CellDoubleClick but i can't get what i required

private void dataGridView1_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
    MessageBox.Show("Content DoubleClick");
}

private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
    MessageBox.Show("Cell DoubleClick");
}

Anjani Poornima wrote:

I tried this by the event CellDoubleClick but i can't get what i required

private byte[] GetShootImage(ZipFile originalZipFile, string pass, string shootName)
{
while (fm.LikedShoots.Count > 0) // fm is a class containing the "liked shoots" - by names
{
    ZipFile shootZipFile = originalZipFile; // <-- ERROR OCCURS HERE!!
    ZipEntry zipEntry = shootZipFile.GetEntry(fm.LikedShoots[0]);

    if (zipEntry != null)
    {
        TempSaveStream(shootZipFile.GetInputStream(zipEntry), zipEntry.Size, true); // Saves the an entry of the ZipFile (which is yet another ZipFile to a temporary file (C:\WINDOWS\Temp)

        zipEntry = null;

        shootZipFile.Close();
        shootZipFile = null;

        shootZipFile = new ZipFile("C:\\WINDOWS\\Temp\\TpTmp\\temp.tmp");
        shootZipFile.Password = pass;

        // For each photo in the Shoot...
        foreach (ZipEntry entry in shootZipFile)
        {
            // If Image is not generated
            if (!fm.ImageGenerated(fm.LikedShoots[0] + "\\" + entry.Name))
            {
                // List the Image in the GeneratedPhotos list
                fm.GeneratedPhotos.Add(fm.LikedShoots[0] + "\\" + entry.Name);

                // Get the Image in a byte[] (instead of saving it)
                buffer = TempSaveStream(shootZipFile.GetInputStream(entry), entry.Size, false);

                shootZipFile.Close();
                shootZipFile = null;

                return buffer;
            }
        }
    }

    // Add the Shoot to the ExhaustedShoot list
    fm.ExhaustedShoots.Add(fm.LikedShoots[0]);
    // Remove the Shoot from the LikedShoots list
    fm.LikedShoots.RemoveAt(0);
}
}

<br />
USE YourDatabase<br />
<br />
CREATE TRIGGER Table1_AfterDelete <br />
ON Table1 AFTER DELETE<br />
AS<br />
DELETE Table2 WHERE Table2.Id IN (SELECT Id FROM DELETED)<br />
GO<br />
<br />
CREATE TRIGGER Table1_AfterInsert <br />
ON Table1 AFTER INSERT<br />
AS<br />
INSERT INTO Table2 SELECT * FROM INSERTED<br />
GO<br />
<br />
CREATE TRIGGER Table1_AfterUpdate <br />
ON Table1 AFTER UPDATE<br />
AS<br />
UPDATE Table2<br />
SET Table2.FirstName=Table1.FirstName, Table2.LastName=Table1.LastName<br />
FROM Table2 JOIN Table1 ON Table2.Id=Table1.Id<br />
GO