johmolan

Hi I am creating a report and I am filtering the columns of my table through a parameter. But I then add a few textboxes but I can not find a way to filter the values to show in these based on the parameter. Anyone who knows if this is …

I where to create a report from a mdf database-file. I have named the columns 1 - 70 for the simplicity when reusing the same code in several methods. But when I am to create the report is says that the column name is not cls compliant? How do I …

I have created a windiws forms program in visual studio. I am using a local mdf database file. I have also imported the same database inte my sql server. I hav altered the connectionstring in my.settings, But when I try to connect to the sql database the debugging just shuts …

In my program I hav a datagridview who is showing som data based on a table call it table_1. I have a table_01 witch has a Primary-key called OrdreID. The Binding navigator is connected to this table. The table called table_1 has a forreign key called OrdreId and are related …

I have a Form with a Datagridview, beneeth this I have Textboxex who shows data from a few columns but restricted to row nr 0. The problem is when I enter data into the datagridview in other rows than 0 or changes the focus inthe datagridvew from row 0 the …

I have earlier created the databases in the sql management studio. but a friend of mine said it would be possible to dreate the tables directly in visual studio and update to the database. I have tried to do it but I can't seem to make the tableadapters etc. because …

I have a button I use to copy a folder from one location to another. the code looks like this: [CODE] Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click Const FOLDER_FROM As String = "C:\Testcopy1" ' Folder to copy from Const FOLDER_TO As String = "C:\Mappestruktur" …

I have a REPORT WITH 10 SUBREPORTS, I have 2 Parameters in the main report and links the subreports to these parameters. my code looks like this: [CODE] Imports System.Data.SqlClient Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports System.Configuration Public Class CR Public Sname As String Public Dbname As String Public Uname As …

I have made a crystal report with subreports, In my subreports I have added commands like: SELECT * FROM Orders where orederID = {?orderID} When I run the report in viewer the report prompts for the orderID with a dialogbox. But I have several subreports that requires the same orderID …

I have made a crystal report, to be able to display data from several tables in the same report I have made a few subreports. But when I display the report some of the subreports grow beyond the next report, why doesn't the next report moove further down and start …

I use VS2008 where I have a program where I have about 20 tabpages with datagridviews and textboxes. But when it comes to printing windowsforms the sollution is just not good enough, and of course på programming skills is not good enough either. I want to print out the data …

I have 2 subs in my class. I need to use the values in the variables in the first sub in my second sub. like this. [CODE] Public sub test1() Dim one as double = 12 Dim two as double = 10 end sub Public sub test2() Dim three as …

