I have made several changes to the columns in an Access db, such as additional columns, column type changes, etc. how do I now incorporate those changes into my datasource? Do I need to delete the datasource and create it from scratch?
View 1 RepliesI am trying to migrate from Access Database to SQL server database. Do I need to make changes (for saving, reading, deleting etc. data) to my code as well?
I understand I need to change connection but what about code?
I use vb.net and windows form and sqlserver
I added Data Source(Microsoft SQL Server (SqlClient)) to my project. and now I need to change it to ODBC Data Source .
I got a DATASource connected, changed the table to details and draged it on to my form, but then it shows me the bindingnavigator at to of my form.
q1. how do i make it so every time this form opens it is like add new?
q2. how do make my own save button (don't want the binding navigator at top)
q3. in my form all my collums aper as textboxes how can i change it so there is a drop down menue that has forexaple 3 pre defined items that the user has to select on of.
i have datasource with stored procedure.Now my stored procedure is changed with new column .In datasource panel i click with refresh button, but i don't see new column how can i ?
View 7 RepliesEmployee emp = new Employee();
comHandledBySQt.DataSource = emp.GetDataFromTable("1");
comHandledBySQt.DisplayMember = "FirstName";
The above code displays drop list of employees first names in a combo box. I want first name and last name to be displayed. How can i do it?I tried to include two columns FirstName and LastName as below but didn't work.
comHandledBySQt.DisplayMember = "FirstName" + " " + "LastName";
I have 10 Comboboxes in a form. All these combo boxes have databound items which come from the same column in a table in the database (access 07) (Am designing a billing software, and these comboboxes show the items (10 lines of them).All these combos reside in one Groupbox.Now for the strange (scary/funny) part, whenever I change a value of 1 combo, all the other combos change automatically and show the same value as the one that was changed. (strange!).
View 6 RepliesI have a datagridview with its datasource binded to a List(Of T). Now i would like to sort on any of the columns.My code:
'Database access : items = List(BlogPost)
dgBlogPosts.DataSource = items
'My BlogPost Class
Public Class BlogPost
[Code]...
I am using the following code to alter an table imported from an Excel spreadsheet
Dim SQL As String = "ALTER TABLE receipts ADD payee integer, account integer, category integer, reconciled boolean"
Dim dataread As New OleDb.OleDbCommand()
dataread.Connection = Connection1
[code]....
Both ExecuteNonQuery() actions yields the exception message {"Syntax error in field definition."}The error message does not happen with the first if the boolean column is not there (I tried Tes/No as a definition - but that also failed.The second query to modify the ID column from autonumber to integer I assume fails because it is a Primary KeyHas?
I have a data entry form with many text boxes/combo boxes/controls. I want to change their bgcolor everytime the user makes a change so they are aware of what changes they have made before commiting.
My plan is to store the original value in the tag and comapre in the validated event.
I don't won't to write the same code everytime I need a control to behave that way. I've never written a customcontrol before.
how to achieve this by probably subclassing the control and reuse the code regardless of the type of control it is?
"write sub prototype for a procedure whcih is named my data and has first parameter as a string which can be changed and second parameter of an integer which cannot be change"
View 3 RepliesAfter packaging my created program.... and install it.... if i install it in my system its ok... but if i install it to other system... some labels... changed position....
View 2 RepliesIs there a way to set the IDE to automatically update all usage of a variable when the case is changed in the declaration? I know ... if I typed it correctly in the first place it wouldn't matter! And I do know how to use search/replace, I'm just lazy.
View 4 RepliesWhen I try to change the datasource of my DataGridView, I am loosing the order of the columns and their type(checkboxes,comboboxes) that i specified on designtime! It's like changing the datasource is generating again the datagridview, why ? and How can I change the datasource without losing these information ? on form load i do something like
Private Sub frmGrid_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim Path as string
[Code].....
I have a vb.net window application project that connect to Access database.
I use dataset for all Forms and Reports.
Now I would like to change back end from Access database to SQL Server 2000 database.
I change the connection string(Data source, Data Provider etc)to connect to SQL Server 2000.
But it is not convenience bcos Dataset Designer codes are still connect with OLEDB Provider instead of Sql Client Provider.
So I can't do my application with SQL Server database.
I'm using VB.NET 2003 windows application.i'm trying to display Crystal Reports using CrystalReportViewer.
Code i'm using to display "ZTab.rpt" in CrystalReportViewer when Form_Load
Code: Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
for example: if we are using datasource "work.mdb" for "ZTab.rpt" when form_load. when i hit a button, how come i change the datasource to "Employee.mdb" for "ZTab.rpt" during run time using codes. so when form_load it will display ZTab.rpt with datasource "work.mdb" and when i hit a button, it will display ZTab.rpt with datasource "Employee.mdb".
I'm using VB.NET 2003 windows application.
i'm trying to display Crystal Reports using CrystalReportViewer.
Code i'm using to display "ZTab.rpt" in CrystalReportViewer when Form_Load
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
CrystalReportViewer1.ReportSource = "ZTab.rpt"
[Code].....
so when Form_load, it displays "ZTab.rpt" and when i select one crystal report in combobox and hit button "Run", it displays corresponding crystal report. that works fine.
how can i change the datasource of a report during run time using codes (programming).
for example: if we are using datasource "work.mdb" for "ZTab.rpt" when form_load. when i hit a button, how come i change the datasource to "Employee.mdb" for "ZTab.rpt" during run time using codes. so when form_load it will display ZTab.rpt with datasource "work.mdb" and when i hit a button, it will display ZTab.rpt with datasource "Employee.mdb".
Code for button:
Protected Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click
Dim li1 As ListItem
Dim addList As New List(Of ListItem)
[code]....
Updates are happening on the load of a dropdownbox This has something to do with autopostbacks and the page load I think, can someone please help When I click the add button even if I have selected an item in the listbox, it will always return an error message. I don't think the listbox changedselected item is firing.
1.Multiple monitors are connection to one computer and they are extended.
2.My window spans to two monitors (Any window like notepad or settings wizard).
3.We change Visual Style From ON to OFF ( i.e. Changed theme from basic and high contrast to Aero or vice versa)
4.The window which was present on two gets shifted to either primary or secondary monitor.
5.This behavior is ok with normal application but I am developing such application which fails if window moves away.
6.I have added handler to check if user changes theme or visual style using :
AddHandler SystemEvents.UserPreferenceChanged, AddressOf UserPreferenceChangedHandler And in UserPreferenceChangedHandler I have checked if UserPreferenceCategory.VisualStyle changed and if it is changed then I have reset the window position back to old values before theme changed , but still it not reverting back to old position.
7.One strange behavior I observed is, it works if I set break point and step through code , but if I remove it then it's not working.
a. Added handler to catch user preferences changed event.
Private Sub RecordingWindow_Load(sender As Object, e As System.EventArgs) Handles Me.Load
AddHandler SystemEvents.UserPreferenceChanged, AddressOf UserPreferenceChangedHandler
End Sub
b. Copied old position
Protected Overrides Sub WndProc(ByRef m As System.Windows.Forms.Message)
If m.Msg = WM_MOVING Then
' Console.WriteLine("Window is moving")
[code]...
d . This is additional code which i tried instead of WndProc
Private Sub RecordingWindow_LocationChanged(sender As System.Object, e As System.EventArgs) Handles MyBase.LocationChanged
_windowLocBeforThemeChanged = Me.Location
End Sub
I have a vb.net project. I have used the GUI and wizard to create a DataSource pointing to a SQL Server Stored Procedure. It works great! However, a new column has been added to the stored procedure.In the GUI if I right click the data source name and refresh, nothing happens.If I right click the stored procedure name and refresh, nothing happens.If I preview data I can see the new column returned.If I choose edit with wizard there is a red exclamation point next to the name of the stored procedure and red X be each column name.
When I hover over the field name it says "Column ABC in the DataSet references a column missing from the Database".When I hover over the stored procedure it says "STORED_PROCEDURE is mapped to STORED_PROCEDURE in the DataSet. Element STORED_PROCEDURE in the DataSet contains columns that do not exist in the Database".I can't figure out how to get the new columnd in the dataset.
I have to change my sql server and need to point all my crystal reports to that new server at runtime, some reports has StoredProcedures embeded inside and those are the problems.[code]....
View 2 RepliesI need to know how to dynamically change the datasource of a rdlc file.
View 1 Repliesdim oXT As New Generic.SortedDictionary(Of String, MyClass)
[Code]...
So based on what is selected in a radiobuttonlist i want the select command to change for my datasource. The problem I'm facing is that if i set the default selected radio button the query will work for that
my radiobuttonlist , user (dropdownlist are all located in an update panel that is not updated after the button is clicked
this my button code
If user.Text = "ALL" Then
SqlDataSource22.SelectCommand = "SELECT * FROM [dashboardtasks] WHERE [completed] = 'NO'"
[Code].....
I made an application that was used by one person only, but now my boss told me that this application it'll be used by all company.I made the application with a dataset that have the datasource in a access database that's installed with the application. The user can add, delete and change values in the database, so i had to put the database in a sql server to everyone see the changes.There's someway to change the dataset datasource/connection string?
View 9 RepliesLet me try to describe my problems in the simplest way: I have combobox1 and combobox2. I hope to achieve two things: Combox1 is bound to list1 (a list of string). When a user selects an item in list1, list2 (a list of string) will be obtained from database and combobox is bound to list2.If user specifies text1 in combobox1 and text2 in combobox2, then these two values will be shown in the comboboxes regardless of the bound lists.
[Code]...
So the results of above code is that goal 1 is achieved, but goal 2 is never achieved. combobox1.selected index is always 0 and combobox2.selected index is always 0 too.
A program that I'm designing for a local jewelry shop to print receipts and what not, there are multiple cashiers. I have written a database in Access with the Cashier ID, First Name, Last Name, PasswordI have added this to my dataset, it shows up as CashierDataSet1. What I need to do is verify the Cashier ID, and the Password match TextBox1, and 2. All the tutorials I have found are for accessing that database on the local hard drive, which would be fine if I could get rid of my UnauthorizedAccessException error. Any ideas or well known tutorials for using a database in a dataset without pulling the text boxes onto the form and creating that navigator ?
View 3 RepliesOk, so I've got this Visual Studio 2008 Project I was working with about a year ago perhaps. And this project had a datagrid that was linked to an external database running on a server off the internet. Now, this databinding was all done using Visual Studio 2008's built in features. But how can I now change the binding to a different server, without destroying the project? I've noticed that a lot of the code that Visual Studio creates makes a mess. So manually trying to change the datasource has allways f*cked up the whole project for me.
I'm not all that good with this stuff, that's why I used the built in features of Visual Studio. But I noticed that several things appear, like a binding source, and a dataset. Is it possible to do this? Perhaps even better, making these settings be controlled after the program has been compiled. The way it is now, it's all hard coded after compiling, and that kinda sucks. I remember trying to do this about a year ago, trying to bind these settings to variables stored in settings. But I never got that to work. Just throwing around ideas here
I am working on a program that is using Access as its datasource. I would like to be able to have the user "approve" a bid and then the database copy that row into the Approved Bids table from the Submit for Approval Table and then delete the entry from the Submit Table.
View 1 RepliesI have a bound datagridview which populates from the database using parameters. I've added a combobox column through the datagridview properties. How do I access this combobox column datasource?
View 9 Replies