Visual Basic

Christian Graus17-Oct-06 21:57

17-Oct-06 21:57

What is it you want to do ? Record your actions on a web site ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

kumarprabhakar7417-Oct-06 22:17

kumarprabhakar74

17-Oct-06 22:17

I want to record action of web page like requesting of url, input in textbox, click on button. Record action should generate .net code. So next time I only run record action which save my time to do navigation from scratch

abc

Dave Sexton18-Oct-06 0:10

Dave Sexton

18-Oct-06 0:10

If saving time is what your're after then forget recording actions and look at caching[^].

Dave Kreskowiak18-Oct-06 3:33

Dave Kreskowiak

18-Oct-06 3:33

I already answered this. There is NOTHING that will watch you surf the web and generate VB.NET code to duplicate what you did.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Decryption/SHA256

ravimorampudi17-Oct-06 21:08

ravimorampudi

17-Oct-06 21:08

How to Decrypt string which has been encrypted using SHA256

Thanks

Re: Decryption/SHA256

Christian Graus17-Oct-06 21:58

17-Oct-06 21:58

It's a hash, so you can't. The hash doesn't contain all the data found in the original string.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: Decryption/SHA256

darkoex18-Oct-06 1:34

darkoex

18-Oct-06 1:34

you can break the hash using bruteforce or tables method.
if you want to bruteforce the hash, you better have a real good processor and lots of patience, because it's going to take too long(months/years)...
tables are lot faster but i dont know anyone that have sha256 tables (maybe NSA ^^)

anarchy will bring us order

exe and dll

amaneet17-Oct-06 20:55

amaneet

17-Oct-06 20:55

Sir,

In C++ exe we knows that there is a main() .So Window knows where to execute the code in the c++ output exe, I mean there is a starting point , that is the execution will take place from the main().Now my queston is , In the Vb.Net What is the starting point.I mean From which point the exe will execute the code.

Thanks.

Re: exe and dll

Christian Graus17-Oct-06 22:04

17-Oct-06 22:04

static void Main

The trouble is, VB.NET hides this from you by default, I believe, and just generates the code behind the scenes to run your main form. But, you can make this method visible, so you can change it.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: exe and dll

amaneet17-Oct-06 23:21

amaneet

17-Oct-06 23:21

Sir,

Thank you very much for ur kind attention.
I want to ask one more thing.How can i make that static void main function visible.

Thanks

Re: exe and dll

Christian Graus17-Oct-06 23:54

Plz help - How to access database from server in vb.Net

17-Oct-06 23:54

Sorry, if I knew, I'd have told you. Just adding it explicitly may do the trick.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Jats_4ru17-Oct-06 19:41

Jats_4ru

17-Oct-06 19:41

I hav developed a application which has to access the database from a centralized location(Server).

The Connection String i was using before to access the DB from the same(local) computer was...
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\xx\xx.mdb;Jet OLEDB:System Database=system.mdw;"

The Connection String i am using now to access the DB from the server is...
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & Server.MapPath("\Leave\Leave.mdb") & ";"

But an error is raising...as
ERROR - - - - - -> Name Server is not declared.

I had used namespaces ->
Imports System.Data
Imports System.Data.OleDb
Imports System.Data.SqlClient

Is there any other namespace tobe provided.
(Or)
Is it any other problem.

Plz help...

Jats

Re: Plz help - How to access database from server in vb.Net

Christian Graus17-Oct-06 22:07

Re: Plz help - How to access database from server in vb.Net [modified]

17-Oct-06 22:07

Jats_4ru wrote:
ERROR - - - - - -> Name Server is not declared.

Herer[^] is the info you need.

The method is in System.Web, and if you don't have that, you probably are not within a web app. The client can't use this to map to the server, how does it know where the server is ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Jats_4ru18-Oct-06 2:35

Jats_4ru

18-Oct-06 2:35

Hi Thankx Christian.

Actually i am a bit new to .NET
Can you plz guide me how to Convert the present application developed in VB.NET to Web app.

-- modified at 0:48 Thursday 19th October, 2006

Jats

Taking info from a website?

JustinEng17-Oct-06 18:16

JustinEng

17-Oct-06 18:16

Hi,

Well, I'm currently taking an introduction to visual basic class, just to let you know what kind of person I'm am if that's any help.

Anyway, I'm trying to study for the SAT's and focus on my regular class work as well. One of my teachers suggested going to this site:

http://www.collegeboard.com/apps/qotd/question

Basically, CollegeBoard posts a new SAT question of the day each day.

Since I normally don't have time to go on the computer every sing day, I was thinking of devoloping an application that would go to that link, copy and past the question and answer, and storing it into a SQL server database all with one click or something. I don't really know where to start, and I don't really know how to do it. (I only know the really raw basics). Sorry if I posted this in the wrong section or something, maybe this program can better be written in another language? I don't know any other language besides a few of visual basic, sql, and asp.net. And I code in Visual Studio 2005.

Sorry if I sound stupid...
Thanks,
Justin

