|
If you are using the ASP.NET 2.0, you might want to check out the Provider[^].
|
|
|
|
|
By using single table the question and answer should in tree format using asp.net ( example: same as message board)
prasanna
|
|
|
|
|
Homework help perchance?
I mean COME ON - at least try to disguse it
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
hi all,
i have to execute a query in page load event.
Like "select * from tbl where sName= ' " + WindowsUserName + " '"
here WindowsUserName is nothing but userName of the windows
system. I tried to use server side script to get username but their i am
getting system number rather than getting username.
But using client side scripting i am getting the windows
userName. i failed to use that username in the page load event .
my client side scipt is like this
sub fncI
dim X
set X = createobject("WSCRIPT.Network")
dim U
U=x.UserName
end sub
help me to use this user name in the page load event
thanx in advance.....
your
peter
|
|
|
|
|
If you dont want to use authentication, I have one idea how to use your clientside script, you should register it in (!IsPostBack) block in Page_Load as startup script, and this script should cause postback (domcument.form1.submit() in js, i think). Your script should save username into hidden field, you can read this value in Page_Load after first postback.
You cannot read this value when page is created (IsPostBack property is false), because client side script is called on client side after Page_Load and other methods are executed on server side.
Btw. can you post a code you use for 'getting system number' ? Maybe I can help you to get user name instead...
I hope it helps, if something is not clear, just ask...
Pilo
|
|
|
|
|
getting system number
System.Security.Principal.WindowsPrincipal p = System.Threading.Thread.CurrentPrincipal as System.Security.Principal.WindowsPrincipal;
string strName = p.Identity.Name;
Response.Write (User.Identity.Name.ToString());
WindowsIdentity user = WindowsIdentity.GetCurrent();
Response.Write(user.Name);
your
peter
|
|
|
|
|
Hi all,
i'm using a datagrid with a sqldatasource.in that i'm using where clause with 2 parameters student ID and name.but the select statement is not working when there is both ID and name is present.But its working and display the data with the ID only.Can any one give me the solutions for this?
Babu
|
|
|
|
|
What is the sql statement which you are using?
Best Regards,
Apurva Kaushal
|
|
|
|
|
select [StudentID],[Name],[Percentage] from tblstudent WHERE (StudentID = @StudentID AND Name=@Name AND Percentage=@Percentage)
this was the statement in the sqldatasource tool.
Babu
|
|
|
|
|
Hi,
Do you have any record in the database which is satisfying all the conditions here because your query is correct.
Best Regards,
Apurva Kaushal
|
|
|
|
|
hi,
i've applied this query for another table too.that is for customers.even for that it was not working.
can you give me the sql statement using OR Condition.will it work.
Actually in sqldatasource there is no need to write coding manually.just in configuration mode we can create with the option "Where" button.
Babu
|
|
|
|
|
Hi,
If you are using and condition then all the conditions has to be satisfied then only you will be able to get the result. So according to your query is you are having a record which is having all the StudentID, Name and Percentage which you have passed that will be fetched.
For OR condition just replace and with or.
Hope this will help you.
Best Regards,
Apurva Kaushal
|
|
|
|
|
SELECT [CustCode], [Name], [Addr], [OrdType], [Area], [Lob] FROM [Customer] WHERE (([CustCode] = @CustCode) OR ([Country] = @Country))
i was using dis query for another table access.but its not working.
Babu
|
|
|
|
|
are you getting any error or simply not getting the result. In case of of the second just check whether you are having the required records in the table.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Can i give yearwise scroll criteria to <asp:calender>?
thanks in advance.
|
|
|
|
|
Hi All,
I have a doubt in datagrid.
I created a datagrid with Header template columns.
In a button click event how to disable the Header template column of datagrid.
Pls gve me suggestion..
Thanks
PAul
Paul
|
|
|
|
|
dtGrid1.ShowHeader =false;
|
|
|
|
|
Hi all,
I am using linkbutton in datagrid and ONCOMMAND event I collect row ID. This Id I am saving in Session("ID").I displayed this session("ID") by messagebox on same page.Everything goes fine,but when I redirect to another page and try to use session("ID") it gives nothing.
Sub Navigation(ByVal sender As Object, ByVal e As CommandEventArgs)
Session("ID") = e.CommandArgument
MsgBox(Session("ID"))
Response.Redirect("ResumeSearchDetails.aspx")
End Sub
///ResumeSearchDetails.aspx
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
MsgBox(Session("ID"))
end if
end sub
MsgBox(Session.SessionID) gives some value on both page which is not same
that means total session is not expired only value lose.
I hope you understand my problem.
Thanks.
Teach Life To Laugh.......
|
|
|
|
|
In global.asax
on Session_onStart
initialize as
Session("ID")=null
and find whether there is any other assignment in the other pages for Session("ID").
set break point on session_onstart event to find when session got initialized
|
|
|
|
|
Hi Saumal,
We are meeting second time last time You teach lots to me.
It may be my mistake that I could not find Global.Aspx in my application.I am using .net2005 (I know in .net2003 global.ascx present in current application folder)
|
|
|
|
|
You can add global.asax by choosing new item and global application class in .net 2005
|
|
|
|
|
Hi,
Thanks,Ones again you solve my problem.
I have added
Session("ID")=null
in Global.asax
Now It's working fine.
But Is there any problem if any another page in application assign value to Session("ID")
Best Regards,
Nagraj
Let's Teach Life To Laugh.......
-- modified at 8:03 Monday 19th June, 2006
|
|
|
|
|
Hi all,
Is it possible to make a dynamic treeview in ASP.net 1.1 with VB.NET 1.1.Can somebody send any link if possible
Thank You
|
|
|
|
|
I am using asp.net(VB) and javascript in my project.
I want to redirect username from onepage to another and then popup thatusername at the bottom of that window as (welcome Username).
So i am able to achive redirecting the username useing Request.queirystring but i want to popup that thing pls help me tell how to popup that thing.
If possible send code for it.
Thanks in advance
|
|
|
|
|
window.status='hi username';
You can use this code to display in status bar of the window using javascript
|
|
|
|