Updating a Database via Datagrid Problem - Visual Basic Discussion Boards

Thanks 4 ur suggestion but i wonder how it is to be done. I didnt get how to create a centralised DB. Actually, as i said earlier i have no problem acessing the database from the applications in a shared environment of my network, except that only the crystal report has the problem since it doesnot point to the exact path that i have specified instead it retrieves from the local computer. So, pls can u help me with further details. My code for the Crystal Report part is as below;

With CrystalReport1
.ReportFileName = app.Path & "\Reports\rptmaster.rpt"
.Connect = app.Path & "\Database\db.mdb"
.SelectionFormula = "{tblContractor.CDBNo} = '" + Trim
(txtcdb.Text) + "'"
.DiscardSavedData = True
.Destination = crptToWindow
.WindowShowRefreshBtn = True
.WindowControlBox = True
.WindowState = crptMaximized
.WindowTitle = "SLAB RATE LEVY DETAILS"
.Action = 1
End With

ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggdfsgdsfgfdsgfdsgfdsgfds d fgdsgfdgfds ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff

Access wont support centralized db access for that matter..better use an RDBMS like SQL Server

Regards
Bino

Hey guys thanks 4 ur support, i hope now it solves my problem. Thanks ya again

ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggdfsgdsfgfdsgfdsgfdsgfds d fgdsgfdgfds ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff

if i have an image placed in myproject/images/test.jpg, should i also add it in my.resources? if i dont what would be the advantage or disadvantage? and what would be a proper relative path for this image if i dont add it in my.resources?????

(Jameel)

You can embed resources in an EXE or DLL project; the advantage is they no longer are
separate files, can't get lost, can't get replaced without the author knowing it, etc.

The alternative is having separate files; easiest way then is to add them to the folder
that contains the EXE/DLL and use relative paths.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google

i want to restrict user not to change the input-language if my application is active.. i tried the even "inputlanguagechanging" but it didnt work out when i changed the input language manually Frown | :(

any help if i want user not to change the language if my app is active..???

(Jameel)

You can't stop the user from changing the input language. All you can do is properly handle user input and output and adapts to the new language.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Hello,

In my small VB .NEt 2005 program. MS Access Database is coonnected via "Add New Souce" & added to the project. I have a DataGrid that is bound to a data source (Dataset) and Data Member is (tableName). I retreive data on basis of selection in the List. A query is called & saved based on List Selected item. Datasource of Datagrid is bounded programmatically. I want to add/edit and delte records in the Data Grid. I am not able to update the recor to the table. Dataset is updated. Here is the code to populate Datagrid and Update. On Update button click, UpdateDetails() is called.

<pre
'="" populate="" data="" grid
="" private="" sub="" populatedatagrid(byval="" index="" as="" integer)
="" try
="" retreive="" by="" passing="" category="" id="" and="" save="" in="" set
="" dim="" i="" integer="Me.TblEmployeeTableAdapter.FillByCatId(Me.EmployeeDataSet.Tables("Employee")," index)
="" msgbox("rows="" found="" "="" +="" me.employeedataset.tables("employee").rows().count().tostring())
="" me.employeedatagrid.selectionmode="DataGridViewSelectionMode.FullRowSelect
" set="" the="" dataset="" datasource="" for="" me.employeedatagrid.datasource="Me.EmployeeDataSet.Tables("Employee")
" catch="" ex="" exception
="" messagebox.show(ex.message)
="" end="" try

="" sub

