Käynnissä

Visual Basic Script Needed

<<<< I just need script for this project.>>>>

'Sql Connections

**** (connection_string) is the variable where the db is located (db type is *.mdf)

'Common Variable declaration for database connection elements Adaptor ,Command and Connection.

Public sql_data_adapter As [url removed, login to view]

Public sql_command As [url removed, login to view]

Public sql_connection As [url removed, login to view]

**** (Query) is the public variable for all sql queries. Example: Query =""

**** LoadTables(name of combo box"TableNames_Cmbo") is used to populate combo boxes with table data

Form1 Properties:

1. Delete_Table_btn: a button that deletes the whole table selected in the combo box.

TablesNames_Cmbo: a combo box that selects available tables(I already have script for this)

2. DataGridView_Table: a DataGridView object that allows you to view the table data that is selected in the TableNames_Cmbo.

3. FileNames_Cmbo: a combo box that would select available files (I need script for this) That are already created in the standard Bin file location.

4. TextBox or RichTextBox to automatically view the combo box selected txt file.

5. Four Buttons: View, Edit, Delete, Clear that will allow a person to view,edit or clear the properites of a text file selected by means of the text box. Additionally the delete button to remove the selected text file perminantly.

6. Populate_Table_btn: a button that takes the combo box-selected text file and posts the data from the text file into the combo box-selected table. Use Table1 as table name. col1 varchar(10),col2 varchar(4), col3 varchar(2)

Taidot: Visual Basic

Näytä lisää: common query, visual basic script populate database, populate combobox text file visual basic, script sqlclient, visual basic payroll system, delete button, visual basic edit, sql script , remove object, edit bin file, data visual, view posts, sql table remove, sql view table, remove script, table queries, view script, script box, datagridview example, object files, example visual basic, mdf sql script, bin file, script sql table, sql datagridview

About the Employer:
( 12 reviews ) Carlsbad, United States

Projektin tunnus: #424017