Freelancer

Description

<<<< 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 System.Data.SqlClient.SqlDataAdapter
Public sql_command As System.Data.SqlClient.SqlCommand
Public sql_connection As System.Data.SqlClient.SqlConnection

**** (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)