="" update="" details="" called="" on="" button="" event
="" updatedetails()
="" me.employeedataset.tables("employee").acceptchanges()
="" me.employeedataset.acceptchanges()
="" msgbox("updated="" status=" + i.ToString())
End Sub
' aLSO TRIED THIS, BY DRAGING THE TABLE INTO THE FORM AND RESULTED AS MY OWN CREATED DATAGRID
Private Sub UpdateBound()
Me.Validate()
Me.EmployeeBindingSource.EndEdit()
Me.EmployeeTableAdapter.Update(Me.EmployeeDataSet.Employee)
' Me.EmployeeataSet.AcceptChanges()
End Sub
' USER DELETING ROW EVENT OF DATAGRID
Private Sub EmployeeDataGrid_UserDeletingRow(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewRowCancelEventArgs) Handles AlbumsDataGrid.UserDeletingRow
If (MsgBox(" are="" you="" sure,="" want="" to="" delete="" record="" ",="" msgboxstyle.yesno,="" "delete="" record?")="MsgBoxResult.Yes)" then

="" msgbox("record="" deleted")
="" else
="" if
="" sub
<="" pre="">

When user selects a row, and Clicks Del key, UserDeletingRow event is thrown by the grid. I had handled that event & asking for confirmation. Even if the user says "No", the record is deleted at present from the grid. How to stop it. Currently no delte code is written.

1. How do I stop the Delete Action if the user selects No

2. Why is the Upadate not functioning - not saving in the DB.

3. How do I know if the user is adding new row. And How do I insert that row in DB.

4. These all operations need to be done just via Update button.

So, basically I need to Add/Delete/Edit records in DataGrid. Just have a Update button. I have enabled Add New, Delete, Modifiy in Datagrid. Please guide me as what wrong I am doing & what chamges/implementationes need to be done. I don't know how to bind data by default by running such type of query & passing parameter, so have done it programmatically.

Please help me friends. I looked a lot on net, but couldn't find proper solution for my needs.

Any help is appreciated.

Thanks

Terry

I haven't done this myself, but I would think that the answer lies in the e argument of the UserDeletingRow event. Perhaps there is an e.Cancel or something like that, which you can call if the user says NO to the confirm messagebox. I'd suggest using intellisense to examine the e.

Oh Thanks Kschuler. That worked. Thanks a lot. Atleast my Delete part is up & running. I also figured out to Update Databse. Actually the point was, I had to select "Copy if newer" of CoptToOutputDire property of the database.

Now, I am wondering to validate the entered data. CurrentCellChanged is not working as accepted. RowValidating is also not helpful. I added RowAdded event and am able to know. But I can't get how to validate the entered stuff. I have Date & Cost which needs to be validated otherwise Datagrid throws its own Exception. Instead of Datagrid handling it, I want to handle & give appropriate message. Please help me if you can in this matter too.

Thanks a lot

Thanks

Terry

Sorry. I don't do much work with editting directly in a DataGrid. The only advice I've got would be to look through the possible DataGrid events and look for ones that might be what you want, then add code with messageboxes so you can see when the event fires. Perhaps you will find one that fires before the DataGrid throws its exception.

I think you could get away with posting this question again, though. And maybe someone else would be able to help you.

Good Luck.

just put e.Cancel=True in the else part of your code

If (MsgBox("Are you sure, you want to Delete the record ", MsgBoxStyle.YesNo, "Delete Record?") = MsgBoxResult.Yes) Then

MsgBox("Record Deleted")
Else
e.Cancel = True
End If

hi all,

i am developing program with vb.net 2005

i am using combobox and i set the AutoCompleteMode property to Suggest, so when i type something to there, it will appear a list for every the content that likes what i type..

the problem is.. when we click on the list... it will return keycode 13 or enter... how can i disable that...

is anybody have the answer?

Thanks...

You can check for keypress event for combobx and do nothing is keycode is 13...

Regards,
Nilesh

Hello,
I am not agree ur point. Because In all control's Keypress event thier will be event displayer commonly known as 'e'. if we use e we will get to properties like e.handler, e.keychar. From this e.keychar which will tell the current pressing/pressed key character.

From that we get 13,43,46 asci values which we currently using if we go for asc(e.keychar).

13 - for enter
32 - spacebar
46 - pullstop / dot

Senthil.S
Software Engineer.

hmm.. but i need the 13 keypress event ....

Hello,
It is easy if u follow the changes in the properties of combobox.

1. FlatStyle - System
2. AutoCompleteSource - ListItems
3. AutoCompleteMode - SuggestAppend

after completion of this. I think ur problem may solve

Senthil.S
Software Engineer

if i use the SuggestAppend AutoCompleteMode property...
when i use the mouse scroll it will not display all item in the combo box..
it just display item that like w type when we scroll it..

I want to temporarily disable the UAC, when i launch my Application and enable when i close the application.

I want this can be do in vb6.

Please give me any idea....

Thanks & Regards
Kumaran

File this under 'not a chance in hell'. UAC is about protecting the user from apps dong unauthorised things. What use would it be, if you could call an API that turns it off, while your app does whatever it likes ? ( no, I don't think you're writing anything malicious, but that's not the point )

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Becoz. I have my application while launch it has to register the component before executing exe.

That's why iam asking you. if you have any code please refer me.

Thanks & Regards
Kumaran

Well, apart from the fact that I'd never use VB6 for *anything*, my answer stands. I'm not saying you're writing anything bad, I am pointing out that even if you were not using an antiquated and dead language, you still would not find support for turning off a security feature using code, it's just not going to happen.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Kumaran21cen wrote:
I have my application while launch it has to register the component before executing exe.

That should be done during the installation phase. Installers run with elevated privilege.

Kumaran21cen wrote:
That's why iam asking you. if you have any code please refer me.

As Christian already said there is no code that will disable security procedures without the proper rights in place. If you want to disable a security feature you must already have the rights to do so. In order to get those rights you must go through UAC.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...

"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."

My website

What part of "IT CAN'T BE DONE" is so hard to understand??

Your code is not allowed to just "turn off" the UAC whenever it wants.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

hi all,

I want to make a program that can list all current connections and block/allow a program from connecting to the internet.

can anyone give me a tip where can I start ?

I've been doing some tricks with the xp sp2 firewall, but now I want to develop something that doesn't depend on it.

thanks