|
try to make this changes
myCommand.Parameters.Add("@ch1", SqlDbType.VarChar, 30).Value<br />
= DropDownList1.SelectedValue;
Also try to search on google [^]like first.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Thank you very much Blue_Boy it works
|
|
|
|
|
No problem.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi,
I am using a Master Page with Header, Footer, Left Column, Center (where Content Place Holder will be) and Right Column.
Now, my I have a SQL Database Driven Menu Control in the header like this:---
http://img403.imageshack.us/img403/8099/dddl.jpg[^]
Now it is working fine. The thing I want it, suppose the user clicks on "Forum".
The "Forum" related webpage will be loaded and corresponding page will be displayed in the center (content place holder section).
At this time, what should happen is that corresponding Menu Hierarchy should be displayed in the Left Column, something like this:---
http://img207.imageshack.us/img207/6738/dd2n.jpg
I am using C# in ASP.NET, please suggest some solution with code if possible...
thanx in advance
|
|
|
|
|
You want "Support" menu control on Left Column ,when user clicks header Forum ?
|
|
|
|
|
yes... same way if user clicks on ABC, ABC Menu should be there on the left hand side, and the new menu on left hand side should also offer URL features.
|
|
|
|
|
Hi,
i am developing a web app. and i got a control in javascript to show images, my question is:
If the path of the image is to be dynamically given from the database table,How could i write the code for that?
Plz help.
|
|
|
|
|
Hi Friends
I am using silver light and i have taken ScrollViewer.Just i want dynamically change the Items Control(FileUploadControl.xaml) in scrollviewer:-
(scrollviewer x:name="filesScrollViewer" grid.row="3" horizontalscrollbarvisibility="Disabled" verticalscrollbarvisibility="Visible" background="White" xmlns:x="#unknown")
(itemscontrol x:name="fileList">
(itemscontrol.itemtemplate>
(datatemplate>
(app:fileuploadrowcontrol margin="0,2" xmlns:app="#unknown">(/app:fileuploadrowcontrol>
(/datatemplate>
(/itemscontrol.itemtemplate>
(/itemscontrol)
(/scrollviewer>)
It Possible Please Help Me....
thanks
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
I think there is a special forum specific to Silverlight. Why dont you post there?
|
|
|
|
|
Thanks Sir I am new in silverlight
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
We are doing a project in asp.net 2.0 with sql server 2005,we need to move to the next record at the click of a button.We are using an sql datareader,we have one button 'show',to show each record,and in the page load, the following code is there:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
regid.Text = "1"
mysql = "select que_bank.que_no,que_bank.ans,testquestions.ans from testquestions,que_bank where que_bank.que_no=testquestions.que_no and testquestions.reg_id='" & regid.Text & "'"
cmd.CommandText = mysql
myconn.Open()
objdr = cmd.ExecuteReader()
End Sub
Protected Sub show_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles show.Click
objdr.Read()
queno.Text = objdr.GetValue(0)
cans.Text = objdr.GetValue(1)
urans.Text = objdr.GetValue(2)
End Sub
Can anyone help us?
|
|
|
|
|
Hi,
Can u use DataTable in place of DataReaader?
Regards
Anil Pal
|
|
|
|
|
I hope this is a bad practice..
In your code connection is open and seems to be never closed.
Best thing to do is to use Paging in Sql server with @rowsPerPage being 1 and @pageNum being row no.
hope u understand the concept
|
|
|
|
|
hello i want code in use capcha img use and give small example
Thanx @};-
|
|
|
|
|
|
|
How to get the Client Machine IP Address if Using Proxy and also not. I Tried the following code, but all the code is returning 127.0.0.1.
1) TextBox1.Text = HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
2) if (Context.Request.ServerVariables["HTTP_VIA"] != null) // using proxy
{
TextBox1.Text = Context.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString(); // Return real client IP.
}
else// not using proxy or can't get the Client IP
{
TextBox1.Text = Context.Request.ServerVariables["REMOTE_ADDR"].ToString();
}
3) TextBox1.Text = HttpContext.Current.Request.ServerVariables["REMOTE_HOST"];
4) TextBox1.Text = HttpContext.Current.Request.UserHostAddress.ToString();
|
|
|
|
|
Hi dear,
just try this
using System.Net;
and code :
String strHostName, IPadd;
strHostName = Dns.GetHostName();
IPAddress[] addr = Dns.GetHostAddresses(strHostName);
IPadd = addr[0].ToString();
|
|
|
|
|
This is showing the private IP of the Machine, not the actual IP.
|
|
|
|
|
I think you are running this with http://localhost/...
if upload in some live server
System.Web.HttpContext.Current.Request.UserHostAddress should work...
--------------------
logiclabz
|
|
|
|
|
OK. Now am running locally. i will try ...
|
|
|
|
|
Hi to all,
I have a issue regarding the use of sessions.
I am working on a shopping cart project. In my project I am sessions a lot in transfering data from one page to another. Sometimes even the username and passwords. I also used session for carrying the cart data from one page to another.
So I want to know, Is there anything like the session can be hacked or they are not safe?
If yes then please suggest me a method to make the sessions secure by encrypting or something like that.
Waiting for the response....
Thanks in advance.
cheers,
sneha
|
|
|
|
|
Hmmm... well first of all, session object will hit your application performance. Secondly it on server side so it's already secure as such as server. However if transfering this information from one system to another then u need to encrypt it first.
Feel free to ask.
Cheers!
Regards
Anil Pal
|
|
|
|
|
Hi Anil Pal,
Thanks for replying. You mean to say that it is already secured. Is there any chance that when the username and passwords are passed from one page to another through session, they can be leaked or something like that.
cheers,
sneha
|
|
|
|
|
Hi thats correct, they are secure. Bcz session is on server side.
So u can use session to hold the Username and password.
Regards
Anil Pal
|
|
|
|