Manipulating Output From Sql Command Asp.net?
Feb 10, 2011
I am building a quiz application which has 5 categories. I am saving details like name, category and score to DB. Table where all data is saved looks like :
Name Category Score
John Windows 10
Tom Mac 5
On the start page i want to disable/enable categories if user has/has not took quiz yet (ie. if John has already completed Windows quiz but hasn't Mac then enable Mac Quiz, disable Windows and show Windows score).Whats the most elegant way of retrieving these values from database and then passing them to variable or boolean? What if search returns NULL (if quiz was not taken by John) and manipulating output from SQL Database? I am using vb.net 2.0 and SQL server 2005 and its an asp.net application.
View 1 Replies
ADVERTISEMENT
Mar 29, 2010
I'm wondering, in Visual Basic 2008, how to execute an external dos command and get its output without help of an intermediate file (to speed up)?
View 1 Replies
Jan 10, 2012
I have a VB.net program in which I call the Shell function. I would like to get the text output that is produced from this code in a file. However, this is not the return value of the executed code so I don't really know how to.
This program is a service but has access to the disk no problem as I already log other information. The whole service have multiple thread so I must also make sure that when the file is written it's not already accessed.
View 3 Replies
Jul 21, 2009
I have a program that runs a command line and retrieves the output, but the output I receive is unorganized and run-on. Since 3 processes are being run, I'd like each process results to be listed on a different line.
Here is the code:
Dim viewteam = Page.Request.Form("viewteam")
Dim arg As String = "/c net localgroup hglocal-" & viewteam & "-gold"
Dim arg2 As String = "/c net localgroup hglocal-" & viewteam & "-rw"
[Code].....
View 1 Replies
Oct 2, 2010
I'm trying to find a simple way of checking user stats via FTP, wininet seems to be the best option.How do I get the output from the command though? [code]
View 1 Replies
Apr 2, 2010
I'd like to have a macro in Visual Studio 2005 that calls a DOS command and redirects the output (stdout and stderr) to a file. Just calling the command and ">" redirecting it will not capture stderr, so there are two parts to this:
calling a DOS command capturing both stderr and stdout to a file during that call
I'd then like to open this file in Visual Studio after the command completes.
View 1 Replies
Jan 9, 2010
I am trying to get the output of a CMD command attached to a RichTextBox control. For this sample, I am using the PING command. It works but unfortunately not the way I want it to. Instead of 'appearing' in my RichTextBox line by line, it waits until the entire process is completed and then it attachs it to my RTB.
[Code]...
View 5 Replies
Apr 30, 2011
Getting command parser to work. I've made a new topic for this, because the old one isn't getting much attention, but also, I wanted to refine my questions, so that they would be easier to work with..
Here's how I have this code set up in my project..
I have a function module with public functions like so..
Code:
in my public class GameWindow I have the sub for the first rooms look command..
Code:
Now everything is going to be fed through a button click. User imputs MyString, and presses button. Here's the button code.
Code:
This isn't generating any output.. not sure how to go about getting it working. ha, I'm learning though...slowly, but surely. I like the hands on approach of implementing things into my project, and working with them. I learn better that way, plus the project'll get completed eventually.
View 10 Replies
Sep 11, 2009
I have 2 VB programs that I would like to communicate with each other, but I want them to be separate EXEs. Anyway, the easiest way I figured would be for me to call the one program from the other and then return a result. How do I get this result into another program?
Here is how I want it to work:
1. Start System Information Program (easy)
2. Call a video test program, and send a couple arguments (see below)
3. Receive arguments from the video test (I do not know how to do this, I do not know how to send from the video test or receive from the system information)
View 5 Replies
Oct 13, 2009
I want to run a dos command with a button and the output need to come in the outpud textbox.the only problem is that i need to give another option in the dos command, how can i do this?This is what i use. but how can i give the second command in that command that is already running?
Private Sub CMDAutomate2()
Dim myprocess As New Process
Dim StartInfo As New System.Diagnostics.ProcessStartInfo
StartInfo.FileName = "cmd" 'starts cmd window
[code].....
View 4 Replies
Sep 15, 2009
I am using this to capture output from the command line: url...Is there a way to modify that, so I can get the results as they are updated? [code]Is there a way to capture that output every time it is updated so I can change a text box as it get updated?
View 1 Replies
Mar 16, 2010
I am using this to capture output from the command line:Is there a way to modify that, so I can get the results as they are updated?
View 3 Replies
Feb 18, 2010
Based on the title I'm sure you all understand what I want... So, I need to work with CMD through my app. and I searched google and vbforums and I found some solutions but none of them helped me because all I found was either older version like VB.net 2005 like this topic HERE (and this is exactly what I want) and found some in other languages like c# or c++ that I really don't now them..
View 3 Replies
May 27, 2011
I am running a command on all computers from a list. I am trying to get back a text file that says PASS or FAIL for each computer. I am using the below StreamWriter and function process. The process runs correctly and it rights to both a data file and an error log. The error log however always says PASS for everything. do I know what to set the if consoleOutput = "????" to?
Using swrr As New StreamWriter(ErrorLog, True)
For Each strUserName As String In strLines
Dim ConsoleOutput As String = GetCMDOutput(strUserName, saveFileDialog3.FileName & ".txt",
[code].....
View 1 Replies
May 25, 2010
I want to run some dos commands (eg: a ROBOCOPY) and show the output from this realtime in a text window to show the user something is happening.The command may take a number of minutes so it's important the output is showing in the VB application realtime, and not just all at the end. Obviously the user will wonder what is happening during this time.
View 19 Replies
Nov 27, 2009
Every time I try and redirect input and output of command prompt I have a problem. The debugger itself crashes! Something must really be wrong. What is a good way to launch CMD and send commands to it, receive output.
View 1 Replies
Apr 30, 2010
First let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.
I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _
[Code].....
View 6 Replies
Mar 1, 2012
What I am trying to do: There are three powershell scripts with different time delays as shown below.I am trying to run them asynchronously in .NET and I followed this article to implement Asyncrhonous programming. Where I am stuck:The I am not able to retrieve output after the events are invoked.The scripts are being called but then the program ends and it shows "Press any key to continue" in console windows.I don't what I am missing here.
Info: JobRequest is a class that I use to pass around information keep track of jobs.
Sub Main()
OurAsyncFunctionCalling("psDelayScript2.ps1", "-arg1 4 -arg2 5", 1)
OurAsyncFunctionCalling("psDelayScript1.ps1", "-arg1 2 -arg2 3", 2)[code]......
View 1 Replies
Apr 26, 2011
How would I turn single images into animated gifs and vice versa? Is there an existing library for such a thing?
View 1 Replies
Jun 30, 2009
I'm trying to design a game using vb.net window application, my game is sokoban, a logic game where the character pushes boxes to the destination.I have already programme my picture to be move by my direction key, I trying to find out if it is possible for picture box to push picture box like when the character(a picture box) move to the box(a picture box too), the box will move also. and also the logic for creating obstacle for the game, as the picture that i have programme can move beyond the page, I'm trying to lock the obstacle in, so when i move the picture, it will be block by the picture box.
View 6 Replies
Dec 18, 2011
i'm creating a game like text twist. that when i press letter a, i need to determine which picturebox contains letter a and display it to different location. that also goes to the proceeding letter a's. for example, i have a jumbled letters "aamba". in my code, it only gets the first letter a and removes it form the screen, it's nowhere to be found. and it won't recognize that i still have other letter a's i'm pretty sure about the location that i set it to be placed.here is my
(it's kind of brute force i think)
ElseIf e.KeyChar = Chr(97) Then
counter1 = 0[code].....
View 7 Replies
Apr 2, 2012
I need to be able to read audio files and manipulate them from within my own program (similar to how Audacity does it). Now, I'm not asking for something with a thousand effects and such, I just need the minimal as far as audio manipulation for .net goes. I really just need to be able to figure out pitches and frequencies being played at what times and the ability to move them all around.
View 1 Replies
Apr 30, 2010
I'm creating a program that displays data from a Access database in DataGridView, and I'm able to "call" the database and display it in datagridview normally, but I need to be able to take the data from 3 separate columns and average them together, within VB.
My table basically displays 3 grades for a student, one column for the student's name and the other 3 columns for 3 separate grades, I need to be able to take the 3 grades from the same row and average them together, then display them in a separate column within DataGridView.
Here is my code so far, but this only displays all the records without the average:
Quote:
Public Class Form1
Sub UpdateGrid(ByVal sqlStr As String)
Dim dt As New DataTable()
[Code]....
View 3 Replies
Jan 10, 2012
I am using the Print Document to create the impression in vb.net...Anything I set a certain number of records per page however see the other pages just like the first,some help to handle these records correctly in the leaves?
View 4 Replies
Jul 7, 2011
My script is pulling some information (filename, date, &c) from a server that contains only (nearly) identical excel files generated by a separate application whenever it is used. The goal is to find out who is using the tool and how often.
I need help with two things: extracting info from within the excel file, and appending the results to the SAME excel file each time it's run instead of creating a new file each time.
Here is what I have...
CODE:
View 1 Replies
Mar 3, 2009
I have a string array that contains the following:
(Date Type RequestNum)
3/3 xyz 3
3/3 abc 4
[code].....
View 1 Replies
Jun 1, 2010
I'm trying to make a program that can handle menu order in restaurant.
In this program, there are Main form (frmOrder), Starter Form (frmStarter), Entree Form (frmEntree), and Dessert Form (frmDessert). Each category (Starter, Entree, and Dessert) contains 4 menus, and each forms other than main form have label for name, price (label), and quantity (textbox).
Main Form have 4 buttons (3 of them opens respective form of Starters, Entrees, Desserts. Last button calculates total), and it has big label that displays all the ordered menu. By default it has current time and date, so any ordered menus are supposed to be displayed on separate line (with quantity, name, and price with dollar sign).
Below is the code I wrote for frmOrders
[Code]....
I tried to see it works, but lblTape.Text (which is the big label that displays ordered menu) do not change. I did saw lblTape.Text got value it supposed to (item quantity & item name & item price) but it doesn't change when I close form and return to Main form. I'm not sure where I got trouble to end up like this...
View 11 Replies
Mar 16, 2011
I have a couple applications that store data in the registry for persistence.It works great when running in Windows XP, but since upgrading to Windows 7 I've noticed that it fails, basically saying that the permissions are inadequate.
If I disable the UAC it seems to work fine, but I don't want to do that.
Dim regKey As RegistryKey
Try
regKey = Registry.LocalMachine.OpenSubKey("SoftwareTagLookup", True)
If regKey Is Nothing Then
[code].....
View 1 Replies
Dec 12, 2011
I have a file full of last-names separated by commas and then first-names.
Smith,Bob
Chicken,Ronald
Car,Anastasia
Code:
gc permissions.csv|% {$_.split(",")[0]}
I'd like to grab the first character of the first name and then pre-pend it to the string of the last name. The general idea is to find the user ID that's stored in Active Directory, in my company it's the first letter of the first name and then the last name.
Then I'm trying to add these users as read-only on a specific directory.
View 2 Replies
Apr 26, 2010
I have developed an application using VB.NET, Visual Studio 2008 and the SQL Server database. Now I want to ignore the database (it has 1 table as customer (name,password,hour,minute)) as I don't want my client to install SQL Server separately or other overheads.I am planning to do the whole using file handling in VB.NET (manipulating the data in files itself, for example change username, password, etc.). As I am new I don't actually know the proper way and of course need assistance.
View 4 Replies
