Skip to main content

Posts

Showing posts from October, 2011

The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).

This error will occurs when you try to modify in Page Header through the C# Coding or uploading and aplying a skin that is refering some images or trying to resolve url  <script> or <style> references in the page head. So Use < script type ="text/javascript" src =" <% #Page.ResolveUrl("js/prototype.js") %> "/>  instead of < script type ="text/javascript" src =" <% =Page.ResolveUrl("js/prototype.js") %> "/> to solve the problem. Even this can be happen that you will get  blank ("") value such as  src="" . For this you can move these lines and put your code/script from "head" tag to "body" tag will solve the problem.

Fulltext predicate references columns from two different tables or indexed views

Fulltext predicate references columns from two different tables or indexed views SELECT      dbo . CustomerMap . DisplayCategoryId ,  dbo . Customer . CompanyName , dbo . Customer . website , dbo . CustomerMap . Description ,                       dbo . Country . Country , dbo . Customer . phoneNo , dbo . Customer . Mobile , dbo . Customer . FaxNo , dbo . Customer . Address , dbo . Customer . AboutUsUrl ,                       dbo . Customer . ProductUrl , dbo . Customer . EnqiryUrl , dbo . Customer . email          FROM          dbo . CustomerMap INNER JOIN                       dbo . Customer ON dbo . CustomerMap . CustomerId = dbo . Customer . CustomerCode INNER JOIN                       dbo . Country ON dbo . Customer . Country = dbo . Country . Id          where freetext (( CompanyName , Description ), @CODE ) gives the following error. Msg 7646, Level 16, State 1, Procedure sp_readALLCustomerBySearch, Line 11 Fulltext predicate references

Creating Full Text Search Catalog and Full Text Search Sql Server 2005

Creating Full Text Search Catalog and Full Text Search USE dbSur EXEC sp_fulltext_database   'enable' --1  First Create the catalog (if you already have then skip this step) EXEC sp_fulltext_catalog    'SearchOffers' , 'create' --2  Add a full text index to a table with index_name EXEC sp_fulltext_table    'PostOffer' , 'create' , 'SearchOffers' , 'PK_PostOffer' --3  Add a column to the full text index EXEC sp_fulltext_column     'PostOffer' , 'Title' , 'add' EXEC sp_fulltext_column     'PostOffer' , 'Description' , 'add' --4  Activate the index on table EXEC sp_fulltext_table      'PostOffer' , 'activate' --5  Start full population EXEC sp_fulltext_catalog    'SearchOffers' , 'start_full'

UP TET 2011 Syllabus and Exam Pattern

Teacher Eligibility Test (UP TET) 2011 Syllabus and Exam Pattern TETs 2011 in UP, MP, Karnataka,AP, Bengal,Tamilnadu, Kerala and Other States. Details of notification and state specific terms of the exam and weightages in teachers recruitment and details of application procedure will be available on the websites of education departments of concerned states.  National Council for Teacher Education (NCTE) has initiated new regulation for those aspiring to become teachers in schools under Government, private, unaided and aided categories. Now the candidates have to qualify in Central Teacher Eligibility Test (CTET) to be conducted at state level by state boards. CTET will be a compulsory and essential requirement for securing a teaching job in all types of schools. Eligibility: B Ed degree. Validity of qualifying certificate (B.Ed.) will be decided by the state government/ Centre. The certificate can not be more than 7 years old.  Exam pattern and Scheme: There will be 2

Rebuild the Master Database for SQL Server 2005

Repair master db in SQL Server 2005 To rebuild the system master databases you need to run the setup command from the Command prompt and follow the following steps: 1. Click Start, click Run, type cmd, and then click OK. 2. Run the following command to rebuild the system databases of sql server 2005: start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=Instance_Name REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=StrongPassword example: start /wait D:\setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=YourSAPassword Replace  YourSAPassword to your current sa login password.It will work fine.

