I'm doing a simple linq request like this:
Dim r = (From p In db.Product _
Where p.Product_ID = ProductID _
Select p)[code].....
My problem is eventhought the request return an empty table (I tried with a count too) it consider the table as not empty and execute the code inside the "if"...
Is there anyway to catch or display the request failed with an empty response message somewhere other then in a message box, for a example in a text box? Catch request failed with an empty response message
View 9 RepliesHow would I return a base64Binary type back from a VB.net web service request? I would like to return the base64Binary of a PDF document from the binary datatype from SQL Server 2008. Is base64Binary the same as Byte? Do I have to convert the Byte to Base64 then to String?
View 1 RepliesI have coded very simple asp pages to return an image when requested. But I need to do this from a vb.net application. So I assume I need to create a mini http web server. I have code for some that does not support asp or anything like that. Is there another method to return an image? Anyone have an example of this? Or again, do I need to find a web server control or app to use?
View 3 RepliesI am trying to search for a term on this site: [URL] and return the definition of the term to a RichTextBox. I can search for the term easily enough. My initial idea was to find a div class similar to every definition, and in the source returned from my WebRequest there is always the div class:
<div class="luna-Ent">
So for example, if you search the term "lol" and view the page source, the definition for that term is wrapped as follows:
<div class="luna-Ent">laughing out loud; laugh out loud: used as a response to something funny or as a follow-up to something said only as a joke.</div>
My problem is that I cannot split the string, which contains the entire text from this web response, leaving just the above. Which I would further split to leave just the definition.Every time I attempt to split the string I get a bogus result with randomly cut up words and nonsense. There is only one <div class="luna-Ent">, so I have no idea why this isn't working when it does with a simpler string such as "lol?55?44" which you would split using "?".Here is the code so far, please excuse the crappy variable names. I always structure my stuff like that when testing?
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyDown
If e.KeyCode = Keys.Enter Then
e.SuppressKeyPress = True
[code]....
Instead of my method, is there any way to return only the data, from the web request, wrapped in that div class?
I have an attribute class:
[code]...
With that said, shall the Private Property Attributes() As String() not return the values of DirectoryAttribute placed over the interfaces properties as well, since I specify True in the inheritance parameter of the Type.GetCustomAttributes method?
I have the following piece of code: trying to use this in 2.0 framework. getting error for not having a return statement before exit function.[code]...
View 4 RepliesWhat I'm trying to do is to write a generic rss reader that I plug in any URL into without worry if the feed has all the common properties. For instance in my example below I'm looking for pubDate, however if no pubDate exists in the xml I'd like to return the current Date. I cannot seem to get the syntax right though.
Dim xmldoc As New XDocument
xmldoc = XDocument.Load(url)
Dim feeds = From feed In xmldoc.Descendants("item") Select New With { _
[code].....
I would like to know how to filter out system tables and only return user tables .when i run the code it displays lists of system tables with user tables list in combobox.I have just gotten into vb.net and have tried few ways to do this but dont understand well enough.
[Code]....
I have the following web method:
<WebMethod()> _
<ScriptMethod(ResponseFormat:=ResponseFormat.Json, UseHttpGet:=True, XmlSerializeString:=True)> _
[Code].....
I wanted to use HttpGet here so that the result can be cached.
I tried every variation of calling this, but no luck. Is this possible with GET?
I need some help with asp.net mvc
Controller:
<HandleError()> _
Public Class HomeController
Inherits System.Web.Mvc.Controller
Function Index() As ActionResult
[Code]...
i want to insert the data into the table only if the table is empty, so for that i need to check the condition to check whether data already exists in the table, if present then i want to empty the table before inserting the the fresh value.
i know how to insert and delete the data only prob is to check the condition. so please can any help me out in this.
TO INSERT
Dim comUserSelect As OleDbCommand
myDateTime(i) = DateTime.Parse(arr_dateTime(i))
' Console.WriteLine(r("P1"))
[Code].....
Possible Duplicate: Checking for an SQL result in VB.NET
I have login form which is redirect user for their levels but before to that if there is no any user on the data table I would like to redirect to create admin form. I have all the forms but I didn't manage to redirect them because I don't know how to create statement.
Dim con As SqlCeConnection
Dim command As SqlCeCommand
con = New SqlCeConnection("Persist Security Info=False;Data Source=.database.sdf;Password=********;File Mode=shared read")
con.Open()
[Code] .....
I have this code is working. What to write for
Private Sub frmlogin_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
i have 10 of empty row which doesnt not have any data, this is happen because i click to many insert button insert data. Please show me the coding should i use to delete my empty row. For you info i have table name is Bundle and 2 column which is name and type .
connection.ConnectionString = " Data Source=Danawa;Initial Catalog=Store;Integrated Security=True"
Try
connection.Open()
[code]....
MsgBox(MyDataSet.mytable.Rows.Count)
Gives 0, why?
The table has data!
I'm binding data table to datagrid but i'm not sure how to delete the empty cells in that data table
View 8 RepliesI think this may be a usual issue but I am not able to find much info. There is a master customer database and a call log database at work. The call log database has two tables that are updated from the master database monthly. Now I am writing this vb frontend for the call log database and cannot figure out the update portion
For p = 0 To maxrowsC (currently around 1000 rows)
With myCommand.Parameters
.AddWithValue("@HEATSeq", dsCallLog.Tables("ConfigDS").Rows(p).Item(0))
[code].....
I have a View that i am trying to use to fill a TableAdapter with. In my code i fill the table adapter properly the first time, filter my bindingsource and use datarowviews to loop through the rows of data and perform the updates needed (done by a stored procedure). Now the problem is, after these updates take place, i need to fill the tableadapter again so that it reflects these changes. Sometimes the View i am using will have no results, other times it may.[code]This is the exact Error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."Okay, you'll notice that i fill my view, then filter those results on the column Number equal to 1. I loop through all those results and update the table my view is created off of. After exiting the loop i hit the second .fill which times out after about 20 seconds. After testing, this time out only seems to occur when MyView does not hold any records.
I use Visual Studio 2010 and sqlserver 2008. All work is done in VB.NET. Also, during debugging, i paused on the second fill, went to Toad for Data Analysts and ran a SELECT * FROM MyView which did not time out and returned the empty result table in about 19 seconds. I have also tried doing a dispose on the tableadapter before the second fill but it has a similar time out. Sorry if this answer seems obvious or something, i'm only an Intern and am still learning the language. That seems to have done the trick, from my understanding that lets it run until it finishes (SQLServer will shut it down if the connection stays open longer than it allows). The ta.fill runs at about the same pace as Toad coming in around 19-20 second mark and does not error after multiple tests.
I am using TextFieldParser to Read a Tab Delimited Text DataFile. The problem I have is that some times the data file (3rd party provided) contains an extra Tab which therefore creates an extra column. I need to remove this unnecessary column. Some columns will have rows that are empty so I cant just delete the column if it has a blank row, So I think I need to loop through each column and if if every row is blacnk then delete that column.
Here is the code that reads the file, I was going to remove the column from the table called table before I populate the table called dtAll , which is what my program uses
Dim safeFileName As String = IO.Path.GetFileName(Me.OpenFileDialog1.FileName)
Using myReader As New Microsoft.VisualBasic.FileIO.TextFieldParser(safeFileName)
myReader.SetDelimiters(vbTab)
Dim currentRow As String()
[Code] .....
I'm trying to add a service company from a vb form to an SQL table. It works as long as I enter something in every field on the form. If not I get a syntax error so I thought I should check that the field values were not null
I've tried to add a sub to check for blanks but it's not working
btw the table will allow nulls for all fields
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Try
[Code].....
I inherited a program that retrieves 3 datasets from our vendors' web services, converts it to a table and then merges the 3 tables before exporting into xml from the resulting combined table. The problem I am having is that when web services returns an empty dataset the program crashes in the attempt to create a table from the empty dataset.How do I modify this code to either create an empty table or recognize the empty dataset and skip around that particular table creation, merge and removal? There is always data in at least one of the datasets.
foreach (Branch branch in branches)
{
Console.WriteLine("Opening connection...");
Vendor.ws_ordersSoapClient VendorClient = new VendorInterface.Vendor.ws_ordersSoapClient();
[code]....
The problem I have is that many times, the dataset that this control is bound to is empty. Therefore, the user continuously gets an error saying that one or more fields is missing. When I debug the code, I can see the code in the class loop through all of the radio button controls on the form. Since none of them match the field from the database, the code throws the error. I assume the code expects a match.
Should I modify the class to handle the case when there is a DBNull value? If so, what would be the best method? Or should I approach this situation in a completely different manner?
Public Class myGroupBox
Inherits GroupBox
Private _myTag As String
[Code]....
I want to return the top 5 records of a table in a dataset for datagrid view. The following does not work.
DataGridView.DataSource = DS.Tables("TABLENAME").Select("SELECT TOP 5")
There are two combo boxes taking user's inputs to return a record in an Access Database satisfying the requirements. This procedure is controlled by a button. However, when it reads "da.Fill(dt, "NETP_ParaList")". It reports error saying that "ArgumentException was unhandled; Object is not an ADODB.RecordSet or an ADODB.Record. Parameter name: adodb" I have no idea what this talking about.
[Code]...
I am new to development and I'm using VB.NET to build an application for my kids. I want to teach them how to manage their money so I've decided to build them an application. I have a database table which stores all transactions aswell as the userid (users have to login). When one of my kids opens his bank account, I have got it so that it only shows his transactions with date and bank account balance and no-one elses. My question is, how can I retrieve the latest balance and display it in a label at the top of the form?
View 3 RepliesI have multiple file upload boxes on a form in my mvc3 application. Request.Files shows 3 files when I put a break point in the below function and look at it.. Problem is other than coding a counter and using a select case I dont see a way to handle saving each file name to the database column it belongs to... Is there away to assign the variable on the fly I guess you could say So that the foreach loop would drop the file in the correct column. Ie handoutFile1, handoutFile2 , handoutFile3, Etc. As it stands the below will overwrite the filename in handoutfile1 every time the loop is gone through. I thought about throwing a counter in the loop and just put a select case on it to assign the db column based on the counter number. Seems like a cheap work around though. [Code]
View 2 RepliesI am retrieving the Max Value of a column using the Table.Compute Method
Max Value
dtlist.Rows(i)("Value") = dtsold.Compute("Max(ClosePrice)", "Distance <= " & Dt & " And BuildingSize<= " & GLA & "")
I would like to also return another value of that same record
How do I identify the record that is the Max Value?
I keep getting an error saying "there is an error in your sql syntax." when i use this sql statement:SELECT * FROM gsm_oceanwide_integrationEDIT:To put this in context heres the code im using this query statement in (VB.net):
Dim con As MySqlConnection = New MySqlConnection("Data Source=" & frmLogin.txtserver.Text & ";Database=stratocast;User ID=" & frmLogin.txtusername.Text & ";Password=" & frmLogin.txtpassword.Text & ";")
[code]......
I have a Microsoft Access database that I connect to with the Jet Database Engine, using VB.NET. I want to programmatically get all of the column names for a particular table [code]...
Is this possible in Access? If not, what are my options for getting the column names?
I have recently started using Request("key") instead of Request.QueryString("key") to access my querystring values. However I have read that:
'Gets the specified object from the System.Web.HttpRequest.Cookies, System.Web.HttpRequest.Form, System.Web.HttpRequest.QueryString, System.Web.HttpRequest.ServerVariables'
Therefore, if I have a querystring key and cookie key which are the same, which value is returned?