User Profile

Collapse

Profile Sidebar

Collapse
camel
camel
Last Activity: Feb 3 '08, 09:04 AM
Joined: Jan 2 '08
Location: UK
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • camel
    replied to Window application with Internet
    in .NET
    Assuming you mean display a web page, try the Web Browser control...
    See more | Go to post

    Leave a comment:


  • camel
    replied to how to split a coloumn into 5 coloumn
    You could use SUBSTRING
    See more | Go to post

    Leave a comment:


  • camel
    replied to Tab control in web application based C#
    in .NET
    Net 2.0 - look at the MultiView control in harness with a Menu (you can make a menu look any way you want more or less). Earlier versions I wrote my own control to do it, you can achieve something that acts like tabs fairly readily. I dare say there is a free control\source code out there somewhere if you google
    See more | Go to post

    Leave a comment:


  • camel
    replied to Is ADO really dying?
    News to me, on .Net 3.0 and looking at .Net 3.5 in beta and all I can see is yet more ADO.Net, maybe someone is pulling your leg ? :) unless you are still on VB6 in which case about time you moved off there for sure..
    See more | Go to post

    Leave a comment:


  • Its entirely up to you, since you were looking for a different perspective I am happy to provide one. FYI I was batch creating 100s of precompiled reports to send to network folders and by email more than 10 years ago with the then Crystal distribution engine. This is 10 years & umpteen versions on so presumably better, whilst even 7 years ago used Active Reports same way.

    Obviously tried various versions of Excel along the way...
    See more | Go to post

    Leave a comment:


  • camel
    replied to Storing a doc file in BLOB?
    in .NET
    This seems to be a popular question at the moment in these forums, please see my response to effectively the same question here:
    http://www.thescripts. com/forum/thread758454.ht ml
    See more | Go to post

    Leave a comment:


  • You can store the document in SQL Server as a BLOB, the datatype is called Image in more recent versions of SQL Server. Look up SQL Server & BLOB in Google and you shall get a host of links explaining how to do this using ADO.

    One caveat you should be aware of...whilst you can store any form of file in SQL Server as a BLOB that does not mean that you should. You need to think carefully about the likely size of files you will be...
    See more | Go to post

    Leave a comment:


  • camel
    replied to How do you insert a DataTable into a Database?
    in .NET
    I should of course have given DMO its proper name SQLDMO, which stands for Distributed Management Objects or Database Management Objects. Anyway in .Net with SQL Server 2005 you have SMO so don't need SQLDMO.

    In short the reason you can't find the answer you are looking for is the answer is "no", it makes sense to separate the classes that manipulate data from those that manipulate structure and that is what Microsoft have...
    See more | Go to post

    Leave a comment:


  • camel
    replied to Cancel the execution of a query in ado.net
    in .NET
    Utilise an ADO.Net Transaction object would be my first thought and call Abort in response to the cancel command. Alternatively just set a variable when Cancel is hit and check that before deciding to populate the grid\clear the grid if is set depending on the timing of the data retrieval and binding taking place.
    See more | Go to post

    Leave a comment:


  • Advice wise, I can't say I would have thought of using any of these mechanisms anytime since 2002 when .Net came out, especially when it sounds like the reports are initiated via ASP which may or may not mean the reports actually run in real time? In fact even pre 2002 I would have used Crystal or Active Reports over Excel as either format can be exported to Excel and is better suited to the report generation task.

    Nowadays the obvious...
    See more | Go to post

    Leave a comment:


  • camel
    replied to How do you insert a DataTable into a Database?
    in .NET
    Gosh this thread got carried away after what I thought was an intial "cover either question" answer ! I had to look up "snarky", not a word I would associate with.

    The simple answer I believe was provided at the outset but obviously not explained clearly. You cannot create a database table directly from an ADO DataTable or DataSet, that is not the purpose of these objects which are by definition for manipulating...
    See more | Go to post

    Leave a comment:


  • camel
    replied to web service as an http call.
    in .NET
    Please clarify what you mean by "http" call, any communication with a Web Service will be a "http" call as that is the nature of the beast. Do you mean call using XML\HTTP rather than calling from code in a proxy class?
    See more | Go to post

    Leave a comment:


  • camel
    replied to How do you insert a DataTable into a Database?
    in .NET
    If you are asking how to get data into SQL Server that is held in a DataTable the answer would be associate an Adapter or Command to DataTable and Update.

    If you are asking how to add a physical Table to a SQL Server Database you would use SMO\SQLDMO or straight TSQL, not ADO. You could also use an OleDb connection to define a new table but it would not have any data in it.
    See more | Go to post

    Leave a comment:


  • camel
    replied to reading of .ldf files from sql server
    Have a look at DBCC LOG, 3rd party tools also available e.g. Lumigent
    See more | Go to post

    Leave a comment:


  • camel
    replied to Opening .ldf Files
    There are some 3rd party tools to do this, Lumigent is the best known one. If you are committed ? :) you can use the DBBC LOG command but be warned the detailed output is difficult to decode which is why 3rd party tools exist.
    See more | Go to post

    Leave a comment:


  • camel
    replied to SQL 2k - xp_cmdshell
    Casting my mind back to SQL2K, when you right click on the extended SP in master db named xp_cmdshell it should tell you the name of the DLL behind it, you can then move it to another location.

    This will cause any calling process that tries to execute xpcmdshell to break. I would not recommend this, for you are potentially taking a chance that legit routines you may be unaware of everything relying on xpcmdshell, i.e., MS procedures...
    See more | Go to post

    Leave a comment:


  • camel
    replied to Windows Integrated Authentication
    in .NET
    Seems a bit obvious, but why don't you just put a login form on startup page? Successful login therein can set a session value or cookie, failure to login via the form denies access to any other pages as you just don't show navigation tree until successful\disa ble navigation links. If your particular concern is people using other's already logged in machines then you could compare form entered login details to the Windows NT detail you can pick up...
    See more | Go to post

    Leave a comment:


  • camel
    replied to Only one form running in runtime.
    in .NET
    There is not a single answer to this, you basically have to keep track of last active form, load new form, and dispose the previous. The following uses a public property on the parent MDI form that sets a local variable to hold the previous form handle just before setting new child form value, then LoadForm().
    It was readily to hand but should give you a good idea of how to approach it.

    Code:
            private void LoadForm()
    ...
    See more | Go to post

    Leave a comment:


  • Check out System.Drawing. Text.InstalledF ontCollection
    See more | Go to post

    Leave a comment:


  • camel
    replied to Xml schema doubt
    in .NET
    Xml Schema is used to describe the structure a Xml Document should have and can therefore be used to validate Xml Documents and to communicate to others what constitutes a valid Xml Document for representing particular information. You don't as such create a Xml Document "from a schema", you create a Xml Document by whatever means you wish so that it accords with a schema.
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...