9,869,883 members (28,545 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*
30 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: Nayan Ambaliya
[x]
Web intelligence reports (WEBI)
by
Nayan Ambaliya
Question
13 May 2013
license:
CPOL
Dear all experts here... Current Scenario:Environment - Crystal Reports 9 - MS Access VBAI have some rpt (Crystal report) files sitting in the local directory.I have an Access VBA application.When I click a button named "Process" in the VBA application, the application runs those...
General Programming
»
Uncategorised Quick Answers
»
General
Reports
CrystalReports
WinForm
Display popup message if records not exists in asp.net C# (SEARCH)
by
Nayan Ambaliya
Answer
12 May 2013
license:
CPOL
Ranjith, It could be even simpler.Considering you have a label named: lblTotalRecords or something like that,look at the code below:protected void BtnSearch_Click(object sender, ImageClickEventArgs e) {con.Open();SqlCommand cmd = new SqlCommand("Select...
General Programming
»
Uncategorised Quick Answers
»
General
C#
ASP.NET
SqlServer
Display popup message if records not exists in asp.net C# (SEARCH)
by
Nayan Ambaliya
Answer
12 May 2013
license:
CPOL
Hey Ranjith, Label solution will be very simple.Format your page as below: (CSS does count on your look and feel)In your code behind:protected void SearchRecords(){ //code for connecting to the database and getting the results into DataTable //Assuming your...
General Programming
»
Uncategorised Quick Answers
»
General
C#
ASP.NET
SqlServer
Re: Need your opinion on querying data for presentation on winforms / web page and for reports
by
Nayan Ambaliya
Forum Message
12 May 2013
Thank you very much. I just needed a clarification for not under-estimating my decision over my superior. Thank you very much.
Database & Sysadmin
»
Database
Display popup message if records not exists in asp.net C# (SEARCH)
by
Nayan Ambaliya
Answer
12 May 2013
license:
CPOL
Hi, I would suggest to show a label just above the data grid displaying the number of records searched. Popups can be used while validating the input for search or submit forms.But if at all you want to display a popup if there are no records, you can use AjaxControlToolkit.Download...
General Programming
»
Uncategorised Quick Answers
»
General
C#
ASP.NET
SqlServer
Need your opinion on querying data for presentation on winforms / web page and for reports
by
Nayan Ambaliya
Forum Message
12 May 2013
Dear all, I require your opinion on what approach is good and/or practical for the following scenario. There is a web application which queries data from SQL server. For example: User
Database & Sysadmin
»
Database
Need your opinion on querying data for presentation on winforms / web page and for reports
by
Nayan Ambaliya
Forum Message
8 May 2013
Dear all, I require your opinion on what approach is good and/or practical for the following scenario. There is a web application which queries data from SQL server. For example:
General Programming
»
C#
Integrate a report developed by Sql Server Report builder in asp.net page
by
Nayan Ambaliya
Answer
7 May 2013
license:
CPOL
Hi, Please review the following:I have developed a report using New Report in Visual Studio 2008 (rdlc format) and Visual Studio Data Sources.this.reportViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;this.reportViewer.LocalReport.ReportPath =...
General Programming
»
Uncategorised Quick Answers
»
General
SQL
Server
Builder
Need opinion about an approach used to query data for presentation and for report
by
Nayan Ambaliya
Question
7 May 2013
license:
CPOL
Dear all, I require your opinion on what approach is good and/or practical for the following scenario.There is a web application which queries data from SQL server.For example: Users report to a manager1. The process by clicking a button is finding who reports to me (manager)2....
General Programming
»
Uncategorised Quick Answers
»
General
SQL
T-SQL
ms-sql-server
Viewing PDF in winforms
by
Nayan Ambaliya
Question
2 May 2013
license:
CPOL
Dear all, I am building a windows forms application where people can view PDF (preview). I am successfully able to locate a file on the local computer and preview this in the PDF viewer control.What I want to do is:My file is located on an internet location which you can point to...
General Programming
»
Uncategorised Quick Answers
»
General
Windows
Application
PDF
Forms
How to pass datetime parameter in where clause?
by
Nayan Ambaliya
Answer
1 May 2013
license:
CPOL
Hi, --Convert any date input to the stored procedure to datetime--Example:declare @tempStartDate datetimedeclare @tempEndDate datetimeselect @tempStartDate = convert(datetime, @InputStartDate)select @tempEndDate = convert(datetime, @InputEndDate)--write the query to...
General Programming
»
Uncategorised Quick Answers
»
General
Oracle
How to create online quiz in php with multiple options
by
Nayan Ambaliya
Answer
1 May 2013
license:
CPOL
Hi Rupal, Create a database with following tablesTable1: dbo.QuestionsQuestionID int (PK)QuestionText nvarchar(max)CorrectAnswerID int (FK)Table2: dbo.AnswersAnswerID int (PK)AnswerText nvarchar(max) QuestionID int (FK)Table3: dbo.AnswerOptionTypeOptionID...
General Programming
»
Uncategorised Quick Answers
»
General
PHP
MySQL
Winforms navigation options
by
Nayan Ambaliya
Question
1 May 2013
license:
CPOL
Dear all, Good morning..!!I am currently developing a windows forms business application.I am aware about the traditional Menu Bar as navigation option for this application. I want to know if people develop this windows forms navigation in any other way. I am reluctant to use the...
General Programming
»
Uncategorised Quick Answers
»
General
Design
Application
Navigation
WinFrom
Data communications - Winforms to database over the internet
by
Nayan Ambaliya
Answer
30 Apr 2013
license:
CPOL
Thanks everyone for the solutions...This has certainly opened up my direction..Thanks again..Cheers,Nayan
General Programming
»
Uncategorised Quick Answers
»
General
database
security
WebService
WinFrom
Data communications - Winforms to database over the internet
by
Nayan Ambaliya
Question
30 Apr 2013
license:
CPOL
Dear all, I have puzzled myself over data communications from winforms to the SQL server database. Here is the scenario:I am developing a windows application which I will be publishing via ClickOnce technology.Therefore, the client resides on user PC and the data will be...
General Programming
»
Uncategorised Quick Answers
»
General
database
security
WebService
WinFrom
SQL Query Issue
by
Nayan Ambaliya
Forum Message
22 May 2012
Dear all, I have this sort of weird question in terms of sql data and query. Consider the dataset below. I have this results in to a table variable (SQL 2008) EmailAddre
Database & Sysadmin
»
Database
In sql i want to trim the string
by
Nayan Ambaliya
Answer
18 Jan 2012
license:
CPOL
You should not be using SQL server to do this. SQL server is designed mainly for data operations and not data manipulations. The functionality is provided only to be used in instances where there is no external resources that could be used to do data manipulations or is much harder to do it...
General Programming
»
Uncategorised Quick Answers
»
General
SQL
VB
VB.NET
i want code for c# for connecting asp.net and sql
by
Nayan Ambaliya
Answer
18 Jan 2012
license:
CPOL
The simplest way of achieving this;using System.Data.SqlClient;using System.DataPage_Load(){ SQLConnection con = new SQLConnection(); SQLCommand cmd; SQLDataAdapter adap = new SQLDataAdapter(); DataTable ds = new DataTable(); con.connectionstring = "";...
General Programming
»
Uncategorised Quick Answers
»
General
C#
ASP.NET
SQL
database
how to transfer data from one table to another ?
by
Nayan Ambaliya
Answer
18 Jan 2012
license:
CPOL
Ideally, I would go for the above solution but in some instances you would want a redundant data set. In this scenario, What is the difference between dates within different products in tbl_future ? For example, consider the below data rows in tbl_future:1000 Product1 2011-01-01...
General Programming
»
Uncategorised Quick Answers
»
General
C#
SqlServer
ASP.Net-4.0
Getting null value but when restarting the application getting the values correctly
by
Nayan Ambaliya
Answer
18 Jan 2012
license:
CPOL
I am supposing;1. You are loading leave types in a leave management system.2. The leave types are stored in a look up table in the database3. For example, when your ApplyForLeave.aspx file or any other file loads up in the browser, you would like to populate the leave types.For this...
General Programming
»
Uncategorised Quick Answers
»
General
C#
.NET
Search my ecommerce database in asp.net
by
Nayan Ambaliya
Answer
19 Oct 2011
license:
CPOL
Product search By Title and By Manufacture is different from Product search by Categories; because I assume that you would have a list of categories which will be populated from the database (of course not to mention that each category would have an ID associated with it) and Title and...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
ComboBox_SelectedIndexChanged execute to seconde ComboBox
by
Nayan Ambaliya
Answer
19 Oct 2011
license:
CPOL
I would not be able to figure out the issue with the code given in your description but surely would tell you how to do it.Please follow the following steps:1. Load categories (from category table) in to the categories combo box I assume that you have a category ID in the table ...
General Programming
»
Uncategorised Quick Answers
»
General
C#
C#4.0
Probleam with combo box list item which connect to table in database
by
Nayan Ambaliya
Answer
19 Oct 2011
license:
CPOL
It seems that you are not handling the change event properly. From your description of the problem above, please try to make sure the following points.1. All the four combo boxes have different names in context of their Identity and Event Handlers (Selected Index Changed)2. Make sure...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Model Pop Up Extender In Ajax
by
Nayan Ambaliya
Answer
3 May 2011
license:
CPOL
Please be a little bit more descriptive about your questionAnyways, I am assuming the below scenarios1. You click a button on the .aspx page but the modal popup is now shown2. You have a button inside the panel which is shown when modal popup is active and that button when clicked does...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
Ajax
How to bring data from database and bind the gridview each time when user clicks paging in the gridview,instead of bring the whole records and binding at once
by
Nayan Ambaliya
Answer
3 May 2011
license:
CPOL
There are many ways you can do this. But it has some restrictions on the data. You can use the following manner provided the below conditions.Conditions:The data needs to have a chronological ID field within it.The process would be;1. The first time you call the database, return...
General Programming
»
Uncategorised Quick Answers
»
General
C#
.NET
Please Help Me , Google Problem ........
by
Nayan Ambaliya
Answer
3 May 2011
license:
CPOL
You will need to update your back links if you have a track of them. I would recommend to submit a new sitemap to Google where it will then crawl to and update the old pages.You can also wait for some time to let google automatically update the links. But you would still be carefull in...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
Asp.net button not firing on modal pop up extender
by
Nayan Ambaliya
Answer
3 May 2011
license:
CPOL
You will need a dummy button control to achieve this behaviour. Steps would be:1. Have your normal cancel button on the page2. Have a invisible dummy cancel button with the CSS Style as display:none (strictly not Visible="false")3. Have your popup panel on the page4. Have your modal...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
how to update columns in 1 table from 2 another different tables
by
Nayan Ambaliya
Answer
3 May 2011
license:
CPOL
You can achieve it in a following manner:UPDATE L2SET L2.AreaID = S2.AreaID, L2.Category = L3.CategoryFROM Line2 L2INNER JOIN Sheet2 S2 ON L2.gateID = S2.gateIDINNER JOIN Line3 L3 ON L3.gateID = S2.gateIDPlease let me...
General Programming
»
Uncategorised Quick Answers
»
General
Oracle
FormsAuthentication.SignOut Method and redirect
by
Nayan Ambaliya
Answer
3 May 2011
license:
CPOL
From what I understand from the question: you want the application to remember the authentication required page. If a user visits that page without authentication, the application redirects to the login page and after login, it redirects automatically to the area where the user is coming from....
General Programming
»
Uncategorised Quick Answers
»
General
C#2.0
ASP.NET
C#
Need help for run parameterized stored procedure in sql
by
Nayan Ambaliya
Answer
3 May 2011
license:
CPOL
I would recommend the following solution if your system is a complex one using many stored procedures and using it many times. 1. Use an object class which stores the stored procedure names of your database This will help you in future of not having any spelling mistakes in calling the...
General Programming
»
Uncategorised Quick Answers
»
General
C#
Page 1 of 1
First
·
Prev
·
Next
·
Last
Advertise
|
Privacy
|
Mobile
Web03 | 2.6.130513.1 | Last Updated 15 May 2013
Copyright ©
CodeProject
, 1999-2013
All Rights Reserved.
Terms of Use
Layout:
fixed
|
fluid