Visual Basic

how can i populate combobox with a field of a table

28-Jan-07 12:01

Yes, it's DesignMode, from memory. It doesn't always work. The new designer sucks.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Re: Design Time Test?

Polymorpher28-Jan-07 12:09

Polymorpher

28-Jan-07 12:09

Perfect, thanks a lot Smile | :)

Pablo
while(1){DoTheDo();}

SMS via MAPI

Member 376993728-Jan-07 5:56

Member 3769937

28-Jan-07 5:56

I winder if there is a way to send SMS via MAPI
I need som hints and VB-code to a litle program I'm working on...

Totte

Member 370476628-Jan-07 3:47

Member 3704766

28-Jan-07 3:47

hi,

wat will be the code for populating the combobox. suppose Customername is a field of the Customer table, how can i populate the combobox with that field name? Pls help me to find out this problem.

SS

Re: how can i populate combobox with a field of a table

Christian Graus28-Jan-07 8:59

28-Jan-07 8:59

Set the datasource to be your datatable, then set the DisplayMember property to be 'Customername'

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

help...

carl_sti28-Jan-07 3:38

carl_sti

28-Jan-07 3:38

help please on how to process command line arguments that being pass to the application..

Re: help...

Christian Graus28-Jan-07 8:59

access password protected database connection string

28-Jan-07 8:59

They are generally passed as a string array to your program's entry point, although it wouldn't surprise me to find they are also a property of the Application object.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

pankajgarg1228-Jan-07 1:07

pankajgarg12

28-Jan-07 1:07

Sir/madam,
I am using access database.I have applied password to the database.Now , I wanted to make the connection string.Presently , i am using the .udl file to make the connection string and in the udl file , in the case of choosing the provider, i am using Microsoft Jet 4.0 OLE DB Provider.and after then i am comming to the connection tab.There i am facing the following error after typing the password and clicking the test connection button.

Test connection failed because of an error in initializing the provider.Cannot start ur application.The workgroup information file is mising or opened exclusively by another user.

But , I have closed the database and even i have restarted my machine.But i am encountering the same problem.
Please help in making the connection string when i have applied the password.
Thanks and Regards
Pankaj

Re: access password protected database connection string

Guffa28-Jan-07 1:25

Guffa

28-Jan-07 1:25

I didn't really read all of your post, it really get tiresome when you make every other word bold, but here is page where you can see examples of connection strings:

www.connectionstrings.com[^]

---
Year happy = new Year(2007);

Re: access password protected database connection string

jaakinye28-Jan-07 9:34

jaakinye

28-Jan-07 9:34

Try to create user's account with the password you are using for connection string

jaakinye

autogenerate column in datagridview in vb.net 2005

pankajgarg1228-Jan-07 0:40

pankajgarg12

28-Jan-07 0:40

Sir/Madam,
I have a table , having two fields , first for name and second for roll number.I don't have serial number field in that table.Can , I display Serial number field in the datagridview , with those two fields.
I mean if i have ten records in the table. Then datagrid should display record no for each row, like for first row it should display 1 , and for second row , there should display 2 and so on.This should happen in the extra column in the datagridview.Is it possible.
Please help.
Thanks and regards
Pankaj

Re: autogenerate column in datagridview in vb.net 2005

coolestCoder28-Jan-07 2:22

coolestCoder

28-Jan-07 2:22

Hi,
You can use sql query in this case. If your current sql query is -

select name,rollno from students

Then modify the query as -

select 0 as [Serial No.],name, rollno from students.

This modified query will generate a column named Serial No. whoes rows will be filled by 0. Then in the program use a counter to count the rows, in the RowDataBound event handler. Replace the text in column 0 with the counter value. You will get your desired resutls.

Hope i am clear enough.

I am assuming that you are using SQL Server as database.

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

crystal reports using vb.net 2005

pankajgarg1228-Jan-07 0:34

pankajgarg12

28-Jan-07 0:34

Sir/madam,
I am facing problem in the crystal reports.Now , Suppose I have 20 records into the database(each record contain one field for name).I am able to display them in the reports in the vertical order , to get the print outs .But the problem is , I am not able to display these 20 records in two column.Two columns means , First column has ten records and second column has 10 records.Actually , the purpose of using two columns is , I want to save the page . I want to put the names on the envelope , after getting the print out , I will cut those names from page and finally will be pasted on the envelope.Is there any option to do this task.Hope , I am trying to make u understand my problem.
Please help.
Thanks and regards
Pankaj

eventscheduler

Doritkatz27-Jan-07 23:56

Doritkatz

27-Jan-07 23:56

Hi
I need to conver c# project to vb.net
from
http://www.codeproject.com/csharp/eventscheduler.asp[^]
I did it for the class library (by using a translator )
now I need to implement the code and I can't do it

