Topics

I just had to reimage and reinstall all the software on my development computer. I installed SQL Server 2016 and Visual Studios 2015. I am converting a bunch of packages from SSIS 2008 to 2015. The scripting components are in VB but the only option Under scripting Languages is C# 2015. I must have installed something wrong because. I have packages I created before my computer when down that were in VB. I really need to get VB as a scripting language back. Can anyone help me? Continue reading...

I have 2 programs that I been using for a long time. Recently with the last update to 16.8.3 that my dll is now not taking signing input. What can I do to make it take a temporary certificate. Continue reading...

Hi, I have one web based application and having login screen. Currently Once user logged into the application, then If user copy the URL after login and paste it in different tab the user is still able to access inside application. So here user able to access in both tab as logged-in. My requirement is to terminate first/old session If user logged into second session(which is created new session). User should able to login in one session at a time, not in multiple session and also when user logged into new session, it should prompt warning message to both session as account is used some other place. How to achieve this in Web based VB.Net. Continue reading...

I inserted a backgroundworker form in my project. My intention is to execute a long time evaluation without blocking the graphic interface. These 2 routines should do the job: Public Sub BackgroundWorker1_RunWorkerCompleted(sender As Object, e As ComponentModel.RunWorkerCompletedEventArgs) Handles BackgroundWorker1.RunWorkerCompleted End Sub Public Sub BackgroundWorker1_DoWork(sender As Object, e As ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork x=math_evaluation() 'x is an array End Sub When math_evaluation is completed, RunWorkerCompleted should be triggered, but this does not happens. If I use in dowork not a func…

HI - Use this function to display data from DataTable to DataGrid View. - Everything Is fine.if No columns are added to the edit And delete column buttons -Many problems occur When adding columns To make edits And deleting button in column, when columns disappear Or additional columns appear. I don't know what the problem is. The code works fine without the edit button column Or delete button cell in columns, but I need it on the front of the invoice datagridview . function fill datagridview from datatable Public Sub Filldatg( ByVal dg As DataGridView, ByVal dT As DataTable, ByVal qurey As String) con.Open() 'dg.Columns.Clear() …

Hi Good People When a form loads the Taskbar does not show. On the form in properties, I have set the windows state to Maximized. I have tried different settings on the windows state. Normal, Minimised and the taskbar does show. I have looked at the taskbar settings but all seems to be OK. And on another program That I have not yet finished, The same form, same size, Same settings, shows the taskbar. There has been an update on Visual Basic. could this have been the problem or is there something I am not doing right? I have not had this problem before the taskbar has always shown after the form load. Kind regards Gary Gary Simpson Continu…

the error when i export data to Excel from DatagridView in visual basic 2008. error name: Member not found (Exception from HSRESULT : 0x80020003(DISP_E_MEBERNOTFOUND) Thanks any one help me! my email: k23phien@yahoo.com Continue reading...

Hello i want to add new column to datatable from combobox all items my code is Dim newColumn As New Data.DataColumn("Mån", GetType(System.String)) newColumn.DefaultValue = ComboBox1.Items.ToString dt.Columns.Add(newColumn) DataGridView3.DataSource = dt but is not working column is add but all items are System.Windows.Forms.ComboBox + ObjectCollection any help thanks Continue reading...

Unable to start program 'D:project1/debug/project1.exe' The System cannot find the file specified i'm code windows form with visual studio 2015 Continue reading...

I get a Syntax Error with the following code "ALTER TABLE receipts RENAME COLUMN payees TO payee" Any ideas of what I am doing wrong reagards Colin Reid Continue reading...

Hi, I have a library database with related tables. dbo.boeken (books) that only have the general data of a book. PK is BoekID There is a relationship with dbo.BoekenGegevens (Book data). These data for the book are the author, publisher and nur codes. An author and publisher have written and published several books. FK is BoekID (The other FK's belongs to Author / Publisher etc.) The other table has the details of who owns the book. FK is BoekID A book can be owned by several libraries. Now I want to do a search with a Linq query on the title of a book. How do I build a LINQ query so that I only see the books that belong to the requesting library? Th…

Hi, How do I write a regex pattern for numbers -1, 0, 1, 2, 3 4, 5? I need for any combination of digits 0 to 5 and another solely for negative one. Appreciate any help. Marilyn Gambone Continue reading...

'Visual Studio 2019 Community' is installed with the option '.NET desktop development' selected. I would like to add a new project 'Setup Wizard' to an existing Visual Basic project but it is not an option in the 'Create a new project' selection display. Question: How to modify Visual Studio 2019 Community so that 'Setup Wizard' is available? Thanks much... jssd Continue reading...

My Windows Form app processes files and is called from the right-click context menu from Windows Explorer. The user selects one or more files, right-clicks on the selection, then picks my app from the context menu. The behaviour of Windows is to call the app once for each file in the selection, and the filename is passed as an argument. Since my app is a "single instance application", I need to use the MyApplication_StartupNextInstance event to capture all the filenames selected. It works - most of the time. Every once in a while (1 out of 5 or so), it misses a file with no error or explanation. I'll select 4 files in Win Explorer, right-click, select my program, and my p…

I'm developing a Windows desktop Form application using VS2019. I am using a Google True Type Font Family, "Federo-Regular.ttf". I want to use it for some controls on my Form1. The custom font is loaded via a method when Form1 loads: Private Sub SetForm1CustomFont() Dim privateFonts As New System.Drawing.Text.PrivateFontCollection() Dim filePath As String = IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Federo-Regular.ttf") privateFonts.AddFontFile(filePath) Dim font24 As New System.Drawing.Font(privateFonts.Families(0), 24) Dim font12 As New System.Drawing.Font(privateFonts.Families(0), 12) Me.LblLogo…

I have this problem when publishing and installing my app in another pc. This program is a windows application written in c#. This comes with a local db (.mdf) I made the Connection String to be relative, that is Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\SampleDb.mdf;Integrated Security=True" providerName="System.Data.SqlClient In the publish setting I did not include the SQL Server 2012 Express Local DB. Only the .Net Framework 4.7.2 is included. Then I encountered this error when running the app in another PC error: 52: Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly inst…

This "Visual Basic" Forum will be migrated to a new home on Microsoft Q&A! We've listened to your feedback on how we can enhance the forum experience. Microsoft Q&A allows us to add new functionality and enables easier access to all the technical resources most useful to you, like Microsoft Docs and Microsoft Learn. Now until Nov 29, 2020: You can post any new questions on Microsoft Q&A or here. From Nov 30, 2019 until Dec 14, 2020: New posts - We invite you to post new questions in the "Visual Basic" forum's new home on Microsoft Q&A. The current forum will not allow any new questions. Existing posts - Interact here with existing…

hi I used this code to restore the database from a specified path or root path, but the following error occurs my code Public conA As New SqlConnection("Data Source=DESKTOP-TRRGQMF\SQLEXPRESS2014; Initial Catalog=namedb; Integrated Security=true") Try cmd = New SqlCommand("restore database namedb from disk='C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS2014\MSSQL\Backup\namedb.bak'", conA) conA.Open() cmd.ExecuteNonQuery() conA.Close() Catch ex As Exception MsgBox(ex.Message) End Try another way 'Try ' Dim database As String = conA.D…

I have 2 diff. image format stored in db2 database as blob one start with 0000000C6A5020200D0A87 which cannot be displayed in picture box I get error invalid parameters and the other start with FFD8FFE000104A4649460 with no problem. So, I tried more than 1 solution till I finally succeeded to display both of them as in the below code But I got both as in Pic. How can I display both Pic. In the right format? Solution1 OleDbDataAdapter1.Fill(DataSet11, "PORT_IMAGE") Dim c As Integer = DataSet11.Tables("PORT_IMAGE").Rows.Count If c > 0 Then Dim output = New Bitmap(Width, Height) …

Hello dear Sirs, I need your help to make my server and client asynch. Here is the code Dll to serialize : Public Class Class1 <Serializable()> Public Class PacketMaker Public Property File As Byte() Public Property Type_Packet As PacketType End Class Public Enum PacketType As Integer MSG = &H5057 File = &H5056 End Enum End Class Server : Imports System.Net Imports System.Net.Sockets Imports System.Runtime.Serialization.Formatters.Binary Imports System.Text Imports System.Threading Imports ClassLibrary1.Class1 Public Class Form1 Public T As TcpListener = Ne…