Visual Basic

DataAdapter - UpdateCommand not working

30-Aug-05 7:30

If you're going to have spaces in your filepath, you MUST enclose the entire path in quotes.

Open """" & appPath & songTitle & "mood.txt""" For Append As #FileNum4

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

dptalt30-Aug-05 5:42

Re: DataAdapter - UpdateCommand not working

30-Aug-05 5:42

Why does'nt the UpdateCommand of my DataAdapter update the table?

Dim myupdate As String = "update usersecurity set haveaccess=1 where usernamesid=2"

myadapter.UpdateCommand = New OleDbCommand(myupdate, myconnection)

Dim myselect As String = "select * from usersecurity"
myadapter.SelectCommand = New OleDbCommand(myselect, myconnection)

Dim mydatatable As New DataTable
myadapter.Fill(mydatatable)
myadapter.Update(mydatatable)

Thanks for any help.

Mark0630-Aug-05 12:14

Mark06

30-Aug-05 12:14

Does it just fail to update, or do you get an error message when myadapter.update(mydatatable) executes?

If it just doesnt update, is there definitely records that meet the criteria.

Also, you could always try a command instead:

Dim myupdate As String = "update usersecurity set haveaccess=1 where usernamesid=2"
dim mycmd as new OleDbCommand(myupdate, myconnection)
try
mycmd.executenonquery
catch e as exception
console.writeline (e.message)
end try

Re: DataAdapter - UpdateCommand not working

dptalt31-Aug-05 2:41

Windows Logon in Visual Basic?

31-Aug-05 2:41

Adding cmd.executenonquery fixed it. Thanks alot for the tip.

sepp130-Aug-05 3:21

sepp1

30-Aug-05 3:21

Dear Friends,

how Can I call the Windows Login Window from Visual Basic. I am lost with this problem since some days.

The program should only continue if the user has entered the correct Windows Username and Password.

Regards
Josef

Josef

Dave Kreskowiak30-Aug-05 7:22

30-Aug-05 7:22

You can't call the dialog from an app. You have to supply your own login form that gets the users name and password, then authenticate them yourself.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Colin Angus Mackay30-Aug-05 9:40

Colin Angus Mackay

30-Aug-05 9:40

One would assume that they are already logged in, so why get them to authenticate again?

Also, from a psycological point of view, asking a user to supply their log in credentials too frequently will desensitise them from thinking about why they are being asked for the information and will supply it blindly when asked. This is something that scammers take advantage of when attempting to gain illicit access to a computer system.

sepp130-Aug-05 22:00

sepp1

30-Aug-05 22:00

