I 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?
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 am using Dataset created by the wizard with BindingSource and Binding Navigator
For example, I placed a Textbox on the form, and bind it to a field.
I was trying to compare the field value stored in the sql server database with the data I have on my form.
Let say I run the form, and Textbox1 get it is value from the first row in mytable from BindingSource (let say value 1000) [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 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 RepliesI have this in a VB.NET console application:
Dim p As ProcessStartInfo
p = New ProcessStartInfo(Environment.CurrentDirectory & "injavac.exe",ClassName & ".java")
Dim ps As Process = Process.Start(p)
This does run the java compiler on the file, but it does so in a new window. I want the output from javac to appear in the same console that is running my application. How can I do this? Perhaps there is another method for running commands in the current console? Or maybe I can supress the second console window from opening and redirect its output to the current console?
how 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 know nothing of VB.NET, but if I were you
View 2 RepliesHere is hte code I'm using to insert into my database:[code]I believe it is Cell 4 that is causing the exception, because it is a checkbox column and i'm not sure what syntax to use to store the "CheckedState" of it.Yes, I know I should be using parameters, but I don't know how yet, and I would like to make the INSERT statement work before implementing the paramater approach with it.
View 5 RepliesIf I need to set the value of a checkbox (threestate) inside of an INSERT command, what would the syntax be? I've tried 'True' but that fails and I can't think of another way to do it.
View 3 Repliesim connect the database using the OLEDB, how to write the code when the user types '02' in textbox1, 'myname' in textbox2 and 'myqty' in textbox3, if database table itemcode field same with textbox1 then will only update the textbox2 and textbox3 in other field, if it does not exist then create the new record.
View 5 RepliesI am trying to do a SQL query to see if an Address already exists in my database. My addresses are structure like this:
line1
line2
line3
city
state
zipcode
country
Sometimes line2 and line3 are NULL values in my database.I am using .NET TableAdapter and DataTable to make my query. When I try to pass in my line2 parameter (@line2) it is equal to a string with value = nothing. My database does not interpret this as NULL and says the records don't match, but I know they do? How do I pass in a string = nothing and have it compare to a NULL value in the database as being equal? I have tried string = DBNULL.value but won't compile.I have done similar comparisons with integers etc. using integer = Nullable (of integer) but this does not exist for strings.
Background: I have a webForm app that registers a user in the database based on the information provided with a web service, auto-generates a random password and username, and e-mails the user a link to take an application based on the marketing company selected.
Question: How do I populate the MarketerName_TextBox field with the currently logged in users name (Is it User.Identity.Name and do I add that line on aspx.vb end or the aspx end?)
[Code]...
Im trying to delete a field from bookid and it doesnt work. Is there something wrong with my query. When i compile it i get a message of Data type mismatch in criteria expression.
CODE:
I am using VB 2008 and SQL Server 2005. I have a texbox in which I need to show the field 'domain' from the table x. I am getting the field in the format needed from a stored procedure.Below is the Vb code that I am using in which I am getting an error message: Invalid attempt to read when no data is present.at this line sDomain = sDomain & " " & v_DR!Search
[Code]...
How may i retrieve the total number of records from a table via a SQL select, store it in a variable & in turn, add '1' to it @ a textbox to simulate the addition of a new record?[code]...
View 2 RepliesI am having a problem with adding a record to a customer table in a Microsoft Access database. I have worked for hours reading my textbook and troubleshooting to no avail. The copy and paste below from VS is a little messy. When I execute this code below the record is not added and I do not get an error of any type. When I go into debug mode, all of the parameters are correct and everything looks good. If I open up Access I can manually add the record but using my program nothing happens. All datatypes are string in VS and text in Access.
First an instance of the Customer Class is created and this seems to be successful. But when I take that customer object and run the AddCustomer method of the customer class it is not successful in that the database does not reflect that the record was ever added. [Code]
The following code does not seem to delete the record in the table...
Imports System.Data.SqlClient
Imports System.Reflection
Module UpdateSys
[Code]....
im fairly new to databases in vb.net and i have just learned how to use datagridview. im gonna show some of my code for the connection and datagridview display
Public Class Form1
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String[code].....
i want to display in a textfield the first name based on where is the pointer is positioned after i clicked Button1, how do i do this?
How to delete a record or field from a fixed-width file in visual basic code?
View 1 Replies