Setup creation with database of windows form application

Anilananda Chakrabortty

Hello ,

again one problem .... I'm not gatting solution plz help...

I created one windows form there was two textbox and one buttion for insert..

i written my connection like...

SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=c:\users\anilananda\documents\visual studio 2013\Projects\demoProject\Database1.mdf;Integrated Security=True");

it is working but when i put like this

SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;");

that time it is not inserting and no error message also ....why ?? plz help

=====================

actually i want to create a setup file so i d'nt want to give connection like 1st one because if i give like this it will work in my system only.

so i want to give second one type so that it should work in others system also .

i want to provide the complet databse (Database1.mdf )

in my project file so that it will work as a local databse no need to install sqlserver in other system. because database is available.

but this how to do this i d'nt know ... plz any one help me.

My intention is only create setup file with databse that i will provide in project folder and after creation exe file it should work in other system aslo without having sqlserver in there system.

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
if this question is answered then make mark as answered.
Anilananda Chakrabortty9y ago
@Rafnas T P

Thank you for ur support ....i understand now i got it ...
now i will do in vs 2013 if any problem happen , i'll let u know...
Rafnas T P9y ago
if you inserted a record in database, that is permenant , you will get every time when you select.
check your connection string for both insertion and selection from which database your dealing with both should be in local debug database
Anilananda Chakrabortty9y ago
@
Rafnas T P

yes now i got it but...
It working only runtime if close debug and again debug
then whatever data i inserted befour that is not comming
...
only runtime it working nicely ...any solution ???

this code im using for viewing the data in the same form only...

private void button2_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from tblname", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}
Rafnas T P9y ago
which database did you check. is it from locally saved which is in debug or in sqlserver management studio(default in c drive). it will save only in debug folder database
Anilananda Chakrabortty9y ago
hi,

now i change the visual studio version from 2013 to 2008

my code is like====

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace WindowsFormsApplication3
{
public partial class Form1 : Form
{
SqlConnection con = new SqlConnection(string.Format(@"Data Source=.\SQLEXPRESS;AttachDbFilename={0}\Database1.mdf;Integrated Security=True", Environment.CurrentDirectory));
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{

con.Open();
SqlCommand cmd = new SqlCommand("insert into tblname (name) values('" + textBox1.Text + "')", con);
cmd.ExecuteNonQuery();
MessageBox.Show("added");
con.Close();
}
}
}

@
Rafnas T P There is no error but when i open db table there is no data..

@
Amit Gupta It showing that connection not opening...
Rafnas T P9y ago
SqlConnection con = new SqlConnection(string.Format(@"Data Source=(LocalDB)\v11.0;AttachDbFilename={0}\Database1.mdf;Integrated Security=True", Environment.CurrentDirectory));
Amit Gupta9y ago
Just rectify some snippet
SqlConnection con = new SqlConnection($@"Data Source=(LocalDB)\v11.0;AttachDbFilename={Environment.CurrentDirectory}\Database1.mdf;Integrated Security=True", );
Anilananda Chakrabortty9y ago
Error 2 'System.Data.SqlClient.SqlConnection' does not contain a constructor that takes '2' arguments

@Rafnas T P

again error....plz help
i given like...

SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename={0}\Database1.mdf;Integrated Security=True", Environment.CurrentDirectory);
Rafnas T P9y ago
hi I have clearly told you to put your database(Database1.mdf) in debug folder of your project and give connection string to it like below
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename={0}\Database1.mdf;Integrated Security=True",Environment.CurrentDirectory);

instead of full path give Environment.CurrentDirectory for debug folder path and your filename
try and let me know
Ramesh Palanivel9y ago
Hi Anilananda, Create a connection string in app config, read about the connection string method. It will help u. If u install Ur setup on other machine, just make the changes on app config.

Setup creation with database of windows form application

@Rafnas T P

Rafnas T P There is no error but when i open db table there is no data..

Amit Gupta It showing that connection not opening...

@Rafnas T P