|
I think you cannot do it in single SQL query.....
populate a dataset with following query..
SELECT Customer.CustID, CustName, OrderID<br />
FROM Customer INNER JOIN Orders ON Customer.CustID=Orders.CustID
then loop through your dataset to make customized dataset or datatable which you want ....where you can concatenate the OrderID fields....
did u get me???
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
How can I make a customized dataset or dataTable and how can I concatenate the OrderID fields.
please send me more instructions with some code
Waiting for ur reply.......
Sarfarj Ahmed
|
|
|
|
|
Sarfaraj Ahmed wrote: Urgent 001
This is a useless subject line. Please use more appropriate subject lines in future. Hint: No appropriate subject line will include the word "urgent"
|
|
|
|
|
Hi there,
I have been given the task of writing a Windows Forms Application that uses a web cam to take photos for ID cards. I am fine with everything except for interfacing with the camera. Has anyone got any links or ideas on how I can achieve this please? I have had a look about the web but I can not seem to find any information on this.
Thank you for your time,
Adam Smith
Regards,
Adam - Tutor @ Barnfield
|
|
|
|
|
You might want to search for an SDK from the manufacturer of the camera. If you they don't offer one, you can Google for "Windows Image Acquisition" or "WIA VB.NET" for examples.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thank you for your response. I will give it a go.
Regards,
Adam - Tutor @ Barnfield
|
|
|
|
|
Hi,
My string contains a number followed by hiphen and then followed by text say
string1 = "1239980 - Microsoft" . Here, "-" is used as a delimiter.
How do i only retrive number from a string.This is my following code.
Dim a As String
Dim b As String
a = "1239980 - Microsoft"
b = a.Substring(0, Len(InStr(a, "-")) - 2)
The value of InStr(a, "-") is 9 which indicates the index of position of "-". Now i want to extract first 7 characters i.e the number part... What i will do??? Please help me...
Thanks and regards,
Shyam
|
|
|
|
|
Dim strTemp As String = "1239980 - Microsoft"
Dim arrSplit As Char() = {"-"}
Dim arrString As String() = strTemp.Split(arrSplit)
Dim strFinal As String = arrString(0)
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
Actually this was i am expecting...
thanks dude...
Thanks for ur kind help.....
Shyam T S
|
|
|
|
|
Hi there,
Give this a go if you only ever want the first 7 characters:
Dim a As String
Dim b As String
a = "1234567 - Microsoft"
b = a.Substring(0, 7)
MsgBox(b)
Regards,
Adam - Tutor @ Barnfield
|
|
|
|
|
Hi Shyam,
The following code is a bit crude, but it allows for any length number, and you can use it to handle other strings with different delimiters in your app as well:
<br />
Public function BeforeTheDelimiter(ByVal MyString as String, ByVal dlmtr as String) As String<br />
'Example: MyString = "1239980 - Microsoft" and dlmtr = " - "<br />
Return Mid(MyString, 1, MyString.IndexOf(dlmtr)) <br />
'result: BeforeTheDelimiter returns 1239980<br />
End Function<br />
Good luck,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Thanks for ur kind help.....
thanks and regards,
Shyam T S
|
|
|
|
|
Hello,
VS 2005
Might sound like a stupid question.
I went to my toolbox to find that the project components are missing. Normally the top tab in the toolbox. I have tried everything to get it back.
Nothing happend and there was no error messages, they just disappeared.
When I open up an early version of my project they are there, but not in my current project.
I have a typed dataset, and cannot add the table adapters to the form as the project components are gone.
Hope you understand what I mean. Normally they are the name of your project in the top tab in the toolbox.
Thanks for any advice on this,
|
|
|
|
|
Where you in the code view when this happened?
|
|
|
|
|
I think that might be possible that i was.
I was doing a few things, then went to add a table adapter to the form when I noticed they where not there.
Any ideas?
Thanks,
Steve
|
|
|
|
|
This happens to me too. If you aren't in the form view part (eg. you are in code view) then you cannot add any objects because you need to be the form view to do so.
So if you go into form view then the table adapter should be there.
|
|
|
|
|
Thanks for your reply.
Yes, I ready know that about the code view.
However, the problem is when I switch to design view, the toolbox displays all the tools, apart from the project's components.
Thanks for anymore advice,
Steve
|
|
|
|
|
I think I know the problem now
Open VS 2005 (if not already open)
then
goto:
1.Tools
2.Choose toolbox items
3.Then search for the table adapters and tick the checkbox and then it should be displayed again.
Hope this helps!
|
|
|
|
|
I know what you mean. But i've not had this problem before. Have you changed anything manually in the .designer.vb that could have affected this? I'm not sure though. So you can't just drag and drop your created datasets etc? Frustrating.
Posted by The ANZAC
|
|
|
|
|
Hello,
I have never had this problem before.
However, adding the all the components manually would be a long task as there are many of them. And I would have to check to make sure I have all them. I don't think that would be a good idea.
Any other ideas would be most grateful
Thanks
Steve
|
|
|
|
|
I've had this happen once before. I had to right-click the Toolbox (in Design view), pick "Reset Toolbox", then quit Visual Studio. Get back in and do a full rebuild of the Solution.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi guys,
how can I set a hourglass during a process?
Thanks
|
|
|
|
|
Somthing like this maybe?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As<br />
System.EventArgs) Handles Button1.Click<br />
<br />
' save the old cursor<br />
Cursor oldCursor = Me.Cursor;<br />
<br />
' change the cursor to the one you want<br />
Me.Cursor = Cursors.WaitCursor<br />
<br />
' do your work here<br />
<br />
' restore the old cursor or else you may never get it back<br />
Me.Cursor = oldCursor<br />
<br />
End Sub
|
|
|
|
|
Hi,
There is actually no need to save the cursor to memory.
<br />
Me.Cursor = CType(Cursors.WaitCursor, Cursor)<br />
'Your process starts here<br />
'Your process happens here<br />
'Your process finishes here<br />
Me.Cursor = CType(Cursors.Default, Cursor)<br />
Have fun,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
All you have to do is set the Cursor property.
Me.Cursor = Cursors.WaitCursor
' You might have to do this, depending on your code...
Application.DoEvents()
'
' Long running code goes here...
'
Me.Cursor = Cursors.Default
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|