Comments by Santhosh Kumar Jayaraman

Santhosh Kumar Jayaraman 2-Aug-13 4:46am View

Reason for my vote of 5 \n Good one

Santhosh Kumar Jayaraman 31-Jul-13 1:35am View

Reason for my vote of 4 \n Not new, but comments will help for the beginners to easily understand

Santhosh Kumar Jayaraman 22-Jul-13 23:52pm View

Reason for my vote of 5 \n Another Nice one by master.

Santhosh Kumar Jayaraman 26-Mar-13 1:04am View

Yes it means you are creating object of B with reference to A. If you want to create object of B, you have to use B obj=new B();

Santhosh Kumar Jayaraman 26-Mar-13 0:58am View

Then declare
class B as child class
like this
class a
{

}
class b:A
{

}

Santhosh Kumar Jayaraman 4-Feb-13 7:22am View

please check my query in the solution. it will work.

select name,email from empl where fairmate_user='yes' and email not in
(SELECT distinct(empl.email) FROM empl INNER JOIN User_log ON empl.name
= User_log.user_name where Convert(datetime,sign_in,103) BETWEEN '2013-01-01' and '2013-01-01'

Santhosh Kumar Jayaraman 4-Feb-13 7:21am View

am telling you again, try with the query in my solution.

Santhosh Kumar Jayaraman 4-Feb-13 7:20am View

I believe you are still using wrong date format

Santhosh Kumar Jayaraman 4-Feb-13 7:17am View

Is this query didnt work?
select name,email from empl where fairmate_user='yes' and email not in
(SELECT distinct(empl.email) FROM empl INNER JOIN User_log ON empl.name
= User_log.user_name where Convert(datetime,datecol,103) BETWEEN '2013-01-01' and '2013-01-01'

What is the error you are getting?

Santhosh Kumar Jayaraman 4-Feb-13 7:14am View

updated the solution with answer for your query.try that

Santhosh Kumar Jayaraman 4-Feb-13 7:13am View

just change the date format in your query.

Instead of 01/01/2013 try '2013-01-01'

Santhosh Kumar Jayaraman 4-Feb-13 7:12am View

Have you tried my table, insert and query?

Santhosh Kumar Jayaraman 4-Feb-13 0:09am View

I believe you didnt get compiler error. It would be a run time error which is different than what you had earlier.
yes thats right.Thats because you have 5 columns in the first select statement and only 4 columns in the except and Union statements, you are missing one column

Santhosh Kumar Jayaraman 1-Feb-13 7:40am View

But where you assigning it to mailmessage.to? Dont you see that you are missing it?

Santhosh Kumar Jayaraman 1-Feb-13 5:32am View

Not with EF

Santhosh Kumar Jayaraman 1-Feb-13 4:25am View

it doesnt matter right? Wherever you are going to bind this datatable to a control, just filter only columns2 and columns3.If its a gridview, just bind the columns to those 2 columns

Santhosh Kumar Jayaraman 1-Feb-13 1:37am View

Please be more clear

Santhosh Kumar Jayaraman 1-Feb-13 1:36am View

updated the solution.please check

Santhosh Kumar Jayaraman 1-Feb-13 1:20am View

this property will give you length..no arguments required. Like this
int sizeinbytes=fileUpload1.FileBytes.Length;

Santhosh Kumar Jayaraman 1-Feb-13 0:57am View

try the updated answer

Santhosh Kumar Jayaraman 1-Feb-13 0:41am View

ya welcome

Santhosh Kumar Jayaraman 1-Feb-13 0:33am View

You should accept solution1 as accepted answer instead of yours

Santhosh Kumar Jayaraman 31-Jan-13 6:08am View

what format you want?

Santhosh Kumar Jayaraman 31-Jan-13 2:34am View

192.168.22.136 is your server name

Santhosh Kumar Jayaraman 31-Jan-13 1:03am View

I have added for c# code also

Santhosh Kumar Jayaraman 29-Jan-13 6:14am View

add autopostback=true for dropdown

Santhosh Kumar Jayaraman 8-Jan-13 9:04am View

check my solution

Santhosh Kumar Jayaraman 8-Jan-13 8:58am View

I believe

You want to check table already exists in the schema
if exists, then check whether values exists else insert.
If table is not there in schema, create and insert table, right?

check solution 1

Santhosh Kumar Jayaraman 8-Jan-13 1:05am View

check solution 3

Santhosh Kumar Jayaraman 6-Nov-12 2:37am View

Why do you want to find duplicate. If you want it with duplicates, then the above query wont work for you, because am taking out distinct salaries

Santhosh Kumar Jayaraman 2-Nov-12 7:47am View

Please be clear, how you want the output?

Santhosh Kumar Jayaraman 10-Oct-12 6:12am View

its nothing, you can write strconnect=string.Format(("Provider=Microsoft.Jet.OLEDB.4.0;"
"Data Source=C:\\DatabasePath\\DBSpreadSheet.xls;"
"Extended Properties=\"\"Excel 8.0;HDR=Yes;\"\";");

Santhosh Kumar Jayaraman 10-Oct-12 2:22am View

you want to do sort or filter?

Santhosh Kumar Jayaraman 9-Oct-12 3:25am View

I didnt get your question

Santhosh Kumar Jayaraman 9-Oct-12 1:20am View

also u missed closing bracket next to @Rate NUMERIC(19,9)

Santhosh Kumar Jayaraman 9-Oct-12 1:11am View

try this
CREATE FUNCTION ufn_SimpleInterest (@Principal NUMERIC(19,4), @TimePeriod NUMERIC(19,2), @Rate NUMERIC(19,9))
RETURNs INT
AS
BEGIN
DECLARE @SimpleInterest NUMERIC(19,4)
SELECT @SimpleInterest = ( @Principal * @TimePeriod * @Rate) / 100
RETURN @SimpleInterest
END

Santhosh Kumar Jayaraman 8-Oct-12 3:24am View

You got the solution?

Santhosh Kumar Jayaraman 4-Oct-12 3:43am View

welcome

Santhosh Kumar Jayaraman 4-Oct-12 2:18am View

is that working?

Santhosh Kumar Jayaraman 4-Oct-12 1:44am View

updated the solution.Check now

Santhosh Kumar Jayaraman 27-Sep-12 6:43am View

give some examples or output for your scenario

Santhosh Kumar Jayaraman 27-Sep-12 6:13am View

you are welcome

Santhosh Kumar Jayaraman 27-Sep-12 6:06am View

You need to check this
http://msdn.microsoft.com/en-us/library/aa258244(v=sql.80).aspx

Santhosh Kumar Jayaraman 27-Sep-12 1:14am View

try my updated solution now.
;With Cte
as
(select t1.* from tm t1
inner join tm t2 on t1.empid=t2.empid and convert(char(10), t1.[savedate], 111)=convert(char(10), t2.[savedate], 111)
where DATEPART(hh, t1.[savedate])>=9 and DATEPART(hh, t2.[savedate])<9)
select * from tm where tm.empid not in (select empid from Cte where convert(char(10), tm.[savedate], 111)=convert(char(10), cte.[savedate], 111))

Santhosh Kumar Jayaraman 26-Sep-12 11:23am View

welcome..

Santhosh Kumar Jayaraman 26-Sep-12 11:15am View

yes thats to get only hour from the datetime. SInce its for everydate, we need to code it in generic way to extract only hour from the datetime field. so i used datetime to check entries made after 9 but not before 9

Santhosh Kumar Jayaraman 26-Sep-12 3:33am View

You are asking me?

Santhosh Kumar Jayaraman 26-Sep-12 3:22am View

Dont forget to use Autopostback=true for the textbox in aspx

Santhosh Kumar Jayaraman 26-Sep-12 2:54am View

OK sorry.I didnt see you were using aspnet.. Use textchanged event and write the same method
tb1.Text = tb1.Text.Substring(0, 1).ToUpper() + tb1.Text.Substring(1);

textbox_leave event is for winforms not for aspnet.

Santhosh Kumar Jayaraman 26-Sep-12 2:52am View

You have to add it in the reference as well. I thought you already used it as reference. Why do you want to use SqlHelper.? You can just use sqlcommand rite?

Santhosh Kumar Jayaraman 26-Sep-12 2:41am View

that is an event comes with each control.Check this http://msdn.microsoft.com/en-us/library/system.windows.forms.control.leave.aspx

Santhosh Kumar Jayaraman 25-Sep-12 6:24am View

welcome

Santhosh Kumar Jayaraman 24-Sep-12 5:22am View

ya welcome

Santhosh Kumar Jayaraman 24-Sep-12 5:03am View

WHen you get error in create table syntax, then we no need to look into whole code.. You have to give us exact error message code. It says incorrect table syntax, but it will say near something or line something..Give us that.

Santhosh Kumar Jayaraman 24-Sep-12 4:32am View

try my solution below

Santhosh Kumar Jayaraman 24-Sep-12 3:47am View

what was the error? which line?

Santhosh Kumar Jayaraman 24-Sep-12 3:33am View

You are welcome

Santhosh Kumar Jayaraman 24-Sep-12 3:03am View

Yeah..By the way, please dont use answers to post your reply..Use comments. mark it as solved, if it works for you

Santhosh Kumar Jayaraman 21-Sep-12 8:08am View

its not just @, its @dt. thats my datetime variable which i will be passing in SQLCOMMAND. I believe you know about passign parameter to query in sqlcommand

Santhosh Kumar Jayaraman 21-Sep-12 7:43am View

So you meant to say you will decide the date and the season. So have a table with 3 columns SeasonName, StartDate, EndDate. Then whenever you select a value in calendar, query the name from this table.
Select seasonName from tbl where @dt between startdate and Enddate

Santhosh Kumar Jayaraman 21-Sep-12 4:43am View

ya welcome..

Santhosh Kumar Jayaraman 21-Sep-12 4:24am View

And are you still getting the error?

Santhosh Kumar Jayaraman 21-Sep-12 4:22am View

thats because WCF concept of behaviors doesn't exist in the Silverlight 4

Santhosh Kumar Jayaraman 21-Sep-12 3:34am View

have you tried my solution by adding dataContractSerializer?

Santhosh Kumar Jayaraman 7-Sep-12 0:27am View

If you are fetching datatable from database, then you can do it in Storedproc rather than bringing it to UI.

Santhosh Kumar Jayaraman 6-Sep-12 9:07am View

Check my another solution..it will fetch you allrecords if you pass@month is null and if you pass some month it willfetch only that month details.

Santhosh Kumar Jayaraman 6-Sep-12 9:02am View

I have updated for your previous thing. Check my solution now it ll be colaesce(NULL,Month(c.Reporteddate))

Santhosh Kumar Jayaraman 6-Sep-12 8:57am View

i didnt understand . What you want to fetch if @month is null

Santhosh Kumar Jayaraman 6-Sep-12 8:54am View

i believe you reported that you are getting output as null, but i hope now the query is coming..Then what you want now?which one is not working?

Santhosh Kumar Jayaraman 6-Sep-12 8:42am View

check my solution.

Santhosh Kumar Jayaraman 6-Sep-12 8:21am View

+5

Santhosh Kumar Jayaraman 6-Sep-12 7:04am View

here your column length is 4..It will work fine till you have value less than or equal to 4 digits. But for this column you have a value with more than 4 digits, thats why. Check and let me know whether you have any value greater than 9999 in your access db column

Santhosh Kumar Jayaraman 6-Sep-12 4:25am View

Yes right.But i believe here we are trying to convert an integer tp string, there are no chances of having null as a value unless if its nullable int.

Santhosh Kumar Jayaraman 6-Sep-12 2:02am View

+5. but inside lambda expression you can just say n.ToString() instead of convert.ToString(n)

Santhosh Kumar Jayaraman 4-Sep-12 9:14am View

then you have to check my another article which i posted in my previous comment, where i give options to select server and databases for user.

Santhosh Kumar Jayaraman 4-Sep-12 9:02am View

You need to look at my another article, to know how to write changes in xml. Here i am saving the value from gridview to xml..You have to make necessary cahnges to populate it from your textbox or any other control

http://www.codeproject.com/Tips/426762/XML-to-DataSet-or-GridView-and-back

Santhosh Kumar Jayaraman 4-Sep-12 9:00am View

yes these changes are applicable for runtime only i.e. only for that instance.

Santhosh Kumar Jayaraman 31-Aug-12 3:27am View

If you want max(date) from the table no need of other columns? If so then its very simple.
Select max(date) from stockdetails will be your query.and use ExecuteScalar.
Datetime dt=cmd.ExecuteScalar() like this.

Santhosh Kumar Jayaraman 31-Aug-12 3:16am View

int delete = Convert.ToInt32(ems.Execute_Sql(cmdDel, con));
or use
int delete;
Int32.TryParse(ems.Execute_Sql(cmdDel, con),out delete);

Santhosh Kumar Jayaraman 31-Aug-12 3:11am View

what error it is??

Santhosh Kumar Jayaraman 31-Aug-12 2:50am View

date part? I have took top 1 record from table order by date as desc. So it will give me the row which is of max date in the table

Santhosh Kumar Jayaraman 31-Aug-12 2:28am View

vb code
For Each dr As DataRow In datatable
Dim fact1 As Integer = Convert.ToInt32(dr("fact1").ToString())
Next

Santhosh Kumar Jayaraman 31-Aug-12 1:54am View

what is previous row date?? you meant last record in the table? or yest date?

Santhosh Kumar Jayaraman 31-Aug-12 1:50am View

latest? I didnt get you

Santhosh Kumar Jayaraman 30-Aug-12 7:59am View

you know what , two people have downvoted it and both of their scores are more than 10k.

Santhosh Kumar Jayaraman 30-Aug-12 7:30am View

My output till first 20
1,2,3,4,5,3,7,8,3,4,11,3,13,14,35,16,17,3,19,5

Are you able to see 15 anywhere?

Santhosh Kumar Jayaraman 30-Aug-12 7:27am View

How you are saying that?Have you tried it first? cant you see last else if loop? Dont assume yourself by seeing code.

Santhosh Kumar Jayaraman 30-Aug-12 7:20am View

that happens always:)

Santhosh Kumar Jayaraman 30-Aug-12 7:19am View

have u tried my solutioon?

Santhosh Kumar Jayaraman 30-Aug-12 5:04am View

Deleted

i have sample solution. i couldnt attach it.mail me at san.pblr.gct@gmail.com

Santhosh Kumar Jayaraman 30-Aug-12 4:44am View

i will give you sample solution

Santhosh Kumar Jayaraman 30-Aug-12 4:37am View

tell me are you using datatable to bind gridview?

Santhosh Kumar Jayaraman 30-Aug-12 4:26am View

i still dint understand your specification. You already have rows and made it hidden or on the selectedchangedevent of dropdown you need to create new row?

Santhosh Kumar Jayaraman 30-Aug-12 4:23am View

So you meant to say you are creating rows dynamically?

Santhosh Kumar Jayaraman 30-Aug-12 4:21am View

but is this working now??

Santhosh Kumar Jayaraman 30-Aug-12 4:16am View

where is the button?inside grid or outside?

Santhosh Kumar Jayaraman 30-Aug-12 4:14am View

sorry i ddint get your question

Santhosh Kumar Jayaraman 30-Aug-12 3:37am View

welcome..can you mark it as solved.?

Santhosh Kumar Jayaraman 30-Aug-12 3:35am View

i have updated the solution. In findcontrol., you have to pass textbox id but your passing something else. thats the reason.

Santhosh Kumar Jayaraman 30-Aug-12 3:33am View

then give textbox name.
TextBox t1 = row.FindControl("txtemp_name") as TextBox;

Santhosh Kumar Jayaraman 30-Aug-12 3:33am View

i have posted my dropdowncolumn code inside gridview from aspx page.

Santhosh Kumar Jayaraman 30-Aug-12 3:31am View

then you should label like this
Label l1 = row.FindControl("lblemp_name") as Label;

Then l1.Text will give you the value.try and let me know.

Santhosh Kumar Jayaraman 30-Aug-12 3:27am View

whats your textbox name inside item template in gridview

Santhosh Kumar Jayaraman 30-Aug-12 3:20am View

it means ur textbox is empty.. value of t1 is null.. Its not able to find any textbox as "empname"

Santhosh Kumar Jayaraman 30-Aug-12 3:14am View

Have you tried t1.Text? Definitely Text property will be there for textboxes

Santhosh Kumar Jayaraman 30-Aug-12 3:07am View

check your input and output and the scenario you said..Its not at all matching

Santhosh Kumar Jayaraman 30-Aug-12 2:52am View

Your question is not clear ?How can you expect 5,7 to be printed when its in sequence

Santhosh Kumar Jayaraman 29-Aug-12 7:09am View

ALso there is no link between table 1 and table2

Santhosh Kumar Jayaraman 29-Aug-12 7:08am View

Its very hard to understand this question. WHy cant you make it as simple and clear?

Santhosh Kumar Jayaraman 29-Aug-12 5:41am View

Deleted

send ur project to me san.pblr.gct@gmail.com. I will have a look and help u

Santhosh Kumar Jayaraman 29-Aug-12 5:41am View

id is the column for each user right? If user 1 login , he will have some Id right? pass that id .

Santhosh Kumar Jayaraman 29-Aug-12 5:05am View

ok got it . The issue was in where clause we didnt pass Id, You have to add Id also for particular Id
if not exists(select 1 from logintable
where CONVERT(varchar(8), logindate, 112) =CONVERT(varchar(8), GETDATE(), 112) and Id=someting)
insert into logintable(col1,col2,col3,logindate) values (val1,val2,val3,getdate())

Santhosh Kumar Jayaraman 29-Aug-12 3:28am View

wc

Santhosh Kumar Jayaraman 29-Aug-12 3:06am View

post your query

Santhosh Kumar Jayaraman 29-Aug-12 2:14am View

Why can't you use google?

Santhosh Kumar Jayaraman 29-Aug-12 2:10am View

check my updated solution

Santhosh Kumar Jayaraman 29-Aug-12 2:03am View

Probably you didnt explain this first time when you posted the question. Aint i right? and you are downvoting answer for your mistake!!

Santhosh Kumar Jayaraman 29-Aug-12 1:39am View

Thanks. Updated the solution

Santhosh Kumar Jayaraman 29-Aug-12 1:29am View

Then use this.It will give one record

Santhosh Kumar Jayaraman 28-Aug-12 10:57am View

CONVERT(varchar(8), logindate, 112) =CONVERT(varchar(8), GETDATE(), 112) ) it will get only date and am comparing date only not time.

Santhosh Kumar Jayaraman 28-Aug-12 10:55am View

its 1 not i..

Santhosh Kumar Jayaraman 28-Aug-12 9:22am View

if it worked mark it as accepted

Santhosh Kumar Jayaraman 28-Aug-12 9:22am View

yes thats right. It means incorrect data is there inside which is not of double type

Santhosh Kumar Jayaraman 28-Aug-12 9:14am View

If its fixed data, then its fine. What in case if you have some value entered by user and there were no validation? Its good to use try parse always

Santhosh Kumar Jayaraman 28-Aug-12 9:07am View

my mistake include out parameter before d1.Updated solution

Santhosh Kumar Jayaraman 28-Aug-12 9:02am View

have you declared d1 as double? post your code plz

Santhosh Kumar Jayaraman 28-Aug-12 9:01am View

Check my updated solution., here am checking whether any record exists for currentdate if no, then am inserting into logintable.

Logintable=tablename
logindate=column..So you have to replace normal insert things which you already have to this in stored proc.
So at a time there will be only one record for user/day

Santhosh Kumar Jayaraman 28-Aug-12 8:56am View

It will still execute if block if values are same.
If values are in double and dint match, if loop wont be executed.
If its not able to parse, it means incorrect and it will return

Santhosh Kumar Jayaraman 28-Aug-12 8:47am View

Tryparse will parse the string to double only if the string contains double value. If its not able to convert, it wont threw error and stop your program. Instead of that it will set value as double.MinValue same as almost equal to 0 if i try to convert string "s" to double in normal way, it will threw error as you said. But if i use tryparse, it will return me Double.MinValue

Santhosh Kumar Jayaraman 28-Aug-12 8:45am View

d1, d2 , d3 are local variables,

Santhosh Kumar Jayaraman 28-Aug-12 8:44am View

Check my solution

Santhosh Kumar Jayaraman 28-Aug-12 8:28am View

why so?

Santhosh Kumar Jayaraman 28-Aug-12 0:55am View

What was the error?

Santhosh Kumar Jayaraman 27-Aug-12 5:29am View

I am not sure whether the above query will work. Few columns can have null value, 'A','P' and he wants to know how many columns has P. He has to use Pivot i believe

Santhosh Kumar Jayaraman 25-Aug-12 6:22am View

wc.

Santhosh Kumar Jayaraman 25-Aug-12 6:11am View

oh..this also might help you
http://msdn.microsoft.com/en-us/library/cc148994.aspx
http://www.dotnetperls.com/file-copy

Santhosh Kumar Jayaraman 25-Aug-12 6:05am View

is that working fine?

Santhosh Kumar Jayaraman 25-Aug-12 4:25am View

Check my updated solution

Santhosh Kumar Jayaraman 25-Aug-12 4:12am View

welcome

Santhosh Kumar Jayaraman 25-Aug-12 4:10am View

It definitely looks like increment is not happening in your procedure properly

Santhosh Kumar Jayaraman 25-Aug-12 3:57am View

I have noticed its just an insert proc right? You are not returning anytables, then why cannot you use ExecuteNonQuery()

command.CommandType = CommandType.StoredProcedure;
command.Connection = con;
command.CommandText = spNameForXlUpload;
command.Parameters.Add(new SqlParameter("@XMLItemsDoc", xmlDoc.Trim()));
cmd.ExecuteNonQuery();

Then select from table and fill it in dataadapter

Santhosh Kumar Jayaraman 25-Aug-12 3:48am View

You no need to pass parameter. In your stored proc you take last id and making it as +1, so its fine. But can you put a print next to this
SET @Disc_Code = (SELECT REPLACE(@Disc_Code,@NID,@CNT))
and check what value is coming here and check its already present in database.

Santhosh Kumar Jayaraman 25-Aug-12 3:45am View

Check my updated solution

declare @year int
declare @months int
set @months=45
set @year=@months/12
set @months=@months%12
print cast(@year as varchar(100))+' years '+cast(@months as varchar(100))+ ' months '

Santhosh Kumar Jayaraman 25-Aug-12 3:29am View

WHere you are passing it? I believe its not an identity column..When you are trying to insert what is the value you pass for disc_code?

Santhosh Kumar Jayaraman 25-Aug-12 3:24am View

which is the primary key for ur table?

Santhosh Kumar Jayaraman 25-Aug-12 3:17am View

In that case what you want 3 or 4?

Santhosh Kumar Jayaraman 23-Aug-12 9:43am View

On the left hand side, dont use ToString().
txtmop.Text=

Santhosh Kumar Jayaraman 23-Aug-12 6:37am View

post your code

Santhosh Kumar Jayaraman 22-Aug-12 12:58pm View

It looks ok. but can you check inside if loop whether its hitting loop by putting a print statement inside if loop

Santhosh Kumar Jayaraman 22-Aug-12 8:11am View

What you are getting/.?

Santhosh Kumar Jayaraman 22-Aug-12 7:56am View

If it works, please mark it as accepted

Santhosh Kumar Jayaraman 22-Aug-12 7:45am View

Yes i got your question. So what you have to do is when you got load items into listbox from database. You have to put a check, whether that record is present already in the database, If its present, then set checked =true.

Santhosh Kumar Jayaraman 22-Aug-12 6:39am View

you already wrote that method in code behind.Then whats ur problem?

Santhosh Kumar Jayaraman 22-Aug-12 4:19am View

Please explain this.
i want catName assign value this query (select invnum from categories where id=1)

Santhosh Kumar Jayaraman 22-Aug-12 1:26am View

I believe that record should have a actual space.

Santhosh Kumar Jayaraman 22-Aug-12 1:25am View

post your code..

Santhosh Kumar Jayaraman 21-Aug-12 12:11pm View

need more info..

Santhosh Kumar Jayaraman 21-Aug-12 11:14am View

Thanks

Santhosh Kumar Jayaraman 21-Aug-12 11:14am View

thanks

Santhosh Kumar Jayaraman 21-Aug-12 6:22am View

What in case if you have multiple foreign reference keys with more than one table.?

Santhosh Kumar Jayaraman 21-Aug-12 6:22am View

Deleted

What in case if you have multiple foreign reference keys with more than one table.?

Santhosh Kumar Jayaraman 21-Aug-12 0:55am View

:)

