Pozdrav svima! Imam problem oko snimanja podataka u bazu. Kada kliknem na dugme snimi, MessageBox mi prikaze da je snimio podatke, medjutim kada otvorim bazu, nije upisana ni jedna vrednost. Hvala unapred na pomoci!
Evo koda:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace WindowsFormsApplication20
{
public partial class Form1 : Form
{
private bazaDataSet dsBaza;
private bazaDataSetTableAdapters.KNJIGATableAdapter daBaza;
public Form1()
{
daBaza = new WindowsFormsApplication20.bazaDataSetTableAdapters.KNJIGATableAdapter();
dsBaza = new bazaDataSet();
daBaza.Fill(dsBaza.KNJIGA);
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
bazaDataSet.KNJIGARow row = dsBaza.KNJIGA.NewKNJIGARow();
row.NASLOV = "naslov";
row.AUTOR = "autor";
row.ISBN = "11111";
row.KOLICINA = 1;
row.OPIS = "opis";
dsBaza.KNJIGA.AddKNJIGARow(row);
}
private void button2_Click(object sender, EventArgs e)
{
int i = 0;
try
{
this.Validate();
i = daBaza.Update(this.dsBaza.KNJIGA);
}
catch (OleDbException) {
MessageBox.Show("failed!");
}
MessageBox.Show(i.ToString());
}
private void button3_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = dsBaza.KNJIGA;
}
}
}
Evo koda:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace WindowsFormsApplication20
{
public partial class Form1 : Form
{
private bazaDataSet dsBaza;
private bazaDataSetTableAdapters.KNJIGATableAdapter daBaza;
public Form1()
{
daBaza = new WindowsFormsApplication20.bazaDataSetTableAdapters.KNJIGATableAdapter();
dsBaza = new bazaDataSet();
daBaza.Fill(dsBaza.KNJIGA);
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
bazaDataSet.KNJIGARow row = dsBaza.KNJIGA.NewKNJIGARow();
row.NASLOV = "naslov";
row.AUTOR = "autor";
row.ISBN = "11111";
row.KOLICINA = 1;
row.OPIS = "opis";
dsBaza.KNJIGA.AddKNJIGARow(row);
}
private void button2_Click(object sender, EventArgs e)
{
int i = 0;
try
{
this.Validate();
i = daBaza.Update(this.dsBaza.KNJIGA);
}
catch (OleDbException) {
MessageBox.Show("failed!");
}
MessageBox.Show(i.ToString());
}
private void button3_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = dsBaza.KNJIGA;
}
}
}