Re: How to put a button inside a dataGridView textBox column? - Visual Basic Discussion Boards

Bulky Fellow13-Feb-08 1:06

13-Feb-08 1:06

I have a VB 6.0 exe. It reads data from an excel spreadsheet and writes to it as well. So, the excel spreasheet is like a database for it. Presently, the spreadsheet resides in a LAN.

Now I want to "INJECT" the excel spreadsheet into the executable, so that the excel spreadsheet is not a separate entity anymore, and is a part if the executable itself. Basically, how can I turn it into an intrinsic application resource?

Can someone please shed some light on how I can do this?

Thanks.

ASP - AJAX is SEXY. PERIOD.

Re: VB reads Excel

Dave Kreskowiak13-Feb-08 7:06

Dave Kreskowiak

13-Feb-08 7:06

The short answer is, you can't. An .EXE, when running, cannot be modified.

The entire idea, though noble, isn't practical. You should be seperating code from data, not integrating it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: VB reads Excel

Bulky Fellow13-Feb-08 18:26

Bulky Fellow

13-Feb-08 18:26

Thanks Dave. I understood that.

Actually, I intend to hide the excel spreadsheet from the user. And when I say hide, I don't mean just physically (as in changing the file attribute to hidden), but logically as well. I.e., the user should not be aware at all that there is an excel spreadsheet involved.

With that said, is there a way to covert the spreadsheet into a resoucre of some sort? Like a dll or something which will contain the spreadsheet.

Everytime the exe runs, the EXE will "upack" the spreadsheet from the resource and when done editing, it will "repack" it into the resource. Any clues regarding this mechanism?

Sorry for such vague statements, but I think I've captured the essence this time.

Thanks.

ASP - AJAX is SEXY. PERIOD.

Re: VB reads Excel

Dave Kreskowiak14-Feb-08 2:10

Dave Kreskowiak

14-Feb-08 2:10

Bulky Fellow wrote:
Everytime the exe runs, the EXE will "upack" the spreadsheet from the resource

Yeah, putting the sheet into a resource is no problem - at compile time.

Bulky Fellow wrote:
it will "repack" it into the resource.

Putting it back into the .EXE or .DLL at runtime is the problem. Using normal methods, once the .DLL is loaded, the file is locked until the termination of your app. Again, it can't be modified.

You MAY be able to gleen something useful from the app in this[^] article though. It copies resources between .EXE's and .DLL's, but there's a lot of hoops to jump through.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Webbrowser control need help

King of Kingz12-Feb-08 23:38

King of Kingz

12-Feb-08 23:38

Hi, i have developed net browser in vb.net, using webbrowser control. My problem is, when i click on go button for navigating the url, if there is no internet connection is available, or server is not reponding, the webbrowser will show the default page of Internet Explorer that is page not found. i want to use my own page instead of this default Internet Explorer page,how can i do this???
thx in advance....

King

Re: Webbrowser control need help

Paddy Boyd13-Feb-08 5:08

Paddy Boyd

13-Feb-08 5:08

You've developed a new browser using the supplied web browser control? Why?

How to put a button inside a dataGridView textBox column?

Benny_Lava12-Feb-08 21:50

Benny_Lava

12-Feb-08 21:50

Hi,

As the tile says. this column will be used to specify a file path, so the user will be given a choice to write manually a file path into the textbox column or click a button inside that column and a openFileDialog will appear...

This interface is used in SQL DBMS programs, when you are attaching a database, the same dataGrid is used to locate ldf and mdf files...

Thank you!

Re: How to put a button inside a dataGridView textBox column?

Dave Kreskowiak13-Feb-08 7:08

Dave Kreskowiak

13-Feb-08 7:08

You'll have to make you're own DataGridViewColumn for this. A full explanation of doing this is way too much for a couple of forum posts. There's simply too much detail to cover.

Search for articles on the subject of "Custom DataGridViewColumn". Results[^]

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

