Click here to Skip to main content
15,662,754 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL QUERY Pin
Trustapple14-Oct-07 17:51
Trustapple14-Oct-07 17:51 
GeneralRe: SQL QUERY Pin
Blue_Boy15-Oct-07 11:32
Blue_Boy15-Oct-07 11:32 
QuestionSetting PRIMARY KEY using Alter Table Pin
Widgets13-Oct-07 0:02
Widgets13-Oct-07 0:02 
AnswerRe: Setting PRIMARY KEY using Alter Table Pin
GuyThiebaut13-Oct-07 0:40
professionalGuyThiebaut13-Oct-07 0:40 
AnswerRe: Setting PRIMARY KEY using Alter Table Pin
Mike Dimmick13-Oct-07 2:24
Mike Dimmick13-Oct-07 2:24 
GeneralRe: Setting PRIMARY KEY using Alter Table Pin
Widgets21-Oct-07 0:03
Widgets21-Oct-07 0:03 
QuestionDataGridView Filter Pin
udikantz12-Oct-07 22:13
udikantz12-Oct-07 22:13 
AnswerRe: DataGridView Filter Pin
GuyThiebaut12-Oct-07 22:35
professionalGuyThiebaut12-Oct-07 22:35 
What I suggest is that you create a dataview based on your datatable.
Bind this dataview to your datagrid.
You can then filter, sort etc on the dataview without changing the contents or base data in your datatable.

Below is an example in VB .NET on how I have filtered and sorted using a dataview:

<br />
dvFileList = New DataView(tblFileList)<br />
dvFileList.Sort = "bytes desc"<br />
filter = "filetype = '" & DataGrid1.Item(DataGrid1.CurrentCell) & "'"<br />
dvFileList.RowFilter = filter<br />
DataGrid1.DataSource = dvFileList<br />


You always pass failure on the way to success.

GeneralRe: DataGridView Filter Pin
udikantz12-Oct-07 22:37
udikantz12-Oct-07 22:37 
QuestionSSRS embedded code and dynamic columns Pin
dove1112-Oct-07 9:08
dove1112-Oct-07 9:08 
AnswerRe: SSRS embedded code and dynamic columns [modified] Pin
pmarfleet12-Oct-07 9:53
pmarfleet12-Oct-07 9:53 
QuestionReg: SQL DB in Emergency Mode [modified] Very Urgent Pin
P.T.R.K12-Oct-07 7:20
P.T.R.K12-Oct-07 7:20 
AnswerRe: Reg: SQL DB in Emergency Mode [modified] Very Urgent Pin
Skanless12-Oct-07 8:49
Skanless12-Oct-07 8:49 
QuestionDynamic database pathways... Pin
new_phoenix12-Oct-07 6:59
new_phoenix12-Oct-07 6:59 
AnswerRe: Dynamic database pathways... Pin
Hesham Amin12-Oct-07 8:46
Hesham Amin12-Oct-07 8:46 
GeneralRe: Dynamic database pathways... Pin
new_phoenix15-Oct-07 10:41
new_phoenix15-Oct-07 10:41 
QuestionSQL statement on website, global password Pin
Cory Kimble12-Oct-07 6:57
Cory Kimble12-Oct-07 6:57 
AnswerRe: SQL statement on website, global password Pin
andyharman12-Oct-07 8:18
professionalandyharman12-Oct-07 8:18 
GeneralRe: SQL statement on website, global password Pin
Cory Kimble15-Oct-07 4:21
Cory Kimble15-Oct-07 4:21 
GeneralRe: SQL statement on website, global password Pin
andyharman15-Oct-07 8:29
professionalandyharman15-Oct-07 8:29 
Questiona problem about stackoverflow Pin
nibabug12-Oct-07 3:27
nibabug12-Oct-07 3:27 
AnswerRe: a problem about stackoverflow Pin
Pete O'Hanlon12-Oct-07 4:44
subeditorPete O'Hanlon12-Oct-07 4:44 
GeneralRe: a problem about stackoverflow Pin
nibabug12-Oct-07 15:26
nibabug12-Oct-07 15:26 
GeneralRe: a problem about stackoverflow Pin
nibabug12-Oct-07 15:36
nibabug12-Oct-07 15:36 
QuestionChecking Duplicate values in Database Pin
codingrocks12-Oct-07 2:25
codingrocks12-Oct-07 2:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.