Hi Everybody, I am using web services first time. Only for my understanding I have used very simple functionality: Addition of two numbers and population of a dropdown list. My questions are 1- when I used "Namespace" It raised an error that 'error BC30002: Type 'First Web Service' is not defined.' later I commented out namespace it is working fine. any tip how to sortout this error. 2- Basically I play all the time with database (binding and manipulating data with controls )and desperate to use WCF and web services. Is this any better/helpful to use in the same way I have use in the FirstWebService. why I am asking this because I can perform the same functionality using simple classes. I dont see any difference or I am confusing myself. any help will be appreciated. FirstWebService code: Imports System.Web Imports System.Web.Services Imports System.Web.Services.Protocols Imports Microsoft.VisualBasic Imports System.Data Imports System.Data.SqlClient Imports App_Code.DB Imports App_Code.Web 'Namespace App_Code.Web ' To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. '<System.Web.Script.Services.ScriptService()> _ <WebService(Namespace:="http://tempuri.org/")> _ <WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _ <Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _ Public Class FirstWebService Inherits System.Web.Services.WebService Dim dbeng As DBEngine Dim lEBStruct As EBStruct Public Sub New() dbeng = New DBEngine dbeng.YourDBName = ConnectionSource.DBName.PupilVoice End Sub Private _YGid As Integer Private _YGDesc As String Public Property YGId() As Integer Get Return _YGid End Get Set(ByVal value As Integer) _YGid = value End Set End Property Public Property YGDesc() As String Get Return _YGDesc End Get Set(ByVal value As String) _YGDesc = value End Set End Property <WebMethod()> _ Public Function HelloWorld() As String Return "Hello Mathematician" End Function <WebMethod()> _ Public Function AddTwoIntegers(ByVal dig1 As Integer, ByVal dig2 As Integer) As String Return Convert.ToString("<br/>you entered teri tou two digits: " & dig1 & " and " & dig2 & ". Sum of two digits is " & dig1 + d

Hi Mycroft Holmes, Thanks for your reply. It was my mistake I didnot normaliz data but I did on purpose but it did not work. Now I have normalized it and I'm trying to figure out how to display it through pivot. But still need your help. Any suggestion or hint how to do that would be much appreciated. thanks TuitionLevel tuitionlevelid tuitionleveldesc 1 1a 2 1b 3 1c 4 1 Student UPN StudentName A1234 Alan A1233 Sam A1232 Carol Subject Subjectid SubjectDesc 1 E 2 M UPN subjid pretui_id posttui_id A1234 1 1 2 A1234 2 3 4 A1233 1 7 3 A1233 2 1 4 A1232 1 5 6 A1232 2 6 6 output: UPN StudentName PreMaths postMaths preEng PostEng A1234 Alan 1a 1b 1c 1 Any help would be much appreciated. thanks

hi everyone, I have 2 tables like StudentDetail and TuitionLevel StudentDetail id Name Surname StudentUniqueId Subject 1 sam smith G1234U890 E 2 sam smith G1234U890 M 3 Paul Day R4321B009 E E as English M as Maths TuitionLevel id PreLevel PostLevel 1 3 4 2 5 4 3 2 2 I want to display result like this Name MathsPre MathsPost EngPre EngPost sam 3 4 5 4 Paul 2 2 I have done in the following way but this is not what i need. SELECT [Name],Surname,StudentUniqueId, Case when motot.Subject = 'E' Then 'English' Else 'Maths' end AS Subject, Pre, IsNull(Post,'') as Post FROM StudentDetail sd INNER JOIN TuitionLevel TL on TL.id =sd.id ORDER BY StudentUniqueId any help would be much appreciated. thanks in adv.

modified on Wednesday, April 7, 2010 11:16 AM