Santhosh Kumar Jayaraman 20-Aug-12 11:24am View

Ya you can retrieve records from sql database and store it in datatable. Then try my method.

Santhosh Kumar Jayaraman 20-Aug-12 8:59am View

Yes.But it depends
Check this.
http://www.bradleyschacht.com/select-count-vs-count1-vs-countcolumnname/

Santhosh Kumar Jayaraman 20-Aug-12 8:08am View

Usually they use rowcount to know how many records inserted, updated and deleted. They dont use it with select queries. Count(1) will be faster than select * and @@rowcount. SO i would say dont use @@rowcount

Santhosh Kumar Jayaraman 20-Aug-12 8:06am View

No its not required..@count is enough

Santhosh Kumar Jayaraman 20-Aug-12 7:58am View

If you use this,
SELECT * FROM MY_DATA WITH (NOLOCK)

you will get output of this.So instead of @@rowcount, i am gettin count .so only FROM select * from MY_DETAIL WITH (NOLOCK) will display records

Santhosh Kumar Jayaraman 20-Aug-12 7:51am View

Just add ToString() next to textbox.Text and combobox.SelectedValue.

Check the updated solution

Santhosh Kumar Jayaraman 18-Aug-12 8:29am View

why ??whats happeneing? I can help you only if you explain error message or warning message

