Scribd
Upload
53 views3 pages

Visual Assignment 51

The document contains two questions. The first question asks to apply DML queries (Select, Update, Delete, Insert) on a Product database, including providing the syntax and screenshots of the results. The second question asks to create a GUI with menus and menu items that change label text formatting and color when clicked, according to provided C# code.

Uploaded by

sameer khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
53 views3 pages

Visual Assignment 51

The document contains two questions. The first question asks to apply DML queries (Select, Update, Delete, Insert) on a Product database, including providing the syntax and screenshots of the results. The second question asks to create a GUI with menus and menu items that change label text formatting and color when clicked, according to provided C# code.

Uploaded by

sameer khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Question No 1:

Apply DML Queries on Product Db. (Select, Update, Delete, Insert). In assignment Write Syntax and
query which you are applying on Database and attach result screenshot in assignment.

Select:

Insert:

Delete:
Question No 2:

Create the following GUI with the help of BOOK and also code according to mention code:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication16
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void formatToolStripMenuItem_Click(object sender, EventArgs e)


{

private void blueToolStripMenuItem_Click(object sender, EventArgs e)


{
Mylabel.ForeColor = Color.Blue;
}

private void toolStripComboBox1_Click(object sender, EventArgs e)


{

private void aboutToolStripMenuItem_Click(object sender, EventArgs e)


{
MessageBox.Show("This is an example\nof using menus.", "About",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}

private void boldToolStripMenuItem_Click(object sender, EventArgs e)


{
Mylabel.Font = new Font(Mylabel.Font, Mylabel.Font.Style ^ FontStyle.Bold);
}

private void italicToolStripMenuItem_Click(object sender, EventArgs e)


{
Mylabel.Font = new Font(Mylabel.Font, Mylabel.Font.Style ^ FontStyle.Italic);
}

private void greenToolStripMenuItem_Click(object sender, EventArgs e)


{
Mylabel.ForeColor = Color.Green;
}

private void yellowToolStripMenuItem_Click(object sender, EventArgs e)


{
Mylabel.ForeColor = Color.Yellow;
}
}
}

You might also like