|
Colin Angus Mackay wrote: Off the top of my head I can't see any difficulties with it.
Thank you
|
|
|
|
|
You can try the same thing with table variables and see if you are having the same problem. At times the table variables are also part of best practice on top of temporary tables.
Sharp
Happy Programming
|
|
|
|
|
i use oledbDataReader for select record from a MS Access database file.
how can i move previous record (or next, last and first record)?
there isn't numeric filed in my table and i don't want use dataset
[i can select first record by "SELECT TOP 1 * FROM table1"]
|
|
|
|
|
hamid_m wrote: use oledbDataReader for select record from a MS Access database file.
how can i move previous record
DataReader is forward only. You can't get the previous record. For this use dataset.
|
|
|
|
|
dataset wast my time
what about recordset?
|
|
|
|
|
hamid_m wrote: what about recordset?
That isn't available in ADO.NET.
If you need to go backwards and you don't want to use a DataSet then you will have to write your own caching mechanism.
Curiously, I've never had the need to be reading rows from a database then needed to re-read some previous row again. What are you doing that requires that you do that?
|
|
|
|
|
i have a table with many records and i have a form that report it to user.
when form loaded, it read last record and show it to user and user have ability to edit, new, delete and move next (disable this case), previous and last and home.
my table is very much so i wast time if i want use dataset(and fill all) therefor i have to use datareader.
|
|
|
|
|
hamid_m wrote: when form loaded, it read last record and show it to user and user have ability to edit, new, delete and move next (disable this case), previous and last and home.
For this situation the Generic Data Classes (that is dataset etc) are ideal. DataReader is one of the *Managed Provider classes* and just reads the rows in forward only direction.
hamid_m wrote: my table is very much so i wast time if i want use dataset(and fill all) therefor i have to use datareader.
Although datasets are slower than datareaders, connecting to the database over and over again, greatly reduces the application's performance. Memory resident data in the form of DataSet and related objects will be a better choice to work with the data. Another good feature of dataset is that they are not specific to any database, and work with any sort of database in the same manner. You should spend a little time to explore DataSet and related classes (that are DataRelation, DataTable, DataView, DataColumn, DataRow etc); other wise the chances of user time wastage by the application may arise.
Regards.
________________________________
Success is not something to wait for, its something to work for.
|
|
|
|
|
thank you uroojkhan, my application will work on network (multi user) so offline databse (dataset) is not perfect for it! is it?
|
|
|
|
|
I have problem to store audio file in database. I am using vb.net & sqlserver. In my project i want to store audio file in database and after I want to retrive this file. I can also want to give some sound effect after retriving(playing from database) the audio file like bass.. and any other. Please help me it's very urgent.
can u give some examples for sql server 2000. I am tried to store audio file using image data type it store data successfully. But in table it looks as some code(number, hex or binary) format not as actual name of that file. and also i can't retrive(play) this file through my vb.net FORM which is just like media player.please help me.it's very urgent.
Thank's  ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
shrikant
|
|
|
|
|
Why did you delete your original question? The one that I answered here[^]
shriku24 wrote: But in table it looks as some code(number, hex or binary) format not as actual name of that file
Because you didn't ask to store the name of the file, you asked to store the file in the database. What you are seeing is the actual file.
shriku24 wrote: i can't retrive(play) this file
I can't help you play the file. This question is in the SQL forum. I can only help you store and retrieve the file from the database. When you retrieve the file from the database you have it already as a raw byte array. From that point onwards you can do anything you want with it.
|
|
|
|
|
Colin Angus Mackay wrote: can only help you store and retrieve the file from the database
Which datatype we need to use for storing files in database ?
|
|
|
|
|
DooDooo wrote: Which datatype we need to use for storing files in database ?
byte[] in .NET
image or varbinary(max) in SQL Server
|
|
|
|
|
Can't get the simplest query to work. I am moving from Coldfusion to ASP.NET and having extreme headaches trying to get the most basic query to run. I want to query one table and pull all rows where the date in one column is equal to the current system date (simple enough). My query is as follows:
<p>
<pre>
SELECT [NoticeDate], [NoticeTitle], [NoticeDetails], [NoticeID]
FROM tbl_notice
WHERE @NoticeDate = 'DateTime.Now'
</pre>
<p>
I have also tried WHERE @NoticeDate = 'GetDate()'
I am using VWD Express (C#) querying a SQL 2005 DB. Thanks.
|
|
|
|
|
If you use something like GetDate or DateTime.Now, you are actually working with a date/time instance. What you need to do is convert the date into a day format and compare that to @NoticeDate.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
briwright wrote: I have also tried WHERE @NoticeDate = 'GetDate()'
Try by saving GETDATE() into local variable and use it for comparision.
DECLARE @curr_datetime datetime<br />
SET @curr_datetime = GETDATE()<br />
<br />
SELECT [NoticeDate], [NoticeTitle], [NoticeDetails], [NoticeID]<br />
FROM tbl_notice<br />
WHERE @NoticeDate = @curr_datetime
Hope this will solve your problem.
Knock out 't' from can't,
You can if you think you can
|
|
|
|
|
Hi,
I'm using a .mdf (&.ldf) sql DB file in my ASP.NET application (it's in \APP_DATA), and I can see in the connection string that it is connected via SQLEXPRESS.
I know I can take the same .mdf file and attach it to MSSQL server and work with the same file under a MSSQL connection.
My question general is: After migrating a DB file from SQLEXPRESS to MSSQL will my DB work as a regular MSSQL DB or it will still have the SQLEXPRESS limitaions?
Thanks
Rafael.
Moreno
|
|
|
|
|
The limitations will most likely be in the software, not the file.
|
|
|
|
|
So if I use the same mdf file via MSSQL I will Not get any SQLEXPRESS Limitations?
Moreno
|
|
|
|
|
Correct.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
|
I Have a MS SQL Store proc, which takes max value of a field from the table for a day ( That field has got date part )and adds 1 if it exists or creates new if it does not exists.
Logic is like this
select a = max ( ID) where ID like (20070321%) /*Denotes March 21 2007*/
if (a is null ) set 200703210001
else a = a+1
insert into table (ID,....) values (a,....)
I am getting primary key violation error occassionaly.
I would like to know, How the SQL Server handles concurrent request for executing storedprocedures.
For example if it is sequential my logic should work fine
else
There can be duplicate values for ID fields.
Please help.
I knew it would end badly when I first met Chris in a Canberra alleyway and he said 'try some - it won't hurt you'..... - Christian Graus on Code Project outages
|
|
|
|
|
If this is in SQL Server 2005, you can wrap it inside a TRY/CATCH block.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi,
Thanks for the reply.
It is SQL 2000 / 7.0
Any other optimal solution
A moment of silence please. A programmer's best friend has passed beyond that great exception in the sky.... - Mark Conger on "The coffee machine has died"
|
|
|
|
|
Well, you could always try something like this:
insert into table1(...)
select @id, @col2, @col3
from table1 where not exists (select id from table1 where id = @id)
Deja View - the feeling that you've seen this post before.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