The reason for this is, that when they open the app, they see very sensitive data. It has to be prevented, that someone can log on to the application on an unlocked PC. As I do not want to use an Internal User/password list, I would like to use the Windows logon. (I have an internal username/password list in some other applications and there they always forget their password.

REgards
Josef

Dave Kreskowiak31-Aug-05 2:33

Find max value in data Grid

31-Aug-05 2:33

Well, in a law enforcement sensitive environment, each system/application has it's own username and password, because of the sensitive nature of the data inside. Reason being is a user doesn't have one single key to unlock everything. If one userid/password is compromised, that same userid/password can't be used to gain access to and/or do further damage in other systems.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Jeeva Jose30-Aug-05 3:17

Jeeva Jose

30-Aug-05 3:17

I have a column that contain 7 rows how can find maximum value
in the grid

1,2,3,4,5,6,7

7 is max value how to get it

anybody help me

Continue...

Re: Find max value in data Grid

_mubashir30-Aug-05 4:24

_mubashir

30-Aug-05 4:24

Hello!

You can access each cell element in datagrids and by this you can loop throug the cells till you find out the max value.

Access cells like this
DataGrid1.Items(RowIndex,ColIndex) in vb.net

For you case
DataGrid1.Items(0,0) will return 1 and so on...

Now you can use any algo to find max......it is basic
I hope this will help u out...!

_mubashir

.Net Sockets

Jason Weibel30-Aug-05 3:11

Jason Weibel

30-Aug-05 3:11

I'm working on a socket program using .net and going against a Unix server. The delays in the following code are needed for it to work correctly. Can anyone help me find a way to get this working without adding the delay?

<br />
    Friend Function Insert(ByVal Name As String, ByVal Client As System.Net.Sockets.TcpClient, ByVal netStream As NetworkStream, ByVal sr As StreamWriter) As String<br />
<br />
   Dim InsertRequest As String = "INSERT::" & Name & ";"<br />
   Dim sendInsertRequest As [Byte]() = Encoding.ASCII.GetBytes(InsertRequest)<br />
   ''// Submit Insert Request<br />
   sr.WriteLine("CMD-" & vbTab & InsertRequest)<br />
   netStream.Write(sendInsertRequest, 0, sendInsertRequest.Length)<br />
<br />
   ''// Get Response<br />
   Dim Response As String = GetResponse(Client, netStream, sr)<br />
   Return Response<br />
    End Function<br />
    <br />
    Private Function GetResponse(ByVal Client As System.Net.Sockets.TcpClient, ByVal netStream As NetworkStream, ByVal sr As StreamWriter) As String<br />
   ''// Add Delay<br />
   System.Threading.Thread.Sleep(m_delay)<br />
   ''// Read Buffer and Write to Open File<br />
   Dim numberOfBytesRead As Integer = 0<br />
   Dim bytes(Client.ReceiveBufferSize) As Byte<br />
   Dim returndata As String = Encoding.ASCII.GetString(bytes)<br />
   Dim SocketData As New System.Text.StringBuilder<br />
   Do<br />
     numberOfBytesRead = netStream.Read(bytes, 0, uCVT.IntNulls(Client.ReceiveBufferSize))<br />
     returndata = Encoding.ASCII.GetString(bytes)<br />
     returndata = Microsoft.VisualBasic.Left(returndata, numberOfBytesRead)<br />
     SocketData.Append(returndata)<br />
     System.Threading.Thread.Sleep(m_delay)<br />
   Loop While netStream.DataAvailable<br />
   sr.WriteLine("RSP-" & vbTab & SocketData.ToString)<br />
   Return SocketData.ToString<br />
    End Function<br />

Thank you,

Jason W.

how to make a datagridcolumn as combobox

kpsetty30-Aug-05 2:46

kpsetty

30-Aug-05 2:46

hi friends,

i am new to vb.net window applications,i don't know how to make a datagrid column as combobox and at the same time i need to bind the data to the combobox from the database.is anyone knows please help me

[Message Deleted]

dptalt31-Aug-05 3:42

Re: how to make a datagridcolumn as combobox

31-Aug-05 3:42

[Message Deleted]

dptalt31-Aug-05 4:00

Re: problrem in sql statment

31-Aug-05 4:00

Take a look at this link:
http://www.codeproject.com/cs/miscctrl/datagridcomboboxcolumn.asp

problrem in sql statment

microuser_200030-Aug-05 2:30

microuser_2000

30-Aug-05 2:30

hellow to all ..
i am trying to write sql statment , it run fine ..
but when i run the statment i have this error "Syntax error in FROM clause"
her is my code

Dim sConnection, ssql, cmtype As String
sConnection = "provider=microsoft.jet.oledb.4.0;data source=C:\Printers.mdb"
ssql = "Select * From add Where(type="
ssql = ssql & "'" & Cmbtype.SelectedItem & "')"

Try

Dim OleDbConn As OleDbConnection = New OleDbConnection(sConnection)
OleDbConn.Open()
Dim MyDataReader As OleDbDataReader
Dim MyOleDbCommand As OleDbCommand = New OleDbCommand
Dim MyDataSet As New DataSet
Dim MyOleDataAdapter As OleDbDataAdapter = New OleDbDataAdapter
MessageBox.Show(ssql)
MyOleDataAdapter.SelectCommand = New OleDbCommand(ssql, OleDbConn)
MyOleDataAdapter.Fill(MyDataSet)
MyOleDbCommand.Connection = (OleDbConn)
MyOleDbCommand.CommandText = ssql

MyDataReader = MyOleDbCommand.ExecuteReader

Do While MyDataReader.Read

cmbModel.Items.Add(MyDataReader("ADD.[דגם מכונה]"))

Loop

MyDataReader.Close()
OleDbConn.Close()
OleDbConn.Dispose()

Catch err As System.Exception
MessageBox.Show(err.Message)
End Try

thxx for anyhelp ...

Dave Kreskowiak30-Aug-05 2:41