I want to check some values in a sql db without populating controls. I can select the row i want, but for some reason my mind then hits a blank, maybe its because its monday.I want to check a few bit fields in the row and if 1 - do something, if 0 do something else. In this case depending on which bit fields are set to what, id like to enable/disable various controls on my form.
Heres the code i got so far, but as i said then i drew a blank, and i may be going about this completely wrong:Dim SQLcon As New SqlConnection("server=DEVSERVERDEVSQL;" & _
"integrated security=sspi;database=WDA_SQL")
Dim SQLqry As New SqlCommand("SELECT * FROM Users WHERE (Username = @Username) AND (Password = @Password)", SQLcon)
SQLqry.Parameters.AddWithValue("@Username", UsernameTSlbl.Text)
It errors on the executenonquery. Says the column rootforestname can not be null. i don't under stand why it does not fill in the value in the command text.
on form's load I am filling the DatagridView with an a Sql query. I also use some buttons to highlight every row(record) of the DataGridView. I have a button where when I click on it I want to display in a msgbox the value of the first column(field) of the highlighted row (i.e. the name of the first filed-column is Code).
The SQL string won't return data from Access. I've tested this exact SQL String in Access and it works fine.First of all, Am I getting a SQL query from Access in the proper manner?Second... should I be using a stored procedure for this? Or is making a query from tables like this a good practice? Third, if I'm doing it right, why won't Access query return and fill my dataset?These are the results I'm getting.
I have an access query which plays flawlesly in Access.I want to use it as a source for a datagridview i use in one of my forms but....given the fact that is a rather big query with some "like" and conditions like ">3" and so on AND the fact it uses tables from 3 different mdb (not to mention is bases on other queries...i 'ill try my best to fix this) what is the best approach .
1st case .Can i retrieve the data simply with NO oledbparameteres and NO " select * xxx where yyy like 'd' ".I think there is a issue with the Oledb connection that "omits" them.To explain better the query right now with the filters in access returns 3 rows, without the filters 30 rows,can i get just the 3 rows to do my job... 2nd case . How should i fill a datagridview using tables from 3 different mdbs.If you can show me an example it would be life saving.
I am trying to fill a combobox using the results form a query to combine two fields (first and Last name). I cannot seam to get to the query through the table adapter. I can set the binding source and select one of the fields to fill the control but I cannot get to the query's.
I converted some code from vb6 to vb2005 that opens a recordset and populates a listbox with about 8,000 names. It uses classic ado. The vb6 code does it in about 0.75 of a second, the first vb2005 code does it in about 5.5 seconds while the second vb2005 code does it in about 4.5 seconds. Is there any way to improve the vb2005 performance a fair bit more?
I'm trying to fill a ComboBox with values from a column in a database.I'm trying to use code I found in jmcilhinney's CodeBank post at url...credits to him since it's basically 100% his code in my image below I've tried 4 methods before this, and I've been receiving the same error, so it must be my fault.
how to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
I have a personalized webbrowser in VB 2005. It fills values into a form and submits the form.
The first page is "login.php", the next page is "home.php" SendKeys.SendWait("{TAB}") SendKeys.SendWait("{TAB}") SendKeys.SendWait("username") SendKeys.SendWait("{TAB}") SendKeys.SendWait("password") SendKeys.SendWait("{Enter}")
I want it to do something else based on the url after the form is submitted.
I'm trying to fill a ComboBox with values from a column in a database...I'm trying to use code I found in jmcilhinney's CodeBank post at url. credits to him since it's basically 100% his code in my image below.I've tried 4 methods before this, and I've been receiving the same error, so it must be my fault... the image below shows the code and the problem.
I am making my first windows forms application in VS2010 and I am having trouble with arrays. I have code that dim's an array 'TabSiteInfo(2,20)' as a string. Then, I have a Loop that adds records to the array. The problem is that my array is not filling values from the loop. I know VS2010 handles arrays differently, but I have this same code working fine for me in VS2008 ASP.NET application. Below is a sample of the code.
I'm writing an ASP web application with VB back-end. What I'd like to do is generate a url and display this in control on the page. For example if I have a label and a button on the form. The label is blank. When the button is clicked the following code fires:
Protected Sub btnGenerate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnGenerate.Click label1.Text = "Hello" End Sub
What I'd like to have is a url that would point to my ASP Page with the words "Hello" in the label.
url...How do I reference a query in a DataTableAdapter so that I can put the values gathered into a Textbox? I'd like them to all go on their own line in an order like so: LastName, FirstName, GradYr: MP1_Pts: MP1_Comments; MP2_Pts: MP2_Comments.Can someone guide me in the right direction here? This is the final step I need to take in creating my program.
Right now I have an array that is unparsed. One of its elements goes something like this:
"Blah, 555-5555"
So it's a name and a telephone number separated by a comma. The instructions I have tell me to use a query to put the information in the array into a data grid view in two columns, one for the name and one for the telephone number. I don't know how to isolate each inside a query.
I am working on a Data Survey Project and first I have a few questions about the different types of databases, and second, I need help querying my tables that have relationships.
1. I need a database that is stand alone. It is just the back end for the program. Simply to hold all the data an employee gets while out on a job. So would I be better using access, or SQL Express? I have played with both, but I do not want a large redistribution to my user machines. When I compile and produce this app does the SQL Database still work without installing any SQL Technology? Or do they have to go in after they install my app, and install Express?
2.Overview: I suppose depending on the first question regarding the database, it might change this question a bit, but none the less...I have 4 tables( using Access at the moment) I will be generating Reports based on data in the database. I haven't gotten that far yet. *Project* is the table that holds all the details that pertain to the job and client. It has a "one-to-many" relationship to *Survey*. So for one customer there are going to be many Survey Records. *Project Type* also has a 1-to-many back to *Projects*. Parts is kind of an orphan, but is linked to the *Survey* table with a one to many. So there can be many parts for one survey. I wanted this table for a drop down box, so the user could just simply select what hardware he was using instead of typing all the names and parts.
So in VS 2008 using the Designers and related Query tools, how do I constrain the Survey Data to one Customer? I have one form that opens from a button that is "New Project" and then there are all the *project* fields listed, so the user fills out the info and hits accept and that opens a new form called "frmSurvey" I need to add some code to the accept button to check what type of project is selected from the frmNewProject and then run a select query based on that. How do I write query statements in the code section of the form, without using the Visual Database tools?
Ill stop here, and get these questions out of the way first. If I could just get a handle on how to use the data properly with different forms and different controls with my queries, that would be great.
I have a form with a tab control, containing a small number of tab pages. I'm writing a sub procedure to clear the controls within a groupbox for the selected tab. A selected tab will only ever contain ONE groupbox and within a groupbox will be command buttons, labels, text boxes and possibly a combobox. The first block of code below firstly finds the groupbox within the selected tab. The next part loops around all control type and if of type texbox clears the text.
Now hears the head scratcher/confusion it error's with :- Unable to cast object of type 'System.Windows.Forms.Button' to type 'System.Windows.Forms.GroupBox Which I don't understand as I cant see where Im converting objects simply looping through all controls and then ONLY if type of control is textbox then clear text.
'Loop around all controls in form, simplified that all controls 'are within a SINGLE groupbox and clear contents or reset to default value Dim groupbox = (From grpbx In tabAdmin.SelectedTab.Controls _ Select grpbx = DirectCast(grpbx, GroupBox) _ Where TypeOf grpbx Is GroupBox) [Code] .....
If I have a query dataset in MS Access (or SQL query) that results in a table with column A as such:
A 500 400 300
How can I hav Column B show growth rates such as B2 = (A2/A1) where A2 = 500, A3 = 400, and A4 = 300, and so on successively (like one can perform on an excel sheet) as such:
B 1 .8 .75 (Columns shown adjectly below for clarity)
My issue is with getting the attribute values. I tried this: For Each xattr As XAttribute In attr cboBrandChoice.Items.Add(test.Value) Next
However, I keep getting the following error: {"Unable to cast object of type '<GetAttributes>d__8' to type 'System.Xml.Linq.XAttribute'."} I'm new to using Linq so this error isn't making a whole lot of sense to me.
how to store or return multiple queries result values into multiple variables.. I'm using a query that return 4 columns but how to.. individual store those results into 4 separate variables.. here is my code
Private Sub FrmAlumnos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load txtCurrentUser.Text = Login.txtUser.Text Dim strsql As String
I have a table which fields are Date, No, Turnover, TotalWin, Opencredit, Handpay, Billin, gamesplayed and I am trying to write sql in vb.net that will show me previous day value but I cant. Here is what I am trying to do.
[code]...
Ok Thomas I am not able to give correct answer to your question because first time in my Life I am trying to write sql. I was doing this with MSAccess and it was easy. Now I am getting pretty simple error I think with this code but I can't find solution again. What is wrong.
I have a sql query with that adds numerical values from different table to find total for a shipment. When I execute this query, it works fine for the first record but rest of the records show null value when I know there are records present. SQL pros take a look if there is a problem with my syntax.
Im having an issue with a certain query,Dim nwLat As Double Dim Ssql As String
nwLat = nwLatHidden.Value Ssql = " select * from customer where latitude < " & nwLat TFRcount.SelectCommand = Ssql TFRcount.SelectParameters.Clear() TFRcount.DataBind()
All it does is refresh the page and does nothing; it should populate a chart. However when I replace nwLat with a value (eg where latitude = 56) it works perfectly and populates the chart. Any ideas what's wrong with nwLat?
EDIT: I switched nwLat to long and it works; however it only takes the number up to the decimal and ignores the rest. Any way to fix? (eg as double 56.764746 and long 56)
This is the current code. Rather than put in this 100 times for each number, What would be a better way? Have had a go myself but can't get it to work.
I've bound a lot of controls on a form to a Entity. Some of them update fine, the others are just jumping back to their original value as soon as it loses focus.The old data are loaded in all controls perfectly.
Dim Q = From e In EnData.Calls Where e.CallID = ID TempRow = Q.FirstOrDefault() ticTemp1.DataBindings.Add("Value", TempRow, "CallDate") ticTemp2.DataBindings.Add("Value", TempRow, "CustomerID")
I'm designing a form and trying to get different opacity values for different controls. How should i do it??eg. clear visible text floating over 50% opaque form.
I have two datetimepicker controls on my form: dtpPickup and dtpReturn I need a way to ensure that the dtpReturn date selected is after the dtpPickup, and not before. How do I do that? And also, how do I get the values of the datetimepicker selected controls? Also, how can I set the values of the datetimepickers to these two private variables? Private mdatStart As DateTime Private mdatEnd As DateTime It will not let me save them with the Sub for the date time pickers.
I face a problem trying to take the values from a variety of controls that I create dynamically using some data from my database.For example I have a treeview and if I click on the first node I create a textbox, a datetimepicker and a combobox.When I click on the next node I create a datetime picker, and two combobox.etc.the problem is that when the user will press a button I want to take the values from these controls and use them to create a report.[code]but how I can get the value, the text, or the selectedvalue.Each control is different.
