ASP.NET

Ibuprofen1-May-07 6:14

1-May-07 6:14

CausesValidation=true;

On your button propertys make sure that is set.

Ibuprofen1-May-07 6:16

1-May-07 6:16

Also why have to buttons? Ammend and submit? Why arent you just calling the other function, if critera for submit is already met? I am assuming, your UPDATEING a record with your ammend button, versus your SUBMIT button, is being used for the first time the data is being submited?

cullyk1-May-07 6:20

cullyk

1-May-07 6:20

yea I have the causesValidation=true on both buttons

yea that's correct I have two buttons amend and submit. submit for the first time I submit at this stage the amend button is not shown, then when amending I show the amend button and hide the submit button, is this logic flawed?

Ibuprofen1-May-07 6:27

1-May-07 6:27

Yes, you do not need two buttons. You should check if the record is a new record within the same function of your submit button, if it is use your select statement, else use your UPDATE statement.

Ibuprofen1-May-07 6:43

Re: File Upload - Displaying a link

1-May-07 6:43

I know its easily said, but harder written if your a NEWBIE like me, and I am sure users on here will tear this apart, but I've done it a way thats not correct but only one button!

This is my submit button.

		private void btnSubmit_Click(object sender, System.EventArgs e)<br />
		{<br />
			<br />
			bool bNoError=true;<br />
			<br />
			OleDbConnection con = new OleDbConnection(strConnection);<br />
			string strSQL;<br />
			DataSet ds = new DataSet();<br />
			<br />
			strSQL="SELECT Top 1 [q1], [q2], [q3], [q4], [q5], [q6], [q7], [q8],"+<br />
" [q9], [q10], [q11], [q12], [q13], [q14], [q15],"+<br />
" [q16], [q17], [q18], [q19], [q20],"+<br />
" [q21], [q23], [q24], [q26], [q28], [q34], "+<br />
" [q35], [q38], [q39], [q40], [q42], [q43], [q44], [q45], [q46], [q47], [q48], [q51], [q52], [q53], [q54], [q57], [q58], [q61], [q62], [q63], [q66], [q67], [q70], "+<br />
" [q71], [q72], [q73], [q74], [q75], [q84], [q85], [q86], [q87],"+<br />
" [q88], [q89], [q90], [q91], [q98], [q99], [q100], [q101],"+" [q102], [q103], [q104], [TCAIMSSite],"+<br />
" [DTG_Submit], [LoginID], [TestPhase], [Final]  FROM t_EOT_User";<br />
						OleDbDataAdapter da = new OleDbDataAdapter(strSQL,con);	<br />
			//			int RecNum=0;<br />
			try<br />
			{<br />
				da.Fill(ds);<br />
				DataTable mytable =ds.Tables[0];<br />
				DataRow myRow ; <br />
				myRow = mytable.NewRow();<br />
				string n ;<br />
				foreach(DataColumn c in mytable.Columns)<br />
				{<br />
					n = c.ColumnName;<br />
					if(n=="ID")<br />
					{<br />
						continue;<br />
					}<br />
					myRow[n] =ControlTypeCheck.CheckControlType(Page.FindControl(n),n);<br />
				}<br />
				mytable.Rows.Add(myRow);<br />
				OleDbCommandBuilder cb = new OleDbCommandBuilder(da);<br />
				int count1 =da.Update(ds);<br />
			}<br />
			catch(Exception err)<br />
			{<br />
				string s= err.Message;<br />
				bNoError=false;<br />
				UpdateData();				<br />
			}<br />
			finally<br />
			{<br />
				con.Close();<br />
			}<br />
						<br />
			if(bNoError)<br />
			{<br />
				Response.Redirect("../Common/DataSubmitted.aspx");<br />
			}<br />
			else<br />
				HandleErrors();<br />
		}

If you look down in my catch, if there is an error (IE cant do it because it would create a duplicate record), then it supposed to give my an error message, what I did was throw in my update command there, so after it tried select statement if it couldnt do that it would try my update statment. Below is my update statment.