Santhosh Kumar Jayaraman 18-Aug-12 8:01am View

i dont think you will be able to debug in iis hosted in server

Santhosh Kumar Jayaraman 18-Aug-12 7:46am View

have u did this?
http://mycodetrip.com/2006/11/27/unrecognized-configuration-section-connectionstrings-error-asp-net-2_44/
now wat error u r getting?

Santhosh Kumar Jayaraman 18-Aug-12 7:13am View

check this
http://forums.asp.net/t/1080128.aspx

Santhosh Kumar Jayaraman 18-Aug-12 6:57am View

now what u r getting?

Santhosh Kumar Jayaraman 18-Aug-12 6:51am View

Then where you are mentioning about server and database?

Santhosh Kumar Jayaraman 18-Aug-12 4:16am View

Did you ask anywhere in your question that how it is done?

Santhosh Kumar Jayaraman 18-Aug-12 4:12am View

Why u posted this here?

Santhosh Kumar Jayaraman 18-Aug-12 3:57am View

Can you be more clear?

Santhosh Kumar Jayaraman 18-Aug-12 3:50am View

You are talking about visible property.. am saying about enable/disable property

Santhosh Kumar Jayaraman 18-Aug-12 3:50am View

Deleted

You are talking about visible property.. am saying about enable/disable property

