|
Dammit man! You caught me again!
I'm gonna have to slow down and think about what I'm posting.
(Thanks for your correction.)
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
EricDV wrote: You caught me again!
No problem
EricDV wrote: I'm gonna have to slow down and think about what I'm posting.
Don't worry about it - It happens from time-to-time.
|
|
|
|
|
That sounds like what I need... how do I do that?
Many thanks,
A
|
|
|
|
|
|
Thanks every so much Colin and Eric. I think you've fixed me.
Best regards,
Alice
|
|
|
|
|
Hello im confused. i do not understand the difference between
ADO, SQL, ACCESS, MICROSOFT SQL SERVER, VBA
i need to develop data-base project and do not know where to start and what is the newest methoods
thank you
|
|
|
|
|
Haoman17 wrote: ADO
ActiveX data objects
Haoman17 wrote: SQL
Structured Query Language
Haoman17 wrote: ACCESS
A desktop database procuct by Microsoft
Haoman17 wrote: MICROSOFT SQL SERVER
A server database product by Microsoft
Haoman17 wrote: VBA
Visual Basic for Applications.
Haoman17 wrote: i need to develop data-base project and do not know where to start and what is the newest methoods
SQL Server 2005 with Visual Studio 2005 using C# or VB.NET
Start with SQL Server 2005 Express (it is free) and one of the Visual Studio Express editions (they are free also)
|
|
|
|
|
Thank you, but i dont understand, should i use sql or ado?
|
|
|
|
|
In the nicest possible fashion, if you don't know what these are, you probably should get some reading material before embarking on a database project...
ADO is a method used to connect to a database (superseded by ADO.net in the .net suite of languages).
Friday afternoons - should connect brain before thinking...
ADO contains a set of functions that are used to connect to and query a database. (ADO.net is the newer version of this).
SQL is a language used within a database to query the data.
|
|
|
|
|
You should use ADO.NET. You will also use SQL because ADO.NET is a way of sending SQL from a .NET application to a database.
|
|
|
|
|
Well, then there is NJDX, which is beyond ADO and SQL.
Damodar Periwal
Software Tree, Inc.
Simplify Data Integration
http://www.softwaretree.com
|
|
|
|
|
|
i not sure wat this error mean it just not working with my SQL
ODBC: Msg 0, Level 19, State 1<br />
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.<br />
<br />
Connection Broken
Here is my SQL command, the underline code which i added then the error came out. B4 add the command so working correctly
SELECT Query1.bizdate, TSuper,TSoft, THard, (TSoft+ THard+ TSuper) as TOTAL ,<br />
((TSoft+ THard+ TSuper)-(TsCost+ThCost+TsuCost))as GP <br />
FROM <br />
(SELECT bizdate, SUM(totalsales+returnamt) AS TSoft ,sum(totalcost+returncost)as TsCost FROM tot_item WHERE deptcode IN (11, 12, 13, 14, 15, 16, 17) <br />
GROUP BY bizdate) AS Query1<br />
<br />
LEFT JOIN (SELECT bizdate, SUM(totalsales+returnamt) AS THard ,sum(totalcost+returncost)as ThCost FROM tot_item WHERE deptcode IN (21, 22, 23, 24, 25, 26, 27, 28, 29) <br />
GROUP BY bizdate) AS Query2 ON Query1.bizdate = Query2.bizdate<br />
LEFT JOIN (SELECT bizdate, sum(totalsales+returnamt) AS TSuper ,sum(totalcost+returncost)as TsuCost FROM tot_item WHERE deptcode IN (30, 40, 50, 60, 70, 80, 90) <br />
GROUP BY bizdate) AS Query3 ON Query1.bizdate = Query3.bizdate<br />
<br />
where query1.bizdate>= '2006-10-01' and query1.bizdate<= '2006-10-15'<br />
order by query1.bizdate
|
|
|
|
|
Contact Microsoft support. There's a bug somewhere in your copy of SQL Server which is causing an error to occur in the database engine.
You should first ensure that you're running one of the supported service packs. For SQL Server 2000 this is SP3a or SP4, for SQL Server 2005 it's either the original (RTM) release or SP1.
|
|
|
|
|
Mike what you pointed out could be the reason. But this need not be the so in this case. MS KB Article ID: 892451 might have been what you were referring to. The dump also occurs in case of excessive memory usage.
Thanks and Regards,
Aby
|
|
|
|
|
I am using xml(.) datatype in sql ser 2005
I want to get the value as string without using dataset
because the data is very huge, if i took by dataset the end values were truncated
i want to get the value directly inside a stored procedure and to pass the value as an input to openXML in the same stored procedure
Please guide me
-
|
|
|
|
|
Hi All,
Glad to be here!
Very strange results from DataReader... I'm using the code from MS examples to populate ListBox with items from SQL 2000 CE 2.0 data file. And if "n" is number of records in database I always get "n-1" records from DataReader!
Otherwise, DataSet returns all needed records with the same SQL string!
I'm on VB.Net 2005
Thanks in advance!
|
|
|
|
|
Can you provide an example of the code populating the ListBox with a DataReader?
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
Hope its help...
Private Sub PopulateFindList(ByVal strField As String, ByVal strWhat As String)<br />
With Me.ListFind<br />
.DataSource = Nothing<br />
.Items.Clear()<br />
End With<br />
Cursor.Current = Cursors.WaitCursor<br />
ceConn = New SqlCeConnection(conSqlConnection)<br />
ceConn.Open()<br />
Dim strSQL As String = "SELECT " & strField & " FROM Customer WHERE " & strField & _<br />
" LIKE '%" & strWhat & "%'" & " GROUP BY " & _<br />
strField & " ORDER BY " & strField & " ASC"<br />
Dim ceCmd As SqlCeCommand = New SqlCeCommand(strSQL, ceConn)<br />
ceReader = ceCmd.ExecuteReader(CommandBehavior.CloseConnection)<br />
If ceReader.Read Then<br />
While ceReader.Read()<br />
ListFind.Items.Add(Mid(CStr(ceReader(strField)), 1, 30))<br />
End While<br />
End If<br />
Cursor.Current = Cursors.Default<br />
ceReader.Close()<br />
ceReader = Nothing<br />
ceConn.Close()<br />
ceConn = Nothing<br />
End Sub
|
|
|
|
|
MrRedLion wrote: If ceReader.Read Then
While ceReader.Read()
ListFind.Items.Add(Mid(CStr(ceReader(strField)), 1, 30))
End While
End If
Your problem is here. Every time you call Read() it moves onto the next row in the result set. Your If statement is effectively skipping the first row. All you need is the While loop because it will never loop if the very first call of Read() returns false (indicating there are no rows returned). So, remove the If statement.
|
|
|
|
|
Thank You Colin,
I'll try...
|
|
|
|
|
hello all ,
whene i write data in webapplication and i want to this dat6a to recording in the data base and this data are in arabic languag this data recorded in data base but the word which is arabic recorded lik this ??????? and i want the data bas to read the arabic languag
|
|
|
|
|
I beleive, You should check International Settings of the PC where You run your application! I'm working with Hebrew data and it looks quite well!
|
|
|
|
|
difference between delete, truncate and drop in sql server
-
|
|
|
|
|