Snitz Forums 2000 - A little SQL problem

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Community Discussions (All other subjects)

A little SQL problem

New Topic

Reply to Topic

Printer Friendly

Author

Topic

thermal_seeker
Junior Member

United Kingdom
430 Posts

Posted - 19 February 2011 : 09:07:47

MS SQL 2005 DB
I have created a form that is partially filled by bringing in data from another table.

The Username dropdown decides which table the data should go into and the other dropdown boxes are the columns in that table. Obviously I cant have the columns named because when the username dropdown is changed the other dropdowns are re-populated with different data.

Is it possible to have the columns linked to the results of the dropdowm boxes??


 PiggieWeightsDataSource.InsertCommand = String.Format("INSERT INTO {0} (freddie, bertie, gertie) VALUES(@freddie, @bertie, @gertie)", UNDropDown.SelectedItem.Text)
        
      
        PiggieWeightsDataSource.InsertParameters.Add("freddie", P0TB.Text)
        PiggieWeightsDataSource.InsertParameters.Add("bertie", P1TB.Text)
        PiggieWeightsDataSource.InsertParameters.Add("gertie", P2TB.Text)

ie. "freddie" is the result of the selected text from dropdown box 2

bertie is the result of dropdown box 3

etc

Dave

No good at coding, but I can plough a field !!

ruirib
Snitz Forums Admin