Search:

Sorry, it's just a words,
not a good terminology
as I tell that for myself :)

I know but using this trick allow you silent object releasing,
have you tried it?

I would use like this (see underline symbol,
coz it used _WorkBook Interface)

((excel._Workbook) wb).SaveAs(xlfilename);
wb.Close();
then just use Marshal.FinalReleaseComObject with no problem...

Not sure about how it works, coz I can't rich at VStudio on my machine,
this code is from my working library though:


Imports System.Globalization
Imports System.Runtime.InteropServices...

I use something like this

dataGridView1.Columns.Clear()
dataGridView1.DataSource=frmOrderNumbers.OrderNumDataSet.Tables(0)

Try again

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim txtArr() As String = Me.TextBox2.Lines ''<-- change on your...

Do you have a multiline text in the textbox?
Seems in your first post there are two lines of text, isn't it?

Sorry was mixing with C#, try instead, tested:


Dim txt As String = "ThelmaMl575|FREIGHTSCLIF|172.234.155.255:62063:world:RLNngChRYc||ThelmaMl575||" & _...

Try this out:

dim myarray() as string=txtMyTextbox.text.split(new char(){'|'},stringSplitOptons.removeemptyentries)
Not tested

Glad to help
Happy computing :)

Try this one

public partial class Form1 : Form
{

internal DataSet ds;

public Form1()
{
InitializeComponent();

Here ya go:
Form1.cs

public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

I use this one often:
http://converter.telerik.com/

Have you looked at this article:
http://devcity.net/Articles/94/1/multipleforms.aspx

Something like this ?

Dim arr() As String = { _
":Gemster!Gemster@Head.Coder.Of.Raven.Script PRIVMSG ### :hello", _
":Gemster!Gemster@Head.Coder.Of.Raven.Script PRIVMSG ### :this is...

Perhaps use paging:
http://msdn.microsoft.com/en-us/library/ms979197.aspx
or create query to select just N records using "SELECT TOP N From....Where myDate Between..." etc..

Perhaps problem with your XML file
at the quick glance your code is working
Anyway give this a shot:

private void ImportDataFromXml(string fileName, DataGridView dgview)
{
try
{
...

You might want to use regular expression methods
here is quick and dirty example but it should work

Dim txt As String = TextBox1.Text
If Regex.IsMatch(txt, ": char") Then
...

Try to adopt to your suit:

Private Sub WriteCSV(ByVal fname As String, ByVal records As List(Of String()), ByVal delimiter As String)
Dim fs As New FileStream(fname,...

Try this out (not tested at all,sorry)
Just from the top of my head...

Public Sub CopyRange()
Dim xlRange As Range
Set xlRange = Application.InputBox("Select cells: ", , , , , , , 8)...

If you use strongly typed dataset so try this

private void saveAll()
{
// check changes on client side
if (dt.GetChanges() == null)//<-- dt is datatable...

You could do it without extrafluous moves straightforward:

TextBox1.Text = TextBox1.Text.Replace(","c, "."c)
but better yet to use your own autocomplete usercontrol textbox
wich one is supports...

You're welcome
Cheers :)

Sorry for my bad explanation
I mean you wanted be to use in csv file another separator, e.g, tab separated:

For Each line As String In records
''i've used comma here
...

You do use Lines property of textbox to retrieve
all text lines, then use Split function to convert
delimited string to an array,then build strings, delimited with
separator you'll use in csv file...

You might be want to look at this page
http://msdn.microsoft.com/en-us/library/system.diagnostics.stopwatch.aspx#Y2090

Oops, agreed
Thanks

Your error message is exactly means that you're exceed
a size of array, you do need to use an Array.Resize method
to growth it up, or better yet to use List (Of String) instead
and then populate...

Just a thoughts, let's make it friend
I'm doing this always with no problems
But I'm not sure about that it's a best solution

You could be use native Excel methods as well, e.g

'Require Reference to Microsoft Excel XX.X ObjectLibrary

Imports System.IO
Imports Microsoft.Office.Interop.Excel
Imports...

Think your friend have a got a floor plans which was drawn
in AutoCAD or ArchiCAD
If so you better go to www.theswamp.org and ask in there about
this task on .ARX or .NET section

I think you need to do it in two steps, perhaps, i.e.

Dim conn As OleDbConnection
Dim connnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyDir;Extended...

You might be want to to call the methods of this class in Form code module something like
SysFunctions.CreateGridColumns(etc..) but you have to check before that both classes have
the same...

Your code is working for me
Seems the problem is on your 'CreateGridColumns' void,
but I'm not sure about

public partial class Form1 : Form
{
public Form1()
{
...

Hi,
Try something along this way
you have to use your Regex pattern instead:

Private Sub btnFind_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFind.Click
...

I wrote a quick & dummy example,
see if this helps:

Imports Microsoft.Office.Interop.Excel
Imports Excel = Microsoft.Office.Interop.Excel
'' ETC......

You can try to set ScreenUpdating to false before

You're welcome

Thanks, Kevin :)
You saved my nap time,
I'll go away till tomorrow :)

Hi Neil,
one more shot in the dark,
create empty xml file in UTF-8 encoding and try again