|
by: KathyB |
last post by:
I'm trying to concatenate fields in SQL stored proc for use in text
field in asp.net dropdownlist. I'm running into a problem when I try
to use a DateTime field, but can't find the answer (so far)...
|
by: Malcolm Diaz |
last post by:
Hello all
Thank you all in advance. I am completely at a loss here with this error. I am developing a simple interface that will allow a user to enter,execute and view results from a SQL statement...
|
by: Amir |
last post by:
Hi all,
I have a table called PTRANS with few columns (see create script below).
I have created a view on top that this table VwTransaction (See below)
I can now run this query without a...
|
by: colinhumber |
last post by:
I have a datetime variable coming from my ASP.NET application that has
a time portion. I give my users the option to perform an equals,
greater than, less than, or between comparison. The trouble...
|
by: virendra.chandra |
last post by:
hi guys,
this is virendra.
I am in big trouble to handle date situation using where clause. i am
using ormapper.
if the sqlserver and application server has different date
format(different...
|
|
by: RSH |
last post by:
I am having a bit of trouble filling a datatable with a query. I'm getting
the error message:
System.FormatException: String was not recognized as a valid DateTime. at...
|
by: Tina |
last post by:
I'm selecting some columns using a .net dataadapter using Select myDate from
myTable. then I...
DIM dt as new datatable
myda.fill(dt)
Now in dubugging I am examining the dt.rows(0).ItemArray...
|
by: =?Utf-8?B?Um95?= |
last post by:
I need to compare a datetime value against the value in a datetime column in
the WHERE clause as accurate as ticks (100 ns). When I construct a query by
string.Format("WHERE MyDatetimeColumn =...
|
by: =?Utf-8?B?Um95?= |
last post by:
I have a DataRow dr retrieved from a database. One of the column is datetime
type. How do I convert it to DateTime structure in .NET?
DateTime dt = DateTime.Parse(dr.ToString()) will drop the...
|
by: =?Utf-8?B?Um95?= |
last post by:
I want to dynamically construct a TSQL with a datetime column in the WHERE
clause. How do I include the millisecond in the query?
"WHERE datetimecolumn = " + dt.ToString() will not include the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|