How do I force users to save the current record (if current record has changed) and not let user go to the next record unless the save button is pressed?
View 5 RepliesI hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
I use this code to move to the next record. but when I move last and then I click movenext I get the "No current record error" but in the code I specified "If Not dbs.EOF Then". How can adjust the code so that I dont get this error
If dbs.RecordCount > 0 Then
If Not dbs.EOF Then
dbs.MoveNext()
[code]....
I'm a bit of a newbie and am trying to delete the current record on a form. next record, previous record is easy. i just write the following Me.CustomerBindingSource.MoveNext()
How come there is no "Delete" method available? such as:Me.CustomerBindingSource.Delete()
code available? I have my form binding to a database table called Customer and am wanting to write code for my own record navigator buttons.
I use This Code To Save Data in Table First I delete record Then Insert record
View 4 RepliesI have used a data repeater, some of the data it repeats are URL's taken from the SQL DB. How can these link labels be made into links that will open the clicked URL in a browser?
I know i have to use the
System.Diagnostics.Process.Start("IExplore.exe",
url) command but i dont know how to get the URL from the current record.Is there an easy command to get a field from the current record?
I have a form to add a new record to a database. In the form load event I have[code]...
If i comment out the line that sets the dateadded field, the record is added fine.
I am returning to programming after a long absence (last real work done in VB5.0). I'm trying to do a small customer management project. I'm starting off with a DataGridView on one form showing a reduced number of fields. When the customer is selected a second form gives the full details. I struggling to find a clean way of passing the selected record to the second form. Both forms are using the same dataset.
View 5 RepliesHow would I print the current record showing in a form. VS 2005, SQL server 2005.
View 2 RepliesVisual basic 2010. I am having a problem with updating on a DataGridView that has me confused.
I have a DataGridView on the first tab page that is displaying data in a DataTable.
On the second tab I am updating the current record on the DataGridView.
The text fields on the second tab are bound to the DataTable in the following manner
rnameTxt.DataBindings.Add(New Binding("Text", TableData, "rname", True))
When I move to the second tab the correct data appears in the text fields.
When I modify a field on the second tab the modified data appears in the DataGridView, on the first tab page. But when I check for changes in the DataTable in the following manner
Dim ModifiedRows As DataTable = TableData.GetChanges() I do not see the modified row - i.e. ModifiedRows = Nothing? Why is the modification not being identified???
How would I print the current record, ie the one that shows on the active form. App is VS 2005. DB is Sql 2005.
View 4 RepliesThis code i had use for create a field in DB Access 2003:
SQL = "ALTER TABLE plano_contas ADD declperiodica06A char(40) WITH COMPRESSION NULL)"
Dim command1 As New OleDb.OleDbCommand(SQL, con1)
con1.Open()
command1.ExecuteNonQuery()
con1.Close()
like you see the code create a Text field with 40 lenght...Well the problem is:When i save a new record the record it's save in this mode: "100......... .........................." - the points means spaces and should be:"100"After try a lot of things i'm without more solutions in find why this happen!
I have the following code on the SaveItem_Click event of the BindingNavigator..[code]how can i adapt the code to also save any other cell changes on the DGV existing rows (even if the row is not new)?
View 2 Replieshow to delete the current record datagridview using adodb in vb.net...this is my code:
Private Sub cmdDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdDelete.Click
adrCURR.Delete(ADODB.AffectEnum.adAffectCurrent)
[code]......
I m workin on vb.net ado.net oledb, I have also added datagrid Control to my form
for retriving database from .Mdb file i used following code
Code:
'decleared Name Space
Imports System.Data.OleDb
[Code]....
or when i click any record in datagrid, then the current record of dataset also should move to clicked record of datagrid, so that i also may see datagrid's clicked record in textboxes
in short i want to use default feature of vb6's ado control, when we bind datagrid with ado control, it worked autometically, both data grid and adodc wer connected each other at a time, so that moving next record also apears in datagrid.
I m working on vb.net ado.net oledb, I have also added datagrid Control to my form
for retriving database from .Mdb file i used following code
'decleared Name Space
Imports System.Data.OleDb
'Dicleared Variabls in Class Form1
[code]....
how to move current record in datagrid, i mean when i press Next record button then datagrid's data (table) also should move to next record or when i click any record in datagrid, then the current record of dataset also should move to clicked record of datagrid, so that i also may see datagrid's clicked record in textboxes in short i want to use default feature of vb6's ado control, when we bind datagrid with ado control, it worked autometically, both data grid and adodc wer connected each other at a time, so that moving next record also apears in datagrid.
example of displaying the record number of total Records in a label.
View 22 RepliesI have a ListBox populated with records and an insert button that activates an InputBox which prompts for the record name. What I would like is instead of an OK or Cancel button, I'd like a Insert Above, Insert Below, or Cancel button. My current workaround is using a second InputBox so after receiving the record name, this box asks to place it above or below. It would be much easier for the user having a single InputBox that takes the record number and having the three options, above, below or cancel.
View 7 RepliesI am trying to check a record in database before inerting a new record here is my code but problem is when i enter a names first alphabet it imediatly populate massage. i want to check it after entering whole name
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
Try
Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
[CODE]...
I am a ASP Classic Programmer, professionally for a little over a year, I have developed some rather nice sites, including the one in my signature (Still a work in progress).
I have been forced to use ASP.NET (VB) for a FileUpload control, as it offers a self controlled way of creating Thumbnails, without the use of 3rd party controls, which is great, as my hosting server does not allow for 3rd party installs on their servers.
So.
The code below is what I have so far for connecting to the database and displaying a record is the "cookie" exist on the users computer.
Unfortunantly, this is not working, and to be honest with you, their is not a whole lot of resources available to show how to do this correctly.
So I am stuck with a lot of post and hoping that someone can actually assist me with this and tell me what I am doing wrong and maybe correct my code.
I am getting an error about the "Connection is closed"
If you want to re-write my code, I prefer something simple and basic, as the only thing that I am doing to checking rather the user is logged in, and if so, display a record from the database. I am NOT in the need for the DataGrid, so please do not suggest it, as I am only needing to check this one thing.
I would like to also add, that I have successfully contect to my database with the FileUpload control and save file names of the images uploaded, so I know that my connection string is done properly> But, for some reason the "SELECT" statement is causing a HUGE issue. (It was easier to insert, than to select, I am not use to that)
CODE:
I have a database app where on a button click, I export the current record to crystal report which in turns converts it to a PDF file. Upon application startup, I export one record into PDF just fine but when I move ahead to the next record and I click the export button, the new PDF file that was exported is now blank. If I restart the app, I can then export the one record again but any subsequent record will export to PDF as a blank PDF file.
To sum up:I can export one record once using the below code snippet but when I try it for a second time on another record, I get a blank PDF file (only the crystal report formatting is in the PDF).
[Code]...
While I've previously many years of relational databases and procedural languages, I'm stumbling with Visual Basic. In this problem, the simple situation is that I have two files, parent and child. The primary key of the parent file (Area file) is linked by a relation to one of the two fields that makes up the primary key in the child file (Project file) (unique key is formed from 'area' and 'project'). I have the default table adapters created on both files. I have created two maintenance forms showing one each of the two files in datagrid view format.I can create some records in the Parent (Area) file, but when I try to create a record in the child (Project) file, using one of the valid key values from the Area file, I get the 'ForeignKeyConstraint [relation name] requires the child key values [actual value] to exist in the parent table' which I'm absolutely definitely sure it does.
I haven't done any actual coding for those two maintenance forms, just dragged-and-dropped the files from the data sources screen onto separate forms so it creates the controls itself. But I can't work out, if it already knows the data does exist because I can load it back in to the Area maintence form, why it can't check itself to find out the record does exist. Why does it think the record from the parent record doesn't exist? It does exactly the same thing, whether or not the database is in access or SQL Server Express. I have all the latest updates.
I have two tables Products and Categories with a many to many relationship. I am trying to copy the categories linked to one product (OriginalProduct) to another product (newProduct). The problem is when I execute the SaveChanges() method, I not only get the records in my linking table, but it also creates another copy of the categories in the categories table. I've tried this in many ways but here are the last couple that I've attempted:
' Copy Product/Categories
For Each oneProdCategory In OriginalProduct.Categories
Dim relatedCategory = _productContext.GetObjectByKey(New EntityKey ("ProductInfoEntities.Categories", "RecordId", oneProdCategory.RecordId))
[code]....
I have a problem with my program, and it's really bad because I need to burn it to disk within 12 hours and I can't get it to work: If I create a record, add information to it and click on Next Record, the ID, Status and Notes boxes content will change but the rest of the controls contents are carried over to the next record and I don't know why or how. It was working perfectly but now it stopped and I never done anything.
View 8 RepliesI am handling many of the BindingNavigator tasks (MoveFirst, MoveNext, etc.)in code to ensure that I always ask the User to save his changes.
The one area I am have a problem is PositionItem. I would like to sense that the User has changed the Record Number in the BindingNavigatorPositionItem, handle my record Update, and move to the Record Number the User entered I have looked all over and have not found any way to do this.
I have created a project that has an add a new record, edit record and a search form, that has multiple text, combo boxes and is working great.Last nite I have added a checkbox under my add new record form and i am saving the checkbox value to my database, so far so good. I would like to be able to search any record that is mark with a checkbox to show up in my search screen when I do a search: [code] The problem that i am having is that now that I have added the code to my project to search for the checkbox field in the search screen and if I leave everything blank and click on the the search button I get no record found. I expected to see all that data, since I have nothing selected. Now if I click my checkbox, as soon as I click on my search button I see that two records that I have added for my test.
View 1 RepliesMy database : table1
ID FIRSTNAME AGE
1 Sumit 22
2 Sanjeev 23
i have gridview 1 and textbox1 and button1 i want when pages load the gridview displays the all records from table1 and also ...i i wanna search record for firstname by typing sumit in textbox1 and click on button1 then in gridview the record of sumit will be shown ..by default gridview display alll records from table1 How to do this My Selct Query is below : but it doesnot display all record ...but it can display record if you search for a particular record .
[Code]...
I have records in a database. Each record has a Picture path in it eg. "C:\Pics\Image1.jpg". I would like to display a record from my database and also the picture for that record, in a .rdlc report in vb .net 2008. i have succeded in displaying the record but just can't get the picture to show. I am using an Imagebox in the report.
View 2 RepliesI am trying to write a system that will send an email to my Client and when my client reply I need to read the Email and push it back to proper Record for the Client.We are using Exchange and outlook, For Sending email I am using smtp with custom coding Which automatically record an email content to the Client File howerver how to read the reply as it is coming into outlook of user machine and push it back to the Proper Client record.
View 3 RepliesIm wondering how would i work with a text file. which would allow me to Read the next Record, Cut record out of the program.
View 15 Replies