Interview Question in Database |
|
|
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.
|
|
|
|
|
Hello All
I am developing a site in ASP.Net2, C#.Net and SQLServer. It is running when I run this website from the Visual Studio 2005 environment. It uses inbuilt ASP.Net Server
But I am trying to run from the IIS it giving an error "System.Data.SqlClient.SqlException: Login failed for user 'ABCD\ASPNET'."
It shows when try to create connection with the SQLServer2000. Code is as follow
Dim myCon as new SQLConnection
myCon.ConnectionString=strConnectionst...
myCon.Open ---> Here giving error.
I am using
Database=SQLServer2000
Operating System=WinXP
Framework=2
Visual Studio 2005
thanks
|
|
|
|
|
|
Hello All
I am developing a site in ASP.Net2, C#.Net and SQLServer. It is running when I run this website from the Visual Studio 2005 environment. It uses inbuilt ASP.Net Server
But I am trying to run from the IIS it giving an error "System.Data.SqlClient.SqlException: Login failed for user 'ABCD\ASPNET'."
It shows when try to create connection with the SQLServer2000. Code is as follow
Dim myCon as new SQLConnection
myCon.ConnectionString=strConnectionst...
myCon.Open ---> Here giving error.
I am using
Database=SQLServer2000
Operating System=WinXP
Framework=2
Visual Studio 2005
thanks
|
|
|
|
|
|
|
Where can I get free hosting for a personal site I made for my class section? Needs Microsoft Database support and ASP support because it is written in Visual Studio 2005. Thannks.
|
|
|
|
|
|
Visual Studio 2005 was upgraded to support all the new features introduced in .NET Framework 2.0, including generics and ASP.NET 2.0. The IntelliSense feature in Visual Studio was upgraded for generics and new project types were added to support ASP.NET web services. Visual Studio 2005 also includes a local web server, separate from IIS, that can be used to host ASP.NET applications during development and testing. It also supports all SQL Server 2005 databases. Database designers were upgraded to support the ADO.NET 2.0, which is included with .NET Framework 2.0. C++ also got a similar upgrade with the addition of C++/CLI which is slated to replace the use of Managed C++.[6]
Other new features of Visual Studio 2005 include the "Deployment Designer" which allows application designs to be validated before deployments, an improved environment for web publishing when combined with ASP.NET 2.0 and load testing to see application performance under various sorts of user loads.
Visual Studio 2005 also added extensive 64-bit support. While the development environment itself is only available as a 32-bit application, Visual C++ 2005 supports compiling for x86-64 (AMD64 and Intel 64) as well as IA-64 (Itanium).[7] The Platform SDK included 64-bit compilers and 64-bit versions of the libraries.
Visual Studio 2005 is available in several editions, which are significantly different from previous versions: Express, Standard, Professional, Tools for Office, and a set of five Visual Studio Team System Editions. The latter are provided in conjunction with MSDN Premium subscriptions, covering four major roles of software development: Architects, Software Developers, Testers, and Database Professionals. The combined functionality of the four Team System Editions is provided in a Team Suite Edition.
for your information VS 2008 beta is already i trial
|
|
|
|
|
|
How can i connect my DB2 Dtabase in my ASP .Net Project??
Pls. help me!! It will be a lot!!
|
|
|
|
|
|
|
Does any body knows how to connect to database in visual studio2005 in VS 2003 we use OLEDB adapter wht to use in 2005 version?
|
|
|
|
|
|
Looking at my post you will see I am a newbie to Visual Studio 2005, I was just playing around with data access and a little project came to mind
I have on my website
GridView1, txtName and btnSearch on the web page
I have a Microsoft Access Database called runnersdb it has a table called Runners
In the table called Runners I have a list of names of people
On the website I want to enter for example Jam and click search
As a result the gridview should show results such as James, Jamie, Jamali etc i.e. I want to make use of the LIKE command in SQL
Can you please help with the code I would need
Thanks
|
|
|
|
|
|
|
I have Access 2007. will it be enough to use as back-end for Visual Basic 2005. or are there any other database software that are good to use as back-end for Visual Basic 2005.
|
|
|
|
|
|
Getting syntax error in INSERT TO statement. That is all the information I get. Here is my code. Parameters are set after last statement
Dim Cmd As OleDb.OleDbCommand
Dim Con As OleDb.OleDbConnection
Dim Sql As String = Nothing
Con = New OleDb.OleDbConnection("Provider=Microsof... source=" & "C:\Documents and Settings\MPAXTON1\My Documents\Visual Studio 2008\Projects\GunLog\GunLog\TeklogixRetu... & "")
Sql = "INSERT INTO GunLog(date, sc_num, wh_id, gun, model, send_tek, sendRMA, return_tek, returnRMA, problem, employee, call_tek, tek_assoc, tek_sc) VALUES (@date, @sc_num, @wh_id, @gun, @model, @send_tek, @sendRMA, @return_tek, @returnRMA, @problem, @employee, @call_tek, @tek_assoc, @tek_sc)"
Cmd = New OleDb.OleDbCommand(Sql, Con)
|
|
|
|
|
|
|
I am now starting to learn Visual Basic .NET using Visual Studio 2008 Express as my IDE. I am focused in Database programming. I am worried that this language again have it's new version. Do the everchanging technology will supersede my knowledge? Please advise me with this matter.
|
|
|
|
|
|
Using Microsoft Visual studio Pro 2008 On Vista Ultimate
On page 443 (Actual Page #) of this ebook the instructions say to:
1. On the Data menu, click the Add New Data Source command.
2. Click the Database icon (if it is not already selected) in the Data Source Configuration Wizard, and then click Next.
3. Click the New Connection button.
4. Click Microsoft Access Database File, and then click OK.
The ebook says to use the browse button on the resulting form to open the students.mdb file, however, in practice I do not get the option to browse.
Have I done something wrong or has something been installed wrong in visual studio pro.
Please help, I would like to finish this course.
|
|
|
|
|
|
|
I am learning Database programming VB.NET and I am now more interested to go more deep study. My problem is my copy of Visual Studio 2008 is only downloaded version and I have 20 days left to use it. Please help me on what to do. I have no money to purchase a copy. Hope you understand a beginner like me.....I am calling all like once me before.
|
|
|
|
|
|
|
To those who are once like me before, please help me. I want to become a good databas programmer. Can I download it again with the same PC? What can I do so I can have a copy again so I can continue my study in Visual Basic 2008 Database Programming. Please give some options. You can send email also to mvglassalum@yahoo.com.ph.
|
|
|
|
|
|
Hw do I plan & devlop a model by which my company can adopt & use CRM in its strategical & oprtnal functn.
2ndly, I also want 2 create a Customer Database 2 my organization using Ms Excel & Access
|
|
|
|
|
|
|
I need to get the full ERD...
|
|
|
|
|
|
I am 9 years experienced Systems admin also managing databases for different client/server based applications. Recently I've done MCDBA and my company needs more proficient in MS SQL 2000. Though I am already doing DBA job but want to be specific in Database Admintration and want to switch or promote to Datbase Adminitrator Designation instead of Systems Admin. Can you please help me what exactly should I concentrate more to have my goal achieve which let me have my goal achieved in job prospect and I could also be more relieable person for my company. I would expect answer most likely in which kind of duties and what type responsibilite I need to take care.
Experts/Expereinced opinion will be great for career choice...Thanks A lot..
|
|
|
|
|
|
I'm am using this SQL statement on my .asp (classic) page to order records by their server name:
SELECT *
FROM ProdServers
ORDER BY Server Name / OS / DNS Alias
But it is returning these two errors:
When I click test (ultradev):
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Server Name / DNS Alias'
When I try and test it on the server I get this error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Server Name / OS / DNS Alias'.
/SORTTESTprod_servers.asp, line 10
It doesn't make any sense that it wants line 10 because:
ecordset1.Open() ??
What are your thoughts?
Oh, I'm using a Microsoft 2000 Database, and the primary key column is ID
|
|
|
|
|
|
|
I am using Microsoft SQL Server 2000 (MSDE) and Microsoft Access 2003. I am using the onNotInList event for a combo box on a form. i got a snippet of code that allows you to add a value to a combo box/table if it does not exist. The problem is there is a line of vbcode from the snippet that says "Dim db As Database". "Database does not exist! The combo box is based on a table. Can anyone please show me either how do i get this snippet to work or show me a snippet that allows me to add new values to a combo box/table.
|
|
|
|
|
|
|
Is is possible to create a percentage graph in Visual Studio. Net 2003? The graph is not fixed. It will depends on the percentage that is retrieved from the SQL Server 2000 Database and the graph will display the number of passes/failures on the user interface.
|
|
|
|
|