grid view in .net2.0

judyashma12-Feb-08 21:33

judyashma

12-Feb-08 21:33

how do u fill up columns and make changes in it using grid view?

Re: grid view in .net2.0

Mycroft Holmes13-Feb-08 16:33

Mycroft Holmes

13-Feb-08 16:33

to fill a datagrid you attach a datasource
Utilise the edit controls to make changes to the data in the grid

Do some research - the question indicates you have done no work towards getting this knowledge.

if i delete a record

sathyan_829412-Feb-08 21:09

sathyan_8294

12-Feb-08 21:09

hai,
i am using dotnet2005.i do my project in vb.net windows application.
if there are 4 rows,if i delete slno 2,the slno 3 will automatically changed as slno 2,then slno 4 will automatically changed as slno 3.
for ex,
there are 3 columns and 4 rows are displayed in datagridview from sqldatabase,
slno name city
1 guru cbe
2 ram salem
3 balu trichy
4 mahesh cbe
if i delete slno 2 means,the slno 3 will automatically changed as 2,then slno 4 will automatically changed as 3.
after i delete slno 2 means,i want to display in datagridview from sqldatabase like following,
slno name city
1 guru cbe
2 balu trichy
3 mahesh cbe
is it possible,if possible means how to do these.
or any other way to do these or any options in datagridview to generate slno with starting no 1 or using programmatically can to do these.
so any way i want to generate slno.i want in windows application.

Re: if i delete a record

Christian Graus13-Feb-08 9:51

Christian Graus

13-Feb-08 9:51

This is automatically what happens, unless the number you're showing is an id from the database. If this is so, it cannot be changed, not easily. Just show a number other than the Id, if you want to show a row number.

Christian Graus - Microsoft MVP - C++

"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 )

Re: if i delete a record

sathyan_829413-Feb-08 18:12

sathyan_8294

13-Feb-08 18:12

now i remove slno from database...i tried to genarate slno in datagridview...there is any option to generate slno in datagridview...or how to put row number....so i want to genarate slno or to put row number...

Open applicaiton

Kumaran21cen12-Feb-08 19:57

Kumaran21cen

12-Feb-08 19:57

Hi All,

Iam using ShellExecute API function to execute the file.
File may be any type.
I want to get the Process ID(PID) of the particular file which i executed.
I already tried Shell command, but it isn't work.

Thanks & Regards
Kumaran

Re: Open applicaiton

Christian Graus12-Feb-08 20:15

Christian Graus

12-Feb-08 20:15

Process.Start will return the handle. Assuming this is VB.NET.

Re: Open applicaiton

Kumaran21cen12-Feb-08 20:30

Kumaran21cen

12-Feb-08 20:30

Thanks Christian Graus.
but i need in vb6

Thanks & Regards
Kumaran

listbox in vb.net

Anusubha.V.G12-Feb-08 18:28

Anusubha.V.G

12-Feb-08 18:28

I need to add the item and value in the list box. I add this using strtext and strvalue respectively.

But the strvalue i need to add is a string. so that the value when adding cannot get duplicated.

How can i add string value to strvalue

I am taking this values from two textboxes

My coding is as follows....

Dim i As Integer
Dim item As New Item

For i = 0 To ListBox1.Items.Count - 1
item = ListBox1.Items(i)

If TextBox1.Text = item.strValue Then
MsgBox("Already you have added this link", MsgBoxStyle.Information, "Knowledge Base")
Exit Sub
End If
Next

item.strText = Textbox2.Text
item.strValue = TextBox1.Text
lstLinks.Items.Add(item)

txtWebLinkDescriptions.Text = ""
txtWebLinks.Text = ""

It shows that the string value cannot be bind to integer value....

May u help me to solve these please....

Thanks in advanvce........

Re: listbox in vb.net

Nanda160512-Feb-08 18:44

Nanda1605

12-Feb-08 18:44

Hi,
I think this code will help you...

