|
In Excel it is
Application.GetSaveAsFilename and
Application.GetOpenFilename
|
|
|
|
|
Hi. I have two tables. Table1(typeid, desc) table2(markid,desc, tyoeid). I want to delete a record from table1 using one query. I am having referential problem. Guide me a little. Thanks
|
|
|
|
|
Delete child records first(table2) and then delete the parent record.
|
|
|
|
|
I believe you can have a clause on your forgein key which specifies "cascade delete".
Something like this ...
CREATE TABLE test_child <br />
(SUB1 INT, <br />
[NO] int,<br />
FOREIGN KEY ([NO]) REFERENCES Test_parent<br />
ON DELETE CASCADE)
|
|
|
|
|
Created a automated dollar incrementar in vba ms powerpoint. Every second it increments by $20. However i want to see the amount increment from 0 to 20 to 40 etc. it is doing the increments but just shows the end result. tried adding sleep it does show the individual increments. how to resolve?
|
|
|
|
|
|
I have a vb.net application (VS 2008). I want to make the application available for the endusers at offshore.
What is the best way to do the above & how to accomplish it?
Thanks in advance.
|
|
|
|
|
You'll have to rewrite the app to be a web application. If your original app was written with a seperate UI tier, that won't be too difficult. But, if it was written as a monolithic app, you'll have to rewrite the entire thing yourself. There is no conversion tool that will do this for you.
|
|
|
|
|
Thanks for the reply.
In the Project Properties, in the Publish tab, their is an option showing Publish Location:
Publishing Folder Location(website,ftp server or filepath).
is it possible to give the location as a website address and create a icon/button in the website to launch the application.
I have no idea on how it works, its just a query...
Thanks.
|
|
|
|
|
This will create a web-based installation for your app, NOT run your app as web-based. It will install the application on the computer that the user is on and run it from there.
|
|
|
|
|
Thanks a lot for this information Dave.
|
|
|
|
|
Hi Friends,
I am reading cells from excel vba and storing in oracle database.
I have a problem here: there are some special characters as well as spanish characters in some of the cells in excel. This is not reading properly and storing properly (means storing the same as it is given in excel cell) in the database.
For Eg: string like : mph-434ĆEĘ needs to be read and stored using Vba.
Kindly help how to read spanish characters from excel using vba and store in db.
Thanks in Advance,
Regards,
<pre>
|
|
|
|
|
Don't place the question in Code Blocks.........Code Blocks are for, you guessed it, code!
Dave
Find Me On: Web| Facebook| Twitter| LinkedIn
CPRepWatcher now available as Packaged Chrome Extension, visit my articles for link.
|
|
|
|
|
Hi.
Can someone explain what does this code mean??When i search for something in that code i see such thing with diffrent methods.
It's really nice of you to explain what does it do?Why we use it?And where we must use this?
Thank you.
<pre>
<b>[DllImport("advapi32.dll", SetLastError = true, PreserveSig = true)]</b>
</pre>
CanI
|
|
|
|
|
This is the start of a declaration that imports a function from the advapi32.dll. The line is incomplete, so there's no way to tell what the function was.
You use this if you want to call functions that are exported by library .DLL's, and not exposed through a COM interface. For example, you can import FindWindow and GetWindow from user32.dll to get a handle to another applications windows to do almost whatever you want with them.
|
|
|
|
|
Thank you,
I don't mean to explain just this line Code
<pre>
[DllImport("advapi32.dll", SetLastError = true, PreserveSig = true)]
</pre>
I mean totally what is Mean?And how to use and when to use???
Explain me like a teacher...
Thank you.
CanI
|
|
|
|
|
I already did.
I'm not writing up an entire lesson plan for you in a forum post.
I gave you a starting point. This is where you start doing research and teaching yourself. Without that skill, you're not going to last long writing code.
|
|
|
|
|
Thank you,
I don't mean to explain just this line Code
<pre>
[DllImport("advapi32.dll", SetLastError = true, PreserveSig = true)]
</pre>
I mean totally what is this?And how to use and when to use it???
Explain me like a teacher...
Thank you.
|
|
|
|
|
|
|
|
Imports System.IO
Dim strFileSize As String = ""
Dim di As New IO.DirectoryInfo("C:\temp")
Dim aryFi As IO.FileInfo() = di.GetFiles("*.txt")
Dim fi As IO.FileInfo
For Each fi In aryFi
strFileSize = (Math.Round(fi.Length / 1024)).ToString()
Console.WriteLine("File Name: {0}", fi.Name)
Console.WriteLine("File Full Name: {0}", fi.FullName)
Console.WriteLine("File Size (KB): {0}", strFileSize )
Console.WriteLine("File Extension: {0}", fi.Extension)
Console.WriteLine("Last Accessed: {0}", fi.LastAccessTime)
Console.WriteLine("Read Only: {0}", (fi.Attributes.ReadOnly = True).ToString)
Next
|
|
|
|
|
Hi,
I like to set the DataGridView-Rows height by the following ways...Is it possible?
DataGridView1.rows(0).height=30
DataGridView1.rows(1).height=50
DataGridView1.rows(2).height=20
But the above is not working while
DataGridViewRowHeaders.Visible =False
Thanks
|
|
|
|
|
Is the datagrid visible at the time you are setting this? I've had issues with trying to setup grids when they are not visible and it not working.
|
|
|
|
|
I didn't have any problems with this.
Starting with a DGV with a single row, containing a few columns, i ran this code;
Dim dgv As DataGridView = Me.DataGridView1
dgv.RowHeadersVisible = False
For i As Integer = 0 To 10
dgv.Rows.Add()
Next
For Each row As DataGridViewRow In dgv.Rows
row.Height = (row.Index * 10) + 10
row.Cells(0).Value = row.Height
Next
Dave
Find Me On: Web| Facebook| Twitter| LinkedIn
CPRepWatcher now available as Packaged Chrome Extension, visit my articles for link.
|
|
|
|