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!

Register Log in
  • Congratulations derfloh 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: *

  1. RaulMA

    Problem to get partial records

    Sample case, the real one contaiins thousands of records with multiple companies and I just want the top 5 or N number of recors. COMPANY USER COMP_A gbuske COMP_A gcaldog COMP_A kdubell COMP_A lboldiz COMP_A rgronb COMP_A...
  2. RaulMA

    TOP N records

    Sample case, the real one contaiins thousands of records with multiple companies and I just want the top 5 or N number of recors. COMPANY USER COMP_A gbuske COMP_A gcaldog COMP_A kdubell COMP_A lboldiz COMP_A rgronb COMP_A rbal...
  3. RaulMA

    count recodrs issue

    all of them work for me thanks
  4. RaulMA

    count recodrs issue

    Need help to count records each time it repeats if and only if the three colums are the same. Cliente Socio Prd other colums (do not care) client1 M_US Em client1 M_US Em client1 M_US Em client2 M_US Em client2 M_US Em client3 A_US HG...
  5. RaulMA

    DLL to VB

    I obnained the following code by using a tool. Could some one help me to create a visual basic code for the corresponding dll translation. STRINGTABLE LANGUAGE LANG_ENGLISH, SUBLANG_ENGLISH_US { 100, "mp" 101, "224 West Esp" 102, "New York" 103, "NY" 104, "000000" 105, "USA" 106...
  6. RaulMA

    Get rid off right and left side

    SQL Denis I think I did not explain clearly test CSFB, ABN, C, BSC, BNPP, LEH, MER, BARX, BAS, FTN requests That is jus a sample your query get rid off test and request as expected but what happens if my query returns blah blah test CSFB, ABN, C, BSC, BNPP, LEH, MER, BARX, BAS, FTN requests...
  7. RaulMA

    Get rid off right and left side

    Some comments declare a parameter like @v ='test CSFB, ABN, C, BSC, BNPP, LEH, MER, BARX, BAS, FTN requests' it won't work in my case because the list between test and requests could be different. I need to identify when I found test and get rid off all I have on the left including test. I also...
  8. RaulMA

    Get rid off right and left side

    The following is an output of a single field select message from table a test CSFB, ABN, C, BSC, BNPP, LEH, MER, BARX, BAS, FTN requests I need a command just to get the list between test and request. Any help will be appreciated. Raul
  9. RaulMA

    HEX TO BINARY

    Could some one provide a function to convert HEX TO BINARY?
  10. RaulMA

    Populate a GridView from a return dataset

    How can I populated a GridView located in a aspx page from this class located in another utility project. public dsCompany selectCompany(string region, string type, string status, string shortname) { try { SqlDataAdapter da = new...
  11. RaulMA

    Populate gridview from a DataSet

    Need to populate a GridView (grdCompany) from a Dataset (dsClient). dsClient.Designer.cs has a class named CompanyTableAdapter Any help will be appreciated protected void Page_Load(object sender, EventArgs e) { CompanyTableAdapter companyAdapter = new CompanyTableAdapter()...
  12. RaulMA

    Store procedure to search a company table

    Thanks for the help, but something wrong happens when I run the store procedure with one of the parameters empty.It should execute the store procedure just with the parameters I passed with out required all of them to be submitted. EX SearchCompany 'us','Dealer','Active','' Returns 0 records...
  13. RaulMA

    Store procedure to search a company table

    I need help to create an store procedure that search a Company table passing 4 parameters.One of the requirements is to allow the user to combine those parameters. Parameters: Region_Name, Type (Client, Dealer), Status (Active, Inactive, Prospect), Name The company table has a foreing key from...
  14. RaulMA

    VB TO C# need help

    Can some one help me to change this vb code to c#. What it does is to read an xml file an store data into sql server database. Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlTypes Module Module1 Sub Main() Dim objSQLConn As New...
  15. RaulMA

    Store XML in Database USING C#

    how to store XML in an SQL Server Database using C#
    • RaulMA
    • Thread
    • Replies: 0
    • Forum: XML
  16. RaulMA

    How to read from an xml and store related data to DB

    How can I store data from an xml file to a sql server data base? Thanks
  17. RaulMA

    Ged rid off of attributes after XSLT

    Thanks
  18. RaulMA

    How to apply XSLT TO AN XML

    The following code generates myfile3.xml on the c drive. I have an xslt file to convert myfile3.xml the way I want. Can some one help me how to call my xslt file and apply this two my xml file.? SqlConnection connString = new SqlConnection("Server=mi...
  19. RaulMA

    Ged rid off of attributes after XSLT

    XML FILE: <NewDataSet> <Table> <First_Name>Roberto</First_Name> <Last_Name>Cortez</Last_Name> <Email>r_cortex@test.com</Email> <Company_Name>My company</Company_Name> <Address_1>11 First st</Address_1> <Address_2>3rd Floor</Address_2> <City>Indianapolis</City>...
    • RaulMA
    • Thread
    • Replies: 2
    • Forum: XML

Part and Inventory Search

Back
Top