Know If Theres A Changes Happen In Database?
May 31, 2010How to know if theres a changes happen in database?
View 10 RepliesHow to know if theres a changes happen in database?
View 10 RepliesAfter developing using the Excel Interop with .Net for a while, i have become increasingly annoyed with the how many "odd things" happen - such as this question i posted earlier.
View 6 RepliesOk lets say i have a textbox with five ones. How do i make something happen for every 1 in the textbox?
View 2 RepliesI'm wondering what would happen if my program was used say, on a computer with a chinese keyboard? I assume the text box controls will be fine, but sometimes I compare english strings.. such as "!" and "@" and a few other things.
View 3 RepliesI have a form with seven tickboxes - one for each day of the week - each one saved in my.settings.monday, my.settings.tuesday, etc Now I need to check if something should happen today and the code I'm using (below) seems very longwinded. Can anyone help 'tidy it up'?
If Now.DayOfWeek = DayOfWeek.Monday And My.Settings.monday = True Then
'do it
End If
[code]....
what MSDN is trying to indicate here on this tutorial, ref this page: Walkthrough: Creating a SQL Server Express Database.I cannot make this happen in VS2008 SQL Server 3.5 ? To create a relationship between the tables created in the previous step 1.Right-click the Database Diagrams node in the SampleDatabase.mdf node in Server Explorer/Database Explorer and choose Add New Diagram.
2.Click Yes if a dialog box opens asking to create the required database objects for diagramming.
3.Add the Customers and Orders tables to the diagram.
4.Close the Add Table dialog box.
5.Drag the CustomerID column from the Customers table onto the Orders table.
6.Verify that the Customers table is the Primary key table and the Orders table is the Foreign key table, and verify that the CustomerID column is selected for both tables.
7.Click OK to close the Tables and Columns dialog box.
8.Click OK to close the Foreign Key Relationship dialog box and create the relationship.
9.Select Save Diagram1 from the File menu.
10.Leave the default name and click OK.
11.Click Yes in the Save dialog box.
I can create relationships but not the Diagram ?
I get the following Error: when Using The program ... Didn't Used to happen before ...
This Is the Source Code :
Form2
Form1
I Have tried Different Stuff But none of Them work.
Strange problem: This code gives the appearance the I have 'Split' 1 button into 2 (B -> B(1) & B(2)) and then can 'Join' them back(B(1) & B(2) disappear and B returns). All this works fine, 'cept when I try to declare the only container where this can happen. The 'Control-S' part works as long as the lower portion is commented out, when I uncomment the lower portion 'Control-J' neither part works - the code skips down to the msgbox -
If e.Modifiers = Keys.Control AndAlso e.KeyCode = Keys.S Then
If DirectCast(sender, Button).Parent Is flp1 Then
MakeButton(sender.text & "(1)") 'sub that makes the button passing the text thru
[code]....
I have a website that i've been working on for about a year now.Recently, it's started throwing System.AccessViolationException every now and then, in my dev machine, mostly, when I was away from the machine.I haven't changed anything on the server code in weeks, since I've been working 100% on the Javascript part, and this error started appearing recently.
Also, the code I'm doing is 100% managed. I'm not doing any interop, calling strange DLLs, nothing. It's pure VB.Net, so I don't see how I could be generating one of these myself.Now, I've been using this new machine for a couple of months, and it's not working 100% right. Every 2 or 3 days I'm getting a blue screen for example. I haven't had time to diagnose it properly, but I'm suspecting I may have a faulty RAM chip.
[Code]...
how to make a button get clicked when a key is pressed. The key I want to press is ctrl and I want it to press Button1.
View 5 Replieshow to make an event happen when user presses a key ... let's say space or whichever...and the other thing - how to display a folder on my hard disk ("E:Music") in a ListView box in my program?
View 7 RepliesI have created this user control.
Imports SAAQ.Utl.W00692BaseControle
Imports System.ComponentModel
Imports System.Web.UI.WebControls
Imports System.Web.UI
[code]....
However, the method Button_Click is never called when i click on of the button thatt his method handle. The specifics events arent raised.
I have made 2 application server/client. I want to remote the client from server for example if I press 1 then one action should happen in client, if 2 then another action should occur. How can I do it? I think I should use select statment
Select case a' a dim as integer
case Keys.1
frmmain.axwindowsMediaPlayer1.ctlcontrol.play()
end select
is this right ?
I'm attempting to create the sending path files from each rows of Datagridview to USB removable Drive. Below the code i''ve got from Shanks it's just show the name of usb drives but when i clicked on sendto not work.
[Code]...
I'm beginner on VB 2010 and I wanna write an app that can downloads file My question is: If it gives me 404 or 403 or whatever, I wanna let the app ignore that message, instead of a webexception error Note: I've already know how to download file with VB
View 2 RepliesI have this function I put together with help online and it works just fine until the program runs over night. I don't think it is night time that is the problem, just the long run time. I take bitmaps and place text on them then convert them to icons so that the image can be used on the system tray.
[Code]...
i'd like to know how to make an event happen when user presses a key ... let's say space or whichever...and the other thing - how to display a folder on my hard disk ("E:Music") in a ListView box in my program?
View 1 RepliesA few years ago I have been busy creating this application but it didn't succeed, now Im coming back to it and similar problems occur. Basically I use SetPixel on a given window to draw a line, work fine, but the line goes away as the window redraws itself.The problem: I have been putting timers and threads on it to make sure the line is being drawn. Is there any way to make a loop to make a certain thing happen about 10-30 times without taking in too much memory/CPU?
View 7 RepliesWhat will happen when 3 function calls same function at a time? I have 3 Function, f1,f2,f3.. Those function after completing their task will call finish() function. What will happen if Finish is Called morethan once..
View 9 RepliesIf NewEntryName.Text = "" And OpenFileDialog1.FileName = Nothing Then MsgBox("Please choose a name for your game.", vbExclamation) MsgBox("Please find your game.", vbExclamation) Else Button1.Text = NewEntryName.Text
[code].....
I have code on log in form but it only get the latest data on username and password column on my database
Here is my code
Public Class Users
Dim MyLogIn As New myRecords
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[CODE]...
This is my connection:
Imports MySql.Data
Imports MySql.Data.MySqlClient
Module myconnect
[CODE]...
This is my record:
Imports System
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
[CODE]...
I recently upgraded the MS SQL Server installed on my personal computer from 2005 Express to 2008 Express. Problem is when I try to add an SQL database file to a project using VS 2005 I get an error message saying that the version of my database server is not supported, I must have SQL Server 2005 Beta 2 or later installed. I didn't do it yet but I'm pretty sure that when I open the other projects that I included a database file to it, I'm going to get the same error.
My question is it possible to have two SQL Servers installed on my machine? If so, is it a good idea to have two DB servers in the same machine?
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 RepliesThis program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
When I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 RepliesI'm trying to use LINQ to SQL in Visual Basic 2010 Express.
It allows me to create the .dbml file, but in order to drag items from the Database Explorer window to the design surface, I first have to get my database listed in the Database Explorer!(this is a remote SQL Server database - not a local .mdf)
I already have a good, working connection string to the remote SQL Server database, but that doesn't help me when I'm trying to generate the DBML at design time.
Can anyone tell me how to get my remote SQL Server database identified in the Database Explorere window? When I try the "Add Connection", I am limited to Access, SQL Server Compact, or SQL Server Database File. If I try to enter the IP address & port of my DB Host I get a 'database file does not exist' message. Doesn't seem to want to let me point to a remote DB server...
In vb.net I am using password protected database with following connection stringconnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:vaivaiDB.mdb;JetOLEDB:Database Password=secret;"Database access works fine on the development machine.
View 2 RepliesWhen I install my application, some forms are unable to connect to the database.
I say some because, when my login form works totally fine. Authentication happens.
But once I go into the main application, and open other windows, I start to get these error mesages:
[URL]
Friends I have Developed my Data base Project on vb6, using adodc and datagrid using ms access database file, it was working nice in vb6, I also put Search box there and used adodc1.recordsource="select * from table" sql query.
later i needed to convert it in vb.net I converted it, every thing is working fine, but one problem appears, an adodc's Recordsource query for searching records is not working, it only works if there is data in dataset (Datagrid),suppose once i pressed search button to search record and if no record found then dataset / datagrid becomes empty, now i wanted to search an other record with other name, but this time it does not work and following error appears Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
[Code]...
I am sitting with a situation that I have to combined (3 years) for 26 site of 29000 database files where there is 1 table in each data base called RECDATA, I need to combined all that data Into one database file called RECDATA.
For example there is a database called DB1 with a REDATA table inside it, and then DB2 with a RECDATA table inside it, DB3 with a RECDATA table inside it est. So I need to put all the Recdata into 1 Database file, or to copy all the RECDATA from all the database files to 1 RECDATA they all have the same columns All I need is to get all that data into 1 RECDATA table.
The program where this database comes from is a voicerecording system creating a new database every day. There is 1 database just for indexing (to view the recordings) and then the daily database is where the recording lies in, that Colum is called RECFILE. I will give you a example of the 2 database.