Peruttu

VB Table and File Manipulation

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

Some script:

(I have not been able to create a query to drop a table. This is what I have been trying to get to work.)

'Private Sub Delete_Table_btn_Click(ByVal sender As [url removed, login to view], ByVal e As [url removed, login to view]) Handles

'[url removed, login to view]

' If [url removed, login to view] <> -1 Then

' Query = "DROP Table " & [url removed, login to view] '<<< this needs to be changed to a string to run properly.

'sql_command = New [url removed, login to view](Query, sql_connection)

' Try

' If [url removed, login to view] = [url removed, login to view] Then

' [url removed, login to view]()

' End If

' Catch ex As Exception

' MsgBox("Unable to connect to database", [url removed, login to view], "DB Connection failed")

' [url removed, login to view]()

' End Try

'End If

'End Sub

Taidot: Visual Basic

Näytä lisää: vb work, vb this, string standard, standard string, common string, common query, clear string, e vb, table, remove object, query table, manipulation, edit bin file, drop catch, click view, text manipulation, view posts, sql table remove, sql view table, script sender, table queries, system data file, datagridview example, text table, text sender

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

Projektin tunnus: #422761

17 freelanceria on tarjonnut keskimäärin 78 $ tähän työhön

rajtuhin1

DONT WASTE A SINGLE DOLLAR, HERE YOU GET BEST SOFTWARE ENGINEER WITH BEST PRICE. HAVE IT DONE WITHIN 1 HOUR. WILLING TO START NOW, SO BIDDING ON MINIMUM PRICE. THANKS AND REGARDS : TUHIN

30 $ USD 0 päivässä
(56 arvostelua)
6.1
MAnkita

Hello,Please refer your PMB.Thank you.

100 $ USD 2 päivässä
(34 arvostelua)
5.2
consus

Hello Sir Please Check PMB for bid detail. Thanks

60 $ USD 1 päivässä
(7 arvostelua)
4.7
KellogITSolution

Hello Please see your PMB for details. Thanks

110 $ USD 0 päivässä
(12 arvostelua)
4.3
shmai

have a glance at PM. Regards,

96 $ USD 2 päivässä
(6 arvostelua)
3.9
rhussain

lets start thnx n rgrds

50 $ USD 0 päivässä
(1 arvostelu)
1.6
ExtraNet

Hi MySmallBiz, please see PM

30 $ USD 0 päivässä
(1 arvostelu)
1.4
seriallink

Please, check you PMB for detail.

40 $ USD 2 päivässä
(0 arvostelua)
0.0
madhavinagendra

hi, I have 9+experience in database and vb.i am ready to start,deliver in time.give me a chance. thanks, madhavinagendra.

60 $ USD 1 päivässä
(0 arvostelua)
0.0
sgnkar

Hi I am interested on this applicaiton Thanks

190 $ USD 2 päivässä
(1 arvostelu)
0.0
raj321

hi , please check pm thanks

50 $ USD 0 päivässä
(0 arvostelua)
0.0
abhipsb

Hi, Please see PMB. Regards Abhi

30 $ USD 0 päivässä
(0 arvostelua)
2.0
ReachCRM

Hi, I can complete this project perfectly for you within 2 days. Please reply. regards, John

100 $ USD 2 päivässä
(0 arvostelua)
2.8
yashiscool

We have no issues doing this job for you.

50 $ USD 2 päivässä
(0 arvostelua)
0.0
MACS

I can do this for you. I can help with the drop table situation you mentioned as well.

105 $ USD 8 päivässä
(0 arvostelua)
0.0
mpatram

hello, i have got 5+yrs of expertise to do you job successfully.

100 $ USD 2 päivässä
(0 arvostelua)
0.0
zoxno6

I'm VB/SQL expert.

120 $ USD 3 päivässä
(0 arvostelua)
0.0