Visual Basic

21-Mar-07 1:24

Also,

I got two Table Name Volume and VolumeLessons .
I have used a Query to make a SingleTable name Query_Volume_VolumeLessons, now this table is inside my code or Prject not in SQL SERVER DataBase.

Now I need to pull data from Query_Volume_VolumeLessons to make another two table name Query_Volume_Sector and Query_Volume_Themes for further work and then lots of thing....................

Please help me

Sarfarj Ahmed

Re: Urgent 002

Tirthadip21-Mar-07 1:59

Tirthadip

21-Mar-07 1:59

In my opinion instead of making a table, populate a dataset with your query as because you can easily loop through your dataset to do your operation....

Tirtha

"A man can ride on your back only when it is bent....."

Re: Urgent 002

Sarfaraj Ahmed21-Mar-07 2:24

Re: Put data to Table(1) from Table(0)

21-Mar-07 2:24

Thanks for your reply

I have alredy added a DataSet name Publications where I have add three tables.
Table(0) is Query_Volume_VolumeLessons
Table(1) is Query_Volume_Sectos
Table(2) is Query_Volume_Themes

Also put data on Table(0) from SQL SERVER DataBase

Now How can I put data to Table(1) From Table(0) , using a sqlQuery

Thanks

Sarfarj Ahmed

Re: Urgent 002

PlayByTheRules21-Mar-07 2:23

PlayByTheRules

21-Mar-07 2:23

Sarfaraj Ahmed wrote:
Urgent 002

This is a useless subject line. Please use more appropriate subject lines in future. Hint: No appropriate subject line will include the word "urgent"

Sarfaraj Ahmed21-Mar-07 2:26

21-Mar-07 2:26

Thanks for ur Email
Can you help me?

Sarfarj Ahmed

SUBJECT LINE

leckey21-Mar-07 5:36

leckey

21-Mar-07 5:36

This is the 6th post you've title with "urgent" or "please help." Many people will avoid answering these questions with such subjects.

_________________________________________
You can't fix stupid, but you can medicate crazy.

Urgent 001

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

Interfacing with a web camera

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"

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

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

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

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

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.

project's components missing in the toolbox

shyamts21-Mar-07 2:26

shyamts

21-Mar-07 2:26

Thanks for ur kind help.....

thanks and regards,
Shyam T S

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,

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

A*****

20-Mar-07 23:15

Where you in the code view when this happened?

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

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.