ASP.NET

13-Jul-07 5:24

Hi
I ahve been tryin to get this datagrid to show my query results for ages now and I jus get a blank screen, any suggestions?

Sub bindData()

'1. Create a connection
Dim connectionString As String
connectionString = "Server=localhost; uid=jshort; pwd=oasisarab;database=ftp1;"

'Builds .net mysql connection and passes connection string into method
Dim connection As New MySqlConnection(connectionString)

Const sql As String = "select UserId, username, groups, joindate from Users;"
'Create mySql command string for passing query or SPROC(Stored Procedure)
Dim cmdString As New MySqlCommand(sql, connection)
'Set Command to equal mySql connection,t so can pass SQL query

'3. Create the DataAdapter
Dim da As New MySqlDataAdapter()
da.SelectCommand = cmdString

'4. Populate the DataSet
Dim ds As New DataSet()
da.Fill(ds)

'5. Set the datagrid's datasource to the dataset and databind
dgUsers.DataSource = ds
dgUsers.DataBind()
End Sub

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>System Users</title>
</head>
<body>
<asp:datagrid id="dgUsers" runat="server" BorderWidth="0"
CellPadding="2" Width="100%"
Font-Size="Smaller"

HeaderStyle-HorizontalAlign="Center"
HeaderStyle-Font-Bold="True"
HeaderStyle-BackColor="Navy"
HeaderStyle-ForeColor="White"

AlternatingItemStyle-BackColor="#dddddd">
</asp:datagrid>
</body>
</html>

kubben13-Jul-07 5:40

13-Jul-07 5:40

Are you calling your databind method in the page load or something? The method won't get called automatically.

Ben

boyindie13-Jul-07 5:42

13-Jul-07 5:42

Ye i am calling that from my page_load method, I have also checked the sql is correct as i put thru a command window and pulls back what i wanted

kubben13-Jul-07 5:45

13-Jul-07 5:45

I would change this line:
dgUsers.DataSource = ds
to point to the table you want to bind to.
perhaps it is the first table returned:
dgUsers.DataSource = ds.Tables(0)

Ben

boyindie13-Jul-07 5:49

13-Jul-07 5:49

Still no joy

I don't understand wot the problem is I have used more sophisticated code using stored procedures, and works fine for every other table i need

kubben13-Jul-07 5:55

13-Jul-07 5:55

I think you are missing AutoGenerateColumns="true"
in your datagrid code in the html.

Ben

Problem in mailto:

rohitshrivastava13-Jul-07 5:05

rohitshrivastava

13-Jul-07 5:05

hi,

i am using mailto: command on my web page.
the problem with this is when i am including the subject in this command and if subject is having '&' then the subject is being truncated in outlook.

please find the code below:

mailto:Webv2test96@executiveboard.com?subject=Message Regarding Leadership Development (ContentId=1118)& Rohit

Output:
Subject line only picks "Message Regarding Leadership Development (ContentId=1118)" and truncates "& Rohit" part.

i want to show all the text "Message Regarding Leadership Development (ContentId=1118)& Rohit" in the subject line in outlook.

Please suggest any workaround for this problem

thanks in advance.

Re: Problem in mailto:

kubben13-Jul-07 5:39

13-Jul-07 5:39

YOu need "" since you have spaces in your subject.

" " (beginning and ending double quotes) are necessary if any spaces are used

Mailto parameter should be preceded by "?" for the first or only parameter and "&" for second and subsequent parameter.
http://www.ianr.unl.edu/internet/mailto.html[^]

Ben

Re: Problem in mailto:

Jon Sagara13-Jul-07 5:48

Jon Sagara

13-Jul-07 5:48

In your subject text (Message Regarding Leadership Development (ContentId=1118)& Rohit), you'll need to replace the "&" character with "%26". "&" is a reserved character used to separate parameter name/value pairs, just like in an HTTP url:

mailto:test@example.com?subject=My Subject&body=This is the body of my test message

This is what your mailto: link will do with "&" replaced by "%26":

Clickety to open link in your email client

Jon Sagara
This is the stuff we'll drink on special occasions. To paraphrase my father-in-law, this is the kind of wine that results in kids.
-- A friend

Blog | Site | Articles

Re: Problem in mailto:

Guffa13-Jul-07 6:29

Guffa

13-Jul-07 6:29

Use Server.UrlEncode to encode the string properly for putting it in the url.

This will also encode the spaces in the string, as spaces are not allowed in a well formed url.

---
single minded; short sighted; long gone;

Authentication

boyindie13-Jul-07 3:58

13-Jul-07 3:58

Hi
I was wondering if you would be able to give me some general feedback on my latest issue

I have created a user login screen, but now I want to be able to create some sort of authentication, so that I don't require the user to enter there login credentials everytime i need to do somthin in my database.

What is the best way of doing this, would issueing a cookie after succesfully loggin in do the job, so it gives me a constant reference to who the user is, allowing me to pull data from tables that is relevant to them

any help appreciated

boy

Paul Conrad13-Jul-07 4:22

13-Jul-07 4:22

Have you tried just using Session variables? You could go the cookies route but make sure the password is not in plain text and the cookie is set to expire with in a short time later. Say like 20 minutes or one hour... Just a quick thought...

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

boyindie13-Jul-07 5:39

13-Jul-07 5:39

No
I have never used session variables, not really done anythin like this thats why I asked was gettin millions of different things off the web.

All my passwords have been encrpted anyways , sot ahts not a problem

DarrollWalsh14-Jul-07 4:01

DarrollWalsh

14-Jul-07 4:01

Session["SomeVariable"] = someVariableIuse;

Use session variables to store information like that about the current user. Just note that you have to cast the objects back out of the Session object

string MySessionVariable = (string)Session["SomeVariable"];

D^arroll

Paul Conrad14-Jul-07 11:35

14-Jul-07 11:35

boyindie wrote:
All my passwords have been encrpted anyways , sot ahts not a problem

That is fine. You can store it in session variables. Just take a look at Darrol's example.

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

plz help

kiranp2softech13-Jul-07 3:49

kiranp2softech

13-Jul-07 3:49

hi friends,
how to upload and download a file from database using upload control in asp.net2.0.

Christian Graus13-Jul-07 4:09

Christian Graus

13-Jul-07 4:09

Where is the database ? If it's on the server, the web is full of examples for storing files in a database.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: plz help [OT]

David Crow13-Jul-07 6:10

David Crow

13-Jul-07 6:10

So did you make it to OK in one piece?

"A good athlete is the result of a good and worthy opponent." - David Crow

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

Paul Conrad13-Jul-07 4:26

13-Jul-07 4:26

Are you trying to store a file in the database and have the ability to pull it out when needed? If so, there is a lot of examples out there on the web. I only know how to do so in PHP but the concept is similar.

You will need to load in the file into something like a memory stream, and send to the database as a blob-type...

Hope this is a start for you...

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

leckey13-Jul-07 5:09

leckey

13-Jul-07 5:09

Please read the forum guidelines. Make your message titles meaningful. Do not use 'please help' or 'urgent' and do not use text speak.

_____________________________________________
Flea Market! It's just like...it's just like...A MINI-MALL!

Paul Conrad13-Jul-07 9:13