Asp.net - Improve The Design Of A Page With Multiple Case Statements?

Aug 17, 2011

My page contains: GridView1, GridView2, Button1, Button2, DropDownList1 I bind Gridviews to the table selected in dropdown like this:

Dim results as DataTable
Select Case ddl1.SelectedValue
Case 0

[Code]....

For me it looks like a lot of overhead. How can I improve then design and only specify that I'm working on the following record in dropdown list without specifying the Case condition every time? Should I change my design or leave it like it is?

Update:
RunZero, RunOne, RunTwo, RemoveZero, RemoveOne, RemoveTwo, RemoveThree - Execute six different stored procedures.

View 2 Replies


ADVERTISEMENT

Case Versus If Then Statements.

Apr 26, 2011

i have a program, three radios, and 2 check boxes. the Radios use a constant value and do a multiplication. check one applies a discount. no problem.

the last takes the values of all three radios does a comaparison and displays a label if false, performs a subtraction if true and shows savings.problem>

very convoluted using if statements. and the output is often wrong(i know this is a logic error) i can not find the fault.

would it be easier to use case statments. can and will post code if requested. as it is in if then format currently it is rather long.
Sometimes the answer is so blindingly obvious i fail to see it.

View 4 Replies

Unable To Use The Select Case Statements

Feb 20, 2009

Dim subtotal As Decimal = CDec(txtSubtotal.Text)
Dim discountPercent As Decimal
Select Case txtCustomerType.Text.ToUpper() = "R"
Case CBool(250) To CBool(500)
discountPercent = 0.25D

[code]....

View 6 Replies

Use Select And Case Statements Along With Startswith?

Jul 10, 2009

i have a situation in which i have to check if the string starts with something and then perform something....First i used "If" as below

If utn.text.startswith("Fuel") then
messagebox.show("Fuel Purchase is selected")
End If

[code]....

Now i have to use Select and Case statements along with startswith...?

View 4 Replies

Select Case Statements With Radio Boxes?

Sep 19, 2010

I am working on a calculator and I'm trying to use select case statements for the symbols selected (radio buttons) as opposed to If then Else statements. I am running into trouble because I'm only used to using them with list boxes.[code]...

View 4 Replies

Use The IF ELSE Statements OR The Select Case Statement To Write?

Oct 7, 2011

Im trying to figure how to use the IF, ELSE statements OR the Select Case statement to write this program.I'm using Visual Studio 2010. The program is suppose to allow the user to input their weight in a text box and from group box 1 the select whether theyre male or female using the radios and they select inactive or active from group box two and the calculate but will determine how many calories they should intake based on the criteria below.

[Code]...

View 14 Replies

Converts Characters In String Using A Case Select Statements

Oct 19, 2009

I am trying to write a code that converts characters in string using a case select statements. For instance if I type the word "aeiou" the the word "<>[]/", also if I type "AEIOU" then <>[]/" should print but its not working here is a sample of my code so far.

[Code]...

View 11 Replies

VS 2008 Radio Buttons And Select Case Statements

May 26, 2010

how to associate a select case statement with, which point to four Function procedures, to four radio buttons that are used to +, -, *, and / two simple fractions in a fractions calculator. This is a class assignment for which I have already been graded. I used an If...ElseIf statment and it worked perfectly. Now I am trying to utilize the Case Statments with Function Procedures to do the same thing. I do not get graded for this, but I was told to research it an find an answer. My current code is listed below.

[Code]...

View 8 Replies

VS 2008 Add Button Control In DataGridView Based On The Case Statements

Oct 21, 2010

I am working on Datagridview. My task is adding buttons in the Datagridview table based on the case statements. Like In the Present table i have one column called "CategoryDescription". In this column, values are like 3101,3102, 3103........Here 31 is the common. and like 3201,3202,3203......Here 32 is the common. Like there are so many common values are there. So where ever the common values will come there i have to add one button in the Same column.

So Finally my conclsion is at Satrting 3101 and starting 3201,3301,3401.. i have to add one button control 3101 and add button control on 3201 and add button control on 3301.

View 3 Replies

Sample Code For Select Case Statements Under A Button Click Event?

May 5, 2010

can anyone give a sample code for select case statements under a button click event?

View 2 Replies

Design A Form And Add Buttons - Download Bank Statements ?

Feb 24, 2010

