Search results for query: *

  • Users: PLH
  • Order by date
  1. P

    Finding and Selecting a record in the dataGridVeiw

    Finding and Selecting a record in the datagridview Hello all, I am almost finished with my app but there is this last search functionality that I like to add to it. The app has dataGridView with more then 30000 fields and a search textbox that will speed up for searching and selecting Cell/row...
  2. P

    Autonumber Problem

    < Why not retreive the Databases number when you populate the dataset initially?> Well I can retrieve the database number but I can’t retrieve the database’s possible next number! Actually, populating the database is not the problem but the updating would be the problem. Let take the last...
  3. P

    Autonumber Problem

    Yes you are right, but the table I am talking is a parent table. To be more clear let say I have a parent table named ‘Customers” whit five customers and a chilled table “Orders” with no orders. Now, the user deletes the last customer from the “Customers” table and terminates the app. Next time...
  4. P

    Autonumber Problem

    no it is one to many
  5. P

    Autonumber Problem

    Well, since I have connected database to the app in the design time, I jus use dataAdapter.Fill(dataset, “Table”) ‘fill the dataset. 'And dataAdapter.Update(dataset, “Table”) ‘updates the table. The problem is that the database’s last record was deleted at the last time the app run so no...
  6. P

    Autonumber Problem

    Hi guys, I have searched three forums and didn’t find any similar problem to mine. That really surprised me because this should be very conmen problem with database apps. Now, I have a database connected to the app which was created by the wizard (in the design time). The problem is that if a...
  7. P

    Update Problem

    Hi all, I hope some one can help me with the problem I have in my app. The problem is that I can’t save the datagrid data into the database. The app uses tabledapter and dataset which were automatically created by the wizard in the design time. When I fill the first row with the data and call...
  8. P

    Help pleas!

    Using Row's FIND method Hi all; Can any one show me how to use row's Find method with three primary key columns?
  9. P

    Dictionary

    No I don't mind at all, Please!
  10. P

    Dictionary

    Hello all, I have this app that I created a year ago is basically a dictionary that shows word's definitions. Now, it is using a MS access database and dataset which is in disconnected mode (I mean that it is not created in design time and it exist only in the run time.) To find a record that...
  11. P

    Desktop icon?

    Ok, how it will look like if you make a shortcut to your app on the desktop and you don't set the shortcut's Icon property. That is how it look like for some millseconds.
  12. P

    Desktop icon?

    Hell oeveryone, I have this problem for a long time for every my apps that I did not pay attention, But I decided to solve this problem ones at all with your help. The problem is the desktop icon that I set for my app. When I double click on it to open the app, it blinks ones. Does anyone know...
  13. P

    Creating Installation Packages

    Just type Deployment in your VB.Net rhight corner serch text box and take a look walkthroughs.
  14. P

    how to resize a form?

    do you mean resize the picture box or the window?
  15. P

    DateTime manipulation..Need help

    I am not sure if I understand your question. <I want to keep the previous Date in invoice number till the System time reaches 12:00 noon. > If you'll be more clear I may help you.
  16. P

    Cast from type 'DBNull' to type 'String' is not valid

    Look this code works in my app. If I don't add ".ToString" I will get the same error that you are getting when the database filed is empty; becouse "logoImagePath" is string type. logoImagePath = Ds1.Company.Rows(0)("Image_Path").ToString 'insted of if...
  17. P

    Cast from type 'DBNull' to type 'String' is not valid

    <should be If Ds_fpersonnel_detail1.fs_personnel(dsrow).PHONE_B = DBNull.Value Then> Actually VB.Net dose not support DBNull. It sgests to use isNothing instead. The best way to go in my app is to convert the value to a string. And empty string is Null too so I don't see any difference!
  18. P

    Updating and Deleting records with Access db

    This is how you delete and update the database yourDataset.Yourtable.FindByOrderID(orderID).Delete() ' This statment deletes the record in the dataset. 'Or this one deletes the first record in the dataset yourDataset.Yourtable.rows(0)("yourColumn").Delete() 'And...
  19. P

    Cast from type 'DBNull' to type 'String' is not valid

    Just add .ToString after every database statement value and it will be ok. The VB.Net does not show members after you placed the dot but it is ok you just type it. It will convert DBNull value to a string value that you can test and it will not give an error if the value is nothing.
  20. P

    MS Access?

    Thanks I got it. Yes I did use Configuration Wizard and it uses DBDate. Now I changed it to OleDbType.Date and it saves the time too. It seems every thing is OK now. Thank you very much you save me a lot of time.
Back
Top