9,869,444 members (28,587 online)
Visit CodeProject.TV
Discuss CodeProject.TV
Sign in
Email
Password
Forgot your password?
Sign in using
home
articles
Chapters and Sections
>
Search
Latest Articles
Latest Tips/Tricks
Top Articles
Beginner Articles
Technical Blogs
Posting/Update Guidelines
Article Help Forum
Article Competition
Submit an article or tip
Post your Blog
quick answers
Ask a Question
View Unanswered Questions
View All Questions...
C# questions
ASP.NET questions
VB.NET questions
C#4.0 questions
C++ questions
discussions
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work & Training Issues
Design and Architecture
ASP.NET
JavaScript
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
Adobe Technologies
C#
Free Tools
Objective-C
Ruby On Rails
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
.NET Framework
Mobile
VS 11 & .NET 4.5
Sharepoint
Silverlight / WPF
Visual Basic
Web Development
Site Bugs / Suggestions
features
Component & Service Catalog
Competitions
News
The Insider Newsletter
Newsletter archive
Surveys
Product Showcase
Research Library
CodeProject Stuff
community
The Insider News
The Lounge
The Weird & The Wonderful
The Soapbox
Press Releases
Who's Who
Most Valuable Professionals
Company Listings
Non-English Language
>
General Indian Topics
General Chinese Topics
help
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
Site Map
Advertise with us
Employment Opportunities
About Us
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*
39 Results
Search
Everything
Articles
Technical Blogs
Tips & Tricks
Questions
Answers
Forum Messages
News Items
Catalog Items
Videos
Training Courses
Just My Stuff
My Bookmarks
Sort by
Relevance
Rating Asc
Rating Desc
Title Asc
Title Desc
Author Asc
Author Desc
Date Created Asc
Date Created Desc
Date Modified Asc
Date Modified Desc
Price Asc
Price Desc
Duration Asc
Duration Desc
Match
All Fields
Title
Description
Author(s)
Tags
Any Date
Last 12 hours
Last 24 hours
Last week
Last 2 weeks
Last month
Last 3 months
Last 6 months
Last year
January
February
March
April
May
June
July
August
September
October
November
December
Rating Range
All - Including Unrated
1.0 - 5.0
2.0 - 5.0
3.0 - 5.0
4.0 - 5.0
4.5 - 5.0
4.8 - 5.0
5.0
Advanced Filters:
Article Topics
All Topics
Desktop Development
Web Development
Mobile Development
Cloud Computing
Enterprise Systems
Database
Multimedia
Languages
Platforms, Frameworks & Libraries
General Programming
Graphics / Design
Development Lifecycle
General Reading
Third Party Products
Mentor Resources
Article License
All Licenses
CPOL
CDDL
Ms-PL
MPL
CPL
Eclipse
MIT
BSD
Apache
CC (ASA 2.5)
Zlib
Public Domain
CC (Attr 3U)
CC (ASA 3U)
LGPL3
GPL3
Forums
All Forums
Feature Forums
General Programming
Web Development
Product Lifecycle
Database & SysAdmin
General Discussions
Non-English Language
Catalog Category
All Categories
Books & Training
Charting & Graphing
Components, Controls, Libraries
Data Manipulation & Mining
Database Tools
Debugging
Documentation & Help
Financial, Math & Scientific
Frameworks & APIs
General Development Tools
GIS & Maps
Graphics & 3D Modeling
Hardware and Robotics
Hosting
IDEs
Imaging
Mobility
Multimedia
Networking
Performance and Profiling
Programming Languages
Project Life-cycle Management (ALM)
Reporting
Search
Security
Setup & Deploy
System Adminstration
Utilities
Virtualization
Web Design/Development
Catalog License
All Licenses
Commercial
Fully Function Evaluation version
Limited Functionality Trial
Limited Time Trial
Shareware
Free For Personal Use
Freeware
Page 1 of 1
Page Size:
10
·
25
·
50
Author filtered by: DileepkumarReddy
[x]
Assigning a value to variable in Dynamic SQL
by
DileepkumarReddy
Question
6 May 2013
license:
CPOL
Hi all, How do we assign a value to scalar variable based on some condition in Dynamic SQL .After assigning i have to returnthe value.Example.CREATEPROCEDURE PROC_LOCALVAR --'1'(@V aS varchar(1))ASDECLARE @SQL AS VARCHAR(MAX)DECLARE @LOCAL AS VARCHAR(20)SET...
General Programming
»
Uncategorised Quick Answers
»
General
SQL2005
SQL-Server
Text box Keydown event is not raising
by
DileepkumarReddy
Question
30 Apr 2013
license:
CPOL
Hi all, I created a menu in MDI with F1 shortcut and at the same time i am using F1 key in textbox key down event in some form.Issue is when i hit F1 in that form text box key down event is not raising where as it's raising menu item click event.How can i resolve this issue. ...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Dynamic SQL Server query
by
DileepkumarReddy
Question
22 Apr 2013
license:
CPOL
Hi all,I have two tables RCP(Receipt,Contra,Payment) and JDC(Journal,DebitNote,CreditNote).And i store type of transaction ((Receipt=1,Contra=2,Payment=3) in RCP and(Journal=4,DebitNote=6,CreditNote=7) in JDC ) in some column.Now how do i write the query to retrieve data from...
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
How to handle double quotes in string literal in sqlserver
by
DileepkumarReddy
Question
30 Mar 2013
license:
CPOL
Hi all, I have a table with columns ID,Name and Desgnation.Some of the records for column Name are something like thisName:Dil" ReddyPradeep'' Reddy.So how do i get data using select statement.Select * from Employee with(nolock) where Name=???????Help me...
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
Comboxedit columns in xtragrid
by
DileepkumarReddy
Question
12 Mar 2013
license:
CPOL
Hi all, I have one Devexpress xtragrid consisting of three columns.First two columns are combobox edit columns.Based on first column value second column combobox items changes.How can i do that,any one help me out.
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Dynamic number of columns based on value
by
DileepkumarReddy
Question
4 Mar 2013
license:
CPOL
Hi all I am writing one stored procedure.what i want is, based on some column value columns have to change.Lets suppose if value is 1 i want to get data from columns 1,2,5,6 and if it is other than 1 then i want to get data from columns 1,3,4,6 something like that..how can i do...
General Programming
»
Uncategorised Quick Answers
»
General
SqlServer
How to write a procedure for file generation
by
DileepkumarReddy
Question
3 Mar 2013
license:
CPOL
Hi all,I want to generate a file with several fields say comma seperated,all the fields comes from sametable.for example i have a table of clients with fields like RefNo(unique),FormNo,RecdDate,Category(Individual Or NonIndividual) etc..Now i want to generate a file with the fields...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
SqlServerm
Xml file generation using VB.net and sql server
by
DileepkumarReddy
Question
11 Feb 2013
license:
CPOL
- - GULMOHAR 13/01/2011 - 01 GULMOHAR I 00001 02/01/2012 ...
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
VB
VB.NET
How to move the focus to a particular field
by
DileepkumarReddy
Question
4 Jan 2013
license:
CPOL
HI All, I have one form consisting of 32 fields in which most of them are mandatory.After clicking on save button i am adding the field's related name to Collections(List of string) and displaying message box with the names.I want the focus to move to the first control displaying in...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
windows controls enabling and disabling
by
DileepkumarReddy
Question
12 Dec 2012
license:
CPOL
Hi all, I have a from consisting of 8 controls(textbox and combo) and i had to use this form for several reports.Based on particular report i have to enable or disable the controls.How can i do this dynamically..Any one help me out..Thanks in advance..
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
How to check which button is clicked
by
DileepkumarReddy
Question
19 Nov 2012
license:
CPOL
I have an textbox,in that validated event i am retreiving some details.I have clear button which clears all.Issue is when users types something in textbox and presses clear textbox's validated event is raising..i want to prevent that..Help me out..thanks in advacne
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
How to limit decimal length of a datagridview column
by
DileepkumarReddy
Question
16 Nov 2012
license:
CPOL
Hi all...i want to limit the decimal length of a datagridview column..Please help me out
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
how to set focus on a particular cell of Datagridview in vb.net
by
DileepkumarReddy
Question
21 Oct 2012
license:
CPOL
Hi all, How to set focus on a particular cell of datagridview..Actually i want to skipa cell(immediate next column's cell).I did something like this.. grdJV.CurrentCell = grdJV(e.rowindex, e.columnindex+2)Excepition is An unhandled exception of type...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
How to split a string dynamically
by
DileepkumarReddy
Question
17 Oct 2012
license:
CPOL
Hi all, I have a collection of client names as Mr.Dileep Kumar ReddyMr Dileep VarmaMrs Rubeena Naazsomething like this.I want to seperate Prefix from them.that isDileep Kumar ReddyDileep VarmaRubeena NaazHow can i do this...help me out
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Text box validations
by
DileepkumarReddy
Question
5 Oct 2012
license:
CPOL
Hi all,I have an issue...I have 4 pair of textboxes ,each pair one below the other.if user enters some values say 5 in textbox1 and 150 in textbox2.then he should not be able to enter the value between 5 and 150 in any of the textboxes,like wise validations on all text...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Adusting the size of buttons on panel
by
DileepkumarReddy
Question
25 Sep 2012
license:
CPOL
Hi all, I am adding buttons dynamically on panel and displaying some data.So i want the buttons to be adjusted on panel without any space on panel.How can i do that..help me out
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
How to create Heat map consisting of boxes in vb.net
by
DileepkumarReddy
Question
24 Sep 2012
license:
CPOL
Hi all, I want to create a utility (Heat map) consisting of boxes based on the number of elements.Suppose if i have an array of 4 elements,i should be able to show heat map consisting of 4 boxes.How can i do that...help me out...thanks in advance
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
How to show table structure and uploading file's structure are different
by
DileepkumarReddy
Question
6 Sep 2012
license:
CPOL
Hi everyone,I want to develop a utility which shows the user that uploading file and respected table have different structures(columns) at a particular row(in file).What is the best way in user point of view.Can any one suggest me..
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
sql query to add coumn's values to other column.
by
DileepkumarReddy
Question
30 Aug 2012
license:
CPOL
I have table 'ProductMaster' with columns ProductCodeProductNameChapterCodeBasicCVDSADDensityLCostCustomMy Stored procedure is..Create PROCEDURE [dbo].[PROC_TransactionReport](@ProductName as varchar(50),@INR1 as money,@INR2 as money,@INR3 as money,@Dollarrate as...
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
Adding Column Values and displaying in another column
by
DileepkumarReddy
Question
23 Aug 2012
license:
CPOL
Hi everyone,here is my issue.I am doing some calculations in stored procedure and display as below ...I want to add Basic,BasicDuty,CVD,Custom,AddDuty and display it as ActualCostProductName ProductCode Basic BasicDuty CVD Custom AddDuty ActualCostProduc1 P1 4553 34 ...
General Programming
»
Uncategorised Quick Answers
»
General
SQL2005
SQL-Server
How to trim a string in vb.net
by
DileepkumarReddy
Question
9 Aug 2012
license:
CPOL
Hi everyone,I have an issue in VB.NET I have string array.That array contains strings having spaces bothsides(left and right).How do i remove spaces.I am putting string in Datarow.I am doing like this,but its trimming right side.I want to trim left side also.Please help me out....
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
User defined function to store date as number of seconds from 1/1/1980
by
DileepkumarReddy
Question
18 May 2012
license:
CPOL
Hi everyone,i want to store date as number of seconds from 1/1/1980..How can i do this?Please help me out...thanks in advance..
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Auto generation of RefNo
by
DileepkumarReddy
Question
16 May 2012
license:
CPOL
Hi everyone..I have an issueI have two tables BrokSchmMaster,BrokSchmDetailsTable BrokSchmMaster ColumnsBrokSchmName SegID BrokSchmType Scrip RefIDSchm 1 2 0 1Table BrokSchmDetails ColumnsRefID BrokSettlmentType Onvalue FromValue ToValue1 ...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Checked combo box issue..
by
DileepkumarReddy
Question
21 Apr 2012
license:
CPOL
Hi,i have Checked Combobox.. Items areSquared Off TO Delivety TO Squared Off Buy TO Squared Off Sell TO Delivery Buy TO Delivery Sell TO Now, if he select "Squared Off TO" user should be able to select either "Delivery TO" Or "(Delivery Buy TO and Delivery Sell TO)".. same...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
How to disable the items of checked combo box
by
DileepkumarReddy
Question
20 Apr 2012
license:
CPOL
Hi,i have checked combo box consisting of some items.What i want is, if user selects any of them,he should not be able to select other items,,,,how can i do that...please help me..
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Checked combo box issue
by
DileepkumarReddy
Question
19 Apr 2012
license:
CPOL
Hi,I have two checked combo boxes..First one will Consist of enums (BSECash,NSECash)...second will filled with enum names according to the selection of enums in first one...enums are.. Public Enum BSECash Rolling = 1 T2T = 2 Auction = 3 Valan = 4 ...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Displaying items in combox box
by
DileepkumarReddy
Question
19 Apr 2012
license:
CPOL
Hi, i have one checked combobox consisting of enums and other is combobox...issue is..whenever i select any one of enum (checked combo box item) i should display corresponding enum values of selected enum in combo box... how can i do that...help me out..
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Query regarding Devxpress xtragrid control
by
DileepkumarReddy
Question
17 Apr 2012
license:
CPOL
Hi everyone,I have a query regarding xtragrid control.I am populating xtragrid control using datatable,i have data something like this..xtragrid control after binding...ClientCode NomineeDetails Name FatherNameC0001 Director1 - -C0001 ...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Issue in Microsoft Visual Studio
by
DileepkumarReddy
Question
15 Apr 2012
license:
CPOL
Hi,I am using Microsoft Visual Studio,I added Devx gridcontrol to form,issue is whenever i type something in editor,paranthesis is coming automatically...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Tool strip Menu Item images using vb.net
by
DileepkumarReddy
Question
13 Apr 2012
license:
CPOL
Hi, Can any one please suggest how to add image(icon) to 'Toolstrip menuitem',i am able to do with 'Menu Item' using 'MeniItem Extender',but help me with 'ToolstripMenuItem'.
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
WrapSP - A Wrapper Class Generator in vb.net for SQL Stored Procedures
by
DileepkumarReddy
Question
3 Apr 2012
license:
CPOL
Hi,I want to generate a wrapper class in VB for SQL Stored Procedures.....please help me out...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Assigning server level role to database user using VB.NET
by
DileepkumarReddy
Question
28 Mar 2012
license:
CPOL
Hi,I want to assign server level roles (bulkadmin,dbcreator,diskadmin,Processadmin,sysadmin) to user through VB.NET Code...Any one help me out please....I am using system stored procedure "sys.sp_addsrvrolemember"...I am doing something like this..but couldnt do it..Dim...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Create table permission
by
DileepkumarReddy
Question
27 Mar 2012
license:
CPOL
Hi, I am creating a database through VB.NET code from a database level user and i want to create a table to it...I am getting exception as " There is already an object named 'xHawk' in the database.Cannot find the user 'test', because it does not exist or you do not have...
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
VB
VB.NET
designing template using VB.NET
by
DileepkumarReddy
Question
26 Mar 2012
license:
CPOL
Hi everyone,I want to create a sheet or utilty that contains database and it's contents(fields) on left hand side(say a section)...i want to give the facility to user to choose the fields...and datagridview should be populated with respected field...please help me out..thanks in advance...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Progress bar for crystal report
by
DileepkumarReddy
Question
23 Mar 2012
license:
CPOL
Hi,i want to display progress bar while crystal report is loading...how can i do that..help me out....
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
text box Re focus issue...
by
DileepkumarReddy
Question
21 Mar 2012
license:
CPOL
Hi,I have one form containing textboxes(City Code,CityName),suppose when i type 'a' in City Code textbox , a pop up window(Datagridview) will come Containing citycode starting with 'a'...problem is,when i type something ,focus is moving to pop up window...i want cursor to focus next to the ...
General Programming
»
Uncategorised Quick Answers
»
General
VB>NET
populating datagridview issue..
by
DileepkumarReddy
Question
21 Mar 2012
license:
CPOL
Hi,i have two text boxes....CityCode,CityNameData is..CityCode(A001,A002,A003...B001,B002,C001,C002...) like that..what i want is ,when i type 'A' in citycode textbox,all the city codes that starts with 'A' should come in pop up window(DataGridview)...please help me..
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
VB
VB.NET
sql query to fetch the records..
by
DileepkumarReddy
Question
19 Mar 2012
license:
CPOL
I have two columns..ClientCode AddressA002 RAHIM APARTMNET,GULZAR LANE,NEAR PETROL PUMP|Hyderabad|500001|Andhra|INDIAA002 RAHIM APARTMNET,GULZAR LANE,NEAR PETROL PUMP|Mumbai|400001|Maharashtra|INDIAC001 RAHIM APARTMNET,GULZAR LANE,NEAR PETROL...
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
sql query to find string between special Characters
by
DileepkumarReddy
Question
19 Mar 2012
license:
CPOL
Hi,I have a column named 'Address' of some database, in which Data is something like this...-- 'D.No 5-34,5th Road,sanjeevanagar|Cityname|Pincode|state|Country'-- 'dgfkj gdkh fghk|CityName|pincode|state|country'i want to fetch CityName to use it as a parameter ...please suggest...
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
Page 1 of 1
First
·
Prev
·
Next
·
Last
Advertise
|
Privacy
|
Mobile
Web04 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright ©
CodeProject
, 1999-2013
All Rights Reserved.
Terms of Use
Layout:
fixed
|
fluid