Auto Increment userdefined id
Hi can anyone give me an idea how to create an auto generated id like ED01,ED02 etc., so that when i am entering data the id should be automatically incremented ...
vb.net
How to insert macro into a excel file without using the excel com library
Is there any way to insert an existing macro into a existing excel file without using the excel library ? I need this to set the excel to print whole work book .I cannot use excel library because it will be done online in the server where installation of excel is not possible. I can however use the c#.net coding . I am using NPOI to gene...
converting the numerals as string
Can someone help mo on how to convert a number value to its string value (ie.,1198.00 should be interpreted as Thousand Hundred and ninety eight) ...
How to let the user cancel my AutoCAD command
Hi, I'm currently developing an AutoCAD 2008 Addin in Visual Basic (.Net 3.0, VisualStudio 2010). I'm able to define my own command and I want the user to be able to cancel my command by hitting the ESC key. In AutoCAD 2010 or higher there exists the HostApplicationServices.Current.UserBreak method. But not in ACAD 2008. Does anyo...
Problem right aligning statictextfield controls
So I am adding StaticTextField controls to a page. This is using ExtJS, but we use VB.NET methods to add ExtJS so we don't actually have to write it. I tried using .Style = "text-align:right" But that isn't working, in fact it isn't doing anything. Here is the whole code of one of the controls: With .AddColumns(2) Wi...
WPF fundamentals?
At the University we teach .NET (both VB and C#) using Windows Forms. We want to introduce the concept of Windows Presentation Foundation (WPF) to our advanced course. Which fundamentals of WPF does students need to learn in order to get the basic knowledge of WPF? The idea is for student to use WPF in at least one of six assignments, ...
StackOverflow in List(Of T)
I have a program that uses Lucene.net in ASP.NET (VB.NET), when you search a term, results are stored in the Lucene.net data structure "hits". I want to read out the hits into an data structure and work with them, after that I display them in a DataGrid. By searching a term with a lot of results, often (but not always) there is an erro...
How to force quotes in every field while saving an excel worksheet as a csv file?
Here is my situation. data = "" & data & "" xlsheet.Range(crange).Value = data xlfile.SaveAs(FileName:=finalfilename, FileFormat:=6) This code puts " around the data, puts the data in the range and saves the workbook(xlfile) with one worksheet(xlsheet) as a csv file. If I open the csv file in notepad I find these following 1.quotes ...
Problem persisting read/write collection at design-time in .Net Winforms.
I have a requirement to persist a collection at design-time: Public Class MyButton Inherits Button Private _MyCol As MyCol <Editor(GetType(MyColEditor), GetType(UITypeEditor))> _ Public Property MyCol() As MyCol Get Return _MyCol End Get Set(ByVal value As MyCol) _MyCol = ...
Weird occasional InvalidCastException in Excel interop
I am developing a fairly comprehensive Excel add-in, applying a lot of ops. Take a workbook, save under new name, apply actions (add names, change formulae, etc). Generally it works fine, but from time to time .Net throws an InvalidCastException on virtually any of my CTypes. When I acknowledge the error and run the code again (without ...
How do I add a record in my database when it is coming from a checklist box control from vb.net?
I'm having trouble on how to code this. First I need to assign a value for every item in the list (1 for the first item, 2 for the 2nd and so on). Does this control have a separate field for the value aside from text? Second, I need to insert this into my database(MSSQL 2008) in this format: insert into table values(ID,selectedvaluegoe...
Creating a comparable Dictionary Key
I want to use a Dictionary(Of Key, Value), and the Key is not a base type, but a class like: Public Class MyKey Sub New(ByVal packet As String, ByVal sent As Boolean) Me.packet = packet.ToUpper.Trim Me.sent = sent End Sub Private packet As String Private sent As Boolean End Class Now to have the Dicti...
Get the BindingSource position based on DataTable row
Hi. I have a datatable that contains the rows of a database table. This table has a primary key formed by 2 columns. The components are assigned this way: datatable -> bindingsource -> datagridview. What I want is to search a specific row (based on the primary key) to select it on the grid. I cant use the bindingsource.Find method becau...
Check for Multiple Instances of a Visual Basic Application
How can I check for multiple instances of my visual basic application? When the user runs the application, I want to know how many instances are already open. Thank you. ...
Removing duplicate items from a multicolumn listview
Question Answered Thank you Dan! Your code worked perfectly and you saved my life today! Many internets to you good sir. Original I was generously guided by the community to use LINQ to find duplicates on my listboxes the last time around. However, I am now in a tough spot because I need to find and remove duplicates from a multicolum...
How do I transfer the value of my datagridview row to a group of textbox and databound combo box?
I have a datagridview that contains only 1 row/11 columns every time. How can I transfer the values to a bunch of textboxes and to match the choice in a databound combo box? ...
Force an Integer To Be At Least 2 Digits Long
Can someone give me code to do the following.... if the integer is 1-9 display a string 01,02,03 etc.. if 10 or over leave it as is. string display = yourInt.ToString("00"); DOES NOT WORK ...
Convert anonymous type to strong type for grouping query?
I've pieced together some information from other posts but I'm stuck. The first part works fine. Basically I query the database using LINQ and then I loop through the results generating a report. Dim results As System.Linq.IQueryable(Of Bud900Reports.tblBud_CONNECT) If options.Type = reportType.Organization Then results = From...
Excel Saving to TXT file
I have this script that I'd like to in addition save as a xls file, also save as a .txt in the same directory, or even a different one. Can I get some guidance here? Imports System.IO Module Module1 Private Property fs As Object Private Property BaseName As Object Private Property FullTargetPath As Object Sub Main() Dim targ...
Randomize() in vb.net not randomizing properly
What is wrong with this code? It is called in groups of four, and always seems to wind up with only two combinations: Public Function GetRand() As String Randomize() Dim r As Integer = CInt(Rnd() * 3) Select Case r Case 0 Return str1 Case 1 Return str2 ...