update

  1. Ace1000

    Bound Form : Going to specific record + Updating data

    I have Visual Studio 2015 Express with SQL Server Express 2014 I am new to .NET but have solid experience with Access/VBA. I have dragged and dropped fields from tblProductDetails in my Datasource tab into Form1 to create bound fields. Now I am struggling with two things. ISSUE #1. Going to...
  2. M

    Question Csv File not updating

    Here is the login process, record adding and updating, I cant see where I'm going wrong, *******The User will login to their account ***** sub login() FileOpen(1, CurDir() + "\LoginDetails.csv", OpenMode.Input) logposition1 = 0 Do Until EOF(1) fullline1...
  3. A

    get updated session variable in a saperate request while first request in progress

    Hi All,I have a page on which there is a link, when clicked it makes a server call to handler using jquery ajax to start zip creation of a list of files. that click also strats a repeatative server calls which checks what is the current zip creation process.The logic is simple, I have stored...
  4. C

    Question Validating data before executing multi looped query?

    I wrote a VB.NET 2010 application that writes to a MS Access DB via an ODBC connection. This application is intended to take the place of the paper based Non Product PO system. The functionality in question works as follows: A user opens the program to a blank PO form. They can search for an...
  5. J

    Question Axis not updated when i add a new point

    Hello, I would like to draw a graph of multiple serie with y and y2. This I can do it. Now my problem is that I want to display data in real time but in a chart in which the size of axis doesnt change. a small drawing worths better than long explanation. so the graph should start like this...
  6. N

    Data gets restored, but functionality differs after returning from tombstoning

    I have an app in which there is a TextBlock that I dynamically update when the user taps certain buttons. When the user first goes to the page, this works perfectly. When the user leaves, I save all the data into Isolated Storage like I should, and then recover the data when they return. The...
  7. N

    Replace existing xml file based on version number within external xml

    I have a program that reads and saves data with an xml file. Once it is released, there is a "Check for update" button that the user will click to see if there is a new version of the xml file. The file contains the version number, ex: <Root><Version><Current>0.0001</Current></Version></Root> I...
  8. L

    Question DataAdapter updates everything but the first DataGridView Record

    Hi! I am new to .NET and been reading these forums in order to learn about it. So far, I must admit that I learned a lot. Hope to be able to share some knowledge in the future! I have a question now, that I am unable to answer to myself. I have a datagridview bound to my access DB (once I'm...
  9. A

    SQL command or Manual Query Qustions?

    Hi guys, After getting dataset's datatable by using wizard ,we can update those tables rows or table by calling that table's adapter. Like blow: Me.Validate() Me.DepartmentBindingSource.EndEdit() Me.DesignationBindingSource.EndEdit()...
  10. A

    Update Sql Query ?

    Hi guys , I want to create manual update , delete and insert command... I am curious why ms create those line of commands: UPDATE Department SET ID = ?, Department = ? WHERE (ID = ?) AND (? = 1) AND (Department IS NULL) OR (ID = ?) AND...
  11. K

    Can not update MSSQL database

    Hello, I am aware about the COPY ALWAYS or DO NOT COPY features for files and database files. But my problem is the following: This is the code: Imports System.Data.SqlClient Imports System Imports System.Data Imports System.Windows.Forms Public Class Toybla ' Dim ConnectionString As...
  12. S

    Question code for update button?

    i have one registration form which consists of username, password, confirmpassword and Register button. When i will be typing the username, it should show whether the username is available or not. and i have changed the username column as primary key in sql database. Private Sub...
  13. T

    Question ToolSTripStatusLabel doesn't update

    Hey there. First of all, let me say i'm relatively new to .NET. Anyways, I'm making a program that searches IMDB online for the episode list. Since the program access the web, it takes ages sometimes to actually complete a task. I wanted to inform the user that the program is still busy and...
  14. E

    How to use UPDATE with JOIN in SQL queries

    We use JOIN in the SELECT statement often to retrieve data from multiple related tables. But, some times we can get into a situation where we may need to use UPDATE statement by joining multiple tables. Consider a situation: A table named as USER_DATA is there which contains user details. This...
  15. S

    Listbox Items Do Not Refresh

    I am adding an object to a Listbox which has the properties "ID" and "Text". I have set the "DisplayMember" property of the Listbox to "Text" and "ValueMember" to "ID". Everything works fine when I add a new item to the list, but when I edit the item and change the "Text" value, it is changing...
  16. T

    Datagridview only updates database after changing row selection...

    I have a bound datagrid that contains textboxes and comboboxes. I am having problems getting my changes to consistently update the database behind the scenes. I have an EndEdit event that fires everytime it needs to and executes the code to update the database. However, the update commands...
  17. S

    Question DataGridView doesn't show changes of its DataSource

    Hello everybody! My application looks like the following: 1. An XML file is read using LINQ and the result is an enumeration of objects of a specific type (i don't use anonymous types). The result is then converted with result.ToList() to a standard list and saved to a list-variable. 2. I...
  18. T

    problem updating datagridview

    I am newbie to Vb.net. and getting trouble in showing received data onto datagridview control.I m writing a program to receive data from serial device and to show it on datagridview. But I m able to show only 1st data next data is not updated on DGV. sample of my code is given below Try...
  19. R

    Question Is this possible with DataGridView?

    Hi If i have a DataGridView is it possible to insert the details of a selected row into another form to update? If so...... How can i do this? I have 2 forms frmMain (where the datagrid is placed) and frmCustomer (this is where i want the selected Row details to be inserted, so i can update...
  20. F

    Another helpful way to use a DataGridView

    I have seen many entries here about issues involving updating and displaying data from sources such as Access and SQL. I use SQL for all my developments so I will be using SQL in my example. SQL connection: 1. In your project properties, go to "Settings". 2. Add a connection to your project...
Top Bottom