Comments by Member 7698619 (Top 3 by date)

Thank you .
then which db i have to use for my standalone application(C#) .Please give me a sample application.

App.cong file

add name="Marketdb" connectionstring="Data Source=.;AttachDbFilename=~\Market\Data\Bichayath.mdf;Integrated Security=True;User Instance=True" providername="System.Data.SqlClient">


page.cs



private void btnsubmit_Click(object sender, EventArgs e)
{
try
{
SqlCommand insrtcmd = new SqlCommand("insert into bichayathi values(@date,@BillNo,@Fname,@Village,@item,@bags,@Totalbill,@totalexpenditure,@finalamount,@Balance,@humali,@lorryrent,@commision,@bagsrent,@borrow,@dueamount,@intrest)", con);
con.Open();
insrtcmd.Parameters.AddWithValue("@date", System.DateTime.Now);
insrtcmd.Parameters.AddWithValue("@BillNo", txtbillno.Text);
insrtcmd.Parameters.AddWithValue("@Fname", txtname.Text);
insrtcmd.Parameters.AddWithValue("@Village", ddlvlg.Text);
insrtcmd.Parameters.AddWithValue("@item", ddlitem.Text);
insrtcmd.Parameters.AddWithValue("@bags", txtbags.Text);
insrtcmd.Parameters.AddWithValue("@Totalbill", txtbill.Text);
insrtcmd.Parameters.AddWithValue("@totalexpenditure", lblttlexp.Text);
insrtcmd.Parameters.AddWithValue("@finalamount", lblfamt.Text);
insrtcmd.Parameters.AddWithValue("@Balance", txtbal.Text);
insrtcmd.Parameters.AddWithValue("@humali", lblhamali.Text);
insrtcmd.Parameters.AddWithValue("@lorryrent", lbllryrnt.Text);
insrtcmd.Parameters.AddWithValue("@commision", lblcashcut.Text);
insrtcmd.Parameters.AddWithValue("@bagsrent", lblbagrent.Text);
insrtcmd.Parameters.AddWithValue("@borrow", txtbrw.Text);
insrtcmd.Parameters.AddWithValue("@dueamount", txtdueamt.Text);
insrtcmd.Parameters.AddWithValue("@intrest", txtintrate.Text);
insrtcmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record inserted ! ");
// reset();
}
catch (Exception ex)
{
MessageBox.Show(ex.StackTrace);
}
}

connection string :
SqlConnection con = new SqlConnection(@"Data Source=,;AttachDbFilename=~\Market\Data\Bichayath.mdf;Integrated Security=True;User Instance=True");

and i have attached a .mdb file to the application in data folder.
im getting problem with connection string of .mdb file .
please tell me how to set connection string and also deploy it to any system by making it as exe file