I want to show column names of respective table into dropdownlist box. I am not getting how to write SQL query which gives column name in tabular format.
For example suppose there is one table book with attributes
title, author and publisher.
Then this attributes should be display in dropdownlist box.
rahul more
Last Activity: Sep 29 '11, 07:09 PM
Joined: Mar 1 '11
Location:
-
rahul more started a topic How to retrieve column name of table in SQL 2005 and display in dropdownlist in ASPin SQL ServerHow to retrieve column name of table in SQL 2005 and display in dropdownlist in ASP
-
rahul more started a topic accessing data from table error = no value given for one or more required parametersin Visual Basicaccessing data from table error = no value given for one or more required parameters
My aim is - Access data from table and show it into a form's textboxes , comboxes for edition of data.
I am using listview. I am selecting particular row of listview by clicking on that row and after clicking on toolbar's Button, I want that , the data of entire selected row should show in textbox and comboxes of form. I am doing this by calling a function "Editt()" at toolbar's button click event which are as follows : -
... -
rahul more started a topic How I store long date of datepicker control in access in the format-Friday,4 Februaryin Visual BasicHow I store long date of datepicker control in access in the format-Friday,4 February
I am using Datepicker control and I change the format to dtpLongDate, therefore the date is looking like - Friday, 04 February. I want to store this long date in Access 2007. And in Access 2007 I already changed the format of date column to Long Date. I write a code for that which as follws -
rs.Open "insert into Table1(#"& DatePicker1.Val ue &"#)", con, adOpenStatic, adLockPessimist ic
... -
rahul more started a topic Run-Time error -2147217900(80040e14) Syntax error in INSERT INTO statementin Visual BasicRun-Time error -2147217900(80040e14) Syntax error in INSERT INTO statement
Hiiii I am making my project in VB6.0 and my back end is Access 2003. I hav one problem.....
When I going to save data into database, at at cmdSave_Click event, VB giving me error(Error mentioned at heading)after clicking on SAVE button and Highlighting the statement which are as follows.....
rs.Open "Insert into addclasses (Batch, BatchTime, Std, CollYear, SchlBtchName, CollBtchName, BatchType, SchlSubjct ,CollSubjct,...Last edited by Niheel; Mar 1 '11, 04:04 PM.
No activity results to display
Leave a comment: