hey, im trying to parse information from a datagrid into an sql table
this is what im thinking:
private void storeDataBTN_Click(object sender, EventArgs e)
{
using (conn)
{
SqlCommand command = new SqlCommand("INSERT INTO BookDetails VALUES(@Title, @AuthorFirstName, @AuthorSurname, @AquisitionDate, @PublisherName ,@PublisherCity, @PublishingDate, @ISBN, @DDClassification)", conn);
foreach (DataGridViewRow dr in DGTables.Rows)
{
command.Parameters.AddWithValue("@Title", titleDataGridViewTextBoxColumn);
command.Parameters.AddWithValue("@AuthorFirstName", authorFirstNameDataGridViewTextBoxColumn);
command.Parameters.AddWithValue("@AuthorSurname", authorSurnameDataGridViewTextBoxColumn);
command.Parameters.AddWithValue("@AquisitionDate", aquisitionDateDataGridViewTextBoxColumn.ToString());
command.Parameters.AddWithValue("@PublisherName", publisherNameDataGridViewTextBoxColumn);
command.Parameters.AddWithValue("@PublisherCity", publisherCityDataGridViewTextBoxColumn);
command.Parameters.AddWithValue("@PublishingDate", publishingDateDataGridViewTextBoxColumn.ToString());
command.Parameters.AddWithValue("@ISBN", iSBNDataGridViewTextBoxColumn);
command.Parameters.AddWithValue("@DDClassification", dDClassificationDataGridViewTextBoxColumn);
try
{
conn.Open();
int rows = command.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Insert succesful");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
i get the error :
string or binary data would be truncated
any help appreciated
thanks