|
Define any web form, then you established connection with any provider after this create command for
accessing query and finaly define datareader class.
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=c:/db1.mdb;");
con.Open();
OleDbCommand cmd = new OleDbCommand("select *from login", con);
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (TextBox1.Text == dr.GetString(0))
if (TextBox2.Text == dr.GetString(1))
Response.Redirect("default2.aspx");
else
lbl.Text="check the username and password";
CheckBox1.Text = "check the username and password";
}
//con.Close();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
}
}
|
|
|
|
|
Dhrumil_Shukla wrote: web server it is retrieving the data from database but does not allow saving the data
Its means your connection string is not valid. Do you have the database on web server or any different system ? What your connectionString contains?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
my datbase is on web server and the connectionstring is like
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|table.mdb;Persist Security Info=True"
|
|
|
|
|
Hi,
I am having a requirement like 'Scheduling Jobs' in a ASP.Net web site. Each user can create 'N' number of projects & schedule each project to run in a particular interval (Daily/ Weekly/ Monthly/ etc). Similarly we have 'N' number of users.
Each user needs to Edit/ Delelte the scheduled jobs & View the status.
One of my colleague suggested the below. Does any one of you have used this open source framework?
http://quartznet.sourceforge.net/[^]
Can you please suggest on this?
Jey
modified on Wednesday, August 26, 2009 5:04 AM
|
|
|
|
|
i need to show image when the user select path. ie, the file could be at any location. at the time of execution user can give any path in the textbox. and at the same time when selection is made by user in textbox the image immediately should show in the picture box.
i use this code
protected void Page_Load(object sender, EventArgs e)
{
Image1.ImageUrl = TextBox.Text;
}
|
|
|
|
|
Looks like it should work. What is the problem ?
You could even do this in javascript and not have to post back. Then it would in fact be 'immediate'
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.
|
|
|
|
|
Dear Christian,
I have a doubt... Is it possible to open a image from any location...if yes, can you give some sample.
|
|
|
|
|
I am not sure if a local path would work for a local user or not, but if it's an online location, I'd expect what you posted to work just fine.
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.
|
|
|
|
|
'Any path' means will the user select the path from his local PC?
How does the user select the path, using a browser window?
You can open a file open dialogbox using activex in javascript. But it will work in IE only.
Also you cannot display images from a folder from the client PC. It should be available in the location of your web site.
|
|
|
|
|
Hi,
I need to convert string which has EBCDIC, packed decimal and Endian data to byteArray to save it in the database. I tried the following code.
Byte[] updateByte;
updateByte = System.Text.Encoding.Default.GetBytes(strData);
//here, strData is the string
Here what happens is it converts some characters to '?' with decimal value 63. For e.g. abc(ASCII vale) after converting to EBCDIC i get [129 130 131](these are decimal values of the converted EBCDIC data). When i convert the string to byte array in order to save it in database, it changes all three characters(129, 130 and 131) to 63. This mostly happens with small case alpbhbets.
I also tried other encoding(EBCDIC-US) but this also changes more characters.
IMP: Please note that the string that i need to convert to byte array contains EBCDIC, Packed decimal and Also Endian data.
Kindly let me know how i can achieve this.
Thanks,
Deepa
|
|
|
|
|
Hi
I am using AJAX Text Slider in Grid View. When i click on Next page it works fine. When i click on First button again it does not show record count (Row command event does not get fired) and grid paging behavior becomes very inconsistent.
Please help me with this problem
Inderjeet Kaur
Sr. Software Engg
modified on Monday, August 24, 2009 3:16 AM
|
|
|
|
|
Hi All,
This code is working fine with C# but i have to use this with existing VB.Net application so that this.gettype() is giving error not defined so how to remove this
ClientScript.RegisterStartupScript(this.gettype(), "newWindow", String.Format("<script>window.open('UserSetting.aspx','ReportWindow', 'width=400,height=200,status=no,toolbar=no,menubar=no,location=yes,scrollbars=yes,resizable=no');</script>"))
Thanks ,
Amit Patel
|
|
|
|
|
Hope this will help you.
ClientScript.RegisterStartupScript(Me.GetType(), "newWindow", String.Format("<script>window.open('UserSetting.aspx','ReportWindow', 'width=400,height=200,status=no,toolbar=no,menubar=no,location=yes,scrollbars=yes,resizable=no');</script>"))
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.
www.aktualiteti.com
|
|
|
|
|
<code>Me</code> points to current object of VB not <code>this</code>.
So Me of VB is equivalent to this of C#.
|
|
|
|
|
hi
How to Access web controls inside a Static method?
Regards& Thanks
Kirti Darji
kirti
|
|
|
|
|
i think this is not possible because inside static method we can access only static variable or function.......If u find a way then please post here
|
|
|
|
|
Hello All,
I am in the way of developing a web-chat application. In my ASP.Net application i am using AJAX.
In my application first the user will login and can navigate through the page. If he like to chat then he need to click on a link, then a small ASPX Page will be opened. This will be opened via JAVA Script function named "window.open()". In this chat window i used AJAX and this will refresh for every 5 seconds. Normally the focus in the chat window will be on the text area in which the text will be entered. Even i followed the same trend. Just think the Textbox id is "TB_ToSend". In this chatwindow i have given "defaultfocus" as "TB_ToSend" and for every AJAX refresh in the OnTimer Function i have given
"ScriptManager1.SetFocus(TB_ToSend);"
where ScriptManager1 is the ScriptManager id.
But i face a problem here in IE 7 when i click on the Parent window when the chat window is open(commonly we do it when we like to switch between windows) ,then after 5 seconds the chat window will popup and i lose focus on the parent Window(due to the focus i set in AJAX timer). This is not the expected behaviour, the expectation is that the focus need to be on the Parent window. This Issue doesnot occur in FireFox. Can anyone give me sugession to overcome this or is there any other way to set the focus.
|
|
|
|
|
Right now , i buy a host and a domain. and i want to publish my project on real website : WWW.MYDOMAIN.COM . but i encounter a problem :
when i want to login to website it send me an error with this title : "Server Error in '/' Application." and contain this message :
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>
I dont undersetand what should i do !
Any Idea?
[]D @ []v[] []D @ []v[]
|
|
|
|
|
Create a file called Web.config in the root directory of your site.
Put this in the file:
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
Then it will tell you where the error is...
Warning, that will show intimate data about your site, before you go live you need to either remove that Web.config file, or better yet, set a better one up, go read about Web.config files, they are quite useful.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
i do it! but it didnt help me! any other another one Idea which can help me?
[]D @ []v[] []D @ []v[]
|
|
|
|
|
Hi all,
I am using a css class for applying horizontal line for each row in a grid view . Its work but it is applying for header line also. Is there a posiblity to remove the class property (css) for the header line.Can any one help me to code the JS.
|
|
|
|
|
Why do you need JS...
Use HeaderStyle to set the style of the header of GridView.
this is the most simple fix. ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Hello,
Using VS 2005 and ASP.NET
One Update panel with following controls:
sqldatasource.
next and previous button to naviagate.
51 textboxes to show the data from orace table.
This is select command of sqldatasource
SELECT * FROM "SECM98" WHERE (("ROL" >= :ROL) AND ("ROL" <= :ROL2)) ORDER BY ROL
Public Sub showdata(ByVal r As Integer)
SqlDataSource1.EnableCaching = True
dv = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), System.Data.DataView)
TextBox1.Text = IIf(IsDBNull(dv.Table.Rows(r - 1)("rol")), "", dv.Table.Rows(r - 1)("rol"))
TextBox2.Text = IIf(IsDBNull(dv.Table.Rows(r - 1)("cen")), "", dv.Table.Rows(r - 1)("cen"))
TextBox3.Text = IIf(IsDBNull(dv.Table.Rows(r - 1)("dst")), "", dv.Table.Rows(r - 1)("dst"))
..
..
End Sub
It is taking lot of time to run dv = Ctype(SqlDataSource1....)
Or
How do i get the resultset returned by sqldatasource, so that i can show the data in the textboxes.
Please guide and help me.
Regards
Girish Sharma
|
|
|
|
|
I think the problem might be in the database.
check how much time is required to fetch actual data from the database.
If it is taking long then use of Index might cure the problem somehow. 
|
|
|
|
|
Thanks for your reply and interest in the thread. I am using oracle 10G database with proper index on rol column. I cheked that oracle is returning the rows in only 1 second in sqlplus. It is returning the rows fast in the oracle; but taking lot of time to run dv=..... line.
Please tell me what should i do to resolve the problem.
Regards
Girish Sharma
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
