Creation Of The DB2 Database?
Apr 19, 2010I want to create a new DB2 Databse When My Application Start First Time tell me the solution for this.i have create database command but it can't run.
View 3 RepliesI want to create a new DB2 Databse When My Application Start First Time tell me the solution for this.i have create database command but it can't run.
View 3 RepliesI have create a Stored procedure which is creates the Streaming Data Base.This SP needs to have the path on which will put the mdf files (and some other things).Until now i was run this procedure after i first create the above mentioned path.Now i want to run the same procedure without interference in the server.So I give the following path in order the procedure to execut it and understand where i want to give the path guide.
\ServerNameSharedFolderNameSQL
The stored procedure takes the path and tries to go to the folder of 'SQL' in order to do her job.But in this point i receive an error which says:CREATE DATABASE failed. Some file names listed could not be created, Check related errors.
-I'm Cheking the way of puting the path and it is absolutelly right, I mean accepted from the server machine and from the client machine as well.
I am new to ADO.Net and I mistakenly using the dataset as how we use recordsets in ADO., I know that it is possible to create a Datatable which will only reside in the memory and hold data. What I need to create is like this.
1. Create Datatable.
2. Fill it with sample data at least 3 lines.
3. Transfer the data from datatable to database (access,sqlsrvr etc).
In the past I've used this code to create a database at runtime :-
Dim Cat As New Catalog
Dim Cn As New ADODB.Connection
Dim objTable As New ADOX.Table
[code].....
I have written a web page which connects to a database and then display 3 values from a management reporting system using the database.
I am accessing a database using the following code:
<asp:SqlDataSource ID="SqlToVersion" runat="server"
ConnectionString="<%$ ConnectionStrings:WebImportOnServer %>"
SelectCommand="SELECT [VerNo], [PeriodName], [PeriodNo] FROM [atblVersion]"
[Code].....
but it is how to replace the question marks with valid code that takes the values from the bound fields that I am stuck with.
sql = "CREATE TABLE tblPrograms ([index] Counter," & _
"[lngPlatformFK] TEXT(255) NOT NULL," & _
"[strCompany] TEXT(255)," & _
"[strProgramName] TEXT(255) NOT NULL," & _
[Code].....
When running the previous sql query i am getting a syntax error. This database is a access 2003 database using the Jet 4.0 OleDB driver.
I am new to VB .NET, but not to DLL creation (C++).I am trying to create a DLL using VB .NET (2008) and I need to execute some code when the DLL loads. I am trying to do this in DllMain, but I don't see how to get DllMain to execute when the DLL is loaded. I don't see anywhere that the DllEntryPoint can be set in a VB .NET DLL.
View 9 RepliesI am using Microsoft visual basic 2010 express edition and i am having some trouble with my web browser i have gotten everything to work except for 6things.How to make the source code appear in note pad when i click view source
View 4 RepliesI have a files list which contain the directory of file. I want to know file creation date of that files. I used fileInof.CreationTime. But It is not displayed creation date. How I can know about this.
[Code]...
I'm trying to extend the GridView class to always show the header and footer even when the datasource is empty by using the code I found online (link). However, the code is written in C# but I use VB.
What is the VB equivalent of the following?
public event MustAddARowHandler MustAddARow;
Is there a way around VB.NET not allowing events to return a type?
Also, I cannot convert the following function because of the error below.
Code:
Protected Function OnMustAddARow(ByVal data As IEnumerable) As IEnumerable
If MustAddARow = Nothing Then 'Error on MustAddARow'
Throw New NullReferenceException("The datasource has no rows. You " _
[Code]....
So I am attempting to do the following: Use VB to select multiple Files(Excel, Word, RTF, PDFs) and create one PDF from all these files. I need to perform this for approximately 2000 files with a different number of files going into each PDF. I have Acrobat 8 and Visual Studio 2008.
View 2 Replieshow can i write <p> <br/> hello this is my creation </p> in xml file while i am creating it by the use of asp.net .
it is showing <P> text </P>
i wants to create an dll (classlibrary) file for displaying selected data form database by using a gridview control.for this iam creating an dll file , in that how to declare gridview1 [code]
View 1 RepliesI'm doing INVENTORY project...
front-end : vb.net
back-end : Access
I'm having PURCHASE, SALES tables...
In sales form, i need to create CONTROLS during RUN-TIME...
i.e, when we gone for shopping to a DEPARTMENT store, we buy LOT things... they will give us only one BILL... when they are entering BILL, they will enter only CODE of the product, all the other particulars will be loaded automatically... if v buy 10 items, there will be 10 items in BILL... if it s 15, 15 in bill...
i need to create like this only...
i.e in SALES form, CODE, CATEGORY, BRAND, S.P, DATE, QUANTITY, TOTAL etc., are available... when i click a BUTTON say NEXT, the controls specified(CODE, CATEGORY, BRAND, S.P, DATE, QUANTITY, TOTAL) has to be created automatically, in same size,and in same COLUMN (in form)(i.e CODE is a COMBO BOX, WHEN I PRESS NEXT another COMBO BOX has to be created in same COLUMN), whenever i press the NEXT...
and also, when i press SAVE BUTTON, ALL THE DETAILS HAVE TO BE STORED IN DATABASE...
I know the concept of CONTROL ARRAY... but i don't know how to implement in vb.net...
how to create a windows application in vb.net
View 3 RepliesI have a form that requires 5 columns of textboxes that the user will populate. By design I will provide the first row but, the user will need the ability to add or delete subsequent rows. Is there an easy way to approach this requirement?
View 19 RepliesI need some input refactoring an asp.net (c#) application that is basically a framework for creating dynamic forms (any forms). From a high level point of view, there is a table that has the forms, and then there is a table that has all the form fields, where it is one to many between the two. There is a validation table, where each field can have multiple types of validation, and it is a one to many from the form fields table to the validation table.
So the issue is that this application has been sold as the be-all-end-all customizable solution to all the clients. So, the idea is whatever form they want, we can build it jsut using DB configurations. The thing is, that is not always possible, because there is complex relationship between the fields, and complex relationship between the forms themselves. Also, there is only once codebase, and this is for multiple clients - all of whom host it on their own. There is very specific logic for each of the clients, and they are ALL in the same codebase, with no real separation. Sometimes it was too difficult to make it generic, so there are instances where it has hard coded logic (as in if formID = XXX then do _). You can also have nested forms, as in, one set of fields on its own within each form.
So usually, when one client requests a change, we make the change and deploy it to that client - but then another client requests a different change, and we make the change and deploy it for THAT client, but the change from the earlier client breaks it, and its a headache trying to debug, because EVERYTHING is dynamic. There is no way we can rollback the earlier change, because then the other client would be screwed.
Its not done in a real 3-tier architecture - its a web site with references to a DB class, and a class library. There is business logic in the web site itself, in the class library, and the database stored procs (Validation is done in the stored procs).
I think this is a bad model in general, because one of the things I heard one of the developers say is that anytime any client makes a change, we should deploy to everybody - but that is not realistic, if we have say 20 clients - there will need to be regression testing on EVERYTHING, since we don't know the impact...There are about 100 forms in total, and their is some similarity in them (not much). But I think the idea that a dynamic engine can solve ALL form requests was not realistic as well. Clients come up with the most weird requests. For example, they have this engine doing a regular data entry form AND a search form.
There is a lot of preserving state between pages, and it is all done using session variables, which is ok, except that it is not really tracked, and so sessions from the same user keep getting overwritten, and I think sessions should be got rid of.Should I really just rewrite the whole thing? This app is about 3 years old, and there has been lots of testing and things done, and serious business logic implemented, so I hate to get rid of all that (joel's advice). But its really a mess of a sphagetti code, and everything takes forever to do, and things break all the time because of minor changes.
I've been reading Martin Fowlers "Refactoring" and Michael Feathers "working effectively with legacy code" - and they are good, but I feel they were written for an application that was 'slightly' better architected, where it is still a 3-tiered architecture, and there is 'some' resemblance of logic..
I ran into a little problem where my thread(s) tries to access a control that may not be created yet. How can I check for this or is there a way to force the creation of the control(s) first and then go on or any other solution?
View 23 Repliesok so heres what im trying to do. I have one form with a textbox and a button. im trying to make it so that when you type in the word "internet" a new form will be created and it will have the following components inserted onto it;
one webbrowser
one textbox
eight buttons
im not really having a problem making a new form so much as having a problem putting the tools on it, heres what i have
Dim screensaver As New Form
Dim back As New Button
Dim forward As New Button
[Code].....
vb doesnt say i have an error or anything like that, but i cant create "internet". i can create the form but cant put any of the components on it.
does anyone know where i can get visual basic 5.0 control creations edition???
View 3 RepliesNow i am doing a vb.net desktop application, In which i have to construct GUID. Eventhough having a built-in function in our VB.NET like "System.Guid.NewGuid.ToString()" to get GUID, I need to create the GUID in 30 digits in the below mentioned criteria through vb.net.
Application constructs the GUID (30 digits) using the information from the 5 different sources. The different sources are Current system time, millisecond of the system time, Process ID for the application, system physical memory status and finally the group object identifier number.
8 digits
4 digits 8 digits
8 digits 2 digits
[Code]....
I am not sure how to get the above values to construct the GUID?
When we create an inherited control then is the Designer still needed or not? Should usercontrols be disposable?What is the difference of using Base and Me when we are setting default properties of our usercontrols?[code]
View 4 Repliessetup wizard creation in wpf
View 2 RepliesI am trying to create a entry in already existing registry key, my program is executing properly but DWord is not being create in registry.
Below is my sample code.
Dim rkey As RegistryKey = Registry.LocalMachine.CreateSubKey("SOFTWAREMicrosoftWindowsNTCurrentVersionWinlogonSpecialAccountsUserlist")
rkey.SetValue("poweruser", 0, RegistryValueKind.DWord)
Since interface provides 100% abstraction over its members then why we are allowed to define a class inside an interface? We can define class inside interface, even instantiate it and call its members ,why? I am not getting the clear picture over this .Why this is allowed and what can be its implication or benefit.[code]
View 4 RepliesI am trying to code a simple background workers class without needing to use the backgroundworker object on a form. This would allow me to use a background worker in any class without writing much additional code. Is it possible to pass in the name of a sub at runtime instead of hard-coding it? To do this I would replace onDoWork and onProgressChanged below and use (Byval onWorkSub as SomeKindOfObject?, Byval onProgressChangedSub as SomeKindOfObject?) instead. [code]
View 1 RepliesI'd like to make a program similar to Forensics Anti-Executable...Except i know of some methods like the registry method, but i see that there are many vulnerbilitys and i'd like to know how to make it wheere it cheacks with my app if its ok to execute the program trying to run...like if i had this program running and i tryed to run notepad it would give you a dialog requesting for a password and login. also have this work with the registry like if an installation is creating a new key or editing or deleting a regestry entry to notify and ask for permission.
I just have ideas of how i want my program to run but i dont have a clue to how to do it...I also am planning on making this a windows forms application. [URL]
I keep getting a "System.Runtime.Serialization.SerializationException" in my application while loading a not-defined assembly (AKA: Plug-in loading.)Even if I turn Serialization on for that plug-in, then it will fail once again. I've been looking around and couldn't find a good tutorial about it..
So all together: How to load an assembly using AppDomain?
I have a reguirement to enable the creation of excel workbooks from sql stored procedure. To do this I want to create a vb class to generate and save the excel files. Then and ASP.net page will enable opening the excel file via the browser or enable the user to download the file.The class should be able to be called from a vareity of pages within the web app and have the ability to handle 8 to 10 separate stored procedures that will return various data sets.
View 2 RepliesIs it possible for the installer or the first running of an application to create a scheduled task entry? Barring that, what is the least resource wasteful way to have a program run in the background watching the system time to run at a preset time?
View 6 Replies