ASP.NET

30-Sep-09 22:48

If you have Windows Authentication enabled and also Data Source is same for each computer, it will work.

But most of the people uses Named Instance rather than going for Default one. So its hard to have this.

Why dont you allow users to configure Web.config ?? Confused | :confused:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Re: further login info

vikas shukla30-Sep-09 22:52

vikas shukla

30-Sep-09 22:52

sir is there any way from which crystal report access the connection string (oledb connection)from web.config.

if is it so then my problem may be solved

Re: further login info

sashidhar30-Sep-09 23:22

Way to access masterpage from usercontrol

30-Sep-09 23:22

vikas shukla wrote:
sir is there any way from which crystal report access the connection string

I dont Know Abt Tht..! I think You Are in trouble when using using Crystal Reports..!

But I tried in different way for this. It may Help or Not But try..!
Open It in Visual Studio ->Open any Crystal Report-->
On the top
CrystalReport-->Go to Field Explorer
-->Verify Database I think

Hope It Helps..!

MyFirstArticlePublished: MenuControlSelectedItem
Why Do Some People Forget To Mark as Answer .If It Helps.

Wouter Coinless30-Sep-09 22:08

Wouter Coinless

30-Sep-09 22:08

Hi!

Is there a way to access a control in my MasterPage from my custom user control.

I have MasterPage with custom control --> Default.aspx --> User Control

And my last User Control needs to access the custom control in my master.

Or do i have to work with delegate in my default.aspx

Thanks! Wouter

Re: Way to access masterpage from usercontrol

Abhishek Sur30-Sep-09 22:42

Re: Way to access masterpage from usercontrol

30-Sep-09 22:42

How about

this.Page.FindControl("id");

Try it, I think it will find the control. Big Grin | :-D

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Wouter Coinless30-Sep-09 22:55

Wouter Coinless

30-Sep-09 22:55

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

Gives back null

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

That gives my masterpage Smile | :)

Not really nice id

query

mylogics30-Sep-09 21:43

30-Sep-09 21:43

hii all
m using update query to update the new paassword in my login table on button click.
it gives error:"syntax error in upadate statement".
the code is:

protected void Button1_Click(object sender, EventArgs e)
    {
        
            string str = "UPDATE memberlogin SET Password='"+txtnewpassword.Text+"',Confirmpassword='"+txtconfirmpassword.Text+"' 
WHERE MemberNo='"+txtusername.Text+"' AND Password='"+txtpassword.Text+"'";
            OleDbCommand cmd = new OleDbCommand(str,conn);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
        
     }

plz guide wr m i wrong...
thanks...

Abhijit Jana30-Sep-09 21:49

Abhijit Jana

30-Sep-09 21:49

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

Set breakpoint over here. Run you appliction, Copy the str value. Put it into SQL Server Query window and check what error it is throwing. This is the way you can identify your own problem !!

As per your code goes, Please be aware of SQL Injection !!!

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET

sashidhar30-Sep-09 21:50

30-Sep-09 21:50

LOL SAme Solution..!

MyFirstArticlePublished: MenuControlSelectedItem
Why Do Some People Forget To Mark as Answer .If It Helps.

Abhijit Jana30-Sep-09 23:08

Abhijit Jana

30-Sep-09 23:08

sashidhar wrote:
LOL SAme Solution..!

With Same time Jig | [Dance]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET

Vasudevan Deepak Kumar1-Oct-09 2:44

Vasudevan Deepak Kumar

1-Oct-09 2:44

There is a one minute gap between the posts anyway. Smile | :)

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!

sashidhar30-Sep-09 21:49

30-Sep-09 21:49

For Now We Can Help ..! If the Same error comes agani Then What?You Will Post Again..1 I will tell You The Way to solve Your Problem
1)Keep a break Point on
mylogics wrote:
string str = "UPDATE memberlogin SET Password='"+txtnewpassword.Text+"',Confirmpassword='"+txtconfirmpassword.Text+"'
WHERE MemberNo='"+txtusername.Text+"' AND Password='"+txtpassword.Text+"'";

and run it..!

2)press f11 as it passes that line part Mouseover on the string str You Will Get a Magnifier click on it You Will Get the Query in popup Window.Then You Can Test It..! Cool | :cool:

MyFirstArticlePublished: MenuControlSelectedItem
Why Do Some People Forget To Mark as Answer .If It Helps.

mylogics30-Sep-09 21:57

30-Sep-09 21:57

i have given the breakpoint:it shows:
str = "UPDATE memberlogin SET Password='0003',Confirmpassword='0003'WHERE MemberNo='0003'
AND Password='0003'"

as soon as it execute the query givs error...

Abhishek Sur30-Sep-09 22:05

30-Sep-09 22:05

Oh.. there must be a space just before Where statement .. I guess. Smile | :)

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

sashidhar30-Sep-09 22:50

30-Sep-09 22:50

Hope You Got the Solution as Abi Suggests..!

MyFirstArticlePublished: MenuControlSelectedItem
Why Do Some People Forget To Mark as Answer .If It Helps.

Abhishek Sur30-Sep-09 22:04

30-Sep-09 22:04

The query looks good, the only possible problem that might took place is when Parameters like txtnewpassword, txtconfirmpassword,txtusername, txtpassword comes with some weird values.

Say I write txtnewpassword.Text = "0'--"

This is what we call SQL injection. So use like this.

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);
.....
...
...

.. Do this for all other parameters.

Hope you got this more clear now. Rose | [Rose]

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

mylogics30-Sep-09 22:59

30-Sep-09 22:59

i tried but prom is same....

Abhijit Jana30-Sep-09 23:07

Abhijit Jana

30-Sep-09 23:07

mylogics wrote:
i tried but prom is same....

What you have tried ? Did you give a space @where section in your code ? If yes then what error is coming now ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET

mylogics30-Sep-09 23:11

30-Sep-09 23:11

yaaa i have given space at where as u told but still it gives error:
"syntax error at upadate statement".
i also tried using sqlinjection but same...