I face a problem that if i make a datattype in sql server of Integer and then use it in linq to sql query it give error of "specific cast not valid" and when i change datatype into varchar the linq to sql query work fine one more thing how to use linq to sql query to make crystal report?
View 2 RepliesI have worked in web application. we are using asp.net and vb.net. In vb.net, we are using int16 and integer. I want to know what is the difference between int16 and integer datatype?
View 4 RepliesWhy doesn't CDate(integer) work where integer has format of YYYYMMDD ?and why won't this stupid site let me submit such a short question when I have nothing else to add except some waffle at the end
View 2 RepliesI have a LINQ2Entity problem, I want to get the value, string, from a database, so I select FProducts.Serial_number, and to end the query, I do .ToDictionary. The problem is, it tells me that it doesn't have sufficient parameters, to convert ToDictionary. So I need something like select FProducts.Serial_number, Nothing). ToDictionary. Also FProducts.Serial_number, 0).ToDictionary doesn't work.
Sub GetStatistics(ByVal ProductNumbers As List(Of String), ByRef Passed As Integer, ByRef FailedProducts As List(Of String))
Passed = 0
FailedProducts = Nothing
[Code]...
I am new to EF Linq and I have been struggling with this query for a few days. From reading this forum, I have managed to get this far:
Dim noPic = (From f In myEntities.FriendLists
Where (f.UserID = Profile.ID)
Select f.FriendID).Except(From g In myEntities.GuestLists
Where g.EventID = _id
Select g.FriendID)
[Code]...
I am trying to get everybody from the FriendList who is not already on the GuestList to display in a Repeater control. After reading the forum I was able to append .First() to noPic at the myNoPic declaration and finally get a result but that only gave me the first element. Does anybody have any advice on how to accomplish this?
I have a table with a Real datatype field. I just can't multiply it with other integer fields although the editor doesn't show any error - the result is always '1'.
View 4 RepliesI'm new to webservices and xml.I've been given the task of creating a webservice with a method called UploadData. UploadData(Username as string, Pwd as string, XMLdata as String)The XMLData will be xml data 2-5mb.Is String the best data type?I've tried the stream datatype and that does not work as a parameter on a webservice.
View 2 Replieswith linq to sql(dbml file), how to get the size of a datatype?
for an example, varchar(50), how to get that 50?
I have this code that use to sort a datatable.
Dim sortingIndex As Integer = orderby
Dim DataTableNew As DataTable = New DataTable
DataTableNew = dt.Clone
Dim query = (From c In dt.AsEnumerable Order By c.Field(Of String)(sortingIndex) Ascending)
query.CopyToDataTable(DataTableNew, LoadOption.OverwriteChanges)
My problem is that with this method I always need (Of String) for it to work, so the date columns are also managed as Strings witch is the problem. Is there a way to use the correct type so the sorting is based on the type of the column?
I have a VS2005 utility that I'm working on that has an Access 2003 backend. A couple of days ago, my boss asked that I change one field in two tables from TEXT to MEMO, to allow more information to be put in. In doing some final pre-deployment testing, I find when I hit my button to pull up the list of tickets, I get the error
"System.Data.ConstraintException was unhandled
Message="Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.""
The datagrid is based on a query I have in the database. The query runs fine, and when I go through the XSD and go into Query Builder, the QB is also returning data. I have made the various changes to the utlity as suggested by Microsoft, but no luck. When I put the two columns back to TEXT, the Grid works fine.
How the heck do I set it up so that the grid will recognise the new data format? The number of characters for the individual columns is set to 37,627 (I believe, it's whatever the default is). I only have 200 characters in my test data. I need to rebuild the whole dataset - this deployment has to be done by the end of the day tomorrow and I have a whole pile of other stuff left to do.
I found that when group by multiple values does not work well with VB.NET, but it works well with C# ,here are my code, is there something wrong with my VB.NET Code? Here is my VB.NET code:
[Code]...
anything wrong with using datatype object and determine datatype in class property? I have a typed dataset and it has several integers columns that are null in the db. and when I make a call it throws exception.is there anythign wrong with setting it as object in my dataset.. changing the throw exception property to Nothing and passing it to my property as integer?
for each row in myDS.DataTable
cRate.CustID = row.CustID
next row
and in my class
Public Property CustID() As Integer
Get
Return _custID[code].............
Apologies if this is the wrong forum (the other LINQ based ones didn't seem appropriate). I'm writing a very simple code crack game, a player enters FOUR numbers in a text box which are compared against the random number generated on form launch. Random number generator
[Code]...
I'm using a 3rd party chart COM object (National Instruments CW graph) to plot data versus elapsed time.The x value needs to be a VB6 equivalent Date type which is a .NET DateTime datatype.What I need is a way to convert a TimeSpan datatype to a DateTime datatype.
Dim testTime as System.DateTime 'date
Dim plotTime as System.DateTime 'date
Dim elapsedTime as System.TimeSpan[code].....
I have a database in mysql. The column in table is of datatype time(0)
Similarly I have a control datetimepicker in vb.net I have assigned format property as custom to the control and the CustomFormat property as HH:mm:ss tt so that it can just provide the time. I dont want the date to be in it.
Issue comes when I try to retrieve the value from database I get an error as Converion of type 'Timespan' to type 'Date' is not valid
Try
Dim myCommand As SqlCommand
myCommand = New SqlCommand("select * from [HMS].[dbo].[DoctorSchedule] where DoctorID='" & txtDoctorID.Text & "'", Connection)
[Code].....
[Code]...
I am trying to replace tasks.IndexOf(t) + 1 with something a little simpler. Is there any built in functionality for this? Hrmm xml literals do not seem to translate well on here....
I've got a Dictionary(Of SomeEnum, Integer) that gets filled up while looping through some objects that have a property with type SomeEnum. Once the loop is done, I want the SomeEnum type that occurs the most in the list of objects. I also need the other counts as well for display purposes, hence the usage of a simple Dictionary(Of K, V).I am looking for a LINQ query to give me back the SomeEnum key that occurs the most by looking at each keys number of occurences. Or perhaps there's an easier way of going about it.I could do this:
Return (From kvp As KeyValuePair(Of SomeEnum, Integer) _
In Me.MyObjects Order By kvp.Value Descending _
Select kvp).First().Key
But wouldn't the sorting be a more expensive operation than trying to wiggle Max() in there somehow?
I've tried these two blocks but it returns the same value. I do not describe more, I simply just show the code:
Dim f As Nullable(Of Integer)
If f = 1 Then
Console.WriteLine("Equal")
[Code]....
It works in C# correctly...
I accept both C# and VB.NET suggestion, even though I'm writing an app in VB.NET I have two lists of intergers
List1 {1,2,3,5}
List2 {2,4,6,7}
I want to have new List3 {4,6,7} which is composed of elements of List2 that are not in List1. I know I can write a nice For Each loop for this but I want it done in LINQ I've been looking for such methods at Enumerable Methods, but I can't find it.
I am working on a produce inventory database in my VB Express program.I have a form on the bottom and a spreadsheet at the top. I want to enter all the data in the form and have that data automatically transferred as a group to the spreadshet in the upper part of the page when I press a button.I know that there's an insert function.I set it up correctly. The problem is that I have to convert the textbox, which contain string data, to the datatype used in the database spreadsheet.HOw do I use CAST or do this?Here's the function I am using:
Me.TableAdapterManager.InventoryTableAdapter.Insert(IDTextBox.Text, fruitName, unitprice, unitsize, unitIn, unitTransit, unitOut)
Evernything is a string cause the data is coming from a textbox, I need to convert it to the datatypes used in the database.Also how do I use the CAST and Convert functions
I'm struggling with getting Linq To NHibernate to work.I have referenced NHibernate, NHibernate.Linq and NHibernate.ByteCode.Castle . Also I have all other dependencies in the same folder.
Code / Error message:
Public Function GetProjectsByName(ByVal ProjectName As String) As List(Of Project)
Return (From x In _session.Linq(Of Project)() Where x.Name.Equals(Project))
End Function[code]....
... tells me that the LINQ extensions aren't loaded. Using NHibernate.Linq seems to be made in a way that it's incredibly easy to use, hence there are no tutorials on how to set it up. (Or at least I couldn't find any).
I am learning MVC3 and transitioning to VB.NET from C# at the same time (Fun, I know). I am running through the MvcMusicStore sample for learning MVC3. All the samples are in C# so I am converting them to VB. I came across one piece of code that I was unable to directly convert and had to change slightly to get it to work.
why one way works and the other doesn't.
This does not work:
Dim albums = New List(Of Album)() From { _
New Album() With { _
.Title = "A Copland Celebration, Vol. I", _
[Code].....
linq querying various nested tables in a dataset? I can't find something like that on the net.
View 1 RepliesI've problems to detect if there are new rows in a DataTable Email_Total that is yet not imported into ContactDetail.
Dim srcUnique = From row In src.Email_Total
Select row.ticket_id, row.interaction, row.modified_time
Dim destUnique = From row In dest.ContactDetail
[Code].....
Using VB.net and the following LINQ statement. I suspect the "Order by" does not work with Concat(). I want to list the current item the user has and then list more available items in asending order. So first i select the current item from the db and then select the next available items in order. LINQ is ignoring the order by statement and sorting by the PK (which is itemID) I examined the list immediately after executing the statement. When I break up the statement and do them separately they work as predicted.
(From items In myDatabase.ItemAssignments _
Where items.BuildingID = buildingID _
And items.ResidentID = ResidentID _
[Code].....
it is possible to do a multiple records editing by linqtosql method in one click event?What I've been trying to do is to edit all the names in the table which are having the same account number.
Private Sub Button2_Click(------------) Handles Button2.Click
Dim accnt As String
accnt = Textbox1.Text
Dim db As New memrecDataContext()
[code]....
Why is it these codes could only edit records in one datarow?Can you debug the codes to edit all records which are having the same account number after it is being query?
I would like to ask if it is possible to do a multiple records editing by linqtosql method in one click event? What I've been trying to do is to edit all the names in the table which are having the same account number. I was able to edit but only one name has been edited and the rest are not
******************************************************
Private Sub Button2_Click(------------) Handles Button2.Click
Dim accnt As String
accnt = Textbox1.Text
[Code]....
Why is it these codes could only edit records in one datarow? Can you debug the codes to edit all records which are having the same account number after it is being query?if that is possible for you.
i'm having troubles with a linq-to-sql statement and getting a left outer join to work. here is a sample of two tables i'm trying to join and my code that i've wrote.
Table1 Table2
f1 f2 f3 f4 fID f1 f2 f3 f4
val1 val2 val3 val4 1 val1 val2 val3 val4
[code]....
Instead I'm returning ALL values from table 1. I need to return all values from the left outer join where tbl2.fID is null.
I have a datagridview which is bound to a local databse table through a Linq to SQL class.
Everything works as I would expect, when the application runs, up to a point.
If, in the datagridview tasks pane I enable Adding, Editing and Deleting all work as expected.
If I disable Adding & Deleting, leaving Editing enabled, Editing works as expected.
If I disable Deleting & Editing, but leave Adding enabled, Adding does not work, despite the row for new records being displayed. I can move around the row but not enter data.
I suspect somehow its the datasource as opposed to the datagridview that is the cause of my problem but as I say, I can add rows if the Enable Editing option is selected.
Changing the relevant properties programatically makes no difference.
I've been searching for the reason for a couple of days without success.
I have a workaround, by leaving Enable Editing set and programatically setting each row during the RowPostPaint event to be readonly except the row for new records. I would just like to understand what is going on.
how can i use value (23,32) in sql column datatype int how can i use comma in column data type int
View 8 Replies