Asp.net - Update Linq To Sql With Variable Names?
Apr 15, 2012
im pretty much a beginner to using ASP.net and linq to sql but what im trying to do is update a column of a table based on a variable. at the momment i have
Dim db As New sqldcDataContext Dim update As tableName = (From i in db.tableNames _ Select i)
i think this selects everything, how could i have two variables, one to store what table to update and the other what column. is this possible?edit: sorry for being unclear im trying to make this as dynamic as possible so i dont have to type in the exact table/col names. something like this but in the linq to sql syntax.
mysql_query("SELECT * FROM ". $table ." WHERE `" . $column . "` = "" . $data ."");
View 2 Replies
ADVERTISEMENT
Nov 17, 2009
I'm quite new to Visual Basic - using Visual Studio 2008 and can't seem to find a way to do the following:
I have a few tables in a SQL Server database and have used LINQ to SQL to create classes of those tables.
Here's a cut down example of what I'd like:listbox1 filled with table names - APS, SMPS, WCPC, CFLAPS
Then from the SelectedIndexChanged event, listbox2 should populate column headers of the selected table.
I have no issues getting data from the database, and can access all of these headers through the anonymous type objects created from a LINQ query (eg APS.ID, APS.count etc), but populating a listbox with these variable names rather than the data inside them seems rather elusive.
This is probably a cross platform coding question rather than VB specific, so if you have a solution in C# or whatever I'd be happy if you could let me know.
View 2 Replies
Sep 5, 2011
I am doing work for a client who has lost the source code for one of their VB.Net WinForms applications. The assembly they have is not obfuscated at all. I am trying to recover as much of the source as I can as C# source and have tried several tools for decompiling assemblies, including Reflector, ILSpy and JustDecompile (all the latest versions), but they all produce code with a huge number of errors in them. Because of the large number of errors in the generated code, I am going to ask about the specific errors (in different questions), get more directed answers and in this way try shed some light on why all the tools are having difficulty decompiling this assembly. This question pertains to the fact that the code generated by all these tools always have a large number of invalid member variables (fields) such as the following:
private short $STATIC$Report_Print$20211C1280B1$nHeight;
private ArrayList $STATIC$Report_Print$20211C1280B1$oColumnLefts;
private StaticLocalInitFlag $STATIC$Report_Print$20211C1280B1$oColumnLefts$Init;
why the generated code has these invalid member variables?
View 3 Replies
Feb 2, 2011
I am using LINQ to SQL queries to return data in my application. However I find it is now needful for me to return the column Names. Try as I might I have been completely unable to find out how to do this on the internet.
So if my LINQ entity table has the properties (Last_Name, First_name, Middle_Name) I need to return[code]...
View 2 Replies
Nov 5, 2010
Public Sub UpdateStaff(ByVal sr As StaffRecord)
Dim oldSr As StaffRecord
Dim q = From staff In db.StaffRecords Where staff.Employee_Number = sr.Employee_Number Select staff
oldSr = q.First
oldSr.Address_Line1 = sr.Address_Line1
[Code]...
The helper function I have written seems to do everything I want apart from update the db. Stepping through the code, the oldSr is updated by the new sr parameter but no update on submit changes.
View 2 Replies
Apr 29, 2009
I am looping through a collection of items. Within that loop I need to set variables but they need to be a variable. I tried using lists but for some reason they don't get set properly. Heres what I have so far...
[Code]...
View 1 Replies
Aug 13, 2010
Given the following code:
try
// code1
try
[Code]....
Are there any side effects to naming the two exception variables the same or should they have different names?
View 2 Replies
May 20, 2010
how do I DIM a variable's name using previously declared string varialbes? I have been using PERL for processing data stored in text files but I now have a business need to use VB2008. I would like to do something like this:
dim name1 as string = "ABCD"
dim name2 as string = "123"
'here is the part that I don't know how to do - create a 3rd variable name concatenated from name1 and name2:
dim string.concat({name1,name2}), or maybe use a counter in a line like 'dim namex as string' with x being a counter value.
Essentially I want to dim variables using text strings extracted from a file. In PERL I have declared literals and arrays, such as 'my @$name1', which creates an array named with the contents of $name1. In VB2008 I am not sure how to make this work with the DIM statement.
View 5 Replies
Mar 29, 2010
I'm trying to reduce as much as I can my VB.Net assembly side, and I just figured out that all variable names were kept unchanged in the actual assembly. Since I tend to use pretty long var names, it adds up and, by running dotfuscator on my assembly, I could shrink it by as much as 10%.
[Code]...
View 2 Replies
Feb 8, 2011
Is there a way to use Meta Tales or Table names to Construct a dynamic query in LINQ?
foreach (var metaTable in db.Mapping.GetTables())
{
var queryType = metaTable.RowType.Type;
[code]....
Is there a way to do something like this? The attempt above yields the error:Could not find an implementation of the query pattern for source type 'System.Data.Linq.ITable'. 'Select' not found. Consider explicitly specifying the type of the range variable 'q'.
View 2 Replies
Jan 9, 2009
Trying to understand the best way to do this and I'm can't get it figured. Here's basically what I have:
Public Class CardParsingClass
Private iAcctIDStart as integer
Private iAcctIDLength as integer
[code]....
I've only included 2 of the class level fields here but there are actually 30, so that's why I was hoping to be able to send the name of the field to set and the value to set it at in the SetValue function. So in some other routine in the program I'd like to be able to issue the following call:
SetValue("iAcctIDStart", "3")
But then when I get into the SetValue routine, I'm not sure how to proceed. I thought about a case statement that would basically be this:
select Case strFieldToSet
case "iAcctIDStart"
iAcctIDStart = cint(strValue)
[code]....
View 5 Replies
Jun 10, 2011
I'm using a Microsoft Word form template to create objects in a form programatically, so depending on the information read by the program from the template.
So, I've got some fields where I store formula data for the form, in which I specify that the value for that field is obtained by multiplying other fields in the template. So I store in the string something like this:
"Text1.Text * Text2.Text"
So I need to convert these string values into variable calls to actually operate these values.
View 2 Replies
Dec 7, 2010
I'm looking to create multiple variables based on a counter object. For example if a counter object is 6 I want to create 6 instances of the variable mText
Something like:
Dim i as integer
Dim Count as integer = 6
[code].....
View 1 Replies
Sep 30, 2010
Is there any way to access your variable names at runtime? Is there any kind of collection you can loop through?
View 2 Replies
Aug 12, 2011
this website seems great and this is my first post. Sorry if this has already been answered but I have been searching for a long time. I have a program with a list view in details mode. I have it load column settings (visibility, display index, width, etc.) when the form is opened and save them when closed. There are many columns...about ten so far...like folder, file, size, etc. Is there a way to access variable names from the values of other variables?
[Code]...
View 3 Replies
Nov 4, 2009
I posted in the Database development forum, but no bites. I have field names in my Access table which have a number as the first character (i.e. "2x2"). Evidently, the DataAdapter doesn't like this. I'm able to view the data in a DataGridView, but I get an exception when I use DataAdapter.Update.
Can I modify my sql statement to make the command builder work or do I have rename the fields?
For example:
"SELECT [2x2] as twoBytwo..."
Changing the names of the fields would be a huge pain-in-the-arse!
View 6 Replies
Feb 1, 2011
I am working on a project where my class has to execute VB code provided by the user, to make it simple I am trying to recreate my own eval function, I am using the following code I found on the web to do this task.
Imports Microsoft.VisualBasic
Imports System
Imports System.Text
Imports System.CodeDom.Compiler
Imports System.Reflection
[Code] .....
The problem with code is that it can't access any variables or there values, so I have decided to get the variable names, there values types and there types dynamically and recreate them in the class that is being created dynamically. Any way to get the variable names there types and values in the current class or method, so that I can recreate them, and execute the user passed code, the user knows what variables are in the current class or method and there datatypes but he don't know there values as they may have changed, so he can't initialize them. Is there a way to do this, this code will be called in an asp.net page on page_load event, the code passed by the user is stored in the variable vbCode that is passed as a parameter.
View 2 Replies
Aug 13, 2009
I am upgrading a VB6 to VB.NET project using the upgrade wizard.I know this is going to give me a lot of grief, but I am trying to make the old application useable. I'd rewrite it if I had time but am currently finishing up a summer internship and would like to get something working.One thing the wizard is doing that I can find no justification for is renaming of random variables. [code] For the life of me I don't understand why this is changing left. It isn't a reserved name as far as I can tell, there is no other variable named left that I can find in scope, and renaming it does not create a compiler error. [code] It does this to seemingly random variables throughout my project. Anyone have ideas as to why it doesn't like some of my variable names?
View 3 Replies
Nov 17, 2010
I'm playing around with Linq and XML and came across a need to update an XML node. Below is my code to read the xml, my question is, can I edit the xml source that I have loaded in to memory (from file) and save it?[cod]e...
View 1 Replies
Dec 17, 2010
Im trying to update the "value" Attribute of some xml file that have this structure:
<app-settings>
<setting name="codeBasePath" value="E:data" />
<setting name="server" value="LOCALHOST" />
[Code].....
View 6 Replies
Mar 25, 2009
In LINQ, I'd like to project different names than those from the database tables. "Friendly names" that I can use for column headers. Names that have "%" or possibly a " " (space). The query below won't compile.
Is something like that possible or am I stuck using the dreaded _ underscore for everything?
CODE:
View 5 Replies
Oct 28, 2010
I want to declare a variable to hold the query result from LINQ to SQL like to the following:
Dim query As IQueryable(Of Student)
If isNoUserName Then
query = From st In db.Students _
Order By st.AssignedId Ascending _
[code]....
Return query
Error : conversions from 'System.Linq.IQueryable(Of )' to 'System.Linq.IQueryable(Of Student)'.
How do I declare variable "query" to hold both data from "Student" and "User" tables?
View 1 Replies
Feb 1, 2010
[code].....
View 4 Replies
May 24, 2012
I am trying to run this line of code: Dim OrderedFiles() As String = Directory.GetFiles(FilePath).OrderBy(x >= x.CreationTime)
I get an error on x saying x is not declared. I have my project set to Option Strict Off and Option Infer On. If I turn ON Option Strict then I get thousands of errors from the project(it is inherited) and I don't have the time to fix all of them, but x no longer gives me an error. I have googled until I want to throw my computer out the window.
I was hoping for a more elegant solution but here is what I came up with to solve this particular problem.
[Code]...
It is not particularly elegant but it does the job. I was hoping for a one liner LINQ solution and I just don't have the background in LINQ to know how to do the job, time to go buy a book.
View 2 Replies
Jan 24, 2011
how to store multiple variables in a single one to be stored in string?I have some 5 linq variables which am trying to store in a single string...Can you tell me how should i do so?
View 3 Replies
Aug 28, 2009
Dim mYVariable = From C In dtXMLConverter Select C I am using the above mentioned syntax for getting the rows in the variable named "mYVariable" after issuing the from clause when I am moving my mouse cursor on the variable name, it is showing "Dim mYVariable As Object" instead of showing DataRow or something like that. I can't understand how to solve this problem.
where dtXMLConverter = DataTable
View 2 Replies
Sep 21, 2010
discovered the compact mode of this instructions vs usual code. I found sample code for selecting, etc. from a datatable, transforming a column in a list or array - all operations are "Select"s - readonly.I need to make an simple update on a certain rows (using LINQ) from a DISCONNECTED datatable for which now I'm using this
for each dr as datarow in dtable.Rows
dr("MyField") = 77
next
[code].....
View 16 Replies
Aug 1, 2011
I need to update a datatable using LINQToSql. Option Strict is ON. Datatable name is Customer with fields customerID, customerName, SalesID. I need to update rows with SalesID = -1.
View 1 Replies
Mar 15, 2010
I'm editing XML element with the following XML:
<?xml version="1.0" encoding="utf-8"?>
<!--Test XML with LINQ to XML-->
<LabSerivceInfo><LabService>
<ServiceType>Copy</ServiceType>
<Price>1</Price></LabService>
[Code] .....
How to update the ServiceType and Price where ServiceType = varServiceType?
View 2 Replies
Mar 9, 2012
I am a bit new to linq, I am only using linq for filtering the data. [code]...
Con.Numbers is a dictionary, but now I converted it into a list, hence the above code wont work with list[code]....
View 2 Replies
