Search results for query: *

I have been struggling for several days now trying to figure out why I am getting the failed to enable constraints, one or more rows contain values violating non-null, unique, or foreign-key constraints when running my code. I have a stored procedure in sql server, part of it below...

If I am posting this is the wrong area, I apologize. I am trying to add a table adapter to one of my datasets. The dataset has oracle as its datasource using ODP.NET. When I put in the query (which works elsewhere) I get this error (Syntax Error: Expecting identifier or quoted identifier)...

I have a form with a grid on it. I have handled the row click event (I am using devexpress winforms addins). I take the employee id from the first form, open the second form and set a value for one of the lookup combos. The first time i do this it works perfectly. If i then close that second...

This might be a dump question and I am just overlooking something. I have a combobox with a datasource to a dataset datatable. It list a bunch of IDs. Next to it, I have a bunch of textboxes that i bound to other fields of that datatable. When I open the form, the combobox is empty like it...

I am trying to write a linq query and having a fit trying to figure it out. Am not very good with linq, just the basics. I code in vb. So I created a datatable in code, then want to write a query that joins it to a typed datatable. Here is what i have so far: Dim dt As New DataTable...

I am trying to create a table adapter that contains a case when and IN clauses, see below: SELECT CATSCOUNTE, PABRJ AS FYR, PABRP AS PP, PERSNO AS EMPL_ID, PNALT AS EMP_NO, CASE WHEN SUBSTR(lstar,1,3) IN ('LAD','LIN','IDR') THEN 'Z' ELSE...

I have a dataset in my project that is connected to oracle. In the dataset i created a tableadapter fillbyEmplLIst. In short the query looks like this: Select * from table where name in (:Value) Where :Value is a parameter. In my code i have this: oraddt =...

I know this will be easy for you guys. I just cant figure it out. I have been away from it for awhile and forgot a lot. I have a form with a combobox (it is actually a devexpress lookupedit) that i have my employee table from my dataset as the datasource. In that i have the employees name...

Here is the situation. I have to get data out of oracle from two tables. The problem is the tables are in different oracle instances. I need to use the results from one select in the where close of the second. I am not sure how to do this. Prior, i just hard coded the where, but things...

So I have a solution that I built that uses DevExpress Controls. The references are in the project properties page. I am using the install shield le 2013 Visual Studio add in to create a setup. How do I make it so it registers the references during the setup instead of just copying the dlls...

So I made a mistake and developed an app in .net framework 4 client profile. It should be the full version. So I changed the target framework to the full version and now got all these errors. delegate Class 'cardimageRowChangeEventHandler' and delegate Class 'cardimageRowChangeEventHandler'...

I have an menu form that is an mdi container. When my app opens, it opens up the menu form. It then does: Dim newmdichild As New frm_login newmdichild.MdiParent = Me newmdichild.Show() newmdichild.Left = (Me.Width / 2) - (newmdichild.Width / 2)...

For the last few days I have been having an issue with my dataset. I have one dataset. Ever since the other day after i went and configured the dataset to pull a new table from my database, I have been having an issue where when I save it creates a new designer.vb file but adds a one to it...

I am trying to move rows up and down in a datagrid. I got that working, it just swaps values in the order column. My problem is when I delete a row. How do I deal with order column when i delete a row.

So I have a form that has controls and binding sources, etc Public Class frm_newflightcard .... end class in the same form code, I added a class: Public Class DropDownListHelper Public Shared Function GetDropDownList(path As String) As List(Of String) Dim result As New List(Of...

I have a form that loads to a selected row selected by the user. The controls are disabled so they cant make changes. What I would like to do is have a button they can click to create a new revision. The parent table has a column named revision for this purpose. So I would like the user to...

So I have a query with results that I want to put into a datagridview. I have it working except I get an error on the last line. Private Sub frm_loadcards_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load...

This deals with images and parent child tables. I have an app that has a parent table and a child table. The child table will hold images. There is a 1 to (0 to many) relationship between these tables. There can be several images associate with a record in the parent table. I am...

I have received alot of help from this site on this issue. I have solved a lot of my problems and I am down to one final one. I have a parent table with two child tables. the parent id is in each of the child tables. On save, the id is flowed down to the child tables with no problems. The...

I am looking for a richtextbox editor for windows forms. Nothing complex - bold, underline, italic, bullets, numbers, font size, etc, the basics. How do I accomplish this. I can't just add a richtextbox from the toolbox can I? I tried that, there was no editor. I am using visual studio...