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
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]...
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.
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.
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?
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).
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?
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.
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.
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?
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.
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
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 }
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.
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(); }
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?
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.
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?
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 ?
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.
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?