Aslam-u-Alikuum Beautiful People
Accounting Software Part 2
SQl Code
Create Tabel:
Companies Name
For Save And Update Record:
CREATE PROCEDURE [dbo].[Csuprocedures]
@mode nvarchar(50),
@Id int,
@CCode nvarchar(50),
@CName nvarchar(50),
@CAddress nvarchar(300),
@CContactinfo nvarchar(50)
AS
if @mode = 'Add'
BEGIN
INSERT INTO [dbo].[Company Name]
(
CCode,
CName,
CAddress,
CContactinfo
)
VALUES(
@CCode,
@CName,
@CAddress,
@CContactinfo
)
END
ELSE If @mode='Edit'
BEGIN
UPDATE [dbo].[Company Name]
SET
CCode = @CCode,
CName = @CName,
CAddress = @CAddress,
CContactinfo = @CContactinfo
WHERE Id = @Id
END
For Search :
CREATE PROCEDURE [dbo].[CVSsearch]
@CName nvarchar(50)
As
select * from [dbo].[Company Name]
Where CName like @CName+'%'
For Delete:
Create PROCEDURE [dbo].[CDdelete]
@Id int
AS
DELETE [dbo].[Company Name]
WHERE Id=@Id
Accounting Software Part 2
C# Code:
On Admin panel:
Form3 f = new Form3();
f.Show();
On Starting
SqlConnection sqlCon = new SqlConnection(@"Data Source=DESKTOP-DODHH2V\SAAD;Initial Catalog=acoountingsoftware;Integrated Security=True");
int Id = 0;
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (sqlCon.State == ConnectionState.Closed)
sqlCon.Open();
if (btnSave.Text == "Save")
{
SqlCommand sqlcmd = new SqlCommand("[dbo].[Csuprocedures]", sqlCon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@mode", "Add");
sqlcmd.Parameters.AddWithValue("@Id", "0");
sqlcmd.Parameters.AddWithValue("@CCode", textBox1.Text.Trim());
sqlcmd.Parameters.AddWithValue("@CName", textBox2.Text.Trim());
sqlcmd.Parameters.AddWithValue("@CAddress", textBox3.Text.Trim());
sqlcmd.Parameters.AddWithValue("@CContactinfo", textBox4.Text.Trim());
sqlcmd.ExecuteNonQuery();
MessageBox.Show("Saved Success fully...:-)");
}
else
{
SqlCommand sqlcmd = new SqlCommand("[dbo].[Csuprocedures]", sqlCon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@mode", "Edit");
sqlcmd.Parameters.AddWithValue("@Id", Id);
sqlcmd.Parameters.AddWithValue("@CCode", textBox1.Text.Trim());
sqlcmd.Parameters.AddWithValue("@CName", textBox2.Text.Trim());
sqlcmd.Parameters.AddWithValue("@CAddress", textBox3.Text.Trim());
sqlcmd.Parameters.AddWithValue("@CContactinfo", textBox4.Text.Trim());
sqlcmd.ExecuteNonQuery();
MessageBox.Show("updates Saved Success fully...:-)");
}
Reset();
FillDataGridView();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error...!!");
}
finally
{
sqlCon.Close();
}
}
void FillDataGridView()
{
if (sqlCon.State == ConnectionState.Closed)
sqlCon.Open();
SqlDataAdapter SqlDA = new SqlDataAdapter("[dbo].[CVSsearch]", sqlCon);
SqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlDA.SelectCommand.Parameters.AddWithValue("@CName", textBox5.Text.Trim());
DataTable dtbl = new DataTable();
SqlDA.Fill(dtbl);
dataGridView1.DataSource = dtbl;
dataGridView1.Columns[0].Visible = false;
sqlCon.Close();
}
private void button4_Click(object sender, EventArgs e)
{
try
{
FillDataGridView();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error...!!");
}
}
void Reset()
{textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = textBox5.Text = "";
btnSave.Text = "Save";
FillDataGridView();
btnDelete.Enabled = false;
}
private void btnReset_Click(object sender, EventArgs e)
{
Reset();
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (sqlCon.State == ConnectionState.Closed)
sqlCon.Open();
SqlCommand sqlcmd = new SqlCommand("[dbo].[CDdelete]", sqlCon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Id", Id);
sqlcmd.ExecuteNonQuery();
MessageBox.Show("Deleted Success fully...:-)");
Reset();
FillDataGridView();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error...!!");
}
}
private void dataGridView1_DoubleClick(object sender, EventArgs e)
{
Id = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());
textBox1.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();
textBox2.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();
textBox3.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString();
textBox4.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString();
btnSave.Text = "Update";
btnDelete.Enabled = true;
}
private void Form3_Load(object sender, EventArgs e)
{
Reset();
FillDataGridView();
}
DataTable dtbl = new DataTable();
SqlDA.Fill(dtbl);
dataGridView1.DataSource = dtbl;
dataGridView1.Columns[0].Visible = true;
sqlCon.Close();
}
On Search Button Event:
try
{
FillDataGridView();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error...!!");
}
on Grid View Double Click Event:
Id = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());
txtName.Text = dataGridView1.CurrentRow.Cells[1]. Value . ToString();
btnSave.Text = "Update";
btnDelete.Enabled = true;
After this do:
void Reset()
{
txtName.Text = "";
txtsearch.Text = "";
btnSave.Text = "Save";
Id = 0;
btnDelete.Enabled = false;
FillDataGridView();
}
On Button Reset Click:
Reset();
on Delete Click:
try
{
if (sqlCon.State == ConnectionState.Closed)
sqlCon.Open();
SqlCommand sqlcmd = new SqlCommand("kgonesnrdeletion", sqlCon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Id", Id);
sqlcmd.ExecuteNonQuery();
MessageBox.Show("Deleted Success fully...:-)");
Reset();
FillDataGridView();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error...!!");
}
No comments:
Post a Comment