Reduce Code By Using Dynamic Queries?
Jul 3, 2011I use the following code to fill the Table1 dictionary with the information found within the LINQ query.[code]....
View 2 Replies
ADVERTISEMENT
LINQ. Reducing The Code By Using Dynamic Queries?
Feb 17, 2011I use the following code to fill the Table1 dictionary with the information found within the LINQ query.
Dim DB As New DatabaseDataContext
Dim Table1 As New Dictionary(Of String, Integer)
Dim Table2 As New Dictionary(Of String, Integer)
[code].....
Dynamic Bind Variable Queries Using Properties Looping?
Feb 8, 2012I have a class with properties in it . The properties in it are all named the same with the columns names in the database.The reason for that is that i want to loop through all the properties within the class and dynamically create an sql query with the parameters in it . Then dynamically create the parameters and add them into the oraclecommand , everything works well until one of the properties ( QTY ) is set to 0 . When it is set to 0 , during the properties loop ,it will check it as nothing and bypasses the QTY property , with that i am missing one of the columns.class with properties , Notice the property Qty it is Nullable(Of Integer) , it is because when inserting data into the database , sometimes i would want it to be null instead of default 0 .
Public Class HDB
Public Property BONum() As String
Public Property Owner() As String
Public Property Qty() As Nullable(Of Integer)
[code]....
[2008] Dynamic LINQ Queries And Select Statements?
Jun 5, 2008I've recently ported my website from 2005 to 2008, and I'm using LINQ Queries to implement a search. The issue is that none of the fields are mandatory, so I've had to implement a dynamic LINQ Query (sic?). Here's the relevant code -
Public Function searchQuery(ByVal titleType As String, ByVal titleName As String, _
ByVal configMgr As String, ByVal lifecycle As String, _
ByVal CIType As String, ByVal recordsPerPage As String) As IEnumerable(Of
[code].....
Way To Reduce My Code
Feb 15, 2010I am creating a windows mobile application .I have an extraordinary amount of if/else statements, I have tried the switch/case statement [code]...
View 1 RepliesWay To Reduce Lines In Code?
Jan 25, 2010I have a school project. by selecting an item from combobox it will show 2 pictures and 2 labels. I used a select case first but it didn't work; only for the first item ;do i have to make every pictures and labels invisible which are 30 controls and repeat it in every index? I try the if else but it did not work too.[cod]
View 4 RepliesReduce My Form Validation Code?
Nov 24, 2010I have almost 15 forms in vb.net 2005, and i have to validate all them, i am using this [code]...
and is working properly but on each form there are 10 to 15 textboxes, maskedtextbox etc so if i place this code on every textbox so it will be a thounds lines of code? so please assist me that how do i write this code shortly for all forms's textboxes.
Reduce This Code To A Single Procedure?
Jan 16, 2012I am relatively new to the whole .NET thing, coming from a VB classic background.On my form I have a tabcontrol, with 4 tabs. Most of the code is handled using a shared handler, but for the others I have to write a handler for each.How can I optimize these routines into a single procedure?
Private Sub cboCalc0_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboCalc0.SelectedIndexChanged
'Page 0
If (Not (IsNothing(trvSignals0.SelectedNode)) And txtSignalName0.Enabled = True) AndAlso trvSignals0.SelectedNode.Level = 3 Then
[Code]...
Reduce Code For Displaying Data In Textboxes?
Mar 10, 2011On the page I have created I have a search facility that if a doctors number is searched it will bring up the doctors details, once search button is clicked the results are displayed in textboxes (I cannot use gridviews because this is not wanted)sample of code placed on the search buttonQuery statement = "SELECT DocNumber FROM tblDoctor WHERE DNum LIKE '%"execute the query and get the resultThe result is converted to string and Execute Scalar is usedDocNum.Text = Result1
Query statement = "SELECT DocName FROM tblDoctor WHERE DNum LIKE '%"
execute the query and get the result
The result is converted to string and Execute Scalar is used
[code]....
.net - C# To Code Converter - Reduce The Amount Of Copy/paste
Aug 29, 2010I need a C# to VB.NET code converter, I want something that's ultra convenient, as I want to reduce the amount of copy/paste that I have to do... so could anybody give me some tips to what is out there? I want processing in bulk too, and to support the latest operations (LINQ, new VB inline-function support and all).
View 3 RepliesLINQ Queries - Combine The First 3 Queries Into A Single Query And Place In A List?
Jan 6, 2010I am writing a message system on my server, the xml is something like this
<xml>
<entry>
<sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
.net - How To Write Dynamic Code
Sep 11, 2009For example i got a class and its got its own properties and i am passing the name of the class and the name of the property to be called to a function Say for example exp is the variable which i am passing which contains a value = "ClassA,Property1"
Function Property2BCalled(byval exp as String)
dim classname = split(exp,",")(0)
dim propertyname=split(exp,",")(1)
dim value= classname.propertyname
End Function
I wanna do something like that,given above.
Getting The Dynamic Code Execution?
Aug 23, 2010i'm building a basic server program that I want to recieve commands and execute them sent from a client program and I'm using my home network to test it out. I've got no problem with the communication between the client and server programs and have used a simple Send Text function to communicate to the server program which simply brings up whatever text was sent in a message box.
I've decided that constantly updating the program and transferring the new EXE file just doesnt work as I have to keep starting and stopping the server program to do that just to update the list of commands it recieves. So say for example I've got a button on my client program that tells the server to open the cd-rom draw on that computer, it sends this in the form of simple text openCDdraw" and when the server recieves this, it pops open the cd draw and so on and so on... but I thought a better way of doing this may be to say have the commands listed in a SQL database and when the server recieves a message it searches through the database to find the correct command and executes the code associated with the command.
Now I can retrieve the information fine in to a string variable ("Dim a as string, a = dr.getvalue(3)") but where do I go for there? This is the problem see. My apologies if I've gone a bit long winded on this one but thought it necessary to explain what I'm doing. I've heard of dynamic code execution but when I tried a project I found on the internet it had been coded in C# and I don't know any C nor do I want to as I'm a VB veteran and have updated myself with the way of .NET now so am not going to start all over again with learning C. Does anyone know of an easier way of doing this? Static code is so easy to do because it is typed straight into the coding sections and I had already thought about creating loads of subs/functions to execute each command but again that involves updating the EXE file every time so there must be a better and easier way of doing it.
Can I also just point out that this little project i'm working on is not for a TROJAN or whatever that old NETBUS program used to be called, it is simply so I know how to do it and can use it for other things that I'm working on and through. Also I'd just like to know how to retrieve and execute code from a database or text file.
Code For Dynamic Control Events?
May 3, 2011I have never dealt with dynamic control events before. I have a variable number of a controls each created at runtime. However I don't know how to code events for each control as they should do different things. I've looked at WithEvents and AddHandler and know I have to use Sender however not sure how to use /where to put eg. MouseEnter 1 panel when there's several.
View 5 RepliesChange This Code To Make The Factory Dynamic?
Feb 12, 2011How would I change this code to make the factory dynamic. I believe I was close with remoting. I don't want any hardcoding of the factory, nor do I want to have to recompile. The database drives it.
Dim genericRule As Rule
Dim factoryObject As String
factoryObject = _dal.GetFactoryObject(ruleId)
[code]....
Include Dynamic Code Which Was Easy In Classic ASP
Jun 8, 2010I've got an ASP.net file, and I'm trying to include dynamic code which was easy in classic ASP. Here is what I have tried so far:
[Code]...
Asp.net - Convert Below C# Dynamic Data Context Registration Code To VB?
Aug 8, 2009[code...]
In particular the MetadataProviderFactory Line... I can't quite seem to figure out how it should look in VB.
Finding A Sample Code For .net Dynamic Dashboard Applications?
Aug 15, 2011I am looking for sample code for vb.net Dynamic Dashboard applications? i want the code in vb.net which will be my front end and sql will be my back end for database?
View 2 RepliesGenerate A Code With 2d-dynamic Array To Make A Matrix?
May 7, 2010i want to generate a code with 2d-dynamic array to make a matrix?
View 9 RepliesCreate Dynamic Html File From Code Behind And Open In A New Window
May 23, 2012I'm letting my users write their own HTML from my webpage. When they click the preview button, my code behind needs access to controls on the page (and so I understand I can't use a web method here). It builds the HTML and saves it as a file on the server. My question is: Once the file has been made, I want to automatically open the file in a new window for the user to see their handy work. I'm using vb.net, but happy to receive c# answers.
[Code]...
Error On The Code - "Dynamic SQL Generation For The UpdateCommand Is Not Supported Against A SelectCommand
Oct 8, 2009I have this code that I have found on the net and I run but there is error that says "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.". May I know what is the problem?
Here is the code that I get from the net:
CODE:
Dynamic Control Called From Vb File Code Raises Object Reference Error
Jan 7, 2010In a ASP.NET app from a procedure IN a VB code file a dynamic control is called. The first problem may solve the second. In the following line of code I am getting an "end of statement expected" error at the following line.
[Code]....
Access Values Of Dynamic Controls Added To Dynamic Tabpages?
May 8, 2011i have created a dynamic tabpage and a dynamic tablelayoutpanel inside it then added dynamic textboxes and labels inside the tablelayoutpanel...the thing is , i am having a problem on how to access the value of those textboxes and labels and add them as new columns in the new table(tagpage) in mysql database, i can already create the table in the database but i cant add the new columns in it. heres the code for accessing the values of the labels and textboxes
error: NullReferenceException was unhandled....Object variable or With block variable not set.
sql = "alter table " & tbl_selected(counter) & " add " & frmMain.Controls("TLP_" & SecArrList_sp(counter2)).controls.item(SecArrList_sp(counter2) & "label" & counter).Text & " varchar(100) NULL;"
Dynamic LINQ Query Based On Dynamic Number Of Comboboxes?
Feb 5, 2010I would like to bind a DataGridView to a different LINQ query every time (in order to reuse the same form/DGV for different queries), like this:
[Code]....
but the "Qry", and the number of comboboxes, and their field names would change every time.
Any Way To Reduce Opacity Of Form?
Jan 28, 2012Is there anyway of reducing the opacity of a form to 80% but at the same time have my buttons and text boxes to remain unhindered at 100%? When I reduce the opacity of the from the opacity of the text boxes reduce as well. How could I stop this from happening
View 5 RepliesHow To Reduce File Size
Mar 3, 2010how to reduce file size? for example : i have a video file that size 13MB now, i want to make the video become 500kB even if the video become shorter thant the original. because i just want a little size of it.
View 6 RepliesHow To Reduce The Size Of An Application
Feb 23, 2009I have a system in VB.Net 2003, and that system takes a very long time to load. From the minute I click on the EXE, it takes one minute before the log in screen appear (P4 with 1GB RAM, no other application running). The size of the EXE is 33.2MB. I think the problem is the way I code the program, 1) I declare all the form as obj when I first load the system and I've got over a hundred forms. I try to load them as I need them but it does not work cause forms with sub form would give me an error. 2) I am using dataset as we know dataset is not very efficient but I don't know how else to connect to the database. Is there anything like ADODB in VB6?
View 2 RepliesNeed To Reduce An Amount Of Time By X%
Sep 7, 2009i need to reduce an amount of time by x% this is what i have so far [code] as u can see ive taken the hours minutes seconds from the time and stored each in a seperate variable so from 02:30:00 i then divided the hours by 60 and then 60 again to give me the total seconds in the hours and then divided the minutes by 60. i then added all 3 to give the total amount of seconds so now the buildtimetotal variable now holds the total in seconds i now need to reducce this by x% all vars are dimentioned as integers except for buildtimehoursback which is a double the problem seems to be when i try to convert the total seconds back to hours minutes seconds.
View 3 RepliesReduce Int To 1 Decimal Place?
Apr 17, 2009I'm using the code below to convert the file size in bytes (test file is 31718 bytes) to KB (30.974609375 KB) but I want to display this to one decimal place (i.e. 30.9 KB). How would I do this in VB.NET?
View 3 RepliesReduce Size Of A Pst File?
Apr 16, 2010Is there any way to reduce the size of a .pst file using Microsoft.Office.Interop.Outlook(programmatically start PST Compaction)?
View 1 Replies