I have an application which uses globalization, hence the datetime objects are globalized based on current culture. These datetime objects are passed as sql parameters for a select query. The database stores the datetime in only one format (en-US style). Although the query is parameterized the final query generated does not contain converted values (format that Database is expecting).
View 1 RepliesConsider this snippet of code:
string sDate = string.Format("{0:u}", this.Date);
Conn.Open();
Command.CommandText = "INSERT INTO TRADES VALUES(" + """ + this.Date + """ + "," +this.ATR + "," + """ + this.BIAS + """ + ")";
Command.ExecuteNonQuery();
Note the "this.Date" part of the command. Now Date is an abject of type DateTime of C# environment, the DB doesnt store it(somewhere in SQLite forum, it was written that ADO.NET wrapper automatically converts DateTime type to ISO1806 format)
But instead of this.Date when I use sDate (shown in the first line) then it stores properly.
My probem actually doesnt end here. Even if I use "sDate", I have to retrieve it through a query. And that is creating the problem
Any query of this format
SELECT * FROM <Table_Name> WHERE DATES = "YYYY-MM-DD"
returns nothing, whereas replacing '=' with '>' or '<' returns right results.
So my point is:
How do I query for Date variables from SQLite Database.
And if there is a problem with the way I stored it (i.e non 1806 compliant), then how do I make it compliant
string NewsFillter = string.Empty;
List<string> PublishDatePostMeta = (from post in postrepository.GetAllPosts()
join pstmt in postrepository.GetAllPostMetas()
on post.int_PostId equals pstmt.int_PostId
where (post.int_PostTypeId == 4 && post.int_PostStatusId == 2 && post.int_OrganizationId == layoutrep.GetSidebarDetailById(SidebarDetailsId).int_OrganizationId) && pstmt.vcr_MetaKey=="Publish Date"
select pstmt.vcr_MetaValue).ToList();
int DatesCount = PublishDatePostMeta.Count();
foreach (string PublishDate in PublishDatePostMeta)
{
if (PublishDate != "")
{
NewsFillter += System.DateTime.Now + ">=" + Convert.ToDateTime(PublishDate);
}
}
var postsidebar = from post in postrepository.GetAllPosts()
join pstmt in postrepository.GetAllPostMetas()
on post.int_PostId equals pstmt.int_PostId
where (post.int_PostTypeId == 4 && post.int_PostStatusId == 2 && post.int_OrganizationId == layoutrep.GetSidebarDetailById(SidebarDetailsId).int_OrganizationId)
&& (pstmt.vcr_MetaKey.Contains(filter) && pstmt.vcr_MetaValue.Contains("true"))
select post;
The thing is that how NewsFillter would be accomdated in the postsidebar query in the pstmt object after true ( i would be putting it in contains,equals join or what). is there any way that a chunk (between &&s) return enumerable and i can get away with this. at this moment it is not allowing that
I use below code to showing date in Persian in my site
DateTime miladi = DateTime.Now;
System.Globalization.PersianCalendar shamsi = new System.Globalization.PersianCalendar();
DateTime shamsidate = new DateTime(shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi));
Lbldate.Text = (shamsidate.ToString("yyyy/MM/dd", System.Globalization.CultureInfo.InvariantCulture));
But below error happen
Server Error in '/behtop website' Application.
Year, Month, and Day parameters describe an un-representable DateTime.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentOutOfRangeException: Year, Month, and Day parameters describe an un-representable DateTime.
Source Error:
Line 43: DateTime miladi = DateTime.Now;
Line 44: System.Globalization.PersianCalendar shamsi = new System.Globalization.PersianCalendar();
Line 45: DateTime shamsidate = new DateTime(shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi)); Line 46:
Line 47:
it worked correctly before but suddenly it make an error Why?
1. I have a GridView on my page and it uses sqldatasource with parameterized query. What I want to do is, on page load (where nothing has been selected so no parameter supplied), I want it to query everything (something like SELECT * FROM [this_table]) but since my SelectCommand is something like
SELECT * FROM [this_table] WHERE [this_column] = @someParameters AND [that_column] = @someParameters.
Can I play around with default value to achieve something like that but how ? Now, when the page loads, it doesn't show anything (No Gridview).
2. On my page, I made something like (username, gender, address, and more) and one single search button. That means, no single control enable auto postback. What I am trying to accomplish is building dynamic query
(if username specifed -> SELECT * FROM [this_table] WHERE [username] LIKE @username).
If both username and gender are specified (SELECT * FROM [this_table] WHERE [username] LIKE @username AND [gender] = @gender) and you know the rest. How can I do this using GridView and SqlDataSource ? To my knowledge, I can only specify one SELECT statement in a sqldatasource.
I need to build a globalized web application, and I already have those resource files in the App_GlobalResources folder. My web application is built upon an N-tier architecture: DAL, BLL and Presentation are the layers, and we are using SQL Server 2008. We have decided that the database, BLL and DAL will always be operating using the en-US culture, but the culture in the Presentation layer can vary.
ASP.NET works with two culture properties: Culture and UICulture. There's an article in MSDN that states that a thread's UICulture determines which resource files ASP.NET picks, and Culture determines datetime/currency formating, etc.
So, to have a fully globalized application, I think I must set both Culture and UICulture, so that both Resources and datetime/currency formating are displayed using the same culture.
Then I thought I would set those culture properties (both of them) in the BeginRequest event in my web application, based on the user's choice, and that everytime a method in the BLL is called, it sets the thread's Culture property to "en-US" and, just before it returns, it sets the thread's Culture back to what it was before.
I am having problems getting my first report to show data when passing 2 DateTime session and 1 string session parameters to my report. When I remove the 2 DateTime parameters returns data, but with DateTime Parameters, no data. The SQL statement returns correctly. It seems my 2 date params get to the report as NULL. [Code]....
Report Parameters:
dtFromSelect = string - internal
dtToSelect = string - internal
qreStorename = string - internal
For report parameters, if I use DateTime instead of String, I get this error
The definition of the report 'Main Report' is invalid.
The property 'DefaultValue' of report parameter 'dtToSelect' doesn't have the expected type
We have a requirement where date time values would be passed to the report parameter which is of
View 2 RepliesIn Report Viewer report, I have two DateTime parameters that I would like to appear in a textbox of my report. How can I format like this? Currently this comes out blank.
= "Date Range: From: " + Parameters!dtFromSelect.Value + " - To: " + Parameters!dtToSelect.Value
here is my code for selectiong some records from db table
string strSql = "select * from mtblNBD where SentTo=@SentTo and InternalStatus Is NULL order by DeadLine desc";
SqlCommand com = new SqlCommand(strSql, con);
com.Parameters.Add("@SentTo", SqlDbType.NVarChar, 50).Value = (string)Session["uname"];
here I am using parameters for SenTo field but not for NULL so it is ok... or should I use parameters for this field where value is NULL , if yes then how can I use parameter for this
i want to create a datetime object in the way dd/mm/yyyy but the defualt behaviour of datetime object is mm/dd/yyyy. I want this because my user enters date in dd/mm/yyyy format and i want to apply different additions and subtrations on this format. I know how to display dates in different formats.
View 3 RepliesI am trying to redirect the user to login page with ReturnUrl and with querystring parameters which are already in the url there.But it is getting only first querystring parameter and not others. here is the code:Response.Redirect("~/login.aspx?ReturnUrl="+Request.RawUrl);it is showing correct in login.aspx after redirect but not returning as per querystring parametersI ave also tried other methods e.g.:
Response.Redirect("~/login.aspx?ReturnUrl="+Request.AppRelativeCurrentExecutionFilePath+"?"+Request.QueryString);
how to query return all data in Array Object ,Hash Table ,And DataTable dataRow
View 4 RepliesI'm writing an Asp.Net WebForms app where I am calling an edit page an passing in the data about the record to be edited using query string parameters in the URL.Like:
http://myapp.path/QuoteItemEdit.aspx?PK=1234&DeviceType=12&Mode=Edit
On a previous page in the app, I have presented the user with a GridView of screened items he can edit based on his account privileges, and I call the edit page with these above parameter list, and the page know what to do.
i use this code for show and converting date in my grid view
<asp:TemplateField ItemStyle-Width = "100px" HeaderText = "DATE" >
<ItemTemplate >
<%# System.Convert.ToDateTime(miladitoshamsi(Eval("Date")))
</ItemTemplate>
</asp:TemplateField>
here show my date and time from data base i learn in below threads how i can bind date from data base that just show date.URL....with this code
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Item" />
<asp:TemplateField>
<ItemTemplate>
[code]...
now how i can mix these two code together that convert date from database and just show date?
sort List-generic object by two parameters
View 1 RepliesOn my master page I am displaying a flash file with SWFobject with the the following parameter
<param name="movie" value="flash/object.swf />
It works great when the web page is in the root directory, but will not in a different folder in the project. What is the equivalent to "~/flash/object.swf".
I have a data grid with a lot of information on it - to easily filter the data, I would like to be able to pass parameters to it. My problem is that I do not want the parameters to be required. So if I just put 1 or 2 of them in the query string, I would like for it to return all of the data related to those two parameters.I am using a data grid & stored procedures:My Stored Procedure looks like this:
[Code]...
I am passing value from one page to another page using query string so tell me easy way to implement the encrypted query string .
View 1 RepliesI am calling an action from JQuery using $.getJSON() method.
This action returns a JsonResult object.
I am getting all the values correctly but not the Date Format.
Below is the Date format which i am getting.
/Date(1287587195000)/
/Date(1287587195000)/
But i want it like "10/15/2010 11:56 AM" this format.
How can i achieve it...
I have the following Repeater, I need to bind multiple querystring parameter in HREF
<li class="current">
<a href="house.aspx?H_name=all"></a>
<ul>
<asp:Repeater ID="rptMenu" runat="server">
<ItemTemplate>
[code]...
Does the DateTime object stores the CultureInfo with it, or you need to use the Formatter to format the DateTime according to current culture ?
I have a class property that retuns a DateTime. Within that property I am setting the DateTime object with current culture information using CultureInfo object. Below is the code for class property I am using:
public DateTime PrintedQuoteDate {
get{
DateTime printQuoteDate = DateTime.Today;
// cInfo = CultureInfo object
return Convert.ToDateTime(printQuoteDate , cInfo);
}
}
So my question is when I will use the above property in my code, will it have the corrosponding culture information that I am setting in its get method, or I will have to use the same CONVERT code for formatting date time. The restriction here is that the Property should return only DateTime type.
System.DateTime start_time = (System.DateTime)phones_.GetStartTime(callInfo.No[1].e164, callInfo.No[0].e164)[0][0];
View 1 RepliesI want to fetch date from a datetime field, when i select this field in database i get the result as 'yyyy-mm-dd hh:mm:ss' i want the result to be like dd/mm/yyyy
I am developing website using ASP.net C# using Mysql.query i have made is:
//***to get next date
string nextdatequery = "SELECT next_dt
FROM testcase.heardt where fil_no=?
and next_dt>?;";
I'm really drawing a blank on this one. I've been working on globalization but the DateTime seems to always revert back to the CurrentThread's culture.
I've got a textbox with the date expressed as a string:
// the CurrentThread's culture is de-DE
// My test browser is also set to de-DE
IFormatProvider culture = new System.Globalization.CultureInfo("de-DE",
true);
// en-US culture, what I'd ultimately like to see the DateTime in
IFormatProvider us_culture = new System.Globalization.CultureInfo("en-US",
true);
// correctly reads the textbox value (22.7.2010 into a datetime)
DateTime dt= DateTime.Parse(txtStartDate.Text, culture,
System.Globalization.DateTimeStyles.NoCurrentDateDefault);
// correctly produces a string 7/22/2010
string dt2 = dt.ToString(us_culture);
At this point I want a DateTime that's in en-US I've tried both:
DateTime dt3 = Convert.ToDateTime(dt2, us_culture);
DateTime dt3 = DateTime.Parse(dt2, us_culture);
But both produce de-DE DateTimes. My motivation in asking this question is the rest of the business logic is going to be calling dt2.toString() and will result in an incorrect date time string. I realize I could change toString() to be toString(us_culture) but I'd rather not change all of the rest of the business logic to accomodate this change.
Is there a way to get a DateTime in a culture other than the CurrentThread's culture?