ASP.NET

Re: Memory Issue for aspnet_wp.exe

2-May-07 0:12

May I suggest reading

http://www.issociate.de/board/post/260520/aspnet_wp.exe_memory_problem.html[^]

just3ala22-May-07 2:56

just3ala2

2-May-07 2:56

Yeah thank u
I already used the GC.Collect() in two in both the log off button and the login page load so the problem was solved Wink | ;)

Thanks again

Best Regards
3ala2 Smile | :)

How to transfer money into diferent accounts

sabby20061-May-07 23:46

sabby2006

1-May-07 23:46

Hello!
I am developing a shopping cart having different merchants!
u user or buyer can purchase from different merchants and all the merchants are having different paypal accounts. Now i want to transfer money payed my the buyer into the accounts of different merchants if he has purchased from different merchants.
for eg.
If he purchased an item of 100 from "A" merchant
and another item of 200 from "B" merchant
Then 100 should go to the account of "A"
and 200 should go to the account of "B"
Payment gateway i am using is PayPal

Regards

Set focus on CheckBox in UpdatePanel

Gamzun1-May-07 23:41

Gamzun

1-May-07 23:41

Im using UpdatePanel ajax extension in asp.net 2.0. I have one checkbox and few texboxes in an UpdatePanel. The checkbox has an event which persorm some task when checked or unchecked. When ever i check or uncheck my CheckBox it loses its control. I've found article for set focus on TextBoxes only, those solution aren't helpful for my problem. Please give my any solution I've searched the whole of internet!
Thanks

Time format

Imran Khan Pathan1-May-07 23:11

Imran Khan Pathan

1-May-07 23:11

Hi friends
I have bit problem in following line

String.Format("{0:t}","11/19/2007 10:00 AM");

I want to get Sort time format:- 10:00 AM

Thanks in advance
pathan

GOD HELP THOSE WHO HELP THEMSELVES

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

Paddy Boyd

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

Paddy Boyd

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