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 PatrickIRL

  1. PatrickIRL

    code to merge pdf files?

    Not sure that the DLL has to be registered. What I did was to put the DLL in the Bin folder then referenced it. Then in your .cs file you use using iTextSharp.text; using iTextSharp.text.pdf; That should be it. Patrick
  2. PatrickIRL

    newbee cannot get the correct value in string

    Why not just use rows.RowIndex.ToString() ?????? Patrick
  3. PatrickIRL

    Get value of DataGridViewCheckBox

    I use this method to get a button in a gridview, should be much the same for a checkbox, let see... <script runat="server"> void chkBox1_CheckChanged(object sender, EventArgs e) { CheckBox cb = (CheckBox)sender; GridViewRow grdRow = (GridViewRow)cb.Parent.Parent; //get the row...
  4. PatrickIRL

    Msflexigrid select multiple rows

    I had a requirement for something like this some time back. My solution was to add a checkbox on each row, user could then select as many as they needed. Ah, yes. Place a checkbox in the grid, set index as 0 so it's an array. Then for each row you add to the grid add a checkbox using: Load...
  5. PatrickIRL

    storing temporary and large amount of data

    Maybe another idea is to use temporary tables within sql server (assumption). The idea is this: Each user had a unique ID whcih can be the table name; for instance: joebloggs runs a query on your database so in code you would have: SELECT * INTO #joebloggs WHERE... and then the rest of your...
  6. PatrickIRL

    Provider Error with Oracle Instant Client

    Not sure if this is what you need, if not post back. http://www.connectionstrings.com/oracle Patrick
  7. PatrickIRL

    newbie - how do you call a button_click event from another method

    Have you tried private void CrossPagePostBack() { btn1_Click(void,void); } Patrick
  8. PatrickIRL

    extract data from xml

    Yes, I should have fixed that, apologies, it's SelectSingleNode you sould use.
  9. PatrickIRL

    StopWatch coding problems

    To me it looks like Stopwatch() is a namespace so you need to import it with a "using" statement. Patrick
  10. PatrickIRL

    extract data from xml

    I think what you need is something like this ... First get the date XmlNode nd = xDoc.SelectNode("//G_NEW_DATE/NEW_DATE") This will return the node, so just use toString() to get the value and compare. Once you have that and checked it use the same method to get the day/month/year Hope...
  11. PatrickIRL

    Show pdf, tif and jpg

    I usually use the ShellExecute API which opens the file with the associated program (I think that's the way it works, I stand to be corrected) Patrick
  12. PatrickIRL

    Insert Into Different Database

    SELECT * INTO <Table2> FROM <Table1> Will create table2 and data. If the tables already exists then the way to do it is: INSERT INTO <Table2> (<FIELD_LIST>) SELECT * FROM <Table1> Patrick
  13. PatrickIRL

    Testing for recordset opened

    You can check the state of the recordset ... if rsRS1.State = adStateOpen then rsRS1.close Set rsRS1 = nothing end if Patrick
  14. PatrickIRL

    Determine SQL Version

    I wonder if SQLDMO or SQLSMO will give you the information you need? Using these you can enumerate through the servers/databases and there may be a property that will give you the version of each database. Patrick
  15. PatrickIRL

    Determine SQL Version

    Ok, I'm confused (I think). What you have will work and return the version, I get 10.0.1600.22 when I run it. So, then in VB you're going to do some conditional branching based on the version? Yes/No/Maybe ?? Patrick

Part and Inventory Search

Back
Top