In VisualStudio I have a tableadapter loading my *.mdb database. The problem is that when i have started, my "Phone" field was on Int.16, but now i nedd to change it to Int.64. I have already tried to change on DataSetDesigner and on mdb database, but when i press "Insert" button i got this message:
"Failed to convert parameter value from a Int64 to a Int16."
Can someone please help me create a very very simplistic sample page as the chat page included is too coomplete. something as simple as detecting a change in the database and displaying the word "change" on screen in realtime for any client connected.and I tried creating a global.asax file into which I added in the line mentioned in the link above, but it does not seem to like the word "Setup" in the line [code]
View 2 Replieswhats wrong with my code?if i change the item from the combo box..the textbox not change or has an error?
conn = New MySqlConnection()
conn.ConnectionString = "server=localhost; user id=root; password=12345; database=gigzta; allow zero datetime=no"
strsql = "SELECT accNo FROM accinfo WHERE (completename LIKE '%" & ComboBox2.Text & "%')"[code].....
This code works (I skipped some code here). I put it here to show names of my database, tables and fields.[code]...
View 3 RepliesI have an application that connects to a database on sql server. I want to make it possible to use another database that has the same structure as the one im using now (for example accounts2007 and accounts2008).
There is a form for login where user have to choose the database that he wants to use.
I fiqured out how to create a new user in vb for SQL, but when I try to access the database, I get a select error. I went into SQLMSO and changed the membership role to db_datareader and db_datawriter and ran my form again and I was allowed to delete and add records. Is there a way with the below to add a user and let them add and delete records.
[Code]...
I am using VB 2008 frountend & Access Databases for my backend.When i make changes to Database such as Change In Field Name, Change In Data Type, Change In field size Addition of new Fields, Deletion of old fields, ReOrdering fields names I use to reconfigure DataAdapter in dataset to take those changes in effect, however some changes took place where some other doesn't.get those changes in effect in right order.
View 1 RepliesI have an application with a database. I can add, remove and save items but when I want to CHANGE an item and save it, the program gives the following error: Update requires a valid UpdateCommand when passed DataRow collection with modified rows.
I am using "service-based database" from visual basic itself. No acces or something.
I have a large project that was originally written in VB6 using an ACCESS database. I want to rewrite it in vs2008 and change the database to SQL 2008. Someone on this site suggested that I look into NHibernate, which I am trying to do. Most of the samples are written in C#. My question is, does anyone know where I can find a sample of a project that is using NHibernate and VB.net? Or is there a better way to go?
View 1 RepliesI use VB2008 and database access and Crystal report.my problem : when ever I change location the database. I will always change location in my report from crystal report. It's very difficults and waste the time because I have many report. how to set up location only 1 place and impact to many report.
My VB Code :
Dim dbname1 As String = "D:AF_SoftwareDBDBAF1.mdb"
Public Strcon As String = "Provider=microsoft.jet.oledb.4.0;data source=" & dbname1 & ";jet OLEDB:Database Password=999"
make code in crystal report , if i want change drive to drive Z / or somthing else.now, i am go to the report and click change location.
I have this code to search my databas
[code]...
Is it possible change the connection string to a different database when the user changes the database they are using .i have a working program atm but i want to be able to change the connection with out having to change the code. the databases contain information from different years but all have the same tables queries etc.
View 2 RepliesI have a label that displays information from my database and I need to format it. It displays a number format like so: (53389) and I just need it to display (53,389)it uses the SQL to COUNT or SUM the data from the datasource. is there a way to have it format like I want when it is displayed, or do I need to change the data format in the database?
here is my code:
Try
Me.MAINTableAdapter.Fill(Me.MainDataSet.MAIN)
Me.MAINTableAdapter1.FillByExceeds(Me.BurnListingDataSet.MAIN)
[code]....
As the coding show at textbox 18/02/2012 (for example). but in database it is 02/18/2012.
TxtReqDate.Text = Calendar.SelectionStart.ToString("dd/MM/yyyy")
cboTermCode.Focus()
Calendar.Visible = False
[code].....
im currently working in a project and i already made a code for the login, the only thing is that i dont know how to update the records(Username/Password) in access using VB 2010. well i can update by manually changing the content of my table but i like to have it change using an interface in my vb named Manage account
View 9 RepliesIm doin project in vb.net as front - end and sqlserver 2005 as back-end
View 8 RepliesHow can i change the currency in ms access 2007. I want to change the dollar into peso. How can i do it?
View 5 RepliesI need to get the AVG of a column in my database i am retrieving. (.csv) I tried using the datatable.compute method but it doesnt work because my data in column is numbers in string format.So i need to either run another query and have the data in integer format?or change the column to integer format? I don't know I am asking as I am brand new to VB and programming for that matter.
[Code]...
Public Class Form1
Dim conn As String
Dim ds As New DataSet
Dim da As New OleDb.OleDbDataAdapter
[code]....
I need to change my [code]...
if i change it under settings it is working but i want to be able to change it in my running application, or when the application is opened for the first time i should be able to put in die path for the database.
I'm trying to write small piece of code in Visual Studio (VB.net) that will change value of a particular field of the database for all highlightetd rows. So, I'm running my form, which displays some data from the datatabse. I then highlight some rows (holding Ctrl and clicking). Next I click a button that will trigger a value change for all the highlighted rows (only). Say, I want to change the "Name" column's value for all of them.
View 1 RepliesI'm trying to add a datagridview in vb.net, but it does not allow me to change the connection string or the database that should be imported to connect to it. The only thing that I'm seeing is the previous ms sql database that I connected with datagridview and everytime I click the new connection, the window closes and it leaves me with the datagridview with the previous connection that I have. And its not applicable because, now I want to connect it with mysql. Not ms sql. Its some sort of a cache like feature in vb.net, how do I get rid of it. so that I can add the new connection for mysql? Do I need to reinstall visual studio 2008?
View 1 RepliesFollowing code is used in a .NET 2.0 windows service to continuously monitor a the table in the Database.[code]Seelctjob method will connect to SQL server 2005 database and executes the following Select query to see if there is a record with a particular status code.[code]This Select Query is executed continuously. If there is a record Start method will process further.I want to avoid executing the query continuoulsy. I tried using Sleep method and timer control. Thread.Sleep method stops the execution for sometime.[code]What is the best way of connecting to DB and monitoring a table at regular intervals of time without having much performance impact? When to use thread.sleep and a timer control and what is the difference between them?
View 4 RepliesI have an error to go mad. My vb.net application makes a report that runs fine in my local machine (with vs2003 and SQL Express 2005). My problem occurs when I execute this using an external database (SQL-Server 2000). Then my app returns the error "Query engine error: "c:....".The actually data origin for report is a dataset, and I've compared the two datasets fill
View 4 RepliesI have to do some maintenance on an old VB.NET application (Visual Studio 2003) that uses Infragistics NetAdvantage 2006. I have a UltraCombo control binded to a DataView.
How can I refresh the content displayed after a change in the database?
I have a datagrid that I am saving to a database. If i am currently in a cell and have changed the value of it, but have not exited the cell or pressed enter the change is not reflected in the database. I think what I have to do is either mimic the Enter key or ALT key command on the activecell in the datagrid, I have tried using
[Code]...
I have the following code to try and change a field in a Microsoft SQL database. I don't get any Exceptions when processing the code but I use the Microsoft SQL Management Studio to view the data before and after but the data does not change.
myDataAdapter.SelectCommand = New SqlCommand
myDataAdapter.SelectCommand.Connection = New SqlConnection(myConnectString)
myDataAdapter.SelectCommand.CommandText = mySqlString
[code]....
1) I created and attached a database to my VB application.
2) I edited the Dataset within the Designer to add a new Insert query to one table. Everything worked great.
3) Externally I modified the structure of the database, changing one field from date to string. Went back to the application and everything was fine. It seemed to update and be aware of the change.
4) Again externally I added a new field to the table. I went back to VB and adjusted the query to include the new variable.
5) Now, VB keeps telling me the first variable I changed is a Date variable and not a string, and I can't seem to convince it otherwise.
My changes should have been refreshed and changed automatically by VB. I did a lot of similar changes and additions earlier, and they all worked. Is there any way of forcing a refresh, or rebuilding the definitions. I did try to go into the designer.vb file and manually change the "date" to "string" in the references to my field (I adjusted all the fields so they matched other string variables).
I don't want to have to rebuild the whole application from the ground up again. (this is the third time something like this has happened to me).
I have few crystal 10 reports with default to a server & database during crystal design time (server=SRV1, DB=Pub1). And, i calling these report from VB. net application with a config.ini define my server & DB . Recently,i hv clone the same reports but extract from different server & Database name (Server=Srv2,DB=Pub2, the tables & fields are still same ) i have created a config.ini which contain my server, database, uid & pwd. And, when i execute these cloned report , they still point back to the origin server which was server=SRV1, DB=Pub1.
My coding :-
Imports CrystalDecisions.Shared
Imports CrystalDecisions.CrystalReports.Engine
Private Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs)
[Code].....
First, I would like to add a text box search field to this form (because navigating through several thousand users with arrows isn't going to work). When the search button is pressed, I want the username to be looked for. If found, the form (and each textbox, option button, etc.) is updated with that user. I can then modify the user's information and press save.
Second, how do I access and change information in a database with only code? For example, if I periodically want to check every user in the database to see if they have over "100 points" and if they do, I subtract 10 points from that user.