private void UpdateData()<br />
		{<br />
			<br />
			bool bNoError=true;<br />
			<br />
			OleDbConnection con = new OleDbConnection(strConnection);<br />
			string strSQL;<br />
			DataSet ds = new DataSet();<br />
			<br />
			strSQL="UPDATE t_EOT_User set [q1]='"+q1.SelectedValue+"', [q2]='"+q2.Text+"',"+<br />
				" [q3]='"+q3.SelectedValue+"', [q4]='"+q4.Text+"', [q5]='"+q5.SelectedValue+"',"+<br />
				" [q6]='"+q6.Text+"', [q7]='"+q7.SelectedValue+"', [q8]='"+q8.Text+"',"+<br />
				" [q9]='"+q9.SelectedValue+"', [q10]='"+q10.Text+"',"+<br />
				" [q11]='"+q11.SelectedValue+"', [q12]='"+q12.Text+"',"+<br />
				" [q13]='"+q13.SelectedValue+"', [q14]='"+q14.Text+"',"+<br />
				" [q15]='"+q15.Text+"', [q16]='"+q16.Text+"',"+<br />
				" [q17]='"+q17.Text+"', [q18]='"+q18.Text+"',"+<br />
				" [q19]='"+q19.SelectedValue+"', [q20]='"+q20.SelectedValue+"',"+<br />
				" [q21]='"+q21.SelectedValue+"', [q23]='"+q23.Text+"',"+<br />
				" [q24]='"+q24.SelectedValue+"', [q26]='"+q26.Text+"',"+<br />
				" [q28]='"+q28.Text+"', [q34]='"+q34.SelectedValue+"',"+<br />
				" [q35]='"+q35.Text+"', [q38]='"+q38.SelectedValue+"',"+<br />
				" [q39]='"+q39.Text+"', [q40]='"+q40.SelectedValue+"',"+<br />
				" [q42]='"+q42.Text+"', [q43]='"+q43.SelectedValue+"',"+<br />
				" [q44]='"+q44.Text+"', [q45]='"+q45.SelectedValue+"',"+<br />
				" [q46]='"+q46.Text+"', [q47]='"+q47.SelectedValue+"',"+<br />
				" [q48]='"+q48.Text+"', [q51]='"+q51.SelectedValue+"',"+<br />
				" [q52]='"+q52.Text+"', [q53]='"+q53.SelectedValue+"',"+<br />
				" [q54]='"+q54.Text+"', [q57]='"+q57.SelectedValue+"',"+<br />
				" [q58]='"+q58.Text+"', [q61]='"+q61.Text+"',"+<br />
				" [q62]='"+q62.Text+"', [q63]='"+q63.SelectedValue+"',"+<br />
				" [q66]='"+q66.SelectedValue+"', [q67]='"+q67.Text+"',"+<br />
				" [q70]='"+q70.SelectedValue+"', [q71]='"+q71.Text+"',"+<br />
				" [q72]='"+q72.SelectedValue+"', [q73]='"+q73.Text+"',"+<br />
				" [q74]='"+q74.SelectedValue+"', [q75]='"+q75.Text+"',"+<br />
				" [q84]='"+q84.SelectedValue+"', [q85]='"+q85.Text+"',"+<br />
				" [q86]='"+q86.SelectedValue+"', [q87]='"+q87.Text+"',"+<br />
				" [q88]='"+q88.SelectedValue+"', [q89]='"+q89.Text+"',"+<br />
				" [q90]='"+q90.Text+"', [q91]='"+q91.Text+"',"+<br />
				" [q98]='"+q98.SelectedValue+"', [q99]='"+q99.SelectedValue+"',"+<br />
				" [q100]='"+q100.Text+"', [q101]='"+q101.SelectedValue+"',"+<br />
				" [q102]='"+q102.Text+"', [q103]='"+q103.SelectedValue+"',"+<br />
				" [q104]='"+q104.Text+"', [Final]='"+Final.SelectedValue+"' WHERE RecNum="+RecNum.Text;<br />
<br />
			OleDbDataAdapter da = new OleDbDataAdapter(strSQL,con);	<br />
			//			int RecNum=0;<br />
			try<br />
			{<br />
				OleDbCommand cmd = con.CreateCommand();<br />
				cmd.CommandText=strSQL;<br />
				con.Open();<br />
				cmd.ExecuteNonQuery();<br />
			}<br />
			catch(Exception err)<br />
			{<br />
				string s= err.Message;<br />
				bNoError=false;<br />
			}<br />
			finally<br />
			{<br />
				con.Close();<br />
			}<br />
						<br />
			if(bNoError)<br />
			{<br />
				Response.Redirect("../Common/DataSubmitted.aspx");<br />
			}<br />
			else<br />
				HandleErrors();<br />
		}

Ibuprofen1-May-07 8:34

Button text on Wizard control

1-May-07 8:34

No one?

object to long cast

Keith Andersch1-May-07 5:19

Keith Andersch

1-May-07 5:19

Hi all.

I have this vexxing problem which showed up when I moved from my dev/test box to a production server. What I'm trying to do is get the pwdLastSet property from Active Diretory. I'm using a DirectorySearcher object to get the pwdLastSet property. Once you get the property, you can cast the data to a long to get the total ticks since 1970. This works like a dream on my XP/IIS 5.1/ASP.Net 2.0 box. Once I moved it out to the Windows 2000/IIS 5.0/ASP.net 2.0 production server, the casting fails. It is my understanding that the DirectorySearcher object is supposed to marshall the data from Active Directory into something that's easier to use. I see this being done in my debugging sessions on my dev box. I would love to setup a debugging session on the production server, but that's a whole other set of issues. I do notice though if I take that whole class where the error is happening, put it into a simple C# windows app, compile it on my dev box, it will run correctly on the production server. I'm thinking that when it gets compiled on the production server, the marshalling doesn't happen corretly. I'm now leaning towards sticking the offending code into a dll. Has anybody else seen this type of issue? Is there some compile time flags that can be set?

Keith

Re: object to long cast

Keith Andersch1-May-07 7:43

Keith Andersch

1-May-07 7:43

