Comments by Animesh Datta

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

Animesh Datta 5-Aug-14 6:15am View

Deleted

configsections>
<sectiongroup name="system.web.extensions">

Animesh Datta 5-Aug-14 6:15am View

Deleted

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

Comments by Animesh Datta (Top 200 by date)