|
.
()
|
|
Updated:
Rating:
()
|
|
|
.
()
|
|
Updated:
Rating:
()
|
|
|
.
()
|
|
Updated:
Rating:
()
|
|
1.
Syntax Error In Insert Into Statement
I don't know Java, but in my opinion you should test for null.Add a function likepublic static string testString(String str) { string temp = ""; if (str != null) { temp = str; } return temp;}and test all your fieldsString AddStudents="INSERT INTO STUDENT...
|
Gianmaria Gregori
|
Updated: 26 May 2013
Rating:
( (No votes))
|
|
|
.
()
|
|
Updated:
Rating:
()
|
|
|
.
()
|
|
Updated:
Rating:
()
|
|
|
2.
Supplier who has supplied maximum number of books
As suggested by Samresh, a query like this should accomplish your taskSELECT [bid],[bname],[sname] FROM [test1] INNER JOIN [test2] ON [test1].[suid] = [test2].[suid] WHERE [sname] = 'C'
|
Gianmaria Gregori
|
Updated: 23 May 2013
Rating:
( (No votes))
|
|
|
3.
CRUD tables in WebMatrix using jTable jQuery plugin
A working example of a jTable implementation in WebMatrix 3
|
Gianmaria Gregori
|
Updated: 23 May 2013
Rating: 4.87/5
( (12 votes))
|
|
|
.
()
|
|
Updated:
Rating:
()
|
|
|
4.
i want to return the MIN and MAX values from the given table using SQLSERVER 2008
I don't know if there are best ways, but this worksSELECT MIN(col) AS Min, MAX(col) AS Max FROM ( SELECT col_1 AS col FROM numb_tab UNION SELECT col_2 FROM numb_tab UNION SELECT col_3 FROM numb_tab) t
|
Gianmaria Gregori
|
Updated: 20 May 2013
Rating: 5.00/5
( (2 votes))
|
|
|
5.
SEO redirect problem
Maybe could help the approach used in this tutorial[^]:- create a subfolder (e.g. Members);- put files you want to protect into this subfolder;- in the Members subfolder, create a file named _PageStart.cshtml. When any page in the subfolder is requested, this page runs first;- in the...
|
Gianmaria Gregori
|
Updated: 7 May 2013
Rating:
( (No votes))
|
|
|
6.
how to set tags of html head section using code
I'm not sure you can use controls in WebMatrix.Anyway, maybe you can accomplish your task with the use of sections.If you add the row @RenderSection("otherlinks", required: false)in the head of your site layout page and @section otherlinks { }in your child page, the...
|
Gianmaria Gregori
|
Updated: 7 May 2013
Rating: 5.00/5
( (1 vote))
|
|
|
.
()
|
|
Updated:
Rating:
()
|
|
|
7.
Files content based Searching
Your answer isn't trivial.There are a lot of articles that deal with text search using db servers like SQL Server or using search engines like Solr.Furthermore, there are problems related to the extraction of plain text from formatted files like pdf or office documents.The following...
|
Gianmaria Gregori
|
Updated: 15 Mar 2013
Rating:
( (No votes))
|
|
|
8.
From pdf files to plain text in a WebMatrix site
How to use the PDFBox Java library in an ASP.NET Web Pages project
|
Gianmaria Gregori
|
Updated: 14 Mar 2013
Rating: 4.10/5
( (3 votes))
|
|
|
9.
How Can i allow users belongs to role only to access files in folder?
In case something else is interested to the solution of this answer, Mike Brind answered to this thread: How Can i allow users belongs to role only to access files in folder?[^].
|
Gianmaria Gregori
|
Updated: 7 Mar 2013
Rating: 5.00/5
( (1 vote))
|
|
|
10.
file upload helper problem in ie
If you set the includeFormTag as true in your FileUpload helper, it makes a new form into the form that you have already created.Setting the parameter to false has the result of removing the unnecessary tag and, furthermore, lifts the upload button that you hide with CSS.Maybe...
|
Gianmaria Gregori
|
Updated: 7 Mar 2013
Rating: 5.00/5
( (2 votes))
|
|
|
11.
how to import already existing sql server database into webmatrix 2
If you want that your WebMatrix site have access to data stored in a sql server 2005 database, you can simply create a connection to a sql server instance.This article explains the procedure that you could follow: Connecting to a SQL Server or MySQL Database in WebMatrix [^].
|
Gianmaria Gregori
|
Updated: 13 Feb 2013
Rating:
( (No votes))
|
|
|
12.
Search Option using .Net
If you are looking for a basic SQL language tutorial, this could be a good starting point: SQL Tutorial[^].
|
Gianmaria Gregori
|
Updated: 31 Jan 2013
Rating:
( (No votes))
|
|
|
13.
What kind of hosting does webmatrix project need?
The minimum suggested requirements for WebMatrix hosting are Windows Server 2008 R2, IIS 7, and both ASP.NET 4.0 and 3.5 available (How to config the host for webmatrix?[^]), but in my experience Windows Server 2008 is enough.If you want to try to install WebMatrix on IIS 6 this thread could...
|
Gianmaria Gregori
|
Updated: 28 Jan 2013
Rating: 4.00/5
( (1 vote))
|
Submit an article or tip