Hi, I am bit confusing about output of fallowing variable 'a' which produce '-1' as result. sbyte a =unchecked((sbyte)255); I have not cleared yet why this store -1 plz clarify me.

no knowledge in .net

hi Gaurav, I have spent more time on Google but i cant not find appropriate solution. plz understand this problem . thanks

no knowledge in .net

hi, I want to create Bcc Mail Add In for outlook in visual studio 2008. but i have no idea about it. plz guide me so that i can create in visual studio 2008.

no knowledge in .net

still no results, on removing space from the the value. does backslash affect my query or the starting number that is prefix in my query?

no knowledge in .net

hi, yes JHizzle table has more than one thousand records matching to the value. and i don't want to use like keyword

no knowledge in .net

hi, when i am running this query from sql server query analyzer it won't return a single record from table.while table has number of records matching this field. select * from csvdata where [source]='529042010\All Data 4cr\0.66cr_calicut_1401 ' plz suggest me solution. thanks in advance.

no knowledge in .net

Hi michaelschmitt, thanks for replying. I am still getting same error.i have define datatype of image in my table.while opening word file ,i recieve error that word can not start the converter mswrd632. plz provide me solution. thanks in advance.

no knowledge in .net

Hi, I have trouble to write binary data stored in sql server databse to word document.when i run the program it write garbage value to document. how can i do it plz help My code is given below byte[] MyData = new byte[0]; da.Fill(ds, "myinages"); DataRow myRow; myRow = ds.Tables["myinages"].Rows[0]; MyData = (byte[])myRow["imgField"]; int ArraySize = new int(); ArraySize = MyData.GetUpperBound(0); string fileName=@"C:\Documents and Settings\Anurag_2\Desktop\anurag.doc"; Response.AppendHeader("Content-Type", "application/msword"); Response.AppendHeader("Content-disposition", "attachment; filename=" + fileName); Response.BinaryWrite(MyData); Response.Flush();

no knowledge in .net

hi , I am using Intelligencia.UrlRewriter.dll to rewrite my page url. it work very well on my local computer but when i upload this page on my web server url rewrite not work it gave an error. The page cannot be found HTTP Error 404 - File or directory not found. Internet Information Services (IIS) plz suggest me how can i correct this problem. thanks in advance.

no knowledge in .net

i am using jquery in asp.net page . jquery is working fine in page but when i fire a server side event on image button click after clicking on any jquery event page produce error like The state information is invalid for this page and might be corrupted. please help me thanks in advance

no knowledge in .net

but i don't know how to enclose string parameter in execute procedure

no knowledge in .net

set nocount on declare @ResultSql varchar(8000) declare @anurag varchar(20) set @anurag='anurag' Set @ResultSql='SELECT distinct a.RegID,a.companyname, b.LocalityName FROM Registration AS a INNER JOIN Locality AS b ON a.LocalityID = b.LocalityID inner join pincode as p on a.pincodeid=p.pincodeid WHERE(a.CityID =1) and a.companyname='+@anurag Create Table #Tbl_Myphonedata ( Id numeric IDENTITY PRIMARY KEY, regid numeric, companyname varchar(30), localityname varchar(30) ) --Fill the temp table with the reminders set @ResultSql = 'select regid,companyname,localityname from( ' + @ResultSql + ' ) OO' Insert Into #Tbl_Myphonedata ( regid,companyname,localityname ) exec ( @ResultSql ) select * from #Tbl_Myphonedata drop table #Tbl_Myphonedata in above procedure parameter @anurag is string type parameter when i execute exec(@ResultSql) @anurag trate as colunm name but it is a simple parameter please help me :(

no knowledge in .net

if(rd[0].checked==true) You can not use object ID at this way. You have to get an object of control. for example if(document.getElementById('rd').checked==true) u r write but the check()event not work in mozilla firefox explorer i wont to know the reason why is it noy work ??

no knowledge in .net

if(rd[0].checked==true) What is "rd" in above code? I think "rd" is not an object.I must be "red" "rd" is radio button id

no knowledge in .net

in this function i validate textbox value and radio button on button click event it work in internet explorer very well. but not work in mozilla firefox what is the reason?? function check(cid) { var red=document.getElementById('rd'); var val="PH"; if(rd[0].checked==true) { val="KH"; } var box1 = document.getElementById('txtsearch').value; box1 = box1.replace(/^\s*|\s*$/g,''); var box2 = document.getElementById('rd'); if(box2.checked==true) { if(box1=="") { alert("Please Enter a Keyword, Business or Category"); return false; } else { window.parent.location.href="../keywordsearch.aspx?kq="+document.getElementById('txtsearch').value+"&stype="+val+"&city="+cid; } } else { if(box1.length<6 || box1.length>11 ) { alert("Please Enter Phone Number(min:6 digit and max:10) "); return false; } else { if(IsNumeric(box1)) window.parent.location.href="../keywordsearch.aspx?kq="+document.getElementById('txtsearch').value+"&stype="+val+"&city="+cid; else { alert("Please Enter Only numeric Number "); return false; } } } } html code /////////////////////////

Search

CREATE PROCEDURE dbo.InsertQueryoperation ( @Award_num int output, @patient_name varchar(40), @Operation_date smalldatetime, @Duration smalldatetime, @Surgean_name varchar(40), @Type_of_operation varchar(20), @Anaesthiologist_name varchar(40), @Type_of_anaesthesia varchar(20), @ID_num int ) AS SET NOCOUNT OFF INSERT INTO Operation_details (Award_num, patient_name, Operation_date, Duration, Surgean_name, Type_of_operation, Anaesthiologist_name, Type_of_anaesthesia, ID_num) VALUES (@Award_num,@patient_name,@Operation_date,@Duration,@Surgean_name,@Type_of_operation,@Anaesthiologist_name,@Type_of_anaesthesia,@ID_num); SELECT Operation_ID, Award_num, patient_name, Operation_date, Duration, Surgean_name, Type_of_operation, Anaesthiologist_name, Type_of_anaesthesia, surgean_ID, Anaesthiologist_ID, ID_num FROM Operation_details WHERE (Operation_ID = SCOPE_IDENTITY()) i hv change ur parameter @award_num int output pest this code to ur store procedure. try this

no knowledge in .net

r u define @Award_num int output in ur store procedure if no then write it

no knowledge in .net

hi, i m using this store procedure in my project ALTER procedure getkeyname(@city sysname,@key varchar(50)) as exec ('select distinct a.keywordname,a.keywordid from keyword As a INNER JOIN ' + @city+ ' As b on a.keywordid=b.keywordid and a.keywordname like ' + @key) but i got an error like.. invalid column name that i entered in @key parameter i want to pass my table name dynamically and parameter name but it accept only @city as a table name parameter and it treat @key as Colunm name like @city but i want to pass @key as parameter. please help me

no knowledge in .net

click this link if help that is better http://blog.donnfelker.com/2007/03/13/CGoogleGeocodeLatitudeAndLongitudeClass.aspx[^]

no knowledge in .net

requiredfieldvalidator and regular expression validator which are related with those texbox u make grouping with same name <asp:TextBox runat=server ID=ksearch ValidationGroup=ks CssClass=”txt”></asp:TextBox> <asp:ImageButton ID=”ImageButton1? ValidationGroup=ks Width=38 Height=24 ImageUrl=”images/gobutton.gif” OnClick=”go” runat=server/> <asp:CustomValidator ID=”cu” ValidationGroup=ks runat=server ControlToValidate=ksearch ValidateEmptyText=true ClientValidationFunction=”check” > which are grouped by using ValidationGroup=ks

no knowledge in .net