Enforce Validation Rule In Create Table Statement For A Coloumn
Dec 15, 2011I want to enforce validation rule in create table statement for a coloumn. im using vb.net as front end and access as back end.
View 2 Replies
ADVERTISEMENT
MVC Data Annotation Validation Rule For Collection?
Dec 2, 2010Is there a dataannotation validate rule for a collection based property? I have the following
<DisplayName("Category")>
<Range(1, Integer.MaxValue, ErrorMessage:="Please select a category")>
Property CategoryId As Integer
<DisplayName("Technical Services")>
Property TechnicalServices As List(Of Integer)
I'm looking for a validator that I can add to the TechnicalServices property to set a minimum for the collection size.
Architecture - Apply The Correct Data From The GUI To The Parameters For The Rule And Execute The Rule
Apr 6, 2011I have a very simple Business Rules Engine that has only three methods. One gets all the rules for the current operation, one will retrieve a list of parameters for the rules, the last applies the rules. The rules are stored in the database as user defined functions using parameters. The client will call the BRE pass in the operation and a Lot Number and the BRE checks for any rules that apply to this operation for this Lot. The client gets a list of rules that apply (the names of the corresponding UDF's in the database) and at which step in the operation the rule applies. When the material gets to a step that has a rule, it calls BRE to get parameters for the UDF for that operation, fills in the parameters with data contained in the GUI and calls the BRE to apply the rule with this lot's specific data. Multiple lots can share the same rule that is why there are parameters for the UDF. This all works well. However, this is assuming we have a set number of rules for each lot at each operation. If the lot needs a new rule applied at this operation we have to add a new rule and corresponding UDF into the BRE database. This is not a problem, the client will now see two rules, however, it only knows how to apply the parameters for the first rule, and there is no code for applying the parameters for the second rule.
For example: Rule 1 states that only the same Lot number items can be put into a carton. So the UDF expects one parameter called LotID and one parameter called Carton ID. It runs the rule (UDF) with these parameters and checks to ensure the lots match. Now the Lot requires a second rule: Only 25 items can be packed in the carton. We create a new rule and corresponding UDF, but this rule has the CartonID and a quantity associated with it.
The GUI can handle Rule 1 because it knows how to apply the correct data from the GUI to the parameters for the Rule and execute the rule, so LotID from the GUI = LotID in the parameter name in the UDF and CartonID from the GUI = CartonID parameter name in the UDF. Now there is a new rule, the GUI sees this new rule, gets the parameters, but has no way to applying the quantity to the new parameter to execute the rule without having to change the GUI. We don't expect there to be many rule changes, however, when they do occur we don't want to have to recompile the GUI every time. Does anyone have any suggestions on how to create a class that could determine the how to apply set the correct parameters? We have thought about a table in a database that maps the parameter names in the UDF with parameter names in the GUI so when we add a new UDF we update the table with the corresponding data from the GUI. That could work but may get cumbersome and would require us to make sure that, that table is kept current. Another suggestion was to name the parameters in the UDF the same as the parameters in the GUI, but this too, would require us to maintain the names in two locations.
Create New MS Outlook Rule VB
May 5, 2012I'm trying to write a rule to compensate for laziness caused by program changes. Used to be, case numbers for family law cases where I work were written as follows: 12-DR-012345. Now, you can get away with 12DR12345, and the file management program accepts it.
View 1 RepliesAsp.net - Create A LINQ Statement Where The Table Name (FROM) And Column Name Is Variable?
May 11, 2012In my programming task I've gone down a dark alley and wished I hadn't, but there is no turning back now.
I'm building up a SQL statement where the table name, column name and id value are retrieved from query string parameters i.e. ("SELECT [{0}] FROM [{1}] WHERE [Id] = {2};", c, t, id)
But it isn't as bad as it looks, I'm protected: Only authenticated users (i.e. signed in users) can execute the Page_Load I'm checking that both the table and the column exists beforehand (using GetSchema etc.)I'm checking that the Id is an integer beforehand All my tables have Id columns The database connection is reasonably secure
[Code]...
Import Or Create An Outlook 2003 Rule (.rwz) With VSTO 2005?
Jul 29, 2009I would like to automatically create an Outlook rule (move email containing something in subject to folder xyz) but dont know how to achieve this. Of course I can create the rule and export it to a .rwz file. This file can be imported manually, but how can I import it automatically?
Can I import a rule through my VSTO 2005 Outlook (2003) Addin? Or can I create the rule from within this addin?
Creating VB Code To Increment The Number Of Fields In An SQL Create Table Statement
May 8, 2012I have an SQL statement which i need to code in vb:
CODE:
Notice the fields prodno1 and prodno2 in the table structure.. this is part of a number of sql statements i need to run and put inside a loop. my problem is i want to automatically use this same code such that on the next loop, this sql statement is going to be:
CODE:
Note that in this "2nd loop"
- the table name is now r3 from r2 in the first SQL statement
- there are now prodno1, prodno2 and prodno3 instead of just prodno1 and prodno2
- in the WHERE clause, the p.prodNo becomes p.prodNo2
And so on and so forth.. so for the 3rd loop
- there's going to be r4
- there's going to be prodno4
- in the WHERE clause i will use p.prodNo3
Using Integer.TryParse For Validation An If Statement
Jan 26, 2012this is for homework but I have 90% of the project done, I just need to finish the data validation portion of the code. This is what I have for the calculate click event:
[Code]...
Using Integer.TryParse For Validation An If Statement?
Feb 12, 2012this is for homework but I have 90% of the project done, I just need to finish the data validation portion of the code.This is what I have for the calculate click event:
Private Sub btnCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click
Dim intInputA As Integer
Dim intInputB As Integer
Dim intInputC As Integer
[code]....
My Problem: I am using the Try parse to validate weather the inputA(B)(C) is an integer or not, if it is an integer, i want it to move to the nested if and validate that it is a positive number, and show the error message in the label if it is not. If it is not a number at all i want it to show another message in the label. The problem that I am getting is that even if i put in a letter for the input it does not catch it and it continues on to the select case, which comes out 0.
Create A Authentication Rule If I Use Separate Login For Two Folders Say Admin Folder And Vendor Folder
Feb 9, 2011I have the following directory structure in my asp.net webdirectory i want when any body access anypage inside my admin folder then it auto redirect to login page of admin folder until they login
View 1 RepliesHow To Enforce Hour Format
Jul 27, 2011I am using a textbox in vb.net but the input should be an hour format for example, "13h30". How can I enfprce this by a user? When he puts the first 2 digits like 13 then automaticly the appl. puts a "h" between?
View 1 RepliesValidating A Datagrid Coloumn?
Dec 15, 2011validating a datagrid coloumn..,i want only alphanumeric values.,symbols like -,+..etc were not allowed..folliwing is the code wht i have.,but it allows only alphabets but not numerals.
[Code]...
Declarative - Enforce Type Alias In .NET?
Apr 6, 2012How might one go about aliasing a type in VB.NET or C# such that when the alias is used as an argument type in a function, accidentally using the not aliased type is an error?
i.e.
Imports AccessSpecifier = System.String
Module Accessors
Delegate Function IoOper(ByRef strm As System.IO.Stream) As Action
[code]....
Overall, I'm wanting the IDE to force me to know what I'm doing if I'm throwing Ints around to mean Flags, or States and Strings around to mean Names, Propertys and Records.
Edit Coloumn 2 Of Row 0 Of SSCE 3.5 Database
Dec 3, 2010I just need to edit coloumn 2 of row 0 of SSCE 3.5 database.I am using following code.It generates no error but database is also unchanged.[code]
View 1 RepliesVS 2005 Pick Data From Other Table Using Key Press Validation?
Apr 7, 2011I am newbie in VS 2005 and started learning. Can you please tell me how to Pop up the data from a table when there is a key press in the textbox.
View 11 RepliesGridview Show And Hide A Specific Coloumn?
Jan 6, 2012I have a Gridview in which a specific column of name "Date".I have set the Visible Property of Column to false because i want to show on different conditions of page.Please tell me how can i do it using vb.net that my Date column should show or hide on runtime
Update
My current code is
If Not Page.User.Identity.Name = "bilal" Then
GridView1.AutoGenerateEditButton = False
GridView2.AutoGenerateEditButton = False
[Code].....
Enforce Case Sensitivity Of The Names Of Files In A Project?
Dec 14, 2009Is there a way to enforce case sensitivity in VB.Net file-names?
The primary issue that I am trying to solve is the difference in how Windows doesn't care about the case of a file-name, but other tools, like Subversion, do care about the case of a file-name
VS 2008 DataGrid - Check Box Ticked Would Like Date To Appear In The Next Coloumn .Net?
Feb 28, 2012I am new to VB.Net and am just learning.. I have a DataGridView in a winform project and have two columns "PO_Created", "PO_Date" (PO_Date being a check box) I would like to know how to have PO_Date populate a date when the check box is ticked.Dragging a check box and a text box on the form and placing the code below in the checkbox control
If CheckEdit1.Checked = True Then
TextBox1.Text = System.DateTime.Today.ToShortDateString
Else
TextBox1.Text = " "
End If
is what I want but I don't know how to do this in a datagrid if someone could give me a hand on this topic that would great.
Create A Program That Asks For Input Then Uses An Else Statement To Create A Handling Fee Balance
Nov 30, 2011To create a program that asks for input then uses an else statement to create a handling fee balance.
Input: sales record - first name, last name, purchase amount, balance before purchase
Output: report - full name, old balance, purchase amount, handling fee, new balance
Definitions: handling fee is 5% of the old balance if the old balance is less than $1000.00 else it is 2% new balance = old balance + purchase + handling fee
Processing:
Ask for and receive sales information
Calculate new balance
Print output report
End the program when a purchase amount of 9999.99 is entered
Why Does Every XML File Create With .net's XMLWriter Fail W3C Validation
Feb 16, 2012The W3C validator tells meLine 256, Column 12: non SGML character number 0Both errors occur at the very end of the file.
Here is my abbreviated code:
dim writer as XmlWriter
dim xmlSettings as new XmlWriterSettings
[code]....
Create FK To Model, From Aspnet Forms Validation Tables
Jan 17, 2012I've recently created a MVC 3 ASP.net application (using VB). I have also created forms validation by running aspnet_regsql. I used this to create the table in the same database as my application uses. I am trying to work out how to create a new model, with a FK from the Users table. Do I have to reverse engineer the validation tables to create models in my application? right now, the tables only exist on the SQL 2008 database, as they were created by running the aspnet_regsql command, and do not exists as models in my ASP.net solution. Here is the code I have now, for a model I would like to add a FK to (as a one-to-many relationship):
Imports System.Data.Entity
Imports System.ComponentModel
Imports System.ComponentModel.DataAnnotations
[Code]....
Avoid Create/drop Table Scenario With A Perm Stage Table?
May 10, 2010I created a function that creates a global temporary table to stage data from a excel sheet I need the table to persist for me to map the columns using a form. The table is still there when the code goes back to the sub that calls the function until I call the form where I do the mapping. I am trying to avoid create/drop table scenario with a perm stage table.How can I get this table to persist until the data gets loaded into the perm table?
View 8 RepliesCreate Table Button Which When Clicked Creates A Table In Sql Server?
Sep 17, 2009I am working with a Vb.net 2005 application. On the application I have a Create table button which when clicked creates a table in Sql server with the code shown below;
Code: Private Sub BtnCrtTable_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnCrtTable.Click
[Code]...
This is really a pre-defined table and the data is already specified to be inserted to the table. However, my primarily task is to read a flat file which has the data and consider the first line as the column to be column names.
Therefore, initially I created an open dialogue to browse for the text file and store the path such as E:Datafile est.txt, in a TextBox1 visible at run time. Now the task is to change the above "create table" to read the txt file (column names are on the first line) and then create the table in the database.
How To Merge Two DataSets On Specified Rule
Apr 13, 2010I'm trying to merge two datasets based on these rules:
1. With ds1 and ds2, If the Unique Key from ds1 is not found in ds2, copy it to ds2 and move to next row in the table, else, goto the next part
2. If the unique key in ds2 is found in ds1, check the DateLastEdited row.
a. If DateLastEdited in ds2 is greater then in ds1, copy the row from ds2 to ds1, else , do nothing
I'm just having trouble with the loops. Here's what I have:
Dim ds1 As DataSet = fillNetwork() 'this function fills ds1 with the dataset from a table found on a network
Dim ds2 As DataSet = fillLocal() 'this function fills ds1 with the dataset from a table found on local drive
Dim returnRows() As System.Data.DataRow = Nothing
For Each dtDs1 In ds1.Tables
[Code] .....
This bit of code is just trying to segregate the one that are in both tables from the ones that are just in one table.
Check An If Statement In A Table Or Database?
Jan 1, 2011Is it possible to check to see if the text in a textbox is present in a table/database and then display the corresponding data.
View 2 RepliesUsing A Case Statement With An Int Entry From A Table?
Apr 15, 2011What is the best way to compare an Int entry from a table in a case statement?Using SQL server 2008 R2, Visual Basic Express with LINQ to SQL.The code I tried doesnt work:
Private Sub UpdateSetOpt()
Dim db = New ACEDataContext
Dim SRM = From q In db.Settings
[code]....
Avoid A "table Nested In Span" W3c Validation Error With Aspx Page?
Mar 4, 2010I am trying to make my site fully w3c validator compliant.
At the moment, I am getting an error because a table which is generated programatically and insterted into a label's text attribute shows as a table nested in a span tag.[code]...
Applying A Rule Set To Different Lines Of Text?
Apr 27, 2012The general purpose of my application simply reads a line of text for example:
1. I have a printer issue
2. I have a software issue
I have a rule set as follows:
'Define the class 'Printer' with 14 values as a string...
Dim Printer(13) As String
'The string 'Printer' gets assigned a value, this is repeated another 13 times...
Printer(0) = "Printing"
[code]....
The code simply uses a number of keywords to detect if the issue is a 'printer', 'software', 'telephone',. or 'password' problem.I want to apply this rule set to 10 issues within the same rich text box, with the results sent to a text file. The exporting to a text file I can do, however the main issue is, i cannot read the lines individually.
Asp.net - Subdirectory URL Automatic Rewrite Rule?
Apr 25, 2012I'm using ASP.NET 4 / VB.NET / IIS to build a web application. Folks will access the web application via a URL like so: [URL] So, for example, here is the urls for Jane Doe, John Doe, and James Doe respectively: [URL] I need to somehow pass them off (no matter what name is entered) to a default.aspx page which then pulls in the name portion of the url and uses it to perform a lookup against the database which contains info. about this particular person and displays a personalized page based on that information.
[Code]...
VS 2010 Check First Rule (not Line) In RTB?
Mar 5, 2011Let's say I have a rtb with a few lines.
line1: (empty)
line2: (empty)
Line3: "blablablablabla"
Line4: ..... etc
How do I get/read the first, only the first line? ("blablablabla")