know in 2008 if you have procedures or functions. that there's a little "-" or "+" that lets you expand and collapse that procedure or function? I was wondering if anyone knew how to create a section so I could collapse it within the procedure? The only way I know it will do it between functions or procedures and things like that but not within the procedure.
[Code]...
I know you can select and ctl m + m but is there an easier way or something in options to keep it from expanding?
This happens once in a while and it takes forever to select (highlight) all my code.
i am trying to collapse all the procedure (pressing the minus icon). is there away to perform collapse all?
View 3 RepliesI'm trying to modify this program so that a function procedure determines the student's grade. The problem is, I don't even know where to start. here's my current code:
[Code]...
When I select a node in my treeview I have no problem seeing them in my web browser.
My problem is that when I try to collapse my tree then my last viewed document in the web browser remains visibe.
How can I ensure that when I collapse my tree my web browser will also become totallt empty?
Im a student doing an assignment, how do i pass the value from a sub procedure to a function procedure....i want to pass the value from decSubtotal to a function procedure named CalculateDiscount; check out my code--
[Code]...
I've bee working on a project for quite some time now, and I get tired of scrolling all the way to where I am going to implement new code. I use #Region a lot, but this does not help me within methods, so what I'm wondering is, is there any way to collapse text within methods, or do I have to keep scrolling?
View 8 Replieshow to collapse a part of code in vb.net?
View 4 RepliesI am using VS2008 front end and MySql 5 database When I attempt to run this sproc I get the following error message:"Procedure or function 'Test_sp' cannot be found in database 'EVOLUTION'." Yet the Stored procedure is definitely there.I have tried changing the name of both the sproc and in the sub below but it makes no difference.This is the first time that I am trying to use a sproc and I can't get it right.All other communication to and from the database is fine.
Dim Cmd As New MySqlCommand("Test_sp", Datacon)
Cmd.CommandType = CommandType.StoredProcedure
Cmd.Parameters.Add("@Acl_Key", MySqlDbType.String).Value = "ABC"
Cmd.Parameters.Add("@Acl_Desc", MySqlDbType.String).Value = "My Description"
[code]....
i able to get data then i click second time i got error Procedure or function "procedure name" display has too many arguments specified" why this error. [code]
View 2 RepliesI finished coding an application for converting Celsius to Fahrenheit, and vice versa. I used the Sub Procedure to convert them. What I need now is to modify it. I would have to use the Function Procedure instead of my Sub Procedure.
[Code]...
I know there are the 'Wizards' to help me, but I need the code to access the Table Manager, the data set and so on, create them in my project and access the tables or stored procedures
View 2 RepliesI am trying to create a procedure which will evaluate a string expression as if it were a line of code...Kind of like what a graphing calculator does when you enter a formula. Does anyone have any experience with this in VB? I have an example of C++ code which uses CodeDom, but I am a bit rusty with my C++!
View 4 RepliesI am using VB.NET 2008. I am using propertygrid and have added a few elements. I have 3-4 categories and wanted to know how can I expand/collapse a particular category thru code. I did find a code on net but it didn't work.
View 10 RepliesHow can i create a GridView that will expand and collapse nested(child) rows based on serial number. +1100,+1200,+1300,+1400 when i click on +1100 sign all the rows 1101,1102,1103.....,1199 should be expanded,when i click sign "-"(minus) the group should collapse.
View 1 RepliesI have to get a value in $.I have 2 radio buttons:
-Residential Customers
-Business Customers
I have 2 List boxes:
-Premium Channels
-Connections
I also have a total Text Box and a calculate button..My goal is to get a cost given the information from the user. the list boxes will have preassigned numbers in them..The residential Customers have to pay a $4.50 Processing fee, a Basic service fee of $30 and 5$ for ever Premium Chanel they buy. The Business Customers have to pay a processing fee of $16.50, a basic service fee of $80 for the first 10 connections (4$ for any connection after that) and 50$ per Premium Chanel (no limit)
how to make the function procedure..e <input id="gwProxy" type="hidden"><!-- Session data--></input> <input id="jsProxy" onclick="jsCall();" type="hidden" />
View 3 RepliesHow can I transform this code to a function (anyone can do it for me?)? Otherwise I have to use this long code again and again..
[Code]...
I am trying to get the value of the CategoryID so that I can insert that value into the database when an admin wants to update product features. The stored procedure that was written is for a ListView, so I was hoping I could put something hidden in there to get the ID. When I put the Hidden Field on the page and tried to get the ID, I got the error I mentioned in the title.
<ul id="categories">
<asp:ListView ID="lvAncestorCategories" runat="server" DataSourceID="dsCategoryAncestors">
<ItemTemplate>
[code]....
I am recieving this error and i cant think why. I have checked the number of parameters being passed as well as the number of required paramaters from the sp ,regenerating the data set has given me no look.
Public Sub GetRows(ByVal [Option] As String, ByVal searchString As String)
Me.DataSet11.Clear()
SqlSelectCommand1.CommandType = CommandType.StoredProcedure
[code]....
I've attempted to use a function in my code to calculate shipping and handling. When I enter my test data quantity 2, weight 3 and price 19.95. The result displayed is that my shipping and handling is 0 but should be 1.75. This is what my shipping and handling function looks like. The name of the function is shipping_handling it accepts a parameter by value and it stores the parameter in a variable called OrdersWeight_Decimal.
[Code]...
How can I handle the above warning? Should I just return nothing when an error occurs?
te Function RetrieveAllCustomers() As DataTable
Dim adapter As New OleDbDataAdapter
Try
[code].....
Are the terms 'Function' and 'Procedure' synonomous?
View 2 RepliesI have to turn the GetFwt function on the code into a sub procedure. Below is the original
' Project name: Harvey Industries Project
' Project purpose: The project calculates an employee's weekly net pay.
' Created/revised: <your name> on <current date>
[Code]....
I am trying to call a stored procedure and get the idn_num as output on entering an input of a name. I get a "Procedure or function 'aaa' has to many arguements specified" error when I try to run my VB.net code
Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:ParameterProject esttable.mdb;Persist Security Info=False" & ";Jet OLEDB:Database Password = "
conn.ConnectionString = "Data Source=localhostsqlexpress;Initial Catalog=PPRT;Integrated Security=True;Pooling=False"
[Code] .....
I just recently had to rebuild my development environment from scratch. I've noticed that when I'm in debugging mode and I have a breakpoint set on a Procedure or Function, instead of stepping into that P or F, it just executes it without actually stepping thru the code. What do I need to change in my "Tools" and "Options" area?
View 6 RepliesI know the major difference is that Sub Cannot return a Value while a Function Can.
View 3 Repliesim getting this error when i run my app, i have looked at my stored procedure and VB code and cannot see anything wrong with been stuck on this for the last couple of days
View 5 RepliesThis code updates the fiscal year automatically.[code]...
View 1 Repliesthis code, it gives always error on execution of command is comes.
Try
DBconnect()
cmd.CommandText = "Designation_INSERT"
[code]......