Hello people
I need to know how can I work a delete command from a table adapter. Follows
my linnes:
1) A solution that contains win app and one class Library.
2) The Class Library (Slibrary) its refence to app (Smovieapp).
3) In the Class library theres a DataSet (SmartDS)
4) Build in a SQL Express 2005 table that follows:
ID Nome Linguagem Acervo Sinopse [Classificação] Assistido Genero 1 A
proposta Legendado 2 A arte do demônio Dublado 3 A batalha de
Riddick Dublado 4 A bolha assassina
Legendado 5 A bússola de ouro Dublado 6 A caçada Dublado 7 A cadeira do
diabo Dublado 8 A Caminho da Guerra Dublado 9 A cartada final Dublado 10
A casa caiu Dublado 11 A casa das coelhinhas Dublado 12 A casa de vidro 2
Dublado 13 A casa do lago Dublado 14 A casa dos horrores Dublado 15 A
caverna Dublado Collum Name Data Type Allow Nulls ID int Unchecked
Nome nvarchar(50) Unchecked Linguagem nvarchar(50)
Checked Acervo nvarchar(50) Checked Sinopse
nvarchar(MAX) Checked Classificação nvarchar(50) Checked
Assistido nvarchar(50) Checked Genero nvarchar(50) Checked
4b)The last blue part is the table definition all the fields isn't null just
here. There's a default value = 'Editar'.
5) THeres an Inherit Form that the control call the data in a gridview an
some text boxes, combo boxes.....
All works perfectly, just the delete not,
The delete control is a button follows the code:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Data.Common;
using System.Data.SqlTypes;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Text;
using System.Windows.Forms;
using Slibrary;
using Slibrary.SmartDSTableAdapters;
namespace Smovieapp
{
public partial class SmovieEditor : Smovieapp.FatherForm
{
//FilmotecaTableAdapter Morpheu;
SmartDS.FilmotecaDataTable Morpheu;
int Index;
SmartDS.FilmotecaDataTable MOrpheuRow;
public SmovieEditor()
{
InitializeComponent();
}
private void SmovieEditor_Load_1(object sender, EventArgs e)
{
// TODO: This line of code loads data into the
'sdataDataSetGrid.Filmoteca' table. You can move, or remove it, as needed.
this.filmotecaTableAdapter1.Fill(this.sdataDataSetGrid.Filmoteca);
// TODO: This line of code loads data into the 'sdataDataSet.Filmoteca'
table. You can move, or remove it, as needed.
this.filmotecaTableAdapter.Fill(this.sdataDataSet.Filmoteca);
#region [EVENTO LOAD>>>>> recuperando dados, populando]
FilmotecaTableAdapter adapter = new FilmotecaTableAdapter();
Morpheu = new SmartDS.FilmotecaDataTable();
MOrpheuRow = new SmartDS.FilmotecaDataTable();
adapter.Fill(Morpheu);
adapter.Dispose();
Index = 0;
ShowData();
// DataTable dtLista = new DataTable();
// dataGridView1.DataSource = Morpheu;
#endregion
}
#region [Chamado SHOW DATA]
private void ShowData()
{
if (Index < 0)
Index = 0;
if (Index > Morpheu.Count - 1)
Index = Morpheu.Count - 1;
txtCursorIndex1.Text = Index.ToString();
txtIDEdit.Text =
Morpheu[Index].ID.ToString();
txtNomeEdit.Text =
Morpheu[Index].Nome.Trim();
cbLinguagemEdit.Text =
Morpheu[Index].Linguagem.Trim();
cbGeneroEdit.Text =
Morpheu[Index].Genero.Trim();
cbClassificaçãoEdit.Text =
Morpheu[Index].__Classificação_.Trim();
cbAssitidoEdit.Text =
Morpheu[Index].Assistido.Trim();
rtxtSinopseEdit.Text =
Morpheu[Index].Sinopse.Trim();
txtAcervoEdit.Text =
Morpheu[Index].Acervo.Trim();
}
#endregion
private void btnNext_Click(object sender, EventArgs e)
{
Index++;
ShowData();
}
private void btnFirst_Click(object sender, EventArgs e)
{
Index = 0;
ShowData();
}
private void btnPrevious_Click(object sender, EventArgs e)
{
Index--;
ShowData();
}
private void btnLast_Click(object sender, EventArgs e)
{
Index = Morpheu.Count - 1;
ShowData();
}
private void btnSel_Click(object sender, EventArgs e)
{
FilmotecaTableAdapter da = new FilmotecaTableAdapter();
da.Fill(Morpheu);
da.Dispose();
int valor = new int();
int valor2 = new int();
valor = Convert.ToInt32(label3.Text);
valor2 = valor - 1;
Index = valor2;
if (Index < 0)
Index = valor2;
if (Index > Morpheu.Count + 1)
Index = Morpheu.Count + 1;
txtCursorIndex1.Text = Index.ToString();
txtIDEdit.Text =
Morpheu[Index].ID.ToString();
txtNomeEdit.Text =
Morpheu[Index].Nome.Trim();
cbLinguagemEdit.Text =
Morpheu[Index].Linguagem.Trim();
cbGeneroEdit.Text =
Morpheu[Index].Genero.Trim();
cbClassificaçãoEdit.Text =
Morpheu[Index].__Classificação_.Trim();
cbAssitidoEdit.Text =
Morpheu[Index].Assistido.Trim();
rtxtSinopseEdit.Text =
Morpheu[Index].Sinopse.Trim();
txtAcervoEdit.Text =
Morpheu[Index].Acervo.Trim();
}
private void btnNew_Click(object sender, EventArgs e)
{
txtNomeEdit.Focus();
Index = Morpheu.Count;
txtCursorIndex1.Text = Index.ToString();
txtIDEdit.Text = "";
txtNomeEdit.Text = "";
cbLinguagemEdit.Text = "";
cbGeneroEdit.Text = "";
txtAcervoEdit.Text = "";
cbAssitidoEdit.Text = "";
rtxtSinopseEdit.Text = "";
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtNomeEdit.Text.Trim() == string.Empty)
{
MessageBox.Show("Olha, o nome do filme deve ser
preenchido...");
return;
}
FilmotecaTableAdapter adapter = new FilmotecaTableAdapter();
if (Index == Morpheu.Count)
adapter.Insert(txtNomeEdit.Text.Trim(),
cbLinguagemEdit.Text.Trim(),
txtAcervoEdit.Text.Trim(), rtxtSinopseEdit.Text.Trim(),
cbClassificaçãoEdit.Text.Trim(),
cbAssitidoEdit.Text.Trim(),
cbGeneroEdit.Text.Trim());
else
{
Morpheu[Index].Nome = txtNomeEdit.Text.Trim();
Morpheu[Index].Linguagem = cbLinguagemEdit.Text.Trim();
Morpheu[Index].Acervo = txtAcervoEdit.Text.Trim();
Morpheu[Index].Sinopse = rtxtSinopseEdit.Text.Trim();
Morpheu[Index].__Classificação_=
cbClassificaçãoEdit.Text.Trim();
Morpheu[Index].Assistido = cbAssitidoEdit.Text.Trim();
Morpheu[Index].Genero = cbGeneroEdit.Text.Trim();
adapter.Update(Morpheu[Index]);
}
Morpheu.Clear();
adapter.Fill(Morpheu);
adapter.Dispose();
ShowData();
dataGridView1.Refresh();
this.Refresh();
this.Hide();
this.Show();
}
/*/ Here the not dele occurs!*
private void btnDelete_Click(object sender, EventArgs e)
{
int a = new int ();
a= Convert.ToInt32(txtCursorIndex1.Text);
Slibrary.SmartDSTableAdapters.FilmotecaTableAdapter filmotecaTA
= new Slibrary.SmartDSTableAdapters.FilmotecaTableAdapter();
filmotecaTA.Delete(a,txtNomeEdit.Text.Trim(),
cbLinguagemEdit.Text.Trim(),
txtAcervoEdit.Text.Trim(), cbClassificaçãoEdit.Text.Trim(),
cbAssitidoEdit.Text.Trim(), cbGeneroEdit.Text.Trim(),
rtxtSinopseEdit.Text.Trim());
Morpheu.Clear();
adapter.Fill(Morpheu);
adapter.Dispose();
ShowData();
dataGridView1.Refresh();
this.Refresh();
this.Hide();
this.Show();
// FilmotecaTableAdapter deleter = new FilmotecaTableAdapter()
;
// MessageBox.Show("Ainda não conseguir fazer este
controle funcionar corretamente");
//
deleter.DeleteQuery1(int.Parse(txtCursorIndex1.Text),
txtNomeEdit.Text.Trim(), cbLinguagemEdit.Text.Trim(),
// txtAcervoEdit.Text.Trim(),
cbClassificaçãoEdit.Text.Trim(),
// cbAssitidoEdit.Text.Trim(),
cbGeneroEdit.Text.Trim(), rtxtSinopseEdit.Text.Trim());
// Morpheu.Clear();
// deleter.Update(Morpheu);
// Morpheu[Index].Delete();
// deleter.Fill(Morpheu);
//deleter.Dispose();
//Index--;
// ShowData();
// dataGridView1.Refresh();
// this.Refresh();
}
}
I Don´t Know how the save works and the delete not work.... I used the same
logic.
Some Help?
Thank's
*Appendix:*
DeleteQuery:
Deletequery1:
or
Delete:
DELETE FROM Filmoteca
WHERE (ID = @Original_ID) AND (Nome = @Original_Nome) AND (Linguagem =
@Original_Linguagem) AND (Acervo = @Original_Acervo) AND
(Classificação = @Original_Classificação) AND
(Assistido = @Original_Assistido) AND (Genero = @Original_Genero) AND
(Sinopse = @Original_Sinopse)
