|
i am having my project in vb6.0,i have binded my controls at design time with Maindata(RecordSet).
Now i am binding DataCombo control at runtime(with new RECORDSET),when i am writing this code i am getting error in other events when my maindata(recordset)is getting updated.error is "Operation was cancelled" wt clould be the reason???????
This is the code,
Set PartyData = New ADODB.Recordset
PartyData.CursorLocation = adUseClient
If PartyData.state = adStateOpen Then PartyData.Close
PartyData.Open "select StkSuppliersMaster.name from StkSuppliersMaster join purinqparty on StkSuppliersMaster.code=purinqparty.suppliercode where purinqparty.mastid=(select id from purinqmaster where inqno=" & txtInqNo.Text & ")", db, adOpenStatic, adLockPessimistic
Set dbcParty.RowSource = PartyData
above code works fine if i write,
PartyData.Open "SELECT * FROM StkSuppliersMaster order by Name", db, adOpenStatic, adLockPessimistic
GIRISH
|
|
|
|
|
try adLockOptimistic.... May be then it works
colgateas900197
|
|
|
|
|
thanks for ur reply i will try and let u know.
|
|
|
|
|
inqno=" & txtInqNo.Text & ")",
You didn't include the character identifiers ( ' ).
Try:
inqno='" & txtInqNo.Text & "')",
Tom Garth
Developer
R. L. Nelson and Associates, Inc., Virginia
|
|
|
|
|
Hi guys!
I'm using MS Visual Basic 2005 Express Edition and I want to add a self made cursor to one of my projects. There are already some cursors to choose but there is no option where I can use my own one.
Do you know any way to use a selfmade one (I'm using "IcoFX" and "Pixel Toolbox").
Thanks and best wishes
|
|
|
|
|
|
I tried your method but there only appeared a error message.
I found this way to use a cursor: this.Cursor = new Cursor(GetType(), "MyCursor.Cur"); int the MSDN2.
However, this also didn't work. I copied the *.cur file into the project folder, but I cannot add it to the resources, because the program seems not to know *.cur files.
Can it be that the *.cur files aren't reconised as such, I had this problem with icons I wanted to use and to solve this problem I used another icon creator, but I already tried two cursor creators.
Does anyone know what I'm doing wrong?
Thanks and best wishes
|
|
|
|
|
The method you found on MSDN is in C#. It translates to :
me.Cursor = new Cursor(GetType(), "MyCursor.Cur")
Which is the same method (just a different signature) that I gave you. What is in the error message?
You shouldn't need anything copied into the resources, just somewhere on your computer.
I suggest using the FULL PATH (C:\MyCursor.cur) of the cursor, as it looks like you didn't copy the file to the output directory, and the relative path (MyCursor.cur) isn't pointing to the correct folder.
|
|
|
|
|
The error message says: "Unhandled exception in this application. Klick "Next" to to ignore the error and countinue with the application. Klick "Finish" to end the application immediately."
I translated it from German so this might not be the exact text.
I found out what I was doing wrong: Instead of single \ I used \\ (I think I know this from C++) and you're right me.GetType() isn't needed.
However, thanks much for your help.
Best wishes
|
|
|
|
|
hi all
i m developing an application basically a text editor
1. which can able to open files having extension like *.txt, *.csv, *.xls
2. which can able to edit all file that can be opened .
3. which can able to search a string in whole file.
4. and get all these things done as soon as possible (even if the file contains large amount of data)
i try to use rich text box control but that's not satisfying me because the speed of search is down when the file size increases.
if some has any idea then please suggest me
thnx in advance
help everyone
|
|
|
|
|
Again, I ask, how much text are you trying to search?? Size in MB would help.
If you're writing a text editor (are you?), there really isn't going to be anything you can do to make if search faster using the standard controls in the ToolBox. You'd have to find a third party control, but there isn't any way to tell how fast the search is going to be unless you try it.
|
|
|
|
|
not much data
(01,02,03,04,05.....so on) (not known how much user can enter. i will take 5 the limit)
the text to be search is not more then 10 to 15 char long (as i think).
can u suggest me whether i use multi threading of some thing else ....
help everyone
|
|
|
|
|
Multithreading doesn't make code any faster.
If you're using the Find method of a RTB, the ONLY thing you can do to make it faster is to reduce the amount of text you're searching in, NOT the text you're searching for.
|
|
|
|
|
is it possible to
1. divide the file in number of parts and then run each loop individually in different thread.
one question
how can windows word pad search faster on same amount of data.
help everyone
|
|
|
|
|
Because it's not a RichTextBox. The RTB you're using is a GENERIC RTB box that is not optimized for ANY particular use.
In your case, you'll have to implement your own code for representing the text and searching it. You cannot rely on the RTB to maintain the text string your searching and do the searching for you. You have to come up with your own representation and searching algorithm.
|
|
|
|
|
The size of text file is about of 10 to 15 MB.
which may or may not contain numeric value.
(the demo file i m working on contains numeric data.)
help everyone
|
|
|
|
|
Hi All, its me who is Stucked now
am using vb 2003. am searching the grid, i have a normal Search and a Advanced Search. my normal search is working fine and return the required results. on my advanced Search and using textboxes to search the grid. The following code is the SQl statement passed to the adapter.
SELECT Primary_ID, Boundary_area, Attrib_Code, Lis_Key, Func_Key, Actual_Extent, Improved_Value, Site_Value, Purchase_price, Purchase_date, prop_id, confidence_score, fin_ls_prediction, new_lis_key, new_func_key FROM Property_mass WHERE (SUBSTRING(Lis_Key, 1, 4) = @Num_key) ANd (SUBSTRING(Attrib_Code, 1, 1) = @Pair1_1) And (SUBSTRING(Attrib_Code, 2, 1) = @Pair1_2)
And the Following code is the code in my Search Button.
Dim strErrorMsg As String
Dim strerror As System.Data.SqlClient.SqlError
Try
SqlDataAdapter2.SelectCommand.Parameters("@Num_key").Value = CStr(txtlisSearch.Text)
SqlDataAdapter2.SelectCommand.Parameters("@Pair1_1").Value = CStr(pair1_1.Text)
SqlDataAdapter2.SelectCommand.Parameters("@Pair1_2").Value = CStr(pair1_2.Text)
'Filling the Dataset
SqlDataAdapter2.Fill(Pairone1)
If Pairone1.Tables("Property_Mass").Rows.Count = 0 Then
MessageBox.Show("Property with Such Code in this pair was not Found")
Else
Pairone1.Clear()
SqlDataAdapter2.Fill(Pairone1)
DataGrid1.DataSource = Pairone1
End If
Catch ExSQL As System.Data.SqlClient.SqlException
''''All this will trap all data Problems and Network if available
For Each strerror In ExSQL.Errors
Next
Select Case strerror.Number
Case 17
strErrorMsg = "Missing server"
Case 4060
strErrorMsg = "Missing database"
Case 18456
strErrorMsg = "Missing user name or password"
Case Else
strErrorMsg = strerror.Message
End Select
MessageBox.Show(strErrorMsg, "SQL Server Error: " & strerror.Number, MessageBoxButtons.OK, MessageBoxIcon.Error)
Catch ExcpInvOp As System.InvalidOperationException
MessageBox.Show("Close the connection first!", "Invalid Operation", MessageBoxButtons.OK, MessageBoxIcon.Error)
Catch Excp As System.Exception ' generic exception handler
MessageBox.Show(Excp.Message, "Unexpected Exception", MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try
In this code, there are Errors,but the bring incorrect results. i tried the SQL statement passed to the adapeter in SQl and replaced the variables with values and it working fine, now from my above code, i think the Problem should be here
SqlDataAdapter2.SelectCommand.Parameters("@Num_key").Value = CStr(txtlisSearch.Text)
SqlDataAdapter2.SelectCommand.Parameters("@Pair1_1").Value = CStr(pair1_1.Text)
SqlDataAdapter2.SelectCommand.Parameters("@Pair1_2").Value = CStr(pair1_2.Text)
'Filling the Dataset
SqlDataAdapter2.Fill(Pairone1)
but i cant understand how.So i have some questions.
1: IF the user has not inserted the value in e.g pair1_1 textbox, can it be ignored and run the query based on what it had been supplied.meaning cant we make this values optional?
Vuyiswa Maseko
|
|
|
|
|
Vuyiswamb wrote: IF the user has not inserted the value in e.g pair1_1 textbox, can it be ignored
The only way to ignore the condition is it's removed from the SQL statement's WHER clause.
Vuyiswamb wrote: .meaning cant we make this values optional
SQL doesn't support optional parameters.
You basically have to generate the SQL string dynamically, adding just the conditions that are supplied by the user.
|
|
|
|
|
|Dave Kreskowiak wrote
The only way to ignore the condition is it's removed from the SQL statement's WHER clause.
how am i going to return the user's required results if i dont use where in my SQl statement?
|Dave Kreskowiak wrote
You basically have to generate the SQL string dynamically, adding just the conditions that are supplied by the user.
How dynamically, i dont understand.please post an example code or point to an article.
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
|
|
|
|
|
Vuyiswamb wrote: how am i going to return the user's required results if i dont use where in my SQl statement?
You said you want the statement to ignore certain parts of the WHERE clause. Since you can't do that, you have to REMOVE THOSE PARTS FROM THR WHERE CLAUSE.
By removing certain conditions from the WHERE clause, this:
SELECT someColumn1, someColumn2, someColumn3 FROM table WHERE condition1 AND condition2 AND condition3
becomes:
SELECT someColumn1, someColumn2, someColumn3 FROM table WHERE condition1 AND condition3
Vuyiswamb wrote: How dynamically, i dont understand.please post an example code or point to an article.
Check each part of the UI for a value entered by the user. If each condition, add it to the end of the SQL statement. Greatly simplified, it looks like:
Dim mySQLstring As String = "SELECT someColumn1, someColumn2, someColumn3 FROM table WHERE"
If someCondition Then
mySQLstring = mySQLstring & " condition1 "
End If
If someCondition Then
mySQLstring = mySQLstring & " AND condition2 "
This logic will NOT work!! If makes certain assumptions about the presence of the "WHERE" in teh SQL statement and doesn't check to see if an "AND" is required between conditions!!
|
|
|
|
|
Thank you veryt much Sir
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
|
|
|
|
|
Can anyone point me to a good article or examples where I can get some information on best practices for formatting the structure of my code. In particular, I am looking for a good examples that separates screen, business, and data logic and the types of functions found in each. I have searched the internet but seem to be coming up short.
Thank you
digicd
|
|
|
|
|
My Laptop has 512MB RAM, When my project running, time to time it raises unhandled exceptions. Called, ExecutionEngineException, NullReferenceException WIn32Exception and so on. But I ran it another PC which has 1GB RAM. In that PC not raised any errors, working fine.
What can be an error?
I am using VB.NET 2003 and MS Access 2003.
I have to present my project in my LAPTOP (512MB RAM) So what can i do?
Can anybody help me?
Dimuthu
Dimuthu
|
|
|
|
|
Hi,
the obvious answers:
1. borrow/rent another laptop
2. add memory (512MB is really not enough for typical development work)
3. reboot, don't run anything you don't need
4. Switch off networking, Wireless, Bluetooth, ...
5. remove everything you don't need from memory, including a lot of little handy
utilities such as:
Google Desktop Search
DVDLauncher
Acrobat Assistant
Microsoft Office QuickLaunch
Adobe Reader Speed Launch
etc.
You could try how much memory is needed on the working PC by adding stuff into memory
until it starts to fail.
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
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
