Comments by sgjoshi85 (Top 31 by date)

I have tried RSAProtectedConfigurationProvider and DPAPIProtectedConfigurationProvider. It works fine on my developer machine. But when I install it in client's machine, it doesnt work

Thanks a lottt..

Hi Marcus, I don't understand the relation between the output lines and issue i fixed, but by doing so it solved my issue. In global.asax I called 2 methods in app_start(), it was running fine from 1 year. suddenly it stopped working due to this. i commented the line where i call the function and now its working.
Thanks for taking effort in helping me.

Yes I did but still its not working. Can it be w3wp.exe issue? or Linq issue?

yes i guess that is an issue. i asked hosting server to check app pool. this must be the reason. thanks ryanb31 :)

Thanks a lot mark

I solved it. Thanks

thanks a lott.. it is done
:)

thanks a lott.. it is done
:)

ya plz copy ur sample code..

clear these textboxes on page_load() of your page..where you have these textboxes..

Thanks Tejas..
Ur url somewhat helped me..and also i changed some positions ..it is working well now :)

hey..thanx buddy :)
this solved!

okie thanks a lott :) RaisKazi.. I will learn and implement it..and let u know once done successfully..

thanks a lott..RaisKazi :)
your 1) i transfered code in btn Click event..
but running off time..so dont have time to learn on 2nd)
so cant i use WaitCallBack() ??? ThreadPool?

no..
initially initially i set it false..
but after once it sends email, it changes the status of pendingMail = true.
So, now when it checks in db, it will send email only to those which pendingMail = false.
sorry..i by mistake started coding by false value..which should be true..but consider this as it is and explain what's the issue..is there any issue in logic? or thread not aborting or what?

In above SendNotification() code,
after it sends email, immediately, i am changing its status = true;
see the below code -

client.Send(mail);
noti.First().pendingMail = "true";
db.SubmitChanges();

Global.asax file --
protected void Application_BeginRequest(Object sender, EventArgs e)
{
Thread td = new Thread(new ThreadStart(SendNotification));
td.IsBackground = true;
td.Start();
}
public static void SendNotification()
{
dbDataContext db = new dbDataContext();
var noti = from n in db.Notificationdbmls
where n.pendingMail == "false"
select n;
if (noti.Count() != 0)
{
try
{
MailMessage mail = new MailMessage();
mail.To.Add(noti.First().ReceiverEmailID);
mail.From = new MailAddress("emailaddress");
mail.Subject = noti.First().Subject;
mail.Body = noti.First().Body;
mail.IsBodyHtml = true;
var client = new SmtpClient("smtpdetails");
client.Credentials = new System.Net.NetworkCredential("emailid", "password");
client.EnableSsl = true;
client.Send(mail);
noti.First().pendingMail = "true";
db.SubmitChanges();
}
catch (Exception ex)
{
//
}
}
}

On aspx page -

On buttonClick -
Notificationdbml nd = new Notificationdbml { Body = body, CreatedDate = DateTime.UtcNow.Date, Description = "", pendingMail = "false", ReceiverEmailID = email, ReceiverUserID = userid, Subject = subject, Type = "User Registration" };
db.Notificationdbmls.InsertOnSubmit(nd);
db.SubmitChanges();

Thanks Madhu..Let me implement that..

Not working :(

wow thats great..i got solution.I am using SSMS,can export the data in csv as suggested..
Results should be sent via email. So I got help from the links you given.
Thanks a lott..

Thanks Mika..but i want to export data from different tables (of same database) to the client. Let me explain you -
Following are tables in my database:
1) company table - Master table that contains records of all companies (CompanyID, Company Name)
2) branch table - Master table under company table (BranchID, BranchName, CompanyID)
3) Transaction table - transactions of branches (TransactionID,Description,BranchID). Likewise other tables containing details of branches.

Now, client Company A asked me to export all his company's data. So I want to fetch all data of Company A from all above tables and export it.
Can I directly enter Company ID & fire query and it fetches all data in a package and send to the client (Company A) from backend ?

Hi digimanus, it solved error. and it is working fine now. thanks a lot for giving idea. :)

Thanks digimanus. I called a property for datatable. but its not working. but I called propery datasource, it fetches datarecord but it is not displaying data on page.