I need to throw together a quick CRUD asp.net site, but this may become a bigger application down the road. I have some experience with SubSonic, but it has been so long since I did a project with it I have to relearn it. I am also considering using Dynamic Data.
View 5 RepliesWhat are the improvements in vb.net compared to vb6 that make developing such an application easier?
View 3 Repliesa friend of mine wants to create a simple inventory database that can be deployed on the web.He has had a lot of experience with Database tools like Paradox. Moreover he has experience with writing Macros and programs with Basic, and even a bit of C++ experience. He uses Windows and Mac OS X, though mostly Windows.
If the requirement of having a web application wasn't there I would recommend MS Access.
[Code]...
So I'm developing an application in VB2010. The idea is to perform CRUD operations (more or less) to an Access2003 Database. The database is relational, yet I haven't grasped the best architecture to make an application to interact with it. I tough doing a Business layer with a domain model would work. Controllers for each Use case (which are basically CRUD operations) would create Domain Layer object. Yet I don't know yet how to manage the mapping of the objects to/from the database.
View 8 RepliesI am using Subonic in a VB.net application for the first time (I have used it succesfully in a WebSite project plenty of times). I followed the 2nd part of the 'Getting Started' video to actually generate the DAL source files as opposed to the build provider method and everything APPEARS to have gone like expected. However, nothing I do will get my generated namespace to appear. I feel that it has to with the fact that I am running my Web Application in VB.Net and Subsonic generates in C#.
Here is the process I followed:
1) I created a blank Web Application Project in Visual Studio
2) I configured the web.config to have the necessary parts, connection strings, etc.
3) I ran subcommander and it generated all the classes I needed into a folder called DAL.
4) I built the Web Application Project
5) I opened up a code behind, typed 'Imports' and I do not see the namespace that was generated.
I have even opened the actual Subsonic Source files and seen that there is a namespace statement for the generated namespace I configured. I tried briefly to move the subsonic files to a separate class library project, compile the .dll and use that in my project, but it still did not work.
how to create then add and delete txt files to the resources folder using code ?(not with the mouse right click on the resources folder in the solution explorer)
View 1 Repliesfind a DataGridView CRUD Sample.I need to find the events of the DataGridView, because I can't do this, special when I need to change from column 1 to column 2 and from column 2 to column 3.The only that I need is the link.
View 13 Replies[code]And this is the code, coming from the web service's vb page, where I'm getting the error:[code]MusicDataTable comes from a dataset called music.The GetMusic() works because I'm not passing it anything. I'm not sure why insertSong and deleteSong aren't working.
View 1 Replieshow to convert an existing Standalone Java Application to a Dynamic WEB Application which can be deployed on Apache-Tomcat Server container ?
View 2 RepliesI am running into a problem where my CRUD operations on an entity sourced from an SQL View is not calling the generated methods for said operations.I press "Delete" in a ListView on an item, connected to a LinqDataSource. It throws an error saying that it cannot perform the operation because it affects multiple base tables. That's fine, I understand that. What I don't understand is why this code won't run on insert/delete:[code]In debug, it won't break on the method, so it's not being called. I even did a test where I deleted the entity by attaching/DeleteOnSubmit and still no-go. Is this a bug or am I not handling the right method? I can handle a data source's OnDeleting event, cancel, etc. (which is my temporary fix) but I'd really like to catch ALL delete operations in a central place no matter how I delete the entity.
View 1 RepliesI'm quite comfortable with VB and have a very large project i need to do. I've come across SubSonic and it looks awesome. I am not clear if i can use it in VB. I've seen a a couple of posts that suggest they did but on the site it specifically shows C#.Can I use SubSonic with VB.NET?
View 1 RepliesI am trying to get subsonic to run work in a webservice I am not sure how to return the data. I only get the word Object in my results when It return anything instead of values. What am I missing?
<WebMethod(Description:="Method to retrieveCptCode subsonic List")> _
Public Function GetSubCptCodes() As CPTCodeCollection
Dim coll As CPTCodeCollection = New CPTCodeCollection()
Dim qry As Query = New Query(CPTCode.Schema)
coll.LoadAndCloseReader(qry.ExecuteReader())
Return coll
End Function
Followed Rob's webcast, did as he did, watched T4 generate the code, went to use the new namespace and oh. No namespace. I can see the namespace Test.Data in each of the generated .cs files, the tt files are included in the project as is subsonic.dll, there are no errors (I managed to get rid of a warning for the duplicate directives) but I just can't see the namespace. To test it out I am building a simple vb.net console application so wondering if there is a conflict there. Using v2.2 against the same db works fine.
View 1 Replies[code] will both give the error "The method 'CompareString' is not supported". If I make the same call searching for an integer (ID field) it works fine. .SingleOrDefault (Function(x As Account) x.Id = 12)So interger matching is fine but strings don't work Is this a problem with the VB.net templates?
View 3 RepliesI am trying to save changes to a record, however I am getting the error
[code]...
I have an application I am converting over from vb6 to vb.net 2.0/3.5. Using Subsonic 2.2 and the vb.net Interop Toolkit 2005. Cannot seem to get the .net form using subsonic to work inside the interop environment.It keeps saying it cannot find the subsonic service provider in the app.config. But I know it is there. Has anyone used these two toolkits together successfully? Will subsonic even work inside the interop environment in that way?
View 1 RepliesI have trouble using the transactionscope on SQLite, i am using the following code. Changes are still commited to the database while i don't call the ts.Complete() function.
Using ts As New System.Transactions.TransactionScope()
Using sharedConnectionScope As New SubSonic.SharedDbConnectionScope()
' Do your individual saves here'
[Code].....
I moved from SubSonic 2.x to 3.0 and noticed that all my classes are combined into the ActiveRecord.vb(cs) file. Is there a way to have my classes generated individually in a separate folder (DAL) as I was doing with 2.x?
View 2 RepliesI'm trying to use Subsonic 3.0.0.3 with an existing web site created in vb.net. I've added a reference to SubSonic.Core.dll and added the ActiveRecord tt/ttinclude files. I also added a contextmenu entry to run the t4 templates using instructions I found here.Whenever I try to run any of the tt files, I receive the following exception. Does this have something to do with me using a web site as opposed to a web application?
f:Documents and SettingsdbollardLocal SettingsTempSQLServer.ttinclude(85,15) : warning CS0219: Compiling transformation: The variable 'parameters' is assigned but its value is never used
ActiveRecord.tt(0,0) : error : Running transformation: System.InvalidCastException: Unable to cast object of type 'Microsoft.VisualStudio.TextTemplating.CommandLine.CommandLineHost' to type 'System.IServiceProvider'.
[Code]...
i download subsonic 3 today (subsonic 3 preview 2) but this don't work in vb project.i think because .tt file (for generation) is C# template so this don't generate vb code.
View 1 RepliesI am looking to make a database call based on user input. The line I am using is:general_read.CommandText = "SELECT * FROM general WHERE Business_Name = '" & business_name & "';"
business_name is dynamically loaded from:Protected Sub btnLoad_Click(sender As Object, e As System.EventArgs) Handles btnLoad.Click business_name = txtName.Text
[Code]...
The error that is being shown is: Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.I'm assuming it has something to do with the variable not being set before the database call is made, but I'm not entirely sure.
I have the following snippet:
liNoSheets = My.Resources.NoSheets
ReDim lsSheetName(liNoSheets - 1)
lsSheetName(0) = My.Resources.Sheet1Name
[Code].....
Currently i only managed to implement the google map(static) into my application,but i want to replace it with a dynamic map. Is there any website or example for me to refer? I tried reading up google API website, but i still dont get it.
View 2 RepliesI'm starting using a project for smart device in windows CE 5. I'm using visual basic of v. studio 2008.I need to create a dynamic connection between a PDA (codebar lector) and an server with ORACLE 9i. The PDA connected via WIFI. But in my vb project I don't find OLEDB or ODBC elements.
View 2 Replies1.How to show Grid vertical and horizontal grid lines in windows application.2.How to stretch complete graph control placed on the form as per the resizing of the form.3.How to draw arc(curve shape) with start and end point with known radius and angle.
View 4 RepliesI am building a program to keep tract of student signup and classesroom.
1.I have an admin form that gives the admin users the right to create a classroom. This class is available / show up when the student signup. Because of future plans I want the admin to have the right to add / delete and classroom if the class is no longer needed to offering.
When a student signup the available class will show up in a datagridviewer and I have added a check box to select the classes taken.
[Code]...
I've created a new ASP.NET Dynamic Data website and have used LINQ-to-SQL for the framework. I start up the application and it displays my tables fine and I can browse them - but it doesn't give me any create/update/delete abilities - all I can do is read? I didn't change anything from the defaults - what gives?
View 1 RepliesWhich technology should I use for data access layer?What's the best way of connecting to a dynamic data source and binding the result to a grid?I'm writing a little web app that user can define connection string and table name (MS Sql Server) and the program will display values in that table inside a grid.We must use datasets (because of dynamic data source) and generate the query as a text command ("Select * From " + TableName).We don't have a model (data source is defined by user at run time) so we can not use EF.
View 1 Replies[URL]..And put into a dynamic array where each month represents a record in the array with 3 given with C/P, Strike and Settle
The criterion is for every month grab all C/P that have matching strikes thus returning the following for every month. See data below and what I would like to return below. Want to use excel VBA to return the values from array into a sheet in excel. See data below
[Code]...
I have the following dynamic controls...working great..
[Code]...