New Articles
Developers often work with unstructured data such as text documents, images, and videos. This unstructured data is often stored outside the database, separate from its relational structured data. This separation can cause data management complexities.
FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system. Transact-SQL statements can insert, update, query, search, and back up files.
HTML5 offers two new objects for storing data on the client:
localStorage - stores data with no time limit - and
sessionStorage - stores data for one session.
This was previously done with cookies. Cookies are not suitable for large amounts of data, because they are passed with every request to the server, making the process slow and ineffective.
Eloquera DB is a 100 percent .NET managed code object database that incorporates the best features of relational and object databases and overcomes their deficiencies. The database can be installed as a Windows Service (like SQL Server), but it can also be run in embedded "Desktop" mode. Here we show how you can use EloqueraDb in Desktop mode in an ASP.NET Web Application.
I've always been interested in fractal geometry. When Benoit Mandelbrot died last year, I was very sad. I still have his book, "The Fractal Geometry of Nature" which I bought back in the 1980's. The color graphics in the book (especially considering available computing power then) are stunning. I almost failed 9th grade algebra. Math didn't become interesting to me until I started programming and studied fractal geometry. Now, math is beautiful!
QR-Codes have become quite popular in the last few years, and there are QR-Code reader apps for virtually every mobile device that has a built-in camera.
These are mostly used for web urls to make it easier for mobile device users to navigate and bookmark a page with their mobile browsers. Of course, other information can be QR-encoded too.
Each year I like to play with the text of the president's State of the Union speech to get the word frequency. You can get some pretty good information from how many times certain words are used. This year I do it via LINQ as a fun programming exercise.
Many ASP.NET developers operate under the mistaken assumption that you need a WCF Service to handle JSON. Quite the contrary; ASMX services are happy to emit JSON. Here's how.
Up until recently, you could use the Yahoo Term Extraction Webservice to have the Yahoo Term Extraction API generate a list of valid key phrases from entered text or by reading a web page. However, Yahoo has announced that this service is deprecated and will only be available until March, 2012. All Yahoo APIs have now been folded into the new YQL model and use the same endpoint url, http://query.yahooapis.com/v1/public/yql.
We live in a world where nasty people with nothing better to do come up with all kinds of tricks to install nasty Trojans, Viruses and RootKits on our computers. Intelligent surfers can avoid most of this stuff just by using common sense - but it seems that for some, that's in short supply these days.
Often I need to convert a List of a certain type to a CSV string, or to a DataTable. Here I provide four extension methods:
1) public static DataTable ToDataTable<T>(this IList<T> data) (List<T> to DataTable.
2) public static string ToCsv<T>(this IList<T> data) ( List<T> to CSV string.
3) public static string ToCsv(this DataTable dt) ( DataTable to CSV string.
4) public static void WriteDelimitedFile<T>(this IEnumerable<T> list, string logfile, string delimiter)
.NET Developers often have to create their own SQL Server databases and be familiar with database schemas, tables, and the use of T-SQL stored procedures and joins. However, a weak point is often how to optimize the database with indexes. We summarize the use of the Database Engine Tuning Advisor in creating statistics and indexes based on an existing workload
Google has some search operators than many people are not aware of. If you suffix a google search url with one of these, you can restrict results to those that got indexed as little as one minute ago.
New Relic is a real-time performance dashboard that you install on your web server machine. EggHeadCafe is giving away a free license of Relic Server Monitoring in January. If you would like a chance to win, be sure to enter the drawing below:
From C# 4.0, methods, constructors, and indexers can declare optional parameters. A parameter is optional if it specifies a default value:
This article is really quite the "back to basics" ASP.NET tutorial. But you would be surprised how many ASP.NET developers aren't aware of all the different ways that data can be transferred from one ASP.NET page to another. We'll illustrate eight different ways that data can be sent from one page to another.
SilverlightSerializer is a fast binary serializer that works in both .NET and Silverlight, allowing you to move your objects between the two instances or store and retrieve them locally in either. It is highly performant and produces small byte arrays which are suitable for further compression.
Dapper is the micro-ORM developed by Sam Saffron and Marc Gravell. I use it in production code wherever possible, mostly because of its raw speed, and secondly because of it's ease of use. I understand that they use it as a kind of "drop-in" replacement to Linq to SQL at Stackoverflow.
Exporting GridView Data to Excel Sheet in ASP.NET is a common task for many Applications.
Every once in a while you come across something useful but incomplete. Such is the case with this GooglePlus.NET library
Everyone agrees that LINQ is "very cool" and brings much-needed elegance and utility to querying collections and other objects. However, there are some real bottlenecks that developers should be aware of when using LINQ.
|
|
New Questions
how to create crytal report using dataset for sql stored procedure in asp.net with c sharp
Hi,
i am trying to get list items from one site collection and display that data into other page, lets say which is in top level site page. so i am getting list items by using soap service. but when i want to insert link on name field, it doesn't give me default view url into desiger. so my question is how can i add link for each individual items on name field. Should i create new colu...
I do not want to have to delete every time one by one when I got a really large table data for each record. Is there a way to delete them all at one time? I am using SQL 2008. Can anyone show me some hint or code? Much thanks.
Please tell me now for the, how to retrieve the VarBinary Image in Window Form application Using SQLCLIENT ? Please tell me a am waiting for you replay help me in this topic as you help me for how to retrieving Image in wpf application . Please please .
Yes i want to re size the Image of type Varbinary and also show it in Datagridview so please tell me i do to retrieve i...
Is this file necessay?
Hi,
I have been given a Dell Optiplex GX620 from work.
For business reasons they have removed the hard drive.
I have tried to use a mini OS on a CD to start the computer without success.
The PC fails to start - all i get are 6 peeps and nothing else. I think these beeps notify a HW issue no surprise since there is no HDD at the moment!
...
Hi pichart y
thank you for your help here's the file
thanks
Leigh
LeighThomas.zip
am trying to develop an application for my staff. the logic is that, every morning and evening, workers will have to enter their staffID and password to sign in and sign out respectively. the problem am having is that, how will able to know that it is not yet 4:00pm and for that matter the worker can not logout. how will i also know that it is the same day so the user can not login again. finaly ...
hi,
I have used 3 pages, wherein i have used sessions for storing the values in 1st & 2nd page.
i want the values to b displayed in the 3rd page in a textbox ctrl.
1st page(drop down connected to SQL 2000): i have used the foll code Session["source"] = dt.Rows[0]["source"].ToString();
2nd page :protected void TextBox1_TextChanged(object sender, EventArgs e)
<...
hello,
Object reference not set to an instance of an object.
could any1 pls tell me what the above err means.
kind regards
Sachin
Hi i have a formula that needs shortening, excel is saying that it contains too many values/ references
heres the formula:
=SUMIFS('WE 8.1.12'!F7:F118,'WE 8.1.12'!D7:D118,C6)+SUMIFS('WE 15.1.12'!F7:F118,'WE 15.1.12'!D7:D118,C6)+SUMIFS('WE 22.1.12'!F7:F118,'WE 22.1.12'!D7:D118,C6)+SUMIFS('WE 29.1.12'!F7:F118,'WE 29.1.12'!D7:D118,C6)+SUMIFS('WE 5.2.12'!F7:F118,'WE 5.2.12'!D7:D...
Hi All
Is there any possibility of counting the occourence of two type of values
For Eg: yes/no from same Coloumn of a single table with a single Query
regards
ajay
when i click a save button the values which I've given to a text box in first form that should be added in dropdownlist which is in another form. that has to be saved in database as well.. pls anybody help to resolve this.. I"ve used asp.net with c sharp and sql
I have gridview. Data has been inserted into gridview trhough dynamically created row. Now I want to Save data into table on Button Click Even.
Thanks
Can you help me - what is the VBA to show/hide one worksheet based on a cell value in another worksheet? Or would it be easier to use conditional formatting?
e.g. Cell "H7"contains the week number of the period, i.e. 1,2,3,4,5. I need vba that will automatically show the appropriate weekly sales report and the inventory(inventory1, inventory2, etc) sheet for that week (if th...
How can i navigate from one record to another (the data appearing in textboxes) for database stored information in vb 2010.
getting below error while trying to get outlook rule list using vbscript...
Run-time error'-2147352567(80020009)' tHIS STORE DOES NOT SUPPORT RULES. cOULDNOT COMPLETE THE OPERATION.
how retrieve the image from sql database
hi, i need to enter address in textbox, so it should accepts only character, numbers,/ and comma and dot...
have any idea
hi
i need chart form...wheather there is chance for chart in c# .net
|