An update. I tried to precompile the whole site and making the offending class a dll by itself. Both options give me invalid casts still. Is there additional compilation going on? It just seems to work everywhere besides inside the asp.net worker process for Win2000...

Re: object to long cast

Keith Andersch2-May-07 11:05

Keith Andersch

2-May-07 11:05

Just to cap this off, whatever the problem was became fixed after doing a iisreset. I discovered this on accident while attempting to get remote debugging running. So one problem down, one to go.

digsy_1-May-07 3:47

digsy_

1-May-07 3:47

I am trying to change the text shown on the navigation buttons on the Wizard control.

I have tried using the following code:

Wizard1.StepNextButtonText = "click me";
Wizard1.StartNextButtonText = "Go";
Wizard1.FinishCompleteButtonText = "End";

For some reason, this only works for Step Next buttons - I cannot change the text on the buttons on the Start or Finish steps.

I have tried setting the StepType as "Auto" or "Start" & "Finish" but this does not fix the problem.

Does anyone know what I am doing wrong ?

How can we come to know email is delivered or not

Software_Guy_1231-May-07 3:41

Software_Guy_123

1-May-07 3:41

Hello All,

How can we come to know email is delivered to receipients or not, any help is greatly appreciated.

Thanks & Regards,
Kumar

Re: How can we come to know email is delivered or not

Colin Angus Mackay1-May-07 4:29

Colin Angus Mackay

1-May-07 4:29

There is no guaranteed way of knowing.

Upcoming events:
* Glasgow: Introduction to AJAX (2nd May), SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services...

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Re: How can we come to know email is delivered or not

DavidNohejl1-May-07 4:38

DavidNohejl

1-May-07 4:38

What Colin said. Why? Imagine if spammers had that ability...

"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
"Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe

Database with the Project

.NET- India 1-May-07 1:25

.NET- India

1-May-07 1:25

Hi All,
Is there any way to include the database with the ASP.NETC#)web based project
so that there shoulde be no need to install the database on the target machine's SQL Server2000

Re: Database with the Project

Colin Angus Mackay1-May-07 4:28

Colin Angus Mackay

1-May-07 4:28

You asked virtually the same question[^] 2 hours 21 minutes previously. Please be patient.

Embedding Database in ASP.NET Project

.NET- India 30-Apr-07 23:04

.NET- India

30-Apr-07 23:04

Hello All,
Can we include the SQL-Server2000 database named 'dataFile' in ASP.NET web based project. If yes plz give the steps to solve my problem

And also what is the use of "Generate SQL Script" in SQL Server2000

Thanx in advance

Re: Embedding Database in ASP.NET Project

Colin Angus Mackay1-May-07 4:26

Colin Angus Mackay

1-May-07 4:26

The Knowledge wrote:
Can we include the SQL-Server2000 database named 'dataFile' in ASP.NET web based project. If yes plz give the steps to solve my problem

No. SQL Server is a server based database, not a file based database. You can, however, include a backup and you can use some SQL to restore that backup.

The Knowledge wrote:
And also what is the use of "Generate SQL Script" in SQL Server2000

This is going to sound really obvious: The purpose of "Generate SQL Script" is to write a SQL Script to a file. The script, if run, will recreate the objects that you specified. Why don't you play with it in a development or testing environment? Find out what it does. Explore. Experiment. Learn.

validating a date

Ayman Mashal30-Apr-07 22:56

Ayman Mashal

30-Apr-07 22:56

hi

i am trying to validate a string that contains a date
using DateTime.parse function

but this function accepts for example the date "31-feb-2007" !!

how can i validate the date to be valid not just the format .

thanks

arun rajappan1-May-07 0:04

arun rajappan

1-May-07 0:04

hi,

i think u can use a regularexpression along with the parser....its up to u

arun

rujuc#1-May-07 0:16

rujuc#

1-May-07 0:16

Use this function for date validation.

//Date validator
public static bool validateDateTime(object _datetime)
{
try{
DateTime testdate = DateTime.Parse(_datetime as string);
return true;
}
catch{
return false;
}
}

PandemoniumPasha1-May-07 1:06

PandemoniumPasha

1-May-07 1:06

if you are using VB.NET there is a function - IsDate() which can be used to validate the date.
you could also use compare or range validators, depending on your choice and use, to check the data type. but i don't think these will validate if the date string contains alphabets as expressed in your example.

but if you are using C#.NET, i think try-catch block (as someone already mentioned) will do the job. Smile | :)

hope this helps

regards
Smile | :)

Ayman Mashal1-May-07 1:15

Ayman Mashal

1-May-07 1:15

thank u all
the try/catch block works fine

RSArockiam1-May-07 1:20

RSArockiam

1-May-07 1:20

try this

bool validatedate(string datestr)<br />
{<br />
try {<br />
System.Globalization.CultureInfo culture = new System.Globalization.CultureInfo("en-US");<br />
DateTime tmpDate= DateTime.ParseExact(date, "dd-MMM-yyyy", culture);<br />
return true;<br />
}<br />
catch(Exception ex)<br />
{<br />
return false;<br />
}<br />
}

Regards
R.Arockiapathinathan