Re: Database Management in VB.net - Visual Basic Discussion Boards

how to deploy msde and vb.net application on client side pc through .net setup

There are lots of articles around the 'Net that describe this. You can search CodepOroject Articles for "bootstrap" and find a few projects that deal with this. You can also try searching GotDotNet.com for the same thing.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

I have Prepared DATA.XML using Dataset. This data set Contain All the Tables Data of my database. This xml is Too bulky like 100 MB. I will transfer this XML at Different Place.

Now my Problem is When I am Trying to Load this XML in Dataset Again It Take too much Time and it does my CPU 100% utilization and it take all memory.
how can i handle with this problem.

one other thing that Can i Load XML node by Node not whole xml in VB.Net.

Atul Patel
Aftek infosys Ltd.
Pune,India.

The problem your having is your using XML as a large database, which it is extremely poor at. Your data really belongs in an actual database, like SQL Server, and not a very large text file.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

SCENARIO (New project started using ASP.net 2.0):

At this point, I am simply trying to open a connection to a datastore.

Application settings: <default web="" site="">\AAC

Physical path of database file:
C:\Inetpub\wwwroot\www\AAC\data\dbStore.mdb

Script running from file in /gallery directory
C:\Inetpub\wwwroot\www\AAC\gallery\aStore.aspx

...
Dim mPath As String = Server.MapPath("\data\dbStore.mdb")
...

returns error:
'C:\Inetpub\wwwroot\data\dbStore.mdb' is a physical path, but a virtual path was expected.

What am I doing wrong? Am I missing some configuration in the web.config file?
I never had that sort of problem with ASP.net 1.1

Any help appreciated,
pyb

Your question really belongs in the ASP.NET Forum, regardless of the language it's written in.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

I'm kinda new to using VB.net i use to use an older version of Visual Basic and I'm kinda learning things all over again. I am trying to put together something that will be able to add to and search a database. I admit i haven't done many things with databases i know how to create them and to add to them in Access but that's about it. The database I want to search is in the Microsoft Access format. I have tried reading books for VB.net but to no avail. Hoping someone on here would be able to point me in the right direction to getting what i want done.

Fibman

Hello Fibman,

I had the same problem and after alot of searching i was able to find a solution. I am attaching a sample of a code that will search a database made with Access.

You will need a OleDbConnection, OleDbCommand and a OleDbDataReader reference. You can find them under the Data Toolbox.
There is a listBox control that is called List1. This list will be populated with the result of the SQL querry.
''==========================================================================
Imports System 'imports neccessay namespaces
Imports System.Data
Imports System.Data.OleDb

Dim te As String 'the string to be used to search the DB
'create the connection string. I have already entered the string to the OleDbConnection1 control. You can connect to the database you want be clicking the ConnectionString on the properties.

Dim strConnection As String = OleDbConnection1.ConnectionString

'Otherwise something like that is needed:
'Dim strConnection As String ="Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=0;Data Source="c:\Directory of the database\db1.mdb";Mode=Share Deny None;Jet OLEDB:Engine Type=4;Provider="Microsoft.Jet.OLEDB.4.0";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"

Dim connect As New OleDbConnection(strConnection) 'create the connection
Dim SQLString As String 'the sql string to use
connect.Open() 'open the connection to the DB
te = txtAreaToSearch.Text 'string to search for.

SQLString = "SELECT * from informations WHERE Area =" & "'" & te & "'"
'information is the table in Access and Area is one of the fields of this table

Dim cmd As New OleDbCommand(SQLString, connect) 'run the SQL command
Dim reader As OleDbDataReader = cmd.ExecuteReader() 'the reader that will return the results

While reader.Read() 'while there is something
list1.Items.Add(reader.GetString(0)) 'add it to the list
End While

reader.Close() 'close reader
connect.Close() 'close connection
''==========================================================================

Hope this helps.
Smile | :)

Still trying to find the way

We have several applications that will be executing on multiple machines. These applications will be placed on our network and setup with an xcopy style of deployment. To accomplish this task, we had to adjust the Framework configuration, Code Access Security for the machine to Full Trust for Local Intranet applications.

We created a deployment package and we execute this on any machines that will execute the apps.

These apps also have a feature where we write messages to the eventlog when an error is encountered. This works great for our clients that have Power user or admin rights, but for a standard user the eventlog post fails with a message that "Requested Registry Access is Not Allowed".

