Generate Data-flow Diagrams From Source?
Mar 17, 2009Is there any tool available which can generate data-flow diagrams and entity relationship diagrams directly from VB.NET source code?
View 2 RepliesIs there any tool available which can generate data-flow diagrams and entity relationship diagrams directly from VB.NET source code?
View 2 Replieswhere to find sample system with complete flow, database structure and data flow.. just for reference purpose.. system like inventory, payroll, accounting, billing and etc..
View 10 RepliesI am wondering how to have more than one SQL select statement inside my window formapplication that will control the data flow, as i am a newbie in visual basic.net 2005. This is because I am working on a Alarm Application Notifier which will alert the guard on duty as well as inform him the alarm location. The guard's computer screen will be showing the premises and the button will blink at that location where the alarm is. So if the alarm is at block A for example, the guard screen will show block A button blinking.I have already done the first part but i am STUCK at the rest as to how am i going to seperate the conditions for the 3rd to 4th building .The bottom is for the first building code. The data is from the sql database.
Imports System.Data.SqlClient
Imports System.data
Imports System.Drawing.Image
[code].....
I am wondering how to have more than one SQL select statement inside my window form application that will control the data flow, as i am a newbie in visual basic.net 2005. This is because I am working on a Alarm Application Notifier which will alert the guard on duty as well as inform him the alarm location. The guard's computer screen will be showing the premises and the button will blink at that location where the alarm is.So if the alarm is at block A for example, the guard screen will show block A button blinking.
I have already done the first part but i am STUCK at the rest as to how am i going to seperate the conditions for the 3rd to 4th building The bottom is for the first building code. The data is from the sql database.
[Code]...
I am very New to Vb.net. We are using fortify software for projects when it is going to LIVE. In that process I got some cross-Site Scripting : persistent Data flow issues.
[Code]...
I have finally figured out how to download a file with background worker and downloader. Now the form does not freeze.. I have only one problem left now... How do I get the progress bar to increment in tandem with the data flow? I have listed my full code below. Towards the bottom where the DoWork() sub resides, I am just a few lines short of this year long goal.
Imports System.IO
Imports System.Net
Imports System.Text
Public Class Form1
[CODE]...
How can I kill the excel.exe process in SSIS during the data flow task when it fails? There could be multiple instances of Excel.exe running from other packages that are perfectly valid so I don't want to loop through all instances killing them.My problem is that during the data flow task the process will sometimes fail due to a sheet that is named incorrectly or missing columns. This keeps an instance of excel.exe running which is now an orphan task eating up resources so it needs to be killed.At the same time there are other SSIS packages running that are accessing their own excel.exe process and aren't having any issues. So how can I kill the orphan excel.exe process without impacting the other excel.exe process?
View 2 RepliesI refreshed my data sources to include additional items from the SQL Server databases and it appears that my entire data source from my VB.NET project disappeared.I am using Entity Framework. I may have clicked on something wrong, not quite sure. Unfortunately I can't recreate the Data Source without creating a new Entity and Data Model.I can delete the entry in the App.Config file and recreated it, however things aren't quite right.Is there a way that I can recreate my Data Source from the entry that is in my App.Config file...since that appears to have remained intact.BTW, I can go to my Data Model and successfully refresh from there, however my project isn't connecting to the database so I have quite a number of errors until I can get reconnected.
View 4 RepliesI have an Access database and I want to view on a datagridview specific rows. For that I used the following :
CasesBindingSource.Filter =
"OfferDate Between #1/1/1997# And #12/31/1997#"
Cases is the table, OfferDate a field of the table wich is DateTime type.
When I use Between operator I get the following error :The expression contains unsupported operator 'Between'.
how to make E R diagrams in vb.net
View 1 RepliesAm looking for an Algorithms that will take object that a linked to multiple other object and work out the best location to draw each object based on there links.
this would generate a tree like diagram.
So i have Object 1 then hast 10 link, one of these link is object 2 that has 5 link but object 1 link to one of object2s links and such link.
so i would have some thing like this
Object1 ------------ Object2
/
/ /
Object 3
But this is on a 100% bigger scale with unlimited number of objects and links.
how i would go about working out the best location on my form for each object?
forming the use case and class diagrams of RF-ID based attendance system...
View 1 RepliesCan anyone suggest a free (or very very cheap) alternative to Nevron Diagrams? I was playing with Open Diagram which is open source but it's very poorly documented and their forum is dead.
View 2 RepliesModifying data with the ListView's EditItemTemplate by programmatically settings its DataSource property and calling its DataBind method. I don't have option to use data source control for ListView. All ListViews are bound with data from code-behind. So, I have to handle the Edit/Update mode of ListView manually. [Code]
View 2 RepliesI'm trying to connect a VB application (2010) to an MS Access DB by adding a data source from the data menu but I receive this error message "The connection you selected uses a local data file that is not in the current project.Would you like to copy the file to your project and modify the connection ?
If you copy the data file to your project, it will be copied to the project's output directory each time you run the application" and the options are (yes , No , Help)
If I choose Yes I will not be able to make the application 'device independent ' since it will not be copied under the bin , and if I choose No , changes won't be applied to the DB
how to use the VS 2010 IDE tools in a way the Microsofties didn't specifically intend. But since this is something I immediately tried without success.
I have defined a .NET 4.0 WPF Application project with a simple class that looks like this:
Public Class Class1
Public Property One As String = "OneString"
Public Property Two As String = "TwoString"
[Code]....
The expected result was that "OneString" would appear next to "One" and "TwoString" next to "Two" in the running window.
The question is: Why didn't this work? What will work instead? If I put bindings in a DataTemplate, it works. Blend, with its sample data stuff, implied that this should work, but it doesn't.
I have 5 combo boxes that need to show the same list of items that come from a single dataset table. I have managed to bind the datatable to the combo boxes no problem at all.. but when I run the application and select an item from one of the combo boxes all the others change to the item I selected. After some research I believe that this problem is something to do with using the one datasource so I have tried assigning the dataset datatable to 2 different variables and used them as datasources for 2 of the comboboxes but the same still happens.
A work around to this I can see is to call the same methods and SQL select statements 5 times over to get individual datasources for each combo box but this doing that sounds crazy to me. how I can get around this easily? Code snippet below shows 2 combox boxes and their datasources. I'm using VS2005, .Net 2
ComboBox1.DropDownStyle = ComboBoxStyle.DropDownList
ComboBox1.DataSource = AllergyListDataSet.Tables("ListOfAllergies")
ComboBox1.DisplayMember = "Condition"
[Code]....
can data reader be used as a data source for a grid control?
View 5 RepliesI have a combo box with a data source. This box shows one column of a table and allows me to select one item.Next, I have an ordinary text LABEL that I need to put text from another column of the item selected above.I tried to set the data binding field of the label, but this grabs only the first row or data and shows the selected column. That is nice, but I can not figure out how to update the selected selected ROW when the combo box item is changed.In this case the combo box lists a bunch of inventory parts. When I select a specific part, I need the change the text in a label to show the manufacturer. (like a sub-form). This same behavior will be used in several other places, but the relationships can cascade.
View 4 Repliesi'm got this sql query code in dataset designer
SELECT pkt.fldPackageID, pkt.fldPSID, pkt.fldQuantity, pkt.fldQuantityUsed, pkt.fldRetail, pkt.fldPK, ps.fldName
FROM tblPaketRow AS pkt INNER JOIN
tblProdukDanService AS ps ON ps.fldID = pkt.fldPSID
WHERE (pkt.fldPSID = @param)
I'm trying to display the results in datagridview,i drag from the data source in vs 2008..I can't figure out to do that.I use this code to set the @param on form_load event.
Me.TblPaketRowTableAdapter.JoinTable(SalonDataSet.tblPaketRow, modCommon.s)
I have a bit of code that reaches out and grabs a series of rows from SQL Server DB. I perform an inner join to get some related table data. In the process I get returned the user id of the creator of the data. I then want to pass this into a query to get back a full name. I am having no luck figuring out how to do just that. If I use the data visualizer I can see the name I am after, I cannot figure out the call to extract it
Bindingsource1.DataSource = GetData("Select * From PURCHASE_ORDERS WHERE PURCHASE_ORDER_NUMBER =" & REQ_NUM.Text)
.DataSource = Bindingsource1
[code].....
How can i auto generate id starting from 10000 increamented each time by 1 i.e 10000+1
View 5 RepliesI want to get input data from user and encrypt them and save to database. Is it possible to retrieve this encrypted data and show in DataGrid?
View 3 RepliesI am using 6 textboxes and three button one for insert data second for update and third for delete the data while inserting and updating the record it generate an error i.e. "Data type mismatch in criteria expression" in the backend i.e in MS Access I am using this column[code]...
View 2 RepliesI want to create a page in asp.net website . it has to have one text box . the user enter the productcode in the textbox and click on search . when the user click search i want to display all the information about that product from product table.
[Code]...
generate a crystal report from gridview data!i ady can get data in gridview through the code below!How can i generate a crystal report from this???
Dim sColList, sTableName As String
Dim DT_Data As New RS_UtilityService.dsSDFSystem.sp_DynamicSQLDataTable
Dim ds As New DataSet
[code]....
I would like someone to modify the following code to save data to generate the primary key for each record automatically. In the database,the ID column is the primary key and the Is Identity is set Yes.
Try
cmd = New SqlCommand("Insert into StudentDetails.programmes(ID,Programme,Form,AcademicYear,Class) values(@ID,@Programme,@Form,@AcademicYear,@Class)", cn)
cmd.Parameters.AddWithValue("@Programme", txtProgramme.Text)
cmd.Parameters.AddWithValue("@Form", txtForm.Text)
cmd.Parameters.AddWithValue("@AcademicYear", txtAcademicYear.Text)
cmd.Parameters.AddWithValue("@Class", txtClass.Text)
cmd.ExecuteNonQuery()
MessageBox.Show("Record successfully saved", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information)
how to learn generate graph by using vb.net. My problem now is input the data and need to genrate the graph.
View 1 RepliesIf you want to go to [url]... there is a tutorial about Luna, a vb.net code generator for data Layer of application
View 6 RepliesI've done asp.net exclusively so long, and now I have to convert a small web app to a desktop app.
At one point in the web app, I dynamically generate a table of data and add it to a placeholder control.
I'm not sure how that would be done on a desktop app. Can anyone suggest a control or 'windows' way of doing that.