Santhosh Kumar Jayaraman 18-Aug-12 1:26am View

Check the updated solution

Santhosh Kumar Jayaraman 17-Aug-12 8:04am View

Before update select * and after update do one more select * for that particular row.

Santhosh Kumar Jayaraman 17-Aug-12 4:52am View

Why cant you check that? instead of asking us? I hope you have all the tables and sql server

Santhosh Kumar Jayaraman 17-Aug-12 4:32am View

check this to know how to calculate month between 2 dates for february.
http://www.codeproject.com/Articles/28837/Calculating-Duration-Between-Two-Dates-in-Years-Mo

Santhosh Kumar Jayaraman 17-Aug-12 3:02am View

its solution 3

Santhosh Kumar Jayaraman 17-Aug-12 2:53am View

only if you mark it as solved, other ppl will come to know the solution

Santhosh Kumar Jayaraman 17-Aug-12 2:53am View

Deleted

only if you mark it as solved, other ppl will come to know the solution

Santhosh Kumar Jayaraman 17-Aug-12 2:45am View

Please mark the correct answer as accepted answer and please isntead of adding new solution,add comment.

Santhosh Kumar Jayaraman 17-Aug-12 2:04am View

But the best way to do is send mail from Sql server..
CHeck this..
http://www.aspsnippets.com/Articles/Automated-Email-Notifications-using-SQL-Server-Job-Schedular.aspx[^]..Updated the solution

