code in .cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DAL;
using BLL;
namespace _3TIERlanguage
{
public partial class nvcontrol : UserControl
{
bll obj = new bll();
public nvcontrol()
{
InitializeComponent();
}
// private void btnsave_Click(object sender, EventArgs e)
// {
// }
private void btnupdate_Click(object sender, EventArgs e)
{
if (txtcode.Text == "")
{
MessageBox.Show("enter code you want to updated");
}
else
{
try
{
obj.pCODE = Convert.ToInt32(txtcode.Text);
obj.pNAME = txtname.Text;
obj.updaterec();
MessageBox.Show("updated");
obj.bind();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void btndelete_Click(object sender, EventArgs e)
{
if (txtcode.Text == "")
{
MessageBox.Show("enter code you want to delete");
}
else
{
try
{
obj.pCODE = Convert.ToInt32(txtcode.Text);
obj.deleterec();
obj.bind();
MessageBox.Show("LANGUAGE '"+txtcode.Text+"'deleted");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void btnew_Click(object sender, EventArgs e)
{
txtcode.Text = "";
txtname.Text = "";
}
private void nvcontrol_Load(object sender, EventArgs e)
{
dataGridView1.DataSource = obj.getlandata();
}
private void dataGridView1_CellEnter(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex];
dataGridView1.ReadOnly = true;
txtcode.Text = row.Cells["CODE"].Value.ToString();
txtname.Text = row.Cells["NAME"].Value.ToString();
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
obj.pCODE = Convert.ToInt32(txtsearch.Text);
obj.findrec();
txtcode.Text = txtsearch.Text;
txtname.Text = obj.pNAME;
}
private void txtcode_KeyPress(object sender, KeyPressEventArgs e)
{
const char delete = (char)8;
e.Handled = !char.IsDigit(e.KeyChar)&&e.KeyChar!=delete;
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
if (txtcode.Text == "")
{
MessageBox.Show("enter deatils");
}
else
{
try
{
obj.pCODE = Convert.ToInt32(txtcode.Text);
obj.pNAME = txtname.Text;
obj.insertrec();
MessageBox.Show("inserted");
obj.bind();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void btnprint_Click(object sender, EventArgs e)
{
Form2 re = new Form2();
re.Show();
}
}
}
code for crystalreport in form2
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;
using _3TIERlanguage.DataSet1TableAdapters;
namespace _3TIERlanguage
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
DataSet1 report = new DataSet1();
DataSet1TableAdapters.language1TableAdapter la = new _3TIERlanguage.DataSet1TableAdapters.language1TableAdapter();
DataSet1.language1DataTable table = la.GetData();
report.SetDataSource(table.DefaultView);
crystalReportViewer1.ReportSource = report;
crystalReportViewer1.Refresh();
}
}
}