Hi everOne I have used switch case statment before but not sure the way I want to use it is implementable or not. If it is then please could you convert the following code into switch Case statement. create proc Details_GetBYID ( @Id int, @TypeId nvarchar(max) ) AS IF @TypeId = 'P1' BEGIN SELECT motot.Completed,motot.Hours,motot.Subject FROM MasterT as motot INNER JOIN PSALevel as psal on psal.Id = motot.Id WHERE motot.Id = @Id END ELSE IF @TypeId = 'P2' BEGIN SELECT motot.Completed,motot.Hours,motot.Subject FROM MasterT as motot INNER JOIN PSALevel as psal on psal.Id = motot.Id WHERE motot.Id = @Id END ELSE BEGIN SELECT motot.Completed,motot.Hours,motot.Subject FROM MasterT as motot INNER JOIN PSALevel as psal on psal.Id = motot.Id WHERE motot.Id = @Id END any help would be appriciated. thanks in adv. regards learner

thanks danish I have done in the same way as you told. kind regards learner

thanks for your response danish, but i think i couldn't explain my problem properly. now scenario is Off course form is lenghty and everything is working absolutely fine there is no problem with insertion, updation or deletion. Now the problem is sometimes users take more time than normal that's why session got expire, my boss asked me to save data after 10 mins either end user submit or not. even all blank fields. system can save form even there is not any field filled in. Now my problem is that how I could store data after every 10 mins automatically. any suggestion would be appreciated. kind regards, learner

Hi guys, I have developed a lengthy form, some time end user takes more than an hour to fill in and submit that form to database. All code is inside updatepanel and script manager control this is requirement. so end user is either filling in the form or sitting idle it doesn't make any difference. I dont want to increase session timeout. Is there anyway to fire button's submit event after 10 mins to enable the form to submit data automatically if user doesn't click the submit button. any help would be really appreciated. thanks kind regards, learner

hi guys, I have 13 classes like clsSales, clsOrder, clsInvoice, clsEmail, clsTimesheet, etc..... every class has obviously different fields and properties. But there is one class like Sales which have all fields and properties which other classes have. Now there are 2 options first one I should create all classes seperately like clsSales saleid, orderid, orderdate, invoiceid, invoicedate, emailid, emaildate, timesheetid, timesheetdate. clsOrder orderid, orderdate clsInvoice invoiceid, invoicedate clsEmail emailid, emaildate and the second option is I should inherit all classes from clsSales class. My question is if I Implement 2nd option will this improve or make worse web page performance. thanks kind regards, learner

Hi everybody, I have developed a page in asp.net (using vb) which is accessible over internet (public domain .com) working fine. This page facilitate end users to save, retrieve, and update existing information, and all information is saved over server database. Now my boss wants to access these information on Intranet (local site) but there is a "FIRE WALL" between Intranet and Internet. In the beginning I assumed that I could solve this issue through replication but later I have been told due to "FIRE WALL" I can't replicate data from Internet to Intranet. MY question is how can I save and retrieve data in local and global database at the same time. Or replication is possible in this situation if it is possible, Or there are any other ways like serialization etc.. Please could you tell me how I can solve this issue, any link or any suggestion would be much appreciated. I'm really sorry if this is not the right forum to ask this question. regards learner

thanks a lot

Hi everybody, I'm getting this error. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Contract_ContractType". The conflict occurred in database "ContractDB", table "dbo.ContractType", column 'ContractTypeId'. The statement has been terminated. I understand that this is because I'm not sending the exact ContracatTypeId to table. I'm doing this deliberately because I want to store Null as well for some reason. Please could any body tell me how can I remove/drop this constraint from database (please bare in mind I have no table diagram). any help will be much appreciated.

Hi everybody, I have a CheckboxList on my web form and I have to display which check box have been ticked into List. the following code is working absolutely fine on IE 8 but not working on IE 6. I tried to change 'if' condition but failed to run same code on IE 6, main problem occurs in 'If' condition. thanks for any suggestion in adv. function readListControl() { var tableBody = document.getElementById('<%=cbsrc.clientId%>;').childNodes[0]; for (var i = 0; i < tableBody.childNodes.length; i++) { var currentTd = tableBody.childNodes[i].childNodes[0]; var listControl = currentTd.childNodes[0]; if (listControl.checked == true) alert('#' + i + ': is checked'); } } regards learner

