Web Development

MinaFawzi21-Dec-05 22:23

21-Dec-05 22:23

when i search fro it i found that it is supported to asp.net vertsion 2.0, i need something work fpr version 1.1

Thanks

MiNa

analytiks22-Dec-05 1:12

analytiks

22-Dec-05 1:12

i believe you want to invoke a post back from javascript so that you can process the datagrid updation in the code behind ~ if this is it then what you can do is have a hidden ASP Button in the aspx page ~ say 'btnA' ~ call the js function below ~ this will cause a post back for btnA click event ~ in the btnA's click handler you can write the datagrid updation code

function submitdatatoserver()
{
var theform;
if (window.navigator.appName.toLowerCase().indexOf("netscape") > -1) {
theform = document.forms["form1"];
}
else
{
theform = document.form1;
}
theform.__EVENTTARGET.value = 'btnA'.split("$").join(":");
theform.__EVENTARGUMENT.value = '';
theform.submit();
}

-- modified at 7:14 Thursday 22nd December, 2005

MinaFawzi22-Dec-05 5:02

22-Dec-05 5:02

i will try it, it may solve my problem Smile | :)

, but can anyone plz discuss this code and explain it to me

MiNa

analytiks22-Dec-05 19:28

analytiks

22-Dec-05 19:28

When the postdatatoserver function, it programmatically submits the form to the server by calling submit on the DHTML object specified in the __EVENTTARGET element. you can also check this out this way. Put a textbox in your form, set AutoPostback to true, and have an event handler for the textchanged event of textbox. When the page is rendered in the browser, do a ViewSource, in the source you will find a code similar to

function __doPostBack(eventTarget, eventArgument) {
var theform = document._ctl0;
theform.__EVENTTARGET.value = eventTarget;
theform.__EVENTARGUMENT.value = eventArgument;
theform.submit();
}

MinaFawzi24-Dec-05 3:36

24-Dec-05 3:36

i tried this solution in a simple test application ,but i didnt work Frown | :(

i created a button and set the visible property of it to false and its name was Button1
then i add an image and link the onclick event of it to this function, but when i click on the image there is an error occured : error :'__EVENTTARGET" is null or not an object
all what i modify is the btnA to button1

MiNa

analytiks25-Dec-05 2:38

analytiks

25-Dec-05 2:38

that is because the __EVENTTARGET is a html hidden field. it is not present in your page ~ add it to your .aspx file ~ but be sure that there are not more than 1 __EVENTTARGET fields in your form ~ if there are more than 1, it will not work ~ when autopostback properties of controls like textbox, datagrid, datalist etc are set to true, the __EVENTTARGET is generated automatically and in that case u will have to remove the __EVENTTARGET field that you had added in the .aspx page.

MinaFawzi25-Dec-05 13:31

25-Dec-05 13:31

thanks man
i add an iage to my form
and here is what is generated in the html code page :

then i add the function between the script tag after the form tag :
function submitdatatoserver()
{
var theform;
if(window.navigator.appName.toLowerCase().indexOf("microsoft") > -1)
{
theform = document.forms["form1"];
}
else
{
theform = document.form1;
}
theform.__EVENTTARGET.value = 'Button1'.split("$").join(":");
theform.__EVENTARGUMENT.value = '';
theform.submit();

}

and i write all what i want to update in the button1 event, and still having the same error .
plzz help

MiNa

-- modified at 19:35 Sunday 25th December, 2005

enjoycrack22-Dec-05 6:52

enjoycrack

22-Dec-05 6:52

Do you mean AJAX only supports ASP.NET 2.0? where do you search from, give me the link?

<< >>

ODBC on the WebServer

gmhanna20-Dec-05 10:25

gmhanna

20-Dec-05 10:25

Hi, I have an application that is reading a DB4 file. I can take the application, run it on the machine that hosts the webserver and it reads the file just fine. I have it all setup under ODBC Data Sources. However, when I try to do the same thing on the Webserver, gives me an error trying to open the file. Using the FileMon utility from Sysinternals.com, it never attempts to open the file, at least the file I was hoping for.

So my question is how do you tell the Webserver where the file is located?

Thank you,

Glenn

Andy Brummer20-Dec-05 11:17

Andy Brummer

20-Dec-05 11:17

You haven't provided enough information to answer your question.
Where and how are the file path specified. If it is in the ODBC data source on the server then you probably need to find the path on the server where the file is located and update the ODBC setting.

If it is a relative path specified by the application, using Server.MapPath("/") will give you the directory on the server at the root of your web application.

gmhanna20-Dec-05 12:47

gmhanna

20-Dec-05 12:47

I selected Data Sources from the Administrative tools. I added a User DSN and a System DSN and tried adding a File DSN. However the File DSN is not showing up but if I try to add it again it tells me it already exsists.

These are DB4 databases (.DBF and .MDX) files. The files exist in the application root directory.

I have the Webserver default page set to d:\development and I have changed WWWROOT$ to also point to d:\development. I then added a Virtual Directory called MCP which exsists under D:\development. So the directory structure is d:\development\mcp. The DB4 databases are in d:\development\mcp, which is also the path information that I put into the Data Sources.

I created a simple program that is a form that has two buttons, one says "Load Merchant" and the other says "Load Userids". The code for the userids is the same for the merchants, however the table name changes. See code below:

string				strCompanyName;<br />
			OdbcDataAdapter		odbcDataAdapter;<br />
			OdbcCommandBuilder	odbcCommandBuilder;;<br />
			OdbcConnection		odbcConnect;<br />
		          <br />
			// ---------------------------------------------------------------------------<br />
			// Prepare to open the Merchant Database to populate the Merchant names<br />
			// ---------------------------------------------------------------------------<br />
			DataSet		dataSet = new DataSet( );<br />
<br />
			odbcConnect = new OdbcConnection("DSN=MCP;");<br />
			<br />
			try<br />
			{<br />
				odbcConnect.Open( );<br />
			}<br />
<br />
			catch<br />
			{<br />
				cbMerchant.Items.Add("ERROR OPENING MCP");<br />
				return;<br />
			}<br />
<br />
			odbcDataAdapter = new OdbcDataAdapter("Select * from Merchant", odbcConnect);<br />
			odbcCommandBuilder = new OdbcCommandBuilder(odbcDataAdapter);<br />
			odbcDataAdapter.Fill(dataSet, "Merchant");	<br />
<br />
			DataTable dataTable = dataSet.Tables[0];<br />
<br />
			foreach (DataRow dataRow in dataTable.Rows)<br />
			{<br />
				strCompanyName = (string) dataRow["NAME"];<br />
				cbMerchant.Items.Add(strCompanyName);<br />
			}<br />

When I make a non-web version of the same code it works perfect, all the entries from the DB4 file gets loaded into a Combobox, yet when I run this on the Webserver, the "catch" block of code grabs it and says, "Error opening MCP".

Filemon shows no attempt at all trying to open the database on the D drive, however I had it scoped only to D, it maybe trying to open something on C:.

I don't want to hard code a file path as this can change per installation. I know I can code something in Web.config but I rather not. I was trying to use "Code Base SQL 2.0" to read the file since I had a license for it, however it was having problems reading the Merchant Table for some reason.

Glenn

Guffa20-Dec-05 21:31

Guffa

20-Dec-05 21:31

You are catching the exception but not the exception information, so you have no clue what the error is.

Remove the try...catch while testing, or catch the exception information and re-throw it:

try {
...
} catch (Exception e) {
throw e;
}

---
b { font-weight: normal; }