Visual Basic

Re: How to run Windows Explorer from an application

4-Feb-07 0:55

TJO1 wrote:
apologise if it is trivial.

Nothing is trivial, until you know how to do it Smile | :)

Process.Start("c:\") should, I believe, open explorer at the c drive.

I think it's in System.Threading.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

TJO15-Feb-07 0:14

TJO1

5-Feb-07 0:14

Christian Graus wrote:
Process.Start("c:\") should, I believe, open explorer at the c drive.

Thanks very much Christian. You are spot on.

I doubt if I would have found this in a month of Sundays.

Cheers
Tim

Search Data Grid

aslamshaikh044-Feb-07 0:44

4-Feb-07 0:44

i am using VB.net for the first time on a data project. I have used the built in functions to put data in a DataGrid. Now what I need to know how to do is when user types in a text box use that to narrow results.

Any examples or help is appreciated.

Re: Search Data Grid

Christian Graus4-Feb-07 0:54

Choosing specific folders to Delete

4-Feb-07 0:54

http://www.codeproject.com/cs/database/gridex.asp[^] would probably contain all the example code you could hope for.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

charchabil034-Feb-07 0:43

selecting values in datagrid & getting it into textbox

4-Feb-07 0:43

Hello guys
help with following

having a folder ,containing many subfolders with the following names
folder 1 :2007-1-30
Folder 2 :2007-2-1
folder .....
how can write a function to let the user : specifies which subfolders to delete
i mean :if the user wants to delete everything with the name before:2007-2-20
algorithm: after choosing a date from the calendar ,delete all the subfolders where their name are inferior from the chosen date

what about the following code.what should i add to it

Dim mydate As String, mymonth As String, myyear As String<br />
        mydate = Me.DateTimePicker1.Value.Day.ToString<br />
        mymonth = Me.DateTimePicker1.Value.Month.ToString()<br />
        myyear = Me.DateTimePicker1.Value.Year.ToString<br />
        Dim dir_info As New DirectoryInfo(Path)<br />
        dir_info.Delete(True)

Regards,

Regards
Ramy

swetachotalia4-Feb-07 0:16

swetachotalia

4-Feb-07 0:16

Hi,
I have to select the value in datagrid and get that selected value in textboxes and update and delete the values from the textboxes.Please tell me how can i do this in vb.net 2003.

Re: selecting values in datagrid & getting it into textbox

Christian Graus4-Feb-07 0:25

Re: selecting values in datagrid & getting it into textbox

4-Feb-07 0:25

How do you mean 'select the value'. You want to search for a value ?

You want to update and delete what ? The grid, or the data source ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

aslamshaikh044-Feb-07 0:41

Re: selecting values in datagrid & getting it into textbox

4-Feb-07 0:41

hi i would appreciate it if you could show me how to search for a value within the datagrid as i am really stuck on my final year project.

thanx in advance

Christian Graus4-Feb-07 0:52

Re: selecting values in datagrid & getting it into textbox

4-Feb-07 0:52

http://www.codeproject.com/cs/database/gridex.asp[^] looks helpful. You could either use the control, or look through the code to see how it works.

Depending on your datasource, you may be able to run SQL on the source, or you can iterate over the Rows collection to find the values you need.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

aslamshaikh044-Feb-07 2:08

Re: selecting values in datagrid & getting it into textbox

4-Feb-07 2:08

hi thanx for the link...i had a look it seems to be done in C. I have done it in vb code. i used the wizard to create the forms. Using a untyped dataset i think. all the search code ive found is for typed datasets i think...

Me.objdsDiary.Clear()
Me.OleDbDataAdapter1.SelectCommand.CommandText = "Select * from 0830 where AppointmentDate like '%" & Trim(Me.lbl2.Text) & "%'"
Me.OleDbDataAdapter1.Fill(Me.objdsDiary)

or

Adodc1.RecordSource = "Select * from secretary where club = """ & txtSearch.Text & """"
Adodc1.Refresh

or

Private Sub Command1_Click()
With Adodc1
.Recordset.Find "Au_Id=" & CInt(txtAuthorId.Text)
End With
End Sub

which do not work as i dont have adodc, all i have is CottageBookingSystemDataSet, TblEmployeeBindingSource, TblEmployeeTableAdapter, TblEmployeeBindingNavigator.

Ive been looking on so many forums.

aslamshaikh044-Feb-07 2:17

4-Feb-07 2:17

i have found the code to search using a string,

TblCustomerBindingSource.Filter = "txtFirstName LIKE '%" & TextBox1.Text & "%'"

how to i implement it to search a int eg the primary key for customerid?

Textfile connection

Socheat.Net3-Feb-07 22:32

Socheat.Net

3-Feb-07 22:32

I have used Testfile connection with my application, but i don't know how to use sql statement.

Thanks

................

Christian Graus3-Feb-07 23:25

3-Feb-07 23:25

You don't know how SQL works ? It's pretty simple, and there are tons of examples on the web. At it's most basic level, select * from [tablename] will return all the data in a table, and select 8 from [tablename] where [column] = [value] ( with single quotes around strings ) will select a particular value.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Socheat.Net5-Feb-07 22:45

Socheat.Net

5-Feb-07 22:45

What is [tablename] i don't understand wheter i used text file.?

................

Christian Graus5-Feb-07 23:43

5-Feb-07 23:43

OK, you're connecting to a text file ? What does that have to do with SQL ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Socheat.Net7-Feb-07 23:00

Socheat.Net

7-Feb-07 23:00

I don't know how to use SQL statment and fill data to dataset

Thanks

................

Christian Graus7-Feb-07 23:22

7-Feb-07 23:22

From a textfile ? Is that even possible ? Your textfile doesn't have any named columns, if some sort of reading of textfiles is possible, I doubt it's using SQL.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

delete folder

charchabil033-Feb-07 22:03

3-Feb-07 22:03

hello
how can i delete subfolders within a folder
----

Regards
Ramy

Re: delete folder

Christian Graus3-Feb-07 23:26

3-Feb-07 23:26

The same way you delete a folder, one at a time. YOu need to iterate over sub files and folders before you can delete a folder.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: delete folder

charchabil034-Feb-07 0:36

4-Feb-07 0:36

thx

Regards
Ramy

Re: delete folder

charchabil034-Feb-07 1:09

4-Feb-07 1:09

test to my mail

Regards
Ramy

How can i Unzip..?

fmlove3-Feb-07 21:44

fmlove

3-Feb-07 21:44

How can i Unzip the zip files using vb.net code...

Feroze

Re: How can i Unzip..?

Christian Graus3-Feb-07 23:26

3-Feb-07 23:26

I think VB2005 has a zip library, any other version, you need an external library

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: How can i Unzip..?

charchabil034-Feb-07 3:34