16,012,223 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 Animesh Datta (Top 200 by date)
Animesh Datta
26-Apr-19 20:59pm
View
Glad to help you
Animesh Datta
26-Apr-19 9:49am
View
what the datetime format you are passing in @SearchVal when @SearchBy = '2'
Animesh Datta
5-Nov-18 5:05am
View
and your problem is ...
Animesh Datta
9-Aug-18 4:09am
View
My 5! for your effort .
Animesh Datta
17-Jul-18 2:57am
View
have you tried something ?
put your effort
Animesh Datta
31-May-18 4:24am
View
you question is not clear . Transfer data by query or script ?
Animesh Datta
27-Mar-18 6:26am
View
why you need the solution without pivot and unpivot function
Animesh Datta
23-Mar-18 1:56am
View
Put your complete C# code
Animesh Datta
7-Mar-18 0:26am
View
My 5! Sir
Animesh Datta
13-Feb-18 6:24am
View
have you taken DataGridViewImageColumn in your datagrdiview control
Animesh Datta
13-Feb-18 2:37am
View
so what is your problem in the code ? where are you stuck ?
Animesh Datta
13-Feb-18 2:34am
View
put your store procedure in the question.
Animesh Datta
7-Feb-18 0:05am
View
My 5!
Animesh Datta
25-Jan-18 7:06am
View
what out put you are getting ?
Animesh Datta
17-Jan-18 4:36am
View
After adding/deleting the rows in the DataTable you must save the changes
by dt1.AcceptChanges()
Animesh Datta
15-Jan-18 1:15am
View
5!
Animesh Datta
20-Sep-17 6:20am
View
Check why the value of Session["login"] is empty or null. Put breakpoint and debug it.
Animesh Datta
15-Sep-17 6:04am
View
my 5!
Animesh Datta
15-Sep-17 6:02am
View
glad to help you....
Animesh Datta
16-Jun-17 7:08am
View
From my opinion , do not call LoadSerial() function for every time when new row adds.Instead , you may call LoadSerial() for first time when record fetched from database and then increase the slno for new record which are inserting dynamically.
Animesh Datta
16-Jun-17 6:41am
View
For existing record the slno should start from 2 as new record already inserted at top position.
Animesh Datta
20-Mar-17 0:44am
View
5 for explanation.
Animesh Datta
8-Mar-17 2:46am
View
provide your sql pivot query , so that we can find your mistake.
Animesh Datta
8-Nov-16 2:31am
View
how do you know that BCC mail is not going ? does your bcc emailid exists ?
Animesh Datta
8-Nov-16 1:40am
View
if duplicate value exists then count(*)> 1 not count(*)<1
Animesh Datta
20-Oct-16 6:37am
View
why you want only "WeitronExcel" ? is there any logic behind your requirement ?
Animesh Datta
20-Oct-16 6:26am
View
Thank You !
Animesh Datta
20-Oct-16 6:24am
View
Deleted
Thank You!
Animesh Datta
24-Aug-16 1:33am
View
Good explanation . My 5!
Animesh Datta
18-Aug-16 6:53am
View
:)
Animesh Datta
12-Aug-16 8:33am
View
Thanks
Animesh Datta
12-Aug-16 5:57am
View
could you post the code that you have tried ?
Animesh Datta
12-Aug-16 5:34am
View
Thank You
Animesh Datta
12-Aug-16 3:20am
View
Glad to help you .
Please check below link
http://www.codeproject.com/Articles/265371/Common-Table-Expressions-CTE-in-SQL-SERVER
Animesh Datta
10-Aug-16 1:19am
View
My 5
Animesh Datta
8-Aug-16 1:19am
View
Have you debug it ? is there any exception occur ?
Animesh Datta
5-Aug-16 1:30am
View
have to debug your code ? any exception occurs ? and what "PathsTo" contains ?
Animesh Datta
4-Aug-16 7:20am
View
just delete the saved userid and passwords from the web browser's password store and try .
Animesh Datta
4-Aug-16 6:56am
View
My 5!
Animesh Datta
4-Aug-16 5:25am
View
have you include below library
<script src="http://www.google.com/jsapi" type="text/javascript"></script>
Animesh Datta
3-Aug-16 8:12am
View
First put a break point in web method and check whether the break point is reaching or not . if not then paste the code where you are passing dropdown selected value using ajax method.
Animesh Datta
3-Aug-16 7:29am
View
put your webmethod code by improve the question .
Animesh Datta
3-Aug-16 7:10am
View
but where is the problem with "FruitName" column ?
Animesh Datta
3-Aug-16 4:10am
View
why you want this type of approach ?
Animesh Datta
3-Aug-16 2:43am
View
Then go for second option that i mentioned in my answer .
Animesh Datta
25-Jul-16 5:47am
View
My 5!
Animesh Datta
25-Jul-16 3:25am
View
Glad to help you .
If your problem is solved then close the discussion by accepting the answer.
Animesh Datta
18-Jul-16 2:50am
View
http://www.codeproject.com/Articles/17953/ASP-NET-CheckBox-Command-in-DataView-or-Repeater
Animesh Datta
18-Jul-16 1:41am
View
have you set 'AutoPostBack' property of txtSearchName to True ?
Animesh Datta
15-Jul-16 2:44am
View
Post full code
Animesh Datta
8-Jul-16 6:40am
View
My 5!
Animesh Datta
21-Jun-16 7:16am
View
what is the problem ?
Animesh Datta
30-May-16 1:16am
View
my 5!
Animesh Datta
30-May-16 1:00am
View
my 5!
Animesh Datta
18-May-16 8:42am
View
what do you mean by "return it to the mvc controller with all parameters" ?
Animesh Datta
17-May-16 8:20am
View
if your problem solved then accept the answer so that it will not appear in unanswered list
Animesh Datta
17-May-16 7:31am
View
You simple call it at bottom after adding parameters
cmd.Parameters.AddWithValue("@PageSize", pageSize);
cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
cmd.Parameters.AddWithValue("@SearchTerm", searchQuery.ToLower().Trim());
//call here
int recordcount= (int)cmd.ExecuteScalar();
Animesh Datta
16-May-16 8:30am
View
what error comes ?
Animesh Datta
13-May-16 3:54am
View
Refer :
Link1
Link2
Animesh Datta
11-May-16 5:38am
View
Thanks Sir ..
Animesh Datta
11-May-16 5:37am
View
whatever you use table or div , you must use loop and then append each element .
Animesh Datta
11-May-16 3:45am
View
you could use a table within div and then loop through each json objects and append one by one row as mentioned in reference link
Animesh Datta
11-May-16 1:31am
View
have you tried any thing ?
Animesh Datta
11-May-16 1:22am
View
yes ..that's my mistake, explanation must needs for every solution ...thanks for the suggestion
Animesh Datta
10-May-16 5:37am
View
you are getting the value by query , then what the reason to set the focus by javascript ...
to set the focus by javascript use
document.getElementById("id").focus();
Animesh Datta
26-Apr-16 5:38am
View
My 5!
Animesh Datta
26-Apr-16 0:51am
View
Thanks
Animesh Datta
19-Apr-16 1:21am
View
Gr8 answer . My 5!
Animesh Datta
19-Apr-16 1:08am
View
That is different issue , The error message means you're comparing two things (this equals that, or this less than that, etc.) that are of two different, and incompatible types (comparing a number to a string, for example).
Animesh Datta
13-Apr-16 8:49am
View
Thanks :)
Animesh Datta
16-Mar-16 4:24am
View
to get list of all foreign keys referencing a given table in SQL Server you can do this
EXEC sp_fkeys 'TableName'
and then check what it defines .
Animesh Datta
16-Mar-16 1:30am
View
Deleted
and your question is ?
Animesh Datta
10-Mar-16 7:12am
View
what is your issue ?
Animesh Datta
10-Mar-16 6:30am
View
Never forget Google your friend . If you search properly then you should get right answer .not an issue but The above links explain enough for your basic requirement .
Animesh Datta
10-Mar-16 4:57am
View
Hello ,
Here 's' is an Abbreviations of datepart . for more information check
https://msdn.microsoft.com/en-us/library/ms186819.aspx .
If your problem is solved then Accept the answer.
Animesh Datta
9-Mar-16 5:55am
View
Integer is defined as :
Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). Storage size is 4 bytes.
To avoid this error, if you have a value in your VARCHAR column that is not within the range of an integer data type, convert the value into BIGINT
Animesh Datta
9-Mar-16 3:15am
View
5ed!
Animesh Datta
8-Mar-16 0:14am
View
My 5!
Animesh Datta
3-Mar-16 5:43am
View
perfect answer .
Animesh Datta
17-Dec-15 1:40am
View
very good explanation .
Animesh Datta
16-Dec-15 0:41am
View
what have u tried to get the out put ?
Animesh Datta
16-Dec-15 0:30am
View
Glad to help you dear ..
Animesh Datta
15-Dec-15 4:41am
View
the above code runs successfully . I can easily get the checkbox id from the above code . no error found .
Animesh Datta
15-Dec-15 2:46am
View
What have you tried ? where is your problem ?
Animesh Datta
15-Dec-15 2:12am
View
give proper tag for your question . Is it C# or Sql
Animesh Datta
15-Dec-15 1:42am
View
Thank You
Animesh Datta
15-Dec-15 1:20am
View
Have u implement below line of code to get the CheckBox Control inside gridview
CheckBox checks = (CheckBox)grdno.Rows[i].FindControl("gridviewtrans");
Animesh Datta
15-Dec-15 1:06am
View
I check the code and it runs fine , check whether 'dtpack' contains any data or not .
Animesh Datta
14-Dec-15 5:58am
View
put your code
Animesh Datta
13-Dec-15 9:07am
View
Thank You
Animesh Datta
11-Dec-15 2:40am
View
you must use check the EmployeeId is null or not before it set .
EmployeeId= e.EmployeeID ==null ? 0 : e.EmployeeID
Animesh Datta
9-Dec-15 1:13am
View
what have u tried ?
Animesh Datta
7-Dec-15 2:53am
View
put your code for better understand
Animesh Datta
5-Nov-15 2:27am
View
what have u tried ?
Animesh Datta
4-Nov-15 6:17am
View
Glad to help you .
Animesh Datta
4-Nov-15 6:00am
View
put the DropDownlist inside Html.BeginForm in View
Animesh Datta
8-Oct-15 4:11am
View
as you are using List hence it is showing one by one . what do you mean by 3 row 3 column ?
Animesh Datta
16-Sep-15 1:03am
View
what the error you are getting while run the executable exe ?
Animesh Datta
10-Sep-15 4:30am
View
is there any error ? use breakpoint and debug .
Animesh Datta
8-Sep-15 12:29pm
View
Thank You Sir .
Animesh Datta
3-Sep-15 1:40am
View
glad to help you :)
Animesh Datta
20-Aug-15 7:00am
View
glad to help you :)
Animesh Datta
14-Aug-15 1:03am
View
5!
Animesh Datta
12-Aug-15 5:55am
View
what error you are getting ?
Animesh Datta
10-Aug-15 7:05am
View
if you don't want to join then you can get the result by adding the second table's data one by one by with first datatable (assuming the column structure of both tables are same) . lastly , set the updated datatable as DataSouce.
Animesh Datta
10-Aug-15 3:47am
View
show your code
Animesh Datta
7-Aug-15 2:01am
View
glad to help you .. :)
Animesh Datta
29-Jul-15 9:01am
View
Perfect one . My 5!
Animesh Datta
23-Jul-15 5:14am
View
5!
Animesh Datta
23-Jul-15 5:14am
View
My 5!
Animesh Datta
22-Jul-15 7:15am
View
Thanks
Animesh Datta
22-Jul-15 5:30am
View
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
con.Open();
int id1= Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["id"].ToString());
SqlCommand cmd = new SqlCommand("sp_neetha", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id",id1);
cmd.Parameters.AddWithValue("@school", txtschool.Text);
cmd.Parameters.AddWithValue("@office", txtoffs.Text);
cmd.Parameters.AddWithValue("@flag", "delete");
int result = cmd.ExecuteNonQuery();
con.Close();
if (result == 1)
{
grid();
}
}
Animesh Datta
22-Jul-15 4:30am
View
yes , you have to pass all the parameters value as you have declared all parameters in your sp without assigning null , hence error will be shown if you does not pass their value
Animesh Datta
22-Jul-15 2:31am
View
all objects means other parameters @school, @flag,@office
cmd.Parameters.AddWithValue("@school", txtschool.Text);
cmd.Parameters.AddWithValue("@office", txtoffs.Text);
cmd.Parameters.AddWithValue("@flag","delete");
Animesh Datta
22-Jul-15 2:03am
View
In the row deleting methoid change from
cmd.Parameters.AddWithValue("@id", DbType.Int32);
to
cmd.Parameters.AddWithValue("@id", txtid.Text); and do this for all other parameters
Animesh Datta
22-Jul-15 1:56am
View
what it shows
Animesh Datta
9-Jul-15 5:46am
View
glad to help u
Animesh Datta
9-Jul-15 5:00am
View
here imagedata means byte array data from database.
Animesh Datta
9-Jul-15 4:54am
View
to set the value of RadBinaryImage used DataValue property .
RadBinaryImageobject.DataValue = (byte[])(imagedata);
Animesh Datta
9-Jul-15 4:02am
View
first let me know What datatype are you using to store the image and where you want to show the retrieved image ? in picturebox ?
Animesh Datta
9-Jul-15 3:40am
View
what are you getting ?
Animesh Datta
8-Jul-15 5:56am
View
I modify the answer . check
Animesh Datta
8-Jul-15 5:08am
View
what error came ?
Animesh Datta
7-Jul-15 12:19pm
View
glad to help u .
Animesh Datta
7-Jul-15 12:06pm
View
Now check.
Animesh Datta
7-Jul-15 11:51am
View
I modified my answer . check
Animesh Datta
1-Jul-15 11:17am
View
My 5!
Animesh Datta
1-Jul-15 2:14am
View
glad to help you..
Animesh Datta
1-Jul-15 1:35am
View
not clear
Animesh Datta
1-Jul-15 1:27am
View
glad to help you .. :)
Animesh Datta
1-Jul-15 1:26am
View
any error are you getting ?
Animesh Datta
1-Jul-15 0:56am
View
You have not declared "BkCode" in your program . hence it is showing error .
Animesh Datta
18-Jun-15 2:12am
View
what have u tried ?
Animesh Datta
11-Jun-15 4:41am
View
check whether there is any data exists or not .
Animesh Datta
11-Jun-15 3:21am
View
check whether crystal report components are installed or not
Animesh Datta
28-Jan-15 4:55am
View
if its works for you then please accept the answer.
Animesh Datta
27-Jan-15 6:22am
View
welcome
Animesh Datta
25-Jan-15 5:44am
View
Please go through this link
http://www.codeproject.com/Answers/683853/Using-DataGridViewComboBoxColumn-and-its-value-in?arn=0#answer1
Animesh Datta
16-Jan-15 2:46am
View
AutoComplete used to search by Initial letter , if you want to implement autocomplete using LIKE operator then read this article . hope this helps you
http://benjsoft.blogspot.in/2011/01/winforms-implementing-autocomplete.html
Animesh Datta
16-Jan-15 2:07am
View
change it to SuggestAppend and check .
Animesh Datta
16-Jan-15 1:48am
View
what have u set the AutoCompleteMode ?
Animesh Datta
28-Nov-14 2:21am
View
simple and clear . My 5!
Animesh Datta
28-Nov-14 2:21am
View
My 5!
Animesh Datta
29-Oct-14 1:53am
View
There is no problem in visual studio .Try passing 1 instead of "id_column". I think the problem is in your column value .First Check that the "id_book" is 1 from your code behind .
Animesh Datta
27-Oct-14 5:21am
View
Welcome dear .Please accept the answer if the problem is solved.
Animesh Datta
27-Oct-14 3:54am
View
Have you gone through the article ? It is clearly written that
PAGE_SIZE is the total number of records displayed on each page . Here you must set it to 1 . I suggest you to read the article carefully and then implement according to your requirement.
Animesh Datta
20-Oct-14 6:28am
View
Then what language you are using ?
Animesh Datta
9-Oct-14 3:25am
View
I would suggest you to follow below link to save and retrieve image from database
http://www.codeproject.com/Tips/465950/Why-do-I-get-a-Parameter-is-not-valid-exception-wh
Animesh Datta
9-Oct-14 3:16am
View
Where have you saved the image ? in directory or in db ?
Animesh Datta
9-Oct-14 2:58am
View
My 5!
Animesh Datta
19-Sep-14 7:33am
View
glad to help you . please accept the solution if it works
Animesh Datta
19-Sep-14 6:44am
View
then what is the issue now ?and what you exactly want from the above?
Animesh Datta
18-Sep-14 5:20am
View
what your expected output ?
Animesh Datta
10-Sep-14 7:34am
View
describe your problem.
Animesh Datta
4-Sep-14 1:12am
View
i found one solution in this link
http://www.codeproject.com/Questions/545595/Theplusmaximumplusreportplusprocessingplusjobsplus
Animesh Datta
3-Sep-14 2:16am
View
could you explain what type of exception you are getting ?
Animesh Datta
3-Sep-14 1:49am
View
Hello Mohi , in my machine i got the above path as i am using crystal report version 2008 .and i already said the path is changed depending upon crystal version .so , please make a search for MaxNumOfRecords in ths "Software" folder . you may also use "Find" option in registry . just try it and let me know
Animesh Datta
3-Sep-14 1:26am
View
what you have found ?
Animesh Datta
2-Sep-14 7:21am
View
welcome
Animesh Datta
29-Aug-14 7:26am
View
just download the code ,run and check
Animesh Datta
29-Aug-14 6:24am
View
if your problem is solved then accept the answer
Animesh Datta
21-Aug-14 3:01am
View
The above example is winform not WPF. please read the question.
Animesh Datta
14-Aug-14 3:58am
View
please put your previous result set and also explain what you want ?
Animesh Datta
14-Aug-14 0:38am
View
thank you Sir
Animesh Datta
8-Aug-14 3:11am
View
which error ?
Animesh Datta
6-Aug-14 3:54am
View
my 5+
Animesh Datta
5-Aug-14 7:20am
View
try this link
https://support.winhost.com/KB/a657/changing-the-default-aspnet-trust-level.aspx
Animesh Datta
5-Aug-14 6:58am
View
have you set the Trust level in web config ?
Animesh Datta
5-Aug-14 6:38am
View
remove the toolkitscriptmanager from your code and clean the solution then drag & drop from toolbox .and try.
Animesh Datta
5-Aug-14 6:17am
View
check
http://www.codeproject.com/Questions/675968/Unable-to-load-one-or-more-of-the-requested-types
Animesh Datta
5-Aug-14 6:16am
View
Deleted
<configsections>
<sectiongroup name="system.web.extensions">
Animesh Datta
5-Aug-14 6:15am
View
Deleted
configsections>
<sectiongroup name="system.web.extensions">
Animesh Datta
5-Aug-14 6:15am
View
Deleted
<configsections>
<sectiongroup name="system.web.extensions">
Animesh Datta
5-Aug-14 6:00am
View
<configsections>
put this in web config file
<sectiongroup name="system.web.extensions">
type="System.Web.Configuration.SystemWebExtensionsSectionGroup,
System.Web.Extensions, Version=3.5.0.0, Culture=neutral,
PublicKeyToken=31BF3856AD364E35">
Animesh Datta
27-Jun-14 0:43am
View
very good explanation Sir . thank you . My +5.
Animesh Datta
19-Jun-14 9:47am
View
here Tables[0] means , the first table of the dataset .
Animesh Datta
16-Jun-14 9:28am
View
what have you tried ?
Animesh Datta
16-Jun-14 6:20am
View
provide your code
Animesh Datta
16-Jun-14 6:17am
View
are you using crystal report ?
Animesh Datta
6-Jun-14 1:00am
View
my 5!
Animesh Datta
31-May-14 11:58am
View
Deleted
your following article is perfect, no problem is there , please compare your code with that code , i think there must be something missing . try to debug the code and find the issue .
Animesh Datta
31-May-14 11:57am
View
your following article is perfect, no problem is there , please compare your code with that code , i think there must be something missing. try to debug the code and find the issue .
Animesh Datta
30-May-14 8:58am
View
the above example will get the all data from your Table (inside database) and show it in crystal report . check the table is blank or not.
Animesh Datta
30-May-14 8:40am
View
Deleted
r u doing a winform application ?
Animesh Datta
30-May-14 8:03am
View
what problem then showing ?
Animesh Datta
30-May-14 7:31am
View
What error you are getting ?
Animesh Datta
30-May-14 7:27am
View
This is not a good question . improve your question.
Animesh Datta
30-May-14 7:16am
View
Try to follow what KARTHIK said. You must create one method in the class which will accept the object of DataGridView . now make the changes in that object where the data is showing .
Animesh Datta
30-May-14 7:09am
View
Deleted
you must use Constructor. when you call that class then you must pass the form class's Datagridview object . Have to tried something like this ?
Animesh Datta
30-May-14 5:10am
View
what is the exact problem ?
Animesh Datta
30-May-14 3:39am
View
yes Ajith ...that was my mistake . You are right , at that time
second part must be compared with empty string
Animesh Datta
30-May-14 3:32am
View
thanks Ajith
Animesh Datta
30-May-14 3:15am
View
you are welcome . please accept the answer .
Animesh Datta
30-May-14 2:49am
View
what is your datetime format ?
Animesh Datta
30-May-14 2:49am
View
Deleted
whatis is your datetime format ?
Animesh Datta
30-May-14 2:24am
View
what is the problem ?
Animesh Datta
30-May-14 2:15am
View
here the question is tagged for C#.Net . and you gave the answer in SQl
Animesh Datta
30-May-14 1:41am
View
you may follow this link
http://www.codeproject.com/Tips/334400/Concatenate-many-rows-into-a-single-text-string-us
this will help you to concatenate many rows in a single row.
Animesh Datta
30-May-14 1:29am
View
Reason for my vote of 5 \n Nice one
Animesh Datta
29-May-14 9:11am
View
Put the Panel inside the ContentTemplate of UpdatePanel . other wise it will not work .
check this link
http://www.dotnetfox.com/articles/updatepanel-with-triggers-in-Asp-Net-1090.aspx
Show More