There are Permission Sets within the framework configuration tool, but I'm not sure what the best approach is to accomplish allowing standard clients the permisiion to write to the eventlog without opening security up too much.

Any suggestions would be appreciated! Confused | :confused:

Lost in the vast sea of .NET

That all depends on which event log your app is writing to. The System and Security event logs are off limits to applicatins run by Users, where as the Application event log should be open to everyone to write to.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

I'm writing to the "Application" log as a standard user with the following code:

Dim EventLogMessageSys As New System.Diagnostics.EventLog
Dim strMachineName As String
strMachineName = System.Environment.MachineName
EventLogMessageSys.MachineName = strMachineName
EventLogMessageSys.Source = “TestApp”
EventLogMessageSys.Log = "Application"
EventLogMessageSys.WriteEntry("Testing", EventLogEntryType.Information)

The app fails on the WriteEntry and the exception that is thrown is "Requested Registry Access is Not Allowed".

I think it was true with Windows 2000 and prior that you could write to the application log, but with Windows XP Pro SP1 I'm not experiencing the same behavior.

XP seems to be more sophisticated with the security. As I said in my original post, I was hoping there might be a Permission Set tweak that you can perform on any machine that the app will run. If you can set permissions for a specific machine or sign-on to have higher rights, the app might run.

Does anyone have any feedback regarding Permission Sets and Framework Security that might help. Thanks Dave for your feedback. Have you had success with standard users writing to the app config in XP? Confused | :confused:

Lost in the vast sea of .NET

Here is what we came up with:
1) Security is the hitch when a standard client tries to write to the application eventlog. The app searches for the eventsource in the registry and when it cannot find it, tries to create one. Due to the rights, it fails and causes our error.

2) We have a class that we wrote for use in our shop, which can be referenced in any program, and if called, can display a message box, write to the eventlog and e-mail, depending what parameters are set. We check if the event source is there. If not, we try to create the event source. If the create fails we notify the client that they need to call us and run a process we call DeployEventSource.

3) We wrote an app (DeployEventSource) which creates the eventsource and is basically setup to be installed by our team with admin or power user rights. We wanted to try to to eliminate as much maintenance as possible and I believe we accomplished this goal. Since our class above writes to a source name that we keep consistent, and our install / create source program creates a source with the same name, we only have to run the install app when someone gets a new machine or system reload. If profiles change with terminations / new hires, we do not have to keep reinstalling or hacking a registry setting. Also we can create several apps that run on this pc which uses our class to write to the eventlog, and as long as the eventsource was created once, it will work for all apps.

I hope this follow-up might help someone else who runs into the same problem. Thanks for your input!!

Lost in the vast sea of .NET

I am trying to automate USB "Found New Hardware" in Windows 2000 using VBS. Can anyone help me with this one? Thanks!

What exactly are you trying to automate? "Found New Hardware" can mean anything. Plug in a Thumb Drive and the entire "Found New Hardware" thing happens automatically without any intervention from the user, or a VBScript. What are the steps you want to automate?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Just a generic USB keyboard and mouse. Both of which are HP, but I don't want to manually go and point to the correct drivers. It is prompting me for the drivers everytime I plug them in after rebooting. Any help with this would totally rock! Cool | :cool:

I would forget trying to automate this. Instead, see if there is an updated driver package. Once the drivers are installed, "Found New Hardware" should make the appropriate changes automatically, without any intervention from the user.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Hey everyone,

I have a problem. I have a windows form that has bound textboxes. When I try to add a new record to the database, I can add the new record to the dataset, but when I try to update the dataadapter based on the dataset, I get this error:

System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.

Does anyone happen to know what might be causing this I've checked the syntax of the insertcommand, but everything seems to be correct in the statement? I've checcked the insert statement based on other forms and it looks correct, but it still won't update. If someone could help me I'd appreciate it very much.

Hi,

an article from Joel Brandenberger, which discrips how to use simple Remoting, but there are questions ...

first the link to the article:
http://codeproject.com/csharp/RemotingWinApp.asp[^]

he uses 3 projects:
- a Server Application
- a DLL with the Interface declaration
- a Client Application

in this case it works fine but this project is designed for an local or an intranet application...

i need a way to use it at the internet.
i know it would work too, but i have to copy the DLL with the Interface declaration to all Clients.

My ServerApplication should be able to load unknown DLLs and provide them with remoting. So its not user friendly to copy new DLLs to the ClientApplication for every changing on the ServerApplication...

