Hi There! Just was wondering as if there is some way of blocking the offline browsing softwares to download my entire web site. Like Web Site Ripper and same softwars, which have the capability to download the complete web site .. Is there any HTML code for that or VB/java Scripting stuff for that or something else. thanks regards,

Hi Friends! Can someone please guide me towards the mark sensor equipments available in the market! My Organization wants to make a system for the automatic checking or answer scripts of students MCQ based papers with the help os some mark sensor! What mark sensor can be best and will they give their own software with the maching? or in general, how it can all be done?? thank you

I was just trying to get all the data at front end in dataset! Thats why populated it with all the tables!!! So, I have to populate my dataset with a single table if i intend to use SqlCommandBuilder! I was trying to use it too but even this was not working, probrably becasue of multiple tables in dataset !!!.. Thanks for the advice sir!

I am having problem with dataset update! I am using a DataAcesTier to access data and update the data and presentation tier is used to do all the manipulation! Presentation Tier uses DataAcessTier to retrieve the data but when i try to update the database with dataset , NOTING HAPPENS! NO ERROR but NO UPDATES too.. Here is how it goes!!! I have a class with the name AccessData in my DataAccessTier and it have somehow this sort of code public sdaMajorDataAdapter as new SqlDataAdapter public strAllDBTables(50) as string 'strAllDBTables Array is inialized with table names with a sub routine Public Function CreateDataset() As DataSet Dim dsMajorDataSet As New DataSet OpenDbConnection() ' some code for dbcommand and dbconnection variables etc 'For loop used to loop through the table names For iCounter = 0 to strAllDBTables.length(0) - 1 sdaMajorDataAdapter.Fill(dsMajorDataSet, strAllDBTables(iCounter)) Next 'I have populated the dataset with all the DB tables supposedly CloseDBConnection() 'this DS is returned to the class from where its accessed return dsMajorDataSet End Function ====== Similary in the same class i have a Function for DB update Public Sub UpdateDataSet(ByVal updateDS As DataSet, ByVal strTableName As String) OpenDbConnection() dim dsUpdate as new dataset 'dbCommand.Connection = dbConnection 'dbCommand.CommandText = "Select * from " & strTableName 'sdaUpdate.SelectCommand = dbCommand 'sdaMajorDataAdapter.Fill(dsUpdate, strTableName) 'I have tried to use dataadapter to fill a new dataset and then try to update .no gain sdaMajorDataAdapter.Update(updateDS, strTableName) 'Which DataAdapter is to be used here ... or do i need to add update queries 'with adapter?, if YES , how to add it? ' There is no error here but NO UPDATES too? CloseDBConnection() End Sub ======== 'i am accessing these functions in Presentation Tier Class with the name AdminControlPanel Class 'here i have a variable dim dsControlPanel as new dataset dim dsRead as new AccessData ' an object of AccessData Class dsControlPanel = dsRead.CreateDataSet() ' than all the manipulation is done here and after that i return the DS to data access class for updation like this dsRead.UpdateDataSet(dsControlPanel, "Name of the table to be updated") 'No Error but nothing happens? i guess i am doing something wrong as to which dataAdapter is to be

Hi, I am having a problem with updating my database with dataset changes! I have separte DataAcessTier where i create all the dataset stuff using some CreateDataSet and bring it to presentationTier, that works fine, but when i try to update the changes, i again go back to dataccess tier for using UpdateDataSet Function, and there problem arises! I dunno which DataAdapter is to be used for DataSet Update Now, There is no error at all but the dataadaper's Fill method is not updating the stuff? What to DO???

Thank You Eliz! One thing more, also if i want to get the record of a single student, can i used the where clause after joins like where s.stuid = '2222' ??? thanks!!!

Hello! I am trying to retirve data from almost five tables simultaneously, but having problems in use of a single query!!! Here is the sample of thouse five tables students: stuid, classID, sectionID, termID, sessionID, stuName, other fields Classes: classID, className Sections: sectionID, sectionName Terms: termID, termName Sessions: sessionID, sessionName NOw if i want to extract data with a single query in somewhat this form stuName, className, sectionName, termName, sessionName Can someone help me in this, as to how the best query can be formed? thank you!! -- modified at 1:28 Monday 30th July, 2007

