|
hello all,
i want to create runtime odbc for sql server. because i have many database in my sql server..my problem is that
for example :
i create my crystal report user database payroll and i create manually odbc for payroll.my problem is that if i not work in different database then my report not show me record. this is why i want to create odbc for runtime. pls help
vipin paliwal
|
|
|
|
|
Ive got a button on a form and am trying to get the flashwindow api to
work with the form , however it seems i don't understand it! As i have never done an api call im not too surprised.!!
Declare Function FlashWindow Lib "user32" Alias "FlashWindow" (ByVal hwnd As Long, ByVal bInvert As Long) As Long<br />
<br />
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
End Sub<br />
<br />
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
FlashWindow(1, True)'what are the arguments this call should use?
End Sub
no error when i click button, just nothing happens?
Any help will be appreciated.
|
|
|
|
|
MickYL wrote: Ive got a button on a form and am trying to get the flashwindow api to
work with the form , however it seems i don't understand it! As i have never done an api call im not too surprised.!!
Declare Function FlashWindow Lib "user32" Alias "FlashWindow" (ByVal hwnd As Long, ByVal bInvert As Long) As Long
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
FlashWindow(1, True)'what are the arguments this call should use?
End Sub
I did see the same question asked by someone else. It could be one or two days back. Just doing a forum search could help.
I guess it should be
FlashWindow(Me.Handle, True) :~
Is it Me.Handle or Me.Hwnd I am not sure please check anyway the first one takes the handle of the window to be flashed. In your case it is this window hence Me .
Nibu thomas
A Developer
Programming tips[^] My site[^]
|
|
|
|
|
I tried after recieving your advice which was similar to advice from others elsewhere, but now i get an error that Me.handle cannot be converted to long ??? me.handle nealy worked i guess. the other suggestion was a syntax error.thx
|
|
|
|
|
Actually that was me who posted it a few days ago and I dont think its going to get a reply ! Thanks for your suggestion. I will try it and see how things go!
thx....
|
|
|
|
|
Hi,
does anybody know, how to convert RSA public key into Base64 Encoded string.
Actually I'm creating Keypair and digital signature using RSA in VB.NET and verifying it into java. For that i need to store the the RSA public key into a file on the hard drive. Later Java class will fetch this public key and use it for verification.
But when i give the RSA public key into Xml format to Java class it is giving an error "Invalid Key Exception." Java class needs Base64 encoded string. So how to convert this xml key into Base64. It will be gr8 if anybody helps me in this issue.
thanks
|
|
|
|
|
How to preview Report without using crystal reports and Export it to any format like Pdf,xls etc.
ssadsadadgawkjawoidehqwohoiweheiwqhrewoihriwolhrwiehriwehfuiwhfiluwhwifhiwhfiwhfiwehfiwhrwhrwhuiw
|
|
|
|
|
That would depend on what kind of report you're using. If it's a Crystal Report file, then you need use crystal reports. If you haven't created the report yet, then I would look into a 3rd party add-in that will allow you to do that. If you only want to display it in one format like excel, then you can just create an Excel Application object and fill your sheets through it.
|
|
|
|
|
Hiya, Do you mean how to preview your crystal report classes? I had the same problem. I was browsing the net looking for an answer when I found a web site that offered a means to do just that. Below is the link
http://www.itteam.net/itteamreportviewer.html[^]
They offer a number of low cost .Net development utilities.
Hope this helps
Rob
-- modified at 13:12 Friday 26th May, 2006
|
|
|
|
|
I am trying to connect to a system in a network through WMI.
If i am not able to connect to a system through WMI then generally i get
"Access Denied" error. for which i know the solution.
But now i am getting "RPC server unavaliable"
Can someone tell me shat does it means and it's solution.
|
|
|
|
|
sounds like the rpc server isn't running on the machine you're attempting to connect to. Pull up the services on that machine and see if it's running.
|
|
|
|
|
We have checked the services and yes they were stopped but even after starting it we are still getting the same error.
|
|
|
|
|
Hi, Friends
what i have is 1 application in that i run so many stored procedures, but now i have to set parameters to them, that is also i can do but every time i have to set thos parameters acording to the store porcedures
what i want is, if i can list in my program that to 1 procedure how many params r their and put it in any arrey or some thing like that so dinamicaly i can add thos param b 4 running the procedures
For Exam:
SP_SelectEmployee <@EmpId>
in the coding i have to wirte
objCommand = new OleDbCommand(SP_SelectEmployee,objConnection);
objCommand.CommandType=CommandType.StoredProcedure;
param1=SetParameter("@EmpId",OleDbType.VarChar,strKey1.Length);
this is the way i have to set the datatype every time and it lenght so what i want is that if i can get the parameters required and it lenght in an array or in some list so that i can pass thos params same which i want not just wage param type
Please Help Me Gays
Harshad Pednekar
|
|
|
|
|
You can pass the parameters into a hashtable. And then create a loop to pass these parameters one by one to it. You can use following example:
Public Function SelectEmployee(ByVal OracleConn As String, ByVal SPName As String, ByVal crOutput As String, Optional ByVal ParamTable As Hashtable = Nothing) As DataSet
Dim m_objDA As New OracleDataAdapter
Dim m_objDS As New DataSet
Dim m_objDBCmd As OracleCommand
Dim m_objDE As IDictionaryEnumerator
Dim Conn As New OracleConnection(OracleConn)
Try
m_objDBCmd = New OracleCommand
m_objDBCmd.Connection = Conn
m_objDBCmd.CommandType = CommandType.StoredProcedure
m_objDBCmd.CommandText = SPName
If Not IsNothing(ParamTable) Then
m_objDE = ParamTable.GetEnumerator
While m_objDE.MoveNext
m_objDBCmd.Parameters.Add(m_objDE.Key, m_objDE.Value)
End While
End If
m_objDBCmd.Parameters.Add(crOutput, OracleType.Cursor).Direction = ParameterDirection.Output
m_objDA.SelectCommand = m_objDBCmd
m_objDA.Fill(m_objDS)
Catch ex As Exception
'm_objDS = Nothing
Throw ex
Finally
m_objDBCmd = Nothing
m_objDA = Nothing
End Try
Return m_objDS
End Function
|
|
|
|
|
Thank you for the reply friend, but my problem is not this
problem is i have created a procedure and now say i forgot the params of that procedure so what i want is in the vb.net codding i want to get the list of the params and i want to build that procedures and excecute in the database and get the output so say for example i have 1 procedure with some params like
SP_ABC <p1>,<p2>,....
now i dont remember thos params so in my vb program how can i get the list of thos params and it's datatypes
Thankx Again
Regards,
Harshad Pednekar
|
|
|
|
|
hello frds
i am creating the databse and table from VB.
Plz help me how to set 'Require' property of column to No.
When i append the column to table and table to databse, the 'Require ' property is by default set to YES, i want to set it to No.
plz help me
Rahul here
-- modified at 2:28 Thursday 25th May, 2006
|
|
|
|
|
rahul.shendurnikar wrote: i am creating the databse and table from VB.
Plz help me how to set 'Require' property of column to No.
When i append the column to table and table to databse, the 'Require ' property is by default set to YES, i want to set it to No.
Well Require property is just another form of NOT NULL . If you don't specify NOT NULL it will take NULL values I guess.
Nibu thomas
A Developer
Programming tips[^] My site[^]
|
|
|
|
|
|
HiYa u guys.
In VB.Net, how to show a certain tab.??
I mean, if i have 1.Add 2.Update 3.Delete Tab.
what is the code for me to show the Update Tab.?
thanks...
isfufushah
|
|
|
|
|
tabControl.SelectedTab = tabPage, from memory.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
TabControl.SelectedTab = TabUpdCust.show
is this the code suppost to look like.
but, in my MDImodule it says it is not defined.
what is it mean.??
|
|
|
|
|
Why the .show ? I'd say that's the problem, it's not correct.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
o.k. can u pls show me some example coding.??
|
|
|
|
|
myTabControl.SelectedTab = myTabControl.TabPages(0)
or
myTabControl.SelectedIndex = 0
Current blacklist
svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
-- modified at 8:43 Thursday 25th May, 2006
|
|
|
|
|
HI,
When i run my multithread program,Why the CPU use is always 100%?
Any issues will be appreciated!
ICQ:258-235-734
MSN:msnadair@hotmail.com
|
|
|
|