Re: Update Database(ACCESS) from ASP page - ASP.NET Discussion Boards

Re: invoke webservice with xmlhttprequest

Cybernate11-Mar-09 6:38

11-Mar-09 6:38

You can use WebRequest class to do the same at server end.
Or create a proxy for the web service using the wsdl tool provided by .Net to achieve Stong type safety

Regards,
Cybernate

Re: invoke webservice with xmlhttprequest

impeesa_0111-Mar-09 15:42

impeesa_01

11-Mar-09 15:42

hi Cybernate,
thanks for your reply. but i really new in this field and just a little of web programming. could you give me link where i have to go, meanwhile i am trying to googling. shall i create a webservice to consume it webservice since the target webservice provided by another party, or just create web page to consume the webservice?

thanks and regards,
edi

gain new knowledge through knowledge-sharing

Cannot Use IIS

MrColeyted10-Mar-09 14:40

MrColeyted

10-Mar-09 14:40

Hello all. I am using a laptop that is running Windows XP Professional. The other day, a breaker in my house kept constantly tripping. It was the breaker that my laptop was plugged into. My computer shut down, and when I booted, I got an error that a file in C:\WINDOWS\System32\config was corrupt. I was able to use the XP CD to replace the corrupt file, but now I have some serious issues. Aside from the absence of all of my SQL Server servers (SQLExpress, other named instances), I cannot open or create any ASP.NET Websites that rely on IIS. When I open the MMC for IIS, there is nothing there. I do not know what to do. I have tried:

- Rebooting the machine (several times)
- Running aspnet_regiis -i from the VS cmd in the v2.0.50727 dir
- Running 'regedit.exe add HKLM\system\... to add a variable (this was recommended in another forum that I read)
- Running DCOMCNFG and placing a tick in the use internet services box

Since I cannot do a system restore that restores beyond the time that I repaired the system originally, I do not know what to do! Confused | :confused:

Please help. I need IIS to work for my ASP.NET development.

"If you don't know where you're going, you'll probably end up somewhere else." Yogi Berra

Re: Cannot Use IIS

Yusuf10-Mar-09 15:23

Yusuf

10-Mar-09 15:23

how about reinstalling IIS

Yusuf

Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]

Re: Cannot Use IIS [modified]

MrColeyted10-Mar-09 15:32

MrColeyted

10-Mar-09 15:32

I have tried to reinstall IIS several times. I have used the CD, as well as downloaded what others online have said was a .rar file of the IIS files. But I do not know how to use the latter. While reinstalling IIS (through control panel\add remove programs\add remove windows components) it only gave me an option of where to find the files the first time, which is when I was using the cd. Since that did not work, I suspect that it has something to do with an environment variable, or a setting that I do not know about.

"If you don't know where you're going, you'll probably end up somewhere else." Yogi Berra

modified on Wednesday, March 11, 2009 2:13 AM

Exception handling with web services in ASP.NET 3.5

Member 391904910-Mar-09 14:14

Member 3919049

10-Mar-09 14:14

I used to create web services in ASP.NET 1.1 and the primary exception thrown from a web service back to a caller was (if I remember correctly) a SoapException.

I have created a new asmx web service in 3.5 and was creating some tests for exception handling. I created a DivideByZeroException in the web service but the primary exception being thrown to the caller is a FaultException (not SoapException).

Is FaultException the primary exception thrown by .NET 3.5 for web services -replacing the old SoapExcpetion - or does it have something to do with the type of exception or the way my environment is configured?

Update Database(ACCESS) from ASP page

daks90610-Mar-09 10:13

daks906

10-Mar-09 10:13

Hi, Please help

I am new to programming. and I am trying to update a value in the database(ACCESS) with a value in a textbox on an ASP page.

the conditions are that "value" in database can only change if it is smaller than value in textbox in the ASP page.

I can INSERT, UPDATE, and DELETE values in the database from the ASP page. I just dont know how to write it with the "if" statement so that it can work

thanks for the help

Re: Update Database(ACCESS) from ASP page

Yusuf10-Mar-09 11:20

Yusuf

10-Mar-09 11:20

daks906 wrote:
the conditions are that "value" in database can only change if it is smaller than value in textbox in the ASP page.

This does not need to be done in the database. You can handle it at UI using javascript code.

