Interview Question in access |
|
|
I am doing a programming on visual studio.net 2003 using the Asp.net mobile Web form. I am trying to update the Microsoft access database that i have created using the statement : Update.
According to the Update Statement that i had written, It directly replaces the value in the attribute of the table. Which is not what i am looking for. here's my quote of example for a better explanation:
I have a table name : Pen
Attributes are : ItemID, Color,Quantity,ItemDetails
As such my quantity inside have 10 and when i want to order another 40, i do not want it to replace to 40. i want to replace it to show 50. As such its an addition method.
However in my Update sentence it overwrite it. Is there any other method to make it add?Thanks. Its urgent.
|
|
|
|
|
|
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 am creating an online sales and inventory system as a project for college...sales system will be online while the inventory system is a windows application tht's only for the staffs' usage...i am using visual studio .net 2003 (VBScript) programming language and MS Access xp pro...i want to know how to link access to .net. I also want to know if i use the windows application for inventory subsystem and use the ASP.Net web application...how do i link both systems to each other?? Please help!!URGENT!!
|
|
|
|
|
|
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'm currently using Windows Server 2003 at home as a stand-alone OS to develop software. It's set up as a domain controller, but no other computers are connected to it. It exists on it's own hard drive and when I want to use it I shut down my computer, take out the hard drive with XP on it (I have swappable hard drive bays), insert the drive with Windows Server 2003 on it, and fire it up.
The problem i'm having is that when I need to connect to the internet, it takes a LONG time for the pages to open, or sometimes they don't open at all. I've entered all of my most used website addresses into Trusted Sites, but still I get errors. When I connect to Visual Studio, sometimes I cannot access MSDN or the ASP.NET Configuration Page (which I need for developing websites).
I'm totally baffled. When my XP drive is in and running my internet connection functions normally, and I almost never have problems accessing the internet.
Im using IE 6 and broadband connection
Help!
|
|
|
|
|
|
|
What I am looking for here is how to setup Windows 2003 server to allow Visual Studio .NET to connect to it. Right now when attempting to connect with Visual Studio .NET I receive the following error "The default Web access mode for this project is set to file share, but the project folder at 'http://www.spencerteck.com' cannot be opened with the path '\\www.spencerteck.com\wwwroot$\'. The error returned was: Unable to create Web project '/'. The web'/' located on server 'http://www.spencerteck.com' does not exist.'. Well, unfortunately since I am not really familiar with developing this way yet I could use any advice that anyone can offer.
|
|
|
|
|
|
currently am developing a inventory control system for my friend using visual studio 2003 and am using ms access as the back end. I don't want to use any wizard so am doing everything by coding.
but i don't know how to update a access data base using oledb commands. I tried many ways but its giving me errors . Is there any way to do this without using wizards , will I be able to update the table using oledb commands . Please help me I will Be waiting for your reply.
|
|
|
|
|
|
|
I want to access an Access database, try catch block gave me the error that "syntax error in INSERT INTO statement" while I'm sure that the syntax is true!! what is the problem I don't know!! I need to insert data into that database, plz help!! thx
|
|
|
|
|
|
This problem is happening for all the programmers that are on the “local” network and it’s happening for both Visual Studio 2003 and 2005 users.
There are web services that are hosted on the “local” intranet.
If the user is in Visual Studio and the user is Debugging, any web service the program is trying to access gives a time out error.
Now if you run the application in release mode (Ctrl + F5), (or its .EXE file) it will work just fine.
Now if you have the web service hosted on the local PC it works just fine.
If you hit a web service hosted on the net (Google search for example) it works just fine.
It’s just when the “local” intranet web services are called.
|
|
|
|
|
|
|
I run Visual Studio 2003 and 2005 versions with .NET Framework 1.1 and 2.0 running. I actually installed IIS first before every other installations. Please help. It's urgent
|
|
|
|
|
|
|
Hello thanks for looking at my question, my last question had a great turn out so i've decided to ask another, and again it's probably extremely simple (but difficult for me!). I've had a few people tell me that you can find the entire C# function (Command) library in visual studio. however, i can't seem to find it to access it. if anyone could tell me what exactly i do with visual studio (I'm using visual studio C# 2005) to get to the C# function list, it would be appreciated. however, if you aren't sure about visual studio, but know a good online resource for C# (Specifically functions as they are what i am looking for) please post those as well! thanks in advance!
|
|
|
|
|
|
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 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.
|
|
|
|
|
|
I have created a windows form application project in visual studio 2005 that consists of many forms.In one of the forms I need to have access to what has been written in a previous form by the user.how can I do so?(using c++)
Thanks a lot
|
|
|
|
|
|
|
I need to find a code example demonstrating an effective way to populate an array (Single()) with values from a sequential access file (example.txt). This is in VB.NET compiled in Visual Studio 2005
|
|
|
|
|
|
I'm trying to access struct instances declared at my main code file (where the main is located). I'm using a global pointer, also declared at my main code file to try to access them.
This is from my Form.h code.
private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) {
lsbRQProcNum->Items->Add(TEMPRQ->process... //ListBox
lsbRQDesc->Items->Add(TEMPRQ->descriptio...
lsbRQReqTime->Items->Add(TEMPRQ->totalti...
}
I get these errors:
Error 1 error C2065: 'TEMPRQ' : undeclared identifier c:\users\xavier\documents\vis... studio 2005\projects\cpu sim\cpu sim\Form1.h 360
Error 2 error C2227: left of '->processnum' must point to class/struct/union/generic type c:\users\xavier\documents\visual studio 2005\projects\cpu sim\cpu sim\Form1.h 360
I'll appreciate some help, thanks
|
|
|
|
|
|
I am using visual studio 2005 and i have a visual basic project that
is connected to database . i am using access2003 .I wanna create a
search button in my form that searches the table according to the
record given by user in a given text box and then shows the other
information(columns)in that form.(e.g. there is an employee table
containing the three fields empid and empname and empphone.we present
the user a form with 3 text boxes for each field and a button
whenever user fill an ID in the text box and click the button other
conserning information of that employee should appiear in other 2 text
boxes)
It may be very simple but i am a begginer help me. Please tell me how
to do that. I know it can be done by some query but please tell me how to execute that query.
THANK YOU IN ADVANCE
|
|
|
|
|
|
Hi,
Iam using dot net 2.0 framework.
I created one website on the local system named 'website1'. And also created virtual directory for this site.
But once i started accessing it in the browser i got the following error:
http://localhost/website1/
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'C:\Documents and Settings\lakshmi.bysani\My Documents\Visual Studio 2005\WebSites' because access is denied.
Source Error:
[No relevant source lines]
Source File: C:\Documents and Settings\lakshmi.bysani\My Documents\Visual Studio 2005\WebSites\web.config Line: 0
So, let me know the solution for this problem.
Thankyou
|
|
|
|
|
|
|
I want to have different folders accessable to different people for previewing their artwork (which I will store in their folder). In frontpage 2003, what is the best way to go about this. I do have visual studio 2005 pro... if that has more features, I can use it instead.
|
|
|
|
|
|
I just installed IIS 5.0 and want to use the aspnet_regiis.exe command utility to register ASP.Net file mappings with IIS.
According to the asp.net book I have, the directory of the utility is:
C:\Program Files\Microsoft.NET\Framework\[Version]\... -i
However, when I checked the directory, there is no Framework folder inside the Microsoft.NET folder.
I have installed MS Visual Studio 2005 before installing IIS. Is there a way to access the utility?
|
|
|
|
|