Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
57 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 2
Page Size: 10 · 25 · 50

Author filtered by: Lokesh Zende [x]
SQL DateDiff in Month by Lokesh Zende
Question 10 May 2013   license: CPOL
Hi Friends,I have a table with two columns in it, viz. Year and Month_No.If I have 1. year = 2013 and Month_No = 10 2. year = 2014 and Month_No = 5I want to find the difference between these two in Months.Any help appreciated.Thanks,Lok..
SQL-ServerSQL2008
Answer 23 Mar 2013   license: CPOL
Hi Manju,You can get the value of the checkbox control in your javascript functionfunction Confirm() {// your code here var chk = document.getElementById("chkbox").checked; alert(chk );}Hope this helps you.Regards,Lok..
C#ASP.NETJavascriptSQL
Answer 23 Mar 2013   license: CPOL
Hey,You can use COUNT function.select count(*) from your_tableGet the count of the record in the table and add 1 to it.But, this will work fine only if you are not deleting the records physically from the table otherwise it will work in any condition.Hope this helps...
SQL2000SQLSQL-Server
Question 5 Feb 2013   license: CPOL
Hi Friends,I am developing a web site of the celebrities.On a page, I have the list of celebrities.If a user clicks on any particular celebrity's image, a page should open showing the information of that celebrity. What I want is, the URL of the page should form with the name of the...
C#3.0ASP.NETC#SQL-ServerSQL2008
Question 23 Dec 2012   license: CPOL
Hi All,I have a web form with a button control.On click of a button, I start a sql job. The job takes almost 20 min to complete.I want to check the progress of the job like out of 100, how many percent has completed.I want to show a progress bar on the page showing how many percent the...
C#2.0ASP.NETC#SQL-ServerSQL2008
Answer 20 Dec 2012   license: CPOL
You can check if the record already exists in the table using IF NOT EXISTS(SELCT * FROM table_name (applicable where clause))The record will be inserted only if the table does not have the same record (or in any case, no records. Depends on the where clause you use.)I think this will help.
SQLSQL-ServerStoredProcedures
Answer 20 Dec 2012   license: CPOL
My sql job had only one step.So I added another step to it and in step 2 of the job, I added the below code declare @body1 varchar(8000)select top 1 @body1 = [Message] from msdb.dbo.sysjobhistory A INNER JOIN msdb.dbo.sysjobs B ON B.Job_id = A.Job_id where B.Name = > and...
SQL2005SQL-ServerSQL2008
Question 19 Dec 2012   license: CPOL
Hi ,I have setup a profile and account for sending mail using DatabaseMail.I have a SQL job and if the job fails, I receive an Email.Till this point, everything works fine. This is what the email looks like :JOB RUN: 'GenerateJVForLabourAndOverheads_R11Testing' was run on...
SQL2005SQL-ServerSQL2008
Answer 19 Dec 2012   license: CPOL
I had set up everything as needed and as I already described in my question, but don't know why I was not receiving any mail. I had also restarted me machine so many times yesterday but to no luck.Today when I opened my mailbox, I started receiving mails for the sql job completion.I still...
SQL-ServerSQL2008
My vote of 5 by Lokesh Zende
Question 19 Dec 2012   license: CPOL
Hi,I have a SQL job. If the job fails / succeeds, I want to send the mail to user.For this, I created an operator under SQL Server Agent and put down my email address in the E-mail name text box under Notification Options.Then, on the Properties of my created SQL job, under the...
SQL-ServerSQL2008
Simple Android application by Lokesh Zende
Question 21 Oct 2012   license: CPOL
Hi Friends,I am learning how to create android apps. I created my first simple app to display "hello world" using Eclipse.Now I want to create a Student Database app where in user enters roll_no,name and grade of the student.Simple app with 3 text boxes.Then user should also be able to...
MobileAndroid
Question 27 Aug 2012   license: CPOL
Hi Friends,I have been asked this question so many times in interviews but I am still not able to satisfy the interviewer.Question is :Explain the complete process right from button click event till the data is stored in the DB. I always say like, assign values to properties and then...
C#2.0ASP.NETC#SQL-ServerSQL2008
Question 9 Aug 2012   license: CPOL
Hi Friends,I am generating an Excel file (Excel 2003 i.e. ".xls") using some data tables.File generates successfully.Now I am trying to open the same file using upload control and OLEDB connection, but I am getting this strange error."External table is not in the expected format."Now,...
C#2.0ASP.NETC#
My vote of 5 by LokeshZende
Answer 2 Jul 2012   license: CPOL
There is no way out for this situation.Once response ends, we cannot get another response as there is only one response to one request.So I added another button on the form, on click of which, it will refresh my page.User HAS TO click the button in order to refresh the page.
C#2.0ASP.NETC#
Question 1 Jul 2012   license: CPOL
Hi Friends,On a button click event, I am calling File save dialogue box.After saving the file, I want to refresh the radgrid.When I try with RadGrid.Rebind() method, it calls the NeedDatasource event of the grid with no problem.I can see updated values in object. But I cannot see those...
C#2.0ASP.NETC#
need to get sql query by Lokesh Zende
Question 5 Apr 2012   license: CPOL
Hi friends,I have two tables as follows :Table_1ID Name1 AAA2 BBB3 cccTable_2ID Sub Marks1 M1 501 m2 652 M1 892 M2 933 M1 893 M2 56I need to get average of Marks and ID having highest avg will be on...
SQL2005SQL-ServerSQL2008
Add Items to ListBox by Lokesh Zende
Question 21 Mar 2012   license: CPOL
Hi Friends,I want to add items in ListBox on press of (Enter) key in TextBox.(Just like we do while logging in --put id & password and hit Enter).I know this is possible with onkeyup event and it worked for me very well.I have another Button , on click of which I want to get the items in...
C#2.0ASP.NETJavascriptC#
Remove Items from ListBox by Lokesh Zende
Question 20 Mar 2012   license: CPOL
Hi Friends,I am adding items to List-box using java-script;Now , on Button click server side event, when I try to remove selected items, I get item count 0;I want to remove items from server side click event only.This is what I have on Keyup event of text box.
C#2.0ASP.NETJavascriptC#
Loop through Hashtable by Lokesh Zende
Question 17 Jan 2012   license: CPOL
Hi Friends,I have a Hashtable and I want to compare the values stored in it.e.gHastable ht= new Hashtable();and it has collection as Key ValueDropdown -- 1000Dropdown -- 2000Dropdwon -- ...
C#2.0C#
Question 7 Jan 2012   license: CPOL
Hi Friends,I want to develop an application to send multiple sms, in .Net.How can I achieve this?Can I get any free API or Code for it?Any help appreciated.Thanks,Lok..
C#2.0ASP.NETC#WinForm
need to get sql query by Lokesh Zende
Question 22 Dec 2011   license: CPOL
Hi Friends,I have a Currency table with records as follows :ID Name1 INR2 USD3 SGD4 EURO. .. .When I fire a query like, select * from Currecny, I get the recordset as shown.But I want to get " SGD " as my first record, then all remaining...
SQL-ServerSQL2008
Question 5 Dec 2011   license: CPOL
Hi Friends,I have a javascript function whicf I call on onkeyup event of textbox.It has a regular expression that will format the values input by user with commas (,);Problem with it is that, it puts comma after every third digit before decimal point.I want it to put comma for first...
C#2.0ASP.NETC#
Auto Comma using javascript by Lokesh Zende
Question 5 Dec 2011   license: CPOL
Hi Friends,I want to display numbers as comma separated string (like we show amount 12,34,675.67)I have a javascript function, which I call on onkeyup event of a textbox.Here is that function :function Comma(Num) { Num += ''; Num = Num.replace(/,/g, ''); x =...
C#2.0ASP.NETC#
Partial page refresh by Lokesh Zende
Question 17 Nov 2011   license: CPOL
Hi Friends,I have a "marquee" on my MasterPage that moves from right to left.But when I open any other page from Menu, It resets back to right.I want it to move continuously fr om right to left irrespective of my other operations on page.Is there any way to achieve this?Ajax or any...
C#2.0ASP.NETC#
Question 15 Nov 2011   license: CPOL
Hi Friends,I am exporting data into Excel (2003 format).But when I try to read the same Excel, I get this error"External table is not in the expected format"I have MS Office 2007 installed on my PC.When I open that Excel and then try to read it, it works fine, whereas it is...
C#2.0ASP.NETC#
Forex currency Web Service by Lokesh Zende
Question 4 Nov 2011   license: CPOL
Hi Friends,I am developeing an application in which I am required to update Currency ratesi.e.INR - USDINR - SGD (singapore dollar)I have only these three currenicies for which I have to maintain the records..As currency rates keep on changing from seconds to seconds, I also want...
C#2.0C#
Question 17 Feb 2011   license: CPOL
Hi firends,I have a button click eventin itafter satisfying some condition, I should get a confirmation dialog.When I click "OK" button of that confirmation dialog, I want to proceed further in my code on server side.protected void btnSelectInvioces_Click(object source, EventArgs...
C#2.0C#
Question 13 Feb 2011   license: CPOL
Hi friends,How do find server control on client side?I tried using "document.getElementById('btnBack').value;" but this gives me the text property of the button.I want to find the id of that button inorder to enable/disable it.Could you please tell me how do we do that?Regards,Lok..
C#2.0C#
Question 7 Feb 2011   license: CPOL
Hi friends,I hav an application, through which I am calling RDL reports.When I give a call, the popup comes with an error res://ieframe.dll/http_400.htmThis happens only for IE(all versions) but not for Firefox.I can see all the reports when I open my application through...
C#2.0C#SQL-ServerSQL2008
Question 7 Feb 2011   license: CPOL
Hi friends,How do we find date diffrence between two dates?I want difference like this : d(days):HH(hours):MM(Mins)I have two date columns and want to get difference between them in the given format.I use sql server 2008Any help will be appreciated.Regards,Lok..
SQL-ServerSQL2008
Session expire by Lokesh Zende
Question 24 Nov 2010   license: CPOL
Hi friends, I have an web application where in I have set the session expire time to 160 in Web.Config.My problem is that, when the session of logged in user expires, instead of redirection to Login page it gives me...
C#2.0ASP.NETC#
Answer 12 Nov 2010   license: CPOL
Hi Arti,its very simple to bind the gridview based ont the value u have selected in the combobox.In the SelectedIndexChangedEvent() of your combobox, write your SQL Query to bind the gridview.For e.g. protected void ComboBox_SelectedIndexChanged(object o,...
C#
datagrid or what? by Lokesh Zende
Answer 12 Nov 2010   license: CPOL
Hi yummy02,you can place the data from XML file either in Grid or in Table.Either way, it will work.
C#XML
A * Algorithm by Lokesh Zende
Question 11 Nov 2010   license: CPOL
Hi friends,Can anyone tell me the code to implement A * alogorithm?From where can I get the source code free?Please help,Lokesh
C++
Answer 28 Oct 2010   license: CPOL
Regex nm = new Regex(@"^[a-z A-Z]");Now use this.
SQL2005C#3.0C#SQL-Server
Answer 27 Oct 2010   license: CPOL
Just add this code right after the code for opening the pop up.window.location.reload;It will solve your problem for sure.
C#ASP.NETJavascript
Answer 21 Oct 2010   license: CPOL
Its very simple Sazib.Just set the ReadOnly proeprty of textbox to True.Or otherwise set Enabled property to False.But setting enable false makes appearance of textbox dull.So better to use ReadOnly property.
ASP.NETControls
3 Tier Application by Lokesh Zende
Answer 19 Oct 2010   license: CPOL
Charudatta,3 tier application khup sope astat.Thodasa Google var search kar.Milel sarv kahi.
C#
Convert .rdl file to .xsd by Lokesh Zende
Question 18 Oct 2010   license: CPOL
Hi all,Is it possible to conver .rdl file to .xsd using C#?If yes, how do we do that?Please help.Regards,Lok
C#2.0ASP.NETC#
Server.Transfer Problem by Lokesh Zende
Answer 17 Oct 2010   license: CPOL
What happens after page load event?The control must be going to OnClick evetn of the button, isn't it?Whwnever any event is fired, say for e.g onClick or SelectedIndexChange, the control is first transferd to Pag Load event, and then the actual (OnClick,..,.) event is fired.
C#ASP.NET
Read .rdl file in ASP.Net by Lokesh Zende
Question 15 Oct 2010   license: CPOL
Hi Friends,I have a .rdl file somthing like below. ApplicationID System.Int32
C#2.0ASP.NETC#
Question 14 Sep 2010   license: CPOL
Hello guys..I am trying to encrypt and decrypt a password.Password is getting encrypted successfully, but while decrypting it gives me cryptographic exception " Length of the data to decrypt is invalid"Can you please help me with this??Heres my code behind..using System;using...
C#2.0C#
Question 13 Sep 2010   license: CPOL
Hello guys..,I want to open a modal popup from server side after checking some condtions.I tried many codes but they didn't work.Here's what I am using now ..string strScript; Type jsType = ObjPage.GetType(); ClientScriptManager CS = ObjPage.ClientScript; ...
C#2.0ASP.NETC#
Question 28 Jun 2010   license: CPOL
I have i gridview in which I have a button. After clicking the button a popup opens.But when I close the popup the control doesnot transfer to the page load event of parent web form.how can i do this?
C#2.0ASP.NETC#
Export Gridview to Excel by Lokesh Zende
Question 29 May 2010   license: CPOL
Hello friends..I am trying to export my Gridview data to Excel sheet.Here is my code..protected void Page_Load(object sender, EventArgs e){ con.Open(); if (!IsPostBack) { BindData(); } con.Close(); }private void BindData(){ ...
C#2.0ASP.NETC#
Question 2 May 2010   license: CPOL
Hi friends..This may not be the right place to ask this question but its an emergency.I need a regular expression for only Uppercase Letters with spacesCan anyone help me?RegardsLokesh
expression
Question 19 Mar 2010   license: CPOL
I have two checkedlistbox controls 1. chklst_type2.chklst_testchklst_type I fill through database.On Checking of an item from chklst_type, I fill second checkedlistbox control i.e.(chklst_test)I want to uncheck the last checked item from chklst_type and also clear the related...
C#2.0C#
Question 19 Mar 2010   license: CPOL
Hello friends,I have 2 tables1. LabTest_Typeid type charges1 biochemistry 102 urine 1202. LabTestid test type_id1 sugar 12 glucose 13 sugar 24 glucose 2I want...
C#2.0C#
Page 1 of 2
1 2
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web03 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid