Re: Login problem with ExecuteScalar(); - ASP.NET Discussion Boards

Re: Login problem with ExecuteScalar();

Not Active15-Nov-09 12:30

Not Active

15-Nov-09 12:30

Abhishek Sur wrote:
So he wrote like this

This doesn't lessen our responsibility to also point out misunderstandings and mistakes in usage and give guidance on more correct ways of implementation.

I know the language. I've read a book. - _Madmatt

Re: Login problem with ExecuteScalar();

Maxdd 715-Nov-09 12:21

Maxdd 7

15-Nov-09 12:21

Because I also use SqlDataReader Smile | :)

I will use object, I think in this case is the best choice for me Smile | :)

Many thanks for all your help!

Re: Login problem with ExecuteScalar();

Abhishek Sur15-Nov-09 12:24

Abhishek Sur

15-Nov-09 12:24

Maxdd 7 wrote:
Many thanks for all your help!

You are most welcome bro...

Cheers.
Thumbs Up | :thumbsup:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Login problem with ExecuteScalar();

Not Active15-Nov-09 12:26

Not Active

15-Nov-09 12:26

Maxdd 7 wrote:
Because I also use SqlDataReader

That has nothing to do with it. DataReader provides methods such as GetString, GetInt, GetBoolean. Learning to use the tools properly will be a great benefit to you in the future.

I know the language. I've read a book. - _Madmatt

Re: Login problem with ExecuteScalar();

Maxdd 715-Nov-09 12:33

Maxdd 7

15-Nov-09 12:33

I was just answering to this question:

"
To make you understand, I guess ExecuteScalar executes a query and returns only the first column of the first row. All others are just ignored. So why do you select them ?? "

I use SqlData reader (I erased those lines on first post here) so I can extract those values.

Re: Login problem with ExecuteScalar();

Not Active15-Nov-09 12:04

Not Active

15-Nov-09 12:04

See other reply for a more acceptable way to handle this.

Also, you should be strongly encouraged to not use inline SQL or at the very least use a parameterized query. Search Google for SQL Injection attack.

I know the language. I've read a book. - _Madmatt

Re: Login problem with ExecuteScalar();

Abhishek Sur15-Nov-09 12:08

Abhishek Sur

15-Nov-09 12:08

Mark Nischalke wrote:
you should be strongly encouraged to not use inline SQL or at the very least use a parameterized query.

I accept with you in this regard. Rose | [Rose]

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Login problem with ExecuteScalar();

Christian Graus15-Nov-09 17:28

Christian Graus

15-Nov-09 17:28

where do username and password come from ? Does the user input them ? If they do, this is terrible code. Even if they don't, it is not great.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Accesing control value in GridView on postback

Aftab Sindhi15-Nov-09 5:07

Aftab Sindhi

15-Nov-09 5:07

I've a user control, which contains GridView. The gridview is bound to the ObjectDataSource. The gridview is displaying checkboxes in the shape of matrix like below

Title	View	Insert	Edit
Users	checkbox	checkbox	checkbox
Page Data	checkbox	checkbox	checkbox

The columns and Titles are dynamic, which is generated by the object(which is used by ObjectDataSource). The data of the grid is displayed correctly without any problem. Under the grid there is button. On the button click I want to know, which check boxes are checked. I can loop through every row of the grid and can access the checkbox also.
Now, problem is, on button click when I am looping through gridview rows, all checkboxes are shown as unchecked while before click I check some checkboxes.
Strange behavior is this, that, on 1st click, checkboxes are not retaining checked state, while on 2nd click, same code shows checked check boxes correctly.
In short, problem is on 1st click, while subsequent clicks are working as expected. Is there anybody who can tell whats wrong?

Regards

Aftab Sindhi
.NET Application Developer
U.A.E

Re: Accesing control value in GridView on postback

Suresh Pirsquare15-Nov-09 7:04

Suresh Pirsquare

15-Nov-09 7:04

Aftab Sindhi wrote:
In short, problem is on 1st click, while subsequent clicks are working as expected.

Just Debug the code.

Everything Is Possible!

http request and web request

noo.dyab15-Nov-09 5:07

noo.dyab

15-Nov-09 5:07

hello
what is the difference between httpwebrequest,httpwebresponse and webrequest,webresponse
in asp.net and what do they use for

Re: http request and web request

Abhishek Sur15-Nov-09 6:16

Abhishek Sur

15-Nov-09 6:16

HttpRequest / HttpResponse classes are derived from WebRequest and WebResponse classes which can handles only Http request and response.
The method WebRequest.Create returns appropriate object based on the url passed. Say you pass
http://www.google.com
The create factory method will then produce HttpWebRequest object as Http protocol is used. On the other hand if you use Ftp urls it will produce FtpWebRequest object.So we write :

HttpWebRequest req = WebRequest.Create("http://www.google.com") as HttpWebRequest;

If you are not sure about the url passed, you can easily use WebRequest class.

Cool | :cool:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

can we store viewstate in masterpage?

Suresh Pirsquare14-Nov-09 19:31

Suresh Pirsquare

14-Nov-09 19:31

can we store viewstate in masterpage. so that when a user tries to open a new tab, the id is fetched from the viewstate.