One way to do this is, set the value in the database to a hidden field, then on submit compare the user value to the hidden value, and if you're not going to accept it show error message.

ASP.Net 1.1, VB.Net 2003 and SQL Server 2005

Ragonastick10-Mar-09 9:43

Ragonastick

10-Mar-09 9:43

Hi I am new to programming with ASP.Net and I am looking for some information.

I currently have a database locally on my machine, and I am trying to connect and read one of the tables through the VB. I have gone to many website, and tried a couple of things but I get up to a point and its still crashing when I go to open it. One thing you will notice is that I do not have a password on my database because there is not one on my machine.

This is the code I have in my page load

Dim oConn As New System.Data.SqlClient.SqlConnection
       Dim oCom As System.Data.SqlClient.SqlCommand
       Dim oDr As System.Data.SqlClient.SqlDataReader
       Dim sSQL As String

       sSQL = "SELECT * FROM AdminTypes"
       oConn = New System.Data.SqlClient.SqlConnection("server=MCF1500\SQLEXPRESS;uid=JWilson;pwd=;database=MCF_Staff;Trusted_Connection=yes")
       oConn.Open()   'Crashes HERE

       oCom = New System.Data.SqlClient.SqlCommand(sSQL, oConn)

       oDr = oCom.ExecuteReader()

       Do While oDr.Read()
           ' Show database data
       Loop
       oConn.Close()

And I have this code in my WEB.config File

<configuration>
    <appsettings>
        <add key="DBConString" value="Uid=JWilson;pwd=;server=MCF1500\SQLEXPRESS;database=MCF_Staff" />
    </appsettings>
  <system.web></system.web></configuration>

I was wondering if anyone could help me out with his. If so it would be much appreciated. If not then I am switching over to PHP for this project because I understand it better.

Re: ASP.Net 1.1, VB.Net 2003 and SQL Server 2005

Ragonastick10-Mar-09 9:46

Ragonastick

10-Mar-09 9:46

Odd the webconfig code did not show lets post that again

<configuration>
   <appSettings>
        <add key ="DBConString" value="Uid=JWilson;pwd=;server=MCF1500\SQLEXPRESS;database=MCF_Staff" />
    </appSettings>
  <system.web>

Re: ASP.Net 1.1, VB.Net 2003 and SQL Server 2005

Rutvik Dave11-Mar-09 6:20

Rutvik Dave

11-Mar-09 6:20

Ragonastick wrote:
One thing you will notice is that I do not have a password on my database because there is not one on my machine.

If you are talking about SQL Server Management Studio is not asking you a password, then you are login using windows authentication. and you are using sql authentication in your application, so you cannot login.

if this is the case then,

open sql server management studio using your windows authentication, now go to security -> Login abd create one login with username & password, and then use that username & password in your application to login.

you cannot login to sql server without specifying a password in your connection string.

Re: ASP.Net 1.1, VB.Net 2003 and SQL Server 2005

Ragonastick13-Mar-09 7:20

Ragonastick

13-Mar-09 7:20

Thanks man I think you are correct. I am looking around but I think the guy that was working on this project before I started working on it did not write it down or leave any information on the password he left. Looks like I may have to reinstall, and back up the files.

compilation error while running the application

misha singhal10-Mar-09 8:16

misha singhal

10-Mar-09 8:16

Can anybody tell me the reason behind this type of error...Is my framework corrupted??
Could not write to output file 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\website\6689c1b9\c4abb612\App_Web_evww1nqy.dll' -- 'Access is denied. ' Confused | :confused:

Re: compilation error while running the application

Calin Tatar10-Mar-09 9:28

Calin Tatar

10-Mar-09 9:28

Have a look here[^].

Calin

creating a daemon process [modified]

liz310-Mar-09 8:00

liz3

10-Mar-09 8:00

I'am creating a website where the front-end is bein developed using ASP .NET,the code so far has been written using VB .NET and all data is stored using MS SQL Server 2000.Everytime the user logs in and performs some activity the database contents are changed correspondingly.
Now i need a process that runs in the background on the server side such that everytime a user fills in a particular form, the process initiates a timer for say,15 mins and wen the timer expires some database modifications are made.This has to be true for every incoming request from the user.So if Im not wrong i need a daemon process that awaits an incoming request and then performs the above-said activity. I have no idea what i need to use in order to achieve this.Please help.

