hi everyone i have a couple of issues i hope to find a solution.
1.i have a data grid view with a couple of columns.the second column is a combo box whose item are names in a database, sql server 2005.i need a code that enables that when an item name is selected in column 2 drop down, the quantity of the item appears in column3, picked from the database.
2.How do you save contents of what you are going to put into the data grid, into a new table in the sql database.
Regards,
Elizabeth
Jump to Post1. Please show code
2. You mean the Insert Statement?
INSERT INTO tableName (Column1, Column2, Column3) VALUES (Data1, Data2, Data3)
1. Please show code
2. You mean the Insert Statement?
INSERT INTO tableName (Column1, Column2, Column3) VALUES (Data1, Data2, Data3)
just from a simple example....say you have a combo box column that you select your country from...e.g...Greece,Kenya,Russia,Brazil....and once a country is selected, the next column automatically shows the continent the country belongs to.i want the value of column 2 to be as a result of column 1.
SELECT WHERE Country = Combobox1.you will only get logic if you don't show code.
You are trying to Bypass the learning and just dive in. You should know some basics at least before proceeding like you have.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.