I have an awful lot of it "down" by now, in that I understand how to design a form and add buttons, how to set properties and am even learning "procedures and parameters". But I think I'm missing something, and it's probably my own fault as I jump around the book (I'm about 1/2 way through the 500 page volume, and have completed chapters from the beginning and middle) I think I understand the "Visual" part, and I think I even understand enough of the "Basic" part to get going.

I want to write a simple program to take our downloaded bank statements (what better time to do this than tax time and sort them out. They are .pdfs so I need to first copy the text and sort of "break it apart" and add tabs etc so I can import to a database (I've been playing around a lot with databases too, and have a good grasp on that part of the equation) I have been reading (in the book) about reading text files with StreamReader, and Replacing Text Within a String, etc. how to "get going..." how to even start writing a program. Do I start with a form? Do I need to create a Visual interface to run the Basic?

Are there existing examples somewhere I could "get my feet wet" working with that already have simple find/replace functions? It's almost as if I know too much about the more complex stuff like "Denoting Scope Using Variable Prefixes", but not how to write a simple program. I'm adding to this -- as I think about it, the main "Project" used throughout the book is a Picture Viewer. I think it if had been a "data replacer" or something like that, I wouldn't be asking this question! I don't want to open a picture, I want to manipulate a text file.

View 4 Replies

How To Improve Code To Print On Multiple Pages

Mar 16, 2010

I want to print contents of a ListView, currently I can print on one page only so my question is how do I improve my code to print on multiple pages. I've read little about the HasMorePages property but no idea how to use it in this context. Heres my code:I have a PrintPreviewDialog and Print Document to assist in printing [code] I understand most part of this code but not all so its kinda hard to follow the program flow to make any big changes myself so if possible can someone please comment the code a bit? how printing works in .NET because I only understand parts of it so having trouble joining the pieces together if that makes sense?

View 3 Replies

.net - One Dataset With Multiple Results Sets (multiple Select Statements) SQL Reporting Service?

Oct 15, 2011

I have a question regarding the dataset usage in Reporting Services. I have a stored procedure which returns multiple select statements (result tables), and I created a Dataset in Reporting Services 2005 with this stored procedure. The problem is that I can not reference the second or third result table, and I can only use the first select statement fields. Is this the limitation on Reporting Services Dataset or is there a way to use multiple table results in one dataset?

View 1 Replies

Create Multiple Threads To Improve A Function On Program

Sep 7, 2011

i need to create multiple threads to improve a function on my program. it is a simple thing really but it's slow and if multithreaded it can improve the speed some thousand times. my program uses a dll to check the MX record of an e-mail from a textbox called emails if the mx record is correct then it validates that domain, if not, it sends to an error textbox with that mail my problem is that im reading a lot on multithreading and i dont have an idea how to make something like this: for x=0 to emails.lines.count -1' start a thread that runs my function next if i can limit the number of threads to avoid crashing it would be good.

View 5 Replies

Sql - Multiple If Statements, Then, Or Else?

May 3, 2011

I'm having some problems getting a query to run based off another query. Here's the database diagram to give a little background. The primary keys for all the tables are automatically generated by identites. The first 2 insert statements (Donation and Food_Donation) work but I can't get the last insert into Donation_Details to work. Here's the code so far:

View 2 Replies

Avoiding Multiple IF Statements?

Sep 14, 2010

I have the following code block. I'm tired of typing the same IF statement to check if the string has any lenght before assignning them to the class properties of Employee.

Is there any better to accomplish this?
Dim title = txtTitle.Text.Trim
Dim firstName = txtFirstName.Text.Trim

[code].....

View 6 Replies

Multiple Do Until Statements In VB 2008?

Mar 2, 2010

I need to write a do until statement. 2 of them actually. 1st one records all of the income and then one that records all of the expense. Then they need to be add to figure a profit or a loss.

View 12 Replies

Use Multiple Statements In A For Loop?

May 8, 2011

I have a piece of code that loops through the rows in a database and brings out information.

The code is attached to a button(search). To search for data, you enter a phone number, the loop goes through the data rows and bring out the information is it is there.

Everything works great accept I have added a second table to the database.

So do I add a whole new loop statement? Example lets say I had a new data row, how can I add that to this statement so that both tables are searched?

This is the code:

Dim strGetRecord As String = masTxtPhoneField.Text
For validData = 0 To storedtData.Rows.Count - 1
If strGetRecord = storedData.Rows(validData)("fldphone").ToString Then

[Code].....

View 4 Replies

DB/Reporting :: Using Parameters With Multiple SQL Statements?

Jun 25, 2009

I have a connection to a MS SQL database, which I understand is capable of handling multiple SQL statements in one Execution, ie

Code:
Using cmdExe As New System.Data.SqlClient.SqlCommand
sSQL = "Delete * from mytable where UniqueID=123;Insert into mytable (UniqueID, Field) values (123, 'something')"
cmdExe.CommandText = strSingleSQLLine
cmdExe.ExecuteNonQuery()
End Using

will delete from "mytable" and insert a new record all at once. This is great, but I want to expand upon that to use parameters because using string concatenation in my SQL queries is a bad idea. Now my question is this. If I add a parameter which is used in multiple SQL statements, do I have to add the parameter VALUE twice to the command object? ie, will the following code work?

Code:
Using cmdExe As New System.Data.SqlClient.SqlCommand
sSQL = "Delete * from mytable where UniqueID=@uniqueID;Insert into mytable (UniqueID, Field) values (@uniqueID, 'something')"
cmdExe.Parameters.AddWithValue("@uniqueID", 123)

[code]....

There are two questions here actually...can I add the parameters before setting the command text, and do I have to add the same parameter over and over again?

View 1 Replies

Running Multiple SQL Statements In One Operation

Apr 21, 2009

I'm trying to use ADO to create several tables at once, into MS Access. Is it possible to do multiple statements in the one operation?[code]This fails due to a "Syntax Error in CREATE TABLE statement", although each of the create statements work on their own perfectly. Is there a way of doing this sort of thing? There will also be statements to add constraints, add indexing, etc., and I'd really like to be able to do it so that I don't have to split up the string into separate parts.

View 8 Replies

Usage Of Colon (i.e. : ) For Multiple Statements?

Jul 27, 2010

Usage of colon (i.e. : ) for multiple statements?

View 1 Replies

VS 2008 Have Multiple IF Statements In A Single Button

Mar 10, 2011

I am just starting to learn the visual basic language so i am trying to make a simple application where a user can put in it's first and last name or else the application exists.

I manage to do this fine untill i get to the point of ending one if statement and starting another in the same button..

(in the form i have button1, button2, label1, label2. Button2 is only a "quit" button)

Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

[Code]....

What happens when i run this is that i can put in the first name but then when i click yes the application closes.

View 14 Replies

VS 2008 Multiple OleDbDataAdapter Update Statements

Apr 13, 2012

I need to update more than one DataAdapters, so I used the

Dim sqlcmdbldUser As New OleDbCommandBuilder(dtaadpUser)
Dim sqlcmdbldPoints As New OleDbCommandBuilder(dtaadpPoints)

But only one of them works, the second one brings up errors if I try to update the DataAdapter. Is there a way of using and updating multiple data adapters?

View 10 Replies

VS 2008 Using Parametrized Queries With Multiple SQL Statements

Jun 25, 2009

There is not a VB.net database forum, and there is a HUGE difference (unfortunately) between ADO and ADO.net. I have a connection to a MS SQL database, which I understand is capable of handling multiple SQL statements in one Execution, ie

Using cmdExe As New System.Data.SqlClient.SqlCommand
sSQL = "Delete * from mytable where UniqueID=123;Insert into mytable (UniqueID, Field) values (123, 'something')"
.CommandText = strSingleSQLLine

[Code]....

There are two questions here actually...can I add the parameters before setting the command text, and do I have to add the same parameter over and over again?

View 3 Replies

Using "AND" In Case Statements?

Mar 29, 2009

Is the following case statement valid?

Case IS <=40 AND IS>=20

This was an example given by my instructor on case statement syntax but I'm getting a build error when trying to compile this.

View 1 Replies

Get An Error Because The Sqlcommandbuilder Does Not Generate Statements In Multiple Tables?

Jan 26, 2012

I have 2 tables in MySQL database. These table were joined through a query and handled by a dataset. Im displaying these data through setting the dataset as the datasource of my datagridview. But when it comes to Update, Insert and Delete statements, I got an error because the sqlcommandbuilder does not generate statements in multiple tables.I want is, when I press the update button..all the changes made in the datagridview will be updated in the database. Can i make it without creating a datasource in design mode or through smart tag? If I have to manually create an UpdateCommand for adapters..Can I have a code snippet for that?

View 1 Replies

Design A Page For Printing?

Apr 24, 2010

Design a page for printing?

View 1 Replies

How To Design And Develop A Web Page In Asp.net

Nov 22, 2009

Am new to web design and development, I want to know how to design and develop a web page using vb.net and asp.net.

I need a link of samples and help sites for developing a web page.

View 2 Replies

How To Make A Statement Run If All Conditions Are True From Multiple Condition Or If Statements

Mar 22, 2011

I have a form that contains multiple conditional or if statements on several defferent for controls.

Example: Radio Buttons, TextBoxes and CheckBoxes.

I am intending to create an order form(demo) where the user can select multiple products.

I have a default order number that changes by one everytime an order is successful.

An order is only successful if all the information on the form is entered correctly.

My question is where do I insert the code for the order number?

Basically for the order number I have a counter that count by increment of one if an order is successful.

Meaning when the user hit place order, and all the infromation is right, then the order numer goes to 1 from zero.

Where do I add the condition for the order number since all the fields must first be completed.

Do I have to create a whole line of if else statements?

View 5 Replies

LINQ Query With Multiple OrderBy Statements Added In Loop

May 11, 2012

I have a method in a webservice that has parameter with which users can decide how they want to order their results. This is a List(Of String) with the names of the fields in the order they want to sort them. I know I can normally order on multiple columns by doing the following

Dim test = Bars.OrderBy(Function(x) x.Foo) _
.ThenBy(Function(x) x.Bar) _
.ThenBy(Function(x) x.Test)

However in this case this won't work since I can't chain the ThenBy function because I'm adding the sorting orders in a loop. To use ThenBy I need an IOrderedQueryable collection. This is how I would want it to work

Dim sortColumns = {"Foo", "Bar", "Test"}
Dim query = From b in Bars
For each column in sortColumns
Select Case column
Case "Foo"
query = query.Orderby(Function(x) x.Foo)
[Code] .....

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved