|
how do i get infomation from a database using a datagrid using sql
|
|
|
|
|
Which language are you writing this in? J#, C#, VB, etc, what?
Are you using .Net 2003? VB6? Give as much information as possible.
What are you trying to do specifically?
-Nclero
|
|
|
|
|
Nclero wrote:
Which language are you writing this in?
i suppose it is in VB as we are currently talking on the VB Forum
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
search the MSDN for SQLDataAdapter... this class provides good functions to work with ADO, but of course, with MS SQL Server too...
what RDB do you query on ?
what language do you use also, VB6 or VB.NET ?
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
search MSDN by keywords "ADO.NET" ,there are lots of samples tell us how to do so
Today is a gift, that's why we call it present
|
|
|
|
|
how do i display infomation from two different tables created in access on a data grid using VB 6.0
how do i also add and remove infomation froma a datagrid that is from a VB 6.0 interface and at the same time update the da:-Dtabase
|
|
|
|
|
Have you ever taken a look at the MSDN?
Try www.msdn.com and ask your question in there - not to brush you off or anything, but they can answer your question with a greater level of detail and you'll get more out of it that way.
Trust me, as a programmer myself, the MSDN and I have gotten very close over the years.
-Nclero
|
|
|
|
|
I am making my own version of a media player. The progress is going great except that the DS control (msvidctl.dll) will not play MPEG-2 files. I thought that the control would handle this automatically. MSDN says that we need to specifiy the MPEG-2 Demuxer and other stuff. Could anyone please post some sample code (VB would be prefered, but otherwise I can join the peices from other languages). I am not using Microsoft.DirectX.AudioVideoPlayback.dll, even thought it works great I cannot combine this assembly with anyother dll using ILMerge.
I have also built a DVD application using the same dll, the only help I need is figure out how to control the dvd navigation filter. At the moment I use
DScontrol.view("DVD:")
This snippet will allow me to play dvds but I cannot control which drive I want to play i.e. If I have 2 drives with dvd movies in the them, the drive that has the master setting on the IDE bus or lower drive letter(dont remember which one of the 2) will play everytime. If I eject one of them, the other one will play. Does anyone know how I can command a specific drive to play a dvd movie? Your help is greatly appreciated.
Thanks
|
|
|
|
|
Figured out the first part. I needed to install an "MPEG2 decoder." But I already have PowerDVD 6 w/ valid DX and WMP10 decoder, for some reason reinstalling PDVD allowed my MPEG2 playback. Another weird thing is that WMP10 and PDVD both played MPEG2 files and DVD but my DS app was throwing exceptions (even though they have the same base classes) ?!#!@# Gotta love Microsoft stuff  .
However I still need help on the second part, the DVD navigation filter. Any help would be great. Thanks
|
|
|
|
|
hello, I have try to translate this code into vb.net but that does not function, my richtextbox is black, Can't you translate it into vb.net for me please
class TransparentControl : Control
{
public TransparentControl()
{
base.SetStyle( ControlStyles.UserPaint, true );
base.SetStyle( ControlStyles.DoubleBuffer, true );
base.SetStyle( ControlStyles.SupportsTransparentBackColor, true );
}
}
class TransparentRichTextBox : RichTextBox
{
public TransparentRichTextBox()
{
base.ScrollBars = RichTextBoxScrollBars.None;
}
override protected CreateParams CreateParams
{
get
{
CreateParams cp = base.CreateParams;
cp.ExStyle |= 0x20;
return cp;
}
}
override protected void OnPaintBackground( PaintEventArgs e )
{
}
}
|
|
|
|
|
Class TransparentControl
Inherits Control
Public Sub New()
MyBase.SetStyle(ControlStyles.UserPaint, True)
MyBase.SetStyle(ControlStyles.DoubleBuffer, True)
MyBase.SetStyle(ControlStyles.SupportsTransparentBackColor, True)
End Sub
End Class
Class TransparentRichTextBox
Inherits RichTextBox
Public Sub New()
MyBase.ScrollBars = RichTextBoxScrollBars.None
End Sub
Protected Overloads Overrides ReadOnly Property CreateParams() As CreateParams
Get
Dim cp As CreateParams = MyBase.CreateParams
cp.ExStyle = cp.ExStyle Or (32)
Return cp
End Get
End Property
Protected Overloads Overrides Sub OnPaintBackground(ByVal e As PaintEventArgs)
End Sub
End Class
'Convert C# to VB.NET
'http://www.developerfusion.com/utilities/convertcsharptovb.aspx
|
|
|
|
|
I have a date field and a dropdown list on web form. The dropdown list contains 3 values.
I want that when I populate the Date field the dropdown list will be automatically set to one of the values in the drop down namely dated.
Has anyone any ideas how to do this?
thanks,
macca
|
|
|
|
|
you could use the tag member to store any non-displayed object on your combobox (useful when used to search on another point than the caption...)
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
I have a label called department and a text box called text department. In my code I am retriving the department Id which is A.
What I want is that if the department Id is A then I want the above label and textbox to appear on the web form but if the dpartment Id is not A I want the above label and textbox not to appear on the web form.
In the code I have something like this:
deptId = P
If DeptID = A then
label = active
textbox = active
else
label = inactive
textbox = inactive
can anyone help with this?
macca
|
|
|
|
|
Try using visible property
Something like
If DeptID = A then
label1.visible = false
textbox1.visible = false
else
label1.visible = true.......
- ashish
|
|
|
|
|
Thanks Ashish,
That worked a treat.
macca
I have another question for you:
I have a date field and a dropdown list on web form. The dropdown list contains 3 values.
I want that when I populate the Date field the dropdown list will be automatically set to one of the values in the drop down namely dated.
Have you any ideas how to do this?
thanks,
macca
|
|
|
|
|
You may like to set AutoPostback property of control to true. Then you should be able to handle the control values using codebehind.
- ashish
|
|
|
|
|
I'm not sure how to do this, would you have any examples?
macca
|
|
|
|
|
sir i created one vb application in that i am genarating excel reports. first time am clicking report command button then it running executing correctly if i am click once again the report command button it is not running.
iam using this commnad for add sheets Sheets.Add before:=Worksheets(Worksheets.Count)
the error for second time click is
worksheets.count=
|
|
|
|
|
Hi
Anyone knows how to do multiple items drag n drop between listboxes.
Thanks in advance.
- ashish
|
|
|
|
|
Imports System.Web.Mail, this name sapce is giving a error message as
"namespace 'mail', imports 'system.web.mail' not found"
this namespase is working fine in other from but not working in another why is this? can some help me with this?
kiran
|
|
|
|
|
You didn't add a reference to System.Web.dll in your new project.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
thanks Dave!
i got the connection.
|
|
|
|
|
Hi
I am using the cyrstal report viewer control in my .Net application. My Client wants that when the report display the data, if he clicks lets say on AccountID field then the Accounts Form should get opened. Please will anybody let me know how i will come to know which field has been clicked and what is the value of that field.
Thanks in Advance
Arshad
|
|
|
|
|
In a winform , Me.Close() will active a close event.
However , this event could not be edited in vs.net 2005 beta 2.
Why?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
