I need to add some common details in more than two tables. [code]So i have stored the Department (from drop down list box) and assigned it to Dept.So i guess dept would have Csc if i choose csc and commerce if i hoose commerce.When I checked with breakpoint it s workin. Datas are added perfectly. But they are not visible in that respective table
View 2 RepliesThere is a "how do I video" on how to properly control updates, inserts and deletes in multi-user applications on forms that edit master-detail related data. [URL] Massi worked through the process using Order (OrderID is PK) as the master table and Order Detail (OrderDetaiID is PK) as a related table in dataGridView. The dataGridView automatically generate orderDetailID whenever the mouse enters in a new row. I am doing a similar form, but placing order form and orderDetail form in two separate tabs in a tabcontrol, and also using Details view for both tables. When I click "new" button in BindingNavigator, the orderID is automatically generated. If I use dataGridView for my orderDetail tab, then the orderDetailID is automatically generated when the mouse enters. This allow me to insert/update tables correctly. However I need the Details View for my orderDetail form too. How do I get a orderDetailID automatically generated when user insert a new order and have the mouse click on OrderDtail tab?
View 1 RepliesBinding Master Table to TextBox and DateTimePicker and Binding Details Tables to Datagridview then Add / Update / Delete in both
View 8 RepliesI have 4 Tables Master And Three Tables Details
how to programming this Technique
This Picture dispaly what i mean http://img300.imageshack.us/img300/3981/26072009110315.png
I'm trying to get a details view in ASP.NET to display the details of the logged-in user only. I have been told to use:
select * from STAFF where USERNAME = user.identity.name
I thought this was too simple to be true and I was correct as it shows no data when I attempt to run.
I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
have a datagridview containing 2 tables left joined, so that:table1 LEFT JOIN table 2 ON table1.id=table2.idI get an error whenever I try to edit my datagridview."invalidOperationException was unhandled by the user codeDynamic SQL generation is not supported against multiple base tables."The error points to this line:
da.FillSchema(dt, SchemaType.Mapped)
da.Update(dt) << This line
'da = dataadapter
[code].....
In my datagridview I was fill in using join tables (table1 = pr_employees, table2 = pr_employee_deduction). My problem now is during save button I want to update records from table2 only.[code]
View 3 RepliesWe are presently developing an application, let's call it APP1, which uses a SQL Database which have about 800 stored procedures, 600 tables, etc. APP1 was originally created in order to replace another application, APP0, from which we do not have source code but only SQL tables, Stored Procedures, views, etc. Previous programers of APP1 used some DB objects from this same database and added some other objects specific to APP1 because it becomes bigger than APP0. And we do not need APP0 anymore as APP1 does all what we want, and more.
So, now, we are thinking about a way to find out which objects are used by APP1 in order to remove objects which are ONLY used by APP0.What is the best approach to discover all objects used by APP1 without having to open every single class and form?
Once we will have a complete list of these objects, it will be easy to use a program we bought which detects all dependencies for all SQL Objects specified directly from SQL and remove objects which do not return from any dependencies. Any ideas of how I could get this list without having to go through all our program that have many, many, many classes and forms?
Note : I know, in a perfect world, all calls to PSs and tables should be in a DAL but in the case of the application we're presently working on ... this is not our case! Yippy! (sarcastic yippy) ;)
Note 2 : This application is not using any ORM. So all queries are directly using SqlCommand. So any call to any DB objects are in string format.
I have a 5 tables in my database and i want to access all my tables togather at a time.e.g.I have a code for one table i.e. rs.Open "select * from Group_info", con, adOpenDynamic, adLockBatchOptimistic. instead of Group_info table i want to access 5 tables also as Login_table,User_info table,group_name table etc. How i do that
View 11 RepliesI am new to .net and I usually had a common file which was having information of username,server,password,IPS and fixed integers in php and asp classic which i used to include in all files so that i could use them in any page. Since I have come to know that .net has no include function. how i can do it in asp.net?
View 3 RepliesIn the old VB, there is a .bas file wherein i place all the global constants there and whenever i create a new project i just include that .bas file so that all the constants i placed are automatically added to my project. Is there any way to do this on VS2008? Ill be doing dozens of Class Libraries that that needs to reference global constants.
1. Is there any other way of referencing the global constants rather than making it a shared variable in a class?
2. Also, is there a way to include a .VB file without the copying it on the local project file? My point being is that this .VB file is also being used by other Class LIbraries that i created.
Is it possible to set up a common event handler for a group of like controls like buttons or text boxes so a single event handler is called regardless of which of the controls is clicked, changed, etc.In my PrinterDialog study project I have 5 text boxes named TB1, TB2, TB3, TB4 and TB5 in a text box array called TBs so they can be accessed with TBs(0), TBs(1), etc.My question is if I can set up a single click event that responds when any of the 5 text boxes are clicked to avoid duplicate code n 5 different click events.
View 1 Repliesif i miss to set dbtype of my parameters (common.dbparameter) it works fine again?Is necessary to explain dbtype or not?
View 1 RepliesI know it is not vb question but I was wondering if there is any place to get the common images for buttons (like save, clear, find, new , delete etc...)
View 2 RepliesStarting from a table like this:
| Code | Year |
---------------
| A01 | 2001 |
| A01 | 2002 |
| B01 | 2002 |
| C01 | 2003 |
I have to arrive to this:
| Code | Year |
---------------
| A01 | 2001 |
| B01 | 2002 |
| C01 | 2003 |
I have to group the first column (Code) and from the second (Year) I have to get the data 'less common as possible' compared to all the other records. I try to explain this with the example: for the code 'A01' I have 2 years: '2001' and '2002'. I have to take '2001' because it's the one that not recurs in the other records. In the case that there aren't available values 'Year' that not recurs in the other records, it's good to take whatever value.
The data are in the form of array in memory and to interact with them I'm useng some LINQ queries.
Essentially, whenever my users who are logged in via a global module level variable enter a new form, their activity is "logged" in a textfile with their UserID as the name.txt and every time they visit a page it adds a new line to their log file with a number corresponding to the form they visited. For example, if they select "add a user" it will add the line "1" to their log file. Note: At the moment there is only 1 2 and 3 not 0.
I have got this far and I have got as far as creating an array which has:
Array(0) = NumberOfTimes 0 appears in the log file
Array(1) = NumberOfTimes 1 appears in the log file
etc etc
Therefore the output for this is
Msgbox(Array(0)) shows "0"
MsgBox(Array(1)) shows "4" for example and lets just say
MsgBox(Array(2)) shows "9" and
MsgBox(Array(3)) shows "1"
Therefore, finally (!) my problem is now finding which 3 are the top. I have tried various methods of sorting them but I just get "9, 4, 1, 0" rather than "2, 1, 3, 0". (By the way the end product for this is to show three links on the "welcome form" of the users 3 most visited forms). Here is a pastebin of all the rubbish I have currently tried that hasn't worked! [URL]
When I was learning QBasic I found a list of most common errors and it told me whether my errors were syntax errors or logic errors. Where I can find a similar list for VB 2008 Express Edition?
View 7 Repliesi made an application using VB.NET 2010. i have 5 forms. i want to know how to make one common navigation (like in a webpage) for this application. Is it possible to have the menu and header static and loads each form in one dynamic container. I hope my questing is clear :P just to make it more cleared, it is more like having a templates in php coding where we can load other page in a particular area without having to reload the entire page with each links.
View 2 RepliesIn my "root" Views folder, I have a _ViewStart with the following code:
@Code
Layout = "~/Views/Shared/_Layout.vbhtml"
End COde
[code].....
What I am doing wrong with these And and If statements.
Sub SetRarity()
Dim Subtotal As String
Dim Total As String
[CODE]...
My question is what am I doing wrong I can only get UltraRare or Uncommon or common.
I am looking for a way to modify the default values in windows vista and or 7.
Examples:
* The default directory for the save/save-as dialog box.
* The size of the window.
* The "favorites" list on the left of the box.
I have been looking for a while and the only thing I can find is to edit the group policy but this will only affect programs that are using the xp dialog box.I am sure this is actualy pretty easy but I cannot find anything for the life of me
Here is a complicated, but possibly dumb question concerning adding projects together in the IDE in order to increase performance and share memory at the same time.I have written two distinct exe's. The first exe (file processsor) operates using three timers to perform communication between a hardware OEM proprietary ComServer and file output from the second exe. The second exe (work generator) simply outputs files on hard disk so that the "file processor" can process the commands in the order given. The first exe was written as a "background processor" to the second exe in a stand-alone fashion. There is a need to communicate data between the first and second exe that is time sensitive. The ComServer called by the "file processor" only allows one port to for communication to the hardware device that is a USB. The "file processor" is capable of extracting the data required but the existing technologies, such as RPC, IPC are too slow and or full of pitfalls. Microsoft's Memory Manger has found it easier to create multiple instances of the proprietary ComServer and assign the needed memory to the calling routine so that it can "scoot" memory easily in the garbage collection feature of the operating system. What this does is cause the mullitple instances that are created to "gang up" on the device either slowing its performance down, or causing time outs. [The second process is a custom 3-D graphical CAD/CAM. The first process is a machine interface. Although hind-sight is 20-20, it seemed more ideal to write this background or file processor independantly, as then it could communicate with existing as well as a custom CAD/CAMs.]
Simply writing the first processes' code into the second slows down the second process as a result of all the timer interrupts looking for work to do. (Mouse is squirrely, screen refresh is slow, etc.) I am only guessing here that the operating system's service of the more complicated single memory location is somehow interrupted more frequently for a larger project, than two smaller independant projects running seperately. I only know what I observer here. Interestingly, the two smaller projects running seperately seem to run fine.
Now for the dumb question. Is it possible to merge the "file processor" with the "work generator" in the IDE such that each process runs as independantly as two distinct apps, but at the same time, make it possible to share memory via one Module1.vb? So far, I cannot find a way for the "file processor" to see the "work generator's" Module1.vb, regardless of how many PUBLIC statements I issue in the code. In other words, what would be the steps after File->Add-> Existing Project to cause the "file processor" project with a form to start first, then drop to the background, followed by launching of the "work generator" second where each process shares the same Module1.vb?.
If this could be done, say through a compiler statement, or whatever; then this could make the Memory Manger folks happy, and provide for the speed required to operate real world processes? Basic computer science suggests a simple processor LD instruction could make data available to any application within a few clock ticks. Microsoft now longer allows direct memory access, or the ability to carve out a "stay resident" dll in memory where a memory location can be called for quick distribution information to all apps with just one call to a device.
There are 3 project in vb.net MAIN PROJECT, BLL(Business Logic Layer), DAL(Data Access Layer) now we are trying to maintain one single instance of some values through out the assembly or what we can called single instance should get used in all projects...for example there is a class called clsParameter we need only one instance of this class should get used through out all projects so if i made any change in MAIN PROJECT same values also get updated in BLL or BLL should receive same values....
View 3 RepliesI have started developing in vb.net 2008. I want to make a common module to validate all text boxes of my every win form. Common Validation I'm looking for are Length ( Size ) of text box value must not greater then that of field size, It must be of numeric, or alpha only, It must not be empty, if single quotation mark, covered with double quote mark etc.
View 5 RepliesDoes DirectCast, ctype, etc., are common function? Why it return type, and how do I used it? Is there others function where I need learn to be dot net expert?
View 3 RepliesThis code gives a result of 1 for all numbers and i don't know why. phi(n) for any n in this code give me 1.Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim n As Integer
n = CStr(TextBox1.Text)
Dim phi As Integer
[code].....
Suppose I have two list
list1: {1,2,3,5}
list2: {1,2,2,3,3,4}
I want to get the result list3: {1,2,2,3,3,4,5}
notice the final result contains the common parts between two lists.
I'd like to implement a common method on most of the forms, but not all.Let's call the method 'FormCleaner'.
I'd like to recursively call each forms FormCleaner method and ignore cases where the form has no such method.[code]...
I'm writting a dll in Fortran. I've included some common blocks in the fortran code. And I don't khow how to import it to Visual Basic.
View 2 Replies