Interview Question in vb |
|
|
refer question:
http://answers.yahoo.com/question/index;...
Dim conn = CreateObject("adodb.connection")
Dim rs = CreateObject("adodb.recordset")
Dim comm = CreateObject("adodb.command")
Dim strSql As String
strSql = "Select User Name, Password From AuthorizedInventoryStaff.mdb Where User Name='" & txtUserName.Text & "'and Password='" & txtPassword.Text & "'"
conn.connectionstring = ""
comm.CommandType()
conn.Open()
comm.commandtext = strSql
comm.connection = conn
rs = comm.execute
If Not rs.eof Or rs.eof Then
response.redirect("Welcome.vb")
Else
response.redirect("Login.vb")
End If
error message: Name 'response' is not declared.
i ma using access and visual studio .net 2003(windows application(VB))
|
|
|
|
|
i want to develop an online sales and inventory system for a bookstore. the inventory system is only meant for the staff. i plan to use visual studio .net 2003 using vbscript and ms access for the d/base. can someone please help me with the code to:
1)link access to .net
2)give a sample code for login, add, delete, update and delete
3)should i use windows application or asp.net web application for the inventory system??
|
|
|
|
|
|
i have to do this project and i've come to the point where i am going to GIVE UP which is a really bad thing coz this project is very important!! SOME KIND SOUL, PLEASE HELP ME!! i need someone who could teach me how to code using visual studio .net 2003!!this is xtremely URGENT!!
Details of the project: online sales and inventory for a bookshop
inventory is using vb.net in vs .net 2003 and the sales is using asp...
I am using MS Access for the database
Main problems:
1) i don't know how to connect the database to the code
2) i have tried so many variations in the coding for logging in and i can't seem to get even THAT right!!
3) I also need to be able to show selected details using the datagrid as well as how to edit and update it
Please help me!!!
|
|
|
|
|
|
|
I'm using Visual Studio.net 2003.
|
|
|
|
|
|
I need Your help for download crystal Reports for visual studio 2003.net
because when i made a Programmer Contains a reports and to my customer .. i face a problem that i didn't have a program (( cryastal Report )) ......
please Help me ... i need crystal report alone NOT ON
Visual stideo CD ...
THanks ...
|
|
|
|
|
|
i'm using visual studio .net 2003 as my front end and sql 2000 as my back end.. i.ve already made my tables in sql.. the problem is how do i connect this database to . net?? what code will i put in dbconnection.vb???
pls. help me...
|
|
|
|
|
|
msdn 2003 and visual studio.net 2003 installed in my computer. And now i install microsoft visual studio 6.0 for my college project. I want to work in Visual Basic 6.0. But when i click help in vb 6.0 then it say msdn not installed, but i have the msdn in my computer.
In a forum i read that after 2001 msdn version not compactible with vb6. Is there any solution. I want to work in both(VB6, VB.NET 2003). Is there any patch or update available that help me to work msdn october 2003 in visual studio 6.0. Please help i realy need help. Because i not found msdn 2001.
Plz help me with solution as soon as posible.
|
|
|
|
|
|
|
dont know how to get oledb adapter.from where can i take it.it is not in toolbox.plz help.
|
|
|
|
|
|
Anybody please help me out in this,urgent!
Thanks in advance.
|
|
|
|
|
|
Hey everyone, i have a programming class at school and when i have to get up to go ask the teacher something, the guys around me mess up and delete my programs all the time. i'm sick and tired of it, so i wrote a visual basic 2005 express program that locks the computer using
Public Declare Sub LockWorkStation Lib "user32" ()
but when i try to execute it at my school (they do whatever they can to stop us from locking it because they're afraid someone will lock and leave) it doesn't work! is there any other way to do this? other than, of course, re-coding the entire darned lockworkstation? much thanks appreciated in advance.
--additon: the only resources i have are microsoft's visual studio express versions
|
|
|
|
|
|
here is the problems, what i tried is below it, having trouble putting this code togeather could somone help me with it and mainly getting the variables right and using the loops correctly.
this is using visual studios 2005
Name this project Marks.
Create a console application for the following problem.
• Place a title on the screen “Marks Program by Your Name”
• Prompt the user: “Do you want to calculate average marks (Y/N)?”
• If the user enters a Y/y, the program will prompt “How many marks (3-6)?” and read an integer between 3 and 6. Use a do while pre-test loop to get a valid number, displaying an invalid message if necessary. Use constants for 3 and 6. Once you get a valid number, read in that many marks (single) from the user and find the average. Marks entered must be between 0.0 and 100.0. Keep reading marks until they are in that range. Use a for loop to read in the marks. Display the following on the screen: “n marks entered and the average is nn.nn”, where n represents the number the user entered and nn.nn represents the average.
• If the user enters an N/n, the program will end.
• If the users enters anything besides a Y/y or N/n, display invalid and re-prompt “Do you want to calculate average marks (Y/N)?”
• Hand in pseudocode by Tuesday, Nov. 4 at 8:30 am. (5 marks)
• Pseudocode must be typed in Word with your name on it.
Your test cases are as follows with messages:
Marks Program by Your Name
Do you want to calculate average marks (Y/N)? X
Invalid option, please try again
Do you want to calculate average marks (Y/N)? y
How many marks? (3-6): 14
Invalid number of marks, choose (3-6): 4
Enter mark 1: -17
Error - marks must be between 0 - 100: 120
Error - marks must be between 0 - 100: 67.5
Enter mark 2: 73.5
Enter mark 3: 76.5
Enter mark 4: 96.5
4 marks entered and the average is 78.5
Do you want to calculate average marks (Y/N)? Y
How many marks? (3-6): 3
Enter mark 1: 77
Enter mark 2: 84
Enter mark 3: 63
3 marks entered and the average is 74.66666
Do you want to calculate average marks (Y/N)? N
Press any key to continue . . .
Imports system.console
Dim num as integer
Dim counter as integer
Dim Marks as Single
Dim Grade as single
Dim char as string=''Y,y" , N,n''
Const MIN as integer= 3
Const MAX as integer = 6
Const grademin as single = 0.0
Const grademax as single = 100.0
Writeline(“ Marks program by Brian Murphy”)
Readline()
Writeline(“ Do you want to calculate average marks (Y/N)?
Readline= char
If char = "Y,y" Then
‘ prompt user to enter number of marks
For counter = 3 to 6
‘prompt user for a valid number
Write= (“ Enter a number “ & counter & “ of 6:”)
Num= readline()
Do while counter >3 or <6
'tell user number is invalid . Prompt for number again
Loop while counter <3 or >6
Write (“Invalid number. Enter another number")
Else if char="N,n" Then
Writeline("
Loop
Next
For
|
|
|
|
|
|
here is the problems, what i tried is below it, having trouble putting this code togeather could somone help me with it and mainly getting the variables right and using the loops correctly.
this is using visual studios 2005
Name this project Marks.
Create a console application for the following problem.
• Place a title on the screen “Marks Program by Your Name”
• Prompt the user: “Do you want to calculate average marks (Y/N)?”
• If the user enters a Y/y, the program will prompt “How many marks (3-6)?” and read an integer between 3 and 6. Use a do while pre-test loop to get a valid number, displaying an invalid message if necessary. Use constants for 3 and 6. Once you get a valid number, read in that many marks (single) from the user and find the average. Marks entered must be between 0.0 and 100.0. Keep reading marks until they are in that range. Use a for loop to read in the marks. Display the following on the screen: “n marks entered and the average is nn.nn”, where n represents the number the user entered and nn.nn represents the average.
• If the user enters an N/n, the program will end.
• If the users enters anything besides a Y/y or N/n, display invalid and re-prompt “Do you want to calculate average marks (Y/N)?”
• Hand in pseudocode by Tuesday, Nov. 4 at 8:30 am. (5 marks)
• Pseudocode must be typed in Word with your name on it.
Your test cases are as follows with messages:
Marks Program by Your Name
Do you want to calculate average marks (Y/N)? X
Invalid option, please try again
Do you want to calculate average marks (Y/N)? y
How many marks? (3-6): 14
Invalid number of marks, choose (3-6): 4
Enter mark 1: -17
Error - marks must be between 0 - 100: 120
Error - marks must be between 0 - 100: 67.5
Enter mark 2: 73.5
Enter mark 3: 76.5
Enter mark 4: 96.5
4 marks entered and the average is 78.5
Do you want to calculate average marks (Y/N)? Y
How many marks? (3-6): 3
Enter mark 1: 77
Enter mark 2: 84
Enter mark 3: 63
3 marks entered and the average is 74.66666
Do you want to calculate average marks (Y/N)? N
Press any key to continue . . .
Imports system.console
Dim num as integer
Dim counter as integer
Dim Marks as Single
Dim Grade as single
Dim char as string=''Y,y" , N,n''
Const MIN as integer= 3
Const MAX as integer = 6
Const grademin as single = 0.0
Const grademax as single = 100.0
Writeline(“ Marks program by Brian Murphy”)
Readline()
Writeline(“ Do you want to calculate average marks (Y/N)?
Readline= char
If char = "Y,y" Then
‘ prompt user to enter number of marks
For counter = 3 to 6
‘prompt user for a valid number
Write= (“ Enter a number “ & counter & “ of 6:”)
Num= readline()
Do while counter >3 or <6
'tell user number is invalid . Prompt for number again
Loop while counter <3 or >6
Write (“Invalid number. Enter another number")
Else if char="N,n" Then
Writeline("
Loop
Next
For
|
|
|
|
|
|
here is the problems, what i tried is below it, having trouble putting this code togeather could somone help me with it and mainly getting the variables right and using the loops correctly.
this is using visual studios 2005
Name this project Marks.
Create a console application for the following problem.
• Place a title on the screen “Marks Program by Your Name”
• Prompt the user: “Do you want to calculate average marks (Y/N)?”
• If the user enters a Y/y, the program will prompt “How many marks (3-6)?” and read an integer between 3 and 6. Use a do while pre-test loop to get a valid number, displaying an invalid message if necessary. Use constants for 3 and 6. Once you get a valid number, read in that many marks (single) from the user and find the average. Marks entered must be between 0.0 and 100.0. Keep reading marks until they are in that range. Use a for loop to read in the marks. Display the following on the screen: “n marks entered and the average is nn.nn”, where n represents the number the user entered and nn.nn represents the average.
• If the user enters an N/n, the program will end.
• If the users enters anything besides a Y/y or N/n, display invalid and re-prompt “Do you want to calculate average marks (Y/N)?”
• Hand in pseudocode by Tuesday, Nov. 4 at 8:30 am. (5 marks)
• Pseudocode must be typed in Word with your name on it.
Your test cases are as follows with messages:
Marks Program by Your Name
Do you want to calculate average marks (Y/N)? X
Invalid option, please try again
Do you want to calculate average marks (Y/N)? y
How many marks? (3-6): 14
Invalid number of marks, choose (3-6): 4
Enter mark 1: -17
Error - marks must be between 0 - 100: 120
Error - marks must be between 0 - 100: 67.5
Enter mark 2: 73.5
Enter mark 3: 76.5
Enter mark 4: 96.5
4 marks entered and the average is 78.5
Do you want to calculate average marks (Y/N)? Y
How many marks? (3-6): 3
Enter mark 1: 77
Enter mark 2: 84
Enter mark 3: 63
3 marks entered and the average is 74.66666
Do you want to calculate average marks (Y/N)? N
Press any key to continue . . .
Imports system.console
Dim num as integer
Dim counter as integer
Dim Marks as Single
Dim Grade as single
Dim char as string=''Y,y" , N,n''
Const MIN as integer= 3
Const MAX as integer = 6
Const grademin as single = 0.0
Const grademax as single = 100.0
Writeline(“ Marks program by Brian Murphy”)
Readline()
Writeline(“ Do you want to calculate average marks (Y/N)?
Readline= char
If char = "Y,y" Then
‘ prompt user to enter number of marks
For counter = 3 to 6
‘prompt user for a valid number
Write= (“ Enter a number “ & counter & “ of 6:”)
Num= readline()
Do while counter >3 or <6
'tell user number is invalid . Prompt for number again
Loop while counter <3 or >6
Write (“Invalid number. Enter another number")
Else if char="N,n" Then
Writeline("
Loop
Next
For
|
|
|
|
|
|
here is the problems, what i tried is below it, having trouble putting this code togeather could somone help me with it and mainly getting the variables right and using the loops correctly.
this is using visual studios 2005
Name this project Marks.
Create a console application for the following problem.
• Place a title on the screen “Marks Program by Your Name”
• Prompt the user: “Do you want to calculate average marks (Y/N)?”
• If the user enters a Y/y, the program will prompt “How many marks (3-6)?” and read an integer between 3 and 6. Use a do while pre-test loop to get a valid number, displaying an invalid message if necessary. Use constants for 3 and 6. Once you get a valid number, read in that many marks (single) from the user and find the average. Marks entered must be between 0.0 and 100.0. Keep reading marks until they are in that range. Use a for loop to read in the marks. Display the following on the screen: “n marks entered and the average is nn.nn”, where n represents the number the user entered and nn.nn represents the average.
• If the user enters an N/n, the program will end.
• If the users enters anything besides a Y/y or N/n, display invalid and re-prompt “Do you want to calculate average marks (Y/N)?”
• Hand in pseudocode by Tuesday, Nov. 4 at 8:30 am. (5 marks)
• Pseudocode must be typed in Word with your name on it.
Your test cases are as follows with messages:
Marks Program by Your Name
Do you want to calculate average marks (Y/N)? X
Invalid option, please try again
Do you want to calculate average marks (Y/N)? y
How many marks? (3-6): 14
Invalid number of marks, choose (3-6): 4
Enter mark 1: -17
Error - marks must be between 0 - 100: 120
Error - marks must be between 0 - 100: 67.5
Enter mark 2: 73.5
Enter mark 3: 76.5
Enter mark 4: 96.5
4 marks entered and the average is 78.5
Do you want to calculate average marks (Y/N)? Y
How many marks? (3-6): 3
Enter mark 1: 77
Enter mark 2: 84
Enter mark 3: 63
3 marks entered and the average is 74.66666
Do you want to calculate average marks (Y/N)? N
Press any key to continue . . .
Imports system.console
Dim num as integer
Dim counter as integer
Dim Marks as Single
Dim Grade as single
Dim char as string=''Y,y" , N,n''
Const MIN as integer= 3
Const MAX as integer = 6
Const grademin as single = 0.0
Const grademax as single = 100.0
Writeline(“ Marks program by Brian Murphy”)
Readline()
Writeline(“ Do you want to calculate average marks (Y/N)?
Readline= char
If char = "Y,y" Then
‘ prompt user to enter number of marks
For counter = 3 to 6
‘prompt user for a valid number
Write= (“ Enter a number “ & counter & “ of 6:”)
Num= readline()
Do while counter >3 or <6
'tell user number is invalid . Prompt for number again
Loop while counter <3 or >6
Write (“Invalid number. Enter another number")
Else if char="N,n" Then
Writeline("
Loop
Next
For
|
|
|
|
|
|
I'd like to have automatic build increment for my application. Unfortunately VS2005 does not have such feature (modifying AssemblyInfo.vb or AssemblyInfo.cs is not working good enough for me). On the net i found how it is possible to do using Macros, BUT i dont like this idea as well (some known problems).
So, my question is if you guys know any software that can integrate with Visual Studio 2005 and accomplish this task?
For example, i build my application for the first time and it modifies version from 1.0.0.0 to 1.0.0.1 and then 1.0.0.2 as so on.
Thanks.
|
|
|
|
|
|
I have to make a program like proteus. maybe you don't know this software , i have another example:
I have to make a program like all the visual programming languages like Visual Studio 2005, vb6 , vc6 or ...
user can insert some objects from toolbox to form, and move them, and also insert some lines between them.
the lines must be a layer, i mean the user must be able to drag , drop delete or ... on the lines and objects
I don't know how to make such a program, please if you know how could i do that tell me ASAP.
(something like the relationship line in MS access ,when you make relation the tables.)
|
|
|
|
|
|
i now doing a project then use vb to view data from c drive and my hard disk...
I really need help on how to do it, i using microsoft visual studio 2005... can u tell me the steps or e tool to use or if need code can let me know e code also.. thx alot... really need help..
|
|
|
|
|
|
|
I have this vb.net project that I want to load up to a webserver. The application is pulling its info from a small access database that I plan on having on the same web server as the forms. I have never done this and was wondering how to implement it. Is there a wizard in Visual Studio 2005 that will convert my porject into the real thing that can be loaded onto a web server? My connection to my database is the web config file, do I have to change that string before or can I cange it after I convert this project into real web pages. Also I have acouple of reports that are pulling info from the access database and I used the connection wizzard to connect the crystal reports to the queries in my database. How do I change the connection of the reports to the new database since the database will no longer be on my H: drive it wil be on a web server? Any help would be appericated or any links or phone numbers to sites/companies that can answer these questions.
|
|
|
|
|
|
hi all i am very familiar with vb6 but .net in vb 6 if i wanted to turn text in a text box bold i simply typed in Text1.Fontbold = true
i cannot figure oout how to do it in Visual studio 2005
|
|
|
|
|
|
|
i need help in finding codings for inventory system in vb.net. I am using microsoft visual studio 2005.please help me. thank you
|
|
|
|
|