modified on Tuesday, March 10, 2009 11:33 PM

Re: creating a daemon process

fred_10-Mar-09 8:24

fred_

10-Mar-09 8:24

try a Workflow

Looking for a starting point (ftp7 lockout)

cechode10-Mar-09 6:53

cechode

10-Mar-09 6:53

Trying to get something written that will trap all FTP traffic and add IP address to blocked list after X number of failed login attempts.
Not sure where to even start looking for a way to write this.
Any pointers would be greatly appreciated

other than that loving IIS7

OR if you know of something that already does it.... please save me the pain and point me that way as well.

Page.isValid is not affected by ValidationGroup hange

tiktak610-Mar-09 5:49

tiktak6

10-Mar-09 5:49

visible='<%Convert.ToBoolean((RecordingConfigurationManager.sysConfig.GetLicensedChannels(RecordingConfigurationManager.current.CaptureModule.CaptureTypeId) - (Int64)RecordingConfigurationManager.current.CaptureModule.cacheCaptureDS.tblLoggerCapture.Compute("SUM(iUsedChannels)", "")) > 0))?True:False %>'

I have a webpage with a hidden textbox and a combo. The textbox should becaome visible and validated when a specific value ("other") in the combo is selected. To validate it, I use a requiredFieldValidator.

To toggle the validation of the validator, I should enable / disable it both in the client side and in the server side.

To toggle the validation in the client side, I used javascript "ValidatorEnable" function and also switched the validation group from "tuti" (the validated group) to "nonValidated" (the non-validated group).

On the server side, I also made the same validation group toggling acording to the combo selected value.

after that I used Page.Validate("tuti"). but when I checked Page.isValid, I got false even when the validation group was changed (in JS and in sever side!).

Here is the ASPX file:

1 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="AJAXEnabledWebApplication2._Default" %>
2
3 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4
5 <html xmlns="http://www.w3.org/1999/xhtml">
6 <head runat="server">
7 <script type="text/javascript" src="jquery.js"></script>
8 <title>Untitled Page</title>
9 </head>
10 <body>
11 <form id="form1" runat="server">
12 <asp:ScriptManager ID="ScriptManager1" runat="server" />
13 <div>
14 <asp:DropDownList ID="ddlMimeType" runat="server">
15 <asp:ListItem Value="mp3">audio/mpeg</asp:ListItem>
16 <asp:ListItem Value="wma">audio/wma</asp:ListItem>
17 <asp:ListItem Value="other">Other</asp:ListItem>
18 </asp:DropDownList>
19 <asp:TextBox ID="txbOtherMimetype" runat="server" />
20 <asp:RequiredFieldValidator ID="valEncOtherMimetypeRequired" runat="server" ControlToValidate="txbOtherMimetype"
21 ForeColor="#990066" ErrorMessage="You have to specify a custom mimetype." ValidationGroup="tuti" />
22
23 <%-- runat="server" ID="sampling"></asp:TextBox>
24 <asp:RequiredFieldValidator runat="server" ID="testi" ControlToValidate="sampling"></asp:RequiredFieldValidator>--%>
25 <asp:LinkButton runat="server" Text="buttonit" CausesValidation="true" ID="buttonit" ValidationGroup="tuti" OnClick="SaveValues"></asp:LinkButton>
26 <asp:LinkButton runat="server" Text="NoTuti" CausesValidation="true" ID="LinkButton1" OnClick="SaveValues"></asp:LinkButton>
27 </div>
28 </form>
29
30 <script type="text/javascript">
31 $(document).ready(function() {
32 toggleOtherMimeType(("#<%= ddlMimeType.ClientID %>"))
33 });
34
35
36 $(document).ready(
37 function() {
38 $("#<%= ddlMimeType.ClientID %>").change(
39 function() {
40 toggleOtherMimeType(this);
41 });
42 }
43 )
44
45 function toggleOtherMimeType(elem) {
46 var valEncOtherMimetypeRequired = document.all ? document.all["valEncOtherMimetypeRequired"] : document.getElementById("valEncOtherMimetypeRequired");
47 var buttonit = document.all ? document.all["buttonit"] : document.getElementById("buttonit");
48 if (elem != undefined) {
49 if (elem.value == "other") {
50 $("#<%= txbOtherMimetype.ClientID %>").show();
51 ValidatorEnable($("#<%= valEncOtherMimetypeRequired.ClientID %>")[0], true);
52 valEncOtherMimetypeRequired.validationGroup = "tuti";
53 buttonit.validationGroup = "tuti";
54 }
55 else {
56 $("#<%= txbOtherMimetype.ClientID %>").hide();
57 ValidatorEnable($("#<%= valEncOtherMimetypeRequired.ClientID %>")[0], false);
58 valEncOtherMimetypeRequired.validationGroup = "NoValidate";
59 buttonit.validationGroup = "NoValidate";
60 }
61 }
62 alert(valEncOtherMimetypeRequired.validationGroup);
63
64
65 }
66
67
68
69 </script>
70
71 </body>
72 </html>
73

