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;
using System.Data.OleDb;
namespace SRL
{
public partial class DAILY_REPORT : Form
{
OleDbConnection daily_rpt_con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Chirag\documents\visual studio 2012\Projects\SRL\SRL\SRL.accdb;Persist Security Info=True");
public DAILY_REPORT()
{
InitializeComponent();
}
private void btn_submit_Click(object sender, EventArgs e)
{
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM daily where bill_no='" +txt_bill_no.Text+ "'", daily_rpt_con);
DataTable dt = new DataTable();
da.Fill(dt);
try
{
OleDbCommand cmd1 = new OleDbCommand("select * from daily where bill_no='" + txt_bill_no.Text + "'", daily_rpt_con);
OleDbDataReader dr1;
daily_rpt_con.Open();
dr1 = cmd1.ExecuteReader();
if (dr1.Read())
{
MessageBox.Show("Duplicate Entry");
dataGridView1.DataSource = dt;
dataGridView1.Visible = true;
}
else
{
string current_date = dtp_current_date.Value.ToString();
string date = dtp_date.Value.ToString();
OleDbCommand daily_rpt_cmd = new OleDbCommand();
daily_rpt_cmd.CommandText = "insert into daily(bill_no,current_date,frm_daily,todaily,date,vechile_no,destination,sip_d_no,del_no,gr_no,qty,rate,amount)values(@bill_no,@current_date,@frm_daily,@todaily,@date,@vechile_no,@destination,@sip_d_no,@del_no,@gr_no,@qty,@rate,@amount)";
daily_rpt_cmd.Parameters.AddWithValue("@bill_no", txt_bill_no.Text);
daily_rpt_cmd.Parameters.AddWithValue("@current_date",current_date);
daily_rpt_cmd.Parameters.AddWithValue("@frm_daily",txt_from.Text);
daily_rpt_cmd.Parameters.AddWithValue("@todaily",txt_to.Text);
daily_rpt_cmd.Parameters.AddWithValue("@date",date);
daily_rpt_cmd.Parameters.AddWithValue("@vechile_no",txt_vehicle_no.Text);
daily_rpt_cmd.Parameters.AddWithValue("@destination",txt_destination.Text);
daily_rpt_cmd.Parameters.AddWithValue("@sip_d_no",txt_sip_no.Text);
daily_rpt_cmd.Parameters.AddWithValue("@del_no",txt_del_no.Text);
daily_rpt_cmd.Parameters.AddWithValue("@gr_no",txt_g_r_no.Text);
daily_rpt_cmd.Parameters.AddWithValue("@qty",txt_quantity.Text);
daily_rpt_cmd.Parameters.AddWithValue("@rate",txt_rate.Text);
daily_rpt_cmd.Parameters.AddWithValue("@amount",txt_amount.Text);
daily_rpt_cmd.Connection = daily_rpt_con;
daily_rpt_cmd.ExecuteNonQuery();
MessageBox.Show("hello");
MessageBox.Show("Record Submitted Successfully!");
OleDbDataAdapter da1 = new OleDbDataAdapter("select * from daily where bill_no='" + txt_bill_no.Text + "'", daily_rpt_con);
DataTable dt1 = new DataTable();
da1.Fill(dt1);
dataGridView1.DataSource = dt1;
dataGridView1.Visible = true;
}
}
catch
{
}
daily_rpt_con.Close();
}
}
}
What I have tried:
daily_rpt_cmd.CommandText = "insert into daily(bill_no,current_date,frm_daily,todaily,date,vechile_no,destination,sip_d_no,del_no,gr_no,qty,rate,amount)values(@bill_no,@current_date,@frm_daily,@todaily,@date,@vechile_no,@destination,@sip_d_no,@del_no,@gr_no,@qty,@rate,@amount)";
daily_rpt_cmd.Parameters.AddWithValue("@bill_no", txt_bill_no.Text);
daily_rpt_cmd.Parameters.AddWithValue("@current_date",current_date);
daily_rpt_cmd.Parameters.AddWithValue("@frm_daily",txt_from.Text);
daily_rpt_cmd.Parameters.AddWithValue("@todaily",txt_to.Text);
daily_rpt_cmd.Parameters.AddWithValue("@date",date);
daily_rpt_cmd.Parameters.AddWithValue("@vechile_no",txt_vehicle_no.Text);
daily_rpt_cmd.Parameters.AddWithValue("@destination",txt_destination.Text);
daily_rpt_cmd.Parameters.AddWithValue("@sip_d_no",txt_sip_no.Text);
daily_rpt_cmd.Parameters.AddWithValue("@del_no",txt_del_no.Text);
daily_rpt_cmd.Parameters.AddWithValue("@gr_no",txt_g_r_no.Text);
daily_rpt_cmd.Parameters.AddWithValue("@qty",txt_quantity.Text);
daily_rpt_cmd.Parameters.AddWithValue("@rate",txt_rate.Text);
daily_rpt_cmd.Parameters.AddWithValue("@amount",txt_amount.Text);