Everything Is Possible!

Re: can we store viewstate in masterpage?

Abhijit Jana14-Nov-09 19:55

Abhijit Jana

14-Nov-09 19:55

Suresh Dayma wrote:
can we store viewstate in masterpage.

I didn't get your question. What do you mean by store view state in master page. I would suggest you to have a qucik look into Beginner's Guide To View State [^]article, and let me know if you have any more issue.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: can we store viewstate in masterpage?

Suresh Pirsquare14-Nov-09 20:16

Suresh Pirsquare

14-Nov-09 20:16

Thanks for your reply.

ok, just take an example

this is what i want

in masterpage, i have created a label called 'customer name'.
and fetched the customer name from the database and assigned it to the label. when i navigate from one page to another then, I just want to retain the customer name across multiple pages without having to interact with the database.
(Assume there is a single master page and multipe content pages.)

Everything Is Possible!

Re: can we store viewstate in masterpage?

Abhijit Jana14-Nov-09 20:30

Abhijit Jana

14-Nov-09 20:30

Suresh Dayma wrote:
when i navigate from one page to another then, I just want to retain the customer name across multiple pages without having to interact with the database.

For that you need to use Session insted of ViewState. Fetch the data first time from DB and put it into session. Now you can access them any where from your site.
Following code is used for storing a value to session
Collapse

//Storing UserName in Session
 Session["CustomerName"] = dbUserName;

Now, let see how we can retrieve values from Session
Collapse

//Check weather session variable null or not
        if (Session["CustomerName"] != null)
        {
            //Retrieving UserName from Session
            lblWelcome.Text = "Welcome : " + Session["CustomerName"];
        }
        else
        {
         //Do Something else
        }

Hope this will help you. If you want to know more about the session, please read this one : Exploring Session in ASP.Net[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: can we store viewstate in masterpage?

Suresh Pirsquare14-Nov-09 20:38

Suresh Pirsquare

14-Nov-09 20:38

Currently, i have used the sessions to store this.
but when the user tries to open it in a new tab then this does not work.

Example
I have a gridview having multiple customers.
if i open multiple customer details on multiple tabs then it will overwrite the customer details.
so it does not make sense to store customer details in Session.

Everything Is Possible!

Re: can we store viewstate in masterpage?

Abhijit Jana14-Nov-09 21:12

Abhijit Jana

14-Nov-09 21:12

Suresh Dayma wrote:
but when the user tries to open it in a new tab then this does not work.

Are you talking about browser new Tab ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: can we store viewstate in masterpage?

Suresh Pirsquare14-Nov-09 23:11

Suresh Pirsquare

14-Nov-09 23:11

yes, you are correct

Everything Is Possible!

Re: can we store viewstate in masterpage?

Suresh Pirsquare14-Nov-09 23:49

Suresh Pirsquare

14-Nov-09 23:49

Hi abhijit, is there any work around for this issue?

Everything Is Possible!

Re: can we store viewstate in masterpage?

Abhishek Sur14-Nov-09 22:44

Abhishek Sur

14-Nov-09 22:44

I think you need to use Database.
Once it is modified, just store it into database and from any other tab / in any other browser in the world, it will be shown updated.

No need for ViewState / Session etc. Wink | ;)

If this is your temporary storage, u might use temporary database tables as well. Rose | [Rose]

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: can we store viewstate in masterpage?

Suresh Pirsquare14-Nov-09 23:46

Suresh Pirsquare

14-Nov-09 23:46

I dont think this is the solution.

Everything Is Possible!

Re: can we store viewstate in masterpage?

Abhishek Sur15-Nov-09 0:06

Abhishek Sur

15-Nov-09 0:06

Then please let me clear this.

If you open a new browser tab, it doesnt allow you to access any data from other tab because of security issues.
Mozilla retains its session data for every tab. So in case of mozilla, it do work in multiple tabs. But in IE it doesnt.

One thing that you might use is Cookie. If you call a server for same domain, you can use it to send data.

Say you call

www.xyz.com

it can create cookie data in browser based on the address. So that after a certain while or at the same instant if a new browser is opened and same address is navigated, you will find the data from cookie easily.

Say you write like this :

<code>Response.Cookies["txtCookie"].Value = this.txtcookie.Text;
Response.Cookies["txtCookie"].Expires = DateTime.Now.AddDays(1);

Now from another browser instance if you call
string txtCookie = Request.Cookies["txtCookie"].Value;
it will give you appropriate data. By this way you can send data to different browser instances.

Cool | :cool:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: can we store viewstate in masterpage?

N a v a n e e t h14-Nov-09 21:02

N a v a n e e t h

14-Nov-09 21:02

Abhijit Jana wrote:
lblWelcome.Text = "Welcome : " + Session["CustomerName"];

This won't compile. Adding a string and object is invalid. You need ToString().

lblWelcome.Text = "Welcome : " + Session["CustomerName"].ToString();

Best wishes,
Navaneeth

Re: can we store viewstate in masterpage?

Abhijit Jana14-Nov-09 21:09

Abhijit Jana

14-Nov-09 21:09

My Bad. Thanks for correcting me !! Thumbs Up | :thumbsup:

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.