What is wrong with this code?When the code runs cmd.ExecuteReader I get an error saying "Incorrect syntax near the keyword 'AS'".I'm assuming I didn't breakup the sentence correctly.
Using cnn As New SqlClient.SqlConnection(clsDBConn.clsDBConnections.prpConnString)
cnn.Open()
Using cmd As New SqlClient.SqlCommand[code].....
Is there a easer way of coding in stead of wrighting long long paragraphs like this in one line [code]All of this is on one line and i got lots of info to put down.."The game will begin on your 16th birthday with your mother waking you up. Today you are to go to the castle for the first time. Leave your bed and open your dresser for a Strength Seed. "
View 2 RepliesBuilting a calculator. I have a string of two numbers separated by an math sign. Knowing the length of the first number then adding one for the sign will produce the start length of the second number. Trim the original string to get what I need.
dim num(25) as double
dim length,length1 as integer
dim string, string1 as string
length = Len(num(n - 1))
length1 = length + 1
[Code]...
LIKE in SQL query in CommandText Here's my
[Code]...
Basically, I have an Access database with Primary keys that are structured with this format ("02"000).When I try to paste the number, it ignores the "02" and goes straight to 000.For example, here is the code;
PeriodRoomID.Name = ("R" & ds.Tables("sqlSpecRoomRequest").Rows(i).Item(1))
What PeriodRoomID.Name should be is R02001.What PeriodRoomID.Name comes up as is R1.It ignores the "02" and ignores the 0s. This makes sense mathematically but it is not what I want. I need a way to get the exact output and not some simplified version.
The query;
SELECT SpecialSoftware.SpecSoftID, SpecialSoftware.RoomID, SpecialSoftwareNames.Description, Rooms.Capacity
FROM SpecialSoftware, SpecialSoftwareNames, Rooms
I have created an SQL query using Query Designer in VB.NET 2005. The commandtext for the query is somthing like SELECT * FROM tablename WHERE Field1=@Parameter1. I want to change this at run time to something like SELECT * FROM tablename WHERE Field1=@Parameter1 AND Field2=@Parameter2
View 4 RepliesI must input a letter and a number in a text box.. say "A14", and them I want to cut the string into "A" and "14" and then use these, but I do not know how to code this as the next string could be "A1" or "C110" and these change... could I make an if for each one? like an if for when its 2 characters and just cut it in half and then an if when its 3 characters and cut between the 1st and second and so on?
View 4 RepliesI need a function that takes a decimal, with a certain number of digits behiond the comma and convert it to a string with a different number of n digits behind the comma. (to display it)My problem is the rounding ip/down.
like 123,789 with n = 2 --> 123,79
or 123,4 with n = 0 --> 123
or 123,5 with n = 0 --> 124
I did not find an existing function that does that, so I wrote one myself.However the code has become soo complex and it still does not work well, and I get frustrated to spend soo much time with something so trivial.Does anyone know a function that can do this? There must be something out there.
I'm trying to edit the CommandText for the Insert Command in a TableAdapter in the Designer in vb.net. Whenever I make changes to the CommandText, Visual Studio (2008) automagically changes the Parameters to a Collection consisting of one Parameter thatexisted before editing the Command, immersed in a sea of complete garbage Parameters, and then I either have to undo (unless this was the first thing I tried editing, in which case I have to close the Designer to discard changes and reopen it) or manuallychange ALL the Parameters back to something that isn't complete garbage.
View 2 Replies[Code] The above code does not work. I need for this to check to see if there is a database entry with the office name and today's date. Then if not it needs to tell the user that it is going to create a new entry for todays date. Then the code is trying to enter a new row in the database but it is like i can't use command. commandtext = in two spots. Both SQL commands work if separated but not together in this code. Obviously the abcdefghij are just test entries but it works if it is separated from the other sql command above. Also of course i have changed the datasource above to hide mine.
View 2 RepliesIn Visual Studio 2008 I am using :Private Declare Function BlockInput Lib "user32" (ByVal fBlock As Long) As Long To stop input from occuring during a search-replace operation.
BlockInput(True) ' do not allow input during search and destroy
Dim cursorIcon As Cursor
cursorIcon = Cursor
Cursor.Current = Cursors.WaitCursor
Then setting it to false at the end of the operation. It did not work, so I thought maybe it was because I was calling it from a child window, so I created a function in the mainwindow, and ran it like this:
FrmMain.BlockFrmMainInput()With these functions is the Main window:
[Code]...
It did not solve the problem. I thought maybe it was because I was running under the debugger, so I tried compiling and running it debugger-free, but that did not do any better. I am still getting input when I double-click the mouse on either form.
I need to display the first c.200 characters of a longer string, for the homepage of a news website. I am using VB.NET. Obviously, cutting exactly 200 chars quite often cuts a word in half, e.g.: "The last five years have seen a radical increase in the volume and complexity of company legislation. The Bahamas has established a Stock Exchange, passed legislation aimed at regu" I need a function that will produce: "The last five years have seen a radical increase in the volume and complexity of company legislation. The Bahamas has established a Stock Exchange, passed legislation aimed at" I can then add "... [More]" or whatever to the end of this string and voila! Is there any way of using regular expressions (regex), substr or something similar to produce this output?
View 2 RepliesI am trying to populate a combobox using the following code.
CODE:
I'm trying to edit the CommandText for the Insert Command in a TableAdapter in the Designer in vb.net. Whenever I make changes to the CommandText, Visual Studio (2008) automagically changes the Parameters to a Collection consisting of one Parameter that existed before editing the Command, immersed in a sea of complete garbage Parameters, and then I either have to undo (unless this was the first thing I tried editing, in which case I have to close the Designer to discard changes and reopen it) or manually change ALL the Parameters back to something that isn't complete garbage.
View 1 RepliesDear friends I am new in .net world and I am trying to display a single row to a literal. I prefer VB so my code is as follows but I'm getting the error "ExecuteReader: CommandText property has not been initialized".I also tried sqlCmd.CommandText = "getLastModificationDateTime" without the EXEC statement
View 3 Repliesi have this code in form1 at buttonpreview
[Code]...
I am trying to add an order by case statement in the dbcommand.commandtext but i see that no rows are returned. I want to assign priorities for colors in the case statement. This would help me avoid create a new table to priorities and rewrite a lot of code to map the foreign key.[code]
View 2 RepliesI created a wizard dataset and add data adapters in my Dataset.i want change select commandtext when form loaded
View 1 RepliesI have a large wikipedia dump that I want to cut into different files (1 file for each article). I wrote a VB App to do it for me, but it was quite slow and crapped out after a few hours of cutting. Im currently splitting the file into smaller 50mb chunks using another app but thats taking a long time (20-30 minutes for each chunk). I should be able to cut each of these up individually if I do this.
Does anyone have any suggestions of a way to cut this file up quicker?
What are the different methods for injecting cross-cutting concerns into a class so that I can minimize the coupling of the classes involved while keeping the code testable (TDD or otherwise)?
For example, consider if I have a class that requires both logging functionality and centralized exception management. Should I use DIP and inject both required concerns via an interface into the class that requires them? Should I use a service locater that I pass to each class that will require some cross cutting functionality? Is there a different solution altogether? Am I asking the wrong question entirely?
For some reason I'm unable to set the commandtext of the tableadapter. I have the following code:
'Prepare the sqlcommand
Dim dd As System.Data.SqlClient.SqlCommand
dd = new System.Data.SqlClient.SqlCommand
dd.CommandText = SqlUsers
[Code]...
In my app (written in VS 2003) I use OleDbDataAdapter's to load data. I have some functions that enable be to change the OleDbDataAdapter.SelectCommand.CommandText at run time, by adding a "WHERE" or "HAVING" section to the SQL command, or updating the "WHERE " or "HAVING" section. This way I have have generic load data functions. (load all invoices for Customer 123, load all invoices for the year 2009, or load all invoices for Customer 123 for the year 2009).
With the new VS 2008 TableAdapter, the TableAdaper.CommandCollection property is Protected. How can I edit the TableAdaper.CommandCollection(0).CommandText at run time?
this code is in the button click , i get each data out using spiltbut i encounter error at "cmd.CommandType = CommandType.Text"
Dim conn As New SqlConnection(GetConnectionString())
Dim sb As New StringBuilder(String.Empty)
Dim splitItems As String() = Nothing
[code].....
I am doing a project for a course that involves a database, i have it set up already so that i can have two different labels displaying data from two different fields in a table when the form loads, but i am trying to get it so that when i click an option in a listbox it will change the displayed information. I am using the following code to set it when the form loads:[code]
View 2 RepliesI want my Richtext box to be populated with a text string that contains HTML-style tags to set colour, underline etc.When I try to remove the tags using .cut(), the first cut always works, the second cut only sometimes.Here's a sample to test it:Create a new project and add a button and a richtext box.Add the following code:
Code:
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim testString As String = "ABC<R>DEF</R>GHIJKL"
[code]....
This code works fine.The text between the tags is turned red, then the tags are removed.Now rem out the msgbox line and run again.Sometimes it works, sometimes the second cut fails with no message or warning.I am using Visual Basic 2010
Visual Studio 2010 v 10.0.30319.1
.NET framework v 4.0.30319
I have a long string that I need to parse into an array of strings that do not exceed 40 characters in length. The tricky part of this for me is making sure that the regex finds the last whitespace before 40 characters to make a clean break between strings since I don't want words cut off.
View 2 RepliesMy general method up until now is I use SQLClient class along with CommandText to send SQL INSERT, UPDATE, DELETE statements dorectly to the SQL Server from the VB app. I have a function I use that will escape any special characters within any string variables. I put a lot of vb database functions in a module that all of my forms can use. When I need to pass data around I send/add arguments to functions using regular variables, etc... I log all of my SQL queries sent to the server to a log file for troubleshooting.So far this has worked well. I know there are better ways to do this, Stored Procedures for example. But I just have not made that leap yet. I'm about to consider turning my world upside down!
I'm MOSTLY interested in creating custom Classes that represent the various objects in my database (Customers, Projects, Invoices, etc...). Then defining all of the properties each of these classes should have: Customer.ID, Customer.Name, Customer.Status, etc... and would like to "map" that Customer object to the database I'm interfacing with. I figure I can wrap all of the SQL commands into methods within each class, i.e.: myCustomer.Name = "Joe Smith"
I'm working with the graphic designer in Visual Basic 2008 Express Edition. I tried to cut and paste a groupbox and the variables reverted to standard ones (CheckBox123 etc.), and when I tried to change them back to their proper names, I got an error message stating that this name is "already in use by another component". But this is nowhere to be seen anywhere in the "Form1.vb[Design]". How do I either get rid of these "hidden" variable names or reunite them with the groupbox they used to belong to?
View 8 RepliesDoes anyone has a sample code or idea for cutting and adjusting a picture size when it is uploaded thru picturebox?
For example..
1. Picturebox size on winform = 150*150
2. A picture size = 1024 *800
3. I want to be able to cut 150*150 out of 1024 *800 and upload it. I wish the cutting and adjusting size is possible thru winform.
Let's say I cut a tab control with buttons on it and paste it into a Panel control. After doing this, all my control events are being unlinked from the event code. I have to manually relink all the events in the Properties window. Is there any way round this?
View 15 Replies