Search results for query: *

  1. Estuardo

    Question Unable to display Item from Combo Box and List it in the ListBox

    G'd morning maneeshmassey, Your parameter and your field must be the same type. looks like your field is numeric, must of the times ID's are numbers, mainly in MS Access: "WHERE PastorID = @pID" and your parameter is Char type "Parameters.Add("@pID", OleDbType.Char) Also a few things i...
  2. Estuardo

    Passing DataTable between ADO and .NET Class

    G'd evening amuller, I think you're out of luck. As you already noticed MS Access doesn't implements datatable type. What you can do is to modify your dll and overload the function, instead of datatable pass a sql string, and a connection string, i guess this kind of modification would have less...
  3. Estuardo

    Beginner needs help with OleDbException was unhandled, No Value given for one ...

    We can't see your query and paramter, but err comes up when you send a wrong type to the query. Ex. your field is boolean and you send strings
  4. Estuardo

    Using strongly typed datasets to build a many-to-many relational table

    G'd evening! To not make this reply longer that it needs, i'll try to answer in the same order you've asked. No, i couldn't find any descent tutorial. I'll keep searching and let your know. Just like you i avoid as much as i can to work with ado.net wizards. But in your case with many DBs i...
  5. Estuardo

    Beginner needs help with OleDbException was unhandled, No Value given for one ...

    G'd morning! I think that finally we're going somewhere. If i understood your Db Name is BlankPupilsdb and your table PublishDb, right? if so. that's why your query will never run. Please before we keep going, let's do things right and please prefix your tables' name with tbl your queries with...
  6. Estuardo

    Beginner needs help with OleDbException was unhandled, No Value given for one ...

    Sorry to back to you just now. Regarding your questions: "...the code that u amended for me, that is for the ListBox dode section ?" Yes. i had to fix the sintax in all posts, now they're ok "the code that u amended for me, that is for the ListBox dode section ? " That's weird... unless...
  7. Estuardo

    Using strongly typed datasets to build a many-to-many relational table

    G'd Afternoon! To Append/Update/Delete your underlying table you do the same KADT.rows.clear KATA.Update(KADT) "...It seems like a common enough problem that there would be a de facto way to do it: Here i'll have to agree with you. There is "defacto" way to solve it. If you use the VS data...
  8. Estuardo

    Using strongly typed datasets to build a many-to-many relational table

    Sorry i have duplicated the reply
  9. Estuardo

    Beginner needs help with OleDbException was unhandled, No Value given for one ...

    Ricco, You can bet is really simple. let's try a step by step. Line 6 we've created a connection object and it gets the connection string Line 8 If the connection is wrong the code will break and you will need to fix the connection string. Line 11 The query needs a parameter and is supplied...
  10. Estuardo

    Beginner needs help with OleDbException was unhandled, No Value given for one ...

    First off If we're here is because we want to. I don't consider any one a pain mainly when they show interest in what they're doing not just to solve a problem but to learn, that i think is your case. Like i'd suggested in my previous post: set the parameter manually. If it works we've found...
  11. Estuardo

    Crystal Reports and Visual Studio

    G'd evening JDGIlbert and Welcome to the forum :) As far as i know, yes your rpts will open fine with later versions of the product. In the web server just install the cr runtime that's all. May be that's why you didn't find much info about it. In my case i never install any CR version for VS. I...
  12. Estuardo

    how to draw a table

    G'd evening All, Is this post the same as this?
  13. Estuardo

    How can I pass string from vba to vb.net?

    Ginger, I'm not by far any Excel savvy, but i don't think your automation code is appropriated. What you are trying to do, in my opinion, won't work. You may have the right tools but not applied in the right way. Consider changing the structure of your project. When you automate a task is to...
  14. Estuardo

    Beginner needs help with OleDbException was unhandled, No Value given for one ...

    Hello again!, I'm sorry i lead you to made a mistake. In order to make the Me.txtYearGroup.text works you must change the name of your text box within the designer. But just for this test set the parameter manually something like SQLString = "SELECT * FROM BlankPupilsdb WHERE YearGroup='2012'"...
  15. Estuardo

    Beginner needs help with OleDbException was unhandled, No Value given for one ...

    G'd evening, First of all, Welcome to the forum! :) Well unless you have intentionally omitted your db path, and the security parameter in your connection string, the error starts there. I don't use to "tell" people how do they should do the things they do when they don't ask for. This time...
  16. Estuardo

    Deleted

    G'd evening Isaac, That's endless, as soon as you open IE it will close and open it. If you want to stop the cycle. just disable the IEchase at the end of the first round. G'd luck
  17. Estuardo

    Adding folders to libraries - Windows 7

    G'd morning Grayda, Have you tried Windows® API Code Pack for Microsoft® .NET Framework i think it will meet your needs. G'd luck
  18. Estuardo

    How can I pass string from vba to vb.net?

    I´m sorry Ginger i don't get it. If you need that your .net app get a value from a excel's cell, then you will need to open excel --> change it's cells value --> and finally open the .net app. it is the flow? if so. I have to be missing something or your design is not the appropriated. Do you...
  19. Estuardo

    Question Retrieving Data from Active Directory

    Hello, I don't know if you will ever read this, but for other readers, i guess that the problem starts in your Entry object, you should explicitly say where to start to look for. Something like this: "LDAP://CN=Users,DC=domain,DC=com", dbnull, dbnull, AuthenticationTypes.Secure ) I don't know...
  20. Estuardo

    How can I pass string from vba to vb.net?

    Ginger, If all what you need is to display a msgbox, why don't you do it from Excel itself? or with vbscript or with a bat file or anything else. I mean to build and .net app for a msgbox is a waste. And by the way sln is a VS solution not an executable.
Back
Top