private void newNoteToolStripMenuItem_Click(object sender, EventArgs e)
{
sRow = dt.NewSongNotesRow();
sRow.Note = "";
dt.AddSongNotesRow(sRow);
SndataGrid.ReadOnly = false;
}
private void LoadSongNote(int songNumber)
{
dt = new PresenterDataset.SongNotesDataTable();
SNdataView = new DataView();
this.Controls.Add(SndataGrid);
BindingSource source = new BindingSource();
source.DataSource = SNdataView;
SndataGrid.DataSource = SNdataView;
int SongId = 5;
using (FBirdTask t = new FBirdTask())
{
t.CommandText = "SELECT [SongNotes].[Number], [SongNotes].[Note], [SongNotes].[IdSong] FROM [SongNotes]" +
" where [SongNotes].[IdSong]=" + songNumber;
t.ExecuteReader();
if (t.DR != null)
{
int rowNumber = 1;
while (t.DR.Read())
{
sRow = dt.NewSongNotesRow();
sRow.Number = t.GetInt32(0); // rowNumber;
sRow.Note = t.GetString(1);
// sRow.SongNumber= t.GetInt32(2);
dt.AddSongNotesRow(sRow);
rowNumber++;
}
t.DR.Close();
SNdataView.BeginInit();
SNdataView.Table = dt;
SNdataView.EndInit();
}
else
{
sRow = dt.NewSongNotesRow();
sRow.Note = "";
dt.AddSongNotesRow(sRow);
}
rowCount = dt.Rows.Count;
}
}
