|
i am using following code in vb6
Private Sub cmdDelete_Click()
On Error GoTo DeleteErr
With datPrimaryRS.Recordset
.Delete
.MoveNext
If .EOF Then .MoveLast
End With
Exit Sub
DeleteErr:
MsgBox Err.Description
End Sub
but it give error:
Insufficient key column information for updating or refreshing.
it remove the data from datagrid but not from ms access database
please help me
battan20@gmail.com
|
|
|
|
|
hi Amit Battan Ror
Have you initiated a Development in vb6?
If so,VB6 its Dead incase you dont know. Try to learn C# or vb.net.If your Company is Still Planning to keep vb6 apps and you have to maintain them, start sending out your resume because you are going to kill your skills. Now lets get back to your error.To update a Database record.. the Server has to know exactly which record it is that you want to change.. ie. it needs a UNIQUE key of some kind to process the record. IF in your DataBase table you do NOT define a field as being unique, ADO will look at the data and then try to build a (temporary)UNIQUE key.. which then can be used to perform the update. Sometimes ADO
is successful in doing this.. and sometimes it is NOT (as witnessed by your present dilemna).The first thing you should do is go and check the Tables you are using to make sure that each of them has at least ONE unique field defined.. and if there is none.. add a Unique identifyling field (such as an Autonumber) to it.
Hope it helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Go to the table that you want to Update and make sure that there is a Primary_key, What database are you using?, Send me a Structure and will help you.
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hello Everybody
I have 3 form on my project
1. frmNewOrder (have a button called btnPayment also have orderID)
2. frmExistingOrder (have a button called btnPayment also have orderID)
3. frmPayment
when you click btnPayment from frmNewOrder or frmExistingOrder then how can I send orderID value to frmPayment
I have done something
Public Shared OrderID As Integer (on frmNewOrder)
I put code on frmOrder page load events
orderID = frmNewOrder.OrderID
I know its really a wrong concept.
Any idea or example will be really helpful
Thanks in Advance
Sarfarj Ahmed
|
|
|
|
|
how are you creating a new instance of frmPayment? in the click event of btnPayment correct? Pass the value into frmPayment after creating the instance.
dim frmPay as new frmPayment
frmPay.OrderID = me.OrderID
frmPay.showdialog
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|
|
thnks for ur reply
i have already solved my problem form google help
thank u very much
Sarfarj Ahmed
|
|
|
|
|
Hi,
If frmPayment isn't equal to nothing then you can set a variable in frmPayment through a public property.
e.g.
in frmPayment:
dim intOrderId as integer
Public WriteOnly Property OrderID() as Integer
Set(byval value as Integer)
intOrderId = value
End Set
end property
and in frmNewOrder:
frmMyPayment.OrderID = orderID
However, if frmPayment is not yet initialised, you can call the new constructor passing the orderid as a parameter.
e.g.
in frmPayments:
public sub new(byval orderID as integer)
me.intOrderID = orderID
end sub
and in and in frmNewOrder:
Dim frmMyPayment as new frmPayment(orderid)
Is this OK?
|
|
|
|
|
Can some body help in reading the EDI files using VB.net or C#
|
|
|
|
|
Your question is pretty much unanswerable considering you haven't said anything about what your doing with the file. Reading an EDI file is just like any other text file. Parsing it and getting data out is another story. You may want to make your life a bit easier by Googling for "edi tools for programmers".
|
|
|
|
|
Thank your for the suggestion. We are having a Practice Management product in which we generate EDI 837 and parse 835, 276, 277 and etc and take the data out. The current system is very slow(i.e. for parsing 835 file which has 3000 transactions takes about 3hrs). we have designed the product using VB & SQL Server. So I am looking for the better approach.
|
|
|
|
|
K Suresh Reddy wrote: for parsing 835 file which has 3000 transactions takes about 3hrs
If it's going that slow, you've got some serious design issues in your app. You're going to have to find out what part(s) of your code is taking so long to execute, then look at methods of speeding those sections up. This is probably going to require you redesigning your application. There's three glaring possibilities.
The parser may be slow. The easiest thing to do is to use a third-party library designed specifically to parse the files and return the data to you.
There may be a data processing problem. What are you doing with the data once you get it out of the parser?
Your SQL code may be inefficient. You may be doing a bunch of sutff using SQL in your VB.NET code instead of using stored procedures or some other more efficient use of the SQL processing power.
|
|
|
|
|
Hi,
I am binding a data in a detail view at run time. But I also want to edit it at the run time. I have tried the following code.
Protected Sub Detailsview1_ItemUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewUpdateEventArgs) Handles Detailsview1.ItemUpdating
Dim index As Integer = Generic_DG.SelectedIndex
Dim con As New SqlConnection(ConfigurationManager.AppSettings("connectionString"))
Dim cmd As New SqlCommand()
cmd.CommandText = "UPDATE Products SET ProdName=@ProdName where ProdId=@ProdId"
cmd.Connection = con
cmd.Connection.Open()
cmd.ExecuteNonQuery()
cmd.Connection.Close()
End Sub
How can I replace @ProdName with data in a detail view?
OR
Which property of the detailview I have to use for it?
Rock Star
|
|
|
|
|
hi
I see what you are trying to do , but your question says something else, now from what i see from your code, you have parameters that are not declared.
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
hai friends
i developed a software thru vb.net windows application
now i will give it to clients for trial
but it should run only for 20 times
if the software is loaded into another system then it should not run
if the count is 20
plz help me
thanks in advance
vijay
|
|
|
|
|
you can store the number of run in database.
on project startup , check whether count is 20,if yes then close the application otherwise increment the number of run by 1.
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
hai rupesh
is there any other option other than "storing count in database"
thanks for u r reply
vijay
|
|
|
|
|
you can store it to a text file
then rename it so that your clients cannot change the data in the text file
e.g.
you can encrypt the '20'
so that the client cannot read it easily
|
|
|
|
|
That would be a bit drastic, wouldnt it? A database just for one number??
Lloyd J. Atkinson
"Logic will get you from A to B, but imagination will take you everywhere" - ALbert Einstein
I look at Microsoft, and turn to my poster on the wall saying: "Bang head here in case of stress".
|
|
|
|
|
vijaylumar wrote: if the software is loaded into another system then it should not run
That's not possible. Each machine will store the number of times run, if you write code to do it. If the user finds how you stored it, they can easily reset it. A new install can't tell if the same user has run it on another machine.
The only way to do that, is to make the machine require the internet. Then you can give a license code for your demo, have it use a webservice to store how often it's been run and to check every time the user runs it. Of course, given it's a .NET program, users can decompile your code, remove the check and recompile it.
Christian Graus
Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
|
|
|
|
|
i want to make a program that can add dll's dynamically
the dll's i made has forms in it that the user can call
through the program
the problem is i dont know how to add a dll just without
manually adding it to the source code
is there a way that the program can list all the dll's i made
from a specific folder?
can anybody give me a sample program?
pleeeeeeeeeeeez
|
|
|
|
|
|
yeah plugins was the one in my mind earlier i just dunno how to do it
thanks for the reply..
|
|
|
|
|
Hello,
Visual Studio 2008 Development Edition
For some reason can't seem to add a new dataset and display the designer, where you create or drag data tables and table adapters on to.
When I Add new item | select dataset. All I get is the files listed below:
DataSet1.xsd
DataSet1.Designer.vb
The above is using my work computer. I have exactly the same version of visual studio 2008 development edition on my home computer. And there I don't have the same problem. I am able to drag the data tables on to the designer.
I have asked another work friend to check his verison on his computer. He is able to get the designer so his is ok, and has the same version as me. But on my works computer I have this problem
When I add the new dataset I just get this being displayed below.
I have also uninstalled visual studio 2008, and then installed it again. Still the same problem.
Many thanks for any help with this.
[code]
<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="DataSet1"
targetNamespace="http://tempuri.org/DataSet1.xsd"
elementFormDefault="qualified"
attributeFormDefault="qualified"
xmlns="http://tempuri.org/DataSet1.xsd"
xmlns:mstns="http://tempuri.org/DataSet1.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
<xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded"></xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
[/code]
|
|
|
|
|
Ciao a tutti, ho un problemino e spero che qualcuno possa aiutarmi.
in vb.net dovrei creare un form di opzioni simile a quello che si vede in word 2007, ossia a sinistra una lista di categorie (che ho fatto utilizzando un controllo treeview) e a destra dovranno apparire i vari settaggi collegati alle categorie. Il punto è che non vorrei utilizzare un Tabcontrol ma vorrei che la pagina si aggiornasse automaticamente con i controlli a seconda della categoria scelta.
spero di essere stato chiaro.
Grazie a tutti.
|
|
|
|
|
post your problem in English language. so everyone can understand and you will get correct answer.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|