Hi all, I can able to fetch a single data from Sql and display it in the Excel sheet using Macro, this is the code. I am getting in the Text Box: sno = TextBox1.Text When i am clicking the Ok button: Query = "Select sname,scity from smaster where snum='" & sno & "'" Set QueryRs = oConn.Execute(Query) Sheet1.Cells(1, 1) = QueryRs("sname") Sheet.Cells(1, 2) = QueryRs("scity") Result: Name, city displayed in the Excel sheet1 Now my problem is how to fetch multiple data and display (like how to use loop in it) waiting for timely help

Tech_spidy

Hi all, I can able to fetch a single data from Sql and display it in the Excel sheet using Macro, this is the code. I am getting in the Text Box: sno = TextBox1.Text When i am clicking the Ok button: Query = "Select sname,scity from smaster where snum='" & sno & "'" Set QueryRs = oConn.Execute(Query) Sheet1.Cells(1, 1) = QueryRs("sname") Sheet.Cells(1, 2) = QueryRs("scity") Result: Name, city displayed in the Excel sheet1 Now my problem is how to fetch multiple data and display (like how to use loop in it) waiting for timely help

Tech_spidy

Hi, I am looking for Testing Tools Tutorial. Can anyone help me to find Load Runner or Win runner tutorials..

Tech_spidy

You can try Testing Tools Like Load Runner, Win Runner with proper study. even i am looking some testing related tutorials. if you got to know something help me out also.

Tech_spidy

I am searching for Load Runner , Win Runner Tutorials. can anyone direct me to get this on the web..

Tech_spidy

This is what i am already doing. I need a solution like by clicking a single button it has to export the data by executing the query in db.

Tech_spidy

hi, i need a help in an automation of data fetch from db to excel. I am having 2 tables in sql server db. at present i will type hundreds of number in excel sheet then i will import that to sql server as a table then executing that table and the primary table using some sql statement i used to fetch the required information. now the problem is when we are doing it for multiple records its too difficult to repeat the process repeatedly.so i want to automate this process. for example: primary table: slno eno,ename, eaddress, ecity exporting data through excel is eno comparing this eno in excel with the primary table i can fetch the remining details to the specified set of eno. how to automate if anyone have idea please share it. so that i can begin my process as soon as possible.

Tech_spidy

hi, i am beginner developer in .net. suggest me some asp.net tutorials and .net tutorials where i can learn and understand concepts easily. regards

Tech_spidy

mail room means like we have lots of courier services providing solution through software. instead we can create our own application for incoming outgoing letters and POD updations some other added features also . regards

Tech_spidy

I am beginner for .net technology. i am trying to develop an application in Mail Room concept. to begin that i am looking for the structure of a mail room, what kind of techniques and flows we can use to create a strong and secured mailroom. expecting lots of help to make my first project a successful one. any king of help is ok. from base level to high level. regards..

Tech_spidy

I have my DB in SQL Server 2000 with the applications developed in ASP, VB. Now i am looking for mirroring my DB because i am going to change the db strucute with similar modifications. i m going to recreate older ASP, vb applications into C#.net & ASP.net if any one have the idea.. kindly help in this issue.. thanks in advance.

Tech_spidy

hi all, How to use Rollback in sql server. can anyone help me in it.:(

Tech_spidy

thanks for ur response krish. but i m using sql server for this wat navaneeth suggested is working exactly . regards:)

Tech_spidy

Thank you so much navaneeth.. wht u suggested is exactly working.. regards:)

Tech_spidy

you have to store the image in binary format. so that u can fetch from database

Tech_spidy

thanks for ur hint Sam Heller

Tech_spidy

hi Sam Heller, auto complete textbox in the sense, in mobile when we are typing 'A' it will start showing the names coming under 'A',like that to do in ASP. may be set of data we can store and retrive from db :|

Tech_spidy

hi, how to create an auto complete text in ASP. if possible, provide me sample code. regards :|

Tech_spidy

ok.. i will try tht. thanks for ur response. regards:)

Tech_spidy

hi Navaneeth, thanks for ur immediate response.. see while displaying some motivational quotes like, it wouldn't look good.. In official sites we can't go display like this. thanks for ur temprory solution. if you/anyone know the exact solution please reply.. regards,:(

Tech_spidy