I am saving the date in database as 12/21/2010 12:00:00 AM. I want to retrive only 12/21/2010.I have DateTime dt = frmDate(from database); In dt i am getting 12/21/2010 12:00:00 AM. I just want 12/21/2010 in dt.
View 19 RepliesHow to create Jobs, I am using SQL 2005, i need a query which should get current date and compare current date with date in table and Send Email according to Job scheduled.
View 4 Replies How to get the date at which a record is created in SQL?..i.e, if i add a record to a database table db1 at 8/10/2010 11:30, I want to get the datetime, i.e 8/10/2010 11:30..;.Also let me know how to compare datetime values..
if(8/10/2010 11:30 >8/10/2010 10:30) will work or not?
i have the following query.
[code]....
but if there were no "hits" for a particular date range in the last week i only get the dates returned where there were hits. i need to get all the days returned and where there were no results, i need a zero returned.
hitdate hitsperday
2010-10-07 2
2010-10-06 58
2010-10-04 1645
2010-10-03 1192
what i need to return is this:
hitdate hitsperday
2010-10-08 0
2010-10-07 2
2010-10-06 58
2010-10-05 0
2010-10-04 1645
2010-10-03 1192
I am storing date data in sql server as varchar but I want to make comaparisons on this field in where clause- like this field from 2 days before or after etc
View 3 RepliesI have a start date and end date parameters.
i need to throw an error when the user enter a ' start date' which is more than 'end date' and an 'end date' which is less than a 'start date' .
the error should be displayed whent he user click the run button
This is House_info table in database
Id
Name
Expiredate
date
in admin.aspx page I have register button
I want when users click on button In Table in Expiredate column insert current date+1year
I mean if today is 2013-1-3Â in Expiredate column insert 2014-1-3
for this what should I wrote in SP?
I tried this code by inputting the ftp address as ftp//: and the correct username and password and I get the following error
"Unable to connect to the remote server" on line :
FtpWebResponse Response = (FtpWebResponse)Request.GetResponse();I tired this on my ftp server provided by a hosting service and an anonymous ftp located at 193.166.120.5 ?
Note: I was able to connect to both of these ftp through filezilla, via a webbrowser, and through windows command line.
I am trying to create a stored procedure that filters data from sql server by date but i get this error:
Conversion failed when converting datetime from character string.
my stored procedure is like:
[Code]....
the parameters are passed to the stored procedures as dateTime variables from c# code...
i have a store procedure that load data in a table of SQL SERVER 2008 from an excel file.the issue is, that the excel file have a column of DATE type, and i want that the system interprets the format in it, no matter what comes in it.dd/MM/yyyy mm/dd/yyyyi have an argue about this with my parnerts, cause i think is imposible, if you don't have a format before the process runs.
View 3 Replieshow to store only date into sql server 2008 from C# asp.net 3.5.
I want to store only date(like 26/05/1986) and only time (like 04:45:40 AM) into sql server 2008 .
I am using C# asp.net 3.5 as front end.But i am not getting how to convert datetime into only date and only time from front end application.
It should not be as a string from front end.it should be as a date type / time type.
I can not see only date or only time data type in VS 2008.
how to store only date or only time into sql server 2008 having only date or only time as a data type.
I want to compare smalldatetime values in my db to a calendar date. I'm not getting any value from dr[0] when I debug and put breakpoint in code below. Same thing if I select 'dateStart' instead of 'count(*)'. Any ideas?
[Code]....
i used below code for date time picker validation but it's not working.
Actually I want a date time picker which date dd/mm/yyyy format date. With validation for start and end date. Also for manual entry it should take only no. and for date rest like / or, will be auto formatted.means user should not be able to enter it.
I m using c# .net 2008.
[code]....
I am working on storing pdf file in sql server database and then reading a portion of it and displaying in html.
View 2 RepliesI want to read a value from database, using stored procedure i will paste my code below
ALTER
PROCEDURE [dbo].[msp_exceedingtimesheet]
-- Add the parameters for the stored procedure here
@Fullname nvarchar(50)
AS
BEGIN
[Code]....
I don’t know where to put this Query.
I am trying to open .dbf file from the server for which I have written below code.
Now, the problem is connection string accepts only physical path from the client machine where as I want it to pick file from the server.
System.Data.Odbc.OdbcConnection oConn = new System.Data.Odbc.OdbcConnection();
oConn.ConnectionString = @"Driver={Microsoft dBase Driver (*.dbf)};SourceType=DBF;SourceDB= http://localhost:1308/CNCScheduling/...;Exclusive=No; Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;";
oConn.Open();
System.Data.Odbc.OdbcCommand oCmd = oConn.CreateCommand();
string sPathApp = Request.ApplicationPath.ToString() + "/";
string sPathFull = Request.Url.OriginalString.ToString();
int iPathFullLen = sPathFull.ToUpper().IndexOf(sPathApp.ToUpper());
string sPathPrefix = sPathFull.Substring(0, iPathFullLen) + sPathApp;
string sRPTFile = "XABCL.DBF";
string sCrvPage = "D:\databases\" + sRPTFile;
oCmd.CommandText = @"SELECT * FROM " + sCrvPage ;
DataTable dt = new DataTable();
dt.Load(oCmd.ExecuteReader());
i want to read specific records form a table for example(tb)
if the field cosnsist of 100 record and i want to read form 70 to 80 what is the query for this but with out using ID field in the query
how to read last 20 record form a table for example (tb1) and the table consist of 3 column
View 4 RepliesI have a table that contain 1000 record and a webpage that contain 10 label to show the data in table and tow linkbutton for showing (next-previous) records. I want a query when i click on next show next 10 record and when i click on previous show previous 10 record (code in c# if possible)
View 3 RepliesI wonder how often the Web.config file is read by the server?And if the fact of the Web.config file is too large, influences the application performance?
View 2 RepliesI am trying to read data from a SQL Server 2008 database. Initially, I imported a 2007 Access db into the server. I have no problem reading this data. However, if I add new data, either through code or through SQL commands on the Server, I get an error when I try to subsequently read it. I only get the error on new data, not the imported data. Error:
System.InvalidOperationException: Invalid attempt to read when no data is present.
In my page (ASP.NET/VB.NET) I have a dropdown box which is filled with Customer Names. No Problem there. However, when I choose the customer, the rest of the form is supposed to fill with data retreived from the database. If I choose original data, it works fine. However, as soon as I choose a newly added record. It throws the Exception. I have tried to find a solution online, but most answers point to missing read code. I think my code is right, as it reads some records correctly. Is there something that is wrong with my server, or the way I am writing the records?
There is a dropdown box name CNAME on my page...
OnSelectedIndexChanged runs the following code:
sub displaydata(s as Object,e As EventArgs)
locked.checked = "True"
edit.enabled = "False"
Dim CustomerName As String = CNAME.SelectedItem.Text
Dim dread as SqlDataReader
Dim cn As New SqlConnection()
Dim cd As New SqlCommand()
cn.ConnectionString = "Data Source=localhost;Initial Catalog=AnalyticalReports;Integrated Security=True;"
cd.Connection = cn
cd.CommandText = "select Customers.CID, Customers.CNAME, Customers.CADDRESS1, Customers.CCITY, Customers.CSTATE, Customers.CZIP, Customers.CCONTACT, ISNULL(Contacts.CONNAME,'none') AS CONNAME FROM Customers JOIN Contacts ON Customers.CCONTACT = Contacts.CONID
WHERE Customers.CNAME = '"+ CustomerName+"'"
cn.Open()
dread = cd.ExecuteReader()
dread.Read()
CID.Text = dread("CID")
CNAME2.Text = dread("CNAME")
CADDRESS1.Text = dread("CADDRESS1")
CCITY.Text = dread("CCITY")
CSTATE.Text = dread("CSTATE")
CZIP.Text = dread("CZIP")
CONNAME.Text = dread("CONNAME")
cn.Close()
dread.close()
End Sub
how to make it?? How to read next row and previous row in database / SQL
View 5 Repliesbest way to read millions of record from sql server database.i have tried dataset but the performance is not good
View 5 Repliesfiletoread = Server.MapPath("\servernamesharefile.csv")
filestream = File.OpenText(filetoread)
readcontents = filestream.ReadToEnd()
It works fine if I put the file in the local directory and use "filetoread = Server.MapPath("file.csv")", but won't do it over the UNC path.I'm guessing the problem is security related but can't find any info related to it, do I need to somehow specify a username/password somewhere ?
I would like to know your libraries recommendations to read and write Excel applications on ASP .NET website. I have tried GemBox and NPOI, because they don't required Excel to be installed on the server, but they have some limitations on handling Excel files that are marked to read only.
View 6 Replies