Dim i As Integer<br />
<br />
For i = 0 To ListBox1.Items.Count - 1<br />
<br />
If ListBox1.Items(I).Tostring = TextBox1.Text Then<br />
        MsgBox("Already you have added this link", MsgBoxStyle.Information, "Knowledge Base")<br />
Exit Sub<br />
End If<br />
Next<br />
<br />
lstLinks.Items.Add(TextBox1.Text)

Thanks,
Nanda

Re: listbox in vb.net

Anusubha.V.G12-Feb-08 22:34

Anusubha.V.G

12-Feb-08 22:34

Thank u for ur response Nanda

But, my question is how to get the value of the item in case of string

ie, since because the value i use here is a string, it displays error
as "Conversion from string to type integer is not valid"

will u please tell me how to get the string value for the item
ie, i need to use string value for item.strvalue

Thank u once again

Re: listbox in vb.net

Christian Graus12-Feb-08 18:50

Christian Graus

12-Feb-08 18:50

The easy way is to build a dictionary where the key is the strValue, or just a list of strings, even. Do a search, if the value is in there, then it's been added already.

The type initializer threw an exception.

Nanda160512-Feb-08 18:08

Nanda1605

12-Feb-08 18:08

Hi,

I am getting the 'Type initializer error' in module1 (for eg see the below code). The thing is i want to get the value from the dll which is added as a reference to this exe, where the value is declared in the module. Please Review the below code and suggest/help me.

Project1.dll

Module Module1<br />
	Public MyPath As String = "C:\Nanda"<br />
End Module

Public Class Class1<br />
<br />
	Public Sub Query()<br />
		MsgBox(MyPath, MsgBoxStyle.Information, "Project1")<br />
	End Sub<br />
<br />
End Class

Project2.exe

Public Class Form1<br />
<br />
Public MyReport As New Project1.Class1<br />
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
	MyReport.Query()<br />
End Sub<br />
End Class

Thanks,
Nanda

Re: The type initializer threw an exception.

User 27100913-Feb-08 7:26

User 271009

13-Feb-08 7:26

Nanda1605 wrote:
MsgBox(MyPath, MsgBoxStyle.Information, "Project1")

Try this:

MsgBox(Module1.MyPath, MsgBoxStyle.Information, "Project1")

Cheers, Karl

My Blog | Mole's Home Page | How To Create Screen Capture Videos For Your Articles

Just a grain of sand on the worlds beaches.

modified 27-Feb-21 21:01pm.

Generating Of Excel Reports - Problem

HatakeKaKaShi12-Feb-08 17:53

HatakeKaKaShi

12-Feb-08 17:53

Hi guys

My problem is this . I need to generate a large number of records from SQL server 2000 to and excel spreadsheet. However the durations of time id too long. For about 900 records there's about 40 min.
Any idea or guide to boast up the speed?

i am generating to excel .xls
Basically i have a main details table link to many sub details Table

Then first i select all the main info id and use the for loop to loop through all the sub details table whether the id is match. then insert into the excel spreadsheet. The method i use is Create the XLS file then connect to it and do insert statement to input data. This method work but when inserting 900 records it took about 30 mins or more....

Any suggetion or solution please guide.... Need help man

Thanks a million guys need it urgently

KaKaShi HaTaKe

KaKaShi HaTaKe

Re: Generating Of Excel Reports - Problem

Mycroft Holmes12-Feb-08 20:59

Mycroft Holmes

12-Feb-08 20:59

Unless you REALLY need to create an actual .XLS file I would recommend creating a .csv file and letting excel convert it when it is opened. This eliminates all the VBA stuff and you should be able to do 900 rows in under 1 sec.

There are plenty of article/examples on CP

Re: Generating Of Excel Reports - Problem

HatakeKaKaShi12-Feb-08 21:16

HatakeKaKaShi

12-Feb-08 21:16

What's a CP?

KaKaShi HaTaKe

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.