Re: Not sure how to phrase this.... - Visual Basic Discussion Boards

If i didn't know how to phrase it for a forum, how would i know how to phrase it for a search engine? Useful keywords would have helped more than a post on how to use Google.

I'm sorry. I'm sorry you're so stupid. The link to google is, in fact, my sig block. My answer was actually one word. Reflection. Google reflection and you'll drown in examples on how to do what you want.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

svanwass wrote:
If i didn't know how to phrase it for a forum, how would i know how to phrase it for a search engine?

Chill, dude. When in doubt, explain what you're actually trying to do - not how you think you're gonna do it. And ask follow-up questions.

Citizen 20.1.01
'The question is,' said Humpty Dumpty, 'which is to be master - that's all.'

My apologies Christian. I misread your answer.

You could try:

with directcast(me.controls(StringName),textbox)
.Text="Blah"
end with

Although you will have to be sure that the control exists, or you will get an exception.

The solution has already been suggested, but whenever you need reflection to do something, you are either doing something quite advanced, or you are doing something backwards...

Why is it that you have a name of a textbox, instead of a reference to it? What is it that you are trying to accomplish really?

Despite everything, the person most likely to be fooling you next is yourself.

My program connects to a database which populates a bunch of text boxes. I then unlock them and allow the user to edit the contents. A write button is pressed and the contents of the current text boxes are stored in an array and compared to the original database read (stored in a different array) to determine what has been changed. The position at which a change is found is store in another array. These positions correlates to another array that stores the names of the text boxes.

The step i am missing is to take that stored text box name and get the real text boxes text.

...so that you can then store the changed values in the database?

But don't you already have the values? Isn't the position of a changed text item also the index of the array that you first used, when the user clicks the Write button, to store what was in the text boxes? Why read from the text boxes when you can read from your array's copy of the text boxes?

Hi All!

I've been through literally hundreds of syntax highlighting code editor controls and
not one free control has been able to provide fast, flicker-free and clear HTML syntax highlighting
for my application. Sigh | :sigh:

All I Want is a HTML Syntax highlighter written in VB, and (I Think) Shouldn't HTML Be one of the
easiest languages to highlight? Everything that needs highlighting is enclosed by tags, so it makes no sense that i have a perfectly good javascript syntax highlighter but can't find
one Fast HTML Syntax highlighter.

Does anyone know of a fast, flicker-free HTML Syntax highlighing control with support for
comments and (If possible) Strings(Quotations) and tag attributes?

Thanks Smile | :)

MrWolfy

Hi again,

I did a general-purpose text editor with full syntax coloring for several languages.
The key to get it both fast and flicker free, is NOT to rely on complex Controls, such
as RTB; instead use a simple Panel and draw the text yourself, in an OnPaint method.

Hint: the only thing that needs to be drawn are the few dozen lines that are actually visible
at any one time.

An RTB (and any other standard Control) is a terrible device for handling large amounts
of data; an RTN especially so since it maintains the concatenation of all text lines.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

hi good day to all!

Can someone help me share some code in vb6 with regards to printer character code such as print#, chr(27) & "@" to initialize the printer. When done printing i tried chr(12) and still the passbook printer status after feed off paper, any character code use to deselect or off the printer?

Thanks!

Hi All

I'm trying to do a mailmerge from a VB.NET winform program into an MS Word Document but I am getting tied up in knots right at the start.

Visual Studio 2005
I have added the MS Office Word reference to the Solution

Imports Microsoft.Office.Interop.Word

Form_Open
Dim oWordApp As New Microsoft.Office.Interop.Word.Application
oWordApp.Visible = true

the oWordApp is underlined as a error of "Declaration Expected"

All help & Pointers Gratefully received

can anyone tell me if there is a dll in vb.net which has the implementation of all the functions used in ms excel.
I want to use these functions in my application

thanks in advance...
Smile | :)

Not unless you count Excel. You can control Excel using the Microsoft tools for office, but your users will need Excel installed.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I want to use these functions in datagrid.

Well, that's just too bad. Really, you can't. Why would someone write a free dll that turns a datagrid into Excel ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I'm fairly new to VB.NET, (I was previously an ASP.NET develeper) and I have what a fairly trivial problem.

