o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

[2005] How to insert Hijri (non-Gregorian) date into sqlserver 2005 database -

How can i convert Gregorian date to Hijri (Jalali or Persian) and Hijri to Gregorian and insert it into a smalldatetime column?

 

[2005] How to insert Hijri (non-Gregorian) date into sqlserver 2005 database -
How can i convert Gregorian date to Hijri (Jalali or Persian) and Hijri to Gregorian and insert it into a smalldatetime column?

how to convert Gregorian date into Hijri date -
Hi! can anyone tell me how to convert Gregorian date into Hijri date or vice-versa. thanx

Convert to Hijri Date -
hi friends, I need to convert Gregorian date to Hijri date and back. Can anybody tell me how to do this in VB..?? Can u suggest any links to solve this problem..? Rajesh

How to Convert a Gregorian date to Hijri format -
first of all in vb Access i can convert the date formate as i want . but in .NET How to Convert a Gregorian date to Hijri format thanks for all

Puzzling question on Matching up dates and accounting for double entries -
Hi there, I have two worksheets in one excel file. The First Worksheet is a complete worksheet, and the second is to update the first. First Sheet: 01/01/2005 .....more data..... 02/01/2005 03/01/2005 04/01/2005 05/01/2005 06/01/2005 07/01/2005 08/01/2005 09/01/2005 10/

Converting a Ordinal Date to Gregorian Date -
I have searched for a straightforward approach to the answer to this question, and have been unable to find one. I think certainly there must be a function written to do this, but all I have found and tried have not worked. Is there a straightforward way to convert a Julian Date to a

Problem with sqlserver 2005 -
Problem with sqlserver 2005 i have downloaded visual basic 2005 express edition from here link when i install it asks me to install sqlserver 2005 express edition and i said yes and it installed but now i dont find that sql thing.. how do i opreate it ? is it spose to really

date in access [resolved] -
Hi guys, Two days I am thinking about solvig problem with date in access. I need to work with date, but access dos not know date() function like Excel. I have database where is for every week in first column stated starting date and in the second finishing date. For example 6th week

Setting Configuration parameters -
Is there any way to set the IP1 and IP2 addresses in SQlServer Express to "Enabled" from Visual Basic? I am using .net 2005, and SQLServer 2005 Express. We need to distribute SQLServer Express, and would like to enable those ports without making the users go into the SQ

problem while attaching database with SQLServer2005 -
hello frnds, I have a code in VB 6 that attaches the MDF file of SQL Server 2000 to Sqlserver 2005. when i run it, it runs fine and attach that database successfully. but if i detaches it and again go to attach it then it will gives me error that "Problem while connecting Sqls

SQL Date Issue -
Im having an issue when inserting a date into my sql server table. the table's date column is set to smalldatetime so when i try to insert the date 23/03/2005 into the column, when i look on sql server the field contains 01/01/1900 however if i insert 03/23/2005, when i look o

get record of current date based on specific table -
Table Name = Calendar CalendarDate Year Workweek Workday ............... ....... ...... ...... 30/12/2004 2004 12 4 31/12/2004 2004 12 5 01/01/2005 2005

How to programmatically create connection to SqlServer database -
I have vb.net (2005) business application, dataset created by designer and SQLServer database (SQL Server 2005 Express). User wants to have separated databases for each year; for example DB2005, DB2006, DB2007... and possibility to choose database from application. So I need to pro

error when insert date into SQLserver -
HI all, I use command to insert data to SQl server and in the command has one field is date time. the problem is that when i get text from textbox if it have date format in the textbox it not error but if the textbox is blank it error(datetime fiels in database allownull), so shoul

[VS-2005]Insert and Retrive an Image in SQLServer -
Dear All, How to Insert and Retrive an Image in SQLServer Thanks in Advance

DatagridView accessing SQLserver tables [2005] -
Hey all, I'm using datagridview in order to access to my sqlserver tables. I've tried to change the color of the headers, but couldn't find the property. In addition, a column in my database, that is defined as type DATETIME - have some problem with getting any values. every t

[2005] Can we change the date system of VB calendars -
Hello As you know there are different date systems in the world. (ex: Gregorian, Iranian, Islamic, Chinese, etc.). And there are some components available for each date system. for example Iranian date-time picker, Islamic Month calendar, etc. But I my Q is: Is it possible to m

date validations with ontextchangeevent... -
hi all, I have two textboxes txt1 and txt2... i have to program the ontextchange event and validate the to be date i would be entering ... suppose current system date is 1/4/2005 with above as reference my output should be somewaht like the following table....

Date Problems -
Hi Guys I got a date field with date like 10/25/2005. I need to run an exception query to determine all data not updated for the last 3 days Example I got a record dated 10/25/2005 Todays date is 10/28/2005 When I run this query it must bring up all records with date

