|
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
|
|
|
|
|
hi,
i'm want to know is that posible if i can use variable instead of listbox.
for example if i have label1, i can use variable by using 'dim lbl as string',
is there posible if i use the same method for substitute listbox control?
i dont know what to type to google it..
plz..
|
|
|
|
|
dim Str as list(of string)
Str.add("Hello")
etc...
|
|
|
|
|
What are you trying to achieve?
A variable is memory storage and a ListBox is a User Interface control with properties. You can dim a control like a variable e.g. Dim myListBox As ListBox or Dim Label1 as Label
A ListBox is affectively a control for displaying collections (including DataRows) or arrays.
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
explore you question in more detail.
if you want to add a item to list box for each label, then you can use Array
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
i am working in VB6, a window base project
use a adodc control
i give
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\sms.mdb;Persist Security Info=False"
on form load
and in properties window i leave blank the connection string
but its not working
Error: [microsoft][odbc driver manager]Data source name not found and no default drive specified
and if i give any connectionstring in the properties of adodc control then it is hardcode i have to avoid that
Please help me
battan20@gmail.com
|
|
|
|
|
i am using MS access file in that project
|
|
|
|
|
how about using adodb instead of adodc?
just a suggestion
i have exacly no clue about your problem 
|
|
|
|
|
Amit Battan Ror wrote: i am working in VB6
Sorry to hear, since VB6 has been dead for quite some time now...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
hi,
in have a public function, let say
public function Merge(.........) as image
(some code)
end function
how can i call this function in my button click event?
i never use this method before, after google it i just find call function
from other developer software like javascript, c and c#
plz help me..
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
