|
Hi all,
i have 3 tables
MultipleChoice
MultipleChoiceAnswer
Level
i wanto amke a join with these 3 where MultipleChoice.MID=MultipleChoiceAnswer.MID AND MultipleChoice.levelID=Level.LevelID
THx
Arshaad
Arshaad
|
|
|
|
|
Did you post this just to inform us, or do you have any problems with it?
---
b { font-weight: normal; }
|
|
|
|
|
I really need help.. sry if was ambiguous
Give the syntax pz
Thx
|
|
|
|
|
Really simple:
select *<br />
from MultipleChoice, MultipleChoiceAnswer, Level<br />
where MultipleChoice.MID=MultipleChoiceAnswer.MID AND MultipleChoice.levelID=Level.LevelID
or
select *<br />
from MultipleChoice<br />
inner join MultipleChoiceAnswer on MultipleChoice.MID=MultipleChoiceAnswer.MID<br />
inner join Level on MultipleChoice.levelID=Level.LevelID
---
b { font-weight: normal; }
|
|
|
|
|
mcqRecordset.Open "select * From MultipleChoice, MultipleChoiceAnswer,Level Where MultipleChoice.multipleChoiceID=MultipleChoiceAnswer.multipleChoiceID AND MultipleChoice.levelID=Level.levelID", myConnection, adOpenStatic, adLockOptimistic
Error: error in from clause
Thx again
|
|
|
|
|
Level is a reserved word. Rename the table.
---
b { font-weight: normal; }
|
|
|
|
|
hello, i made an ip messenger that can be used for chatting between 2 users only The server and the client. I used the tcpClient and vb.net.
I want to know how can i send a file (textfile) or what so ever via ip! can this be done?? thanks alot
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
How could i select a single speaker to play a sound with DirectSound?
I've a 5.1 soundcard which is configured as sorround sound, so that i can use the 6 outputs. This card appears in the system as one device (i have another 5.1 card and, with special drivers, it appears as 3 stereo devices, so it s easier to use, but i cannot use these drivers on the first card) and ive seen an application which can play a sound to a single speaker, so i should be able to do it too.
Ive thought about playing the sound as a 3D sound and selecting its position, but i dont think it s a good idea.
Any idea? Thx
|
|
|
|
|
<b>Dear Sir,
<b>
i amworking on vb.net
i have a textbox field in the form called CardId
now what i want is to generate numbers automatically and in a sequence.
Suppose,
when i click on the ADD RECORD button to add a new record, the cardid should be automatically generated as 1. if the record is saved ,then the next time when i am trying to add another record the cardid should be 2. but if the first record having cardid 1 is not saved then the next time i am adding a record the card id should be 1.
can u pl help me through code.</b></b>
Arun
|
|
|
|
|
dear arun,
You can refer the code below.
Function GenerateCode() As String
Dim MyCommand As SqlClient.SqlDataAdapter
Dim Dsg As New Customer
Dim LastRec As Integer
Try
MyCommand = New SqlClient.SqlDataAdapter("select * from Cusdetail order by 1 asc", Myconnection)
MyCommand.Fill(Dsg, "Cusdetail")
LastRec = Dsg.CusDetail.Count()
If LastRec > 0 Then
LastRec = LastRec - 1
TxtCusCode.Text = Ds.CusDetail(LastRec).CusCode + 1
Else
TxtCusCode.Text = "100001" 'Code for first Customer
End If
Catch ex As Exception
Label11.Text = ex.Message()
End Try
Myconnection.Close()
End Function
Thankx
Murtuza Patel.
|
|
|
|
|
this is easy...u can get the cardid field from the database into a dataset...and check for the largest number...and then add 1 to it and set it as ur generated number in the text box...
subhrajyoti
|
|
|
|
|
is it not easier to use Access for that sort of things?
|
|
|
|
|
Hello everybody!
I should write a program to power on & power off a video projector..
I use the SerialPort Class in the .NET Framework to transmit the necessary codes via a serial cabel that is connected to that video projector - it works fine (power on & power off)..
But now I should develop a GUI program to do that..
In that GUI program I need to specify on what time the specific code will be transmitted to the projector - maybe also the days (Monday until Friday or so..)
It could look like:
Start Time: 08:00
End Time: 11:00
From: Monday until Friday
In the codeproject messageboard I have found the "task scheduler class library". With that library I could create two scheduled tasks in win2k to perform "power on" and "power off". In order to that I will have to create two console-based programs executed by the scheduled tasks..
(http://www.codeproject.com/csharp/TSNewLib.asp[^]
But is there a better concept to achieve my goals?
Is there any other possibility to implement a timer to control the video projector at any one time?
Thanks in advance for any suggestion!
(Sorry for my English, it is not my first language)
|
|
|
|
|
Generally there are three ways of doing this:
:: Use the scheduler.
:: Let the program run in the background and wait until the right time.
:: Develop a service, that runs in the background and waits until the right time.
The third one is basically creating your own scheduler, so it might be a bit over the top for your project. Whether you should use the first or the second method mostly depends on if you want to have a program running constantly on the computer or not.
yomam wrote: Sorry for my English, it is not my first language
(Nor is it mine.) Even if your use of the language is not perfect, I find it far better than that of many users here that actually do have english as their first language. They just don't make an effort to use it correctly.
---
b { font-weight: normal; }
|
|
|
|
|
Thank you very much for your suggestions!
I think by using the task scheduler my requirements will be satisfied. Implementing my own scheduler would be a bit too much.. Therefore I will have to write some code to import all scheduled tasks with their settings and find the proper ones which are "responsible" for my video projector in order to make changes for power off and power on time..
|
|
|
|
|
i have developed an application using MS SQL, VB 6 usifn Seagate crystal reports. i want to create this application as a demo version, for this i need to go for putting the expiry date for the application. how can i do that ? or something to be done during pacakage and deployment ?
thanx a lot ..
furher
|
|
|
|
|
i have got an idea...try this...during the form load of ur main form...store the date of first run in a text file through file commands at an unknown location...e.g. windows/system32...
and then every time the user runs...the formload checks for thr file and reads the date and comapares with the currnt date...if it doesnt find the file then its the first run and u need to create the file...and u can set the date to any number of days after the first run date....
subhrajyoti
|
|
|
|
|
Hi Rikky,
Thanx for ur response.
I will surely try this.
But there is a small problem.
If suppose the file is renamed or deleted, then the demo version will be of no use.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
Hi Furher,
Iam also looking for the same code.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
Hi,
I would like to write a program that loads an image and scans each pixel in turn from left to right and from top to bottom. When the pixel is scanned I need to find out the color value e.g. #FF0000
I am not new to programming its just that I have not programmed using graphic functions before.
If anyone could possibly point me in the right direction I would appreciate it.
Many Thanks
Julian Mummery
www.IJude.com
|
|
|
|
|
when you load a image you can get its Image type which you cast into a Bitmap.
Then you have a GetPixel(x,y) method avalible.
Then you just loop trough the width and height of the image and you will get the pixel information (you will get a Color ).
But I must warn you that this is really slow (I had some spare tiem yesterday and I have written a small app that does just that).
--------------------------------------------------------
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
how to write the automation code by using VB? it is same like do the pointer or any different ways? actually, i want to make an automation for converter step. the converter such as word to pdf converter. so that, i want to automate all the step in the converter. can you give the suggestion or the example..thank you
|
|
|
|
|
I have designed two forms, "compose page" and "read page", I designed one button "add" on the compose page, once it pressed, the requested things will be add in the "requested lists" field, at the same time, the record of that things in the stock(stored in a database) will be deducted by corresponding requesting number. Then press "send" to recipients. But this logic is abnormal, Normally, when the recipients receive the request email, he press "accept" on the "read page", and then stock record will be deducted. I dont know how to send out the "read page" to recipient by email. Please help me. Thank you.
|
|
|
|
|
i wanna ask how do i overwrite the contain inside the text file?
recently when i write it will continue my old information
strmw = OpenStreamWriter(filePath)
strmw.Write(vbCrLf)
'loop all the player status
For x = 1 To Val(NumPlayer.Text)
' write detail in the record
strmw.WriteLine(String.Format("Player:" & (x), Now))
strmw.WriteLine(String.Format(" Name: " & wpname(x).Text, Now))
strmw.WriteLine(String.Format("position:" & wPP(x).Text, Now))
strmw.WriteLine(String.Format(" MoveStep:" & wcounter(x).Text, Now))
Next
strmw.WriteLine(String.Format("whosturn: " & PTurn.Text, Now))
strmw.Close()
|
|
|
|
|
You can use the fileStream
* * *
Dim f As New FileStream(FileName, FileMode.Create, FileAccess.Write, FileShare.Write)<br />
Dim r As New StreamWriter(f)<br />
All the parameters with *'s above them can be changed to diffrent options such as reading or writing ect.
|
|
|
|