ASP.NET

Lijo Rajan1-May-07 23:39

Lijo Rajan

1-May-07 23:39

U have to store the time,date,year in seperate variable.Then u can take time alone.
DateTime dtDOB = Convert.ToDateTime(drFieldRetrieve["dateof_birth"]);
string strDay = dtDOB.Date.Day.ToString();
string strMonth = dtDOB.Month.ToString();
string strYear = dtDOB.tYear.ToString();
string strTime = dtDOB.TimeOfDay .ToString();
Hope that u r expecting like this.

Blumen2-May-07 0:54

Blumen

2-May-07 0:54

Hi Pathan,

Try this.

DateTime.Today.ToString("t");

This will return just the time in AM/PM format.

Regards,
Blumen

Blumen2-May-07 0:57

Blumen

2-May-07 0:57

for reference you may try this as well:
http://msdn2.microsoft.com/en-us/library/az4se3k1.aspx

Guffa2-May-07 1:15

Guffa

2-May-07 1:15

The "t" format applies to dates, not strings.

String.Format("{0:t}",new DateTime(2007, 11, 19, 10, 0, 0));

---
single minded; short sighted; long gone;

string.Format("SELECT Count

mnvkng762-May-07 17:16

mnvkng76

2-May-07 17:16

You need to turn the string to a DateTime value as below:

DateTime timetoparse = Convert.ToDateTime("11/19/2007 10:00 AM");
this.textBox1.Text = string.Format("{0:t}", timetoparse);

Output = 10:00 AM

Ibuprofen1-May-07 23:08

1-May-07 23:08

Can someone tell me why my counting wont count correctly?

using System;<br />
using System.Collections;<br />
using System.ComponentModel;<br />
using System.Data;<br />
using System.Drawing;<br />
using System.Web;<br />
using System.Web.SessionState;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.HtmlControls;<br />
using TCAIMS.Components;<br />
using System.Data.OleDb;<br />
using System.Configuration;<br />
<br />
namespace TCAIMS.NewDag<br />
{<br />
	/// <summary><br />
	/// Summary description for QCData1.<br />
	/// </summary><br />
	public class WorKiDAGData1 : System.Web.UI.Page<br />
	{<br />
		protected System.Web.UI.WebControls.Label lblErrorMsg;<br />
		protected System.Web.UI.WebControls.DropDownList ddlForm;<br />
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;<br />
		protected System.Web.UI.WebControls.Button Button1;<br />
		protected System.Web.UI.WebControls.Panel Panel1;<br />
		protected System.Web.UI.WebControls.DataGrid DataGrid1;<br />
		protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1;<br />
		protected System.Web.UI.WebControls.Label lblErrMsg;<br />
		protected TCAIMS.Server.Navigator MenuNav;<br />
		protected System.Web.UI.WebControls.Button TIR_Score;<br />
		private string strConnection = ConfigurationSettings.AppSettings["TCAIMSDataCon"];<br />
<br />
	<br />
		private void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
			<br />
<br />
			if(!IsPostBack)<br />
			{<br />
				string connectionString = strConnection;<br />
				OleDbConnection con = new OleDbConnection(connectionString);<br />
				CUsers user =new CUsers();<br />
				user=(CUsers)Session["SessionUser"];<br />
				<br />
				<br />
				if(user.DAG.ToString() == "False")<br />
				{<br />
					Panel1.Visible=false;<br />
					lblErrorMsg.Visible=true;<br />
				}<br />
				<br />
				CountRecords();<br />
				<br />
			}<br />
		}<br />
<br />
		private void CountRecords()<br />
		{<br />
<br />
			string connectionString = strConnection;<br />
			OleDbConnection con = new OleDbConnection(connectionString);<br />
			DataSet dsDagFlagCnt = new DataSet("dsDagFlagCnt");<br />
			DataTable tblDagFlags = new DataTable("tblDagFlags");<br />
			try<br />
			{<br />
				con.Open();<br />
			<br />
				string[] list = {"DEMO", "Task_Questionnaire", "Software_Usability_Survey", "Test_Incident_Report", "Workstation_Profile", "t_EOT_IA", "t_EOT_SA", "t_EOT_Security", "t_EOT_SMEpart1", "t_EOT_SMEpart2", "t_EOT_User", "Equipment_Daily_Status"};<br />
<br />
				<br />
				//			dsDagFlagCnt.Tables.Add(tblDagFlags);<br />
				tblDagFlags.Columns.Add("TableName", typeof(string));<br />
			<br />
<br />
				<br />
				tblDagFlags.Columns.Add("AECVote_NV", typeof(int));<br />
				tblDagFlags.Columns.Add("AECVote_P", typeof(int));<br />
				tblDagFlags.Columns.Add("AECVote_NA", typeof(int));<br />
				tblDagFlags.Columns.Add("AECVote_A", typeof(int));<br />
				tblDagFlags.Columns.Add("AECVote_L", typeof(int));<br />
<br />
				tblDagFlags.Columns.Add("OTCVote_NV", typeof(int));<br />
				tblDagFlags.Columns.Add("OTCVote_P", typeof(int));<br />
				tblDagFlags.Columns.Add("OTCVote_NA", typeof(int));<br />
				tblDagFlags.Columns.Add("OTCVote_A", typeof(int));<br />
				tblDagFlags.Columns.Add("OTCVote_L", typeof(int));<br />
<br />
				tblDagFlags.Columns.Add("PMVote_NV", typeof(int));<br />
				tblDagFlags.Columns.Add("PMVote_P", typeof(int));<br />
				tblDagFlags.Columns.Add("PMVote_NA", typeof(int));<br />
				tblDagFlags.Columns.Add("PMVote_A", typeof(int));<br />
				tblDagFlags.Columns.Add("PMVote_L", typeof(int));<br />
<br />
				tblDagFlags.Columns.Add("HQDAVote_NV", typeof(int));<br />
				tblDagFlags.Columns.Add("HQDAVote_P", typeof(int));<br />
				tblDagFlags.Columns.Add("HQDAVote_NA", typeof(int));<br />
				tblDagFlags.Columns.Add("HQDAVote_A", typeof(int));<br />
				tblDagFlags.Columns.Add("HQDAVote_L", typeof(int));<br />
<br />
				tblDagFlags.Columns.Add("NAVYVote_NV", typeof(int));<br />
				tblDagFlags.Columns.Add("NAVYVote_P", typeof(int));<br />
				tblDagFlags.Columns.Add("NAVYVote_NA", typeof(int));<br />
				tblDagFlags.Columns.Add("NAVYVote_A", typeof(int));<br />
				tblDagFlags.Columns.Add("NAVYVote_L", typeof(int));<br />
<br />
				DataRow rw;<br />
<br />
				//			<br />
<br />
				foreach (string table in list)<br />
				{<br />
					// count AEC Records have to do this for each voting group<br />
					int countNVaec = CountTableRecordsAEC(table, "Not Viewed", con);<br />
					int countPaec = CountTableRecordsAEC(table, "Pending", con);<br />
					int countNAaec = CountTableRecordsAEC(table, "Not Authenicated", con);<br />
					int countAaec = CountTableRecordsAEC(table, "Authenicated", con);<br />
					int countLaec = CountTableRecordsAEC(table, "Limited Use", con);<br />
<br />
					// count OTC records <br />
					int countNVotc = CountTableRecordsOTC(table, "Not Viewed", con);<br />
					int countPotc = CountTableRecordsOTC(table, "Pending", con);<br />
					int countNAotc = CountTableRecordsOTC(table, "Not Authenicated", con);<br />
					int countAotc = CountTableRecordsOTC(table, "Authenicated", con);<br />
					int countLotc = CountTableRecordsOTC(table, "Limited Use", con);<br />
					<br />
					// count PM records<br />
					<br />
					int countNVpm = CountTableRecordsPM(table, "Not Viewed", con);<br />
					int countPpm = CountTableRecordsPM(table, "Pending", con);<br />
					int countNApm = CountTableRecordsPM(table, "Not Authenicated", con);<br />
					int countApm = CountTableRecordsPM(table, "Authenicated", con);<br />
					int countLpm = CountTableRecordsPM(table, "Limited Use", con);<br />
<br />
					// count HQDA records<br />
					int countNVhqda = CountTableRecordsHQDA(table, "Not Viewed", con);<br />
					int countPhqda = CountTableRecordsHQDA(table, "Pending", con);<br />
					int countNAhqda = CountTableRecordsHQDA(table, "Not Authenicated", con);<br />
					int countAhqda = CountTableRecordsHQDA(table, "Authenicated", con);<br />
					int countLhqda = CountTableRecordsHQDA(table, "Limited Use", con);<br />
<br />
					// count navy records<br />
<br />
					int countNVnavy = CountTableRecordsNAVY(table, "Not Viewed", con);<br />
					int countPnavy = CountTableRecordsNAVY(table, "Pending", con);<br />
					int countNAnavy = CountTableRecordsNAVY(table, "Not Authenicated", con);<br />
					int countAnavy = CountTableRecordsNAVY(table, "Authenicated", con);<br />
					int countLnavy = CountTableRecordsNAVY(table, "Limited Use", con);<br />
<br />
					<br />
					int totflgs = 0;<br />
//					totflgs=countNVaec+countPaec+countNAaec+countAaec;<br />
					totflgs=countNVaec;<br />
<br />
			<br />
				<br />
					rw = tblDagFlags.NewRow();<br />
					rw["TableName"] = table;<br />
<br />
					//aec<br />
					rw["AECVote_NV"] = countNVaec;<br />
					rw["AECVote_P"] = countPaec;<br />
					rw["AECVote_NA"] = countNAaec;<br />
					rw["AECVote_A"] = countAaec;<br />
					rw["AECVote_L"] = countLaec;<br />
					//otc<br />
					rw["OTCVote_NV"] = countNVotc;<br />
					rw["OTCVote_P"] = countPotc;<br />
					rw["OTCVote_NA"] = countNAotc;<br />
					rw["OTCVote_A"] = countAotc;<br />
					rw["OTCVote_L"] = countLotc;<br />
<br />
					//pm<br />
					rw["PMVote_NV"] = countNVpm;<br />
					rw["PMVote_P"] = countPpm;<br />
					rw["PMVote_NA"] = countNApm;<br />
					rw["PMVote_A"] = countApm;<br />
					rw["PMVote_L"] = countApm;<br />
<br />
<br />
					// HQDA<br />
					rw["HQDAVote_NV"] = countNVhqda;<br />
					rw["HQDAVote_P"] = countPhqda;<br />
					rw["HQDAVote_NA"] = countNAhqda;<br />
					rw["HQDAVote_A"] = countAhqda;<br />
					rw["HQDAVote_L"] = countLhqda;<br />
<br />
					//navy<br />
					rw["NAVYVote_NV"] = countNVnavy;<br />
					rw["NAVYVote_P"] = countPnavy;<br />
					rw["NAVYVote_NA"] = countNAnavy;<br />
					rw["NAVYVote_A"] = countAnavy;<br />
					rw["NAVYVote_L"] = countLnavy;<br />
<br />
					//tot<br />
//					rw["TOT_NV"] = countNVaec+countNVotc+countNVpm+countNVhqda+countNVnavy;<br />
//                    rw["TOT_P"] = countPaec+countPotc+countPpm+countPhqda+countPnavy;<br />
//					rw["TOT_NA"] = countNAaec+countNAotc+countNApm+countNAhqda+countNAnavy;<br />
//					rw["TOT_A"] = countAaec+countAotc+countApm+countAhqda+countAnavy;<br />
//					rw["TOTVote"] = totflgs;<br />
//					rw["TOT_NV"] = countNVaec;<br />
//					rw["TOT_P"] = countPaec;<br />
//					rw["TOT_NA"] = countNAaec;<br />
//					rw["TOT_A"] = countAaec;<br />
//					rw["TOTVote"] = totflgs;<br />
					tblDagFlags.Rows.Add(rw);<br />
<br />
					if(totflgs > 0)<br />
					{<br />
						ddlForm.Items.Add(table); //text displayed in dropdown<br />
					}<br />
                    				<br />
				}<br />
			}<br />
			catch (Exception e)<br />
			{<br />
				HandleErrors(e.Message.ToString());<br />
			}<br />
			finally<br />
			{<br />
				if (con.State == ConnectionState.Open)<br />
					con.Close();<br />
			}<br />
			<br />
			DataGrid1.DataSource = tblDagFlags;<br />
			DataGrid1.DataBind();<br />
		}<br />
<br />
		private void HandleErrors(string ErrorMessage)<br />
		{<br />
			lblErrMsg.Text=ErrorMessage;<br />
		}<br />
<br />
<br />
		private void DeleteFlags(OleDbConnection con)<br />
		{<br />
			string query = "Delete * from DagFlagCnt";<br />
			OleDbCommand command = new OleDbCommand(query, con);<br />
			command.ExecuteNonQuery();<br />
			command.Dispose();<br />
		}<br />
<br />
		private int CountTableRecordsAEC(string table, string flag, OleDbConnection con)<br />
		{<br />
			string query = <br />
				string.Format("SELECT Count([AEC Vote]) " +  <br />
				"  FROM {0}" +<br />
				"  WHERE [AEC Vote] = '{1}'", table, flag);<br />
<br />
			OleDbCommand command = new OleDbCommand(query, con);<br />
			int count = (int)command.ExecuteScalar();<br />
			command.Dispose();<br />
			return count;<br />
		}<br />
		private int CountTableRecordsOTC(string table, string flag, OleDbConnection con)<br />
		{<br />
			string query = <br />
				string.Format("SELECT Count([OTC Vote]) " +  <br />
				"  FROM {0}" +<br />
				"  WHERE [OTC Vote] = '{1}'", table, flag);<br />
<br />
			OleDbCommand command = new OleDbCommand(query, con);<br />
			int count = (int)command.ExecuteScalar();<br />
			command.Dispose();<br />
			return count;<br />
		}<br />
<br />
		private int CountTableRecordsPM(string table, string flag, OleDbConnection con)<br />
		{<br />
			string query = <br />
				string.Format("SELECT Count([TCA2_PM Vote]) " +  <br />
				"  FROM {0}" +<br />
				"  WHERE [TCA2_PM Vote] = '{1}'", table, flag);<br />
<br />
			OleDbCommand command = new OleDbCommand(query, con);<br />
			int count = (int)command.ExecuteScalar();<br />
			command.Dispose();<br />
			return count;<br />
		}<br />
<br />
		private int CountTableRecordsHQDA(string table, string flag, OleDbConnection con)<br />
		{<br />
			string query = <br />
				string.Format("SELECT Count([HQDA Vote]) " +  <br />
				"  FROM {0}" +<br />
				"  WHERE [HQDA Vote] = '{1}'", table, flag);<br />
<br />
			OleDbCommand command = new OleDbCommand(query, con);<br />
			int count = (int)command.ExecuteScalar();<br />
			command.Dispose();<br />
			return count;<br />
		}<br />
		private int CountTableRecordsNAVY(string table, string flag, OleDbConnection con)<br />
		{<br />
			string query = <br />
				string.Format("SELECT Count([Navy Vote]) " +  <br />
				"  FROM {0}" +<br />
				"  WHERE [Navy Vote] = '{1}'", table, flag);<br />
<br />
			OleDbCommand command = new OleDbCommand(query, con);<br />
			int count = (int)command.ExecuteScalar();<br />
			command.Dispose();<br />
			return count;<br />
		}<br />
<br />
<br />
<br />
<br />
//Not Using anymore<br />
//		private void LoadFlagsGrid(OleDbConnection con)<br />
//		{<br />
//<br />
//			string sqlFlagCnt = "Select [TableName],[Flag_D_E2E],[Flag_Z_E2E],[Flag_X_E2E]," +<br />
//				"[Flag_D_Pilot],[Flag_Z_Pilot],[Flag_X_Pilot],[Flag_D_Record],[Flag_Z_Record],[Flag_X_Record], [TotFlgCnt] FROM DagFlagCnt";<br />
//<br />
//			OleDbCommand FlagCmd = new OleDbCommand(sqlFlagCnt, con);<br />
//			<br />
//			DataSet dsDagFlagCnt = new DataSet("dsDagFlagCnt");<br />
//			DataTable tblDagFlags = new DataTable("tblDagFlags");<br />
//			tblDagFlags.Columns.Add("TableName", typeof(string));<br />
//			dsDagFlagCnt.Tables.Add(tblDagFlags);<br />
//			<br />
//			DataRow rw;<br />
//			rw = tblDagFlags.NewRow();<br />
//			rw["TableName"] = "Demographics";<br />
//			tblDagFlags.Rows.Add(rw);<br />
//               <br />
//			//SetDropdown(tblDagFlags);<br />
//			con.Close();<br />
//			<br />
//		}<br />
<br />
		private void SetDropdown(DataTable tblDagFlags)<br />
		{<br />
<br />
		}<br />
<br />
		#region Web Form Designer generated code<br />
		override protected void OnInit(EventArgs e)<br />
		{<br />
			//<br />
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.<br />
			//<br />
			InitializeComponent();<br />
			base.OnInit(e);<br />
		}<br />
		<br />
		/// <summary><br />
		/// Required method for Designer support - do not modify<br />
		/// the contents of this method with the code editor.<br />
		/// </summary><br />
		private void InitializeComponent()<br />
		{    <br />
			this.Button1.Click += new System.EventHandler(this.Button1_Click);<br />
			this.TIR_Score.Click += new System.EventHandler(this.TIR_Score_Click);<br />
			this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);<br />
			this.Load += new System.EventHandler(this.Page_Load);<br />
<br />
		}<br />
		#endregion<br />
<br />
		private void Button1_Click(object sender, System.EventArgs e)<br />
		{<br />
			    if(ddlForm.SelectedValue.ToString() == "DEMO")<br />
				{<br />
					Response.Redirect("../NewDag/Demographics.aspx");<br />
				}<br />
				else<br />
					Response.Redirect("../NewDag/"+ddlForm.SelectedValue+".aspx");<br />
<br />
		}<br />
<br />
		private void TIR_Score_Click(object sender, System.EventArgs e)<br />
		{<br />
			Response.Redirect("../NewDag/TIR_Score.aspx");<br />
		}<br />
<br />
		private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)<br />
		{<br />
		<br />
		}<br />
	}<br />
}<br />

