Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: arpan
  • Order by date
  1. arpan

    Tables!

    Thanks, Chip, for your response. As you say,objDS.Tables("Users")returns an object of type System.Data.DataTable but then what doesobjDS.Tablesdo? Doesn't it return an object of type System.Data.DataTable? If no, then what exactly does it do? Also the Add method is a member of which object...
  2. arpan

    Tables!

    The following ASPX code works fine.... Sub Page_Load(obj As Object,ea As EventArgs) Dim objDS As New DataSet Dim objDT As New DataTable("Users") objDT.Columns.Add("ID",Type.GetType("System.Int32")) objDT.Columns.Add("FName",Type.GetType("System.String"))...
  3. arpan

    Looping!

    Hey Dazzled, You need not answer my follow-up query regarding Primary Key. I have got the solution. Omitted brackets in the "Dimming" line! It should have beenDim objDC As DataColumn[highlight red]()[/highlight]={objDS.Tables("Users").Columns("ID")} instead ofDim objDC As...
  4. arpan

    Looping!

    Hello Dazzled, One last question please regarding the same ASPX code - I added the following code (which is in red color) in order to define the column ID as a Primary Key: <script language=VB> Sub Page_Load(obj As Object,ea As EventArgs) Dim objDS As New DataSet Dim objDT As New...
  5. arpan

    Looping!

    Thanks, Dazzled, for your reply but to be very honest I was wondering how stupid I can be asking such a stupid question! Getting back to ca8msm's question-actually your question is justified - why would one have to add records manually? The truth is I have just started with ASP.NET & presently...
  6. arpan

    Looping!

    The following ASPX code creates a dynamic DataSet which is then displayed in a DataGrid (using a DataView): <script language=VB> Sub Page_Load(obj As Object,ea As EventArgs) Dim objDS As New DataSet Dim objDT As New DataTable("Users") objDT.Columns.Add("ID",System.Type.GetType("System.Int32"))...
  7. arpan

    Strings

    Hi Lrnmore, Thanks for your help once again. It works great; this is what I was exactly looking out for!! Regards, Arpan
  8. arpan

    Strings

    Hello Lrnmore, I tried out your idea regarding my 'duplicate' query. It works fine but there's a small problem. The problem is as soon as the empty textbox gets populated with the 1st mail address, a semi-colon (;) also gets appended at the end. I want the semi-colon to be appended if & only if...
  9. arpan

    Strings

    Thanks, my dear friends, for all your suggestions & inputs but here's the simplest way to do it: <script language=&quot;JavaScript&quot;> var str=&quot;(mymail@server.com)&quot; str=str.substring(1,str.length-1) </script> No RegExp, no replace()! Just substring().....that's it!!! Regards...
  10. arpan

    Strings

    Suppose I have the following string : (mymail@server.com) Please note that above string is enclosed in braces. Using JavaScript, how do I get rid of the 2 brackets - ( & ) i.e. the string should be just mymail@server.com Thanks, Arpan
  11. arpan

    Populate Textbox With Options Selected

    Thanks, Adam, for your suggestion. It is working exactly as I wanted it to but there is a small hitch. Suppose from the drop-down list, I select the 1st option james@bond.com. The textbox value becomes james@bond.com Next I select the 2nd option which is matt@horne.com. The textbox value...
  12. arpan

    Populate Textbox With Options Selected

    An HTML Form has a drop-down list in which the options are listed by retrieving records from a backend (for which I am using ASP). The options in the drop-down list are displayed as LastName FirstName (e-mail address) The value of each option is a whole number. This HTML Form also includes a...
  13. arpan

    RESTORE Database

    Thanks, mate, for your suggestion. You hit the nail on the head. The DB was named BSI4103 earlier & I wasn't aware of this fact. Later I got it verified from my friend who had created the back-up. Thanks once again, Regards, Arpan
  14. arpan

    RESTORE Database

    This question pertains to SQL Server 2000 running on Win2K Pro. I have a database back-up named BSI4200.bkp is my C: drive. Please note that I haven't made the back-up on my machine; I got it from someone. Now to RESTORE this database, I am using the following code: RESTORE DATABASE BSI4200...
  15. arpan

    Deleting Duplicate Records

    Thanks wolf for your code. It works properly but still a problem exists. If &quot;68&quot; (as per the e.g. I had given) is the 1st number in either the 1st or the 2nd textbox, it does not get deleted from the 2nd textbox (though 68 is present in the 1st textbox). Any workaround to fix this...
  16. arpan

    Deleting Duplicate Records

    Whatever number it is, it will appear only once in the 1st textbox. But it can appear any number of times in the 2nd textbox. Is such cases, all the &quot;68&quot;s should be deleted from the 2nd textbox.
  17. arpan

    Deleting Duplicate Records

    &quot;Fun&quot; ones or the &quot;funny&quot; ones?? What do you mean by &quot;fun&quot; ones? Anyway w.r.t. your 2 doubts, the answers of both the doubts is yes i.e. the values will always be numeric & will always be seperated by a comma? Any other doubts?? I will be happy to clarify them...
  18. arpan

    Deleting Duplicate Records

    An HTML Form has two textboxes. Suppose a user enters 23, 45, 68, 99 in the 1st textbox & in the 2nd textbox, he enters 54, 68, 78, 94. Note that in the 2 textboxes, 68 is common. What I want is under such circumstances, 68 should automatically get deleted from the 2nd textbox (as it is already...
  19. arpan

    Shifting Select List Options

    Hi Jakob, Thanks for your suggestion. There's no doubt that your idea is a good one but if I implement your idea, it would mean consuming a lot of unnecessary server resources. The reason is I am populating both the select lists dynamically from a database (for which I am using ASP). So...
  20. arpan

    Shifting Select List Options

    An HTML Form has 2 select lists along with a checkbox. Assume that the 1st select list shows 3 options - Jan, Feb & Mar. The 2nd select list shows the remaining 9 months. Now what I want is when the checkbox is checked (i.e. using the onClick() event), all the 9 options in the 2nd select list...

Part and Inventory Search

Back
Top