|
Have you ever tried with FSO?
Regards,
Venkatesh Mookkan.
Software Engineer, India
|
|
|
|
|
Try with FileSystemObject...
Regards,
Venkatesh Mookkan.
Software Engineer
|
|
|
|
|
Dear All,
I am making web application using Asp.net and C#(Visual Studio 2005). In one web page . i have made three controls Autopostback property true.
Out of them two of them works fine. but I am having problem with third one. Is that one can use only two controls on a page whose autopostback true
Please Help me.
regards
imran khan
|
|
|
|
|
There is no restriction on how many controls in your page can have AutoPostback="true".
So something other is going wrong there.
Arindam
|
|
|
|
|
if postback is true then atleast it should go thrugh text_changed. but flow is not going through it . what cold be reason. please guide
regards
imran khan
|
|
|
|
|
What are the 3 controls you are having and which one is creating trouble to you?
Arindam
|
|
|
|
|
Thanks for quick reply
Firh i am using Combo Box Control(Autopostback true). I wrote the following code which work fine(this code is to select service code and fetch from database corresponding max recordno and assign 1+ max record no to textbox1 )
protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)
{
setting = ConfigurationManager.ConnectionStrings["Databaseconnection"];
if (setting != null)
{
SqlConnection conn = new SqlConnection(setting.ConnectionString);
query = "select max(serialNO) from inquirydtl where serviceid = '" + DropDownList1.SelectedItem + "'";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
//TextBox1.Text = cmd.ExecuteScalar() + 1;
int i;
//SqlDataReader rdr = cmd.ExecuteReader();
if (cmd.ExecuteScalar().ToString().Equals(""))
{
TextBox1.Text = "000001";
}
else
{
TextBox1.Text = cmd.ExecuteScalar().ToString();
}
TextBox1.Focus();
}
}
Seond i am using Textbox(Autopostback) true .where i want to concatenate it with textbox1.text to generates inquiryid . check for its existnace but it does not work. In debug mode. flow does not go through it.even then i made corresponding TextBox1.AutoPostBack = true; in page load event what is problem. please help
regards
imran khan
|
|
|
|
|
The main point lies what I feel the way TextBox autopostback event reacts.
Basically a <asp:textbox> control can do a autopostback in 3 scenario
1. Ater entering all the character in textbox, if ENTER key is pressed.
2. Ater entering all the character in textbox, if TAB key is pressed.
3. Ater entering all the character in textbox, click anywhere outside of the Textbox.
Like drop down list TextBox cant just fire server side textchangedevent as you keep entering character from keyboard one by one. If you do the same it becomes a client side event that can be tracked using anyclientside event.( onkeypress, onkeydown ... like that)
So make sure that you are initiating the postback event of the Textbox, means you are performing either of the above mentioned activities.
Hope it will help you.
Arindam
|
|
|
|
|
thanks Arindam,
I think that i am just assainging database value(Not entering) to textbox that cuases problem. How can i make sure that even i assaign from database. code execute. please guide me
thanks once againe
regards
imran khan
|
|
|
|
|
I didnt get what exactly you want to do.
Mathod TextBox1_TextChanged(....) event handler only starts executing if those condition is satisfied.
Just a suggestion. You can put your code( whatever you are writing inside TextBox1_TextChanged(....) ) just after populating the textbox values from database.
Arindam,
|
|
|
|
|
hi,
no,I wrote dropdownlist select event to get service id and fetch from database max of corresponing serial no. which i populate in textbox. now based on textbox text. i concatenate both field to create one inquiry id and checkfor it existance. for tha same i wrote code in textbox change event. but it does not fire as i fetching value from database.Now i am checking inquiry existance code on button. Is there any alternate so that user do not need to click button.
regards
imran khan
|
|
|
|
|
Hai Take One CompareField Validator and go to propeties
1.Type= integer
2.Operator= DataTypeChecking.
Happy Coding
Siddu
Software Developer
|
|
|
|
|
HI Imran,
That is not the case and you can use any number of controls that have the AutoPostBack property "true".Could you explain me the exact scenario what you want to ask?
Vicky
|
|
|
|
|
Hello, everyone,
As most of you know, Microsoft will release final AJAX version on January 2007.
I'd like to know if it's possible to include AJAX capabilities in an RDL (SQL Server Reporting Services 2005) file? We'd just need to add an UpdatePanel, right?
Or do we have to wait for a Service Pack...
Thanks,
Raphaël Désalbres
MCP - MCAD - MCSD .NET
|
|
|
|
|
Is this possible in ASP.NET in Visual Studio 2005.
I want to create a web site that contains about 4 pages. The data for each page is stored on a SQL Server 2005 database. The ConnectionString is always the same, but the SelectCommand will differ depending on that page's function. Can't I place these instructions into a global module on the web site and have them called when needed?
If this is possible, how do I create a VB module on the web site?
Thank you,
Quecumber256
|
|
|
|
|
Hey Quecumber256,
VB modules are not recommended in .NET world. But you can still create a module of your own. Just click Add New Item and add a class file. Then clear the file and add
Public Module MODULENAME
End MODULENAME
Don't try to change the extension. The file extension should be .vb only.
Another solution:
If you are going to store only the ConnectionString info then use Web.Config file which is recommended by .NET. If you want to remember any objects try Sessions.
Have a nice day man...
Regards,
Venkatesh Mookkan.
Software Engineer
|
|
|
|
|
You can place the connection string (and others) in the web.config
|
|
|
|
|
Hi ,
Store the ConnectionString in web.Config's AppSetting .Add a new class(note this is not amodule) and write your functions to retrieve the data from database .IN code behind page , call the methods from the class to display the records into page.
Vicky
|
|
|
|
|
Sir
Please consider my error when it becomes while I click an button.so please tell what are the solutions to claer it..The following errors are:
---------------------
Line 839:sub page_load(s as object,e as eventargs)
Line 840:con=new oledbconnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("db1.mdb") & ";")
Line 841:con.open()
Line 842:cmd=new oledbcommand("select * from Table1",con)
Line 843:dr=cmd.executereader()
Source File: c:\inetpub\wwwroot\project\account1.aspx Line: 841
Stack Trace:
[OleDbException (0x80004005): Could not use ''; file already in use.]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
System.Data.OleDb.OleDbConnection.InitializeProvider()
System.Data.OleDb.OleDbConnection.Open()
ASP.account1_aspx.page_load(Object s, EventArgs e) in c:\inetpub\wwwroot\project\account1.aspx:841
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
sargunam
|
|
|
|
|
You forgot to close the connection that has been opend already.
Whenever to use reader object it must be closed using connection object's close() method.
So what you need to do ... add the line " con.close() " and execute it.
Hope you can solve it now.
Arindam
|
|
|
|
|
Sir,
Thank u for ur reply...but it makes an error when
I already gave correctly con.close() method.but the db1.mdb has same name which stored in another path..
Is there way to come an error...please review my error
|
|
|
|
|
There is another way which produce this error. If you have been kept your mdb file open. (ie) You have been opened the db1.mdb in Access or equivalent application. Close that application before you open the connection.
Regards,
Venkatesh Mookkan.
Software Engineer
|
|
|
|
|
Thank u for ur reply...but it makes an error when
I already gave correctly con.close() method.but the db1.mdb has same name which stored in another path..
Is there way to come an error...please review my error
|
|
|
|
|
Could you debug and tell me what are you getting in,
Server.Mappath("db1.mdb")
Check the path with your location....
Regards,
Venkatesh Mookkan.
Software Engineer
|
|
|
|
|
Sir,
In my project contains two Forms.Form 1(namely Login page) and Form 2(namely account page).Form2 contains two buttons, we click an 1st button another page will open if button1 as set as start page.probably it would work directly click an form 2.But if we enter through an form1 to form2 then click button1 it forms an error like ..
File Already open in open()
so what can i do
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
