Using vb2005 and .Net 2.0. I've been trying for some time to get my query to work. I've posted my issue on several forums but no one been able to asssist me. From code behing I need to query Active Directory and have following issues:
1. I need to select only where "title" is empty and
2. I need to do a LIKE on sAMAccountName
[Code]...
I need to query AD to work out what access a user has to my application.I have 7 AD groups (FTP1 to FTP 7), these groups can have other groups added so I'm using GetMembers(True) which is recursive.The below function works great but it's a little slow, is there any obvious changes I can make to speed it up?[code]
View 6 RepliesI've never scripted anything before,Using Listing 6 from [URL].. I have amended the script for my domain, and the response is correct for the Default Domain Policy. However we have a different password policy for an OU within the domain, so I amended the script as follows:
[Code]...
I hoped this would pick up the maxPwdAge which is set for this OU, but the response I get says the max password age is 0. This is not the case. The max password age is 2 (doing some testing), but it can't see this. Have I done something wrong, or can this script only see the Default Domain Policy, and not the individual OU policies?
Im just trying to figure out how to write an LDAP query to list all of the PCs in a specific OU.
View 3 Replieshow i can get a list of users who are members of a group in Active Directory. A vb.net example would be great. I can list all users in AD, but cannot get just the users in a group.
Also do anybody know of a really easy tutorial on LDAP queries with vb.net examples.
CODE:
And the following sub routine is load in the Listbox_selectedindexchanged event
CODE:
And listitem class
CODE:
And subsequently I want to Design the select query by adding the three column i.e. First Name, Middle Name and Last Name in the Listbox and by selecting the list item that will show in text box.
in below code there is syntax error in from Clause but i think every thing looks fine iam using access database thx and relation is fine between thes two table
Public Function GetGridData() As DataTable
Dim dt As New DataTable
Try
[code].....
i am trying to bind a dropDownList control to a select query that has a parameter.the query itself runs fine on sqlserver database when the paramter is replaced with an actual datetime variable.the basic query is: SELECT DISTINCT DeliveryZone FROM dbo.tblComplaints WHERE (DeliveryZone IS NOT NULL)AND (DeliveryZone NOT IN ('**', '??', 'EE', 'T', 'M'))[code]
View 1 RepliesI make a query in coding. But I got conversion error.My query is below
Dim strSelect As String = ""
strSelect = "SELECT " & _
"Description As [Desc], " & _
[code].....
Exception error is like
Conversion from string "iif(CurCons = 0, " to type 'Double' is not valid
Actually, in my report, i wanna show if it's zero then '-'. If i set it in this string.I got another error like below The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value.
From da.Fill
Dim cmd As New OleDbCommand(strDynamic, m_DBConn)
Dim da As New OleDbDataAdapter(cmd)
da.Fill(ds, "tblCur")
I am using/creating a DataTable so the "enforceConstrains" property is not avilable for DataTable.Error message: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Windows Form Load Event:
Private Sub Expenses_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
expensesGV.DataSource = listExpenses()
expensesGV.Columns(0).Visible = False
End Sub
Here is a code to insert data to DBaccess from textbox. When I write a colon(') in the textbox to add to DB it caused error and show me this Message "Syntax error in string in query expression '''')'
Code:
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source =" & Application.StartupPath & "Store.mdb ")
Dim cmd As New OleDbCommand
cmd.Connection = conn
'Add text to DB
[Code] .....
I want to select to multiple sql tables using select query in vb.net..I have 2columns in sql table..I have tried this query.. But i'm getting error.
TextBox11.Text = Val(27)
cmd = New SqlCommand("SELECT outside,power FROM vijay21 INNER JOIN vijay22 ON vijay21.outside=vijay22.outside WHERE outside BETWEEN " & Val(TextBox11.Text) & " AND " &
[code].....
When Creating a query using the sear Criteria Builder . I keep getting the error : "The schema returned by the new query differs from the base query" what does that mean and how do i avoid this problem in future
View 2 Replies1st i get this error
query error and Conversion from string "Insert into Table1 (cust_id," to type 'Double' is not valid.
when inserting data to database 2nd error is
when use employee name to get employee id i got result always 0 here is the code
" select id from customers where name2='" & ComboBox1.Text & "'"
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
i should say hi experts :D . Help me with this pretty code :)
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
I have 7 company Divisions that sit in an access database.I then use this list to populate two comboboxes in my windows form.However I get a syntax error in my SQL Query if the Division name is more than one word.For example in my access database I have two columns one is a status column and the other is a division column. If for example the Division is called 'Corporate' the status column is called 'Status Corporate' and the division column is called 'Corporate'.The SQL query works fine in this scenario.However if I have a Division that is more than one word, lets say 'Operations Division' I get an error in my SQL Query that says -
Quote: Syntax error (missing operator) in query expression 'Operations Division'.Here is my code
sqlNewTenderDetails = "SELECT " & Me.DivisionBox.SelectedValue & " From BidRefCodes Where " & "[Status " & Me.DivisionBox.SelectedValue & "='Active'"
daNewTenderDetails = New OleDb.OleDbDataAdapter(sqlNewTenderDetails, NewTenderDetailsTableCon)[code]....
I got a SQL statement where am selecting from an access database in vb but I get this error; "syntax error in query expression select sum(brought_qtty)" when I run my program. I imagine am doing the right thing but seems am not. How can I adjust this select? The code is below:
"select distinct(brought_price) as [Price], select sum(brought_qtty) as [Ordinary] from brought_coffee where " & _"coffee_grade=O, select sum(brought_qtty) as [Premium] from brought_coffee where" & _"coffee_grade=P, sum(brought_qtty) as [Total Qtty]" & _", sum(brought_paid) as [paid], " & _"sum(brought_bal) as [Balance]" & _"from brought_coffee, farmer where brought_date=#" & dtc.Text.Trim & "# and farmer_centre='" & cc.Text.Trim & _"' and farmer.farmer_num=brought_coffee.farmer_num"
I've recently been trying to figure out a way to get parameterized queries to work and i think i'm almost there but seem to be getting an error when executing my query
Here's the code
[code]...
I'm trying to get a simple count of rows meeting some criteria. The value returned does not coincide with the correct number of rows when running the same query in Management Studio (SQL 2005)
vb.net
Public Function RowsAffectedCount() As Integer
Dim result As Integer = 0
[code]....
'result' always returns 1, but I have 3 records meeting that criteria in the database. Been staring at the code for a couple hours now and can't figure it out... I just need to know if the Count of rows returned from a SELECT statement is greater than 1 (at least two records).
I have an ado.net statement I want to convert to use NHibernate:
Dim sql As New StringBuilder()
sql.AppendLine("SELECT r.RoleId, r.RoleName ")
sql.AppendLine("FROM dbo.aspnet_Roles r ")
[code]...
I have pulled information from a database into a datatable (dtCustomerInfo) then I expanded on the columns by processing the data and I can display this in a datagridview without any problem. However, the data is in detail and I want to ultimately summarize by customer name.The code below has a commented sql statement that is the statement I ultimately want but it is not working. However, the idea is that I want to Select from one datatable into another but run aggregate sum on several columns so that I will get one record per customer showing totals for each column.So I broke it down to just pull all data possible into the second table.[code]I do know the grouping in the current select * statement does nothing but my issue is more that the columns do not show up.
View 3 RepliesOn an SQL query I have. I have the select query working fine but according to the result I need to set the column of a table to 0. I have the following Select query:
CODE:
So where the CommissionCalculator SetUp > 0 I want it to Update the CommissionStructure SetUp column to 0. I was thinking I might need an IF statement but I dont know how to work with them in SQL.
I'm tying myself in knots with AND OR NOT qualifyers to return all rows having two different items. From a column headed 'Instrument' I want to retun 'CELLO' and 'VIOLIN' Where am I going wrong with the following?
View 8 Repliesclass:
Public Sub insetTotalPaidAmt(ByVal dtSDate As Date)
Dim comm As OleDbCommand
Try
strQry = "INSERT INTO rpt_Paid_Amt(ST_ID,ST_PAY_AMT,ST_DIS_AMT) " & _
"SELECT S.ST_ID,SUM(P.PAY_AMOUNT),SUM(P.PAY_DIS) " & _
[Code]...
how to select multiple table in vb2010? i trying to create a login so i need to retrieve the data in 3 different tables in one database i have a code but not work.[code]
View 2 RepliesLinq to SQL query to Select the maximum "MeanWindSpeed" value? The database name is "WeatherArchives" The TableName is "TblValues" The Column is "MeanWindSpeed" And Also, I would like to have a query to get me the Max "MeanWindSpeed" in each year,
View 1 Repliesi have a project which is room scheduling. i'm having a problem on how to make my query to be able to select the available rooms for the givin time start and time end.
View 14 RepliesI am trying to link to a Access database at runtime using a SELECT FROM WHERE query, which I can do but.......
with the WHERE part I want to select several conditions, 4 actually and it is not working, what am I doing wrong?
Here is my code,
Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=V:GYMDBFLineProdSanderProduction.mdb")
[Code]....
Public Shared Function getrealrequests(ByVal itemname1 As String) As ArrayList
Dim sqlStr As String = "data source=localhost;initial catalog=Customers;integrated security = true"
Dim dbRecords As ArrayList = New ArrayList
Dim dbConn As SqlConnection = New SqlConnection(sqlStr)
[Code] .....
I'm trying to pass the value of 'itemname1' to the select query. What's the correct syntax to get it to work?
