ASP.NET Discussion Boards

First Prev Next

Re: Causing validation on postback

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?

Re: Causing validation on postback

Ibuprofen1-May-07 6:27

Ibuprofen

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.

Re: Causing validation on postback

Ibuprofen1-May-07 6:43

Ibuprofen

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 />
		}

Re: File Upload - Displaying a link

Ibuprofen1-May-07 8:34

Ibuprofen

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.

Button text on Wizard control

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

Re: validating a date

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

Re: validating a date

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;
}
}

Re: validating a date

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 | :)

Re: validating a date

Ayman Mashal1-May-07 1:15

Ayman Mashal

1-May-07 1:15

thank u all
the try/catch block works fine

Re: validating a date

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

Re: validating a date

eggsovereasy1-May-07 5:48

eggsovereasy

1-May-07 5:48

Instead of using exception handling as logic as some people have suggested try something like this:

public bool ValidateDate(string date)
{
  DateTime temp;
  return DateTime.TryParse(date, out temp);
}

Javascript strangeness [modified]

RichardGrimmer30-Apr-07 22:00

RichardGrimmer

30-Apr-07 22:00

Morning all.

I've been playing around with "customizing" the XMLHttp object using javascript to provide some extra functionality to it. Specifically, I've been trying to add a Timestamp field to the object, for tracking purposes.

Now as we all know, a javascript object is just a dictionary with string keys - which is why "object" members can be accessed through either the . operator or the [] operator. So far so good. Now since it's a dictionary, we're able to aritrarily add fields as and when we like, so the following code...

<br />
var obj = new ActiveXObject ("Microsoft.XMLHttp");<br />
obj.Timestamp = new Date();<br />

...should add this field to the object. I've tested under IE7 (no no - don't panic, not moaning bout Firefox - it's even stranger than that!), and alles ist gut. However, when I try it under IE6, I'm getting an "object doesn't support this property or method" error on the assignement of the new field - and a quick watch is telling me that indeed it's not there. (Which makes sense since the assignment is failing)

Anyone know what this might be - according to The Great God Google, there were no syntactic changes in the JS engine for IE7, just performance ones...

-- modified at 4:45 Tuesday 1st May, 2007

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

Charts in asp.net

yaminilatha30-Apr-07 21:48

yaminilatha

30-Apr-07 21:48

Hi can anyone help me in giving guidance to create barcharts and piediagrams using the crystalreport in .net. When i searched in the net I am getting all the .net charting softwares but not the guidance to create the charts using crystalreport.

Thanx in advance

Sharepoint Portal in .Net

aaraaayen30-Apr-07 21:32

aaraaayen

30-Apr-07 21:32

Hi friends,

Give me some idea for working with Sharepoint portal in .Net.
Please help me.

Thanks and Regards

Prya

Last Visit: 31-Dec-99 18:00 Last Update: 4-May-24 20:07

Refresh

ᐊ Prev 1...5009 5010 5011 501250135014 5015 5016 5017 5018 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.