Search results for query: *

  1. E

    multiple records in crystal report

    Hello. I am making a crystal report. i have a member that have three cars. I need to load the informations about the three cars and the informations aboout the member in the crystal report. How can i do that? the crystal report should look something like this: Name Name FamilyName...
  2. E

    insert and update

    i have 2 tables: members and membercars. i need to be able to add more than one car for one member. so i thought if i added the second car, and i put a condition--where memberid=txtserial.text--the memberid is for the membercars and the txtserial.text is the serial for a member(autincremented)...
  3. E

    Question populating data from datagridview into textboxes

    Hello guys i have a problem. i have a datagridview with textboxes. i insert-update-delete records from database. Everything works fine. when i click on a cell in the grid. the information about this person are populated into the textboxes. but when i click on the newly inserted record it won't...
  4. E

    saving to sql from windows imbedded CE 6.0

    Hello. I have an application on a handheld that reads rfid and stores the result in a txt file. all good so far. i read the file in order to save it into sql server. but i am having a big error. Here is my code. Is there anything wrong with it? because it seems very logic to me. I thik it's a...
  5. E

    Error : Conversion from string ?serial? to type 'Integer' is not valid

    Hello. I am a little confused. I have this code: Dim dv As New DataView(_DataSet.Tables(0)) ' select deleted rows dv.RowStateFilter = DataViewRowState.Deleted For _irow As Long = 0 To dv.Table.Rows.Count - 1 If Not IsDBNull(dv!serial) Then...
  6. E

    Question Get data from DataAdapter

    Hello. I need to get data into dataview (to loop through the rows in the dataview) from my dataset(after making some changing some records:insert, update, insert). So i need an answer on these two questions: Can i get data from dataadapter into dataview ? Or i have to get data from dataadapter...
  7. E

    Question delete record from dataview and database

    Hello. Dim dv As New DataView(_DataSet.Tables(0)) ' select deleted rows dv.RowStateFilter = DataViewRowState.Deleted For _irow As Long = 0 To dv.Table.Rows.Count - 1 ' if serial is null, that means the row is new and deleted ' so no need to add...
  8. E

    Question Datagridview to crystal report

    Hello guys. I need you help. I have a datagridview. with a combobox. The content of the datagridview changes according to what i choose in the combobox. How can i print the datagridview rows to a crystal report? i started with something. I don't know if it's right. I created a dataset.with the...
  9. E

    One button submit that handles the work with the database

    Hello. I did the following: Update-delete-insert in the dataset. delete: dataset.customers.rows(0).delete() insert: anyrow(Name) = "qwerty" anyrow(Address) = "azerty" tablename.rows.add(anyrow) update:dataset.tables("tablename").rows(4).item("Name")="qwerty"...
  10. E

    Question Delete a record from a database

    Hello. I have this code to delete a record from m database(i am using SQL Server) am i missing something. Because it wont delete the record And i have no errors. It just don't delete the record. Private Sub cmdDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...
  11. E

    loading data from sql using binding context

    Hello guys i need your help urgently. I need to load data from sql into my form using binding context. i have written this. Private Sub cmdRequery_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdRequery.Click DBRequery()...
  12. E

    Creating VB database applications using ADO control

    Hello. Need your help. I want to Create a database applications using ADO control. But i can't access it from the toolbox. I searched to see how to view it in the toolbox. I found this: ""To be able to use ADO data control, you need to insert it into the toolbox. To do this, simply press Ctrl+T...
  13. E

    Question From Access to sql

    Hello. I need a hand in my code. i wrote the following code. and i am trying to work with sql. what should i change? I really need some help with this :/ Public Class BindingContext Dim _cn As New OleDb.OleDbConnection Dim _DataAdapter As New OleDb.OleDbDataAdapter() Dim...
  14. E

    Question Cristal Reports

    Hello :) I wonna start learning about Cristal Reports. Any sites suggestions ? Thank you :)
  15. E

    Question Saving to DataBase. SQL

    Hello again :) I have this code below. it won't give me any errors. but i can't see the records in SQL. Is there anything that has to be done in order to view the newly inserted record in SQL? i can delete records with this. the record is deleted from SQL. Private Sub btnRemove_Click(sender...
  16. E

    Question Saving to DataBase

    Hello everyone. I have been trying for a while to save records to sql. i have created a database called SchoolDB. i hv the feild listed below in the table StudentInfo. unfortunately i haven't succeeded. I tried many ways. Here is one of them. Can you help me please :/ Any help would be...
  17. E

    Question radiobutton and the DateTimePicker Please

    Hello :) I need you help in something. i have a DataGridView. What i need is when i double click a certain row, the record will be displayed in the texboxes,radiobuttons and comboboxes that i have in my from. i succeded to do it for the texboxes and comboboxes Private Sub...
  18. E

    Question Populate a Combobox from sql

    Hello. Need your help in something. I am trying to populate the fields in a table that i created in Sql into a Combobox. Table name: Vehicule fields : Immatric-Marque-Modele-annee-etat-compteurkm-remarque-typv i want this in my form, so when the user wants informations about a car,he just...
  19. E

    Question import a collection to export to Notepad-Exel

    Hello Experts. I need your help in something. it got a bit hard for me, since i am a beginner. i have a collection. (Please don't ask me why i'm using a collection :/) , it's an assignment. -------------------------------------------------------------------------------- Dim _collection As...
  20. E

    Question Combining two function in one

    Hello Experts. I have a question. i wrote 2 functions. I need to combine them into one function. Can you help me please ? Private Sub Button3_Click_1(sender As Object, e As EventArgs) Handles Button3.Click Using myWriter As New...
Back
Top