Hi everybody, please any one could tell me how I can use transaction for multiple records. e.g. if I have a multiple check boxes selection and I want to save them all in database through transaction. any Idea would be appreciated. thanks regards learner

hi everybody, I have developed a simple web application in asp.net(sql 2005, and asp.net built-in role base security). there are some forms in this application where users enter their information, sql manipulate the information and send them back via email. it is working fine on laptop. I'm wondering if I want to deploy it on Intranet or any local network what steps I have to follow. if you guys send me link or any kind of related information that would be much appreciated. thanks in adv. regards learner

thanks holmes for your kind answer my Problem; the following code is working perfectly except date. every thing is working perfectly pleas let me know how to add Date into table through following query, and dont worry about other variables these are working perfectly because i have changed them into varchar like this SELECT @str_Session_Id=CONVERT(nvarchar(10), CONVERT(int, @SessionId)) but i dont want to add date like varchar because i have to compare date with other dates therefore i dont want to convert into varchar. select @date =(select DATEADD(dd, 1, GETDATE())) Begin set @txtSql = case when (@Std_Count < 3) then 'insert into ProjectRequests values('+ @str_stu_Id+','+ @str_Priority_Id +','+ @str_Project_Id +' , '+ @str_Session_Id +', '+ @date +' , NULL)' Msg 241, Level 16, State 1, Procedure FUALLY_QUALIFIED_STUDENT_BULK, Line 48 Conversion failed when converting datetime from character string. any help would be appreciated.

hi everybody i have two tables table1 with column name SubmissionDate nvarchar(11) table2 with column name submissiondate2 (datetime) and i insert data in table1 like 17/05/2009 but still in nvarchar format cos this is my requirement (i mean nvarchar) my question is i want to insert same date from table1's column to table2's column but dont know how to convert datatype nvarchar to datetime. when i try to cast i got this error msg Arithmetic overflow error converting expression to data type datetime. any help would be really appricated

hi everybody! I want to create more than one user account at a time using CreateUserWizard. And only Adminstrator would be allowed to create any new account. But the CreateUserWizard has got property that it let new user login automatically, that's why administrator have to log in every time. please any one could tell me how can I create more than one user account using wizard

hi everybody I implemented Role base security in asp.net on my project. its web.sitemap and tree view working absolutely fine. but when I used below code copied from microsoft site. sitemap defaultprovider="XmlSiteMapProvider" enabled="true" providers add name="XmlSiteMapProvider" description="Default SiteMap provider." type="System.Web.XmlSiteMapProvider " siteMapFile="Web.sitemap" securityTrimmingEnabled="true" /> add providers sitemap in web.cofig file tree view disappears. please advise how can i make it working properly. thanks in adv for any kind help. regards learner

hi everybody here are the steps of explaining my question. master page contentplaceholder Table with 2 rows 2 cols in first row first colum i have dragged Tree view. On clicking tree view's sub link different pages come up with different size in contentplace holder. if page size is samll than Tree view doesnt move down. if page size increases tree view control moves into the middle. my question is that how can i make it not to change its position whatsoever size of the other page is. help would be appreciated. regards learner

hi everybody I have a textbox in Datagrid > and i want to get text from this textbox foreach(DataGridItem xItem in DGUpdateStudents.Items) { clsobj.StudentId = DGUpdateStudents.DataKeyField[xItem.ItemIndex]; clsobj.ForeName=(String) ((TextBox)xItem.FindControl("TxtForeName")).Text; } no error but doesnot return text from textbox like if enter name like John it returns me "" empty strings. thanks in adv for help.