Paddy Boyd1-May-07 23:22

1-May-07 23:22

I think you'll find few people who are going to read through the entire code of your page. Which bit in particular isn't working...?

Ibuprofen1-May-07 23:24

1-May-07 23:24

It functions, but its not display accurate counts of my data in my tables. Is there a better way to do this?

Paddy Boyd1-May-07 23:29

1-May-07 23:29

In what way inaccurate, and is there a particular bit of the code that you are getting problems with?

Ibuprofen2-May-07 0:09

2-May-07 0:09

It's not counting my actual voted fields.

All the counts end up as the total number of records in the db. Or some other crazy number.

N a v a n e e t h1-May-07 23:23

N a v a n e e t h

1-May-07 23:23

How a person can identify where you are wrong from such a lengthy code ?

printf("Navaneeth!!")

www.w3hearts.com

Ibuprofen1-May-07 23:25

1-May-07 23:25

More looking at getting some comments on a better way to do counting for certain critera, so I posted my whole code so everyone could see how I was doing it.

Christian Graus2-May-07 1:23

Christian Graus

2-May-07 1:23

No-one is going to read all this, and without your DB, they cannot use it to try and reproduce the issue.

Go into SQL Server and play with SQL until you find something that accurately counts your values. Then use that.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Ibuprofen2-May-07 17:19