and the CodeBehind:

1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11
12 namespace AJAXEnabledWebApplication2
13 {
14 public partial class _Default : System.Web.UI.Page
15 {
16 protected void Page_Load(object sender, EventArgs e)
17 {
18
19 }
20
21 protected void SaveValues(object sender, EventArgs e)
22 {
23 if (ddlMimeType.SelectedValue != "other")
24 {
25 valEncOtherMimetypeRequired.ValidationGroup = "NoValidate";
26 buttonit.ValidationGroup = "NoValidate";
27 }
28 else
29 {
30 valEncOtherMimetypeRequired.ValidationGroup = "tuti";
31 buttonit.ValidationGroup = "tuti";
32 }
33 Page.Validate("tuti");
34 System.Diagnostics.Debug.WriteLine("ddl validation group is: " + valEncOtherMimetypeRequired.ValidationGroup);
35 System.Diagnostics.Debug.WriteLine("is page valid? " + Page.IsValid);
36
37 }
38 }
39 }
40

Any ideas how to disable fully the validation?

thanks,

Hadar

Deferred Evaluation in LINQ

nkmkrishna10-Mar-09 3:02

nkmkrishna

10-Mar-09 3:02

What is meant by Deferred Evaluation??
Wtat is the use of that one in LINQ??

Thanks,
NKMKrishna

Re: Deferred Evaluation in LINQ

Calin Tatar10-Mar-09 7:55

Calin Tatar

10-Mar-09 7:55

Please have a look at http://msdn.microsoft.com/en-us/library/bb943859.aspx[^]
and see a sample at http://msdn.microsoft.com/en-us/library/bb669162.aspx[^]

Calin

Gridview ?

Che _Guevara10-Mar-09 2:15

Che _Guevara

10-Mar-09 2:15

What is the use of the GridView .Where i should be use.Give me an

example for that.

by

che

Re: Gridview ? [modified]

rakeshs31210-Mar-09 2:26

rakeshs312

10-Mar-09 2:26

Refer some books,google and get some basics,dont try jump in the middle and deepest part first.

modified on Tuesday, March 10, 2009 8:45 AM

Re: Gridview ?

nagendrathecoder10-Mar-09 2:36

nagendrathecoder

10-Mar-09 2:36

It is used to display data stored in some database table.
You can goggle about it too.

Re: Gridview ?

BalasubramanianK10-Mar-09 2:44

BalasubramanianK

10-Mar-09 2:44

GridView is used to show the data from database.
It will help you and if you google, you can get more samples like this.

<a href="http://www.codeproject.com/KB/aspnet/ScrollingGridView.aspx">http://www.codeproject.com/KB/aspnet/ScrollingGridView.aspx</a>[<a href="http://www.codeproject.com/KB/aspnet/ScrollingGridView.aspx" target="_blank" title="New Window">^</a>]

Balasubramanian K.

Re: Gridview ?

impeesa_0110-Mar-09 21:01

impeesa_01

10-Mar-09 21:01

i used to use gridview to show detail record from certain header. for example, i record data from Purchase order which contains POHeader saved in table named T_Header that consist of Pono, podate,requester,supplier, and orderdetail saved in table named T_Detail consist of orderlineno, partcode, and priceunit which is recorded line by line. all orderdetail i have recorded shown in gridview.

regards,
edi

gain new knowledge through knowledge-sharing

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.