madani

From Project->Reference ,add Microsoft SQLDMO Library Backup Private Sub Command1_Click() Dim SQLSvr As SQLDMO.SQLServer Dim Backup As SQLDMO.Backup Set SQLSvr = New SQLDMO.SQLServer Set Backup = New SQLDMO.Backup SQLSvr.Connect "myserver", "username", "passwo…

The MVC (Model,View,Control) design pattern is a good way of achieving this objective.It is always better to leave JSP for presentation only in order to simplify the web design tasks.A servlet or more could be used to control the data flow from the user input …

the varcvhar values will have the exact time .for example 4.12 is 4 hours and 12 minutes.this is in my first reply. just sum the values of this varchar field after casting it as shown in my second repy (change g with your varch field name) and you will get the…

When you are creating a new database ,there is something called collation name that allows you to choose the language (available in 2000 but not sure of its name in 7) just select Arabic_CI_AI from the list and your database will have arabic support Madani

Use sp_execute_sql to evaluate the sql query and pass the list of ids as a string.this list will get evaluated inside the query CREATE PROCEDURE test @list varchar(500) as DECLARE @query NVARCHAR(500) Set @query = N'Select*From table Where Id in (' + @list + '…

Use sp_executesql .call this procedure from your code to evaluate the sql query CREATE PROCEDURE test @tablename char(10) as DECLARE @query NVARCHAR(500) Set @query = N'Select*From ' + @tablename EXEC sp_executesql @query GO executing : test "Students" is equa…

XML is not a real database in terms of storage capabilities and should not be used for that purpose.It is a vehicle for exchanging data between applications .For instance ,a client application might get a list of products in xml format by sending a sql query t…

use cast to get a decimal from the varchar table.also ,you need to understand that 1 hour and 20 minutes is not 1.20 ,so we need to get the representation of the hours in decimal .for example 1 hour and 20 minutes is equal to 1.33 since a 20 minute is a third …

Use object serialization to serilaize your linked list to a file.You need to create a FileOutputStream and use it to initialise a ObjectOutputStream.Then calling the method writeObject and passing your linked list as a parameter will store your object. Madani

retrieve the primary key of the newly created record and store it in the session.Then when the employee logoff ,update the row the newly created record id can be returned in sql server using @@IDENTITY which can be done from a stored procedure

All you need to know is the IP address of the sql server (or computer name if using LAN) , sql server is totally different from MS Access

You need to change the connection string used to connect crystal reports with the sql server,and also make sure that you are using the computer name and not localhost since the other computers are clients and not servers.

You could use simple calculation to get the hours and minutes and then convert them to a string and store in another field Select TimeInMinutesAndHours = CAST(SUM(DATEDIFF(n, datein, dateout))/60 as varchar) + '.' + CAST(SUM(DATEDIFF(n, datein, dateout)) - (SU…

You can do that using ADO RecordSet Dim rs as new RecordSet Set rs = new RecordSet rs.open "Select*from Table","Provider=SQLOLEDB;Server=154.87.45.20;uid=sa;pwd=;database=MyDatabase",3,3 change 154.87.45.20 to your SQL Server IP Address or computer name if usi…

Salah, the best way to populate a jtable is to use the constructor JTable(Vector data,Vector headers); the data vector is Vector filled with Vector for each row.So you could go through the resultset and add the string to a vector and then add that vector to th…

IBM Websphere is a J2EE Server that has been in the market for a long time and was not developped to compute against the .NET since the .NET arrived in the market just few months ago while J2EE is a mature technology (more than 5 years).Websphere is one of the…

You need to have a seperate asp page for reading the image from the database and then use it as the source of the image tag 1 Read the image from database image.asp <% Set rs = Server.CreateObject("ADODb.RecordSet") rs.open "select*from Table","Provider=OraOLE…

I can't see any END IF !!!! Another issue is that you do not need to go through all the records, use Filter to check if the file exists in the database For Each f1 in sf Rs.Filter = "filename=" & f.Name IF NOT Rs.EOF THen 'the file exists ELSE 'it does not exi…

To do it from Microsoft Access without using ADO ,just check the checkbox "Inforce referential integrity" and "cascade delete realted records" from the Relashionship Window

Just an addition to brother Mohamed's reply: Always use transaction attributes so that all operations are done or none of them Example: Con.BeginTrans 'delete the product records 'delete the category record Con.CommitTrans this is to ensure that if an error ha…