[2005] can't enter date in sqlserver 2005 -
Hi im trying to execute sql statement and it gives me error says "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated." and my sql statement is insert into sales(goodscode,ccode,sa

convert access mdb to sqlserver 2005 express -
Is there an easy-to-use tool out there to convert an existing access mdb to a sqlserver 2005 express database ? Thanks

Populate combo box with Mondays date from given date -
Hi, I want to populate a combo box with the Monday's dates from a given date, which the user can select, but not sure where to start? e.g. Stored date = 13/05/2005 The combo box then has listed: - 16/05/2005 23/05/2005 30/05/2005 06/06/2005 etc. etc. Any ideas wo

Strange Date Problem -
Hi all, i am using visual studio 2005 and sql server 2005, i am developing a web application using visual basic 2005. i also let you know that i am in UK. i am having a strange problem. i have got a form from whcih i need to insert the date values into the data base my querystrin

Return Record for each day if any [HALF - RESOLVED] -
hi, got other problem here i need to return detail (like OrderQuantity, SaleQuantity) for each Ordered/Saled day for Specific Product so let say if i had ProductID "a" which got Ordered at '01-06-2005' ,'05-06-2005', '13-06-2005' and Saled at '13-06-2005', '14-06-2005'

[2005] Using SQLServer in a game -
Ok, I've decided to use SQLServer or some kind of MySQL database to store my stats in.. however I am wondering how I do so? I am sure it was installed when I installed everything else, how can I check? and is there anything I need to import? Thanks

SQL SERVER DATABASE In VB .NET 2005 -
I installed vb .net 2005 but in this, sql server database is not showing so how to create a database in sqlserver using vb .net applivcation

Cannot connect to SqlServer Express 2005 using VB 2005 Express -
Hello, I am developing a windows application in Vb 2005 Express and Sql Server express I have created a database in sqlserver called "mydb" I want to connect the desktop VB application to this and create two screens, say employees and projects This seems to be very non-

Special Date problem -
I have a problem I can't figure out my self. Here is the problem... The user write a date From and a date To in 2 textboxes. I wanna get all months who are in these dates. And I also need first date in the month and laste date in the monh. Like this: From: 2006-01-23 To

Date data type and SQL Statements -
Why do dates never return correctly in an SQL query? I have a database where one of the fields in a table is a Date let say the Table name is Events.. the date field name is Event Date. Now If I execute "SELECT * FROM Events WHERE [Event Date]=8/9/2005" it never re

DTS and SQLServer 2005[resolved] -
In short, where has DTS gone and how can I very quickly copy tables, data and sprocs from one server to another?! More crucially, from SQL Server 2005 to SQL Server 2000..... Our technical people, in their infinite wisdom, have upgraded across the board internally from 2000 to 20

Access 97 IIF statement -
Hello, Ok, hopefully you all can help me with this. I have the following SQL SELECT statement: SELECT [C_PROD-089 Availability WorkStatus].StatusDateTime, IIf(Format([StatusDateTime],"hh:nn:ss") Not Between "00:00:00" And "03:59:59",Format([StatusDa

Access IIF statement -
Hello, Ok, hopefully you all can help me with this. I have the following SQL SELECT statement: SELECT [C_PROD-089 Availability WorkStatus].StatusDateTime, IIf(Format([StatusDateTime],"hh:nn:ss") Not Between "00:00:00" And "03:59:59",Format([StatusD

SQLServer 2005 lets me compile invalid Sprocs -
Something I've noticed since moving to SQLServer 2005 and wondered if anyone else had experienced. When I used to write a sproc in 2000 and accidentally spelt a field or table name wrong, when I came to execute the create statement, it would report it and refuse to compile. In 2005

datetime dilemma -
I retrieve a date from a database: v = recordset1.Fields("Since") 'v is a String the value of v, is set to the date format of Windows this is the value of "v": 1-23-2005 (dd/MM/yyyy) but I need it to be 23-1-2005 (MM/dd/yyyy). I basically have the same p

MSChart Basics -
OK, I haven't used MSChart much and now I can't find anything on the forums or the Internet to get it to do the simplest thing. Nothing seems to work. I just get nothing or junk all over the graph. I just have a list of records for each date with values for a few fields that I want

How to get same date format insert -
Hi I am using sqlserver200 as database ,i want when i enter date from front hand it should get store in sqlserver database in same format as i enter, what date function i should use on front hand. yogesh

Moving to an older SQLServer -
I have made a small application for use at work. I have been allowed to install SQLServer 2005 Express on a local computer - and the program work as intended. It is only installed and used on 1 computer. "Unfortunately" people higher up in organization now want to use the

[2005] date comparison between vb.net and sql 2005 -
I am trying to compare an entered date with a date in sql2005. The field in sql is declaired as a date field. No matter what I put in the textbox, the code will not match up with the database. I know I am doing something in error. How do I compare what is in a textbox with a sql 20

[2005] How to programmatically create connection to SqlServer database -
I have vb.net business application, dataset created by designer and SQLServer database. User wants to have separated databases for each year; for example DB2005, DB2006, DB2007... and possibility to choose database from application. So I need to programmatically create several conn

[2005] validating date strings -
Hi Bit of a newbie question I'm afraid. My application currently uses datetimepicker controls, but because these can't show blank dates when no date is present/needed, my users (bless 'em!) want to go back to a free format text field for entering dates. Whilst I'm reluctant to