in terms of speed and resource usage is it better to call the access queries using access.aplication or rewriting the database objects in VS? By using access there should be just one version of the queries, not two and access is more friendly for writing the queries.
View 2 Replies
I have over 11,000 pages in a site and need to change the tag on every page. I interact with production through horribly slow tool so doing a global search and replace is out of the question. The site is in a .net environment and I utilize vb so I am wondering if I could rewrite the tag sitewide on the fly with a class
View 1 RepliesIt looks like theres a bunch of threads with these issues. Mine has to do with events and event handing in an add-in...so its a bit complicated for me.I'm trying to rewrite this C# code
#region Event Handling
/// <summary>
/// Wires up events from xWeb and this plugin
/// </summary>
[code]....
I have no idea where the type AddinActiveDocumentChanged and the type DocumentEventHandler is coming from. Intellisense doesn't have these. So both of those sub routines I'm stopped at.
How would I write the 3rd VB code in C#?. I can't find anything on Google.
Imports XL = Microsoft.Office.Interop.Excel
Public Class LicenseRenewal
' The line below to C#
Private xlRangesForRenewal As New List(Of XL.Range)
I am making an application so I can easily clear up this ini file. The ini file contains such data as playerlevels, abilities they own, abillities available, conclusion: it contains all information for the RPG modification for a game.Now when I have for example this in my INI:
[[CD]Infernus RPGPlayerDataObject]
OwnerID=xxxxx-xxxxxx-xxxxx
Level=57
Experience=234
[code]....
;Each ability will be removed. The problem here is that earlier in the code you also have Abilities= which I really need to keep, I only want to remove it from parts starting with the header [**some name** RPGPlayerDataObject]
I have wired up a Global class to an HttpModule. It's job is to detect "http:/www." in the URL and redirect the user to the NON www. version
Protected Sub OnBeginRequest(ByVal sender As Object, ByVal e As EventArgs)
'Force Removal of WWW
Dim application As HttpApplication = TryCast(sender, HttpApplication)
[code]....
not something I want to do anyways since it's a hack, but it didn't work anyways.
I have a txt file comprised of a vertical list. The list contains x-amount of groups but what is standard is that they are always made up three entities.Example as follows:
PANNEL A
38
2440
Explained as:
NAME
WIDTH
LENGTH
A list of three items (though list can contain x-amounts) is identical to:
NEW BEAM
38
2440
[code]....
I now need to create a new txt file, which is written as follows:
("NEW BEAM" is "38" x "2440")
("WOOD" is "22" x "610")
("ITEM A" is "50" x "1220")
How van I do this using VB.NET?
+
I have set the name of my Form text in the application settings and I need to rewrite it. Is it possible as it is showing me that it is only a readonly.I know that we can simply change it by using me.text="" But I have a problem in my application as I have the below code where On every time the form loads it is erasing the text.
Protected Overrides Sub OnLayout(ByVal e As System.Windows.Forms.LayoutEventArgs)
MyBase.OnLayout(e)
'Me.Text = CStr(Val(Me.Text) + 1)
FillList()
[code]....
Relating to another question I asked yesterday with regards to logging I was introduced to TraceListeners which I'd never come across before and sorely wish I had. I can't count the amount of times I've written loggers needlessly to do this and nobody had ever pointed this out or asked my why I didn't use the built in tools. This leads me to wonder what other features I've overlooked and written into my applications needlessly because of features of .NET that I'm unaware of.
Does anyone else have features of .NET that would've completely changed the way they wrote applications or components of their applications had they only known that .NET already had a built in means of supporting it?
It would be handy if other developers posted scenarios where they frequently come across components or blocks of code that are completely needless in hindsight had the original developer only known of a built in .NET component - such as the TraceListeners that I previously noted.
This doesn't necessarily include newly added features of 3.5 per se, but could if pertinent to the scenario.
Edit - As per previous comments, I'm not really interested in the "Hidden Features" of the language which I agree have been documented before - I'm looking for often overlooked framework components that through my own (or the original developer's) ignorance have written/rewritten their own components/classes/methods needlessly.
I don't know if this is even the correct terminology but I was wondering if it is possible to bind a row (of data) from a database to an object. I am working on a school project and we have decided to create this application to track a user's BMI/BMR and compare it to the amount of calories they have input. The program doesn't go too in depth so it does not store the calories consumed in the database.
So here is my problem. I have a row in my database:
First_Name -- Last_Name -- Height_Inches -- Weight_Pounds
And I guess what I am thinking I want my program to do is if I have an object with properties for FirstName, LastName, HeightInches, WeightPounds, is to somehow query the database for one row and put the values into the object. All we have learned so far is binding the data with controls which doesn't really help in my case since the work is going to be done behind the scenes.
Private Sub btnPurchase_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPurchase.Click
Dim objCustomer As Customer
Dim objProduct As Products
Try
[code]...
1- why not just write queries those manipulate the database rather then creating objects, making changes and then going back to database.
2- now that i have got the new balance and the product oder has been made so every time this happens a query has to be sent to change database or there is any other better why of doing it?
I've just gotten started with development using Visual Studio (though this can be seen as a more language-generic question), and need done design answers regarding how to suitable relate a Database Entity/Table with an Class in-code.
Currently, I create a class who's attributes or iVars directly correspond to the fields in an Entity.
When I come to fetching all 'Customers from a Table' for example, I run a Select all statement against the database and for each result-row returned, I instantiate a new class Object where I use the Class' default constructor to set the instance variables. (I really wish there was a method like PHP's mysql-fetch-object()?)
I can then add each of these objects to say, a List(of Customer) and return it.
This doesn't seem like the best way to do it. If I were to change the Database schema, I'd have to reflect those changes in the class also.
I have a connection string set up and a data reader.I have two textboxes on my form for users to type in. One textbox (txtLogin) is a user name and the other textbox is a password (txtPwd). I'm trying to compare what a user types into those two boxes to a table in a vfp database. The table I'm trying to compare to is open about 99% of the time so I need to be able to read from it in some type of "shared" mode.
My Select statement needs to be something similar to "select * from sites where clogin = txtLogin.text and cpassword = txtPwd.text"I just don't know how to get this to work properly.
I have decided I would start small and make a program that would create a "receipt" list in a listbox and a total. Now, I would like the user to be able to add their own "menu" items. I'm assuming the best way to go about this would be to have them actually add it to a database and then a function in the program will refresh the dataset with the new list. However, this is where my problem lies. How can I tell VB .net 2010 that I want to create a new button (or buttons) on the fly, in an orderly pattern on the form, based on the input from a DB?
View 10 RepliesHow can we use the database objects from one form to another? Eg. In my Login form a person enters his user-name and password & if it is correct, the code directs him to another form(Form2). Now in Form2 How will I get which person has entered in?
View 1 RepliesI have developed a small window application, having lot of insert and select scripts. It runs fine for 3 times but when i run it 4th time it gives me Error "Out Of Memory Exception". I observed that in my task manager Sqlserver.exe process occupies memory around 167000K. Then I killed it. and again run the code, this time it occupy 12000K memory. Again I run it...the memory increases and stops at 87125K. All It means i the C#.net objets are not disposed well.
I have tried for
GC.GetTotalMemory()
But failed? How can I release objects?
I opened vs 2008 and used the server explorer for the first time to create a connection to my SQL 2005 db. The solution explorer pulled in all the tables, the database diagram etc. My question is how do I access that database connection and work with it using ADO objects? Do I need a reference to ADO?
View 4 RepliesI have a problem with access database in my vb project. I would like to fill the listbox with objects from my database. I've attached two images. In first image when i'm using command objDataAdapter.Fill(mydataset....) i can select table property(zaposlen). But in second image or in my second app i dont have an option to select table property in my dataset(there is nothing to select). If i select DataTableDataTable i get next error: DataTableDataTable' is a type in 'WindowsApplication1.baza_podatkovDataSet' and cannot be used as an expression.
View 2 RepliesI have this code that creates a template and stores that template to a local database and I want it also to store in a network database but I'm having problems on the other end it seems it's not storing the right data.
Server side
Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=|DataDirectory|fp.mdb; Jet OLEDB:Database Password = joceradmin"
Dim fpFilename As String
Dim userID As String
userID = InputBox("Please enter ID number to enroll", "Enter ID Number", , 100, 100)
[Code] .....
I am using VB Exopress 2008 and SQl Server Express 2008 in Windows Vista Home Premium. I have created a dataset after importing all tables and queries from MS Access to SQL Server. I have now added a view in SQL Server that I want to access and use in VB Express. However on clicking "Refresh" for the dataset the new view does not display in the available objects, only those I originally imported and opened with the original dataset. What, pleas am I doing wrong? How can I see this new View?
View 3 RepliesIn my global.asax.vb I have a rule like so:
RouteTable.Routes.MapPageRoute("defaultRoute", "{*value}", "~/default.aspx")
So, if someone enters:[URL]...Even though that page doesn't exist, the application pulls up default.aspx
Now, if this wasn't using a wildcard it would be easy to pull this value in on default.aspx like so:
Dim prospect as String = Page.RouteData.Values("value")
But this doesn't seem to work with wildcards, e.g.:Dim prospect as String = Page.RouteData.Values("*value")
How can I get the page to pick up these variable values? e.g. one time might be janedoe, another johndoe, another goose, another 12345, etc. Whatever it is, I want it to be returned into the string prospect.
make objects from the ToolBox using code instead of changing existing objects invisible then visible later?
View 7 RepliesI am getting this error, Not sure why it is happening "Error The SqlParameterCollection only accepts non-null SqlParameter type objects, not Int32 objects."I have tried with all sorts of possibilties, now try to enter default data as dummy data,
Using connection As New SqlConnection
connection.ConnectionString = ConfigurationManager.ConnectionStrings("DentalDeviceConnectionString").ConnectionString
connection.Open()[code].....
I have a program like this.
Module Module1
Public Class Mstr
Public Property Prop1 As String
Public Property Prop2 As String[code]....
But it is not working as I expect it to. You can see it from.The DtlsB properties of all three DtlsA objects are having values from last iteration.
I want to let the user input objects to a richtextbox 1 object on each line, and somehow use Random.Next to select pseudorandomly a few objects, the number 'few' inputted in a textbox.
View 9 RepliesPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Using conn As New SqlConnection("Database=Clinic_Management_System;Data Source=.SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|Clinic Management System.mdf")
Dim cmdRecord As SqlCommand
[code]....
I have a user control that inherits the FW ListView and I need to dispose of two objects when the form's disposing of it's objects. Here's what I've concluded already, am I on the right track?
[Code]...
long story short, I have created a ListView type control, using UserControls for the parent control and the ListViewItems. Most the of the control is written and works fine, right up to the point where I tried to replicate the 'Control.SelectedItems(0).Index' property and the 'SelectedIndexChanged' event.
Each child object knows its index value, and could pass this value via the SelectedIndexChanged event (assuming this is how it works in a normal ListView control -- user clicks on an item, and that item fires an event updating the selected index value in the parent object).
How does the child object raise an event in the parent object? I have a feeling this could be done with Delegates, but I'm still learning about their usage.
getting the following error Unable to cast object of type 'System.Object[]' to type 'OrderService.webdirect_WebLinesRow[]'. On the line
webdirect(web_companyID, web_locationCode, web_customerNumber, web_orderNumber, web_orderReference, web_orderDate, webLinesArray.ToArray(), o_Company, o_LocationCode, o_CustomerNumber, o_OrderNumber, o_OrderStatus, o_OrdDescrip, webRespArray)
I created the webLinesArray.ToArray() array as such
Dim webLinesArray As New ArrayList()
Am I missing an additional cast or something ?
I want to compare two objects to check if all the properites of both the object have same value or not. for this i need to use the reflection to enumarate through all the properties of an object and check the value of the property. To try the code just i have written a Employee Class having Two Properties EmployeeNo and EmployeeName. I am creating an object of the Employee class and need to write a function that can list the values of all the properties in the class.
[Code]...
