- This is my add function to try to add new component with a combo box but it always fail because can't get data in cbbDivision,
private bool save()
{
try
{
if (txtMoney != null && txtSubject != null && txtMemo1 != null
&& txtTitle != null && txtAmount != null && txtMemo2 != null)
{
DateTime date;
string division = "";
float money;
string subject = "";
string memo1 = "";
string title = "";
int amount;
string memo2 = "";
date = DateTime.Parse(dtDate.Value.ToString());
division = cbbDivision.Text.ToString();
money = float.Parse(txtMoney.Text.ToString());
subject = txtSubject.Text.ToString();
memo1 = txtMemo1.Text.ToString();
title = txtTitle.Text.ToString();
amount = Int32.Parse(txtAmount.Text.ToString());
memo2 = txtMemo2.Text.ToString();
HanbiDBDataContext db = new HanbiDBDataContext();
DataManage data = new DataManage();
data.Date = date;
data.divId = Int32.Parse(cbbDivision.GetItemText(cbbDivision.SelectedItem));
data.Money = money;
data.Subject = subject;
data.Memo1 = memo1;
data.Title = title;
data.Amount = amount;
data.Memo2 = memo2;
db.DataManages.InsertOnSubmit(data);
db.SubmitChanges();
XtraMessageBox.Show("Add Success!");
}
return true;
}
catch (Exception)
{
XtraMessageBox.Show("Please insert information!", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
}
- This is my DB:
CREATE TABLE DataManage
(
Id int primary key identity (1, 1),
[Date] datetime,
[Subject] varchar(200),
Title varchar(200),
[Money] float,
Memo1 varchar(200),
Memo2 varchar(200),
Amount int,
divId int foreign key references Division(dId)
)
CREATE TABLE Division
(
dId int primary key identity(1, 1),
dName varchar(10)
)
- I'm using LINQ to connect to database and show data by GridControl. And I get values of Division table by using dataBindingSource
private void AddNew_Load(object sender, EventArgs e)
{
HanbiDBDataContext db = new HanbiDBDataContext();
divisionBindingSource.DataSource = db.Divisions.ToList();
}
What I have tried:
I was tried to add new values in combo box by hand and test again but it still error. Some one can help me to solve it pls?