16,016,527 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Rajesh Pandya (Top 39 by date)
Rajesh Pandya
7-Mar-19 23:33pm
View
@MadMyche Thank you for the detailed answer. I will make sure HTML is correct. Thank you for your help.
Rajesh Pandya
1-May-18 1:30am
View
Please provide sample data and your expected out.
Rajesh Pandya
10-Apr-18 1:41am
View
Instead of "/" give the home page URL.
Rajesh Pandya
3-Apr-18 2:59am
View
For implement try catch in stored procedure check the below link:
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql
Rajesh Pandya
3-Apr-18 1:31am
View
You can use CTE, following link will be helpful:
https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-server-2005-common-table-expressions/
Rajesh Pandya
3-Apr-18 1:23am
View
Have you get any error when enter username and password? You have just mentioned "server not accepting" without knowing error nobody can help you.
Rajesh Pandya
26-Mar-18 8:41am
View
Have a look at following URL, may be it will help
URL: https://dba.stackexchange.com/questions/90033/how-do-i-drop-all-constraints-from-all-tables
Rajesh Pandya
12-Mar-18 4:36am
View
Add try catch in while loop code so if an error comes try-catch block will handle the error and loop will not break and it will continue to process next record
Rajesh Pandya
8-Mar-18 5:28am
View
Can you please explain your question in detail and also give detail regarding where you struck.
Rajesh Pandya
31-Jan-18 4:58am
View
May be following link will helpful to you:
https://silviomoreto.github.io/bootstrap-select/examples/
https://codepen.io/Rio517/pen/NPLbpP
Rajesh Pandya
30-Jan-18 6:29am
View
Is any error you get? Please explain your question in detail.
Rajesh Pandya
26-Jan-18 7:14am
View
You have given only table structure. What query you have tried? What error you have get? Please specify that.
Rajesh Pandya
26-Jan-18 7:00am
View
'BB' is your table name? If yes then that table is not exists in database and because of that it gives error "Invalid object name 'BB'".
If you have given alias as 'BB' then you need to specify table name and then alias name.
Rajesh Pandya
24-Jan-18 8:25am
View
Store the coalesce function value in variable and check if value is blank or null then assign the default value in the variable.
Rajesh Pandya
19-Jan-18 10:10am
View
Instead of storing image in database store image path in the database and use the path to show the image as per your requirement. Check the following link:
https://stackoverflow.com/questions/19529896/how-to-upload-image-and-save-path-to-database
Rajesh Pandya
19-Jan-18 10:09am
View
Deleted
Instead of storing image in database store image path in the database and use the path to show the image as per your requirement. Check the following link:
https://stackoverflow.com/questions/19529896/how-to-upload-image-and-save-path-to-database
Rajesh Pandya
19-Jan-18 6:38am
View
Is there any specific reason you want to store actual image in database instead of store reference to the image?
If you store store images in database it make database big.
You could store them as a BLOB. Following link may be helpful for you:
http://forum.codecall.net/topic/40286-tutorial-storing-images-in-mysql-with-php/
Rajesh Pandya
11-Jan-18 7:11am
View
What is your table structure? How many columns in the table?
Rajesh Pandya
10-Jan-18 1:11am
View
You can use above logic just remove the for loop and use if condition like below:
if(tablerowcount = 5)
{ sTableData = 'specify data you want show'; }
else if(tablerowcount = 20)
{ sTableData = 'specify data you want show';
sTableData = sTableData + 'specify data you want show';
}
Like above add as many condition as required for create div based on row count.
Rajesh Pandya
9-Jan-18 6:49am
View
May be following link will be helpful:
https://www.codeproject.com/Articles/390952/Stunning-popup-window-control-using-jQuery
Rajesh Pandya
1-Dec-17 13:24pm
View
On button click you want to show the form for data entry?
Rajesh Pandya
1-Dec-17 13:18pm
View
Share the query in which you have used join
Rajesh Pandya
31-Oct-17 13:06pm
View
I use native code for that.
Rajesh Pandya
31-Oct-17 12:53pm
View
currently my sample table have only one row.
Rajesh Pandya
31-Oct-17 5:20am
View
Yes it won't impact the data..but for parse the json it need to remove the escaping character
Rajesh Pandya
31-Oct-17 5:01am
View
I have checked outout in postman and in ios device.
Rajesh Pandya
31-Oct-17 5:01am
View
In IOS and Android
Rajesh Pandya
19-Jul-17 2:52am
View
You cannot directly connect/communication with the client machine hardware using web application. But here's some approach you can try: Use ActiveX component or Create a Windows Service(WCF, WebAPI etc..).
It communication something like: Web Application <---> ActiveX component/Windows Service <---->Hardware
Rajesh Pandya
2-Dec-15 8:05am
View
Use two separate button for do this. On add new button click use javascript function and in javascript function call another button click and do the code behinde stuff in that click event and also use updatepanel with that. If you need sample code then feel free to ask me
Rajesh Pandya
2-Dec-15 7:44am
View
Instead of "#<%=grdorders.ClientID%>" use static id and then try. May be it works.
Rajesh Pandya
4-May-15 1:41am
View
you can use below code for refresh the updatepanel
UpdatePanel1.Update()
where "UpdatePanel1" is you updatepanel id.
Thanks
Rajesh Pandya
4-May-15 1:13am
View
Check if any API or web service it available for that.
Rajesh Pandya
4-Jan-13 23:35pm
View
Please try following. Hope it will work for you.
CREATE TABLE [dbo].[Pit_Output](
[League_ID] [nvarchar](7) NOT NULL,
[Team_ID] [nvarchar](7) NOT NULL,
[Season] [nvarchar](4) NOT NULL,
[Session] [nvarchar](1) NOT NULL,
[Player_ID] [int] NOT NULL,
[Player] [nvarchar](64) NULL,
[W] [int] NOT NULL, [L] [int] NULL,
[ERA] [float] NULL, [G] [int] NULL,
[GS] [int] NULL,
[CG] [int] NULL,
[Sho] [int] NULL,
[Sv] [int] NULL,
[BS] [int] NULL,
[IP] [float] NULL,
[TBF] [int] NULL,
[H] [int] NULL,
[R] [int] NULL,
[ER] [int] NULL,
[HR] [int] NULL,
[BB] [int] NULL,
[IBB] [int] NULL,
[HBP] [int] NULL,
[WP] [int] NULL,
[BK] [int] NULL,
[SO] [int] NULL,
[SF] [int] NULL,
[SH] [int] NULL,
[upsize_ts] [timestamp] NULL,
CONSTRAINT PK_Pit_Output PRIMARY KEY(League_ID, Team_ID)
)
------------------------------------------------------------------------
CREATE TABLE [dbo].[Teams](
[Team_ID] [nvarchar](7) NOT NULL,
[Team City] [nvarchar](64) NULL,
[Team Name] [nvarchar](64) NULL,
[League_ID] [nvarchar](7) NOT NULL,
[Franchise ID] [nvarchar](7) NULL,
[Short] [nvarchar](8) NULL,
CONSTRAINT [PK_Teams_1] foreign key(League_ID, Team_ID) references Pit_Output(League_ID, Team_ID)
)
Rajesh Pandya
4-Jan-13 2:20am
View
Can you please paste here you sample code using which you are trying to create both table.
Rajesh Pandya
3-Jan-13 2:00am
View
You can create foreign key using composite primary key. Only thing is that you need to use same column combination which you use to define composite primary key.
Rajesh Pandya
2-Jan-13 0:17am
View
Welcome. It's depend on the requirement whether you use single column primary key or composite primary key. For insure unique value in your column you can use unique key constraint for your column in which you want to store unique value.
Rajesh Pandya
31-Dec-12 6:06am
View
You need online database connection string to connect your website with your database. For get the online database connection string you need to login into your hosting control panel and you get it from there or else contact you hosting support and ask for the online database connection string.
Rajesh Pandya
31-Dec-12 5:37am
View
In your "Team" table column "Team_Id" is primary key? If no, then first set the primary key for "Team_ID" column in Team table and then try again.
Rajesh Pandya
12-Dec-12 2:20am
View
Can you please post here your sample code in which you are getting above issue.
Show More