stored - Page 49 - Developer IT

How can i implement parameterised and filtered report using stored procedure in Telerik reporting.

- by Mit

HI! I am new to telerik reporting , I want to implement a report using stored procedure with 5 filters on the report to get the desired out put. So, please can any one explain me how can i do it? or any link to see the video for the same?

Read the article

how to get all code of stored procedure in c#.net window and create textFile of storedprocedure in

- by sanjay chaudhari

hi, I Want get All Code of stored procedure from database and convert that procedure in textfile and save that textfilke in perticular path in c#.net window application. please reply me, Regards, Sanjay Chaudhari Mumbai, India.

Read the article

import a text file into a temporary table using 'Load data infile' inside a stored procedure- MySQL

- by Pankaj

I need to import a text file into a temporary table and from that select portions of it to insert in different tables. I wanted to use 'LOAD DATA INFILE'. Is there any way, i can use 'Load data infile' in a stored procedure. I am using mysql. LOAD DATA LOCAL INFILE 'C:\\MyData.txt' INTO TABLE tempprod fields terminated by ',' lines terminated by '\r\n'; SELECT * FROM product p;

Read the article

How to implement Gridview Custom paging using Stored Procedure?

- by user144842

Hi folks Can someone redirect me to your own blog link or any other link explaining complete tutorial about how to implement gridview custom paging using stored procedure? My search in google giving me old articles from year 2006. Right now I am using asp.net 3.5 and c#.

Read the article

What's the best way to keep java app data stored redundantly in a file?

- by Bijan

If I have systems that are based on realtime data, how can I ensure that all the information that is current is redundantly stored in a file? So that when the program starts again, it uses this information to initialize itself back to where it was when it closed. I know of xstream and HSQLDB. but wasn't sure if this was the best option for data that needs to be a literal carbon copy.

Read the article

How would be data stored at database in case of social networking site?

- by Abhishek Jain

In social networking site, a person has friends/followers. There is a chain of relation. How would be data stored at database in this scenario? This is a very huge information, still result of a query comes back very fast on these sites.

Read the article

Why is overloading operator&() prohibited for classes stored in STL containers?

- by sharptooth

Suddenly in this article ("problem 2") I see a statement that C++ Standard prohibits using STL containers for storing elemants of class if that class has an overloaded operator&(). Having overloaded operator&() can indeed be problematic, but looks like a default "address-of" operator can be used easily through a set of dirty-looking casts that are used in boost::addressof() and are believed to be portable and standard-compilant. Why is having an overloaded operator&() prohibited for classes stored in STL containers while the boost::addressof() workaround exists?

Read the article

Is Java File object from a MultipartRequest written to disk as temp file or stored in memory?

- by Flash84x

If I accept a file from a MultipartRequest and call File f = request.getFile("fileName"); Is the file written to disk (as a temp file) or is it only stored in memory at this point?

Read the article

How do I calculate the size of an entity stored in Google App Engine?

- by ryan

Is there an easy way to calculate the size of an entity stored in App Engine? I would like to know how close a particular entity is to hitting the 1 MB upper limit on entity size.

Read the article

Can I raise System Error in sql Server in a stored procedure.

- by Shantanu Gupta

I am writing a stored procedure where i m using try catch block. Now i have a unique column in a table. When i try to insert duplicate value it throws exception with exception no 2627. I want this to be done like this if (exists(select * from tblABC where col1='value')=true) raiseError(2627)--raise system error that would have thrown if i would have used insert query to insert duplicate value And which method will be better, using insert query or checking for duplicate value before insertion using Select query ?

Read the article

How do I compare current date with dates stored in MySQL db?

- by Gabriele

Hello, I'm coding a uploader that saves into the db the date when a file is uploaded using CURDATE(). I want to compare the current date with the one stored into the db in order to change the color of the icon related to the file depending on how long has this feel been uploaded. For instance, if less than a week, the icon will be green, if more than a week, it will be yellow, if more than two weeks, red. How can I do it? Thanks.

Read the article

how can I delete videos stored in documents folder ?

- by srikanth rongali

I have stored the videos in the documents folder. the path is /Users/sridhar/Library/Application Support/iPhone Simulator/User/Applications/EC177E77-8665-485C-93DE-62350FA6D0E7/Documents/air.mp4 I want to delete the video . How can I do it programmatically.

Read the article

where is the actual data in a mysql db stored on a linux machine?

- by noam

Which files are the actual files holding the data in the tables in a mysql db? I went to /var/lib/mysql/ and I can see there a bunch of relatively small directories corresponding to my tables, and a lot of files named servername-bin.0000001 etc. Is the data stored in those files?

Read the article

How to access the values stored in the user attributes of Active Directory?

- by Sekhar

How do I access the values stored in the user attributes of Active Directory? I'm using vc++.

Read the article

how do i cast a .net single to equivalent byte array that can be stored on the heap?

- by PeanutPower

how do i cast a .net single to equivalent byte array that can be stored on the heap? this is to be used as a glfloat

Read the article

import a text file into a temporary table using 'Load data infile' in a stored procedure- MySQL

- by Pankaj

I need to import a text file into a temporary table and from that select portions of it to insert in different tables. I wanted to use 'LOAD DATA INFILE'. Is there any way, i can use 'Load data infile' in a stored procedure. I am using mysql. LOAD DATA LOCAL INFILE 'C:\\MyData.txt' INTO TABLE tempprod fields terminated by ',' lines terminated by '\r\n'; SELECT * FROM product p;

Read the article

How to get the first n words from text stored in my DB in PHP?

- by SzamDev

Hi I need to know how to get the first n words from text stored in my DB in PHP? for example if there is some text in my DB like this one : "word1 word2 word3 word4 text one test four five" How I can get the first 4 or five words from this text? Thnks in Advance.

Read the article

Is there a way to visualize records stored in an iPhone app via Core Data?

- by Justin Searls

I have an app which, for good reasons, can only be debugged on a device. I'm using Core Data for the first time, and I'd like to be able to easily inspect the records that are stored by the app on the device. I imagine that Core Data is by default backed by SQLite on the iPhone, so this question might be as simple as asking: "What's the easiest way to extract the SQLite database for an app installed by Xcode without jailbreaking it?" Any experience someone could lend regarding this would be greatly appreciated.

Read the article

VC++ static library needs .obj stored in other project. How to do it?

- by Saurabh Chopra

Hi all, I am using Visual C++ 6.0. I have a static library containing a set of C functions. To create the .lib file, I need .obj of some .C files. Some such files are contained within the same static library project but some are to be stored in some othr project due to separate flags, etc. How can I include those .objs to create this library file..?

Read the article

How do I get SQL Server 2005 data stored as windows-1252 as UTF-8?

- by Diodeus

I have a client database with English and French data in windows-1252 encoding. I need to fetch this data as part of an AJAX call and send it in UTF-8 format. Is there a way I can pass the data through a stored proc to perform this conversion? My web app cannot be altered to perform this conversion itself.

Read the article

How can i read back an object stored in a session?

- by strakastroukas

First of all, here comes the load part. Structure MainStruct Dim Ans1 As String Dim Ans2 As String End Structure Dim Build As New List(Of MainStruct) ... ... ... Session("MyData") = Build The question is how can i read back the contents of the list, stored in the Session? I mean something like... Build = Session("MyData").Ans1

Read the article

Edit all views and stored precedures, find and replace?

- by johnboy

Is there an easy way to do a find and replace on a string in every view and stored procedure in my SQL Server database. I need to replace something like 'X United Kingdom' with 'X(UK)'.