TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Emm
NA
1
1.5k
Need Help with a simple data entry form using C#
Mar 11 2014 10:13 AM
Hi Guys,
I am busy teaching myself C#. I have gone the through all the console applications learning syntax and now I want to do a data entry form.
This is what I have done so far. I have a form that has a datagridview on it with textboxes for each item in the grid. I have the grid and the text boxes bound to a SQL database table and loaded as follows:
command =
new
SqlCommand
();
adapter =
new
SqlDataAdapter
();
dataset =
new
DataSet
();
bindingSource =
new
BindingSource
();
command.Connection = connection;
command.CommandText =
"SELECT * FROM customer"
;
adapter.SelectCommand = command;
try
{
adapter.Fill(dataset,
"customer"
);
bindingSource.DataSource = dataset;
bindingSource.DataMember =
"customer"
;
dgvCustomers.DataSource = bindingSource;
//txtCustNo.DataBindings.Add("Text", bindingSource.DataSource, "Customer.CustNo");
//txtName.DataBindings.Add("Text", dataset, "Customer.CustName");
txtCustNo.DataBindings.Add(
"Text"
, bindingSource.DataSource,
"Customer.CustNo"
);
txtName.DataBindings.Add(
"Text"
, bindingSource.DataSource,
"Customer.CustName"
);
txtEmail.DataBindings.Add(
"Text"
, bindingSource.DataSource,
"Customer.email"
);
txtTelNo.DataBindings.Add(
"Text"
, bindingSource.DataSource,
"Customer.TelNo"
);
cboGender.DataBindings.Add(
"Text"
, bindingSource.DataSource,
"Customer.Gender"
);
cboTerms.DataBindings.Add(
"Text"
, bindingSource.DataSource,
"Customer.PaymentTerm"
);
}
catch
(
SqlException
)
{
MessageBox
.Show(
"Error occured while connecting to database."
);
Application
.Exit();
}
To refresh the data when I select a record on the grid I use a currency Manager as follows.
CurrencyManager
cm = (
CurrencyManager
)
this
.BindingContext[dataset,
"Customer"
];
long
rowPosition = (
long
)cm.Position;
cm.Position = dgvCustomers.CurrentRow.Index;
What I would like to know is:
1) How do I use the currency manager of the binding source? As I have read using the CurrencyManager is an old way of doing it.
2) When I click on the add button I clear the textboxes of the data they have in. If I select Cancel but on I use the following but this does not restore the values to the textboxes and instead clears my grid.
bindingSource.CancelEdit();
bindingSource.ResetBindings(
false
);
What do I need to do.
Perhaps somebody has a simple data entry form with code they can refer me using datasource and bindingsource.
I know I can do this using "wizards" and so on. But I want to do it in code so I can understand how things work
Reply
Answers (
1
)
windows app
Foot Switch with Serial Port