Richard MacCutchan wrote: once heard one of our IT help desk reps ask a colleague "What exactly is hexadecimal?" :omg: "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

you're welcome. :) Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Prolific encyclopedia fixture proof-reader browser patron addict? We all depend on the beast below.

How about restricting the data that you load, with a SELECT TOP 5 FROM [blah]? I are Troll :suss:

A stored proc (or any other sql query) returns zero for success and non-zero for an error Bob Ashfield Consultants Ltd

Thanks for the reply. I will research Custom Paging. I'm sure the answer lies there. Cheers!

Good Call.. I will do that.. I shall use an encryption algorithm. Thanks!

Hi, Thank you so much for the reply. I have done as you said. I have a class file which has 4 private variables declared, and then I have 4 properties for each. The property code for each looks like this: Public Property Artist() As String Get Return strArtist End Get Set(ByVal Value As String) strArtist = Value End Set End Property These are the steps I have taken: In the Main form, OnButtonClick - Dim obj As New cls - obj.Variable1 = Me.Textbox1.Text - obj.Variable2 = Me.Textbox2.Text - obj.Variable3 = Me.Textbox3.Text - obj.Variable4 = Me.Textbox4.Text - arrList.Add(obj) ???? Is this correct? - Me.Listbox1.Items.Add(Textboxe1/2/3/4.Text) THEN, OnListBoxSelectIndexChanged - I need to retrieve the values from the arraylist which at this point holds the class instance - Then I need to put the data back into the original Textboxes. This is the part I am stuck at :( Thanks in advance :)

Silly me .. I found the easiest and most reliable way of doing this.. Simply add another column in the Database called Progress Number. Pending will be 1, Work In Progress will be 2.. etc.. And then simply sort by "ProgressNumber" Thank you guys for the help.

Alternatively, you could use COALESCE(vchRequestNumber, 0) + 1 Deja View - the feeling that you've seen this post before.

Thanks a lot man. Will try to code it =D

hi, if you do not need any formatting in your destination excel file you can create a simple text file with the extension xls. you only have to seperate your content throug vbTab and vbNewLine. solidIT.de - under construction Components for Microsoft .Net audittrail, objectcomparer, deepcopy and much more ...

Thank you very much for SELECT DISTINCT! It works now =D.

Thanks for the reply. I have found the problem after 1 week of debugging!! You will never guess what is was... ... ... I removed Visible="False" then it worked. I suppose visibility affects its functionality lol

Thank you for the reply mate. Very useful info! :)

try to place a required field validator first

Have you tried ?: string sql = @' IF NOT EXISTS(SELECT * FROM foo WHERE user = @username) BEGIN INSERT INTO foo (user) VALUES (@username) SET @Success = 1 END ELSE BEGIN SET @Success = 0 END'; bool bSuccess = false; using(SqlConnection conn = new SqlConnection("connection string")){ SqlCommand cmd = new SqlCommand(conn, sql); cmd.Parameters.Add("@username", SqlDbType.Varchar, 50); cmd.Parameters.Add("@Success", SqlDbType.Bit); cmd.Parameters["@username"].Value = DataSet.Tables[0].Rows[0]["Username"]; cmd.Parameters["@Success"].Direction = ParameterDirection.InputOutput; conn.Open(); cmd.ExecuteNonQuery(); bSuccess = (bool) cmd.Parameters["@Success"].Value; } if(!bSucess) { //tell the user }

I found what the problem was. My application was reloading the page which meant that a few other subroutines were being run before the "Save" subroutine. One of those subroutines was clearing all the the fields which meant that required fields were empty before the record is stored. Hence Me.IsValid was False. Thank you for your replies.

No I haven't. They all have the ControlToValidate property set. I'm still looking into it. It is very strange. Every time I try to submit the form, it restarts the page. Maybe this isn't due to the dropdown? I will investigate..