When a user inserts a record it automatically stores the Date and Time that the record was created in column called CreatedDate.
Now what I am looking to do is retrieve the records between two days - which isnt a problem really, I am doing this....
[Code]....
@StartDate and @EndDate come from Calendar selected dates.
@StartTime and @EndTime come from two textboxes.
I am using multiple parameter for binding gridview. i used following code for binding.
string constr = ConfigurationManager.ConnectionStrings["connect"].ConnectionString;
//string query = "select * from bug_details where (auditor_name=@auditor_name or @auditor_name='')and
(datee=@date or @date='')and((datee between @from and @to) or @from='' and @to='')";
string query = "select * from bug_details where (auditor_name=@auditor_name or @auditor_name='')and (datee=@date or @date='')and(datee between (@from or @from='') and (@to or @to=''))";
[Code] ....
If I enter date in txtfromdate text box in will get record from particuler date and if i enter date in both the text box it will get records between these two date and one more two text box may be empty also. How can I achieve this...
how can we retrive records from sql-server between two dates. Dates are specied using DateTime datatype of C#. Also the stored date in sql is of Datetime type.
View 5 RepliesI have 2 table's
Table 1: Daily_item
Fields: Key_Guid Drescription Count
1 test 3
3 new item 2
I want to insert records form table 1 into table 2 but using the count field to duplicate the Key_guid record the new table.
New table example:
Table 2
Key_guid
1
1
1
3
3
This is more of a question about best pattern and practice than asking about any one particular method. We have app that is heavily reliant on dates and times and is hosted in the US. Sometimes it needs to perform actions based on those values, like emailing out reminders and expiring "single-use" session tokens.However there are clients around the globe that need to access this app and have the dates and times display relative to their local time.Clearly the solution should be to store the dates on the server side in a single time zone (UTC?) and then convert them back and forth from the local time settings of the user.We are using silverlight 4 on the client and the ria services 1.0 stack over linq2sql on the server side. I am hoping someone knows if there is a way to automate this localization of date and time as much as possible and if so, what is the pattern to use for this. Ideally we don't want to have to do a DateTime.ToLocalTime() every time we need to use a date. This has to be a common situation.Is there a way to automatically shift dates and times into the client's local time zone on SL4?
View 1 RepliesIf I have records in a table in this order:
Id - Date - Type
1 - 2011-03-01 - 1
2 - 2011-03-02 - 0
3 - 2011-03-03 - 0
4 - 2011-03-04 - (-1)
5 - 2011-03-04 - 0
Can I somehow select the records between a record having type 1 and type -1 without using a cursor,for example the records with ids 1-4 in this example?
I have an application called barcode available on a server on the web. The application is used to generate barcodes. The user is able to save her progress directly on her desktop, however though whenever the user try to load the saved progress. It is doesnt remotely connect to the server, instead, it defaults only the saved copy on her desktop. so for example
we have the following aspx created
barcoded.aspx. The barcoded.aspx is available on the server. the page has the following information
Name: PRT321-1 Code: 456789-1000
Label: 678900-001-001
Now, this information is saved as webpage.html. however though, when the user goes to the saved location and clicks on the saved copy, it automatically load the copy as a webpage and allow the user continue with the modification online but that is not the case. Does anyone know how to fix this problem.
I want to create an application where I need to enter date to the ms access database.
I am a bit confused regarding how to make the user to enter date. The options avaliable are:
a. Shall I use a textBox?
b. Shall I go for 3 drop down lists?
or something else.
Some more questions:
1. what date format shall i use? (dd-mm-yyyy, dd-mmm-yyyy, etc, etc or anything else)
2. What datatype shall i use to store the date in the database?
3. What SQL query shall i use to retrieve the data between 2 dates?
let me know if there are multiple options available regarding this application.
I want to make this application as easy as possible for the user.
[Code]....
this is my html code
[Code]....
this is my code behind
[Code]....
this is my bal code
acuttally
in my javascript popup i am getting the checked values but i need it in record by record in the lblsave data
i need to retrieve all the records present in a database
iam using the following code but it fails to show any record
Dim con As New System.Data.OleDb.OleDbConnection
Dim myPath As String
I have to filter the records from the data table based on the date.
I am having a column in data table called "cStartDate".
I will enter the begin and end date. I have to find out whethere the "cStartDate" is within the begin and end date i entered.
I am going to implement the filter logic in data table with out affecting the data base.
I need a Filter string for this.
I am using Linq to Sql as my ORM and I have a list of Ids (up to a few thousand) passed into my retriever method, and with that list I want to grab all User records that correspond to those unique Ids. To clarify, imagine I have something like this:
List<IUser> GetUsersForListOfIds(List<int> ids)
{
using (var db = new UserDataContext(_connectionString))
{
var results = (from user in db.UserDtos [code]....
Essentially that gets translated into sql as select * from dbo.Users where userId in ([comma delimmited list of Ids])I'm looking for a more efficient way of doing this. The problem is the in clause in sql seems to take too long (over 30 seconds).
I have a data grid in which I have to display around 12,000 records. Even if I do paging it is difficult to display all the records. Is there any other control or something else so that I can display all these records. Even if I make these as alphabetical also, some times I have to load 1000 records in a page which is difficult.
View 2 RepliesWhen I used the (way #1) below I could retrieve search result from my DB
Way #1:
[Code]....
But When I use( way#2) "separating my code to Presentation layer and data access layer ( using SQL HELPER CLASS )"
Way # 2
Presentation layer: protected void btn_Search_Advance_Click(object sender, EventArgs e)
[Code]....
data access layer:
[Code]....
I keep getting this error: Procedure or function 'SP_Search' expects parameter '@SEARCHTYPE', which was not supplied.
I have table in database in which near about 2 lac records are available.
I am using access as database.
How can i get the particular row or records from the database in a minimal time
I want data to be retrieved faster
I have created a table in my Oracle database and am trying to add / edit / delete/ query the records. This table already has 4000000 records. Now when I try to query the database, it takes close to 3 minuetes to return records. I have tried creating indexes, but was not successfull so far.
Following is the structure:
User : varchar(20)
Fac : varchar(10)
Prm: varchar(100)
I am using the following code in VS2005:
[Code]....
In the procedure function, there will be queying several times based on conditions.
Suppose each query retrieves several records, can I caumulate those records in on table, then return that table.
Benifit I want to success here is that I want to save time, so instead of making several functions each has one query, each one requires a connection to databae, so it will take time.
I want to block Year From Calender .I have 2 text box in first text box i select Start Financial Year And in second Text End Financial Year.When i Select 2009 year in first text box then in second texbox all dates privious from 2009 will be block.
View 1 RepliesIn my webapplication, i have a scenario to retrieve all of the .txt files which is stored in current date.The files would have to be stored in particular folder by appending the datetime with the filename regularly.I just want to move those files shich stored in the current date from that folder to amother folder. So that i nust need to retrieve the files validating from the current date.
View 2 RepliesI was creating another usercontrol with Telerik's RadGrid and Calendar.
[code].....
The problems are, (1) when I click the submit button. the data in the RadGrid is not changed. (2) how can we check if there is nothing selected in the Calendar controls, because there is a date (01/01/0001) set even if we do not select anything from that calendar, thus Calendar1.SelectedDate != null is not enough.
I have two text boxes (from date and to date). Based on your demo i have disabled the future date but my requirement is
1). First i have select the from date. eg: 21-02-2013
2). Now i am selecting TO DATE. eg:21-01-2013
Now my requirement is i need to disable dates until 21-02-2013 to current date. Then user not able to select ToDate as 21-01-2013 i need to provide only option to select from 22-02-2013 to current date.
<asp:Label ID="lbl_sel_date" runat="server" Text="Select Date: "></asp:Label>
<asp:TextBox ID="txtDate_from" runat="server" CssClass="disable_future_dates"></asp:TextBox>
<asp:ImageButton runat="server" ID="imgPopup" ImageUrl="~/Calendar.png" />
<cc1:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txtDate_from"
PopupButtonID="imgPopup" />
[code]...
The website is over half way done and the functionality for the blog is (except for adding posts) is already implemented and working correctlyI have a SQLExpress 2008 backendBlog posts are rendered on the page with full HTML markup within a label control.
All of the above is done and working. Though I am essentially new to creating websites with ASP.NET, CSS and SQL, I am sure that I could simply carry on and make a login page with some controls that would allow me to add records (blog posts) directly to the database on the host server. However, I am fearful of doing this because I know that malicious code can be passed in this way. Also, because of my lack of knowledge, the only way that I know of to pass the code from a control to the database is to disable validation for the page the control is on. Without a doubt I do not want to do that.
So what are my options for getting blog posts into the database? Is it safest for me to fully create the post in html and update a copy of the database that resides on my local machine? If I do it this way, how can I merge the records from the database on the local machine with the records on the remote server?
In machine XPSP2, I tried to install SQL SErver 2005 express edition (downloaded from the microsoft site) - after mode selction form (Windows/SQL server authentication) - system restarted, automatically.Again restarted, Again restarted,Again restarted,Again restarted,a 1000 times or more.finally I unplugged the system from the UPS
View 2 RepliesI would like to develop an application which retrieves records based on date.(using vb.net)
if initial date is 07/10/2010 expiry date is 07/08/2011(dd/mm/yyyy) which is stored in database.
between these two ranges on 07th of every month i wanna generate reports .
and if if initial date is 15/10/2010 expiry date is 15/08/2011(dd/mm/yyyy) on every months 15th reports has to be generated.
I want to create a listing view in which the record will be in this format(basically one record based on other, what mvc approach i should follow) .Basically i am using linq to sql and i have module and features in the same table with module being identified by is module =true tag . basically i am looking for suitable mvc approach. i could create a codebehind html table and rendered it here but that not i am looking for.
My table
Module1
Module1Feature
Module1Feaure2
Module1Feature3
Module2
Module2Feature Module2Feature2
Module2Feature3
Basically Please Notice that the child records are based on the parent.