2,951 Posted Topics
 | that will depend on how the image is stored in the database 1. if you are storing only the file path You need to retrieve the path from Db and point to the same from Picture Box. 2. if the image is stored as a binary stream. retrieve the stream …  |
| | |
| | |
| | |
| |  |
| | |
| | Why not handle that part using SQL. Checking data in a loop is going to kill the performance. |
| | i really do not understand what you are trying to do. the query is doing exactly what is it is written for. |
| | Why not use a dynamic parametrized dynamic SQL to handle the requirement.  |
| | since you are using [B]GROUP BY[/B] clause , you need to use some grouping function as part of the select list. |
| | please go through [URL="http://www.oracle.com/technetwork/database/migration/sqlserver-095136.html"]this[/URL] , [URL="http://download.oracle.com/docs/cd/B10501_01/win.920/a97248.pdf"]this[/URL] and [URL="http://st-curriculum.oracle.com/obe/db/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm"]this[/URL]. |
| | Re: NULL Values That should work, ensure that you are using where clause on the proper column. Also check if the column contains any white spaces. |
| | |
| | It is really difficult to guess what is happening in your system blindly. |
| | simply try this [CODE]SELECT CURDATE() - 10[/CODE] read more [URL="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html"]here[/URL] and [URL="http://dev.mysql.com/doc/refman/5.1/en/datetime.html"]here[/URL] . |
| | what is the exact table structure ? |
| | |
| | Check if the file open while you are trying to write to it. |
| | to which property of the object you are assigning that string ?  |
| | What is a GIS project ? What kind of data you are going to store in the DB ? What is the front end application /language you are using / planning to use ? |
| | Simply because you are taking the count after adding more records. |
 | does your data contains comma (,) other than the delimiter. |
| | |
| | |
 | |
| | [QUOTE=Arjun_Sarankulu;1576657]it gives 0.04890 And i think it should be 0.04890 [/QUOTE] If you are getting what is expected, what is the problem ? |
| | If you are opening the picture in any browser, check for [B]zoom[/B] settings. |
 | |
| | |
| | |
| | what have you done so far ? Do you have any code that you are working on ? |
| | |
| | what exactly you are storing in the table ? table structure please. |
| | May be you can store system shutdown time into registry or any other location and read the same on system start up. If the difference is < 30 mins call the shutdown routine again. |
| | You can't do that, if you do not have Access. |
| | do you have any code that you are working on ?  |
| | Hi Airil Hafiiz. Welcome to Daniweb. |
| | Re: query woes You are not inserting the Id columns (authorID, publisherID,..............) into any of the tables. check your insert statements. |
| | I think the values in the column UpperBound & LowerBound are reversed. Regarding your SQL, why not use between operator. |
| | Trying to implement many-to-many is impractical. It can't be implemented in any database. |
| | Re: class query With the information provided by you, i can only suggest you to read books for all the details. |
| | |
| | I don't open rapidshare for any coding not do i send solutions by mail. |
| | You can try to use [B]Base64[/B] encoding. |
 | I really do not understand your code. can you please explain line #4 and #5 . |
| | |
| | 1. You can create a view based on the records of the JOIN between the relevant tables for the purpose of search. 2. While updating you need to update only one master table by pulling / selecting record from the above mentioned view. |
| | Re: Foreign Keys authorID in the books table is the foreign key in Books table which refers to the primary key of the Author table. |
| | Try [URL="http://www.google.co.in/search?hl=&q=SSRS+Presentation&sourceid=navclient-ff&rlz=1B3GGLL_enIN395IN395&ie=UTF-8"]this[/URL]. |
 |
The End.