|
dear friends,
can any one of you tell me how to verify whether the right click
is on row heading or on the worksheet cell in Excel.
i need to catch this event in my VBA code.
thanks and regards
prahant
|
|
|
|
|
hi there,
I have read some articles on event , raise event , delegates ,SerializATION
None of them exactly explains it's utility in real life projects.
I just need one or two simple advantages that y should i use these terms in the projects.
Please refer articles that briefly explains it's advantages.
|
|
|
|
|
Well I think that you will find events and delegates useful by just attempting to build Windows Application with GUI. If your applcation will grow a bit, then you'll find also useful raising events.
Well Serialization will come into play as your application will need to remember it's last execution state (or even if you need to make some operation undo-able).
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
Hi there,
i have a long operation in the form that continues fo 12-15 minutes.
Now my question is
1.Can i show the progress bar in different window that show the pogress of the operation.currently i am using the PROGRESS BAR IN THE DIFFERENT WINDOW.
2.Does SHOW/SHOWDIALOG has anything to do with this problem?
|
|
|
|
|
1. First of all you have not written your problem clearly. You are currently using progressbar in different window. then what is the problem?
2. SHOW/SHOWDIALOG does not effect anything in this problem
|
|
|
|
|
There are two different versions of anything called a "Progress Bar".
The first is one where the progress bar goes from 0% to 100%. In order for this to work, your code has to know where the stopping point is in order to generate a value that can go from 0 to 100. It also has to update the progress bar (noone cares what form it's on!) every once in a while with the current value of the progress.
The second is a progress bar that doesn't, well, progress. What that means is that your code doesn't need to know how long a process will take or show any actual progress. The progress bar just displays a moving image that show something is going on. It has no idea how long the process will take or how long it has yet to go.
So, which is it for you?
|
|
|
|
|
Hi there,
I know there is no pointer concept in vb.net.
Now my question is
Does self referential classes has anything to do with the pointers?
If yes can somebody refer an article to understand it?
|
|
|
|
|
Nilish wrote: Does self referential classes has anything to do with the pointers?
No, but it can be implemented with pointers. As the name suggests a "Self referential" class is one that referes to itself (usually a different instance). In .NET this would be done with references (another hint the name of the concept gives you).
|
|
|
|
|
Colin , can u provide an article ?
|
|
|
|
|
Nilish wrote: can u provide an article ?
Have you tried Google?
|
|
|
|
|
yes , i have . But specifically with pointers , I am not getting ... the thing which was intended
|
|
|
|
|
Nilish wrote: But specifically with pointers
A reference and a pointer are pretty much the same thing. There are some differences, but not so many that I've ever had to concern myself with them in any practical way.
|
|
|
|
|
Hi there
i have
two forms named form1 and form2
two class files named class1.vb , class2.vb
now in class1 the code is as follows
class class1
protected overrides sub Finalize()
mybase.Finalize
End Sub
end class
class2 code is as follows
class class2
protected overrides sub Finalize()
mybase.Finalize
End Sub
end class
In form1 i am writing the following code
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dim d1 as new form2
d1.show
End Sub
End Class
In form2 i am writing the following code
Public Class Form2
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dim d1 as new class1
End Sub
End Class
The startup page is form1
At form1 loads i am getting form2 automatically.
now i am closing the form2 .
Though the object of class1 is declared in form2
ad on closing the form2 , i am not getting the automatic call of the class1 destructor.Rather getting the automatic call of the finalize function of class1 at the form1 (startup page) closing.
Now my question is
1. y the automatic call of the class1 destructor is not getting called on form2 closing because class1 is assigned the memory in form2.
2. Can i call the finalize function of class1 using it's object
like dim d as new class1
d.finalize
i was getting error but.
3.in the finalize function , i am writing
Mybase.finalize
what's the mean of this line.
I know it is a desctructor
Finalize funtion get called automatically when the startup form gets closed.
|
|
|
|
|
Nilish wrote: 1. y the automatic call of the class1 destructor is not getting called on form2 closing because class1 is assigned the memory in form2.
Because object destruction is non-deterministic. This means that you cannot predict when an object that is no longer in use is going to be destroyed and collected. The Finalize code won't get called until the GC gets around to collecting the object. This could take a while. The GC is a bit lazy, but it's very good at it's job when it gets around to doing it.
Nilish wrote: 2. Can i call the finalize function of class1 using it's object
Why? It's very rare that you ever need to put code into the Finalize method. Instead, put your clean up code into the Dispose method instead and call Dispose when your code needs to destroy an instance of the object and free up resources and a known time.
|
|
|
|
|
Hi,
I created one project in .net 2003 and using C1 report,I get the following error:
Could not transform licenses file 'licenses.licx' into a binary resource. (1) : error LC0003 : Unabled to resolve type ''C1.Win.C1Report.C1Report, C1.Win.C1Report, Version=1.1.20023.28, Culture=neutral, PublicKeyToken=c9c7ad9c0a5706c9'
How it can be resolved.
Any help will be highly appreaciated.
Thanks,
SD.
|
|
|
|
|
C1? Is this ComponentOne? If so then you have to speak to them about sorting your licenses out.
|
|
|
|
|
You URGENTLY need to stop using URGENT in your message titles...3 of 4 have URGENT. Please read the forum guidelines.
__________________
Bob is my homeboy.
|
|
|
|
|
I display the xml file data in datagrid control and i also add the extra column in the datagrid control now i want to add the command button in the newly added column cell.please help me.It is urgent for me
|
|
|
|
|
Dim ds As DataSet = New DataSet
ds.ReadXml("FileName Here")
Dim btn As New DataGridViewButtonColumn
btn.Text = "Add New"
DataGridView1.column.add(btn)
BEST LUCK
|
|
|
|
|
dear sir This is my code.I can add the check box by using this code Now i need the Command button.Your code doesnot work.Please hope for kind coperation.
'btn1_click()
'Dim filePath As String
'filePath = "D:\authors.xml"
'dsAuthors.ReadXml(filePath)
'With dg
' .DataSource = dsAuthors
' .DataMember = "Authors"
' .CaptionText = .DataMember
' Dim dtcCheck As New DataColumn("New Column")
' dtcCheck.DataType = System.Type.GetType("System.Boolean")
' dtcCheck.DefaultValue = False
' dsAuthors.Tables(0).Columns.Add(dtcCheck)
'End With
end sub
|
|
|
|
|
I ran the code below that adds a column to an SQL table.
I refreshed Data Sources, but, the new column does not appear.
I refreshed Server Explorer and the new column does not appear.
I tried running the code again and I got:
"Column names in each table must be unique. Column name 'CaseNbr' in table 'Patient' is specified more than once."
so the column did actually get added, but, I can't see it.
Imports System.Data.SqlClient
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim sqlConnection As New System.Data.SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Patient.mdf;Integrated Security=True;User Instance=True")
Dim str As String = "ALTER TABLE Patient ADD CaseNbr Varchar(50)"
Dim command As New System.Data.SqlClient.SqlCommand(str, sqlConnection)
sqlConnection.Open()
command.ExecuteNonQuery()
sqlConnection.Close()
Close()
End Sub
End Class
|
|
|
|
|
I Think Ur Code is Correct if u have any confusion then please review this Code thanks
Dim cn As New SqlClient.SqlConnection
cn.ConnectionString = "Data Source=ssi-SIQBAL;Initial Catalog=Dummy;integrated Security=SSPI"
cn.Open()
Dim cmd As New SqlClient.SqlCommand
Dim str As String
str = "ALTER TABLE TBL1 ADD HOME varchar(500)"
cmd.Connection = cn
cmd.CommandText = str
cmd.ExecuteNonQuery()
|
|
|
|
|
Is the MDF file listed in your project in Solution Explorer? The problem usually occurs because the .NDF file is being copied to your Release or Debug folders along with your app's .EXE. The Server Explorer is looking at one version of the database (in your project folder) and your code is looking at the other copy of your database in the bin\Release or bin\Debug folder.
Wanna see? Just open your project folder and search all the subfolders for any files with the extension MDF.
|
|
|
|
|
That was the problem.
Another question:
Why is it that in some projects, the .mdf file is in bin\Release
and in other projects, the .mdf file is in the bin\Debug folder?
|
|
|
|
|
It'll be in either depending on which build configuration you use when you hit, well, Build.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
