Insert Long Text In Data Base
Friends,
Please, somebody help me!!! I trying to insert a long text (360 pages of MS-WORD) into Data Base of SQL SERVER 2000. I'm using the command and the fields in SQL SERVER is Text.
How can I do this?
Tks,
Eduardo - TI Manager
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Insert Long Text In Data Base
Friends,
Please, somebody help me!!! I trying to insert a long text (360 pages of MS-WORD) into Data Base of SQL SERVER 2000. I'm using the command and the fields in SQL SERVER is Text.
How can I do this?
Tks,
Eduardo - TI Manager
Insert Record Form Local Data Base To Remote Dat Base
I want to update a Remote database data to locl database data through my Pc but i want to use it in asp in in VB i create a connect
i write a code but its not working
<%
set conLocal = server.createObject("adodb.connection")
set conRemote = server.createObject("adodb.connection")
set rsLocal = server.createObject("adodb.Recordset")
set rsRemote = server.createObject("adodb.Recordset")
path = server.mappath("./../")
pathLocal = path & "dbdb1.mdb"
pathRemote = path & "database.mdb"
conLocal.open "Provider=Microsoft.Jet.OLEDB.4.0;Data source='"& pathLocal &"' ; Persist Security Info=False"
conRemote.open "Provider=MS Remote; Remote Server=http://myUrl.com; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source='"& pathRemote &"'"
Edited by - r_bilgrami on 10/5/2003 11:32:38 PM
Insert Records In Oracle Data Base
i want to insert date into oracle data base using VB source code with DSN.and also How to Configure the DSN through oracle.can i send the date type in this format DD/MM/YYYYY.
Insert Data Into A Accees Data Base
how can i insert data into a access database .
ie defining the connections and the query???
when opportunities arises ,only the prepared mind is fovoured
Insert Cell Row To Accommodate Long Text
In my spreadsheet's table, the text length in col 5 could be longer than the actual col width, causing the complete text content cannot be displayed. I compare the length of maxtextlength and colwidth, and if the text length is detected longer than the col width, have the row added to accommodate full text length. But when the row is added, how to shift the remaining text to one row below?
Dim m As Integer
Dim j As Integer
m = 0: cell.Row = m_currentrow: m = cell.MaxTextColWidth(5)
j = 0: cell.Row = m_currentrow: cell.Col = 5: j = cell.ColWidth(5)
If m > j Then
Call cell.InsertRows(m_currentrow + 1, 1)
End If
[Oracle][ODBC][Ora]ORA-01461: Cannot Bind A LONG Value For Insert Into A Long Column
Using the Oracle in OraHome92 version 9.002 ODBC driver in visua basic I receive the message "[Oracle][ODBC][Ora]ORA-01461 cannot bind a LONG value for insert into a long column" whe updating a large table a table with 59 columns. The proble seems to be related the number of columns being updated or th size of the data. I am using a recordset object to perform th update. If I limit the number of columns I update, the updat works successfully. On smaller tables, the update work successfully.
Loading Names Of Files Into A Data Base Or Text File
I need to put to gether a program for mangeing data at work. I need to know how to look in a directory and load the names of the files in it to either text file or preferbly a data base file. I need the code and explicet instructions on how to use the code(I'm still trying to get used to VB)
Can You Mix Text And Data In Insert Into
this is my code and keep getting syntex error
Private Sub Command3_Click()
MyConn.Execute "INSERT INTO distance(place id,miles,yards)VALUES('" & Text6(1).Text & "'," & Text7(2).Text & "," & Text8(3).Text & ")"
End Sub
place id is text the other 2 are numbers
cheers
Doug
Insert Data Into Text File
Hi all,
I have a .txt file in which i have to insert data to a field and save it. The .txt file looks like
[Text 1]
text data = <<---- this is where i need to insert data from a text box.
can anyone help me with this.
thanks!!!
Insert Data From Text Box With Correct Value Type
I am trying to insert user input from textbox in vb.net into the database server and still not able to comply with the database (ms-sql) column's variable type.
Lets say text box called txtAmount will have amount of transaction entered and insert into the database column which has the variable set as money. So, to do so, I have to convert the text box value to decimal right? I did assigning the text box value to a decimal variable with CDec(txtamt.text)
But, it still can't work. It came out with error: Conversion from string to decimal is not correct. or something like cast from string to double is invalid.
Any way to do the input string correctly?
Below is the portion of the code:
Dim amt As Decimal
Dim bal As Decimal
Dim CID As Integer
CID = CInt(txtCID.Text) 'CID is Card ID
amt = CDec(txtAmt.Text) ' is the purchase amount
bal = CDec(txtBal.Text) ' is the balance
cmdCanteen.CommandType = CommandType.Text
cmdCanteen.CommandText = "INSERT INTO tblCanteen (CardID, Amount, Date, Balance) " + "VALUES ('" + CID + "', '" + amt + "', '" + App.CurrentDate + "' , '" + bal + "' ) "
cmdCanteen.Connection = Conn
and the value in database is:
CardID - BigINT - 8
Amount - Decimal - 8
Balance - Decimal - 8
Date - DateTime
Insert Data From A Text File To A Table
When i use the following insert statment it fails to open the text file, read the lines of data, then insert into my table. However when i hard code the data i.e.
'str_recordid = "test"
'str_acno = "test"
It works!!
What am i doing wrong?
xxG
'Open the database
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; " _
& "Data Source = c:windowsdesktop racking.mdb"
cn.Open
'Open the text file
Set ts = fso.OpenTextFile("c:windowsdesktop10010253136471.txt")
recordid = Mid(sStringToBreakDown, 1, 1)
acno = Mid(sStringToBreakDown, Len(recordid) + 1, 9)
'Open the table
rst.Open "SELECT * FROM tbl_headerrecord", cn, adOpenDynamic, adLockOptimistic
If rst.EOF Then
strsql = "INSERT INTO tbl_headerrecord (recordid,acno)" & _
"','" & "VALUES ('" & str_recordid & "','" & str_acno & "')"
Else
strsql = "UPDATE tbl_headerrecord SET recordid='" & str_recordid & "',acno='" & str_acno & "'"
End If
cn.Execute strsql
Insert Data From Text File To Database
Hi All,
I am working on Attendence module, I have a text file which consistof data which I want to insert into my database table attend_tbl
I have made 4 columns in my database as
Date | EmpNo | Time_In | Time_Out
now the text file I have which is attend.txt, it also shows data in 4colums having the same fields as made in my database table.
30/07/2004 000002 1030AM 1034PM
30/07/2004 000006 1016AM 0900PM
please guide me the way throguh which I can insert the record of textfile into database table in theire relevant columns
Please Help me with aforementioned query.
thanx.
Really Long INSERT
OK I have a HUGE Insert Statement (swear Im not bragging)
The table has, .........wait for it ........ 75 columns!
My problem is when VB breaks it up due to size how do I connect the different parts to make it one large coherent statement
e.g.
"INSERT INTO Table (M1,M2,M3....M25, N1,N2.....,N25, O1,O2,O3......O25)
VALUES ('" & varA1 "',varA2,....varA25,varB1,varB2,...varB25,
varC1,varC2....'" & varC25 & "')"
How do I join
INSERT INTO (......)
VALUES (........
..............)
Please Help, this is quite important
Insert Heading Or Text Onto Data Report Using Code?
Hi there,
I currently have the following code in a command button, which when clicked loads a data report:
VB Code:
Command1_Click()rorders.Open "SELECT * FROM OrderTable WHERE TheDate='" & lblTodaysDate & "'"Set DataReport1.DataSource = rordersDataReport1.Show
Is there a code that I can add to this so when clicked the data report displays a heading, or even some text? For example:
DataReport1.Display Heading "INVOICE"
The reason I ask is because I'm using the same data report template several times to display different things (using different command buttons) and would therefore like each to display a different heading.
Any pointers would be of great help!
Thanks ppl.
Insert Data In A Text File Created By Excel And Export Them All
Hi for all
This is very hard.
I want to insert into a text file create by Excel some information like name, address and so on.
The text file is saved and opened for data inserts.
The file is opened, excel´s macro waits 'till I save the file.
Then, it copy each line of the text file and put in a excel´s row.
Please HELP MEEEEEEE!!
Hughes for all
Alex
Problem With Long Insert Statement
Guys,
Though its somewhat simple problem i am stuck with it from ond and half days. I have to insert 55 values from a form to an access database. I created two strings and then joined them:
str4 = "insert into srx ename,email,cmpaddress,hmaddress,phhome,phwork,phm obile,dept,ssup,acadstatus,semester,year,major,awa rds,seminars,fcpr,afgp,afkb,afs,esa,esag,aceg,acep ,afaapt,ncsa,jsc,yc,ascm,afadvpt,aftrc,lgt,cprpr,c fa,aedess,lins,wsi,bbpt,lm,oadmin,linstr,wtrit,wtf rt,wprkt,stsc,cpo,padi,nadi,market,gd,pr,wpd) VALUES ('" + ename.Value + "','" + email.Value + "','" + cmpaddress.Value + "','" + hmaddress.Value + "','" + phhome.Value + "','" + phwork.Value + "','" + phmobile.Value + "','" + dept.Value + "','" + ssup.Value + "','" + acadstatus + "','" + semester.Value + "','" + year.Value + "','" + major.Value + "','" + awards.Value + "','" + seminars.Value + "','" + FCPR.Value + "','" + AFGP.Value + "','" + AFKB.Value + "','" + AFS.Value + "','" + ESA.Value + "','" + ESAG.Value + "','" + ACEG.Value + "','" + ACEP.Value + "','" + AFAAPT.Value + "','" + NCSA.Value + "','" + JSC.Value + "','" + YC.Value + "','" + ASCM.Value + "','" + AFADVPT.Value + "','" + AFTRC.Value + "' "
str5 = ",'" + LGT.Value + "','" + CPRPR.Value + "','" + CFA.Value + "','" + AEDESS.Value + "','" + LIns.Value + "','" + WSI.Value + "','" + BBPT.Value + "','" + Lm.Value + "','" + Oadmin.Value + "','" + LInstr.Value + "','" + WTRIT.Value + "','" + WTFRT.Value + "','" + WPRKT.Value + "','" + STSC.Value + "','" + CPO.Value + "','" + PADI.Value + "','" + NADI.Value + "','" + Market.Value + "','" + GD.Value + "','" + PR.Value + "','" + WPD.Value + "');"
str6 = str4 & str5
db.execute str6
I even displayed the whole query in message..its working absolutely fine.. i mean the syntax..i have checked it many times...just the values dont show up int the database
Any help from your side is most appreciated..Thanks in advance...
Vikrant
Extracting Data, Update And Replace Back Into Data Base
Hello all
It has been a while since I last looked at some VBA code so I am a little rusty, I was never that good to start of any way
Geof helped me out ages ago to copy a row of data from a worksheet in the same workbook using the "Find" function in Excel then pasting to a different worksheet using the code in Module "Reports_Function"
The code copy's the row to sheet "Copy Hidden" and from their I am populating "Sheet Userform", on this this the user can update the values. The new values are linked to sheet "Past hidden", so the data base can be updated.
I am trying to get the "FindValue" to auto populate, the value is located @ Past hidden $J$4". Then select and copy the range on "Past hidden". Find the corresponding "FoundValue" on the sheet "Master data", select the range then past the data back into the master data base.
In module "Up_Date_Master" I have tried to start some code to to the above but I am falling at the first hurdle to auto populate the FindValue.
Kind Regards
Tom
Edited by - Nozmo on 5/31/2007 1:50:41 AM
Creating A Data Base In A Program Then Writing Data To It.
I have 3 good VB books, each covers DB generation, and accessing a database for information.
None describes how to put the data there from a program in the first place.
I have a program the parses files orginally created by dumpsec.exe.
They are straight text files. Their purpose is to dump access control lists from NT member servers.
I have created a text output, then I use a excel macro to modify the data for a management reports.
I would like to create a access database file, then use a routine I purchased to display and then convert it to excell. It just looks more professional.
I am attaching my current code. The first half is creating the data base. This is where I want to go.
The second half is my current text file output that is then modified by a excel macro. I am including this as reference.
' ************************************
If chkGrpCFMReport = 1 Then 'call master reports sub
Dim NewDb As Database, NewWs As Workspace
Set NewWs = DBEngine.Workspaces(0)
'Set NewDb = NewWs.CreateDatabase(strReportLocation(0), dbLangGeneral)
Set NewDb = NewWs.CreateDatabase("c:dumpacl
eportsgrpcolmaster.mdb", dbLangGeneral)
Dim NewTbl As TableDef
Set NewTbl = NewDb.CreateTableDef("PrivGrpID")
NewTbl.ValidationRule = "PrivGrpID <> ' '"
NewTbl.ValidationText = "Field Cannot be Blank"
Dim F1 As Field, F2 As Field, F3 As Field ', F4 As Field, F5 As Field, F6 As Field, F7 As Field
' ************************************
' Specify filed Server, ID, Member, and Type as Create Field arguments
Set F1 = NewTbl.CreateField("ServerName", dbText, 16)
Set F2 = NewTbl.CreateField("Group", dbText, 40)
Set F3 = NewTbl.CreateField("Member", dbText, 30)
'Set F4 = NewTbl.CreateField("Comment", dbText, 21)
'Set F5 = NewTbl.CreateField("MemberType", dbText, 15)
'Set F6 = NewTbl.CreateField("Approver", dbText, 15)
'Set F7 = NewTbl.CreateField("Keep", dbText, 4)
'Set F8 = NewTbl.CreateField("Removed", dbText, 4)
' append the fields into the database
NewTbl.Fields.Append F1
NewTbl.Fields.Append F2
NewTbl.Fields.Append F3
'NewTbl.Fields.Append F4
' NewTbl.Fields.Append F5
' NewTbl.Fields.Append F6
'NewTbl.Fields.Append F7
' set all fields to allow variable length
F1.Attributes = dbVariableField
F2.Attributes = dbVariableField
F3.Attributes = dbVariableField
'F4.Attributes = dbVariableField
'F5.Attributes = dbVariableField
'F6.Attributes = dbVariableField
'F7.Attributes = dbVariableField
F1.Attributes = AllowZeroLength
F2.Attributes = AllowZeroLength
F3.Attributes = AllowZeroLength
'F4.Attributes = AllowZeroLength
'F5.Attributes = AllowZeroLength
'F6.Attributes = AllowZeroLength
'F7.Attributes = AllowZeroLength
' append to database
NewDb.TableDefs.Append NewTbl
NewDb.Close
End If
ctrReportLines = 0
' ************************************
If chkGrpCFMReport = 1 Then 'call master reports sub
'Close #5
Open strReportLocation(0) For Append As #5
' Open "c:dumpaclgroupmaster.txt" For Append As #5
Print #5, " "
Print #5, " "
Print #5, strdfdir
Print #5, " "
'Print #5, strDatesDir
Do Until lngMasterGroups = ctrReportLines
If Mid$(strMasterGroups(ctrReportLines), 1, 1) <> " " And ctrReportLines > 2 Then
strMasterGroupsTempHeader = strMasterGroups(ctrReportLines)
If Not Err = 0 Then
MsgBox Err & " error"
Err = 0
'Exit Do
End If
Print #5, " "
Print #5, ", " & strMasterGroupsTempHeader
lstresults.AddItem " "
lstresults.AddItem Trim(strMasterGroupsTempHeader)
' MsgBox strReportLocation(0)
End If
If Mid$(strMasterGroups(ctrReportLines), 1, 1) = " " And ctrReportLines > 2 Then
Print #5, ", , " & strMasterGroups(ctrReportLines)
lstresults.AddItem Trim(strMasterGroups(ctrReportLines))
End If
ctrReportLines = ctrReportLines + 1
' Call GroupColumnMasterReport
Loop
Close #5
How Can I Filter Data Wich Not In Data Base
please help me how to filter my data
i have student data like student 1 until student 20
and other data (data 2 ) is student who take 1 study like math
so if the student whi dont take math do not appear int data 2 right?
how can i list student who take math? how i type the cod e to do that?
Data Base
Let Me Ask A dumb Question.
Do you have to create a database using excel or Dbase or SQl before you can access it in Vb or am I in left Field.
I Now use fields to store records I think that I could do alot better with database would make sorting alot faster.
Don
Quote:
OLD Dos Programmer
Need Help With A Data Base
I am running out of time to write this post right now but here is some info about my problem. I am writing a program that displays information from an MS access database (DAO) in textboxes. Here is the code so far:
Private Sub MnuOpenDatabase_Click()
CommonDialog1.Flags = cdlOFNHideReadOnly
CommonDialog1.Filter = "DataBase Files(*.mdb)|*.mdb|Text Files (*.txt)|*.txt|All Files (*.*)|*.*"
CommonDialog1.InitDir = "C:My Documents"
CommonDialog1.ShowOpen
Dim table1index As Integer
Dim table2index As Integer
If CommonDialog1.FileName <> "" Then
Set db = _
DBEngine.Workspaces(0).OpenDatabase(CommonDialog1.FileName)
table1index = 0
While (db.TableDefs(table1index).Attributes And dbSystemObject)
table1index = table1index + 1
Wend
Set dbrecordset = db.OpenRecordset(db.TableDefs(table1index).Name, dbOpenTable)
Set td = db.TableDefs(table1index)
Text1.Text = dbrecordset.Fields(0)
Text2.Text = dbrecordset.Fields(1)
Text3.Text = dbrecordset.Fields(2)
Text4.Text = dbrecordset.Fields(3)
End If
End Sub
I can see the information for the first person on my database, but I was wondering how to display the information for the second person on my data base
Help With Data Base
Hi
i am a newbi to VB i have no programming expirance and i have ran in to a little problem, for my VB class (1st yr) i need to make a database in which i can add, manage and remove customers i have asked about and i found out i need MS Access to make the database but i have no idea how to use this in VB, i made a table and search quiary but i found that hard as well i dont even know if i did it right but what i really need to know is how to make a data base in VB which i can add, manage and remove customers within if someone could help me out please
Vbs Data Base...
hi guys! thus the connection of database in [vb] is similar to [vbs]?
VB + Data Base + WEB = ?
Hi Friends,
Is it possible to use VB over WEb with back end of SQL/Access Data Base?
If so, How to do that, can any one give outline for that ? (No need for full explanation - just need concept)
Thanks,
Saravanan.M
Data Base?
i want a button when i press it it ask for new username and password u put the password in and the user name after i press ok it saves the recored and next time open the program it remmbers the user name and password in the records so its bassicly log in thinging which i can use to register accounts and then use the existing user name pass to log in...... how can i do that so it save my records....? help plox
Help With Data Base
Hy. I want to make a program to store some informations like name, age, gender, etc. How to do this ? i need to use a data base? The informations will be save on local disk not on a server. I don`t know how to start with this .. if you have some tutorials ore examples how to start.. Thenx
Data Base
I want to connect my project with access data base I want to save something to the table and get some data from the table. What is the code for it? I want the international code which code use for great project. Could you please tell me details about it?
Thanks you
Rummy
Data Base
VB Code:
Dim newtable1 As New TableDef, fld1 As New DAO.Field, fld2 As New DAO.Fieldnewtable1.Name = "My table"fld1.Name = "Myfield1"fld2.Name = "Myfield2"fld1.Type = dbIntegerfld2.Type = dbTextnewtable1.Fields.Append fld1newtable1.Fields.Append fld2datStudent.Database.TableDefs.Append newtable1
Why doesn't this work and append a table
DB Data Base
i'm trying to make a DB for my cds
i need to store them like a tree
Types(of CD)
....|-CD#
.......|-CD Dir
...........|-CD memory
...........|-CD bio
I cant seem to find out how to do this with Microsoft Acces.
if you have Microsoft Acces could you wip up an eg. of what i'm trying to do
THanx
Data Base And DAO
Hi!
If I dont have the Microsoft DAO 3.51 Object Library control, is there another way that i can control my DB at runtime?
Thanks in advance!!
Data Base Help !
I am having a nightmare, i cant write to a database (access) and i am not understnding why ....
i have to write to an address / member file holding names and phone numbers and i cant write the new data to the file ??... any help would be Greatly appreciated !
i.e. i have 7 Txt Fields (id, Name, Phone......etc) and need them to be added to the database on click of 'save'.
i have all the txt boxes set up to link to the database columns but no luck with the Adodc1.Recordset.Update function because i'm not too sure how to use it
VB For Data Base
Please kindly tell me the easiest way to get the result of two fields from two different tables after deduction & put in a third table.
VB And Data Base
hi ,
i have two tables 'clientprofile' and 'service'. both are connected thru the clientcode
i have used 2 commands in DE where the 'client_ profile' is the parent command and the 'service' is the child command. Now i have used bookmark to get the data to the frontend using code
DataEnvironment1.rsclientprofile.Bookmark = uname_dcb.SelectedItem
for a single client if he goes for two different services the data is entered in this table(in the service table ).
in VB when i scoll thru the names of the clients all the fields of the parent and child command are got in the front end . Now the problem is when a client has two different services it doesnt show the other service but only shows 1 service of the many. how do i get the second record of the same client?
-Joyce
Data Base
I'm Starting a new data base would I be better doing it all from scratch or using an Access table to store the data?
I'll be putting in, and tracking between 4000 to 6000 files, files will consist of Name, Address, City, County, Ect also up to 10 contact dates.
using vb6 2000
Edited by Rock
Move the topic to the Vb & Databases
Thanks Jemand
Edited by - rock on 10/7/2006 8:04:22 PM
Data Base Help...
hi,
i would like to know what is the best way to check the existence of a certain table.....
i can catch an error message regarding to Open() function, but i'm looking for an other way , more appropriate one....
plz help
tnx
uzeb
Data Base Index
I`d like to know how to refer to a Data base Index from Visual Basic without make it from Access.
Thanks
Password Data Base
What i am trying to do is have a password database for my program, i am trying to have like a .txt file on the website: called [logins.txt]
Code:
Admin
Admin1
Admin2
Admin3
Admin4
Admin5
Admin6
and [passwords.txt]
Code:
Password
password1
password2
password3
password4
password5
password6
and i want the VB6 program to load in a listbox or a combo box the admin names then when they clikc on the name they can insert a password, if the password is one from the password.txt list then they can login
Thank you sorry if it is confuing
-ithug
Regarding Data Base Fields
Hai every body,
Can anybody help me how to check whether Visual Basic recordset field is a primary key or not in the database. I go through the methods and properties but i am confused with which property checks the field is primary key or not.
I try to get the recordset.fields(0).properties but i couldn't.
How to get the properties.
Thanks in Advance
Data Base READ ONLY????
OK, here is my problem:
I open database base.mdb ( dbBase = OpenDatabase(".../base.mdb"). Everything works fine. But when i put READ ONLY property on base.mdb (left click on base.mdb in windows explorer, and i put read only), i can't open database and it says error 3051 (i think this is the right number). How can i open databases that are read only?
How To Connect My Data Base
i have a case study in connection of data base i dont want to do how to connect to data base i hope you can help me[/font]
Data Base Creation
I'd like to know if its posssible to create a Data Base when the app is runned in the first time and then connect to that DB. It is possible also in a installation file put a Db in that, like you put the application. How to do it ?
Thanks.
Bruno Alves
Data Base Problem!! :o(
Hi!! I have a prob...
when I log in to the system, goes to look for the user name and the password and I can insert the records with no problem but when I want to back it up in an other folder I use this statement
Filesystem.copyFile "source path", "destiny path"
and it says that can not copy the file; and when I test the system without log in and without using the data base I can copy.
I donīt know if is because of the memory when the data base opens.
thanks for your helping
Data Base Problem
Hello.
I have a little problem and don't know how to make this work because I am a kind of newbie in VB.
anyway...I whant to make a connection to a database and when I press a button another form to be opened and in that form to have all "first name" from data base.And when I click to a name then the real data base to be opened.This becouse now if I press the buton I can see just the first name and all the data for that name (first registration) but I whant to see all the names that can be found in database.Maybe I whant information about the 9th person and right now I need to press "next" 8 times to see that person info.
understand what I whant to do ??
thanks
Data Base Format
hi
got a small problem with my database im trying to acess it through a vb prgram i wrote the problem is it does not recongnize the database format. I have download the mdac version 2.7 from the mircosoft website and added the reference to my program and still it doesn't seem to make a difference.
any help thanks
mystic
Book Data Base
I have been assigned a task to do. I was wondering if any of you could help me out with it. I would very much appreciate it. I have been a longtime reader, and a first time poster. Here are the guidelines. My post below shoes what I have so far. I pretty much need to do steps 2-7.
Specific tasks in the Book Information form are:
1.When the form is loaded, the text file csvBooks.txt is read and the book titles and the book formats will be displayed in the list box (just the book titles and the formats, not other information).
2.When the user clicks on a book title in the list box, the information related to the selected book will be placed in the text boxes and check box on the right hand side of the form. Note: You’ll need to read the data from csvBooks.txt into an array (or an arrayList) of books. A book will be represented by a “structure” of variables. Then as the user clicks on the book title in the list box, transfer the data from the array (or arrayList) to other controls on the form.
3.The user can then make changes to the book information (in the text boxes and/or check box).
4.After the user makes the changes, he/she can click on the Modify/Save button to have the changes saved onto the text file csvBooks.txt and the Book Information form will be closed.
5.If the user doesn’t want to save the changes to the data (or makes no changes), he/she can simply click the “Exit” button to close the program.
6.Set up the list box such that the user can click on only one book title at a time.
7.Arrange the tab order to make it convenient to go through the controls on your form when the user only uses a keyboard.
|
TRACKER
