Code:
namespace TC
{
public partial class frmProizvodjac : Form
{
string connString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TC.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn;
SqlDataAdapter da;
SqlCommandBuilder cmb;
public frmProizvodjac()
{
InitializeComponent();
}
/*
private void proizvodjacBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
this.Validate();
this.proizvodjacBindingSource.EndEdit();
this.proizvodjacTableAdapter.Update(this.tcDataSet1.Proizvodjac);
}
*/
private void frmProizvodjac_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'tcDataSet1.Proizvodjac' table. You can move, or remove it, as needed.
this.proizvodjacTableAdapter.Fill(this.tcDataSet1.Proizvodjac);
Napuni();
UpdateProizvodjac();
//BrisiProizvodjac();
}
private void Napuni()
{
string select = "SELECT * FROM Proizvodjac";
conn = new SqlConnection(connString);
da = new SqlDataAdapter(select, conn);
//DataSet ds = new DataSet();
da.Fill(tcDataSet1, "Proizvodjac");
DataTable dt = tcDataSet1.Tables["Proizvodjac"];
proizvodjacDataGridView.DataSource = dt;
// proizvodjacListBox.DataSource = dt;
// proizvodjacListBox.DisplayMember = "Naziv";
//txtID.DataBindings.Add("Text", ds, "Proizvodjac.ProizvodjacID");
// txtNaziv.DataBindings.Add("Text", dt, "Naziv");
//bm = this.BindingContext[tcrDataSet1, "Proizvodjac"];
}
private void UpdateProizvodjac()
{
string select = " Select * From Proizvodjac";
conn = new SqlConnection(connString);
da = new SqlDataAdapter(select, conn);
SqlCommand com = new SqlCommand(select, conn);
da.SelectCommand = com;
cmb = new SqlCommandBuilder(da);
da.Fill(tehnocentarDataSet1, "Proizvodjac");
//proizvodjacListBox.DataSource = tcDataSet1.Tables[0].DefaultView;
//proizvodjacListBox.DisplayMember = "Naziv";
}
private void BrisiProizvodjac()
{
string select = " Select * From Proizvodjac";
conn = new SqlConnection(connString);
da = new SqlDataAdapter(select, conn);
SqlCommand com = new SqlCommand(select, conn);
da.DeleteCommand = com;
cmb = new SqlCommandBuilder(da);
da.Fill(tcDataSet1, "Proizvodjac");
//proizvodjacDataGridView.DataSource = tcDataSet1.Tables[0].DefaultView;
}
private void btnDodaj_Click(object sender, EventArgs e)
{
}
private void btnIzmeni_Click(object sender, EventArgs e)
{
da.Update(tcDataSet1, "Proizvodjac");
}
private void btnObrisii_Click(object sender, EventArgs e)
{
da.Update(tcDataSet1, "Proizvodjac");
}
namespace TC
{
public partial class frmProizvodjac : Form
{
string connString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TC.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn;
SqlDataAdapter da;
SqlCommandBuilder cmb;
public frmProizvodjac()
{
InitializeComponent();
}
/*
private void proizvodjacBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
this.Validate();
this.proizvodjacBindingSource.EndEdit();
this.proizvodjacTableAdapter.Update(this.tcDataSet1.Proizvodjac);
}
*/
private void frmProizvodjac_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'tcDataSet1.Proizvodjac' table. You can move, or remove it, as needed.
this.proizvodjacTableAdapter.Fill(this.tcDataSet1.Proizvodjac);
Napuni();
UpdateProizvodjac();
//BrisiProizvodjac();
}
private void Napuni()
{
string select = "SELECT * FROM Proizvodjac";
conn = new SqlConnection(connString);
da = new SqlDataAdapter(select, conn);
//DataSet ds = new DataSet();
da.Fill(tcDataSet1, "Proizvodjac");
DataTable dt = tcDataSet1.Tables["Proizvodjac"];
proizvodjacDataGridView.DataSource = dt;
// proizvodjacListBox.DataSource = dt;
// proizvodjacListBox.DisplayMember = "Naziv";
//txtID.DataBindings.Add("Text", ds, "Proizvodjac.ProizvodjacID");
// txtNaziv.DataBindings.Add("Text", dt, "Naziv");
//bm = this.BindingContext[tcrDataSet1, "Proizvodjac"];
}
private void UpdateProizvodjac()
{
string select = " Select * From Proizvodjac";
conn = new SqlConnection(connString);
da = new SqlDataAdapter(select, conn);
SqlCommand com = new SqlCommand(select, conn);
da.SelectCommand = com;
cmb = new SqlCommandBuilder(da);
da.Fill(tehnocentarDataSet1, "Proizvodjac");
//proizvodjacListBox.DataSource = tcDataSet1.Tables[0].DefaultView;
//proizvodjacListBox.DisplayMember = "Naziv";
}
private void BrisiProizvodjac()
{
string select = " Select * From Proizvodjac";
conn = new SqlConnection(connString);
da = new SqlDataAdapter(select, conn);
SqlCommand com = new SqlCommand(select, conn);
da.DeleteCommand = com;
cmb = new SqlCommandBuilder(da);
da.Fill(tcDataSet1, "Proizvodjac");
//proizvodjacDataGridView.DataSource = tcDataSet1.Tables[0].DefaultView;
}
private void btnDodaj_Click(object sender, EventArgs e)
{
}
private void btnIzmeni_Click(object sender, EventArgs e)
{
da.Update(tcDataSet1, "Proizvodjac");
}
private void btnObrisii_Click(object sender, EventArgs e)
{
da.Update(tcDataSet1, "Proizvodjac");
}
Hvala unapred
[Ovu poruku je menjao zenmorke dana 21.03.2008. u 02:16 GMT+1]
[Ovu poruku je menjao zenmorke dana 21.03.2008. u 04:19 GMT+1]
[Ovu poruku je menjao zenmorke dana 22.03.2008. u 07:16 GMT+1]
sve je s***** osim pishanja