Comments by Harsha Dev (Top 71 by date)

Expecting Integer at @Uom_Noofdecimal :(

But i need to pass integer value by parameter. (Through @Uom_noofdecimal)

Thanks :)

Thanks :)

Thanks AshishChudha... :) Nice Article It Helps !!! :)

Thanks :)

http://www.asp.net/downloads/archived-v11/migration-assistants/php-to-aspnet

Thanks :)

But i need an Worked Example like this
http://www.dotnettwitter.com/2012/01/group-total-and-grand-total-part-2.html

I need Design part Coding... and how to calculate sub total and grand total via cells or rows or columns of Repeater or ListView (That is i need vb.net back-end coding as well :)

A worked example is more appreciated :)
Thank you and Regards
Harsha

hmm ok podbielski but i have to complete this task in company so oly asking help and i am new to cursors :)

Thanks Om Prakash :) Here i have not used logic but i need to update the last column with same seraialnum i need to use cursors for swapping or holding variables and get the result

Thanks VedPrakash !!! :) Nice Work...its Working Perfectly :)

updated bopannavb :)

ok wait i will update the question for better understanding...juz 1 min

ya i am going through..Thanks Man :)

yeah sure :)

hmmm ok lemme update the question?

Question Updated Niijboer :)

hmmm its working Thanks man :) but i need with the help of looping Cursors.

Yeah Thanks man!!! :) Nope :( i am getting serial num as 3212111 instead of 1112231

logic behind calculation of Serial_Num is when the Item_Icode changes the serial num gets reseted to 1

when the item code changes serial num gets reseted to 1

ok right now u can take like this...
when the item code is 10 it will generate serial number 1,2,3 to the respective itemname and itemcode

i want to update this serial number with the help of itemicode and itemcode columns!!!
it should update in one shot using loop cursor :)

Regards
Harsha

I have only posted again to get result of table above using looping cursor.
i need a query. :)

I have only posted again to get result of table above using looping cursor.
i need a query. :)

ya it is correct kasim but i need in terms of looping Cursor !!! :)

output -

Procedure or function 'UpdateValue' expects parameter '@Id', which was not supplied.
No rows affected.
(0 row(s) returned)
@RETURN_VALUE =
Finished running [dbo].[UpdateValue].

ALTER PROCEDURE UpdateValue
(
@Id int,
@Name varchar(50),
@Age int
)
AS
/* SET NOCOUNT ON */
DECLARE @Count int
select @Count=Count(Id) from Person where Name=@Name

IF @Count=0
BEGIN
UPDATE Person SET
Name = @Name,
Age = @Age
WHERE Id = @Id

END
RETURN @Count
RETURN

Is this ok?

Thanks man... will check it...

thank u vani :) always helpful :)

hmmm.. like courier tracking and track and trace of container shipments :)

yeah roger that ;)
hmmm sure sir :)

Working perfectly!!! :)

ooops how can i miss that... :( thank you sir :)

thank u michael :) but i need C# code :(

can u give me a sample code if u have?

//string filepath = @"C:\Documents and Settings\HPFS.HPFS\Desktop\rajmal.csv";
string file = FileUpload1.PostedFile.FileName;
file = Path.GetFileName(file);
string filepath = Server.MapPath("~/csv/")+file;
FileUpload1.SaveAs(filepath);
StreamReader sr = new StreamReader(filepath);
string line = sr.ReadLine();
string[] value = line.Split(';');
DataTable dt = new DataTable();
DataRow row;
foreach (string dc in value)
{
dt.Columns.Add(new DataColumn(dc));
}
while ( !sr.EndOfStream )
{
value = sr.ReadLine().Split(';');
if(value.Length == dt.Columns.Count)
{
row = dt.NewRow();
row.ItemArray = value;
dt.Rows.Add(row);
}
}


SqlBulkCopy bc = new SqlBulkCopy(sc.ConnectionString, SqlBulkCopyOptions.TableLock);

bc.DestinationTableName = "company";

bc.BatchSize = dt.Rows.Count;

sc.Open();

bc.WriteToServer(dt);

Response.Write("Ok");

bc.Close();

sc.Close();

Hi its working in SQL SQL Server but not mysql server please help!!! :)

yeah it help me a lot :)

gud link vani thanks :)

yeah... but can we attach the exported data(ie Excel) from gridview into textbox using button click event... :)

wow thanks man its working...

no i am not getting any kind of exception to debug...

using yahoo service!!! :)

hope it will be useful... i will try and come back to u...

Thanks :)

Can some one help me how to go on with email sending step by step procedure!!! :)

Error

System.Net.Mail.SmtpException: Insufficient system storage. The server response was: 4.3.1 Out of memory at System.Net.Mail.MailCommand.CheckResponse(SmtpStatusCode statusCode, String response) at System.Net.Mail.MailCommand.Send(SmtpConnection conn, Byte[] command, String from) at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception) at System.Net.Mail.SmtpClient.Send(MailMessage message) at _Default.Btn_SendMail_Click(Object sender, EventArgs e) in c:\Documents and Settings\User\My Documents\Visual Studio 2008\WebSites\Email\Default.aspx.cs:line 25

yeah zoltan zorgo i tried but i am getting errors!!! wait i will post the kind of error which i am getting...
hope u can help me from that error :)

thanks but i want to send mail without using gmail smtp... :)

MailMessage MailMesaji = new MailMessage();
MailMesaji.Subject = (txtSubject.Text);
MailMesaji.Body = (txtBody.Text);
MailMesaji.BodyEncoding = Encoding.GetEncoding("Windows-1254");
MailMesaji.From = new MailAddress(txtEmail.Text);
MailMesaji.To.Add(new MailAddress("info@instant-freight.com"));
SmtpClient Smtp = new SmtpClient("smtp.mail.instant-freight.com");
Smtp.Credentials = new System.Net.NetworkCredential("info@instant-freight.com", "");
Smtp.Send(MailMesaji);
Response.Write("mail Send");

i am using this code in button click Error Sending Failed :(

will it work without password...??

:)

thanks man... but i need to send mail from host server... eg info@domainname.com will it work these kinds of emails

thanks man...

thanks man...:)

Dear Sir,
The Question is Just about how to set expiry date for website application.
For example suppose the user wants to use an application for 'x' month or year we should pay some 'y' dollars. Say the user used the application for 'X' months or years after that it should automatically deactivate.

thank you so much sir...will learn from these links :)
i am a fresher :(:)

thanks man i will try...

thanks...

thanks...

thanks...

thanks...

thanks man can u elaborate it....???

thank you!!! :)

thank you!!! :)

thank you!!! :)

thank you!!! :)

thank you!!! :)

thank you!!! :)