Re: Browse the directory system - Visual Basic Discussion Boards

First Prev Next

Re: Hashing

Dave Kreskowiak21-Feb-07 4:37

Dave Kreskowiak

21-Feb-07 4:37

Why? I'll give you a hint - it's an MD5 hash that is easily broken now-a-days. Other than that, I question the motivation behind asking such a question.

Dave Kreskowiak
Microsoft MVP - Visual Basic

difference between Datagrid & datagridview

priya_p23320-Feb-07 18:37

priya_p233

20-Feb-07 18:37

gud morning frends,
Will anyone tell me what is the difference between Datagrid & datagridview in VB.nNet.
Thanks for any help in advance

-Regards Priyanka.

I AM NOT THE BEST
BUT I AM NOT LIKE REST Wink | ;)

Re: difference between Datagrid & datagridview

sathesh pandian20-Feb-07 19:00

sathesh pandian

20-Feb-07 19:00

Differences Between the Windows Forms DataGridView and DataGrid Controls

The DataGridView control is a new control that replaces the DataGrid control. The DataGridView control provides numerous basic and advanced features that are missing in the DataGrid control. Additionally, the architecture of the DataGridView control makes it much easier to extend and customize than the DataGrid control.

The following table describes a few of the primary features available in the DataGridView control that are missing from the DataGrid control.

DataGridView control feature Description
Multiple column types
The DataGridView control provides more built-in column types than the DataGrid control. These column types meet the needs of most common scenarios, but are also easier to extend or replace than the column types in the DataGrid control. For more information, see Column Types in the Windows Forms DataGridView Control.

Multiple ways to display data
The DataGrid control is limited to displaying data from an external data source. The DataGridView control, however, can display unbound data stored in the control, data from a bound data source, or bound and unbound data together. You can also implement virtual mode in the DataGridView control to provide custom data management. For more information, see Data Display Modes in the Windows Forms DataGridView Control.

Multiple ways to customize the display of data
The DataGridView control provides many properties and events that enable you to specify how data is formatted and displayed. For example, you can change the appearance of cells, rows, and columns depending on the data they contain, or you can replace data of one data type with equivalent data of another type. For more information, see Data Formatting in the Windows Forms DataGridView Control.

Multiple options for changing cell, row, column, and header appearance and behavior
The DataGridView control enables you to work with individual grid components in numerous ways. For example, you can freeze rows and columns to prevent them from scrolling; hide rows, columns, and headers; change the way row, column, and header sizes are adjusted; change the way users make selections; and provide ToolTips and shortcut menus for individual cells, rows, and columns.

The DataGrid control is retained for backward compatibility and for special needs. For nearly all purposes, you should use the DataGridView control. The only feature that is available in the DataGrid control that is not available in the DataGridView control is the hierarchical display of information from two related tables in a single control. You must use two DataGridView controls to display information from two tables that are in a master/detail relationship.

Sathesh Pandian

Select Record Between 2 Dates

Kumaran21cen20-Feb-07 18:33

Kumaran21cen

20-Feb-07 18:33

Function SelectReportServiceAndDate(ByVal FromDt As Date, ByVal Todt As Date)
Try
'Myconnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=KanServicesDB.mdb;"
MyCommand.Connection = Myconnection
MyCommand.CommandText = "Select * from GKRST"
MyCommand.CommandType = CommandType.Text
MyDA.SelectCommand = MyCommand
MyDA.Fill(myDS, "GKRST1")
All.SetDataSource(myDS)
'All.RecordSelectionFormula = "{GKRST.Dttime}>=#" & Format(FromDt.Date, "mm/dd/yyyy") & "#"
All.RecordSelectionFormula = "{GKRST.DtTime}>=#" & Format(FromDt.Date, "M/dd/yyyy") & "# And {GKRST.DtTime}<=#" & Format(Todt.Date, "M/dd/yyyy") & "#"
'All.RecordSelectionFormula = "{GKRST.DtTime}>=#" & Now.AddDays(-1) & "# And {GKRST.DtTime}<=#" & Now & "#"
CrystalReportViewer1.ReportSource = All
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Function

Hi, I have a problem while selecting between two dates. In my database "Kanservices.mdb" have a Date Column like 'DtTime'. It has both date as well as time. The above code is select between two dates.Its not working properly. If i store the Date in the DtTime column its working. If i store Store Date&Time the problem occurs.

Plz give the solution.

Thanks & Regards
Kumaran

Re: Select Record Between 2 Dates

Dave Kreskowiak21-Feb-07 4:36

Dave Kreskowiak

21-Feb-07 4:36

Two words: "Parameterized Queries".

If you try and concatenate strings together, like you are in this code, you have to worry about putting the strings together with the correct date format. Using parameterized queries, the Parameters objects take care of that for you! You don't have to worry about getting the format right!

You can find out more about them in Colin's article SQL Injection Attacks and Some Tips on How to Prevent Them[^].

Dave Kreskowiak
Microsoft MVP - Visual Basic

Browse the directory system

ArchaBhandare20-Feb-07 18:00

ArchaBhandare

20-Feb-07 18:00

Hello,

I need help in my VB application.
I have a 'Browse' button in my application's properties page, which should help me to browse through the directory system to choose a directory to save the xml files into.
How to I get the directory system when I click on browse.

In C# we have the 'FolderBrowserDialog' , do we have something like that in VB.

Also how do I save files into the directory choosen by 'browse'