Sql - Select Max (column) From Table (column Is Varchar)?
Jun 16, 2011
I am going to make a invoices then.. they are going to have a id it is not going to be identity, it is not my idea, this is the idea's my professor's. then he want it so..he didn't want i change id to int, he want it was varchar..but now i have seen this is as identity.. id =1, next id=2, next=id=3.. but it doesn't mind he told me in the future it is going to be so..
abc000002
abc000003
abc000004
[code]....
then for that he doesn't want i change it to int how can i get the last? i want it one plus next i want it was
abc000010
how can i do it? i am working on visual basic and visual studio 2008i can use a loop-for, or a query for solve it?
My Data base a a column called BIG VarChar(MAX).I can't find a SqlDbType for my paramter definition in VB.net that matches it.VarChar with no size compiles but does not work.Var Char(MAX) does not compile.
I'm writing a help application for the Customer support team at my company to help agents ask better questions when customers report problems. In it, I've got a SQL database that contains all the products, topics, and questions. The layout is similar to the following:
I don't know if I'm making myself clear, but I basically need to do the equivalent to the following SQL statement: "SELECT PRODUCT_ID FROM Products WHERE PRODUCT_Name = LstProducts.SelectedValue"
I have this MySQL Query glitch in my VB.NET program. Here is the query in VB.NET: "SELECT Points FROM user WHERE Username = '" & UsernameText.Text & "';" It will select the points column from the user table from the Username they entered. When I deploy this it will set the value for points to 0 on their account. I'm not even inserting anything in.
i am developing a software using microsoft visual studio basic 2010. I set up a connection string to my server and take the data from there. I am using gridcontrolview and put my "product" table in here. It contain 4 column: systemid, system, actualid, description. I want to display only system column (it's easy, just hide the others column) But, In "system" column, there are a lot of similar data, i want to display only distinct data from this column in the grid
example, the column consist: STSTEM topaz topaz topaz
[Code]....
i try to user "add query", buat if i get rid of the other 3 column, there will be error message like "the output is different with the schema"
I am getting the error "system.argumentException; Column ' test_id2' does not belong to table Table. At System.Data.GetDataColumn( string columnname0 at system.data.datarow.get_item(string columnName).
This error is occuring right after I set the parametervalues in the report object of the Crystal report.(Note this a visual basic.net 2005 windows form application.)
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cryRpt As New ReportDocument Dim sql As String
[code]....
The value for the first parameter @Parm_1d1 value to the crystal report version 11 is correct. However, when trying to access the second @Parm_1d2 parameter ,the values past to the crystal report is not correct.
I has a datagridview and now I would like to determine that whether column1 in row 1 is selected by the user.What should I write to do so?
Private Sub DataGridView1_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick
i have more than 10 table but same column names i need to collect datas from these table for example i need to select name column from 10 tables how to do this
I have two text files, the first text file has two columns separated by a space (" ") and the second text file only has one column.
The column 1 in text file 1 and text file 2 match albeit in different order, what I'm trying to achieve is for every field in column 1 text file 2 I want to search for column 1 in text file 1 and display the matching column 2 field in column 2 text file 2.
I have a Xtragrid where when I double click the row I need to be able to pass the value of one of the columns to a stored procedure. There's got to be an easy way to do this but I haven't been able to find it.
I want to select a datagridview row according to its column value (i.e. user id) when I click on that row (with sql command).
I had following coding: If chkboxMvOut.Checked Then Dim oledbCMD As OleDbCommand = New OleDbCommand oledbCMD = New OleDbCommand("UPDATE qmaint.ots_output set Timeend = '" & CStr(time2) & "' + Remark='" & txtRemark2.Text & "' + Cstate = 'Move Out' where user_ID ='" & lngUserid & "'", myConn) oledbCMD.ExecuteScalar() End If
Dim MyQuery = From c In xdoc.Descendants() _ Where c.Attribute(OriginY) IsNot Nothing _ Order By Val(c.Attribute(OriginY).Value), Val(c.Attribute(OriginX).Value) _ Select c.Attribute(UniStr)
Right above you can see my First! linq attempt! And here comes my first question.
How can i select more than one column in a linq query in vb.net?
For example... Select c.Attribute(UniStr) AND c.Attribute(OriginY)
The data type for my DATE column in SQL is smalldatetime. I want to perform a query which selects records based on the the selected date of a calendar object.
A user clicks on the date and the date is stored in ddlfilter2 DDLfilter2.Items.Add(CalendarMain.SelectedDate)
mystring = "SELECT * FROM view_main where date" & "='" & DDLFilter2.Text & "'"
produces this "select * from view_main where date='24/03/2009'
I then get an error saying "The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value."
In the SQL database the data is displayed as "24/03/2009 00:00:00" is this why the query is failing?
I have a query that executes fine in TOAD, but when bringing back the results with either an ADO.Net DataReader or DataAdapter/DataSet, it's not recognizing a column in the select statement. See the query below... the column in question has its data coming from a dynamic table or sub-select or whatever you call it. I don't see why this is a problem in .Net:
Dim sql As String = String.Format("select bu.row_id, bu.name, selectedOrgs.bu_id as selectedOrg " _ & " FROM SIEBEL.s_prod_int_bu pb " _
Im trying to make it so that the user can pick what column to see and what now to see. How would I make it so when the user right clicks anywere thats on the column name show a contexmenustrip?
I'm just a frustrated noob trying to get past my first DB Program. My goal is to get relational data from different tables all ordered by a certain field..Ive noticed early on that i cannot select a column when its name has a space.[code]Now the statement i want to use is sql = "SELECT [PT.Chart Number],[PT.Last Name],[CA.Case Number] FROM Table1 AS PT INNER JOIN Table2 AS CA ON PT.Chart Number = CA.Chart Number ORDER BY PT.Chart Number"..When i Debug i get the same type of error ("... Can't find column name PT.Chart... ")I'm new to sql so i dont know if my syntax is off.
i am using the grid from dev express.. in vb.net 2005..when i choose a row to edit, in that row, when i select a particular column , then cursor show focus in that particular column , instead it is focused in the first column in that select row.
I have a column in DB called price with Decimal as its datatype. when I use:dim r as objectAccessConnection.Open()cmd = AccessConnection.CreateCommand()r = cmd.CommandText = "SELECT AVG (Price) FROM Sale;"I receive an error "Decimal byte array constructor requries an array of length four containing valid decimal bytes."It works fine with other datatype such as Integer and Double. What is my problem?
