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, string manipulation c, standard string, open-table, common string, common query, clear a string in c, e vb, delete button, Data e try, table, remove object, query table, open file, manipulation, edit bin file, drop catch, click and view, text manipulation, view posts, sql table remove, sql view table, script sender

Tietoa työnantajasta:
( 12 arvostelua ) Carlsbad, United States

Projektin tunnus: #422761

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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 [login to view URL] 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 [login to view URL] 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