I'm trying to code an application that selects an appropriate delivery method from a list box. The user should be able to enter a part number consisting of numbers and either one or two letters. I want to code it so that it does the above and displays an appropriate message when the part number contains an invalid letter or letters.[code]...
View 2 RepliesI'm trying to code an application that selects an appropriate delivery method from a list box. The user should be able to enter a part number consisting of numbers and either one or two letters. "MS" representing "Mail-Standard, "MP" for "MailPriority", "FS" for "FedEx-Standard", "FO" for "FedEx "Overnight" and "U" represents "UPS" I want to code it so that it does the above and displays an appropriate message when the part number contains an invalid letter or letters.
Option Explicit On
Option Strict On
Public Class MainForm
[Code]......
Is there a function to write this in DataTable Select method in VB.net?SQL Query that I would like useSELECT id from mytable where id in ('a','b','c')
I have this code to create query but it would be nice if I can use IN clause
For Each typeitem In shapecb.Items
If Stntypeitem.Selected = True Then
[code].....
I want to filter a virtual table (DataTable) and return only matching items into another datatable which eventualy is the datasource of a datagrid. The datagrid displays the result. The purpose is to reduce the network traffic while still providing the function. So as type on the textbox provided, the virtual table which was earlier populated by a disconnected Ado ADO connection, is re-queried and filtered into the new datatable.
how to go about this. It is a windows application and i am using dot net 3.5, VB 2008.
Here is my code:
Dim filtDT
If MYQDT.Rows.Count <= 0 Then
MsgBox("The data is been cleared")
[Code]....
I need my program to select the proper output in the listbox based on what the user input as the delivery code!I have attached the complete file that is run in Visual basics 2008 express edition.
This is the code:
Public Class frmMain
Private Sub btnExit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExit.Click
[Code].....
Using Excel Automation classes I am seeking to save an Excel file as a delimited text file. The examples given in the MSDN library refer to versions older than Express 2008 with (apparently) different syntax options for FileFormat.Based on the snippet shown, I get a COM exception error (800A03EC). Other variations produce the same error.
Am I improperly applying the Automation features?
Imports System.IO
Imports Microsoft.Office.Interop
[code]....
I have a db, and one of the columns in my db is an attachment column. It stores the link to a pdf document. I want the user to be able to browse through folders and select the proper pdf file. And when the user finally hits the submit button on the form my algorithm should put the necessary link into my db. I'm just not sure how to do this with regard to VB searching and finding the file, and then using my SQL statement to insert the attachment into my db.
Here is my code so far.
Private Sub SearchFile_Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SearchFile_Button.Click
Dim saveFileDialog1 As New SaveFileDialog()
[CODE]...
It is really too bad that Microsoft (who once had the best documentation in the business) has slipped so badly. Good documentation does not really require analysis, though, admittedly, it is a lot of work. To wit: for each and every single method, function, event and operator provide the following: a brief topical functional description including any parameters, a detailed description of how the object works, a workable example of the code needed to make this object do something useful and links to all possible associated objects (See Also).
I see pages upon pages of useless text and links to other pages full of links. This rapidly descends into a crevace of unbelievable complexity for the developer trying to find out something truly simple like filtering a DataGridView without changing the data connection. (As it turns out this is very simple to do but I could not find a single example of how to do it in the Visual Studio documentation.)
Im testing a program and want to display the DELIVERY form as the first form. I don't see the delivery form ?
View 5 RepliesI need a delivery report when the sms was send. Which AT Command is used to enable the sms deliver report.
View 1 RepliesI am building an application that contains data that needs to be fed out to seperate groups of people.Sending them emails is the only way to do it but this takes ages to do.i need for example to send:
send to = textbox1.text
subject = textbox2.text
body = textbox3.text
I'm trying to get value from Datatable after Select Method.Select Method should return only one record.
Dim y As DataTable = CType(HttpContext.Current.Session("tb"), DataTable)
Dim products = y.[Select]("StnID" = "'" + stnID + "'")
Dim size = DirectCast(Products(0)("Shape"), String)
if I replace products with y--(DirectCast(y.Rows(0)("Shape"), String), it works.(which is before Select method, so it's useless) products is datarow object and I can't seem to get the value same way as datatable.How do I get value from datarows?
am using VB.NET 2008 and am a complete beginner. am writing a programme that requires the user to select a number from a NumericUpDown control and the number selected will enable the equivalent number of GroupBoxes on a form following a click event.
[Code]...
think that the argument to be passed to the method or sub will be the Case condition but how do I return the corresponding code to enable the GroupBoxes? I have the same issue with resetting all my textboxes to some default text then the user activates more then one event.
i am making a progrom to calculate delivery charges this depending on weight of the item.i enter the weight of the item in a text box i need it to calculate the shipping cost, currently i have something like this but it is wrong. [code]
View 5 RepliesHow do i use Datatable.select method to select only those rows where a specific column value is blank?
View 16 RepliesFor I've tried this:Dim exampleItems As Dictionary(Of String, String) = New Dictionary(Of String, String)
Dim blah = exampleItems.Select (Function(x) New (x.Key, x.Value)).ToList 'error here
But I'm getting a syntax error and all the examples that I've seen are in C#.
I'm having the datatable with three columns, i need to return the rows in which the third column having the null values.
ie., I need to do like this below mentioned coding,
Dim rows As DataRow() = ds.Tables("Tablename").Select("col3 is null")
Is it possible? if no, anyone tell me the way to get the results.
First time poster, so if there is any formatting, or guidelines I failed to adhere to, please let me know so that I can fix it.
So I am basically asking the user for the file directory of the excel file, then I setup some variables (originally set at public as project variables, since these were being used and changed in other places). I have also added the lines to set these variables to nothing (just in case, I do not think that it should matter). I then set these variables to the excel file, workbook, and sheets that I want to access. [code]...
I am trying to receive confirmations if a user read or deleted an email.Also, I would like to capture if the email was delivered.I have the delivery receipt working, but the read receipt is not working.The email accounts are used on a MS Exchange Server 2010.[code]
View 1 RepliesJst recently i came across the select() method of data table and felli n love with it instantaneously.
Basically I want query the data table on a date field, unfortunately the format of the date string returned from y database in to data-table and the date string i'm passing as inputs are different.
How can i make sure that the data is compared irrespective of the formats ? Can I use something like SqlParameters whoes data type is date for comparison ??
this is what i'm tying :
dim dat as date = "#1/3/2009#"
dt.select("StzDate ='" & dat "'")
entry in datateable dt : StzDate : 3/1/2009 12:00:000
Am I do'in something wrong ??
Also, can anyone redirect me to some site where I can learn a bit more about passing parameters to the select statement,etc...
This is the code that I'm currently working with, and I'm getting this problem. I'm novice at Excel and I can't figure out what's wrong.[code]...
View 2 RepliesVB.Net 2005 SQL server 2005
I have a project I have a dataset that contains tables In the dataset designer, each table has a defaiult FILL command set. I have draged and droped my table as a grid onto my form VB automatically sets up the table adapter, and binding source to make it all work.
in my code, is placed in the form load routine, a tableadapter.fill(dataset.datatable)
Here is my dilemma. The data in my table may have 100's of thousands or rows.
I have presented the user with a front end that allows for filterring and selecting based on several columns. reguardless of how many rows the result set contains, there will always be the same columns in the dataset.
Because there are so many combinations of select query, i do not want to make 20 or 30 custom fillby's in the dataset. I want to make an addhoc select query and have the binding source and table adapters work as expected. I have created a query called "FillByCustom" in the dataset designer attached to the DataTable Adapter section.
My question is this.
If i build a select query that returns the desired rows, how do i place it into the adapter in place of the FILLBYCUSTOM select command, such that it all works as expected?
I have two lists declared as follows:
Dim lstDBItems As New List(Of DBItem)
Dim lstAppItems As New List(Of AppItem)
I am trying to do something like this:
I've a function which returns List(Of AppItem):
Function GetAppItems() As List(Of AppItem)
'...
End Function
In the above function I populate lstDBItems and then write the return statement like follows:
Return lstDBItems.Select(Function(x)
dim oItem As New AppItem()
oItem.Property1 = x.DbProperty1
[Code]....
The weird thing is the code compiles, but on rumtime I get a type case error.
When I am trying to use DataTable.Select to get column values.. Actually it is working file in C# which I have converted using Converters.[code]...
View 1 RepliesVBA error 1004 - select method of range class failed
View 2 RepliesI am tightening up my coding with the Option Strict set to ON. It has now produced alot of errors. An example of this is:
If AllocatedDGV.Rows(i).Cells("RoomNumber").Value = RoomsAvailableDGV.Rows(j).Cells("RoomName").Value Then
It gives me the following error: Option Strict On disallows operands of type Object for operator '='. Use the 'Is' operator to test for object identity.
The following LINQ query resp. call of the extension method Select in Visual Basic 2010 is working fine:
Dim qAvSalary = qJobData.Select(Function(e) e.AvSalary) But doing so I am not able to specify the name of property I want the query (e.g. AvSalary) using a string variable. This should be possible if I use a LINQ expression tree. Searching and trying a long time on how to translate the query to a corresponding expression tree was not successful. My final approach is:
[Code]...
I need to write an interface to get data to/from our data files.
We have a low level class that holds field values for each record read from the files.
This just holds two values, the value read from the file (DBValue) and the updated value that may need to be written back to the file (CurrentValue).
These values may be any of the standard value types (integer, date etc) or a string.
Either value (DBValue or CurrentValue) may be null if not defined.
I have written the class to manage this data which works fine while option strict is NOT on.
But we have an office policy of having option strict on all the time.
When I put option strict on, my object value comparisons fail with the error: "Option Strict On disallows operands of type Object for operator '='. Use the 'Is' operator to test for object identity."
Question, how should I change the following code to handle option strict on ...
This is all running on Visual Studio 2010
[Code]...
Possible Duplicate: Is there a conditional ternary operator in VB.NET?
Can we use Coalesce operator(??) and conditional ternary operator(:) in VB.NET as in C#?
I'm trying to access the Count Property on the array of rows returned by the datatables select method, this is after converting the Web Project to 3.5
View 2 Replies