Here is document that explains "Accessibility" in msdn. I hope this will help...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcn7/html/vbconaccessibility.asp
enjoy
JK
No...once you have xml file, you open the file in excel. It will ask you few question first time you will open. After you do that save the excel file and you are all set.
Jignasu
Well, Good news...There is certainly a way...Here is what I tried and it works...You can indeed create new session variables from Business Layer...
Here is one of the function in my Business class...
Public Function Test(ByRef context As HttpContext)
context.Session("Test") = "Test"
End...
I am not sure if that could be done or not. But there are other ways you can have those information available to the web appliction. Since you are creating Business Rules Layer, you will have to that Bueiness Rule be used in Web Application. For example, when you access Authticate method of...
You certainly can also open using code. I am not sure what exacetly you are trying to do. But if you could explain what is that you need, I might be able to offer other solution/scenario.
You don't have to write to excel, you can open xml file using excel! In a sense, you are creating presentation layer using excel. So in future all you have to do is replace underlaying xml file and excel will update automatically.
Yes, It is straight dump to excel and it will be nicely formatted. Below is an example of what I dumped to xml file...You also have option to create schema file.
ns1:CourseID ns1:CourseName ns1:CourseDesc
28 Test 1 Test 1
32 tEST 2 tEST 2
34 Test X Test X
25 Test 4 Test 4
27 Test Test
29 Test...
What you can do is, instead of having to export as excel file, export as xml file and then you can open it in excel. I also know there is a way to export as excel, but need never done that. I hope this will help. Below is the code I used (three lines).
SqlDataAdapter1.Fill(DataSet1)
Dim...
I would suggest, instead of having to refer session variable directly, pass them as parameters of the function.
Something like below...
Private Function NoUserObjectRedirect(CurUserObj as boolean)
if CurUserObj = True then
....
End
End Function
When you call a function it...
Yes, Same rules applies as database update. For instance, if you have a view that pulls data from multiple tables you can not use that to update data! But you can execute more than one update commands to achieve that.
Andrew,
It is really simple. Below is the sample code for UpdateCommand event of datagrid. Hope this will help...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwebuiwebcontrolsdatalistclassupdatecommandtopic.asp
Jignasu
Have you looked at MSDN? Below is the link that might answer your question. Hope this helps...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vakeyDirectCast.asp
Jignasu
Here is sample code for Word automation and on that page there are links to more resources.
http://support.microsoft.com/default.aspx?scid=kb;en-us;293861
Happy Coding...
Jignasu
You can code within KeyDown event of text box. Get the SelectionStart value of textbox.
Private Sub TextBox1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyDown
Label1.Text = TextBox1.SelectionStart
End Sub
Enjoy.
Jignasu
There is a sample code on the Microsoft Visual Basic Developer Center. Below is the link.
http://msdn.microsoft.com/vbasic/downloads/samples/default.aspx
Look for "Find And Replace Dialog Box" link.
Enjoy.
Jignasu
Jeff,
The way I usually do is look at few column I know for sure should have some data. If there are no data in for three continous rows, that is end of the file. I don't know any build in functions that does that.
Here is something that might work for you...
Do Until blnExit = False
'You...
Here you go...
Great samples on Microsoft site by Duncan Mackenzie. Hope this helps...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwxp/html/WinXP_BITS.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncodefun/html/code4fun02282003.asp
Jignasu...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.