Member Avatar

I want to make a small logo in the upper corner of a Form rotate. I've seen on some forums that they have small avatars dancing and such, so I imagine it would be posible to make a tiny image rotate by it self up in the corner in a Form. Does anyone know how to do this? Link to tutorial, codesnippets etc.. Ps. The goal is to make it smooth. Not turn 4 x 90 degrees.

Member Avatar
+0 forum 7
Member Avatar

Is it posible to create IPAD or Android applications on my PC using VB.NET? If so, any good advice where to start my reading on the topic? If not, what language are best suited for the task?

Member Avatar
+0 forum 1
Member Avatar

Hi all I have "borrowed" a function from the net, and need som help in modifying it to do what I want. [CODE] Public Function CrossTab(ByVal dtS As DataTable, ByVal leftColumn As String, ByVal topField As String, ByVal dataValue As String, Optional ByVal pFix As String = "") As DataTable If dtS Is Nothing Then Return Nothing End If Dim dtOut As New DataTable Dim dtRowTitle As New DataTable Dim dtColHeader As New DataTable dtRowTitle = dtS.DefaultView.ToTable(True, dtS.Columns(leftColumn).ColumnName) dtColHeader = dtS.DefaultView.ToTable(True, dtS.Columns(topField).ColumnName) Dim dColx As New DataColumn dColx.ColumnName = leftColumn dColx.Caption = leftColumn dtOut.Columns.Add(dColx) For Each drow As DataRow In …

+0 forum 0
Member Avatar