Schedule s = new IntervalSchedule("Test_Interval", DateTime.Now.AddMinutes(10), 45, TimeSpan.Zero, new TimeSpan(TimeSpan.TicksPerDay));<br />
			s.OnTrigger += new EventScheduler.Invoke(ScheduleCallBack);<br />
			Scheduler.AddSchedule(s);

I wrote

MessageBox.Show("Test will now create Interval schedule")<br />
           Dim s As New ES.IntervalSchedule("Test_Interval", DateTime.Now.AddMinutes(1), 45, TimeSpan.Zero, New TimeSpan(TimeSpan.TicksPerDay))<br />

and it's won't work with s.ontrigger.....

What can I do

How to display a grid on form in vb 2005

Mekong River27-Jan-07 23:54

Mekong River

27-Jan-07 23:54

Hi, in windows form designer in vs 2005 pro, how to display a grid (a small dot) on the form like vb.net 2003?

Registration Free COM with VS 2003

Atara27-Jan-07 23:34

27-Jan-07 23:34

I recently learned that on XP (and later) OS, you do not need to register activeX, if you use "isolated" option from vs 2005 menu to create a special manifest file.

Does anyone know how can I make the required manifest lines if I only have VS 2003 ?

Thanks,

Atara

Christian Graus28-Jan-07 0:24

28-Jan-07 0:24

VS2003 doesn't create manifest files. I also don't see how a COM dll can work without being registered, unless the manifest contains the GUIDs and so on, and everything has to be in the same directory.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Atara28-Jan-07 1:03

28-Jan-07 1:03

The manifest should contain clsid.

This technologie (COM dll can work without being registered) should work on XP sp2, and Vista. according to the documentation it should work on .Net 1.1

but I can not find the exact format of the needed manifest file Frown | :(

more about this "Reg Free COM" technologie in -
http://msdn.microsoft.com/msdnmag/issues/05/04/RegFreeCOM/[^]

Atara

Atara31-Jan-07 2:42

31-Jan-07 2:42

I solved it with the help of:

(1) Escape DLL Hell - Simplify App Deployment with ClickOnce and Registration-Free COM
(VS 2005 Article)
http://msdn.microsoft.com/msdnmag/issues/05/04/RegFreeCOM/

(2) Registration-Free Activation of COM Components: A Walkthrough
(VS 2003 Article)
http://msdn2.microsoft.com/en-us/library/ms973913.aspx

(3) oleView.exe
C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\oleView.exe (or . . . \Tools\Bin)
oleView.exe: File->View TypeLib

The solution:

1. The main manifest (myProg.exe.manifest):

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
<assemblyIdentity
type = "win32"
name = "myProg"
version = "1.0.0.0" />
<dependency>
<dependentAssembly>
<assemblyIdentity
type="win32"
name="myAxFile.X"
version="1.0.0.0" />
</dependentAssembly>
</dependency>
<dependency>... more files ...</dependency>
</assembly>

2. The myAxFileN manifest (myAxFileN.X.manifest):

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
<assemblyIdentity
type="win32"
name="myAxFileN.X"
version="1.0.0.0" />
<file name = "myAxFile.ocx">
<comClass
clsid="{...clsid...}"
threadingModel = "Apartment" />
<typelib tlbid="{...tlbid...}"
version="1.0" helpdir=""/>
</file>
<comInterfaceExternalProxyStub
name="myAxName"
iid="{...iid...}"
proxyStubClsid32="{00020424-0000-0000-C000-000000000046}"
baseInterface="{00000000-0000-0000-C000-000000000046}"
tlbid = "{...tlbid...}" />
</assembly>
The id are taken from oleView.exe: File->View TypeLib generated file.

I hope it will help you to start digging your specific needs.

Atara

Atara4-Feb-07 23:11

4-Feb-07 23:11

or, you can use only one manifest file, e.g:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0" >

<assemblyIdentity type="win32" name="myProg.exe" version="1.0.0.0" />

<file name="file1.ocx">
<typelib tlbid="{...}" version="1.0" helpdir="" />
<comClass clsid="{...}" tlbid="{...}" threadingModel="Apartment" />
</file>

<file name="file2.ocx">
...
</file>

</assembly>

Note: all *.ocx, *.dll files of the activeX should also be in the same folder, with the manifest and the exe files.

Atara

VBS File

Mohammad Daba'an27-Jan-07 20:30

Mohammad Daba'an

27-Jan-07 20:30

:->Hello all,

I want to make a vbs file that will take some data and then will redirect me to a nwe web page with the entered data as a query string,

is there any one can help me or have a ready done vbs file Blush | :O

Thanks alot
Hamody

Re: VBS File

Christian Graus27-Jan-07 20:41