Instance failure...???

Hi!

I wrote this code but when I click on my save button. Its stack and show message that saying: instance failure. I do check the database path its sound correct. Its showing the but on conn.open;

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 System.Data.SqlClient;

namespace ElSoft_FactuStocks

{

public partial class Facturacao : Form

{

public Facturacao()

{

InitializeComponent();

bindCombo();

}

SqlConnection conn;

SqlCommand comm;

SqlDataReader dreader;

string connstr = @"Data Source=localhost\\sqlexpress;Initial Catalog=lunaoffice;Integrated Security=True";

private void btnGravar_Facturacao_Click(object sender, EventArgs e)

{

conn = new SqlConnection(connstr);

conn.Open();// here

comm = new SqlCommand("insert into fact values(" + symb.Text + ",'" + nomeClienteFactu.Text + ",'" + artigoFactu.Text + "'," + leituraCodFactu.Text +

",'" + quantidadeFactu.Text + ",'" + precosaidaFactu.Text + ",'" + totalFactu.Text + ",'" + descontoFactu.Text + ",'" + utilizadores.Text + "')", conn);

try

{

comm.ExecuteNonQuery();

MessageBox.Show("Saved...");

}

catch (Exception)

{

MessageBox.Show("Not Saved");

}

finally

{

conn.Close();

}

3 Replies

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

Ranjit Powar12y ago
Hey check single quots in insert query.
Mfwamba Tshimanga12y ago
Now its doesnt show the error message "instance failure". But its still saying "Not saved". I am sure if the problem it's in DB. I think not.
Ranjit Powar12y ago
Write connection string as

string connstr = @"Data Source=localhost\sqlexpress;Initial Catalog=lunaoffice;Integrated Security=True";

OR

string connstr = "Data Source=localhost\\sqlexpress;Initial Catalog=lunaoffice;Integrated Security=True";