First I tried getting a SQL query into an array, and then mail it. Made the data incomprehendable. So someone told me to use CSS to build a table format, filling it with the array. A LOT of hard work (since I had to learn css all the way from "what is a css". Then I was told "Array? why use array when DATATABLES are soooo much easier" So here we go again. "What is a datatable, and how does it work" Now finally nailed it and am ready to place my nice and sorted datatable into the body of …

Member Avatar
+0 forum 1
Member Avatar

Hi all. I have a problem that I haven't found a solution for on the web, so maybe anyone here can assist. Om our server at work we use excel, but it always starts in "Excel wasn't started correctly last session. Do you want to start in safe mode", wich messes up my scripted automated excel files, since they can't answer "no". Does anyone know how to disable this function? I have the ActiveX Safty Mode switched off. Excel is installed for several users.

Member Avatar
+0 forum 1
Member Avatar

I'm creating a small program to read from an SQL server, loading result into an array, pivoting the array to my liking and mailing it out to selected members of a group. It's going to be run once a day with Windows schedule. I have the connection, query and mail sorted, but not the datareader to array bit. Anyone know how it's done (line 26)? [CODE] Imports System.Data Imports System.Data.SqlClient Imports System.Net.Mail Module Module1 Sub Main() 'Connection to SQL Dim con As New SqlConnection con.ConnectionString = "Data Source=localhost\SQLEXPRESS;Initial Catalog=db;integrated security=SSIP;Persist Security Info=False;Trusted_Connection=Yes" con.Open() 'Query SQL Dim cmd As New SqlCommand("SELECT …

Member Avatar
+0 forum 1
Member Avatar

I've extracted some data from an SQL server, put it into an array, and want to mail it's content to a group of people. All quite easy, until it comes to presentation in the mail body. When I set it up manually in Excel and do Copy - Paste it looks readable. How do I create a 2D "worksheet" that I can put into the mail body so it looks ok? (I'm quite a n00b at this, so there are surely some premade functions for this, If so, just point me in the right direction)

Member Avatar
+0 forum 2
Member Avatar

Hi all. I am trying to create a search that displays 3 columns. Analysis, Amount, Amount of Positiv results I have nailed down Analysis, Amount, but have problems displaying Pos. result. [CODE] SELECT DISTINCT SP.ANALYSIS AS Analysis,COUNT(SP.ANALYSIS) AS Amount FROM SAMPLE S INNER JOIN SAMPLE_PARTS SP ON SP.SAMPLEID = S.SAMPLEID WHERE S.SAMPLE = '18000' GROUP BY SP.ANALYSIS [/CODE] This gives the folowing: Analysis | Amount One | 30 Two | 25 Three | 30 Lets say 10 of each has the value 'POS' in the the column SP.RESULT. How would I then get a 3.rd column in my result displaying …

Member Avatar
+0 forum 4
Member Avatar

I have the following connection string in a Excel VBA project: oCon.ConnectionString = "Driver={SQL Native Client};Server=SQL;Database=D1; Trusted_Connection=yes;" On my laptop this works perfectly. But when I try it out on another computer I get an error: I get this error when oCon.Open on debugging: Run-time error '-2147467259(80004005)': Automation error Unspecified error On first time run i get the error: Run-time error '-2147467259(80004005)': [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified What is wrong? (Posted it here since it is vb code)

Member Avatar
+0 forum 2
Member Avatar

I am having difficulty with a SQL query in my project. I have 3 tables. T1: - Date - ID - Location_ID T2: - Location - Location_ID T3: - ID - Result From this I need the T1.Date and T3.Result based on Location in T2. So my I need a query to compare a known location, get the Location_ID. Then Use that Location_ID to get the Date and ID. Use the ID to get the Result from T3. (Value is a variable with the known Location) This is what I have tried: [CODE] "SELECT T1.Date,T3.Result _ FROM T1,T2,T3 _ WHERE …

Member Avatar
+0 forum 6
Member Avatar

I'm creating a search function for my program, and need some help with SQL. Until now I have been using simple SQL query like [CODE] "SELECT post1 FROW table1 WHERE a=b" [/CODE] and put it into arrays. Then using that info to do another query, put it into arrays, and so on. I know there are ways to improve my SQL querys like this [CODE] "SELECT table1.post1, table2.post2 FROM table1, table2 WHERE a=b" [/CODE] (more or less) I want to query (using JOIN?) 3 tables, where some of the posts are only intermediate data to find posts in other tables. …

Member Avatar
+0 forum 1
Member Avatar

I'm using Visual Studios 2008 to write a small program that writes to a file. The program works fine until I run it on my server at work, where for some reason it adds a "next line" (like vbCrLf command) at the end of the second line in the .txt file. Looks like three squeres: "Location =□□□" A copy paste of the string from textfile is shown under: "Location = " Excerpt from program: [CODE] If saveFileDialog1.ShowDialog() = DialogResult.OK Then myStream = saveFileDialog1.OpenFile() If (myStream IsNot Nothing) Then Using sw As System.IO.StreamWriter = New System.IO.StreamWriter(myStream) For Lagre = 0 To …

Member Avatar
+0 forum 1
Member Avatar

I have a grid of RadioButtons, and need some help in Check / Uncheck acording to data collected from a .txt file. The .txt file contains a list like this: A01,a B01,b C01,c A02,a B02,b C02,c I have set up in a grid formation RadioButtons, and named them A01,B01,C01,A02,B02,C02. I have loaded the .txt file in an array, and want to use the first 3 letters in the array to point to the RadioButton. Problem: How do I get the string "A01" from the array to point to the RadioButton control?

Member Avatar
+0 forum 2
Member Avatar

I have loaded a .TXT file into an array, and want to display each of the posts in the array in a grid. Any pointers how to start attacking this beast? Have tried using Datagrid, and failed :( I have a "Learn by doing" approach to VB.NET, so I need a little help with the doing part :) Attachment shows my idea of how it should look: 13x9 grid setup.

Member Avatar
+0 forum 1
Member Avatar

I'm trying to bind an Array to a DataGrid using VB.NET (2008), and I get an error. Array was not one-dimentional array. Any pointers? [CODE] DataGridView1.DataSource = arrProv [/CODE] Size of array: arrProv(4,21)

Member Avatar
+0 forum 1
Member Avatar

I've managed to put together some code to retrieve data from a sql file. I plan to connect to a sql server that are operated by a database program, that update the registry every 10 sec. Before I try to connect my program to the sql database, I need to know if my program will prohibit other progrograms to read and write to the database. Anyone see any problems? My program: [CODE] Imports System.Data.SqlClient Public Class Form1 Dim SQLRead As SqlDataReader Dim connStr As String = "Server=.\SQLExpress;AttachDbFileName=C:\tmp\DB\MyDB.mdf;integrated security=true;database=MyDB" Dim sqlcon As New SqlConnection(connStr) Dim QueryString As String Private Sub Parts() …

Member Avatar
+0 forum 4

The End.