I am just starting to dive into the ADO.Net routines in VB.Net, have used ADO in VB6 forever just would like to make sure I am getting started on the right foot here.
'As I test I had hard coded the connection string here which I have removed from the post, I will switch it to a var that is read from a config file later.
CN.Open()
Dim Cmd As SqlCommand = CN.CreateCommand
Cmd.CommandText = "Select * from tblusers where userid=@UserID"
[code]....
btw I realize that I have not yet added a message for when the Userid is not found. I am more concerned with the method I am using to query the db and read the results as well as closing the objects afterwards.
I have loaded my database with one table under "Data Connections" in the "Server Explorer" pane.What is the standard / best-practices way to handle a simple query in a VB ASPX page?
My left <div> would be a set of form elements to filter rows, and when the button is clicked, the main <div> would show the columns I want for the rows returned.
Note: Answers in C# are okay too, I'll just translate.
I am trying to get a query to work with Visual Basic 2010 Express addition I have pasted the code below but it just errors out with to many arguments I have taken this sample from a reference book but cannot get the darn thing to work. I have looked all over the net and Microsoft for a solution but still no go if any one can help it would really be great. BEP
Private Sub FillBypeeps1ToolStripButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FillBypeeps1ToolStripButton.Click
I'm using vb.net express with access 2010.Everything is working fine except for a simple query:SQL: SELECT * FROM Customers WHERE Name Like 'Ale*'Which returns all the names starting with Ale. Now in my .NET code I wrote this:cmd = New OleDbCommand("SELECT * FROM Customers WHERE Name Like " & Chr(39) & Name.Text & Chr(39), connection)Now when I start the app and in my textbox "name" I write Ale* I have the following expression:SQL: SELECT * FROM Customers WHERE Name Like 'Ale*'But when it executes from .NET (dr = cmd.ExecuteReader) it doesn't find ANYTHING.
I am trying to query a SQL db and send the results to a notepad or wordpad doc. I have the VB code wrapping the statement and it works fine but I have to put the results to a doc so the user can preview and/or print.
I've tried different approaches to query a simple xml and compare one of it's values but none of them worked well.
Consider the following XML structure: <?xml version="1.0" encoding="iso-8859-1" ?> - <Shops> - <Shop> <text>Northampton</text> <value>NN</value> <currentdate>050809</currentdate> <labelcounter>1</labelcounter> [Code] .....
I have the shop name in a drop down list which is ShopsDDL and it's set to autopostback. What I want to achieve is: On postback, check for a xml node where node's text = shopDDL shopname And retrieve also this node's currentdate and label counter. Rhen, if the node currentday = today then increment labelcounter by 1 Else set labelcounter = 1 and currentday= today My problem is the XML query, I can do all the logic as soon as I manage to retrieve data from the XML.
I'm retrieving data from an Excel sheet, using a simple SQL query using a textbox as input to my variable. It works great when I enter an integer to search for (such as 213 for example) but when I put in a mixture of numbers and letters (48A for example) I get the following error: Syntax error (missing operator) in query expression '[P&L]=48A'.
Private Sub MPLS3() Dim BrNr As String BrNr = TextBox1.Text Dim stSQL As String = "SELECT [MPLS Date] FROM [Master Data$] WHERE [P&L]=" & BrNr & ";"
The code below works fine on my development PC, but when I deployed the app, it crashes.
Here is the lines of code that are relvant
Private TdsTypesList As List(Of TDS_Type) ... TdsTypesList = (From tt In db.TDS_Types Select tt).ToList
[Code].....
I have many queries that are using linq, and none of them throw any errors. The set of data is not very large either, less that 100 rows. I dont know if I have any other queries that do not have where statements in them that work.
Running .net 3.5 without sp1 on the client machine, although I am running sp1 on my development PC. looking for a solution that doesn't require sp1 to be installed.
Edit Code breaks on the second line when remote debugging.
I looked over [URL] and tried the following, with the same error.
TdsTypesList = tl.OfType(Of TDS_Type)().ToList
I finally found a dirty workaround. Instead of pulling all of columns from that table, I was able to re-write the query to omit 1 column. This returns an object of anonymous type, and I can use that object. I still would like to know what causes this though.
I have a project in Visual Studio 2008 and there is a working data connection to a MySQL database. In other words, I can query the db directly from Visual Studio and it will display the results.
I've tried a couple of approaches that I found online for writing a connection string and accessing the db, but no luck yet.
All I'm trying to do is code a button to query the db and then reset the text property of a label/textbox to display the results based upon another label/textbox value.
The pseudo-code I am imagining is something like this:
Private Sub query_submit_button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles query_submit_button.Click result_textbox.Text = SELECT field FROM table WHERE otherfield = key_textbox.Text End Sub
I didn't see any related questions posted on SO - forgive me if I missed one that already exists and this is a dupe.
I get a Type 'System.Data.SqlClient.SqlDataReader' has no constructors. error on the 5th line of code below and I get a Variable 'e' hides a variable in an enclosing block. on the last line of code below (in my catch statement).
Here is my code:
Imports System.Data.SqlClient Public Class Form1 Dim myConnection As SqlConnection
Im a user of VB 2005. I had a problem with Simply run a project (Even Without any code in it). Indeed when i Creat a new project and i want to run and debug it (with F5). The information box show that cant debug. and because of that, the program may not run.The Message in information box is here (in Appendix).I try it with VB 2008 (But didnt work). After i Reinstall all of VB and Install again, but my problem existed even now.
I need to display a simple box on a form that can be split by the user. It represents a gang up of a number of images on a printed sheet. These images are always in a # of rows x # of columns format (1x1 or 2x4 etc). There can be from 1 - 24 rows and 1 - 24 columns.
My thought was that I would give one text box each that the user could enter the number of rows and number of columns into. When these change then the box display would repaint to display a grid that represents the gang up specified in the text boxes. My issue is that I don't see a control that I could adapt for this use for the box.
We're starting to evaluate VS 2010, but right now I'm trying to do a simple Windows application in Visual Studio 2005 on an XP box.
Eventually, this will become a web service, but I want to test the XSLT file I am using in a simple application first.
Here is the XSLT file:
CODE:
The file is added to my project, XMLTest.
The code that generates and parses the file to change to a text file is as follows:
CODE:
A sample output XML file is as follows:
CODE:
When I run the VB code to input and transform the XML output I get a filenotfoundexception error that I can not figure out, because where it is expecting the XSLT file doesn't seem to make any sense.
If it were going to always be hosted on my machine, I'd use an absolute path, but it's not going to be, and I'm going to be switching to a Windows 7 x64 box after lunch anyway.
I'm trying to create an application that is able to find products from a XML file, which will contain the following data:EAN (Barcode as a string, not an image) Description Price Stock
So basically, I enter the EAN and my program will lookup the XML file for this EAN and will return the description of this product, the price and the stock in a new messagebox. However, I don't understand how to create a XML file, add items, remove items, edit items, and most of all: read items from a XML file.
I was looking to do some simple manipulations of variables based on what tab was selected.But I dont see Deselected, Or Selecting as in this example, does 2005 use somthing different?
vb Private Sub TabControl1_Deselecting(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TabControlCancelEventArgs) Handles TabControl1.Deselecting someClassLevelVariable = e.TabPageIndex End Sub
I am trying to create a simple countdown timer using vb 2005 express edition. I think the code is fairly simple but I have fallen at the first hurdle. How do you display the result, i.e. which control do you use? Tried label and textbox but both return the error: "Value of type [integer or long] cannot be converted to [textbox or label].
Every time I edit the query in the query builder, it return this error "The schema returned by the new query differs from the base query". (eg. I remove "address" from the sql command - SELECT customer, address)I'm trying to select data from different tables from different database, How do I write the sql query? How do I join those database and tables together? (e.g Select FROM table1.database1, table2.database2, table3.database3 and so on)
My below code has to copy a table from access in to temp dataset and then i need to select some datas from the dataset... its workign fine up to copying in to dataset..but in the second part the query is not submitted.. im a beginner
I have an sqlserver 2000 database and i am able to add records and read from it but i cant modify existing records. My test table just hav user_id,Name, , Phone and State for columns.
As you may have seen in my other post, I have to switch over an all text SQL statement based database interaction program to using parameterized queries instead.I remember doing it this way in college but I don't seem to be able to recall one part of it. The program I wrote back then and some code samples here both point to doing the code as I did so far:
m_strSQL = "UPDATE [OWNER DATA] SET [FIRST NAME] = @strFName" m_strSQL &= ",[LAST NAME] = @strLName" Dim upCMD As New OleDb.OleDbCommand(m_strSQL, m_Connection) upCMD.Parameters.Add("@strFName", OleDb.OleDbType.Char, 30, "[First Name]")
[Code]...
it ran the SQL statement and that's that. Can I just do that with a parameterized query too without using the adapter.update()? And for bonus points, why the heck did I use that command in my old college program cuz I sure don't know?
With DataAdapter i passed a query and this is working....
Dim strSQL1 As String = "SELECT tbl_Items.GroupName, tbl_Items.ItemName, tbl_quantity.Quantity, tbl_quantity.QtyDate FROM (tbl_Items INNER JOIN tbl_quantity ON tbl_Items.ItemID = tbl_quantity.ItemID)WHERE(tbl_quantity.QtyDate = #12/29/2009#)" Dim da1 As New OleDbDataAdapter(strSQL1, DataConn) Dim dt1 As New DataTable da1.Fill(dt1)
But when i give the date as this, not working...
Dim tmpDate As DateTime tmpDate = System.DateTime.Now.Date Dim strSQL1 As String = "SELECT tbl_Items.GroupName, tbl_Items.ItemName, tbl_quantity.Quantity, tbl_quantity.QtyDate FROM (tbl_Items INNER JOIN tbl_quantity ON tbl_Items.ItemID = tbl_quantity.ItemID)WHERE(tbl_quantity.QtyDate = " & tmpDate & " )"
From Previous Forum Post: Table Adapter Parameterized Query.I added a query. FillByDate using Table Adapter which takes a date as input from the code. The query I have set is the following: [code] lastdate (string object) is a date (inside double quote) provided in the code. The code does not generate error but I get a screen which asks the date as input despite the fact that it has already been provided in the code. [code]
I'm writing a program that will be able to start a window service (SQL Server) on demand. Some of our servers have both SQL 2000 and SQL 2005 installed. I'd like to run a WMI query on the server (either local or remote) to determine how many instances of SQL are installed, and then start the latest version of SQL server. Install paths to SQL instances / configs can be different due to SAN configuration, so I need to use a WMI query to get the services.
I was using the following query- "SELECT * FROM Win32_Service WHERE Name LIKE '%MSSQL$%' OR Caption = 'MSSQLSERVER' OR Name = 'SQLSERVERAGENT' OR Name LIKE '%SQLAgent$%'" This returns a bunch of SQL services, so I decided to cut it down- "SELECT * FROM Win32_Service WHERE Name LIKE '%MSSQLSERVER%' OR Caption = 'MSSQLSERVER'" But that query still returns other services (i.e. FullText, Active Directory Helper, etc.) that I don't want. Is it possible to create a WMI query to only look for MSSQLSERVER and SQL Server Agent services? Am I missing something?
Trying to make a simple browser with some simple addon's. What Ive done is setup a menu(forum) for the user to enter their email providers web address and it will save it in a xml file. When they click on the email link, it should load the email xml iformation and place that info in the tb_html.text and navigate. I keep getting a null exception and im not sure what going on here. Here is the code:
Browsers: Private Sub btn_Email_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_Email.Click 'Load Action Dim SavedEmailObj As Storage
