Dynamic Table Creation From .net In Sql Server 2008?
Oct 19, 2010Can i create a table with the input taken from user at runtime from vb.net.?
From vb.net in sqlserver 2008
ADVERTISEMENT
Dynamic Sql Table Creation - Create Sql Tables Based On User Need
Apr 20, 2012i need to create sql tables based on user needs lets say a guy needs a table of 4 rows 5 columns other user needs 3 rows 3 columns each with different types so how is the best way for letting them choose like they write in a text box ( this will be the value of rows)4 and another text bvox the count of columns and i have those 2( rows and columns needed) numbers i create the table as is.based on those. by default i create type as varchar max then later on we must fill the table using datagrid.
View 14 RepliesVS 2008 : Dynamic Object Creation From Dll?
Jul 9, 2009I am trying to get the hang of Dynamic loading of objects from assemblies on the same machine (But NOT part of the same project).In the sample below, Form1 implements an interface built as part of the .dll I placed in C:Release. I am trying to create a local instance of Form1, and Cast it as Iform, so that the local code can access the properties and methods exposed by the interface.The assumption here is that at runtime, local code will have access to the String name of a form, and an interface which is implemented by the form (and is compiled into the .dll as well as the client application), and that is it.
When I run this code, I get a exception: "Unable to cast object of type 'WindowsApplication1.Form1' to type 'WindowsApplication1.Iform'.
Public Function fApplicationObject() As Iform
Dim sLocation As String = "C:ReleaseWindowsApplication1.dll"
Dim sType As String = "WindowsApplication1.Form1"
[code]....
I seem unable to dynamically load an object from a dll and then utilize an interface to access it's properties and such.
Create A Dynamic Table In Sql Server 2005?
Feb 18, 2009To create a dynamic table in sql server 2005 with all its privilages(constraints,..) from a xml file.
View 1 RepliesDynamic SQL To Dynamic LINQ In .NET With MS SQL Server 2008?
May 24, 2010I need to represent the following query using LINQ:
DECLARE @PurchasedInventoryItemID Int = 2
DECLARE @PurchasedInventorySectionID Int = 0
DECLARE @PurchasedInventoryItem_PurchasingCategoryID Int = 3
DECLARE @PurchasedInventorySection_PurchasingCategoryID Int = 0
[code]....
Now, I know that a query in .NET doesnt look like this, this is my test in the SQL Design Studio. Naturally VB.NET variables will be used in place of the SQL local variables.My problem is this: All of the conditions after "WHERE" are optional. In that a query might be made that uses one, some, all, or none of the conditions. V.PropertyID and V.Value can also appear any number of times.In VB.NET I can make this query easy enough by simply concatenating strings, and using a loop to append the "V.PropertyID/V.Value" conditions.I can also make a Stored Procedure in MS SQL, which is easy enough.However, I want to accomplish this using LINQ.
VB 2008 - Access Database Table Creation Syntax Error
May 23, 2009sql = "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.
File Not Found After Creation Vista To Windows 2008 Server?
Aug 31, 2009Using VB6 to create a file and then open the file just created fails when run on a Vista client with Windows 2008 Server. The same code will work when run directly on the Windows 2008 Server or when using an XP client. If a Sleep 10000 is placed after the close, the program will work. What is the problem here? The code is as follows:
Option Explicit
Private Declare Function GetTempFileName Lib "kernel32" Alias "GetTempFileNameA" _
(ByVal lpszPath As String, ByVal lpPrefixString As String, ByVal wUnique As Long, _
[code].....
Dynamic Creation Of Textboxes
Mar 7, 2011I 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 RepliesDynamic Form Creation In Asp.net C#?
Aug 12, 2011I 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..
ASP.Net Dynamic Excel Creation From SQL Datasource?
Feb 15, 2012I 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 RepliesDynamic Creation Of ASP.NET Form Elements?
Nov 20, 2009I'm trying to build a form which generates itself as it is used. I have created a really simplistic example, loosely related to what I'm trying to do below, but which demonstrates the problem.The user types a word in the text box, clicks the Button and a new TextBox is loaded into a Panel, with the value in the original TextBox that the user has entered. The user should then be able to type something else/the same and create another text box with that in it by clicking the button, basically permitting 0,1,..,n textboxes appearing above the "txtFeeder" TextBox on the form.The problem is that everytime you click the button, it doesn't add a new control, it seems to just update the one that has already been created with the new (incremental) ID. I'm not sure if I'm doing something wrong, or if what I'm trying to do can't be done (which I find hard to believe)?Here's the .aspx...
<form id="frmMain" runat="server">
<asp:Panel ID="pnlAdded" runat="server"></asp:Panel>
<asp:TextBox ID="txtFeeder" runat="server"></asp:TextBox>[code].....
Dynamic Creation Of Rdlc Reports?
Dec 16, 2010How can i add columns to rdlc report at runtime in windows based application using vb.net
View 1 RepliesDynamic Control Creation And Moving Of Those With Mouse?
Jan 22, 2012I am trying to make a program that will include a drag/drop view where you can arrange objects around in a view and add/delete objects as needed (objects are actually controls I create dynamically), I have made some code which I include below.If I run this code it works but not the part when I click on a newly created control, then mousemove function is not used, I should be able to move controls using the mouse functions..but these do not work. I thought code like:
AddHandler logicif(i).MouseMove, AddressOf logicif_MouseMove
should work! Can anyone give me pointers on what I am missing?
Public Class Form1
Dim logicif(20) As Panel
Dim count = 0
[code]....
Dynamic Creation Of Details View With A Web Panel?
Oct 27, 2010Every time i enter set of values like Group Name,Group Abbreviation,URL in the text boxes and click the save button automatically its saves in the database and for each set of values a new details view has to be generated dynamically with a web panel and the header of the web panel should have the value of Group Name.
Example:
[Code].....
A new details view with web panel like the above has to be generated every time the save button is clicked.
Dynamic Creation Of Picture Boxes, Buttons, And Labels For Each Item
Apr 7, 2011I'm currently working on a program where I'm trying to dynamically create a picture box, a button, and a label for each item in a text file. Any ideas on how to do this? What I have: a plain text file with a list of numbers. Each number corresponds to a location. When that file is read, I want to create a picture box, a button, and a label related to each number. If I want to add something to the screen, all I Have to do is add a number to the file. So, lets say the file has. 1, 2
When the file loads, it will create a unique item on the display for each location. say pic1, button1, and label1 and pic2, button2, and label2. Right now, if I add something to the file, I have to go back into the editor and manually add everything. Which is a pain.
Dynamic Menu Creation Not Working After Changing From VB 2003 To VB 2007?
Jul 12, 2009I have started a new blank project for VB 2007. I have taken the old code (VB 2003) and added it to the project.The line marked below worked on the old VB, now it does not. I get the following error:
Object reference not set to an instance of an object.
Troubleshooting tips:
Use the "new" keyword to create an object instance.
Check to determine if the object is null before calling the method.I have tried several forms of using the "New" keyword and still get the error.
Public Sub BuildChooseFileMenuItems()
Dim k As Integer
Dim numChecked As Integer
[code].....
Creation Date Column In SQL Table?
Apr 29, 2010What is the easiest way to automatically fill a datetime column in an SQL data table with the date the row was created? Using SQL Server 2005 if that matters.
EDIT: I've tried using GETDATE() for default and that works for an INSERT Query but not when the TableAdapter adds the row.
Table Creation Html Code Behind
Jul 22, 2011My question is a combination of VB.Net creating html code..No Google links to pointless areticles in languages that are not VB.NET, please. If you cannot code it yourself, please don't reply because it's so annoying to ask a question then get pointless, timewasting links just so you can get your points score up.I have a table which has 3 columns - nothing special just simple but its's the row number I am having issues with. Will explain soon.There is a directory with jpg files in it and the number of jpg files increased yesterday by 67, today by 37. Because the picture files come with any filename I have created a Windows app that renames the new files taking the ending point of yesterdays number as the starting point for today..So, each row holds 3 jpg files therefore 67 jpg / 3 = rows (yesterday). First number today is 68. I type 68 into the app I created, enumberating & moving (renaming) the jpg ('hduyhdgu.jpg becomes 68.jpg, suhdos.jpg becomes 69.jpg and so on for each of the new jpgs in that directory. That is done by the simple FileInfo/DirectoryInfo classes. Whilst renaming the photos in numerical sequence it has to write the html in the following form: [code] My Questions are:
1) How to sort out the row numbers so they flow in groups of 3 correctly and not 70, 71, 72, 71, 72, 73, 74, 75..?
2) How to create the table in code that dynamically draws itself with 3 columns (200px each done by CSS) wide and enough rown to hold every jpg in that directory? So, if I moved 5000 jpgs in that directory tomorrow the code will loop through and create the html.
3) If creating the table dynamically as in Q2 above how would I fix the place to draw it? Placeholder? A div is easy (<div 'id="MyTable" runat="server"></div>. In code behind: MyTable.InnerText=.../MyTable.InnerHtml=...) but is it the best idea? [code]
Passing Literals From Vb 2008 To A Dynamic Sql String In Sql Server Stored Procedure?
Jan 28, 2010In a nutshell, I am selecting values from a checked box column in a grid view. After checking the boxes I have a function that concatenates each customer number into a string called @CusList to use a parameter for a stored procedure Public Function SelectCusList()
Dim CusShow As String
Dim CusStr As String
Dim CusList As String
CusStr = ""
[Code]...
SQL Table Creation And Search For Specific Customer
Mar 15, 2012I am making a booking app in vb.net and I am using sql server as my database. I am confused about table creation. I have increment of 1 in customerid which is primary key in customer table. Suppose if a customer books a room and according to the increment id"1" is assign to the 1st customer. Now after some days same customer again comes to the hotel and books for a room. Now this time a different id would be assign to the customer according the the increment may be id"125".
What to do if I want to search the customer for how many booking has he done so far. Because there would be different id's assigned to the same customer as every time he walks in to book a room different id would be assign to him. And suppose if I make surname as my primary key than may be other people will have the same surname. How to solve this search problem for a specific customer for all bookings he has done so far. And if i give a unique id to customer my self suppose "cust1" than every time customer walks in he has to remember his id.
SQL Server DB Connection Class Creation?
Jul 22, 2011Trying to begin rewriting a VB6 application using .NET (as a Windows Forms app.) to get some practical coding experience.First hurdle is the best way to connect from VB.NET to typically various stored procedures in a SQL Server DB... I'm of course struggling a little along the way as well w/the difference in syntax and so forth, too.Anyone out there have an example you can point me to as far as typical blocks of code you use in calling to establish connectivity to SQL Server databases, populate SQLDataAdapter objects, etc?My assumption is that I need to create a connection object class and have everything in there and just call various methods of that connection object class whenever I need to connect to the database, retrieve data from stored procedures to populate fields on various screens of my app., close the connection to the database, etc.
View 4 RepliesCreation Of Remote Server Checking Tool
May 25, 2011I am new to Visual Basic (and programming in general) just wondering if there are any good tutorials on how to get my Visual Basic application to connect to a remote server.
View 8 RepliesInsert Columns In Between In Table In Sql Server 2008?
Jul 25, 2011I want to add or update columns using alter table if i am adding a new column i want show rror. I am using the code belowalter table Personal_Details alter columns DOB datetimef i uncheck the NULL to not NULL then it will shows column does not allow nulls; update fails;i want to insert the fields in between columns not at end.
Retrieve Data From A Table In Sql Server 2008?
May 9, 2009I am using visual basic 2008 and sql server 2008. I am trying to retrieve data from a table in sql server 2008. I am using the following code
Dim cn As ADODB.Connection
cn = New ADODB.Connection()
Dim rs As ADODB.Recordset
rs = New ADODB.Recordset
Dim cnstr As String
[Code]...
VS 2010 From Csv To Datagridview To Sql Server 2008 Table
Jan 11, 2012I am facing now a very frustrated simple project, I successfully imported .csv to datagridview using VB .NET 2010 but I have no idea how to import it to SQL SERVER 2008 specific data table.
View 7 RepliesVS 2008 - Add Data From Various CSV Files Into A SQL Server Staging Table?
Mar 18, 2011I THINK this should be a fairly simple fix, but my VB newbness is holding me back.I want to add data from various CSV files into a SQL Server staging table. Each CSV file has its own quirks as far as field names, more fields than the others, etc. go, so I'll need to map each CSV structure to the staging table in code.
[code]...
But it's no good, I get this error, "Input array is longer than the number of columns in this table." at "row.ItemArray = data".
Open A Table In SQL Server 2008 Table From VB Using ADO Error "Recordset.Open Fatal"
Dec 8, 2009I am a newbie and am trying to open a table in SQL Server 2008 table from Visual Basic using ADO and its throwing up a weird fatal error. The error message is:'A fatal error has occurred and debugging needs to be terminated. For more details, see the Microsoft Help and Support web site. HRESULT = 0x80131c08. ErrorCode: 0x0' The code I am running at the time is:
[Code]....
Select Excel Files And Import To SQL Server 2008 Express Table?
Jan 14, 2009Does anyone has a sample code that do like,Open and select excel file and select the exact excel sheet to import then connect to SQL server 2008 and append all the data from the certain sheet to the SQL table?
View 8 RepliesVS 2008 Dynamic Timer In A Dynamic Form
Feb 19, 2010Ive managed to dynamically create a form, and dynamically create a timer, but i have not been able to create the timer on the dynamic form. Specifically, i need to be able to have the timer itself create another form with a timer. (I realize that this would create a new form every interval on the timer, that is what i want to do)
1. A way to add the timer to the dynamic form, and maintain the timer sub on my main form.
2. A way to create the whole thing over (dynamic form and timer) through the previous dynamic form and timer.
I was thinking i could use a collection/array to store the forms and timers, but i'm still having trouble figuring out how to add entire forms or timers into a list. (A timer is not considered a control, so i cant use a controlcollection...)
Heres my code;
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim frm As New Form
[Code]....
*EDIT* Btw, my idea was to use i as a variable that increases every time a form is created, then insert the form into the array, with i as the integer. i just need to know how to create a new form with a different name each time. (as with timers)
How To Make Table Name Dynamic
Feb 22, 2011I am trying to create an autocomplete textbox using jquery which will be bound to SQL database. I also want to place a dropdownlist on the page so based on initial selection autocomplete textbox will retrieve data from different tables. It's an ASP.NET 2.0 page and code behind is VB.NET. I have AJAX autocomplete working but it matches only first characters and its not as robust as jquery. Can anyone share a sample code that will retrieve search data from SQL and also give me directions on how to make the table name dynamic?
View 2 Replies