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
Nel
NA
716
1.1m
Connecting the combobox with a datatable
Aug 21 2011 12:30 PM
Hi,
I use ado.net commands not dataset to insert and modify data in my windows form. I have also a combobox which should contain values from another table (the primary key is in that table, but also the first table to which all other textboxes are connected contains one value as a foreign key from that table).
Could somebody help me how to connect the combobox as to be able to insert data in the first table (dokuments, which has currency field as a foreign field), choosing the value from the combobox which contains the data from the other table (Currency with currency field as a primary key)?
Thanks in advance.
Now I have this in my code for insertion:
bool result = false;
SqlConnection connection = null;
try
{
connection = GetConnection();
connection.Open();
SqlCommand command = new SqlCommand("vnesiDok", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@vp", dokument.vp);
//Here I should insert the value "valutaid" from the combobox as well
command.Parameters.AddWithValue("@valutakurs", dokument.valutakurs);
command.Parameters.AddWithValue("@imeprezime", dokument.imeprezime);
command.Parameters.AddWithValue("@iznos", dokument.iznos);
command.Parameters.AddWithValue("@iznosden", dokument.iznosden);
command.Parameters.AddWithValue("@br_kas_izvod", dokument.br_kas_izvod);
command.Parameters.AddWithValue("@br_patna_ska", dokument.br_patna_ska);
command.Parameters.AddWithValue("@tip", dokument.tip);
command.Parameters.AddWithValue("@data", dokument.datum);
SqlParameter brdokParam = new SqlParameter(
"@brdok", SqlDbType.Int);
brdokParam.Direction = ParameterDirection.Output;
command.Parameters.Add(brdokParam);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected == 1)
{
dokument.brdok = (int)command.Parameters["@brdok"].Value;
result = true;
}
}
Or I must use dataset?
Reply
Answers (
4
)
How to create stored procedure with parameter in sql server database
When we use trigger in SQL Server