|
Nvm Thankyou and I had it all the time but it was buried in some folders.
Amazing what *.* will do in search. LOL ;P
<marquee>Universal Project... Soon to be a .net
|
|
|
|
|
MindNets
“MindNets” is an organization that is being established for providing support and solution in different fields of IT/Computer Science.
Our Expertise includes:
Web Design and Development, Databases, Networks, Desktop Applications, Business Applications, Image Processing, Biometrics, Science and Engineering.
For Students:
During our final projects, we found that there is very little guidance for students; in working on their projects (software) using latest tools and technologies. This is where the whole idea came to our mind and became the basis of “MindNets”.
For Companies:
In this era, for each and every organization; it’s necessary to transfer its business online. This is so, because it not only helps in expanding the business but also in providing more facilities to the customers.
For this we are providing complete web site design, development and hosting facilities. We are also looking forward to facilitate these companies in building and maintaining efficient LAN/WAN networks.
So feel free to contact us at any time; you need us; as we are to help YOU.
Team:
Khurram Ishtiaq Qazi (Netsol)
(c++, visual c++, java, Oracle 8i, (sql/plsql, Developer6))
Asim Nazir (XavorInt)
(c++, java, visual c#, ASP.NET, Sqlserver 2000, Crystal Reports)
Irfan Yousaf (ICBCS)
(VB6, ASP, VB.NET, ASP.NET, Oracle, Visual C++, Visual Prolog)
Mohsin Ali (TWE)
(Microsoft Certified Solution Developer (MCSD), VB6, Flash)
Aamir Alla-u-Din (Operation Al-Badar)
(Microsoft Certified System Engineer (MCSE NT+2000), CCNA)
Contact:
Mail: mind_nets@yahoo.com
Voice: 0333-4294413
MindNets
|
|
|
|
|
Please help. When I use @From it fails with the following error , but at the same time when I spesify date is runs fine.
"The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value."
Declare @From as varchar(10)
Set @From =(case When DatePart (dw , getdate())=2 Then convert(varchar(10),(getDate()-3),101)
When DatePart (dw , getdate())=4 Then convert(varchar(10),(getDate()-2),101)
When DatePart (dw , getdate())=6 Then convert(varchar(10),(getDate()-2),101)
Else convert(varchar(10),(getdate()),101) End )
select @From
select dateentered
from NormalizedData_Out n join MaxDate_Out m
on n.StudentID= m.StudentID and (isnull(n.DateEntered, '1/1/1900') =isnull(m.maxdate, '1/1/1900'))
and n.dateentered between @From and getdate()
--and n.dateentered between '08/27/2003' and getdate()
|
|
|
|
|
Either declare @From as datatype smalldatetime, not varchar or use Convert(smalldatetime,@From,101) in the where clause.
onwards and upwards...
|
|
|
|
|
I try to run a sql file in my program. But I got an OleDbException of "TimeOut Expired". When I try the sql file in Query Analyzer, it's running very well.
Can anyone please tell me why???? waiting online.
Thanks in advance!
|
|
|
|
|
The OleDbCommand object has a CommandTimeout property, which defaults to 30 seconds. If your query takes longer than this to execute, it will abort.
Either try to improve the performance of the query, or increase the CommandTimeout.
Query Analyzer just keeps running until the query completes or you choose to abort it.
|
|
|
|
|
I am using VB.Net to build a windows form with a datagrid. is there a way to calculate a value in on column based off a value in another column?
|
|
|
|
|
The DataColumn object can be used to create an expression column:
productsTable.Columns.Add("SubTotal", Type.GetType("System.Single"), "Sum(Price)")
Hope this helps.
Andy
|
|
|
|
|
Hi, I run a sql file using ADO.Net and count the run time. But strangely, for the exactly same environment, same sql, but the run time are different. sometimes it has more than 30 seconds' differece. For example, first time it took 2 mins and 31 secondes, the next time it took only 1 minute and 54 seconds. Can anyone please tell me why and how to avoid this happens?
Thanks in advance.
|
|
|
|
|
What are you running the file against?
Queries in MS SQL Server can have different run durations as a result of SQL Server caching the data. (ie. keeping it in memory, rather than the timeconsuming task of reading it from disk,)
|
|
|
|
|
Thanks. I think that's the reason.
|
|
|
|
|
Also, if it's the exact same script, SQL Server will likely have cached the execution plan.
There's a compilation stage in each query where SQL Server decides which logical operators it will use to correspond to your query text. I was recently a little surprised to find that SQL Server often uses the Inner Join logical operation to implement the IN clause of a query. SQL Server terms this the execution plan.
If it can detect that you've used the same query, or one that only varies slightly (e.g. you've changed a value in a WHERE clause) it will reuse the cached execution plan. It might decide to try again if you've added some indexes or a whole load of new data which might change how useful the existing indexes are.
|
|
|
|
|
Hi
how can I get a list of tables from a database by using
the CADO Classes from Carlos Antollin?http://www.codeproject.com/database/caaadoclass1.asp)
Greetings
Thomas
|
|
|
|
|
Running this query will give you the names of all tables...
<br />
SELECT table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE'select * from information_schema.tables<br />
|
|
|
|
|
Firstly hi to all,
I want to learn is there anyone or anyplace that has all countries' icon flags in jpg or gif files.
I mean for example: for United States US.jpg for United Kingdom UK.jpg for Turkey TR.jpg.
I want like this since I've collected these countries in short forms to SQL and I want to call these images by /folder/(user.Country)"+".jpg"
Is there any better way to do this?
Any help will be appriciated
Arda
-
When in doubt, push a pawn!
-
|
|
|
|
|
I have a simple datagrid that i want to add a combo box to on e of the columns but can't find any information on how. Any help will be a start.
Chris
|
|
|
|
|
hi,
Firstly if you are using VS.NET right click the datagrid and select Edit Template and then click Item Template. Datagrid's apperance will change and then drag and drop the box(es) to the Item Template(the very first row). Finally right click the datagrid again and then select End Template Editing.
If you want further information and some simple dynamic codes for selecting a row here is the link that I know http://www.dotnetbips.com/displayarticle.aspx?id=147
Kind Regards,
-
When in doubt, push a pawn!
-
|
|
|
|
|
I do not see the "edit template" functionality. This is a datagrid in a window form, does that matter?
|
|
|
|
|
oh absolutely in windows applications it changes but I don't know about them.
Hope you can find a solution.
Kromozom
-
When in doubt, push a pawn!
-
|
|
|
|
|
I'm using asp.net, c#, and Sql Server. I'm calling a sp, and I'm getting an error back. I have the "ExecuteNonQuery" wrapped in a try/catch. I fall into my catch, but what is the best way to find out which column I'm getting a unique constraint error on?
I'm checking SqlException from my catch, and I notice that the SqlException.Number==2627. I also look in the SqlException.Message, and it has some good text in it.
The sp is inserting into a couple of tables, which each have a unique constraint on them.
Do I need to parse the SqlException.Message? Is there a cleaner way?
Thanks in advance,
|
|
|
|
|
when i search using ado's seek method on a multi- column index if the data entered matches partially the method returns true
example: an access table with an index consisting of first and lastname when i use the ADO seek method it finds a record even if i only eneter a firstname that exist and leave the last name blank
|
|
|
|
|
This is a wierd one!
I'm trying to use a transaction, when I try to execute the command I get the following error:-
The transaction assigned to this command must be the most nested pending local transaction
I've looked on the web and MSDN and can't find a reference to this error! Anyone got any ideas?
Dim myTrans As OleDbTransaction = conn.BeginTransaction(IsolationLevel.ReadCommitted)<br />
Command.Transaction = myTrans<br />
'Try<br />
myTrans.Begin()<br />
If UniqueID > 0 Then<br />
'it exists so update it<br />
Command.CommandText = "UPDATE PCLEquipment SET NoOff=NoOff+1 WHERE UniqueID=" & UniqueID<br />
Command.ExecuteNonQuery() 'FAILS HERE<br />
Else<br />
'it doesn't so add it<br />
Command.CommandText = "INSERT INTO PCLEquipment(PlayerID,EquipmentID,NoOff) VALUES(" & PlayerID & "," & ItemID & ",1)"<br />
Command.ExecuteNonQuery() 'FAILS HERE<br />
End If<br />
'subtract cost<br />
SpendMoney(Command, Money, PlayerID)<br />
myTrans.Commit()
|
|
|
|
|
Hi Lee
You have already started a transaction by calling the "conn.BeginTransaction" method - try removing the call to "myTrans.Begin" (which is used to created nested transactions).
Hope this helps.
Andy
|
|
|
|
|
Durr! <slaps himself="" on="" forehead=""> 
Thanks Andy
|
|
|
|
|
Hi,
our website is presently using Access as it's database. We are planning to redesign our website and we'd like to improve our database system. So I have a few questions:
1) What version should we use? 97, 2000 or 2002? Why?
2) Should we use Jet drivers or Access drivers (DRIVER={Microsoft Access Driver (*.mdb)}; )? I guess that questions 1 and 2 are related...
3) Is there a proper way to open and close a connection? For example, should I open a connection at the beginning of a page, let the recordsets found in the code use the same connection, and close that connection at the end of the page, when I'm done with it? Or should I use may different connections (like 1 connection for each recordset)?
Any other info/links are welcomed!
Thanks! 
---------------
Tired of Spam? InboxShield 2.0.2 for Microsoft® Outlook® 2K/2K2/2K3
http://www.inboxshield.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
