Do you have any suggestion regarding this!!!:confused:

Thanks for ur reply! Actually my code is! Dim objWebClient As New WebClient Dim aRequestedHTML() As Byte aRequestedHTML = objWebClient.DownloadData(strURL) Dim objUTF8 As New UTF8Encoding Dim strRequestedHTML As String strRequestedHTML = objUTF8.GetString(aRequestedHTML) GETHTMLStream1 = strRequestedHTML The request(URL) is sent to the server which returns the HTML. Now Problem is this request doesn't able to retrieve session values. Session values are being reterieved on other pages.

I had posted this question couple of days ago but still not able to get the answer. I want to Get HTML by Executing URL on Server. I have got the HTML but problem is this Current Session Values are not being sent. I can't use query string I have to use current sessoin values!!! Any Help will be highly appricated!!!

Sorry for confussion!!! let me explain it to u! Let suppose i have URL = "http://www.some.com" Now in it i have a Grid which depends on some session variables. Now when i use Response.Redirect(URL) the grid reterives the data on the basis of session variables. but when i use HTTPWebRequest to get the HTML which is generated for that URL grid doesn't reterives session values. I have to get the execute the URL on the Server and Get the Generated HTML. Hope u will got it!!!

I have removed this but still session values are not being used by HTTPWebRequest :(.

Please look into this code is there any mistake in it? i am not being able to get session values? Dim _HttpWebRequest As HttpWebRequest = HttpWebRequest.Create(strURL) _HttpWebRequest.CookieContainer = New CookieContainer Dim _HttpWebResponse As HttpWebResponse _HttpWebResponse = _HttpWebRequest.GetResponse Dim _Cookie As Cookie For Each _Cookie In _HttpWebResponse.Cookies _HttpWebRequest.CookieContainer.Add(_Cookie) Next Dim _StreamReader As StreamReader ' Process the URL and Get HTML _StreamReader = New StreamReader(_HttpWebResponse.GetResponseStream) GetHTMLStream = _StreamReader.ReadToEnd

I am using WebRequest and here is the code: Dim _WebReq As WebRequest Dim _WebResp As WebResponse Dim _StreamReader As StreamReader Dim strHTML As String _WebReq = _WebReq.Create(strURL) _WebResp = _WebReq.GetResponse _StreamReader = New StreamReader(_WebResp.GetResponseStream) GetHTMLStream = _StreamReader.ReadToEnd Thanks

I am using WebRequest to Get the HTML of specific URL(of same application) which works fine but not the session variables are not being sent. If any one has used this please let me know?:zzz:

You will have declare an event and raise it in the event which you want to capture e.g. if you have a button in your user control then you capture its click event as: 'Declare it in Declaration Section Public Event MyButtonClicked() 'In the click event of button you will have to write this: Private Sub cmdTest_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdTest.Click RaiseEvent MyButtonClicked() End Sub MyButtonClicked() event will be available in aspx form and you can handle it. hope you will get it if you face any problem let me know. take care Javed

Thanks for your suggestion, actually as i mentioned i am using VB 6.0 as front end and mySQL 4.1 as back end. i want there should be an option for taking the backup of complete database from VB form: user just tell the path where he wants to take backup of database. any suggestions? Thanks and Regards, Javed

thanks for ur response!!! can u please tell me how it can be used in VB 6.0. I have treid but its giving error?

Hello, Do any body have idea of getting complete database backup of mySQL database except this? SELECT * INTO OUTFILE Path FROM Table I want just there should be only one backup file of All tables and how to restore that. I am using: mySQL 4.1 and VB 6.0. Thanks

you put dummy data in table then check the query will work fine...

you can simply use: select * from table where col1 IN('val1' , 'val2') and col2 IN ('val3' , 'val4') it will work... Javed

Yes, but if the table will already exists you will get an error. you can create table as: Dim cn as new Connection cn.ConnectionString ="Connectionstring" cn.open cn.Execute("CREATE TABLE tNewTable( Field1 Int NOT NULL , Field2 Int NOT NULL )") Regards, Javed -- modified at 0:37 Monday 27th February, 2006

Use Call Shell (Path of the Software Exe) Regards, Javed

'This code can b used to store image in database using VB 6.0 Private Sub StoreImage(sPath As String) Dim bytBLOB() As Byte Dim intNum As Integer Dim rs as new RecordSet If (Trim(sPath) <> "") Then rs.Open "Select * From tTable1",cn,,adOpenDynamic,adLockOptimistic 'Start store pic intNum = FreeFile Open sPath For Binary As #intNum ReDim bytBLOB(FileLen(Trim(sPath))) Get #intNum, , bytBLOB Close #1 'End store pic rs.AddNew rs("Img").AppendChunk bytBLOB 'Other Fields...." rs.Update End If End Sub Regards, Javed

Hello, u will have to make a setup project u can add setup project as: - Add New Project - Select Project type as "Setup and Deployment Wizard" - Select Setup Wizard From Template - A wizard will ask u some questions just complete it - Now u have to add merge modules for crystal report which u can add as? * Right Click on the Setup Project * Add --> Merge Modules * Select Following ** Crystal_Database_Access2003.msm ** Crystal_Database_Access2003_enu.msm ** Crystal_regwiz2003.msm ** VC_User_CRT71_RTL_X86_---.msm ** VC_User_STL71_RTL_X86_---.msm - Build the solution - A setup will be created in Setup Project Folders's -->Debug - Copy it and run it on client machine Regards Javed :)

Hello, I want to place my application on server and place short cut on client to run the application. :wtf: Thanks Javed :omg::omg:

hmmm the control which you want to edit in inherited form make its Modifier Property Value = "Public" then you will be abe to edit it. Regards, Javed :)