I thought of a possibility to load DLLs over Internet ...?
like
LoadDLL(http://server.tld/Application/AddOns/Interface.dll)

i hope you understand my problem, if not ask ^^

Copyrights © 2003 by Paebbels.net

i thought over this again and again and i remembered that it was possible in VB 6.0 with COM to set up a ActiveX-DLL-Server this DLL runs on the remote mashine and the cliend had full access to the dll (if i read the book in the right way... Developing COm and AXC with VB 6.0 - Dan Appleman)

but how can i build it in .NET? (VC# .NET or VB .NET)

Copyrights © 2003 by Paebbels.net

I have 39 buttons on a form (numbered 1-39) and I want to randomly assign text values to those buttons when it loads. So I have a sortedlist object with the values I want to assign. However, I want to use a single event (like the form load event) to assign the text string to the buttons. In this load event, I want to use a looping structure like "while" to assign the text from the sortedlist to each button. The only way I could find to do this was to generate the button identifier as a string. For example:

string = "button"&counter&".text=x.getbyindex(counter)"
x is my sortedlist instance.
Counter in this case is the counter on my loop. So as it loops the 1st time, it sets button1.text = the first instance in the sortedlist. The second loop sets button2 and so on. If there is a better way to do this, I am all ears. However, even if there is a better way, I would still like to know if VB has an execute string command. Any help is much appreciated. Smile | :)

scout12

Scout12:
1st off, there is NO WAY to execute a command like the one you are trying...
Ok, now to the solution of your problem: What you really have is an array of controls... ever heard of that? You have a full set of controls, that are all of the same class, and mostly, do the same thing. So, the best way to go is, "Name them all the same, and distinguish them by an identifying number within the 'name' definition". If you know nothing about working with arrays, you better start studying about it, because it is an actual codeing standard procedure, valuable for any programming language.
Now, concretely, you must select all the command buttons and:

At the name property, put "cmdMassReCaption"

At the index property, put numbers 0...39

and on the form_load, use a For...Next block structure, to peruse through all the controls that are part of the array:

For i = 0 To 39
cmdMassReCaption(i).Caption = lstTheNamingList.List(i)
Next i

So, you'll access every single one of the command buttons by using the same name for each of them, but you will also use a unique (i) indexing number.
Well, hope this is an immediate solution to your problem with buttons, but I profusely suggest you start studying about arrays, it's something you just cant't miss.
Kindly, Pablo.

-----------------------------------------------------------------------------
We live to code, this is our religion.

I still have some questions on this one if you don't mind.
As my example, using the visual designer, I created 2 buttons.

Q1) I changed the name property on 2 button controls to cmdMassRecaption. However, there is no index property in the property grid. There is an image index and a tab index but no index. Can you clarify this?

Q2) By placing cmdMassRecaption in the name field for both buttons, the code generator made the following declarations

Private cmdMassReCaption As System.Windows.Forms.Button
Private cmdMassReCaption As System.Windows.Forms.Button

This would not compile because the second statement produces and error stating that it is already declared. Do I have the naming syntax correct?

Q3) I searched my .net Framework documentation and can't find a reference to cmdMassRecaption anywhere. How can I find out more about this button and coding standards in the VB language?

I appreciate your help.

scout12

sundayschool wrote:
However, there is no index property in the property grid.

I guess Pablo assumed that you use VBA/VB 6. The suggested solution however will now work with VB .NET (for more details see Control Array Changes in Visual Basic .NET[^]).

Best regards
Dennis

Control arrays only exist in VB6 and below, not in VB.NET...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

hey Dennis, Rage... you got it right guys, I was talking VB6 here, but I didn't know there is no control array on .Net, why is that?

and as to you sundayschool... guess you ain't going to school on sundays anyway! hehe, joking...
cmdMassReCaption is a way to name a button. I mean, the control IS A BUTTON but we give it a name we can identify it for what it does, or related to what we want to do with it. That way of naming controls and components, with three lowercase letters for a shorts of the control type, and then the name, is the GNU standard. try to keep it that way, cause everybody codes that way and when you share code, is easier for everybody else to read it and make changes to it. So:
cmdMassReCaption
^ ^--------------- The name: Mass (Re-) Caption.
|---- The type: cOmMANd.

Ok, now get VB6 and get on with studying control arrays, cause you still need it, don't think 'you don't need to know that, cause it's not used anymore'!!!

Kindly, Pablo.