// 用生成的代码插入数据
public static void AddRecords(AutoLotDataSet.InventoryDataTable tb,
InventoryTableAdapter dAdapt)
{
try
{
// 从表中获取新的强类型的行
AutoLotDataSet.InventoryRow newRow = tb.NewInventoryRow();
// 使用一些示例数据填充该行
newRow.CarID = 999;
newRow.Color = "Purple";
newRow.Make = "BMW";
newRow.PetName = "Saku";
// 插入新行
tb.AddInventoryRow(newRow);
// 使用重载的Add方法添加另一个行
tb.AddInventoryRow(888, "Yugo", "Green", "Zippy");
// 更新数据库
dAdapt.Update(tb);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public static void AddRecords(
AutoLotDataSet.InventoryDataTable table,
InventoryTableAdapter adapter)
{
try
{
// Get a new strongly typed row from the table.
AutoLotDataSet.InventoryRow newRow = table.NewInventoryRow();
// Fill row with some sample data.
newRow.Color = "Purple";
newRow.Make = "BMW";
newRow.Name = "Saku";
// Insert the new row.
table.AddInventoryRow(newRow);
// Add one more row, using overloaded Add method.
table.AddInventoryRow("Yugo", "Green", "Zippy");
// Update database.
adapter.Update(table);
}
catch (Exception ex)
{
WriteLine(ex.Message);
}
}
private static void AddRecords(AutoLotDataSet.InventoryDataTable dt, InventoryTableAdapter dAdapt)
{
try
{
// Получить из таблицы новую строго типизированную строку
AutoLotDataSet.InventoryRow newRow = dt.NewInventoryRow();
// Заполнить строку данными
newRow.CarID = 999;
newRow.Color = "Purple";
newRow.Make = "BMW";
newRow.PetName = "Saku";
// Вставить новую строку
dt.AddInventoryRow(newRow);
// Добавить еще одну строку, используя перегруженный метод добавления
dt.AddInventoryRow(777, "Yugo", "Green", "Zippy");
// Обновить базу данных
dAdapt.Update(dt);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private static void AddRecords(AutoLotDataSet.InventoryDataTable table, InventoryTableAdapter adapter) // Добавление записей
{
AutoLotDataSet.InventoryRow newRow = table.NewInventoryRow(); // Получение из таблицы новой строго типизированной строки
newRow.CarID = 999; // Заполнение строки данными
newRow.Color = "Purple";
newRow.Make = "BMW";
newRow.PetName = "Saku";
table.AddInventoryRow(newRow); // Вставка новой строки
table.AddInventoryRow(888, "Yugo", "Green", "Zippy");
adapter.Update(table); // Обновление базы данных
}
private static void AddRecords(AutoLotDataSet.InventoryDataTable table, InventoryTableAdapter adapter)
{
AutoLotDataSet.InventoryRow newRow = table.NewInventoryRow();
newRow.Color = "Purple";
newRow.Make = "BMW";
newRow.PetName = "Saku";
table.AddInventoryRow(newRow);
table.AddInventoryRow("Yugo", "Green", "Zippy");
adapter.Update(table);
}
public static void AddRecords(AutoLotDataSet.InventoryDataTable table, InventoryTableAdapter adapter)
{
try
{
//add new row
AutoLotDataSet.InventoryRow newRow = table.NewInventoryRow();
Console.WriteLine("Enter new color:");
newRow.Color = (string)Console.ReadLine();
Console.WriteLine("Enter new Make:");
newRow.Make = (string)Console.ReadLine();
Console.WriteLine("Enter new PetName:");
newRow.PetName = (string)Console.ReadLine();
table.AddInventoryRow(newRow);
////another way (Dont forget about position in constructor)
//Console.WriteLine("Enter new color:");
//string strColor = (string)Console.ReadLine();
//Console.WriteLine("Enter new Make:");
//string strMake = (string)Console.ReadLine();
//Console.WriteLine("Enter new PetName:");
//string strPetName = (string)Console.ReadLine();
//table.AddInventoryRow(strMake, strColor, strPetName);
adapter.Update(table);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public static void AddRecords(AutoLotDataSet.InventoryDataTable table, InventoryTableAdapter adapter)
{
try
{
var newRow = table.NewInventoryRow();
newRow.Color = "Purple";
newRow.Make = "BMW";
newRow.PetName = "Saku";
table.AddInventoryRow(newRow);
table.AddInventoryRow("Yugo", "Green", "Zippy");
adapter.Update(table);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public static void AddRecords(AutoLotDataSet.InventoryDataTable tb, InventoryTableAdapter dAdapt)
{
try
{
AutoLotDataSet.InventoryRow newRow = tb.NewInventoryRow();
//
newRow.CarID = 991;
newRow.Color = "Purple";
newRow.Make = "BMW";
newRow.PetName = "Saku";
//
tb.AddInventoryRow(newRow);
tb.AddInventoryRow(887, "Yugo", "Green", "Zippy");
dAdapt.Update(tb);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public static void AddRecords(AutoLotDataSet.InventoryDataTable tb, InventoryTableAdapter dAdapt)
{
// Get a new strongly typed row from the table.
AutoLotDataSet.InventoryRow newRow = tb.NewInventoryRow();
// Fill row with some sample data.
newRow.CarID = 999;
newRow.Color = "Purple";
newRow.Make = "BMW";
newRow.PetName = "Saku";
// Insert the new row.
tb.AddInventoryRow(newRow);
// Add one more row, using overloaded Add method.
tb.AddInventoryRow(888, "Yugo", "Green", "Zippy");
// Update database.
dAdapt.Update(tb);
}
