i implemented a RSS for big company on loacal area network attached with sql database to feed internal news.everything working fine.but i faced a small problem when the database changed the RSS doesn't take the update unless the user close the RSS and start it again.how can autorefresh the rss without closing it when the database changed.
View 1 Repliesi try for script that is process kill here
[code]...
im using that for protect by attacking software ...because i try using script refresh() can't work and i wanna any body expert in here help me to find autorefresh form..
I'm trying to write my first application which connects to an Access db. It took me hours to understand this, but I figured out that, if during the creation of the connection I chose to copy the mdb file in my project directory (VB asks this), I get that the database is not updated. Everything works, except the save button which saves new rows in the db. If I answer no, and the original mdb file is used, the database is correctly updated as expected. Is there a reason for this? Why is this happening? Shouldn't the database bu updated anyway?
View 2 RepliesUsing this code i cannot insert data in the database . it gives no error but no row is created in the data base
Imports System.Data.SqlClient Publi ClassForm1 SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=
[code].....
Ive never done a database before and i found this in one of my books... I think it should work. The part of the program that is in bold is the issue i get an error that says "Update unable to find TableMapping['Table'] or DataTable 'Table'." From the da.Update(ds).. ive been trying to figure this out for hours!
Public Class retailForm
Dim tempPrice As Double
Dim dbProvider As String
[code].....
I have a datagridview bound to bindingsource. Whenever I delete a row, it is not updated to the underlying database table. I have to click elsewhere in the form to cause the dgv_rowValidated to fire where I have the following code in there to push changes to the database:
bs,EndEdit
Dim cb As New SqlCommandBuilder(myDataAdapter)
myDataAdapter.Update(myDataSet)
Normally, where do I place such code for updating when comes to deleting a row in datagridview? I noticed userDeletedRow event does not fired when I am deleting the last row in a one row datagridview.
The label never get updated when it is assigned a new value from DB. I try with label.refresh method and also update method but the label still never get updated.
View 2 RepliesI've updated my database...
And all the information goes in fine, and an Auto-Number is allocated.
Do I need to re-read the database to find & display this auto-number?
Where do I begin?
part of my code is in below
[Code]...
I would expect to see the path.Path include the new record, however, I also notice that tempnextgen also include the new record. Can anyone help me out on this issue? Why the tempnextgen got updated as well, how to prevent this unexpected operation?
I am working on VB.Net. I have a sub form with a datagridview, that is being loaded with the criteria taken from another form. Hence this form is called with parameters. Here is the code that calls the sub form.
[code]...
where ds is the dataset to fill the datagridview and rb is the string from a radio button on this form.
Here is the code in the sub form.
[code]...
Now, I need to refresh this sub form every -- minutes, depending on how the user wants it to be. For this I have given a NumericUpDown control to select the mins. All this works fine. But how do I refresh the dataset and the datagridview?
I have invoice form bound to a bindingsource and bindingnavigator. In the form I have unit price, quantity and total textboxes. The total textbox text property is set to total.text = quantity.text * unitprice.text in the textChanged event of both quantity and unitprice text boxes. The result is displayed in the total textbox. But when i hit save button on the bindingnavigator it is set to null and not saved to database. [code]When I used msgbox to see the value of total textbox before bindingsource.endEdit() it is the correct value. but after the code bindingsource.endEdit() it is null. I checked the databinding property and it is correct. What is the problem.
View 1 RepliesI've created a VB.NET Windows Form application which pulls info from an MSAccess database via datasets and tableadapter. When the user makes a change to the data, I use the Update method of the tableadapter to send the changes back to the database. This all works fine in the Visual Studio 2008 IDE, but once the build is done and the application is installed, I run into problems. The application keeps the original data and will not read or write to the database, although any changes I make through the application are mysteriously saved somewhere. If I make changes directly to the database using MS Access - which I need to be able to do - those changes don't show up in the data pulled into the application.
View 13 RepliesI can figure out how to do this, but Im not sure what I should be looking for. I have a database that gets updated about once a month, and when it does, it changes the name of the database file to match the date and time the new database was created.
The file name always starts with DB and the rest of the file name structure is DBYYYYMMDDHHMMSS (After the seconds, the file name is the same for all of the databases)
There are a few things I am trying to do.
1.I want to be able to search the update folder for whatever database is there
2.Trim the file name to return the database name as DBYYYYMMDD
3.Search the local database folder for the specific file name and return it in the same format as the update
4.Compare the two file names and choose which decide if one is newer than the other based on the date
What I need to know is what this would be called and what I would need to use to accomplish this.
I am developing an app that has a treeview on the left in panel1 of a split container. When you click in a node it loads a user control into a tabcontrol that is in panel2. Some of the user contols contain webbrowsers that autorefresh every 15 sec (not under my control). I can successfully remove a tab by a contextmenu but I can still hear the clicking sound of the webbrowsers refreshing. Not sure what to do to completely remove the usercontrol. Treeview control code for one node: there rest are basically the same
Code:
Dim tabcount As Integer
tabcount = TabControlMain.TabCount
[CODE]...
Code to remove a tab and all tabs:
Code:
Private Sub RemoveToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RemoveToolStripMenuItem.Click
TabControlMain.Controls.Remove(TabControlMain.SelectedTab)
[CODE]...
I also originally had this setup to work without the tabcontrol and just load the usercontrol into panel2 of the split container. Each time a new node was selected from the treeview I would have SplitContainer1.Panel2.Controls.Clear() to remove the current usercontrol. I would still hear the clicking of the old usercontrol.
how to get the updated database data and print into crystal report using VB.net?
Dim rpt As New CrystalReport1()
Dim myConnection As SqlConnection
Dim MyCommand As New SqlCommand()
[Code].....
VB2008 with MS Access Database updated related data ?
View 9 Repliescurrently i had a program which working fine when its running in the solution explorer,but after published,problem comes.my datagridview cant show updated data while my database access already update...my datagridview only show existed data.could it be my datagrid problem?i get my data programmatically or is my INSERT command doesn't update the dataset?but in the solution explorer does show the dataset was updated. [code]
View 3 RepliesI can edit the values in the dgv cells manually, add rows, delete rows all without problem and then update the database.My problem is in one form where I want to allow the user to filter the rows in the grid and then enter a value in a textbox and programmatically update all the cells in one column with that valueI can update the rows, and see the changes in the datagridview. When I try and update the database (using UpdateQuery on the underlying TableAdapter of the datagird) only some of thechanged rows are being updated I though it might be related
View 9 RepliesI load a DataGridView (VB.Net, VS2005) using the code below. The save logic works fine for manual edits oh the cells.However, I run some code that updates a Status column in every row then I call the same Save logic. All rows execpt the first row are updated! I am updating the Datasource (dvCerts)Ah.... I just tried changing the CurrentCell to 1,0 instead of 0,0 and now the data saves OK.
Load_...
daCerts.SelectCommand = New SqlCommand("SELECT * FROM PERP_ARB_Certificates", conPERP)
Dim cmdBldr As New SqlCommandBuilder(daCerts) ' used for grid save
[code].....
as os are being updated does windows updates the api also ?is yes what are the new windows api provided by microsoft and their documentation for windows 7
View 6 RepliesI have a picturebox that is supposed to grab an image from the clipboard, which contains the latest image captured from a webcam. Portion of the codes are as follows:[code]...
View 8 Replies[Code]...
The table is not getting updated.
i'm having a gridview which is binded to a dataview, OnPageLoad i'm populating gridview records. and i have a textbox and a button, So now i want to add more Records to GridView but this records should not be get added into DB, they just added to the page and of course the default records which are coming from db stay.
<asp:GridView id="gvItems" runat="server">
<Columns>
<asp:TemplateField HeaderText="Item Code" SortExpression="ItemCode">[code]....
Basically at first Data From DB comes to page then after that Textbox data should get appended to the Gridview but Db should not get updated. i tried to do it by keeping DataView in ViewState or Session variable but later i came to know am going in a wrong way and that this won't work since Dataview can't be Serialized. i just need an idea or right path to do this, is this possible what am doing? [my alternative option ]: create a temp db table and save it... but i don't want to use this option..
In my inventory mobile application , i use RDA.using the mobile device ,i update only the Barcode of a particular Item which is in the Item Master(.sdf file). then I push the tables to the SQL Server.there is a web application handles all the other functionality , including Item Master Changes.for and eg.
(1) I pull the Item master to the Mobile Device.
(2)change the Item Name from the Web application.(NOT FROM DEVICE)
(3)Update Bar code from the Device
(4)push table from mobile Device to SQL Server.
In this situation Old Item Name is replaced.My need is only to update the Barcode.
I am using a table adapter and the update code as below in a Try/Catch block as shown on the MSDN site.
Me.MyTableAdapter.Update(Me.MyDataSet.MyTable)
This all works fine but I should like to return to the user a MsgBox which displays the count of new records added and/or existing records amended.I know I could count the records in the underlying table before and after the update, the difference being the count of new records. How can I count amended existing records ?
I am using the project management database created by Microsoft to track our projects. I would like it to notify (send an email) out to people once they are added to a project. And then send another one out when their due date is a couple days out as a reminder. Can someone help me with this. I am not a guru at programming and am just starting to get in to it. I would love to get this task done and then I think this database is complete. ( I am guessing I need to use the DoCmd.SendObject, but from there I am lost and what needs to go before it.)
View 2 RepliesDoes anyone know if Visual Studio 2010 has a good/Updated Tapi sdk? Or Does any one know where I can get a Tapi Sdk that is in .Net format?
View 1 RepliesUsing VB in Visual Studio 2005, I buit a lttle bit of code to create/manipulate an Excel spread sheet. At time of creation no problem no errors or warnings. Program ran fine. That was a couple weeks ago, I open the project now and I get a warning :"Warnin There are updated custom wrappers available for the following referenced components: Excel ,VBIDEI haven't changed anything. One other thread to this said remove references to Excel and readd, I tried that, no luck. I have had same warning with other VB programs using COM and cannot firgure out how to update custom wrappersRDE
View 1 RepliesI have an array of objects, I find the item by index, assign a value but then looking at the array the item doesn't show the updated value.
Public Structure Cheque
Public Id As String
Public Status As Byte
[code].....
How can i retrieve last updated EmpID form sql database.
View 1 Replies