|
Hi, i have sql membership provider in my database and i want to join two different tables in sqldatasource i.e. i have this select statement in my aspx page.
<asp:sqldatasource id="Games" runat="server" xmlns:asp="#unknown">
ConnectionString="<%$ ConnectionStrings:SecurityTutorialsConnectionString %>" SelectCommand="SELECT dbo.aspnet_Users.UserName, GameComment.Subject, GameComment.Body, GameComment.CommentDate, saquib.Reply.Subject, saquib.Reply.message From GameComment INNER JOIN dbo.aspnet_Users ON GameComment.UserId = dbo.aspnet_Users.UserId AND saquib.Reply.UserID = dbo.aspnet_Users.UserId ORDER BY GameComment.CommentDate DESC" />
their is three tables asp.net_users, GameComment and reply, should understand what i say on my above code.
and other query is that, i want to put the statement like that
<asp:sqldatasource id="Games" runat="server" connectionstring="<%$ ConnectionStrings:NorthwindConnectionString %>">
SelectCommand=SELECT dbo.aspnet_Users.UserName, GameComment.Subject, GameComment.Body, GameComment.CommentDate, saquib.Reply.Subject, saquib.Reply.message From GameComment INNER JOIN dbo.aspnet_Users ON GameComment.UserId = dbo.aspnet_Users.UserId AND saquib.Reply.UserID = dbo.aspnet_Users.UserId ORDER BY GameComment.CommentDate DESC" >
Please help me to solve this.
if you wish, i can show my database structure and relationship to you.
Thank you
saquib
|
|
|
|
|
To solve what? What is the problem?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
how to use the OpenFileDialog in web application using c#?
i've heared it's by using Activex but i didn't know how to do it in anyways
|
|
|
|
|
The easiest way to deal with files is using the Input tag with Type=File. Then you can upload the file to the server and deal with it there. If you want to show the user files on the server, you will have to write a custom control to do it, but I wouldn't recommend it anyway. What are you trying to do?
|
|
|
|
|
what i'm trying to do is that allowing the user to upload a file from his own computer.
anyways the 'input' inst. i couldn't use it 4 a Button Click Event Handler.
|
|
|
|
|
That's right, the Browse button on the file input won't post back to the server; you'll have to add a second button to do that. Then you'll have the file in the PostedFile property of the input.
|
|
|
|
|
how to call a javascript function from javascript file in asp.net 2.0
i added a java script file
and written two functions
now how to call these two functions
how can i get reference to that file
plz help me
thanks in advance
vijay
|
|
|
|
|
vijaylumar wrote: how to call a javascript function from javascript file in asp.net 2.0
Include the JS file to the page(head section) and call as usual.
|
|
|
|
|
plz help me!!!!!! I'm making an online examination and counselling project for my training. but I'm stuck at using timer in the examination. somebody plz help fast.
|
|
|
|
|
Panks_macho wrote: somebody plz help fast.
You are getting first reply after 6 hours ! If you mind to read the forum posting guidelines before posting, you could have formatted a better question and might have got many replies. Asking for urgent help is considered as rude here.
Panks_macho wrote: but I'm stuck at using timer in the examination
This is not explaining anything. What are you using ? Are you using "setTimeout" JS method or "Timer" control in the "AJAX Toolkit" ? What is the error you are getting ?
|
|
|
|
|
i have create run time pdf file . how to read this file and give the print without opening pdf file.
Thank & Regards
Lav
lav naphade
|
|
|
|
|
Accessdatasource control
1> i m using insertcommand with simple query to insert data in access but nothing is happening.
2> how i can use parameter query to for insertcommand.
thanks in advance.
|
|
|
|
|
dream_liner_7e7 wrote: i m using insertcommand with simple query to insert data in access but nothing is happening.
Please stop posting same question. Follow the previous thread which you created. What do you meant by nothing is happening ? Are you getting any error ?
dream_liner_7e7 wrote: how i can use parameter query to for insertcommand.
I believe the MSDN example which I given shows this. Isn't it ?
|
|
|
|
|
1> i need to insert data through accessdatasource
2> can i use parameterized queries to select or insert data
thanks in advance.
|
|
|
|
|
dream_liner_7e7 wrote: i need to insert data through accessdatasource
It has a InsertCommand property. Write your query there.
dream_liner_7e7 wrote: can i use parameterized queries to select or insert data
Yes. MSDN[^] has an example.
|
|
|
|
|
I am working on a project and I am a bit stumped with sorting of a Gridview. I am creating a DataTable, and one of the columns is populated with decimal numbers ranging from -100.00 to +100.00. I then DataBind the DataTable to the GridView, and then sort on the column. The problem is its sorting it as text, not as decimal numbers - so its sorted something like this: 9.33, -7.6, 3.3, 2.02, 14.6, -1.8, -1, 0.99, etc which isn't at all what I want! How can I make the GridView realise the data is decimal, not text, and sort correctly. I am almost at the point where I might just insert the numbers back into SQL as decimal, and then read it back in sorted!
Thanks
|
|
|
|
|
Do you have all column type specified for your data table ? If yes, take a DataView from it and use sort functions on the DataView and bind DataView to the grid.
|
|
|
|
|
Thank you, that has worked! (dt.Columns.Add("SortColumn").DataType = System.Type.GetType("System.Decimal") )
|
|
|
|
|
|
Hi
i want to create maultiLanguage webSite, for this, each web page has two resource, en-US and ar, i want when user select en-US, RightToLeft set to No, and when user select ar(Arabic), RightToLeft set to Yes, but how to do this ?
thanks
|
|
|
|
|
i wanna add sound recorder in COM componentss of vs 2005
i tried to add [b]sndrec[/b] from System 32 bt giving error
m using visual studio 2005
help me plss
scrapp me if u knww
|
|
|
|
|
Are you the same guy who has been spamming the whole site with this question ? If so, you have been answered.
Either way, you cannot record sound with ASP.NET
Christian Graus
Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
|
|
|
|
|
When a client is connected with the server, a session is assigned with that client uniquely, now a sessionID is stored as cookie on the client's system.
Now, i m trying to check the value of this ID, as Session.SessionID
but, each time the page is re-loaded, the ID changes .... !
Why does the ID change ?
Is there anything wrong in my code, or the ID actually changes when the page is re-loaded ???
|
|
|
|
|
i thinkkk sesssiion closes
after u reload and new session is created
check out ur code properly
|
|
|
|
|
my code,
protected void Page_Load(object sender, EventArgs e)
{
System.Windows.Forms.MessageBox.Show(Session.SessionID.ToString());
}
The above code shows a message box with the current Session ID.
|
|
|
|