I am trying to export a datagridview ti excel, but i get an error I do not quite understand. I have made two click-events using two buttons looking like this: [CODE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cnn As SqlConnection Dim sql As …

Hi, I have a windowsform in visual studio 2008, I connect to a ms sql-server On my form I have a datagridview who I use to enter data etc and save them to the database. I then have textboxes who shows the sum of the columns etc in the table …

I have a small problem when I edit cells in my datagrid. If I leave my cursor in the cell I just edited. and runds the updatecommand the cell does not update the edited value. But if I leave the cell before I run the updatecmmand it does. Anyone who …

I have a method where I am making a trial period. When the date has exceded its trialperiod the program will not close. The code looks like this: [CODE] Public Sub DemoRestrict() If My.Settings.dteStartDate = Nothing Then My.Settings.dteStartDate = Now End If If My.Settings.intTime = Nothing Then My.Settings.intTime = intTime …

I have an Access relation database with a few tables. Customer, order, process1, process11, process130 etc. Customer Primary key is CID Order tabel har Primary Key OrderID and Forreign Key CID All the Processtables has ID as PrimaryKey and OrderID as Forreign Keys. The relations are set to 1 to …

I have made an application using an access database. When I publish the application the database is set to be included. But when I install the application, the database does not install, then when I start my application I get an error because it can not find my database. Anyone …

I have a problem copying rows in a table. My code is: [CODE]Public Sub Ordreupdate() Dim conn2 As OleDbConnection conn2 = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source =|Datadirectory|\Kalkyle1.mdb") Dim dtbl As New DataTable Dim dt As New DataTable dtbl = Kalkyle1DataSet.Tables("Ordre") dt = dtbl.Clone Dim copyRows1 As DataRow Dim copyRows() As DataRow …

Is there a way to check if the user has changed the value of a textbox? I try to acces a variable in one of my methods to compare against the value but I can not seem to be able to access it?

I use the binding navigatorsaveitem to save my data back to the database, but the way I am doing it today seems to take an awful lot of time. Ex: [CODE]Private sub .....SaveItem_Click(Etc Etc Etc)Handles ....Click Me.Validate() Me.Process1BindingSource.EndEdit() Me.Process2BindingSource.EndEdit() Me.Process3BindingSource.EndEdit() Me.Process4BindingSource.EndEdit() Me.Process5BindingSource.EndEdit() Me.Process6BindingSource.EndEdit() Me.Process7BindingSource.EndEdit() Me.Process8BindingSource.EndEdit() Me.Process9BindingSource.EndEdit() Me.Process10BindingSource.EndEdit() Me.Process11BindingSource.EndEdit() Me.TableadapterManager.UpdateAll(Me.DataSet) 'Then …

if I forget to enter a value in a cell in my gridview a loooong error who says thar that the indata format is wrong. anyone who know where in visual studio I can make this error a bit more understandable for others?

I try to copy data from rows in my db and then add them with another ID. but somehow I think I have made a mess out of it. [CODE] Public Sub Ordreupdate() Dim dtbl As New DataTable Dim dt As New DataTable dtbl = Kalkyle1DataSet.Tables("Ordre") dt = dtbl.Clone Dim …

I have a windowsform where I have a listbox who displays all the pdf files in a folder, I select one of them and push a button and it shows in a webbrowsercontrol I have added to my form. But I know wants to have a similar form for my …

I want to sett the position on my bindingsource when I load my form. I have tried Me.Bindingsource.Position= 2 in my load event, but this does not work. How can I make this work?

I use the code [CODE]Dim Selvk As New Selvkost2 Selvk.PassedText = TextBox29.Text Selvk.Show()[/CODE] in mainform and the code [CODE] Private _passedText As String Public Property [PassedText]() As String Get Return _passedText End Get Set(ByVal Value As String) _passedText = Value End Set End Property [/CODE] in my second form and …

I have a windowsform, on that form I have put a panel. on this panel I have some labels and textboxes and a tabellayoutpanel. i use this code to print: [CODE] Private Sub PrintDocument1_PrintPage(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintPageEventArgs) Handles PrintDocument1.PrintPage Static page As Integer = 1 Dim …

I use the binding navigator in my application, but when the resolution of the display gets to small and I have to use the scrollbars I get a problem. the scrollbars automatically scrolls down below the navigator bar instead of showing it when the window loads. Anyone who can help …

Hi, I have a form with multiple tables. when I add rors into the tables I Use code like this: [CODE] Dim n As Integer = 0 For Each copyRows1 In copyRows Dim newOrdreRow As DataRow = Kalkyle1DataSet.Tables("Ordre").NewRow() Dim Ordredato As String = Kalkyle1DataSet.Tables("Ordre").Rows(n).Item("Ordedato") [/CODE] where I add new rows …

I have a Form1 with a method called OrdreUpdate2 I try to run thad method from another form by using the command Form1.Ordreupdate2 in a buttonclick. But nothing happens..What am I missing here?

have a method who gets data from one table, put the data into variables before it it returned into the same table with changed ID etc. My problem is that it adds the first row without any problems, but when it is supposed to add row number 2 the error …

I tried to sum a column using the Dim myValue As Double =myDt.Compute("Sum("total cost"),"Condition") But I ony end up with the result. SyntaxError:SytaxError in argument: expecting an argument for singel column with possible "Child"-qualificator. Anyone knows what I do wrong I tried the same code with the column quantity and …