Yeah thanks for the good advice and i have already started working with JOINs somehow .. But still are there any ways to filter data from two or more tables of a dataset using some criteria? Also, when i have populated my datagrid with three or more tables how can i update data in all three if some changes occur in datagrid? thanks

Hi, I wonder if its possible to query the tables in a dataset same as we do with the database tables! I have loaded my dataset with almost 10 tables and now want to extract data from four of those tables to display everything in a datagrid! But i couldn't find a way as how easily it can be done? In other words i was just trying to avoid the SQL JOINS ...:) so i opted for dataset manipulations.. any help in this regard will be appreciated!!! Thanks

Yeah! thank you! Its nice to hear that you are working with a same kind of system!... Good to be in contact haa'n mine cell is +92-321-4169324 Tahir

Sir! I am trying to develop a computer based Result Tabulation System for the school I work in. I have designed the tables for Teachers, Classes, Students etc. but am stuck with the design of tables for exam system itself. Can you please guide me as to how better it could be done? The examination system of school is as follows. 1. There are Two Terms in an academic year 2. There are two Bimontlhy's(BM) in each term 3. There are Four Class works(cw), One Oral Project(OP) and One Assessment Test(AT) in one Bimonthly 4. The aggregate of all the class works and OP and ATs make one Bimonlthly Its Like cw1+cw2+cw3+cw4+OP+AT = BiMonthly(BM) 5. The aggregate of two Bi Monthly and Term Exams make A Term Assements and BM1+BM2+First Term Exam = First Term I am wondering as how to make normalized tables and avoid any anomalies. Should I make separate tables for Classworks like tblClasswork: cwID, cwname, cwshort 1 , Classwork1, cw1 and same for AT and OPs. and them make a table for Bimonthly to Put CWID in it ... and then for term? I have also tried to create a table named tblExamData with fields: stuID, teacherID, subjectID, sessionID, cwID, opID, atID, bmID, termID but it won't serve the purpose coz it will store the information about CWs, Ops and Ats not the obtained marks of the students. I have also tried to change it like tblExamData: stuID, teacherID, subjectID, sessionID, cwID, cwMarks, opId, opMarks, atID, atMarks, bmID, bmMarks, termID, termMarks. but then there may be some update, delete anomalies.? what to do with it? I apologise for this long write up but i am writing in a hope to get a better guideline. thank you regards,

Hi friends.. again with a short question.. here i am ... Well I placed a tool bat at my MDI form... but as soon as i place a background image at that main MDI form.. that also starts behaving as a background image to that toolbar too... I dunno why is soo.. it went ok a few days earlier.. but now i deleted the tool bar.. placed it again.. still the same problem..and this problem occurs when i put buttons on the toolbar...??? how is it happening...? how to prevent that image to be displayed on toolbar...??? tahir

thank you sir with this help.. but do i always need to use Select Case for dealing with Buttons of ToolBar.. can you please send me a lil code snipper for this.. thank you

Dear friends, i wanted to know that how can i write code behind toolbar panels.. when eevr i double click on toolbar it takes me to buttonclick event of toolbar.. but how can i code behind the buttons i placed upon toolbar?

Friends, i want to ask that is there a way to auto fix columns in a data grid, I mean if i have to display just two columns in data grid and datagrid size is larger than two columns width.. they just r displayed on left and rest of the grid remain empty.. how can i FILL data grid with only two coloumns.. ? Should i have to chage the columns width manually.. but what if there are three columns sometimes to display? looking to here from u soon

Hello Sir, I have been assigned a task to auto mate a school system. i.e. Timetabling issues, Teacher Replacemts, Employee Attendances(HR), Exam control and Student Records... although .. i have analysed almost everything.. database tables are finalized as well... but coz of being untouch with all this development issue since a year.. i am just strugling as to how and where to start design and development of the software....? if anyone having idea about this kind of software? please help me ... or i would be grateful if anyone can come up and exchange emails with me regarding this project... i mean, the one, who can help me step by step..as how to start i'll be using VB.NET and SQL Server... thanks .. All Praises are for the Lord of the universe... Regards, Tahir

Yes! I am trying to priortize the functionalities... looking for Teacher and Student Records Managent at first hand... but still kind of confused.. :) any more suggestions please? thank you