|
hi pmarfleet
Thanks for your reply
There is a website that we look at to retrieve information, but now its time consuming to do the copy and paste, we were thinking of writting a Program that will extract that info and put it in a SQl table for us.
How can we achieve this?
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
I've suggested ways that you could do this. I'm not going to do your work for you. Look at how the HTML markup is constructed and then research and write a regular expression to extract the information you want.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Greetings
I have written an insert routine that has the text boxes and a grid with populated with the target "insert" table on the same form.
I am using data bindings:
txtLastName.DataBindings.Add("Text",dsMusicStore, "Customers.LastName")<br />
txtFirstName.DataBindings.Add("Text", dsMusicStore, "Customers.firstName")
Code for the insert
Dim comBuilder As New OleDb.OleDbCommandBuilder(daCustomers)<br />
Dim dsNewRow As DataRow<br />
dsNewRow = dsMusicStore.Tables("customers").NewRow<br />
dsNewRow.Item("FirstName") = txtFirstName.Text<br />
dsNewRow.Item("LastName") = txtLastName.Text<br />
dsMusicStore.Tables("customers").Rows.Add(dsNewRow)<br />
daCustomers.Update(dsMusicStore, "customers")<br />
grdCustomers.Update()<br />
Me.Refresh()
Problems:
1. When I start entering data into the textbox, the data overwrites data in the top line of the grid
2. When I save, the data in the first line is still overwritten and the new record falls to the bottom of the grid. If I close the form and reopen it, the data first line data has been restored and the new data takes its place on the grid in the proper position for the given index
How can I:
1. stop the first line on the grid from being overwrttien (short of unbinding the data
2. Update the data grid upon save so the record displays where it should (not at the bottom)
Just Do It
|
|
|
|
|
Hi all,
how to get the Full path of a Shared Network Folder.
i have a folder named DBBackup in Server Computer.
from Client computer the above path is \\Server\DBBackup.
Actually 'DBBackup' folder in D Drive of Server Computer.
i need to get this Path Like '\\Server\D\DBBackup' Or 'D:\DBBackup'.
can you give any valuable information about this.
By
George Garvasis
|
|
|
|
|
hi
When you are looking at the path of a shred folder on network it will not show on which drive is it located...
The path to the other systems will be shown as \\<system name="" system="" ip="">\<folder name="">
can u plz specify what exactly u want to do
|
|
|
|
|
Hi everyone,
In one of my project I have to work with embedded resources in VB.NET.
I have 2 Problems:
(1) In my project I have added a 5 MB movie file as a resource. Now I want to copy that one to localdisk "C:\sample.avi". I wrote the following code. But I don't know what to use in place of "x" where "x" is the path of the file to copy.
Any suggestions?
Code:
<br />
Imports System.Io<br />
<br />
Button1_click()<br />
File.copy("x","C:\sample.avi")<br />
End sub<br />
So in short I want to know what is the path of that file?
(2) How to do the same with more than one files. I want to copy them all (at least 6 files!) to localdisk. Can anyone suggest the code for it ? I will be helpful to me.
Thanks,
Dan
|
|
|
|
|
i am using .net 2005.i am doing project named as billing in vb.net 2005 windows application.i want to take printout of billing form.if i give 2 page continuosly printing,in first page correctly printed,in second page,the datas are printed at very top.i want to print in 2nd page same as 1st page.
-- modified at 5:58 Thursday 15th November, 2007
|
|
|
|
|
I want to know
how to entry data in data grid view.
And saving row by row.
|
|
|
|
|
Hi,
Please provide some more details about your requirements. Like
1. Do you want to enter data manually at run time or via code?
2. Where you want to save the data (in a database or a file)?
Looking forward to your inputs.
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
Hello,
I want to enter data manually at run time.
And save SQL 2005.
Thanks to your reply.
|
|
|
|
|
There is one datagrid and one textbox in my application.The datagrid is bound to the datatable.Now What I want is that when user navigate the datagrid it should show the value of datagrid first colum in textbox.
I am using the following line in the datagrid_navigate event.
textbox.text = datatable.rows(datagrid.currrowindx).item(0).tostring
But the problem is that Datagrid_Navigate event does not fire.
How I can fix this?
Thanks in advance
I am using datagrid in my application which is bound to datatable.
I am trying to use datagrid_navigate event but its not working.
Ejaz
|
|
|
|
|
Hii ,
1) How to create the no of rows ,columns at runtime by entering values of those properties (columns and rows) in propertygrid for datagridview .
2) I dont want to provide the user the facility to enter text in cells .How to disable entering text of all cells at runtime for datagridview ?
3) How can i give name for every column headerCells(which looks solid )at runtime (i.e, User cannot enter text TOP Column )for datagridview ?
4) How can i give name for every Row HeaderCells(which looks solid ) of datagridview without going into default cell while entering text ?
Actually my datagridview has to work like a flexgrid control of vb6.0
dvs
|
|
|
|
|
Hi...
I am sending you a sample code which lets you to add data at runtime... You can put all this code in a test application...
Take a form, Put a button on it and add a DataGridView. Name the DataGridView as dg and past all the following code in the form class
Inherits System.Windows.Forms.Form
Dim tab As New DataTable("MyTable")
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim row As DataRow
Dim colIdx, rowIdx As Integer
'Bind
dg.DataSource = tab
For colIdx = 1 To 5
tab.Columns.Add(CType(colIdx, String))
Next
For rowIdx = 1 To 35
row = tab.NewRow()
row("1") = CType(rowIdx, String)
row("2") = "Row two" & rowIdx
tab.Rows.Add(row)
Next
End Sub
Good luck... The code is simple and works
Regards
Nishkarsh
|
|
|
|
|
Hii
Thanks For replying ,
Actually ,I dont need to connect a datatable or something to show data .I have to work in this way .
There is a button on toolstrip .If user clicks it has to create an instance of datagridview it shows with default rows and columns .
Lets Consider 6 cols and 6 rows of DGV .Now ,
1) The cells has to disable without entering any information .
2) Whenever he click on top of Column ,he can write the column name or Row name at that time like this : sampleDatagridView . It has to work like FlexGrid or Excel or think a Calender .All this in design Mode
Emp Det|Jan| Feb| March |Apr |May ............<br />
<br />
ENo |<br />
<br />
Ename |<br />
<br />
Age |<br />
<br />
Salary |
In Edit Mode i can enter the values in cells without changing the column and row names
After
dvs
|
|
|
|
|
Hi
the example i had given also dose not take any data from DB, it creates 5 columns on run time with column headings as 1,2,3.....
Only thing i had done in there is added the columns i a loop....
After that i add some dummy data in 2 columns for each row..
For editable and non-editable part of the issue, you can keep on changing the properties when ever u want during the course of execution
|
|
|
|
|
Hi
I am using a DataGridView control..
Depending on the options selected by the user i have to send some data to a function..
My issue is that i am not able to set the active cell to where ever i want...
If the user clicks a cell then i am able to read data from only that cell..
Regards
Nishkarsh
|
|
|
|
|
Have you resolved your issue?
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
|
|
|
|
|
|
Cool. I dropped you a line the other day in case you didn't and needed help 
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
i 28 Users who use a Same Database Application. Well it does not happen all the time, but i have Concurency Problems. Sometimes there will be Concurency Violation.How can i deal with Concurency.
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
What database ?
Vuyiswamb wrote: Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
Wow - that sure is depressing.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi Chris
Dont start am not sad
you know what i mean the Table. i need to handle Concurency for 28 users. am thinking of using Threads, but whats you input?
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi all,
How would i go about inserting a breakpoint after each 500th character. You see, i have created a flat file using ssis. This packaged reads records from a database and writes it into a flatfile with fixed length. BUT the records do not get written underneath each other... The get written next to each other and this is then a problem when i need to write the final flat file (a combination of three flat files).
The records (read from the database [sql]) gets written like this:
Text Line1Text Line2Text Line3
I want it:
Text Line1<br />
Text Line2<br />
Text Line3
To do this (i think) i need to do something like this...
Read the text line from the datafile into a variable. (this is the text file with the datarecords next to each other)
Take the length of the variable and devide it by 500. (This is because each record / text line is only 500 characters long. This will then be stored in another variable called: Lines)
Then i do a for loop for each line, taking the first 500 characters from the variable and writeln it into the text file. Now delete/remove the first 500 characters from the variable (as to not write them again) and do the same with the next 500 characters until the end of the Lines loop ended.
I dont know if this could be prevented (what i mean is: Can you tell the SSIS Flat File Destination control to write each record into a new line??) if NOT do you think my theory would work using vb.net code?
Thank you in advance.
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
|
|
|
|
|
Never Mind...
I figured it out.
I inserted a new breakpoint (using writeline) after every 500th character.
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