I am developing a system for a client where the application gets data from a SQL Server database. I have the connection string to the database stored in the app.config file. But the problem lies in that I am using a different database when developing than that which will be used on the live system. So it means that each time I build the project to test on their machines, I have to remember to change the connection string settings before I do so (and in fact, there are other settings like file paths which need changing to).

Like I said, a failry trivial isssue but if you guys have any suggestions on other ways to go about this then it would be appreciated.

Thanks.

I'd deploy a different app.config, or perhaps write code so that the debug version of your code reads one setting and the release, reads another. You do this with

#ifdef DEBUG

#else

#endif

in C#, I am not sure if VB is capable of that tho.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Couple of solutions:

1. Use two different connections settings, ex: devConnectionString and ProdConnectionString

2. Make a form that allows user to input settings such as db server name etc and save those settings.

You can consider something like this (change DEV_COMPUTER and TEST_COMPUTER to match the names of your computers):

<appSettings>
  <add key="ConnectionString_DEV_COMPUTER" value="..." />
  <add key="ConnectionString_TEST_COMPUTER" value="..." />
</appSettings>


ConfigurationManager.AppSettings("ConnectionString_" + Environment.MachineName).ToString

We allow the user to select the target server from a list when they logon. This then supports Dev/UAT/Production. Some of our apps will also have multiple scenario copies the user may need to use.

Never underestimate the power of human stupidity
RAH

Good Morning All,

I have a question that I'm hoping someone out there maybe able to help me with. I'm trying to bind a CheckListBox to an Excel spreadsheet that has two columns of data. IPAddress & SystemName. I am new to programming and have only been able to get this fare. If anyone could help, you have my sincere thanks.

Tazy

Private m_sConn2 As String = "Provider=Microsoft.Jet.OLEDB.4.0;data source='C:\IPMonitoringTable.xls';Extended Properties=Excel 8.0"

Public Sub Retrieve_Records()

Dim conn As New OleDbConnection(m_sConn2)
Dim ExcelData As String
Dim i As Integer

conn.Open()

Dim da As New OleDbDataAdapter("Select IPAddress, SystemName, SysDate, SysTime, UserID from [IpAddrMonitor$]", conn)
Dim ds As DataSet = New DataSet

Try

da.Fill(ds)
CheckedListBox1.DataSource = ds
CheckedListBox1.DisplayMember = ds.Tables(0).TableName

'MsgBox(CheckedListBox1.Items(0).ToString) 'This didn't work
'MsgBox(CheckedListBox1.Items.Item(i).ToString()) 'Nor This

Me.Refresh()

Catch OleDbExceptionErr As OleDbException
MsgBox(OleDbExceptionErr.Message)
End Try

conn.Close()

Tazy wrote:
I am new to programming

Then why are you working on something this complex ? No-one is paying for your 'new to programming' code, are they ? If so, shame on you. If you're learning, choose something simpler to start with. You're just guessing here, and you'd do better to take a methodical approach to learning.

Tazy wrote:
'MsgBox(CheckedListBox1.Items(0).ToString) 'This didn't work
'MsgBox(CheckedListBox1.Items.Item(i).ToString()) 'Nor This

Well, a MsgBox is the wrong approach to take with ASP.NET anyhow, that will kill your server in a hurry. However, I assume this is debug code. Try instead to set a breakpoint. You'll find that the item is actually a DataRow, so you need to do Items(0)("SystemName"), or whatever.

In futurem don't say 'this didn't work', say 'this threw this excpetion', or 'this gave me a different result to what i hoped for, as follows... ', or 'this gave me the following compiler error.

And, for the love of all that is holy, buy a book and refer to it before asking questions. That's another step towards learning, towards actually becoming a programmer. People who take those sort of steps, are the sort of people we most like to help, because it doesn't feel like smashing your head against a wall.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

No I'm new on the job and just grad. from school and this is part of a project my boss has asked me to take over. I thought this would be easier then this and would make me look good, but school has prepared me enough for this type of project. But I also don't like to give up, so I keep trying. I don't want him to think that he hired the wrong person for the job.

OK - well, like I said, when you get an item from the items collection, it's a datarow, so you need to look up the data in the column you want to view from there. That's what the control does with the displaymember property.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )