Visual Basic

Re: Where is my mistake in SQL

25-Dec-10 8:14

ivo75 wrote:
this is my code

Please don't use spaces in your fieldnames. You might find it more readable, but the computer will be reading it more often than you will. Once the spaces are gone, you can drop the brackets around those names, which could simplify the statement a lot;

SQL

    SELECT Students.FirstName
         , Students.SecondName
         , Students.ThirdName
         , Students.Identification -- You're not saying "ThirdNameText", so why repeat that it's a number?
         , StudentClass.Class
      FROM Students
INNER JOIN StudentClass ON Students.Identification = StudentClass.Identification 
     WHERE StudentClass.Class>=100 
       AND StudentClass.Class<=1209
       AND StudentClass.Position=1
     ORDER BY Students.FistName

ivo75 wrote:
but give me this error "IErrorInfo.GetDescription failed with E_FAIL(0x80004005)"

According to Google, this could be caused by having a reserved keyword as a fieldname. You'll need a new naming-convention Smile | :)

I are Troll Suspicious | :suss:

Dave Kreskowiak25-Dec-10 18:55

Custom icon on an executable compiled with VBCodeProvider? [Solved]

25-Dec-10 18:55

Next time you've got a SQL problem, ask in the General Database forum. This has nothing to do with VB.NET.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Saul Johnson22-Dec-10 5:54

Saul Johnson

22-Dec-10 5:54

Hello Everybody!

I've been puzzling all day over how I would go about giving a custom application icon to a VB.NET executable compiled from VB.NET 2010 code using the VBCodeProvider class.

My application compiles VB.NET source code into a .NET executable like this:

Dim MyCodeProvider As New VBCodeProvider
Dim MyCompilerOptions As New CompilerParameters
MyCompilerOptions.GenerateExecutable = True

MyCodeProvider.CompileAssemblyFromSource(MyCompilerOptions, MySourceCode)

That's working great, but I can't find a way to assign custom application icons to the generated executables. I've tried using a ResourceWriter to create a resources file with the icon in it and embedding that in the executable like so:

Dim MyResourceWriter As New ResourceWriter("C:\AppResources.resources")
MyResourceWriter.AddResource("APPICON", New Drawing.Icon("C:\AppIcon.ico"))
MyResourceWriter.Generate()
MyResourceWriter.Close()

MyCompilerOptions.EmbeddedResources.Add("C:\AppResources.resources")

However, though the generated executable increases in size (which leads me to think that the icon data is in there somewhere), the icon still doesn't show up as the application icon in Windows Explorer.

I'm a real novice at using resource files, and I just can't get it to work. Can anybody see what I'm doing wrong?

Thanks in advance!

MrWolfy Big Grin | :-D

modified on Saturday, December 25, 2010 5:30 PM

Re: Custom icon on an executable compiled with VBCodeProvider?

Eddy Vluggen25-Dec-10 8:04

Re: Custom icon on an executable compiled with VBCodeProvider?

25-Dec-10 8:04

Found an answer on StackOverflow[^] that might help Smile | :)

I are Troll Suspicious | :suss:

Saul Johnson25-Dec-10 11:32

Saul Johnson

25-Dec-10 11:32

Hi!

Perfect! Absolutely exactly what I was looking for, thank you very much indeed for the link!

Thanks Again!

MrWolfy Big Grin | :-D

Re: Custom icon on an executable compiled with VBCodeProvider?

Eddy Vluggen25-Dec-10 12:18

25-Dec-10 12:18

You're welcome Smile | :)

Word 2007 open xml

B Mac Gregor22-Dec-10 3:35

B Mac Gregor

22-Dec-10 3:35

Hi I have a VB6 system that updates Word 2000 documents held in RTF format with case specific information at points indicated in the document such as [0123] meaning replace these 6 characters with the 123rd element of case specific information. I am now in the process of upgrading this to Word 2007 and Open XML. The reason for moving to open XML is that it seems that Microsoft will not be continuing its support of RTF.
My problems are as follows:
1. When I insert case specific information I need to make it a specific colour. This works okay with Word 2000 and RTF because I just surround it with {\cf5 and }. What do I do with Open XML?
2. I have specific inserts for Returns, Tabs, Centres, Italics and Bold that in Word 2000 and RTF can be achieved by \par, \tab, {\qc, {\i and {\b with those starting with { being ended with }. What do I do in Word 2007 and Open XML?
3. I need to find the MS section breaks which are \sect in Word 2000 and RTF. What are they in Word 2007 and Open XML?
Any assistance will be greatly appreciated.
Regards
Mac

Re: Word 2007 open xml

Eddy Vluggen25-Dec-10 8:02

DataGridView's Cell as Multiline Vb.Net 2008

25-Dec-10 8:02

B Mac Gregor wrote:
Any assistance will be greatly appreciated.

It won't be as simple as asking "what tag is replacing this one". RTF is a single file, OpenXML is a bundle of files.

You could download the SDK[^] and work through the examples Smile | :)

I are Troll Suspicious | :suss:

Paramu197322-Dec-10 0:55

Paramu1973

22-Dec-10 0:55

Hi
I want to enable the DataGridView's particular cell as multiline...
and accordingly the rows width has to increase automatically...

Does anybody have idea about it?

Thanks For The Ideas...

My Codings:-
------------
Dim MyDtb1 As New DataTable,NRow as DataRow
MyDtb1.Columns.Add("one", Type.GetType("System.String"))
MyDtb1.Columns.Add("two", Type.GetType("System.String"))
MyDtb1.Columns.Add("three", Type.GetType("System.String"))

For p As Integer = 0 To 20
Drow = MyDtb1.NewRow
MyDtb1.Rows.Add(Drow)
Next

DataGridView1.DataSource = MyDtb1

Suppose particular cell, my user need to entry multiple lines..
I don't know which event can do...and where to include...
my expectation is like....

If DataGridView1.CurrentCell.RowIndex = 12 And DataGridView1.CurrentCell.ColumnIndex = 1 Then
??????????????
????????

End If

Thanks

Re: DataGridView's Cell as Multiline Vb.Net 2008

dan!sh 22-Dec-10 3:12

dan!sh

22-Dec-10 3:12

You can do this by setting dataGridView1.Rows[rowIndex].Cells[colIndex].Style.WrapMode to true.

Finally is not executed always. As told by Sir Pete and PiebaldConsult. Go figure.

Re: DataGridView's Cell as Multiline Vb.Net 2008

Paramu197322-Dec-10 20:15

Paramu1973

22-Dec-10 20:15

Thanks D@NISH

Getting filename of current window/application [SOLVED]

Yance Lawang21-Dec-10 23:32

Yance Lawang

21-Dec-10 23:32

Hi...any one can help me how to get the filename of current window/application using vb 6?

modified on Tuesday, December 28, 2010 5:50 AM

Eddy Vluggen22-Dec-10 0:37

22-Dec-10 0:37

The current application can be retrieved using App.Path and App.ExeName properties. Forms are a different story, an example of looping through the available windows is available here[^].

I are Troll Suspicious | :suss:

Dave Kreskowiak22-Dec-10 2:17

22-Dec-10 2:17

Eddie is taking an educated guess at what you want.

You're going to have to explain further what you're trying to do. What do you mean by "current application"? Are you talking about your application that is running? Are you talking about the application window (doesn't matter what application) that has the focus?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Yance Lawang22-Dec-10 3:59

Yance Lawang

22-Dec-10 3:59

Thank you. Yes, i talk about the application window that has focus, not just my application. I can get the caption of any window that has focus, but i don't know how to get the filename.

Dave Kreskowiak22-Dec-10 7:50

22-Dec-10 7:50

Unless you are REALLY familiar with Win32 and how process, modules, handles, ... work, you're going to find this very difficult to do. There are no built-in functions in VB6 that will do this for you and WMI will not help either.

Basically, once you get the window handle, you'd have to get the ThreadId that owns the window handle using the Win32 function GetWindowThreadProcessId. Once you've got the ProcessId, you can use it to get the process information. You can get the steps and functions required from this article[^], but all the code is in C++. You'll have to Google around for any examples of the functions use in VB6. I don't have any examples since I dropped all VB6 use almost 10 years ago.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Yance Lawang23-Dec-10 3:05

Yance Lawang

23-Dec-10 3:05

Finally, i have get the code. I combine the GetWindowThreadProcessId and GetForegroundWindow of Win32 function. Thank you very much!

Check Box Problem

Leinad_3021-Dec-10 12:11

Leinad_30

21-Dec-10 12:11

Please some help me updating check box in SQLStmt . beep me back in mail (villanuevaleinad@yahoo.com).. thanks

Re: Check Box Problem

Luc Pattyn21-Dec-10 12:25

Luc Pattyn

21-Dec-10 12:25

That is not how this site works. I suggest you read the "how to get an answer" message on this page, then abide by it; people here will gladly answer a properly asked question or two.

And I suggest you don't post e-mail addresses; you may get unwanted guests.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

Re: Check Box Problem

Dr.Walt Fair, PE21-Dec-10 15:56

Dr.Walt Fair, PE

21-Dec-10 15:56

Beep, beep.

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

Re: Check Box Problem

Dave Kreskowiak21-Dec-10 18:18

Insert data to database tables [modified]

21-Dec-10 18:18

Consider revising your question to make some sense. An SQL statement cannot modify the state of a checkbox.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

ivo7521-Dec-10 8:21

ivo75

21-Dec-10 8:21

How to insert data from table1 in database Data1 to table2 in database Data2 and database Data2 is with password. Database is MS Access 2003. I use this
SQuery = "INSERT INTO uchenici (egn, name1, name2, name3, klas) SELECT Students.[ID number], Students.[Name 1], Students.[Name 2], Students.[Name 3], StudentClass.Class FROM Students INNER JOIN StudentClass ON Students.[ID number] = StudentClass.[ID number] WHERE(((StudentClass.Class) >= 100 And (StudentClass.Class) <= 1205)) ORDER BY Students.[Name 1]"

but 2 tables isn't in same datrabase

modified on Tuesday, December 21, 2010 2:37 PM

Re: Insert data to database tables

phil.o21-Dec-10 9:03

phil.o

21-Dec-10 9:03

Hi,

As far as I know, one single query can only be ran against one single database (I may be wrong, but I never encountered such queries that can access more than one database at the same time).

So you have to process it in two stages :

1- Run the query on the first database to grab the data you need
2- Run another query on the second database, using the previous stage's results (make use of parameters)

(and, please, take the time to format the code when you post Wink | ;)

)

Re: Insert data to database tables

Eddy Vluggen21-Dec-10 9:22