using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class ExtEltSetTimeStamp : System.Web.UI.Page { protected void Page_Load(object sender, System.EventArgs e) { label3.Text = " Showing COMPLETED Elements "; if (Session != null) { } else { Response.Redirect("Login.aspx"); } if (!Page.IsPostBack) { GridView1.PageIndex = 0; GridView2.PageIndex = 0; fillgridview(); label2.Text = "1 out of" + GridView1.PageCount; label2.Text = "1 out of" + GridView2.PageCount; GridView2.Visible = false; } } public void fillgridview() { DataSet ds; // DataRow[] dr; try { int y = 0; bool iscompleted = false; DateTime submitted = DateTime.Today; DateTime completed = DateTime.MinValue; TimeSpan ts; //DataTable tbliscompleted = new DataTable(); //DataTable tblinprogress = new DataTable(); //string columnname=""; //ds = clsSqlDataProvider.ExtElement_GetRequisitionTime(Convert.ToInt32(Session["LoginId"].ToString()), "1"); clsSqlDataProvider dp = new clsSqlDataProvider(); ds = dp.ExtElement_GetRequisitionTime(112, "1"); DataTable dtCompleted = new DataTable(); dtCompleted.Columns.Add("Description", System.Type.GetType("System.String")); dtCompleted.Columns.Add("Scope", System.Type.GetType("System.String")); dtCompleted.Columns.Add("GICSCodeDesc", System.Type.GetType("System.String")); dtCompleted.Columns.Add("SubmittedDate", System.Type.GetType("System.DateTime")); dtCompleted.Columns.Add("DcDate", System.Type.GetType("System.DateTime")); dtCompleted.Columns.Add("EADate", System.Type.GetType("System.DateTime")); dtCompleted.Columns.Add("HUDate", System.Type.GetType("System.DateTime")); dtCompleted.Columns.Add("PSDate", System.Type.GetType("System.DateTime")); dtCompleted.Columns.Add("DUDate", System.Type.GetType("System.DateTime"));

hi any body please help me iam converting vb.net code to c# while doing this i got problem near convertion datediff(dateinterval.day,submitted,completed) with ths above code in vb iam getting output in days i.e 23 but in c# iam getting thre output as 23.14:33:01 can anybody resolves it here i used the datetime completed=datetime.today and submitted=datetime.minvalue

hi iam suffering with small problem acutually iam trying to view gridviewpagecount using label at the bottom and top of the grid view my gridview consists of boundfields,templatefields how to get this can anybody resolves it

hi iam getting error while using updatepannel control in my page dnt exactly the error is can anybody resolves it below is the code iam using here iam getting error near updatepannelcontrol <%@ Page Language="C#" MasterPageFile="~/MasterPage.master" EnableTheming="true" AutoEventWireup="true" CodeFile="ExtEltAddRequisation.aspx.cs" Inherits="ExtEltAddRequisation" Title="Add Request" %> function fnValidate() { if(fnAddRequisition()==true) { return true; } return false; }

hi iam in a little bit of confusion how to add webreferences dynamically in .net can anybody helps me

intReq = Convert.ToInt32 (selectRow.Cells[0].ToString());//getting error here

yes it is working thak u very much rightfrom morning onwards iam suffering with this problem once thank u very much

hi this is RK iam working with webservics in asp.net in that iam trying to use databaseconnectivity iam passing this query in dataadopter " select dtlastupdated,dblvalue from dbo.tblPerodicTickerData where dtDateTime = between 2007-03-28 11:35:09.000 a.m And 2007-04-09 11:40:05.000 a.m" while using this websrvice in asp.net page iam getting the error like this "System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'between'." whAT DO I DO TO RECTIFY THIS ERROR COULD U PLEASE KINDLY HELP ME OK BYE