ASP.NET

vikas shukla wrote:

sir is there any way from which crystal report access the connection string

public partial class Administration_Controls_FileControl : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Control control = this.Page.FindControl("MessageControl");

Control control = this.Page.FindControl("ctl00");

mylogics wrote:

string str = "UPDATE memberlogin SET Password='"+txtnewpassword.Text+"',Confirmpassword='"+txtconfirmpassword.Text+"'
WHERE MemberNo='"+txtusername.Text+"' AND Password='"+txtpassword.Text+"'";

sashidhar wrote:

LOL SAme Solution..!

string str = "UPDATE memberlogin SET Password=@newpass, Confirmpassword=@confirm WHERE MemberNo=@member AND Password=@password";
OleDbCommand cmd = new OleDbCommand(str, conn);
SqlParameter confirm = new SqlParameter("@confirm", SqlDbType.NVarchar, 50);
confirm.value = txtnewpassword.Text; // This will remove sql injection
cmd.Parameters.Add(confirm);
.....
...
...

mylogics wrote:

i tried but prom is same....

Mr Mackey from South Park said:

And remember children, there are no stupid questions, just stupid people

ServiceController service = new ServiceController(serviceName);
service.Start() / Stop() 

int timeoutval = 20;
ServiceController svcController = new ServiceController("servicename");

    if (svcController != null) {
        try {
               svcController.Stop();
        svcController.WaitForStatus(ServiceControllerStatus.Stopped, TimeSpan.FromSeconds(timeoutval));
               svcController.Start();
        } catch (Exception ex) {
              //log exception
   }
}