Click here to Skip to main content
15,898,134 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionSorting Pin
CyberSamuraiii19-Aug-07 22:26
CyberSamuraiii19-Aug-07 22:26 
AnswerRe: Sorting Pin
originSH19-Aug-07 22:32
originSH19-Aug-07 22:32 
GeneralRe: Sorting Pin
CyberSamuraiii19-Aug-07 23:00
CyberSamuraiii19-Aug-07 23:00 
GeneralRe: Sorting Pin
originSH20-Aug-07 0:06
originSH20-Aug-07 0:06 
QuestionCrystal report Pin
sweehin1819-Aug-07 21:22
sweehin1819-Aug-07 21:22 
AnswerRe: Crystal report Pin
Sipder19-Aug-07 23:48
Sipder19-Aug-07 23:48 
Questionhow can i select two tables in a datagride [modified] Pin
magedhv19-Aug-07 21:11
magedhv19-Aug-07 21:11 
AnswerRe: how can i select two tables in a datagride Pin
Vimalsoft(Pty) Ltd21-Aug-07 21:45
professionalVimalsoft(Pty) Ltd21-Aug-07 21:45 
Good morning MageDHV

i hope following code will help you. if you want to update,Insert,Delete, you have to Add relations to this Code, but this one Will Display you 2table. i Suggest you do one thing at a time, try Displaying results from 2tables and then display results based
       Dim strconnection As String = "workstation id=5875-049;packet size=4096;user id=sde;Password=topology;data source=SGIICORNETGS01;persist security info=False;initial catalog=Tshwane_Valuations"
       Dim cn As SqlConnection = New SqlConnection(strconnection)
       cn.Open()
Dim  cmdstr as String  = "Select Property_Mass.boundary_Area,  "  _
   " &  Property_Mass.Actual_Extent, Property_Mass.Attrib_code,  "  _
   " &  Property_Mass.Lis_key, Property_Mass.Func_key, Property_Mass.Density, "  _
   " &  Property_Mass.New_Net_Usable_Extent, Property_Mass.New_Total_Land_Factor, "  _
   " &  Property_Mass.New_AdJ_Extent_1, Property_Mass.New_Points_1, Property_Mass.New_ADJ_Extent_2 , " _
   " &  Property_Mass.New_Points_2, Property_Mass.Fin_LS_Prediction, Property_Mass.Confidence_score , " _
   " &  Property_Mass.Flagtype, Property_Summary.Purchase_Date, Property_Summary.Purchase_Price " _
   " &  from Property_Mass, Property_Summary " _
   " &  where Property_Mass.Lis_key = Property_Summary.Lis_key "
       Dim da As New SqlDataAdapter(cmdStr, cn)
       Dim ds As New DataSet
       da.Fill(ds)
       Dim dv As New DataView(ds.Tables("Property_Mass"))
       dgDetails.DataSource = dv


it will look Buggy, but i want you to get th Logic, you create a Join and test it if its working and apply it in your string variable and display it on your table, tell me if you were able to do that, and we will go to the search based on textbox input. that would be easy you will see.

Vuyiswa Maseko

QuestionHow can i create syntax tree to check the grammar of a string Pin
Ajay_developer19-Aug-07 18:26
Ajay_developer19-Aug-07 18:26 
AnswerRe: How can i create syntax tree to check the grammar of a string Pin
Dave Kreskowiak20-Aug-07 2:13
mveDave Kreskowiak20-Aug-07 2:13 
QuestionRe: How can i create syntax tree to check the grammar of a string [modified] Pin
Ajay_developer20-Aug-07 18:30
Ajay_developer20-Aug-07 18:30 
Questiontime attendance Pin
saraswathy14319-Aug-07 17:05
saraswathy14319-Aug-07 17:05 
AnswerRe: time attendance Pin
Christian Graus19-Aug-07 17:55
protectorChristian Graus19-Aug-07 17:55 
QuestionList box selection Pin
sa_runner19-Aug-07 15:26
sa_runner19-Aug-07 15:26 
AnswerRe: List box selection Pin
Christian Graus19-Aug-07 17:59
protectorChristian Graus19-Aug-07 17:59 
GeneralRe: List box selection Pin
sa_runner19-Aug-07 18:47
sa_runner19-Aug-07 18:47 
JokeRe: List box selection Pin
Luc Pattyn19-Aug-07 23:22
sitebuilderLuc Pattyn19-Aug-07 23:22 
GeneralRe: List box selection Pin
Christian Graus19-Aug-07 23:56
protectorChristian Graus19-Aug-07 23:56 
GeneralRe: List box selection Pin
sa_runner20-Aug-07 6:46
sa_runner20-Aug-07 6:46 
AnswerRe: List box selection Pin
The ANZAC20-Aug-07 0:08
The ANZAC20-Aug-07 0:08 
GeneralRe: List box selection Pin
sa_runner20-Aug-07 6:45
sa_runner20-Aug-07 6:45 
AnswerRe: List box selection Pin
satheesh.a20-Aug-07 0:14
satheesh.a20-Aug-07 0:14 
QuestionStatus Bar Text Pin
ejaz_pk19-Aug-07 11:58
ejaz_pk19-Aug-07 11:58 
AnswerRe: Status Bar Text Pin
Dave Kreskowiak19-Aug-07 12:27
mveDave Kreskowiak19-Aug-07 12:27 
Questionhow to call function that return object Pin
Arif Liminto19-Aug-07 6:12
professionalArif Liminto19-Aug-07 6:12 

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.