Re: Taking info from a website?

Dave Sexton18-Oct-06 0:18

Dave Sexton

18-Oct-06 0:18

I had a look at that site & I don't think it's possible as they don't offer any RSS feeds or other web services.

Why don't you subscribe to their email service instead? It'll be way easier.

Error on:user defined type not defined??- vb6 [modified]

campbells17-Oct-06 16:08

17-Oct-06 16:08

I was trying to link my vb6 to the MYSQL but i got this
Error:"user defined type not defined"??

<big>Dim dbb As Database</big> <-- Error<br />
       Dim rs As Recordset<br />
       Dim strConnect As String<br />
       Dim strSQL As String<br />
       Dim strResult As String<br />
<br />
       'Set connect string.<br />
       strConnect = "ODBC;DSN=DSN_SP_TEST;"<br />
<br />
       'Open the database<br />
       Set dbb = DBEngine.Workspaces(0).OpenDatabase("", False, False, _<br />
                                                    strConnect) <br />
  'Create the stored procedure. It really does not do much.<br />
       'It simply sets the variables and returns<br />
       strSQL = "/****** Object:  Stored Procedure dbo.sp_Vendor */"<br />
       strSQL = strSQL & vbCrLf & "CREATE PROCEDURE storebo.sp_vendor"<br />
       strSQL = strSQL & vbCrLf & "/* Declare Parameters */"<br />
   <br />
strSQL = strSQL & vbCrLf & "@param1 varchar(20) ,@param2 varchar(20) ,"<br />
strSQL = strSQL & vbCrLf & "@param3 smalldatetime ,@param4 smalldatetime"<br />
strSQL = strSQL & vbCrLf & "as"<br />
strSQL = strSQL & vbCrLf & "begin"<br />
strSQL = strSQL & vbCrLf & "SELECT   dep.[name],dep.deptcode,dep.deptdesc,dep.depttotal,    (dep.DeptTotal /     (SELECT  sum(dep.depttotal)"<br />
strSQL = strSQL & vbCrLf & "FROM    (SELECT v.[name],d.deptcode,d.deptdesc, SUM(ti.totalsales) AS DeptTotal"<br />
strSQL = strSQL & vbCrLf & "FROM     item i ,vendor v,tot_item ti  INNER JOIN   dept d  ON (ti.deptcode=d.deptcode) where ti.itemcode=i.itemcode and v.vendorid=i.vendorid and v.[name]>=@param1 and v.[name]<=@param2 and ti.bizdate>=@param3 and ti.bizdate<=@param4"<br />
strSQL = strSQL & vbCrLf & "group by v.[name],d.deptcode,d.deptdesc) AS dep )) * 100 AS PercentOfSales"<br />
strSQL = strSQL & vbCrLf & "FROM    (SELECT v.[name],d.deptcode,d.deptdesc, SUM(ti.totalsales) AS DeptTotal"<br />
strSQL = strSQL & vbCrLf & "FROM     item i ,vendor v,tot_item ti  INNER JOIN   dept d  ON (ti.deptcode=d.deptcode) where ti.itemcode=i.itemcode and v.vendorid=i.vendorid and v.[name]>=@param1 and v.[name]<=@param2 and ti.bizdate>=@param3 and ti.bizdate<=@param4"<br />
strSQL = strSQL & vbCrLf & "group by v.[name],d.deptcode,d.deptdesc) AS dep"<br />
strSQL = strSQL & vbCrLf & "ORDER BY     dep.[name] ASC"<br />
End<br />
       MsgBox strSQL<br />
       db.Execute strSQL, dbSQLPassThrough<br />

-- modified at 22:16 Tuesday 17th October, 2006

Christian Graus17-Oct-06 16:09

17-Oct-06 16:09

I don't see a UDT in the code you have posted ? It looks to me like you almost got to the part that matters and stopped.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

campbells17-Oct-06 16:15

17-Oct-06 16:15

wats UDT??

Dave Kreskowiak17-Oct-06 17:48

Dave Kreskowiak

17-Oct-06 17:48

User Defined Type.

A custom type that you create, specifying it's structure, members, and member types.

Dave Kreskowiak
Microsoft MVP - Visual Basic

campbells17-Oct-06 17:48

17-Oct-06 17:48

what should i need to create for database?

how to click a button then mySQL will create the procedure? [urgent]

Dave Kreskowiak17-Oct-06 17:56

Dave Kreskowiak

17-Oct-06 17:56

The compiler is bitching because the type "Database" doesn't exist, or at least you haven't supplied enough information to tell the compiler where to find the Database type definition. Is this an ADODB Database object? If so, you'll probably have to do something like this:

Dim dbb As ADODB.Database

DO NOT COPY AND PASTE THIS CODE INTO YOUR APP!! I have no idea if it's going to work and can't even tell you if the Database object you're looking for is even in the ADODB namespace.

Dave Kreskowiak
Microsoft MVP - Visual Basic

campbells17-Oct-06 15:44