there are two combobox cm1 and cm2 when user select columns from database for x axis and y axis in cm1 and cm2 the graph show the data from those columns .
Need your help that how to populate combos with column names and to show the graph of selected columns.
satti 7 Light Poster
Recommended Answers
Jump to PostHi,
Try something like this:Sub PopulateComboWithFieldNames(byref TableName as string, byref Combo as ComboBox, ByVal connection As SqlConnection) Dim cmd as new SQLCommand Dim reader As SqlDataReader cmd.Connection = connection 'I'd recommend using a stored Procedure with TableName passed as parameter 'But for sake of clarity I'll …
Jump to PostHi,
What is MyRead? a Dataset? an adaptor? a Reader? some sort of data layer class?I don't think you need the brackets around the
information_schema.columns
in your query, I tried it on SQL 2008 R2 and got a syntax error.Your results will bring back a lot of …
All 6 Replies
G_Waddell 131 Posting Whiz in Training
satti 7 Light Poster
G_Waddell 131 Posting Whiz in Training
satti 7 Light Poster
satti 7 Light Poster
ryanjayson -4 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.