SQL Server :: Show Time Data Posted?
Jan 1, 2011
i want show time data posted. for example 18 second ago or 4 min and 36 second ago or 2 day ago. for example my post in forum asp.net. this is Procedure: but not run.
@DATEDIFF INT=0
as
If (SELECT DATEDIFF(Minute, date, GETDATE()) AS Minutes)
FROM tblajax > 60
BEGIN
SELECT Id, name, family, age,
(SELECT DATEDIFF(Minute, date, GETDATE()) AS Minutes)
FROM tblajax
END
ELSE
BEGIN
SELECT Id, name, family, age,
(SELECT DATEDIFF(Second, date, GETDATE()) AS Second)
FROM tblajax
END
View 3 Replies
Similar Messages:
Jan 25, 2011
i always got the empty string in form data posting. can you describe what the hell happened in my code? always got the empty string to insert to SQL server even it is drop down list selected value is empty. Is this the error in visual studio cause sometimes i can get the value and sometimes can't (inconsistent!!!)
Protected Function sqlparameter_insert_newscat() As SqlParameter()
Dim sqlparam(4) As SqlParameter
Dim ddlstatus As Boolean
If rbActive.Items(0).Selected = True Then
[code]...
View 2 Replies
Jan 25, 2011
I've got stuck for this for a long time. I always got empty value for the posted data. Here is my code:
Protected Function sqlparameter_insert_newscat() As SqlParameter()
Dim sqlparam(4) As SqlParameter
Dim ddlstatus As Boolean
If rbActive.Items(0).Selected = True Then
ddlstatus = True
Else
ddlstatus = False
End If
sqlparam(0) = New SqlParameter("@username", SqlDbType.VarChar, 30, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, Session("user.id"))
sqlparam(1) = New SqlParameter("@news_category", SqlDbType.VarChar, 255, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, news_category.Text)
'Response.Write(HttpContext.Current.Request.Form(name))
sqlparam(2) = New SqlParameter("@news_category_desc", SqlDbType.Text, 1000000, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, HttpUtility.HtmlEncode(news_category_desc.InnerText))
sqlparam(3) = New SqlParameter("@news_category_status", SqlDbType.Bit, 1, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, ddlstatus)
sqlparam(4) = New SqlParameter("@news_category_parent", SqlDbType.BigInt, 100, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, ddlRoot.SelectedValue)
Return sqlparam
End Function
the news_category.text always the empty string even the dropdownlist selected value return empty string. Is this an error of bug in Visual Studio 2010? I 've got stuck for this for long time and i have been nearer to deadline. I just made change "ValidateRequest = False" to aspx file to permit html tag to be posted.
View 4 Replies
Feb 4, 2010
HOWTO create ASP.NET C# controls on server side for posted data that had no runat=server on the client.
I have processes needing to post files to a ASP.NET application. These processes must post without runat=server as such:
<form ~~~~ to some ASP.NET/C#/aspx page>
<input type=file name=MY_FILE ~~~>
</form>
On the ASP.NET page, in the Page_Load I would code somethign like this:
[URL]
Here is the trick, the control "fileLIST_FILE" does not exist because the HTML does not have runat=server on it.
If the client did have runat=server the designer.cs would have somethign liek this:
System.Web.UI.HtmlControls.HtmlInputFile fileLIST_FILE;
With all that said, I want to make "fileLIST_FILE" on the fly inside Page_Load fromt he posted name of "MY_FILE".
do not focus on the fact that this is a file upload. I would like to know how to do this for any posted FORM data.
View 11 Replies
May 26, 2010
My problem is that I have a grid view that show the data from database.In my gridview i add a column name date .like eg You knw that when we send a scrap to anyone then show time how much time to send a scrap.
View 6 Replies
Sep 7, 2010
I am working on an application where it stores information that different clients will be using. I need to figure out how to show the current client logged in only what they have posted to the application and not everything that has been posted to the application. Client 1 logs in and sees what they have posted; client 2 loggs in and sees what they have posted.....etc. Can anyone shed some light on this for me?
View 1 Replies
Apr 6, 2010
I have a client request that all times be displayed in Pacific Time Zone, regardless of client settings. I'd like to avoid a scenario where I have to call a function for every time display and instead have a single point where I can make the switch.
I'm thinking a custom culture might do the trick, but I wanted to ask before I set off down a potentially blind alley (or miss something trivially easy).
View 3 Replies
Apr 20, 2010
Whatever server Control we take on aspx page while in coding phase, all those controls are converted to html controls through the asp.net engine and sent to the requesting web browser. That's fine.
Now, all the controls that are rendered on the browser are html controls. I am bit confused that how after pressing any button (Or any such control that post back pages) page is posted back to the asp.net engine. How such html controls comes to know where (address) they have to go?
View 6 Replies
Oct 8, 2010
I've a grid view which could have huge data. When any control like a button causes the postback, I do not want gridview data to post back as it is not required and results in slower responses.
View 1 Replies
Mar 11, 2011
I have an ASP.NET website that worked fine using and debugging in VS2008. I went through the upgrade process opening the solution in VS2010. I can run the site, but as I make changes in the app_code folder classes, they don't seem to commpile and warn me of compile-time errors. As soon as I get to a point that calls the class, the errors show up. Sounds JIT I guess, but this isn't how it was working in 08. Is there an option that was changed in the upgrade process? This is a large project, I really don't want to break something and not find out until some obscure page is opened.
View 1 Replies
May 7, 2015
i want the date appears in grid view without the time part in sql server i made the data type of date as date not as datetimein asp.net i made the data type of date as datetimewhere is the problem?
View 1 Replies
Feb 12, 2010
I wnat to evaluate the performance of my web page. How can I show the time comsued of a page?
View 3 Replies
Feb 16, 2010
Is there a way to show multiple rdlc files at the same time that will print together as 1 report? I noticed that the ReportViewer allows multiple <LocalReport> items, but I haven't yet had any success with this.
View 1 Replies
Oct 6, 2010
i hv a table in ms-access that have a column in datetime format.when i add data to this field it get stored in the format dd/mm/yy with time as 12.00.00 am.i m binding this data in grid view.hw can i remove the time from the date as i dont wanna show time in the that column of grid view. i m binding the data in gridview by the template field binding methods
View 6 Replies
Jun 13, 2010
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class ResponseTest : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
var a = Request; //I didn't find the data in Request's structure.
Response.Write("successed; hello World;");
}
}
//-----------------------javascript--------------
for( var i=0; i<this.dataToBeSent.length && this.dataToBeSent[i].hasSent == false; i++ )
{
xmlRequest.open("POST",this.dataToBeSent[i].url,true);
xmlRequest.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xmlRequest.setRequestHeader("Content-length", this.dataToBeSent[i].data.length);
xmlRequest.setRequestHeader("Connection", "close");
xmlRequest.onreadystatechange = function()
{
var j = j || i;
if(xmlRequest.readyState == 4 && xmlRequest.status == 200)
{
if( xmlRequest.responseText.toLowerCase().indexOf("successed") > -1 )
{
this.dataToBeSent[i].hasSent = true;
}
}
};
xmlRequest.send(this.dataToBeSent[i].data); // xml data
}
View 2 Replies
Sep 29, 2010
I am trying to get data posted to a site. The only way i have been able to access these variable is through the headers:
Posting script:
HttpWebRequest request = WebRequest.Create(address) as HttpWebRequest;
request.Headers["name"] = "Brandon"; [code]....
I have tried doing this but cannot access the variables in the Posted to Script..
[Code]....
[Code]....
Is there a better way than using Request.Headers?
View 1 Replies
Feb 6, 2011
I want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
View 33 Replies
Oct 29, 2010
I am writing an application in which a remote url web site ( says url1 that is sender) sends xml data to another web site (says url2 that is receiver) by using .NET WebRequest. On the receiver url2 if I use .NET Page.Response and .NET Page.Request to store posted/received xml data into an external text file, then the data is stored. However, if I store the received data into database, I do not see the data is stored into the database.
trouble shoot the codes so I can store such remotely posted data into database on the receiver side url2.
I host both url1 site and url2 site in my computer using IIS like [URL]
1/ Receiver page's codes that store remotely posted xml data into database do not work:
protected void Page_Load(object sender, EventArgs e)
{
Page.Response.ContentType = "text/xml";
StreamReader reader = new StreamReader(Page.Request.InputStream);
String xmlData= reader.ReadToEnd();
ProductNameSapce.ProductCollection.InsertReceivedProduct(xmlData).ToString(); // data is not stored ; the method is tested and works well with hard-coded data
reader.Close();
Page.Response.End();
}
2/ The version of the receiver page at url2 that stores into an external text file works:
protected void Page_Load(object sender, EventArgs e)
{
Page.Response.ContentType = "text/xml";
StreamReader reader = new StreamReader ( Page.Request.InputStream );
String xmlData= reader.ReadToEnd ();
StreamWriter s;
s= File.CreateText ( Server.MapPath(".")+@""+ Guid.NewGuid () + ".txt" );
s.WriteLine ( xmlData); // data is stored in an external text file
s.Close ();
reader.Close();
Page.Response.End();
}
View 10 Replies
Dec 16, 2010
I have a datalist and gridview that have a image in a column.. when you click the imagebutton, its calls my method that updates a table. The page is posting during this event, but when the page is done, the image hasnt changed.. im sure it has to do with the datasource not binding during that click.. so where can i move this code to or can i simply bind the control during that click? Currently im handling it in the itemdatabound event.. which would explain it.. but where is the correct place to handle this logic?
[Code]....
The control on the page is configured like so..
[Code]....
View 2 Replies
Mar 4, 2010
i have a image control that show Captcha...
Problem:in the Host(not local system) Captcha show only one image that created for first time,but in my local system every things is right,and captcha change for every page load...
i think image can't find server folder address and always show first produced image!!!
see code:
[Code]....
where is the problem?
notice:when i see server "Upload" folder and "AddIntuitionReflexRandom.gif" file,content change truly,but that can't show in my image.
View 10 Replies
Jun 9, 2010
I am working on a comparison tool that will take an excel file and a .csv file and find differences. The user is going to be selecting the two files from their local machine via the .NET FileUpload control. The issue I am running into is that I don't want to write the files to the server first so using something like below won't work for me, as "Book1.xls" or even " + FilePath + " in place of it won't work. I need to be able to read the posted files into memory, then create maybe datatables of them, then do my comparison code.
[Code]....
I have some code that reads the PostedFile into a stream but I don't know how I can use that stream with the above code. Then I have some that can read the .csv file, but if it is an excel file, I get a bunch of Excel garbage along with the data...
[Code]....
How can I read into clean data from a FileUpload control of an Excel document?
View 5 Replies
Jul 26, 2010
I am developing a web application in ASP.NET3.5 with C#. I also using Telerik RadAjax Control. When user click the menu then open the page with a new tab(Like web Browser).I want to create, when user back any previous tab(page) the will be show the previous data without loading 2nd time( like browser tab). Is it Possible ?
View 2 Replies
Oct 8, 2013
Here what i am trying to accomplish. I want to have a div or panel on the page and have some text on it. The div or panel must hava a specfied time limit and then disaaper from the page. Say i want this text to apper on 10Cotober 10.00 and disapper from the page on 11October 18.00.
View 1 Replies
Jun 2, 2010
How show local time in datagridview collumn DateTime from database with universal datetime
View 2 Replies
Mar 25, 2010
In my asp.net application I user Microsoft Membership to manage site access security and find the time saved into LastLoginDate is ahead of local time (Eastern Time Zone) 3 hours. What is wrong with it and how to ajust it to local time by application system only such as changing some properties od application?
View 2 Replies