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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by PankajBanga

  1. PankajBanga

    Trouble inserting image into DB

    you'll have to convert the image into a byte array and pass the byte array to your stored proc. here the code for converting an image into byte array Dim ms As New System.IO.MemoryStream myImage.Save(ms, myImage.RawFormat) Dim byteArray() As Byte = ms.GetBuffer() ms.Close()
  2. PankajBanga

    UDL/Access 2000 Error

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=YourDataSourcePath;Jet OLEDB:System database=YourSystemDatabasePath;User ID=YourUserID;Password=YourPassword
  3. PankajBanga

    Find Available SQL Server Using SMO Classes in Visual Basic .NET 2005 Application

    Introduction SQL Server 2000 and former included SQL-DMO (Distributed Management Object) a COM based object model, to provide programmatic interface for database management. SQL Server 2005 replaces SQL-DMO with two .NET based object libraries; SQL Server Management Object (SMO) and...
  4. PankajBanga

    SELECT Statement against Excel file?

    The problem is with Extended Property in Connection string... but you get "installable ISAM" error... it’s weird… when u google this error u'll get lots of doc, but none of them will say first check connection string actually Extended Property needs string with double quotes inside the...
  5. PankajBanga

    Change development environment in VS2005 IDE

    Tools > Import and Export Setting Select Import selected environment settings > Next Select No, just import new settings, overwriting my current settings. (or you could save it as well) > Next Select Visual Basic Developer Setting from the list and press Finish.
  6. PankajBanga

    How to generate new email message in the user's default email program?

    ShellExecute Me.hWnd, "open", "mailto:someone@something.com?subject=somesubject", "", "", vbNormalFocus
  7. PankajBanga

    Updating a dataset filled by a join query

    You'll have to supply your own updating logic. Neither the CommandBuilder nor the Data Adapter configuration wizard will be of much help with the actual join query. Or try using multiple DataTable objects and a DataRelation to stimulate the results of a join query. This way CommandBuilder and...
  8. PankajBanga

    How do you fill a Dataset using mulitple tables in the Select Statemen

    First of all why are you using OleDb Data Provider for accessing Oracle database, use OracleClient which is Found in System.Data.OracleClient I didn't get a chance to have a look at the code, but this is how i normally do it with SQL Server. Logic should be the same, just a matter of using...
  9. PankajBanga

    VB Trick

    Few more CTRL + R --> Solution Explorer F4 --> Property Window CTRL + T --> opens Customize Toolbox window (VB.Net), Components Window in (VB6) F2 --> Object Browser CTRL + SHIFT + C --> Class View Windows (VB.NET) F9 --> Add/Remove Breakpoint CTRL + G --> Immediate Window
  10. PankajBanga

    Character equivalent of elements in an Enumeration

    Use Asc value of each character in the Enum as follows Public Enum Delimiters Tab = Asc(vbTab) Semicolon = Asc(";") Comma = Asc(",") Space = Asc(" ") End Enum Then simply retrieve the character using Dim strDelimiter As String = Chr(Delimiters.Semicolon) You can also use...
  11. PankajBanga

    Visual Source Safe Hell

    Sorry missed out something Once the project is unbounded, make sure you set the read only property of contents in the folder to false.
  12. PankajBanga

    Visual Source Safe Hell

    You can unbind the project before taking a copy of it for your home use. Following are the step 1. Create a copy of your project. 2. Open the copied project. 3. Click File --> Source Control --> Change Source Control 4. In Change Source Control window select Disconnect and then press OK. This...
  13. PankajBanga

    Properties Window Error Message Box

    Throw an exception in the property declaration. Something like this Set(ByVal Value As Integer) If Value = 1 Then Throw New Exception("Your error message.") End If p = Value End Set
  14. PankajBanga

    Halting and Debugging thread?

    sodakotahusker u have a point here, i can do it in one thread. thanks learned something new though Thread.Join JohnYingling Build/Config/Active Sol Config is Debug

Part and Inventory Search

Back
Top