Im trying to write a WPF application using Linq but while trying to update the database (add new data to it) it doesn't update at all.
I want to add another row when I click a button but it doesn't update the database at all and after checking data it's still empty.
If anyone can help me with that I would be grateful.
namespace portiEX
{
public partial class LentPop : Window
{
DataBaseConnectionsDataContext DB = new DataBaseConnectionsDataContext();
DataBaseConDataContext Con = new DataBaseConDataContext();
DateTime CurrentDate = DateTime.Now;
string tmp;
List<string> EQ = new List<string>();
public LentPop()
{
InitializeComponent();
// Combobox with RoomNumbers
List<Table_Key> dataRoom = DB.Table_Keys.ToList();
RoomComboBox.ItemsSource = dataRoom;
RoomComboBox.DisplayMemberPath = "ROOM_NUMBER";
RoomComboBox.SelectedValuePath = "IDENTIFICATION_NUMBER";
// Combobox with info who took room
List<EMPLOYEE> dataEmp = DB.EMPLOYEEs.ToList();
PersonBorrComboBox.ItemsSource = dataEmp;
PersonBorrComboBox.DisplayMemberPath = "NAME_SURNAME";
PersonBorrComboBox.SelectedValuePath = "IDENTIFICATION_NUMBER";
// Combobox with Equipment selected
ListEquipment();
AddStuffComboBox.ItemsSource = EQ;
ComboBoxsSupplement();
//hour
LblCurrDate.Content = CurrentDate.ToString();
}
private void ComboBoxsSupplement()
{
enter code here
// Combobox with hours of return
HoursLoop(HourofRetComboBox);
// Combobox with mins of return
MinLoop(MinsofRetComboBox);
}
private void ListEquipment()
{
foreach (var s in DB.Equipments)
{
if (s.QUANITY != 0)
{
tmp = s.NAME;
EQ.Add(tmp);
}
}
}
private void CancelButt_Click(object sender, RoutedEventArgs e)
{
Con.Tables.InsertOnSubmit(new Table
{
Room_Number = decimal.Parse(RoomComboBox.Text),
Who_Borr = PersonBorrComboBox.Text,
Borrow_Data = CurrentDate,
Return_Date = HourofRetComboBox.Text,
Add_Eq = AddStuffComboBox.Text
});
Con.SubmitChanges();
this.Close();
}
public void RentButt_Click(object sender, RoutedEventArgs e)
{
string x = ("Room Number: " + RoomComboBox.Text + "\nWho Borrow: " + PersonBorrComboBox.Text +
"\nAdd Eq: " + AddStuffComboBox.Text + "\nDate: " + LblCurrDate.Content +
"\nReturn time: " + HourofRetComboBox.Text + ":" + MinsofRetComboBox.Text).ToString();
DB.Borroweds.InsertOnSubmit(new Borrowed
{
ROOM_NUMBER = decimal.Parse(RoomComboBox.Text),
WHO_BORROWED = PersonBorrComboBox.Text,
ADD_EQUIPMENT = AddStuffComboBox.Text,
BORROWED_DATE = CurrentDate.ToString(),
RETURN_DATE = HourofRetComboBox.Text + ":" + MinsofRetComboBox.Text,
});
DB.SubmitChanges();
MessageBox.Show(x);
}
private void HoursLoop(ComboBox comboBox)
{
for (int i = 0; i < 24; i++)
{
if(i<10)
{
comboBox.Items.Add("0" + i.ToString());
}
else
{
comboBox.Items.Add(i.ToString());
}
}
}
private void MinLoop(ComboBox comboBox)
{
for (int i = 0; i < 60; i++)
{
if(i<10)
{
comboBox.Items.Add("0" + i.ToString());
}
else
{
comboBox.Items.Add(i.ToString());
}
}
}
}
}
<connectionStrings>
<add name="portiEX.Properties.Settings.PortiEXDBsConnectionString"
connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\PortiEXDBs.mdf;Integrated Security=True;Connect Timeout=30"
providerName="System.Data.SqlClient" />
</connectionStrings>
@Edit After changing attach~~ to Database im getting error like that:
System.ArgumentException HResult=0x80070057 Message=Format ciągu inicjowania jest niezgodny ze specyfikacją, począwszy od indeksu 35. Source=System.Data StackTrace: at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue) at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value) at System.Data.Linq.SqlClient.SqlProvider.GetDatabaseName(String constr) at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Initialize(IDataServices dataServices, Object connection) at System.Data.Linq.DataContext.Init(Object connection, MappingSource mapping) at System.Data.Linq.DataContext..ctor(String fileOrServerOrConnection, MappingSource mapping) at portiEX.DataBaseConnectionsDataContext..ctor() in C:\Users\USER\Downloads\portiEXzDB(1)\portiEXzDB\portiEX\DataBaseConnections.designer.cs:line 54 at portiEX.LoggingPage..ctor() in C:\Users\USER\Downloads\portiEXzDB(1)\portiEXzDB\portiEX\LoggingPage.xaml.cs:line 23
This exception was originally thrown at this call stack: [External Code] portiEX.DataBaseConnectionsDataContext.DataBaseConnectionsDataContext() in DataBaseConnections.designer.cs portiEX.LoggingPage.LoggingPage() in LoggingPage.xaml.cs
User contributions licensed under CC BY-SA 3.0