UP TET 2011 Exam Application,UPTET 2011 Result | UPTET 2011 Revised Result

UPTET 2011 Result | UPTET 2011 Revised Result | UPTET 2011 Updated Result |Board of High School and Intermediate Education Uttar Pradesh, Allahabad UP TET Advertisement 2011 and Exam Detail/Admit Card/Call Letter Download UP TET 2011 FORM & DETAILS  GET LATEST DETAIL ABOUT 72825 Primary Teacher Merit List UP TET 2011 Application form submission last date is 18-Oct-2011.Forms will be distributed from PNB bank all over UP.According to latest news Appearing B.Ed student also eligible for TET exam 2011 so they can also submit their forms to concern District.There is no requirement for Rojgar Registration No and Bank receipt within the application form.UP TET 2011 exam results will be avail on http://www.uptet2011.com . Now you can easily get Application from from the P.N.B bank Branches. UPTET 2011 Result | UPTET 2011 Revised Result | UPTET 2011 Updated Result |  Board of High School and Intermediate Education Uttar Pradesh, Allahabad

Insert Data Into The Table SQL SERVER

  First we have to create table with the table name Student with the following fields in which we are going to insert records. Column Name Data Type Length Std_Name Varchar 50 Address Varchar 50 City Varchar 50 Age Numeric 8 DOB DateTime 8 Class Varchar 10 Insert Data Into The Table for execution of queries open the new query window from the Microsoft Sql Server Management Studio. Select SQL Server from the drop down combo if you are using the client else in case of server enter (local) like above. Select window authentication or SQL Server authentication according to your system installation and click on OK. Query window will appear as you click on New Query marked as first red. Select your database from the combo displaying at the toolbar above on the screen. Now write down the following query in the displaying window. ·          

To View a Stored Procedure,Triggers,Functions

Just wanted to quickly check the stored procedure logic from the SQL Query Analyzer.  SQL Server allows us to view the definition, information, and dependencies of a stored procedure,function and triggers.                  1. To view the definition of a stored procedure: sp_helptext   procedureName 2. To view the information about a stored procedure:  sp_help   procedureName 3. To view the dependencies of the stored procedure:  sp_depends   procedureName 'procedureName' is name of stored procedure,function and triggers also. You can also put these 'procedureName' between single quote. If you are going to view function then put   function name such as sp_helptext GetDownlinePairCountInfo Sp_helpText is very good option for viewing the sp’s, Trigger’s , View’s and functions .

Sharekhan trade tiger,Free Trade Tiger,Download Sharekhan Trade Tiger New Version

Ultimate online trading platform - Trade Tiger - Multiple Exchange - Internatinational Market Watch - 24 Hour Market Access - One Click Filter - Unlimited Charts - Create your own technical rules for trading - A single Trading Screen for all segments - Live Streaming Quotes - Access all Trading Calls - Advanced Charting features          http://freeintradaytips2u.blogspot.com Google Search Key: Trading system,Sharekhan,shares trading system,stock exchange trading system, stock software, intraday trading,stock market trading, share market,a utomated trading system, stocks,free stock tips,stock market

Retrieve & display image from sql database in vb.net

In my previous post I have discuss about how to store image into sql server database using vb.net. It is time to fetch image from sql server database and display into picture box. Here is the snapshot of vb.net code. First of all we have to imports these namespace in our class. Imports System.IO Imports System.IO.Stream Public Function getImagefromByte( ByVal data As Byte ()) As Image         Dim ms As MemoryStream = New MemoryStream()         Dim img As Image         Try             ms.Write(data, 0, data.GetUpperBound(0))             img = Image.FromStream(ms)         Catch ex As Exception             img = My .Resources.noimage         Finally             'ms.Close()             'ms = Nothing         End Try         getImagefromByte = img     End Function Here is code that show how to call this function and display image into picture box. ds is object of DataSet class and DataAdaptor is used fill that dataset,