Click here to Skip to main content
15,880,608 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL Server 2005 Reporting Services Pin
martin_hughes29-Jun-07 1:35
martin_hughes29-Jun-07 1:35 
QuestionSQL Inner Join? Pin
Expert Coming27-Jun-07 14:56
Expert Coming27-Jun-07 14:56 
AnswerRe: SQL Inner Join? Pin
Chinnakasu27-Jun-07 16:31
Chinnakasu27-Jun-07 16:31 
AnswerRe: SQL Inner Join? Pin
Guffa27-Jun-07 20:51
Guffa27-Jun-07 20:51 
QuestionVB.Net 64 bit long to SQL [modified] Pin
Polymorpher27-Jun-07 12:18
Polymorpher27-Jun-07 12:18 
AnswerRe: VB.Net 64 bit long to SQL Pin
Mike Dimmick27-Jun-07 23:13
Mike Dimmick27-Jun-07 23:13 
GeneralRe: VB.Net 64 bit long to SQL Pin
Polymorpher28-Jun-07 9:44
Polymorpher28-Jun-07 9:44 
QuestionSQL Statement for searching in ADO.NET Pin
kinsella_john27-Jun-07 5:00
kinsella_john27-Jun-07 5:00 
I am trying to create a search for a sql database i have been writing. i have managed to get the search to search "firstName". if i replace this with any of my other column names it also works fine, but i am trying to get it to search multiple columns at once.

i have tried searching on google but dont really know what to search for.

i thought it might have been an AND or an OR statement but couldnt get these working either.


this is my code;

Sub BindDataGrid1()
Dim CS As String
CS = _
"data source=(local)\SQLEXPRESS;" & _
"initial catalog=mus_search_test;"



Dim objCN As SqlConnection
objCN = New SqlConnection(CS)

Dim objDA As SqlDataAdapter
objDA = New SqlDataAdapter("Select * from Musician_Search", objCN)



Dim DS_SearchMusician_Search As DataSet
DS_SearchMusician_Search = New DataSet

objDA.Fill(DS_MS11, "Musician_Search")

Dim objDV As DataView
objDV = DS_MS11.Tables("Musician_Search").DefaultView
' sql statement for row filter
MySearch = "firstName LIKE '*" & txtSearch.Text & "*'"
objDV.RowFilter = MySearch
RecNum = objDV.Count.ToString

John Michael Kinsella
kinsellajohn@hotmail.com

AnswerRe: SQL Statement for searching in ADO.NET Pin
DanB198329-Jun-07 0:59
DanB198329-Jun-07 0:59 
GeneralRe: SQL Statement for searching in ADO.NET Pin
kinsella_john29-Jun-07 1:34
kinsella_john29-Jun-07 1:34 
GeneralRe: SQL Statement for searching in ADO.NET Pin
DanB198329-Jun-07 2:48
DanB198329-Jun-07 2:48 
GeneralRe: SQL Statement for searching in ADO.NET Pin
kinsella_john3-Jul-07 3:45
kinsella_john3-Jul-07 3:45 
GeneralRe: SQL Statement for searching in ADO.NET [modified] Pin
DanB19833-Jul-07 4:08
DanB19833-Jul-07 4:08 
QuestionUrgent need in procedure........... Pin
Member 387988127-Jun-07 3:23
Member 387988127-Jun-07 3:23 
AnswerRe: Urgent need in procedure........... Pin
Tarakeshwar Reddy27-Jun-07 6:08
professionalTarakeshwar Reddy27-Jun-07 6:08 
QuestionPartial update via OleDBDataAdaptor Pin
Dan Neely27-Jun-07 3:12
Dan Neely27-Jun-07 3:12 
AnswerRe: Partial update via OleDBDataAdaptor Pin
Dave Kreskowiak27-Jun-07 5:19
mveDave Kreskowiak27-Jun-07 5:19 
GeneralRe: Partial update via OleDBDataAdaptor Pin
Dan Neely27-Jun-07 5:40
Dan Neely27-Jun-07 5:40 
GeneralRe: Partial update via OleDBDataAdaptor Pin
Dave Kreskowiak27-Jun-07 5:55
mveDave Kreskowiak27-Jun-07 5:55 
QuestionI want to secure my DB Pin
merwa27-Jun-07 2:35
merwa27-Jun-07 2:35 
AnswerRe: I want to secure my DB Pin
Vasudevan Deepak Kumar27-Jun-07 2:47
Vasudevan Deepak Kumar27-Jun-07 2:47 
QuestionSQL Server 2000 mirror Database Pin
AcDev727-Jun-07 1:01
AcDev727-Jun-07 1:01 
AnswerRe: SQL Server 2000 mirror Database Pin
Mike Dimmick27-Jun-07 2:24
Mike Dimmick27-Jun-07 2:24 
GeneralRe: SQL Server 2000 mirror Database Pin
Colin Angus Mackay27-Jun-07 12:19
Colin Angus Mackay27-Jun-07 12:19 
GeneralRe: SQL Server 2000 mirror Database Pin
Mike Dimmick27-Jun-07 23:30
Mike Dimmick27-Jun-07 23:30 

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.