|
i am using sql server 2000.
i want to pass a string parameter to sp. my problem is when the length of parameter increase 4000 then i gives error.
In 2005 sql server we can use nvarchar(MAX)
but how we can increase the length in sql 2000
One person's data is another person's program.
--J.Walia
|
|
|
|
|
probably by using a BLOB, I would think. One more reason not to use a version of SQL Server that's two versions out of date.
this is, of course, not an ASP.NET question.
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.
|
|
|
|
|
I'm Using File Upload Control in ASP.NET.. The textbox in File upload is not displayed when it is opened by Google Chrome... Other Browsers r displaying properly...  Can Anyone tell me the solution?? 
|
|
|
|
|
Shalini_U wrote: I'm Using File Upload Control in ASP.NET
The Google Renders The File Upload Control Differently
U Will Find Only The Button But Not The TextBox .But the Functionality Works Fine .
If U Want the look And Feel Of the File Upload Control U need to Use TextBox And Button and write code
If It Helps Click It as Answer
|
|
|
|
|
Hi I am New To SSRS.I need To Implement In asp.net
I Have Gone through the Wikipedia about SSRS In That I have seen two ways
The ReportViewer control processes reports in one of two ways: (a) server processing, where the report is rendered by and obtained from the Report Server; and (b) local processing, where the control renders the RDL file itself.
Please Can Any one Give me the links to work in the second way ie
local processing, where the control renders the RDL file itself
Any Help is Greatly Appreciated
I already Posted this Question in General Database .
Thanks
If It Helps Click It as Answer
|
|
|
|
|
i has been created one login.aspzx page and one master.aspx page
when i login ,i m directly redirect to master page.master page contain logout button(linkbutten).
when clicked on logout button,the page has redirect to login page.
My problem is that,in that (after i clicked the logout button)when i clicked the "Back" it will move to master page.
i want clear the session or history?????
login.aspx page :
protected void buttonLogin_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(TextBox1.Text))
{ //Focus box before showing a message
// textBoxUsername.Focus();
TextBox1.Focus();
//MessageBox.Show("Enter your username", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Response.Write("<script> alert('Enter your username');</script>");
//Focus again afterwards, sometimes people double click message boxes and select another control accidentally
TextBox1.Focus();
// textBoxUsername.Focus();
return;
}
else if (string.IsNullOrEmpty(TextBox2.Text))
{
// textBoxPassword.Focus();
TextBox2.Focus();
// MessageBox.Show("Enter your password", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Response.Write("<script> alert('Enter your password');</script>");
TextBox2.Focus();
// textBoxPassword.Focus();
return;
}
using (DataTable dt = LookupUser(TextBox1.Text))
{
if (dt.Rows.Count == 0)
{
TextBox1.Focus();
// MessageBox.Show("Invalid username.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
Response.Write("<script> alert('Invalid username.');</script>");
TextBox1.Focus();
return;
}
else
{
//Always compare the resulting crypto string or hash value, never the decrypted value
//By doing that you never make a call to Decrypt() and the application is harder to
//reverse engineer. I included the Decrypt() method here for informational purposes
//only. I do not recommend shipping an assembly with Decrypt() methods.
string dbPassword = Convert.ToString(dt.Rows[0]["Password"])…
string appPassword = (TextBox2.Text);
//we store the password as encrypted in the DB
if (string.Compare(dbPassword, appPassword) == 0)
{
Session.Add("islogin", true);
Response.Redirect("Firstmain.aspx");
}
else
{
//You may want to use the same error message so they can't tell which field they got wrong
TextBox2.Focus();
// MessageBox.Show("Invalid Password", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Response.Write("<script> alert('Invalid Password');</script>");
TextBox2.Focus();
return;
}
}
}
}
master page :
protected void Page_Load(object sender, EventArgs e)
{
lblTime.Text = DateTime.Now.ToLongDateString();
if ((Session["islogin"] == null) || (Session["islogin"] == ""))
{
Response.Redirect("frmLogin.aspx");
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
Session.Remove("islogin");
Session.Clear();
Response.Redirect("frmlogin.aspx");
}
please send me response aor solution as soon as possible!!!!!!!!!!!!
|
|
|
|
|
shru_dhuri wrote: please send me response aor solution as soon as possible!!!!!!!!!!!
If this is a paid job ( allowing you to set a time limit ), please place it in the job section.
shru_dhuri wrote: //MessageBox.Show("Enter your username", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
It's clear you're barely learning how to use ASP.NET. You're clearing the session. The question becomes, how does each page make sure that the user is logged in, and redirect them if they are not ?
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.
|
|
|
|
|
There's a lot of comments in this code that are wrong. Did you copy this code from somewhere ? In any case, I have to wonder why it is that you want help 'as soon as possible', but don't respond when someone answers.
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.
|
|
|
|
|
Hi all,
In a ASP.NET website, I have used Login View to show the Login Status. For Login I have used Login Control.
It is showing status correctly. But after few idle minutes, it is automatically login view text changing to "login"
But user is already logged in. I think this is Session problem. I have used below line earlier. I commented it now.
Still same problem.
<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes" cookieless="UseCookies" timeout="1400" />
pl.help me out
Ramesh Sambari
Knowledge is like honey.
Collect it, to make life sweet.
|
|
|
|
|
Hi all,I am developing one project and right now i have the task to develop forum can anyone gimme some idea how i should proceed.I know the functionality of forum but problem is how to do implement it technically anyone please help.Like how to store into database,how to display etc...
Thanks
|
|
|
|
|
|
|
Sagar Singh Biswakarma wrote: Like how to store into database,how to display etc...
Either the forum is by far the most complex part of your project, or you're in a real mess.
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.
|
|
|
|
|
Hi
I am completely new to web services, but after doing some reading around, I have found that the WCF Web Services fits the bill. My project are looking to use the Web Service to get an XML document from a server and pass it through the same web service to another application and pass messages back in XML. The Web Service will not being doing anything except passing documents back and forth.
The Web Service will be called from an ASP.Net application.
Being completely new, is there an example I can follow that shows me how to pass an XML through a web service to an application and back again?
Thanks
|
|
|
|
|
|
Abhishek Sur wrote:
http://aspadvice.com/blogs/joteke/archive/2008/10/26/Calling-WCF-service-asynchronously-from-ASP.NET.aspx[^]
and
http://msdn.microsoft.com/en-us/library/aa702682.aspx[^]
Unfortunately both the links provided by you are not explaining what OP is asking.
|
|
|
|
|
You can read the XML file into a string and pass it like sending normal strings. After receiving the XML string, you can load it to XmlDocument class.
|
|
|
|
|
Hello friends,
Pls can you explain me difference between the document.write() and document.writeln() in JavaScript language?
modified on Monday, September 14, 2009 2:31 PM
|
|
|
|
|
|
writeln is almost similar to write, the only difference is writeln places a newline character after each expression.
Actually you cant see them in browser as newline character in browser is <br/>. But the html will be placed in newline. 
|
|
|
|
|
writeln is almost similar to write, the only difference is writeln places a newline character after each expression.
means to say that if we use code something like
document.writeln("Hello");
document.write("Hello I am new here.");
then
OUTPUT:
Hello
Hello I am new here.
|
|
|
|
|
no .. as I already told you...
It places newline on the html not in its output.
Output will be
HelloHello I am new here.
but if you look into innerHTML it will write like
Hello
Hello I am new here.
To make the output appear newline, you need to use <br/>
|
|
|
|
|
I gave you the link to the documentation in my previous response. I would suggest you read through that a few times then create a test HTML file and see for yourself what the results are.
|
|
|
|
|
|
Hi...
I have created virtual directory in my production server..
how would I map it with my default website...
I want my virtual directory to be accessed if user browse the url xyz.com..
thanks...
By:
Hemant Thaker
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
