|
Dear Rupesh Kumar Swami
Thanks for help
But I face an error like :
Microsoft.WindowsMobile.Utilities.Registry from assembly Microsoft.WindowsMobile.Utilities, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35.
this above error in line
AddHandler callState.Changed, AddressOf callState_changed
|
|
|
|
|
Nimesh U wrote: Microsoft.WindowsMobile.Utilities.Registry from assembly Microsoft.WindowsMobile.Utilities, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35
That's not an error. It's the fully qualified name of an assembly.
What's the error message?
|
|
|
|
|
hi nimesh,
do not add one more new message for continue the previous message. select reply from previous message.
by the way,are u add following reference in your application ?
if No then add this reference
Microsoft.Windowsmobile<br />
Microsoft.Windowsmobile.status<br />
Microsoft.Windowsmobile.Telephony
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
Hi all,
Does anybody know how to merge cells in DataGridView like in FlexGrid in
VB6?
There was an method MergeCol and MergeRow.
I am using DataGridView with an DataSet, exactly for this reason, because
I need one row with 3 cols, and the next one with only one col.
Something like this
------------------------------------------------------
¦ some data ¦ some data ¦ some data ¦
------------------------------------------------------
¦ Some other data should be here ¦
------------------------------------------------------
¦ some data ¦ some data ¦ some data ¦
------------------------------------------------------
¦ Some other data should be here ¦
------------------------------------------------------
¦ some data ¦ some data ¦ some data ¦
------------------------------------------------------
¦ Some other data should be here ¦
------------------------------------------------------
Thanx in advance
Know is Drop, Unknown is Ocean
|
|
|
|
|
Exelioindia wrote: Does anybody know how to merge cells in DataGridView
Not supported. You'd have to create your own version of the DGV to do this, supplying the property, drawing, and edit code to render the rows cells and still have them be editable. This will be a LOT of work to pull off.
Merging cells in DataGridView[^]
|
|
|
|
|
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!!
|
|
|
|
|