Posts made by Dirso

Dirso

Hi, I have this webapplication with some webservices on it. I'd like my client software to be abble to access them, so far so good. My question(s) is(are): 1) Do I have to add the webreference to the client point to each server it can access? 2) Is there a better way to change the URL for the webservice reference, so the client can be configured to access a new server anytime?

Thanks, Dirso

Dirso

Hi, I saw a few question about that but couldn't find the answer so far. The problem is that several times a day my WebApplication is getting slow at the first load. It doesn't use db in the first page or anything is just a default welcome page. www.supercontrole.com I thought that IIS could be "re-compiling" the webapplication more often than I actually update it. Any ideas of how could I check if it is happening and how to avoid it?

Thanks, Dirso

Dirso

Yeah, you're right, it should be independent... it's just a lot of extra work (my objects are much more complex than what I showed).

Thanks, Dirso

Dirso

Hi! 1) I see, i think it would work, but the other problems keep comming 2) Didn't work for me. The Items are a IList I tried to XmlInclude Item, but it still doesn't seem to be exported

Thanks, Dirso

Dirso

Hi, I have this class:

[Serializable]
public class Item
{
public string ProdName { get; set; }
public string Qty { get; set; }
}

[Serializable]
public class Order
{
public DateTime Dt;
public int CustomerId;
public List Items;
}

It's implemented in a separated assembly and is used in a lot of projects (the class is bigger than it appears here) When I made a webService to return a List, I have two problems. 1) The WebReference I add in the client has a definition of Order that the compiler thinks it's not from the assembly they are defined into. I can't cast. I have to create a List and populate with the data returned from the WebMethod. Worst, It doesn't return a List<>, it returns an []. 2) The Item.Items is not a member of this new (mirror) type the webservice declares? Is there a way to fix it? At least the #2?

Thanks, Dirso

Dirso

It didn't work for me. I still got the same error. To solve it, I make the website just to register in the db what should be done with the certificate and then another application (a windows one) scheduled to run every minute will do it.

Thanks, Dirso

Dirso

Thank you very much! I'll try it tomorrow and let you know the result!

Thanks, Dirso

Dirso

Hi, I use this code to load a certificate X509Certificate2 cert = new X509Certificate2(filename, password); The problem is it works fine when the windows user is logged, but it crashed it it's not.... I found this solution but it doesn't work for me, since it was suppose to work without human intervention. Does any one know if it's possible just to load the certificate in a way that the ASP.NET code desn't try to store it?

Thanks, Dirso

Dirso

Thank you both for your suggestions. I'll try it out in afew days and if I find a solution, I'll post it here.

Thanks, Dirso

Dirso

Hi, To get the unique keys from a given table, i use a sql statement like this: Select [COLUMN_NAME] as FieldName, [CONSTRAINT_NAME] as KeyName, [ORDINAL_POSITION] as Ordinal FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] WHERE TABLE_SCHEMA=@schema AND TABLE_NAME=@table AND CONSTRAINT_NAME LIKE "IX_%" ORDER BY [CONSTRAINT_NAME], [ORDINAL_POSITION] First of all, it waorks fine, but I don't like the idea of selecting it by the name, but it was the only solution I found... For now it works, so if it's the only way, I'll live with it ;) My main problem is that I didn't find any [INFORMATION_SCHEMA] table where the NonUnique keys are stored, but it has to be somewhere, right? Any ideas about it?

Thanks, Dirso

Dirso

Hi, I have a big MasterPage (MasterPage_System) e several MasterPages inheriting (don't think it's the right word) this master page. My question is: Could a web page using a MasterPage_A (that already uses my MasterPage_System) access the MasterPage_System properties? I tried in the Page_Load method something like this: ((MasterPage_System)(Master.Master)).MyProperty = true; but it doesn't work :(

Thanks, Dirso

modified on Friday, September 18, 2009 3:41 PM

Dirso

Thanks, guys for your attention but I decided to create a webservice, download the webpage in the webservice and call it with Ajax. It worked fine.

Thanks, Dirso

Dirso

It was returning 0... sadly

Thanks, Dirso

Dirso

Hi, I just trying to get a result from a http get request to another domain webpage. Here is my javascript funtion for the request:

  function pegaCEP() {
      wRequest.set\_url('http://cep.republicavirtual.com.br/web\_cep.php?cep=13026075');
      wRequest.set\_httpVerb("GET");
      wRequest.add\_completed(completed);
      wRequest.invoke();
  }

If I use set_url for a webpage in the same site, it works fine, otherwise it cames blank (not denied, just empty, no error). I was looking around and saw something about proxy... Do I need proxy here? If so, can you tell how to do it? If not, is there any web.config solution or something?

Thanks, Dirso

Dirso

I didn't know that... I thought I had to execute. Thank you very much! I just tried and it worked great!

Thanks, Dirso

Dirso

Hi, I'd like to put all my database management in StoredProcedures or Functions, but I'm having a small problem: 1) I know I can't use INSERT, UPDATE or DELETE in UDFs, right? 2) So i created a SPROC that inserts a record to a simple table (id, name) and returns the ID in an output parameter. It's working fine. 3) I create a UDF that executes this SPROC and returns the ID... and here is my problem... looks like I can't execute my own SPROCs from a UDF. :( 4) So.. how do I achieve this goal? Inserting a record and returning the auto generated id back to my web browser (asp.net application). Here is some of my code:

CREATE PROCEDURE finsTeste
@snome varchar(50),
@nid int output
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO teste (nome) VALUES (@snome)
SELECT @nid = SCOPE_IDENTITY()
END
GO
CREATE FUNCTION insTeste
(
@snome varchar(50)
)
RETURNS int
AS
BEGIN
DECLARE @nid int
EXECUTE finsTeste @snome, @nid output
RETURN @nid;
END
GO

And then in the asp.net page I run a ExecuteScalar(StoredProcedure, "insTeste", params);

Thanks, Dirso

Dirso

Hi, I thought about it actually. But I have no idea how. I could create an onexit event for textbox easily, but how to assign it to the gridview row index? Thanks, Dirso.

Thanks, Dirso

Dirso

The problem is that the event is not fired when I press tab or enter, since I didn't click the "Edit" button (I don't even have one). Thanks, Dirso

Thanks, Dirso

Dirso

Hi, After some research, I get this code, and it's pretty much the page I need

<asp:GridView ID="gr" runat="server" GridLines="Horizontal"
AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="bc" HeaderText="Código de Barras" ReadOnly="True" />
<asp:BoundField DataField="produto" HeaderText="Produto" ReadOnly="True" />
<asp:TemplateField HeaderText="Preço Caixa">
<ItemTemplate>
<asp:TextBox ID="txtPC" runat="server" Text='<%# Bind("pc") %>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

How do I make the SelectedIndexChanging event to get fired without clicking a "edit" button? or any event at all from changing or leavind the txtPC Thanks, Dirso.

Thanks, Dirso

Dirso

Hi, About a week ago I asked how to create a nice order page and Yusuf.A[^] answered me nicely. My problem now is how do I put editboxes on it for the user to fill with the desired quantities? He doesn't need to fill all the lines and the empty lines WON'T be stored in the order table of course. Thanks, Dirso.

Thanks, Dirso