|
I’m trying to access one row in a table based upon its int value held locally in a variable. (I increment the 'count' variable in the application.) As you can see below, 'count' is the local variable in the application. Can this be done or is there another way?
-Shannon
If count < iResultQuery Then
myConn_.CommandText = "SELECT WorkInstructions.InstructionText FROM WorkInstructions
WHERE WorkInstructions.StepNo = count"
end if
|
|
|
|
|
spettiford wrote:
If count < iResultQuery Then
myConn_.CommandText = "SELECT WorkInstructions.InstructionText FROM WorkInstructions
WHERE WorkInstructions.StepNo = count"
end if
Should be:
If count < iResultQuery Then<br />
myConn_.CommandText = "SELECT WorkInstructions.InstructionText FROM WorkInstructions<br />
WHERE WorkInstructions.StepNo =" & count<br />
end if
hope that helps
|
|
|
|
|
THANK YOU!!! I knew there was a way, but just didn't get the syntax correct. It works great and you saved me.
|
|
|
|
|
your welcome
and for string variables:
myConn_.CommandText = "SELECT BLAH FROM BLAH_TABLE_NAME WHERE BLAH_TABLE_NAME.BLAHCOLUMN_NAME (OPERATOR)'" & report_type & "'"<br />
|
|
|
|
|
|
I have created a class library in which I have created customised textbox columnstyle.
When I click on the cell of this datagrid,actual text box is made visible(normaly text is painted in the cell using drawstring method of in overriden paint method.) & we can edit the text in it. but this text box is not handling arrow keys! The focus is lost from the text box if we click arrow keys. because data grid was handling these events. I checked these events in datagrids overriden method 'IsInpunkey' method & tried to return true whih will avoid further processing of key by base class method but it didn;t worked. I also tried to handle this through textbox's IsInputKey method, but it failed there also.
Can any body tell me why is this hapening & how can I make arrow keys work in my text box.
Thanks.
|
|
|
|
|
I have been attempting to find my own method for controlling the "boundaries" of child windows within the main parent. So far I have come up with:
Private Sub childform1_LocationChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.LocationChanged<br />
If childform1.Location.X < 144 Then<br />
' childform1.Visible = False<br />
'cannot use the visible= False as this cause the application to crash.<br />
childform1.Location = New System.Drawing.Point(144, childform1.Location.Y)<br />
'childform1.Visible = True<br />
End If<br />
If childform1.Location.X > 753 Then<br />
'childform1.Visible = False<br />
childform1.Location = New System.Drawing.Point(144, childform1.Location.Y)<br />
'childform1.Visible = True<br />
End If<br />
If childform1.Location.Y > 442 Then<br />
'childform1.Visible = False<br />
childform1.Location = New System.Drawing.Point(childform1.Location.X, 0)<br />
'childform1.Visible = True<br />
End If<br />
'for the main form<br />
F1.AutoScroll = False<br />
'F1.Refresh()<br />
End Sub
The above code works fine, does what I need it to, but there is a large amount of flickering going on when the form is moved. I tried to prevent this by making the form invisible when the relocation was going on but the application crashed as a result.
Does anyone have an idea I might try to prevent the flickering?
|
|
|
|
|
How Can I Create Query Builder Using VB By DAO Connection
S.venkatesh
|
|
|
|
|
hello,
i start vb.net programming now.
i dont any about coding,link database with access database and link between forms.please help me.
i need them.
thanks
best regaurd
k.pakzamir
|
|
|
|
|
I've recently a connection problem between vb.net and sql server and a guy have give a link to me!
I hope it's what you want and search !
ConnectionSting : http://www.connectionstrings.com
|
|
|
|
|
I've recently a connection problem between vb.net and sql server and a guy have give a link to me!
I hope it's what you want and search !
ConnectionSting : http://www.connectionstrings.com
Excuse, but I think i've post the same message with a anonymous state
SeLoRBIS
|
|
|
|
|
hi friends,
Third time i am asking about dataset when i am having table with more than
five lacs of record i want to show all record to user. that time dataset stuck(hanged) what to do?
|
|
|
|
|
I have created a package using VB .Net running under the 1.1 Framework
It has a series of buttons along the bottom of the screen.
When installed on PCs in the UK it works fine.
When installed on PCs in Germany, the users cannot see the buttons ( except for the one on the far left ). The buttons must exist, because they still function when accessed via the Tab + Enter keys.
Can anyone shed light on why they cannot see them, and how to solve the problem ?
A typical machine in th UK is Panasonic CF-29
The machine in Germany is IBM Net Vista
|
|
|
|
|
hi...
I'm manipulating on the Crytal Report. The problem is that I have one printer having many TRAYs on the printer, and I want to choose the default TRAYs when user prints the report. Besides, it doesn't allow users to select the printer. Tell me how to do that, please. Thanks
|
|
|
|
|
Hi everybody,
I want to ask a question about MshflexGrid Control ,
I have a grid in myProject that is writing with VB6 ,I update this control with timer control at 2 second from DataBase.
I want to control Grid 's Click event and When I click a Row for example row3 ıt catch this event ,but I try and try then It can create wrong result that catch LastRow of MyMshFlexGrid ,For example ,I click 3.row It display SelectedRow=39 (LastRow of myGrid)
How can I solve this problem?
I hope ,You could understand !
Thanks for your interest
|
|
|
|
|
Hi
Nice Day
Use This To Get The Row Ur Select By Click
GridName.get_TextMatrix(GridName.Row,<column u="" want="" from="" this="" row="">)
Waiting ur Reply
Best Regrad
Scorpion
|
|
|
|
|
Hi, I am facing some proplem to develop an application in VB6.0. My database is SQL Server. The main problem is I need to insert the data in a particular table using SQL DMO Objecs.
I have One database called dexpro. in this I had a table called Employee.
In another database called Mydata. in this I had a table called Employee.
So when I enter a Row in a Dexpro's Employee table that row need to check
in Mydata's Employees table. When That particular row is not exist in Mydata's Employees table, then that particular row need to add Mydata's table.
when I delete a row from Dexpro's Employee table that Particular row need to delete from Mydata's Employees table.
This is nothing but called Replication. This operations need to perform through using SQL DMO Objects.
Please send solution to me
|
|
|
|
|
hello everybody,
anyone of you can tell me how to check server hard disk space using
vb.net. Is it possible or not? If yes then explain me.
|
|
|
|
|
Yes, it's possible. But how you go about it depends entirely upon the type of werver that you're talking about. Unix/Linux, NetWare, Windows, ...???
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
i am talking about window o/s
|
|
|
|
|
Hi
I have this problem of writing to a text file everyday at a particular time say 10 AM in the morning automatically.I am being told that using windows service is a solution.I however dont know how to go about doing this
faraz
|
|
|
|
|
File/New/Project/VB.NET/Windows Service. That should be a good start.
Google[^] seems to have a lot of info, as well.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Another option would be to create an application that doesn't put up a user interface, either a Windows Forms app or Console app to do the same thing. Be sure that it quits itself after it does what it needs to. Just setup a job to run the application using the Scheduled Tasks control panel. That way, your app doesn't need to be running 24 hours a day if it's only going to do work for a couple of seconds a day.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have the following event handler for a rich text box.
Protected Sub Link_Clicked(ByVal sender As Object, ByVal e As System.Windows.Forms.LinkClickedEventArgs) Handles rtbDescription.LinkClicked
Try
System.Diagnostics.Process.Start(e.LinkText)
Catch ex As Exception
Debug.WriteLine(ex.Message & " : " & e.LinkText)
End Try
End Sub
When I click a link in the rich text box nothing happens an I receive the following line in my output.
The system cannot find the path specified : http://www.cnn.com/rssclick/2005/TECH/internet/07/28/disappearing.apple.ap/index.html?section=cnn_tech
Anyone have any ideas?
MSDN states that this handler should fire the default browser.
|
|
|
|
|
Try it like this:
Dim proc As New Process()
With proc
.StartInfo.FileName = e.LinkText
.StartInfo.UseShellExecute = True
.Start()
End With
I would appear that Process is not using Shell Execute for some reason, so, force it to do so.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
