Click here to Skip to main content
15,893,622 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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();


}

}
}
Posted

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900