C# Dont Reference Sqlreader In Client Portion Then Where?
Oct 30, 2009
Assume I have a form that has say 5 text boxes and I need to pull some data from a database then set those 5 text boxes with that data.So assume I have 3 basic layers: the code behind for a default.aspx page a BLL class that contacts the DAL and a data access layer (DAL)But I've heard and read that the default.aspx page should not know about sqldatareader, in fact you probably dont want to add the sqlclient namesspace to the default.aspx code behind page. [code] Then the BLL would simply call the DAL to call a stored procedure in SQL Server and do a CommandObject.ExecuteReader, get the results pass it back to BLL and BLL would then send it to the code behind page of default.aspx.I can provide full source code if that doesn't make sense. My question is if its bad that default.aspx actually declares and knows about an SQL Data Reader then what is the better way to do this? What datatype should I be using to avoid having an sqldatareader in my interface code ?
View 2 Replies
ADVERTISEMENT
Sep 24, 2010
I'd like to know after I've executed MySqlReder = MySqlCommand.ExecuteReader() how many rows it returned. If it's one I can continue processing with the data. If it's more than one I need to populate a drop down list box.
View 6 Replies
Aug 16, 2011
i have a WPF application that uses a service reference to a web service.Now i have a GUI component that tracks the progress of this...But i seem to have some sort of bug here, it only occurs on some machines and not often..I start a call with MethodNameAsync and display the progress bar until the matching Completed event occurs.
some times i call 3 different async methods in a row but only the two of them get their Completed event raised so the GUI will be locked and the application has to be restarted.After being totally frustrated a few weeks i found the event AppDomain.CurrentDomain.FirstChanceException, so i hooked up to it and started logging all FirstChanceExceptions..
[Code]...
Fix this temporary by not using async methods and instead using a thread that will call them one by one.. now this is not a elegant solution, i should be able to use the async methods...
View 1 Replies
Oct 1, 2009
I would like to pass to values to a stored procedure. I am using a sqlreader to populate a excel sheet. I need the user to be able to select a range, rather that the whole table.
Dim strSQL As String = "sp_im_select_customerdtl"
Dim data As String = ""
sqlCon.Open()
[Code].....
View 4 Replies
Jun 21, 2010
We are creating a Who wants to be a millionaire style game in VB. Our server is pulling information such as questions and answers from a Access Database and sending them to the contestants (Clients). All transfer of information is directly from the server to each client. One of the "Life Lines" we want to use is "Ask a friend", where one client is able to Instant message another client for a short time to get help on the question.
[Code]...
View 2 Replies
May 2, 2012
All i need to do is save the project when i done, But it keeps updating.
View 7 Replies
Aug 30, 2011
i am using PostMessage API to send text to another app but the prob. is i want which key is pressed and it not write to the app for example.If a person is writing to notepad he pressed "H" but it will not write H and the key will be stored in my program i am using keys.H for this for reciving but i dont know how to not write the key which he pressed.how to use it which api or code to use.
View 2 Replies
Feb 5, 2012
[code]...
View 11 Replies
Feb 24, 2010
The ZEMSDK program only run on VS 2005 is there any possible that it can run in VS 2008? because i am using VS 2008..
Is there any object or function that are not suppported by VS 2008?
View 12 Replies
Jun 26, 2010
I have adapted a connection string i used alot in vb6 to what, after much research i think it should look like now. I added some code to a button, i dont get any errors and no result in the textbox.[code]
View 2 Replies
Mar 31, 2012
ok i want the speech recognition to listen to me but not do anything unless it hears a certain word or phrase
View 4 Replies
May 29, 2009
Public Function ChangeUpdateOrderPlace() As Boolean
' Try
Dim dsChanges2 As New DataSet
[code].....
View 3 Replies
Nov 23, 2009
It there a way where you dont type anything in the textbox, and you press F2 and then the textbox says F2 or if you press 1 on your numberpad, the textbox will say NUMPAD1, or something like that and if you press Ctrl on your keyboard the TextBox will say Ctrl
View 2 Replies
Jun 8, 2010
how can i prevent from software to be opened twice?
View 9 Replies
Jul 8, 2009
I have formA.vb and I added some shortcut keys using the key_up event handler. Before coding the handler I change the keypreview property of the form to true. I added this code :
Private Sub IntRMA_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyUp
If e.KeyCode = Keys.ControlKey And e.KeyCode = Keys.C Then
[code].....
View 3 Replies
Mar 19, 2011
I have developed an application which launch an external executable. I want to be able that if I am using another one, like notepad, I dont loose the focus to the one called by my application. I have test it changing the startinfo.windows style ( http://msdn.microsoft.com/en-us/libr...ndowstyle.aspx ) from Normal, minimized and hidden.Every one I have used make notepad loose the focus to the new launched application. Is it there any way to launch an application and make this dont get the focus, in order I can continue working in other app without problems?
View 7 Replies
Dec 8, 2010
i am still new to using session state, i want to convert page name into and integer according to a database table a function then compares "X" and "Y" to check if a user have the right to view this page..i know this is not the best way of managing website security, but it is like "training on how to use the session".[code]
View 1 Replies
Jan 28, 2009
I imported icons from the VS 2005 Image library and they look kind of weird. I have it set on 16-bit color. The icons in the toolbar look fine but the rest don't look right. Has anyone had this problem before?
View 3 Replies
May 1, 2009
I am using ASP.net with VB.NET.Is there some Validator that i can use that will check the size of the uploaded image?Else what must i do in code to make sure that the user do not upload images more than 1MB?
View 3 Replies
Jun 22, 2010
I have a problem that hopefully someone can shed light on. My OleDBdataadapters and OledbTableadapters have gone on strike In a simple vb.net 2005 pro project I have an Access 2003 .mdb with 2 tables each with 1 primary key and all other fields allowing zero length and not required. The database (not read only) is included in the project (see connection string below which works because data is presented on bound forms).
Although each table's data is displayed on one of 2 bound windows forms, it just refuses to update, add new or delete. I've deleted and recreated forms, etc, using wizards and just run time code but the problem is still there. I can change data manually in the mdb. The code below refers to a site mdb table and was wizard generated. I added an update query to the TableAdapter using the wizard, see sql below.
[Code]...
View 9 Replies
Dec 15, 2011
wen i open mdi through the login form, the forms inside the mdi child forms dont seem to execute.
View 2 Replies
Dec 13, 2009
Each time I create a program, if I don't change the CPU type to x86 in the Project Properties, Compile, Advanced Compile options, it doesn't work. For example, if I hit the drop down button on a combo box, there will be no data, but after switching to x86, there is data. How does changing the CPU type affect how others (such as when its being graded) view the program? If the program is not run on an x86 system, would it appear to not work then?
View 1 Replies
Oct 21, 2009
I found some threads talking about this.. but when I follow the thread on where to do it.. it must be talking VS2005.. cause on vs2008 in project properties -> application tab-> I dont see View Application Events button. so I assume its moved in VS2008 ? I did find some code I guess to do the same thing.. but I wanted to make sure I do it correct.. since I have an app that a client is running and they keep getting framework exceptions and I have no clue where its coming from.
View 18 Replies
Sep 2, 2010
How can I only add the decimal part of a number to another one?
example: if a number is A = 10.25
Then X = 30
Y = X + 0.25 (Here it added 0.25 which the decimal only NOT 10.25)
Another example, If X = 16.35, A = 102.001
Y = 16.351
View 6 Replies
May 13, 2009
I was wondering what the easiest way is to get a portion of text from a string for example, you have:
"example1,example2,example3"
And i need to be able to get all three of the items separate:
"example1"
"example2"
"example3"
The length and number of items will change, I'm using a listview subitem
View 2 Replies
Feb 29, 2012
Lets say I have a variable: varEmail. It contains a variable equal to the user's email address, so it might contain a value likeNow, lets say I want to get just a portion of the email address, e.g. strip off the domain, like so:
View 5 Replies
Sep 7, 2011
I am trying to extract the first portion of a string up to the first SPACE or any non-numeric digit.I thought I could do it but the string may contain an alphabet in the front followed by varying digits of numerals, making it more complicated.Here are some examples of the string to be parsed and the expected results:
String[code].....
I would have to use a series of instr statements but the code would be much cleaner using RegEx.
View 2 Replies
Jun 28, 2010
I'm trying to look in the program files for a directory(the gimp directory). I could hard code it but they change the file name and the exe name with the versions. So I only know that the folder contains the word gimp. How do I search for it only knowing a portion of the file name.
My.Computer.FileSystem.FindInFiles(Environment.SpecialFolder.ProgramFilesX86, "gimp", True, FileIO.SearchOption.SearchTopLevelOnly)
This is the code that I've tried but it just doesn't work.
View 14 Replies
Oct 17, 2011
I have a drawing image, Dim DrawingImage as Image = My.Resources.Img, which will be drawn on my form. The DrawingImage is supposed to be 64x64, but the Img.png is 114x114. How can I get this DrawingImage to stretch so that there is no cut off portion?
P.S. Is there a way to BringToFront this DrawingImage?
View 4 Replies
Jan 8, 2009
I need to retrieve a portion of xml into a datatable
<Product>
-<productID>123</productID>
-<productName>123</productName>[code]......
Now Under product tag there are ProductID, ProductName and ProductFeatures.Under ProductFeatures tag there are three "productfeaturetext" tags.I only need to extract "Features" tag into a datatable to loop it, how this can be done ?
View 3 Replies