Santhosh Kumar Jayaraman 17-Aug-12 1:57am View

check this.

http://stackoverflow.com/questions/1350634/scheduled-mail-in-asp-net

http://www.codeproject.com/Articles/12117/Simulate-a-Windows-Service-using-ASP-NET-to-run-sc

Santhosh Kumar Jayaraman 17-Aug-12 1:54am View

Check this.
http://rockingshani.blogspot.in/search/label/Asp.net%20File%20Upload

Santhosh Kumar Jayaraman 17-Aug-12 1:45am View

Yes you are right. But he wanted it in LINQ

Santhosh Kumar Jayaraman 17-Aug-12 1:06am View

What is this checkbox1? Can you share ur aspx code?

Santhosh Kumar Jayaraman 17-Aug-12 0:59am View

so what happened? any error? or whats the proble,?

Santhosh Kumar Jayaraman 16-Aug-12 6:40am View

Is it string array or datetime array?

Santhosh Kumar Jayaraman 16-Aug-12 3:49am View

good one.

Santhosh Kumar Jayaraman 16-Aug-12 3:32am View

post ur trigger here

Santhosh Kumar Jayaraman 15-Aug-12 12:29pm View

Reason for my vote of 2
No code. Will be good if Sample code or demo is attached

Santhosh Kumar Jayaraman 15-Aug-12 10:40am View

how you are expecting to display a word doc in image control.

Santhosh Kumar Jayaraman 15-Aug-12 7:20am View

mark it as solved,plz

Santhosh Kumar Jayaraman 15-Aug-12 7:19am View

welcome

Comments by Santhosh Kumar Jayaraman (Top 200 by date)