[Message Deleted] [modified]

2-May-07 17:19

Well, it truly does prove how much better it is to just have someone elses eyes on your code, I sent it to a friend and fellow programmer, and as he was reviewing it, I found my TYPO's. Fixed and counts were correct.

srinandan..1-May-07 23:05

srinandan..

1-May-07 23:05

hi following problem please help
Sys.WebForms.PageRequestManagerTimeoutException: The server request timed out.
-- modified at 7:20 Friday 18th May, 2007

Re: ajax web extensiom problem (pls urgent)

Gamzun1-May-07 23:45

Gamzun

1-May-07 23:45

did you install aspajaxextsetup for ajax web extension

Re: ajax web extensiom problem (pls urgent)

srinandan..2-May-07 0:03

srinandan..

2-May-07 0:03

hi
yes i have installed ajax web extension

Regards,
Srinandna

Re: ajax web extensiom problem (pls urgent)

Gamzun2-May-07 0:10

Gamzun

2-May-07 0:10

did you install aspajaxEXTSetup, if so then try reinstalling it.

Search code using Asp.Net and SQL 2000

Stormint1-May-07 22:58

Stormint

1-May-07 22:58

Will you kindly help me with a search code using Asp.net and SQL 2000 coz I an designing a program that can search Client Name in the Sql. ROMEO

Romeo

Re: Search code using Asp.Net and SQL 2000

Paddy Boyd1-May-07 23:23

Re: Search code using Asp.Net and SQL 2000

1-May-07 23:23

SELECT * FROM ATable WHERE CLIENTNAME LIKE '%searchtext%'

Paddy Boyd2-May-07 3:48