Question on substring???????? - Visual Basic Discussion Boards

Sarfaraj Ahmed21-Mar-07 1:21

21-Mar-07 1:21

I need some instruction and help

Customer Table

CustID CustName
01 ABC
02 ACB
03 ADB

Order Table

OrderID CustID
1001 01
1002 01
1003 01
1004 02
1005 02
1006 03
1007 03
1008 03
1009 03
1010 03

I want those output like below

CustID CustName OrderID
01 ABC 1001, 1002, 1003
02 ACB 1004, 1005
03 ADB 1006, 1007, 1008, 1009, 1010

Please help me. Thanks
Sarfaraj

Sarfarj Ahmed

Re: Urgent 001

Tirthadip21-Mar-07 2:03

Tirthadip

21-Mar-07 2:03

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....."

Re: Urgent 001

Sarfaraj Ahmed21-Mar-07 2:34

Sarfaraj Ahmed

21-Mar-07 2:34

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

Re: Urgent 001

PlayByTheRules21-Mar-07 2:22

PlayByTheRules

21-Mar-07 2:22

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"

Interfacing with a web camera

BarnfieldAdam21-Mar-07 0:45

BarnfieldAdam

21-Mar-07 0:45

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

Re: Interfacing with a web camera

Dave Kreskowiak21-Mar-07 3:20

Dave Kreskowiak

21-Mar-07 3:20

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

Re: Interfacing with a web camera

BarnfieldAdam21-Mar-07 4:10

BarnfieldAdam

21-Mar-07 4:10

Thank you for your response. I will give it a go.

Regards,

Adam - Tutor @ Barnfield

Question on substring????????

shyamts21-Mar-07 0:41

shyamts

21-Mar-07 0:41

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

Re: Question on substring????????

Tamimi - Code21-Mar-07 0:49

Tamimi - Code

21-Mar-07 0:49

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

Re: Question on substring????????

shyamts21-Mar-07 2:27

shyamts

21-Mar-07 2:27

Actually this was i am expecting...
thanks dude...
Thanks for ur kind help.....

Shyam T S

Re: Question on substring????????

BarnfieldAdam21-Mar-07 0:55

BarnfieldAdam

21-Mar-07 0:55

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

Re: Question on substring????????

Johan Hakkesteegt21-Mar-07 1:35

Johan Hakkesteegt

21-Mar-07 1:35

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.

Re: Question on substring????????

shyamts21-Mar-07 2:26

shyamts

21-Mar-07 2:26

Thanks for ur kind help.....

thanks and regards,
Shyam T S

project's components missing in the toolbox

steve_rm20-Mar-07 23:11

steve_rm

20-Mar-07 23:11

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,

Re: project's components missing in the toolbox

A*****20-Mar-07 23:15

A*****

20-Mar-07 23:15

Where you in the code view when this happened?

Re: project's components missing in the toolbox

steve_rm20-Mar-07 23:21

steve_rm

20-Mar-07 23:21

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

Re: project's components missing in the toolbox

A*****20-Mar-07 23:33

A*****

20-Mar-07 23:33

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.

Re: project's components missing in the toolbox

steve_rm20-Mar-07 23:36

steve_rm

20-Mar-07 23:36

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

Re: project's components missing in the toolbox

A*****20-Mar-07 23:44

A*****

20-Mar-07 23:44

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!

Re: project's components missing in the toolbox

The ANZAC21-Mar-07 0:00

The ANZAC

21-Mar-07 0:00

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

Re: project's components missing in the toolbox

steve_rm21-Mar-07 0:14

steve_rm

21-Mar-07 0:14

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

Re: project's components missing in the toolbox

Dave Kreskowiak21-Mar-07 3:18

Dave Kreskowiak

21-Mar-07 3:18

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

Hourglass

Liottru20-Mar-07 22:07

Liottru

20-Mar-07 22:07

Hi guys,

how can I set a hourglass during a process?

Thanks

Re: Hourglass

KaineDunno20-Mar-07 23:47

KaineDunno

20-Mar-07 23:47

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

Re: Hourglass

Johan Hakkesteegt21-Mar-07 2:02

Johan Hakkesteegt

21-Mar-07 2:02

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.

Last Visit: 31-Dec-99 18:00 Last Update: 6-May-24 11:44

Refresh

ᐊ Prev 1...2691 2692 2693 269426952696 2697 2698 2699 2700 Next ᐅ

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