Hi,
I need to send xml file as a parameter to SQL stored procedure from Access VBA form..
I wrote code that handle sending parameters from a textbox input.. but if I need to send xml file, what I have to do?
To add OpenFileDialog in order to choose the xml file, then parse it and make it as one string then pass it to the sp (The SQL stored procedure gets "XML" parameter and not a varchar(max)). Or is...
pisgasys
Last Activity: Oct 8 '09, 05:34 AM
Joined: May 26 '09
Location:
-
pisgasys started a topic How to send xml file as a parameter to SQL stored procedure from Access VBA form?in AccessHow to send xml file as a parameter to SQL stored procedure from Access VBA form?
-
Soluation
That's what I did, and it works:
...Code:protected void Page_PreLoad(object sender, EventArgs e) { SqlConnection conn = null; SqlCommand cmd = null; SqlDataReader rdr = null; int i = 0; conString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; -
Hi,
The number of my controls is changing dynamically according to association mechanism (I'm taking part of developing of system that simulating XFactory if you know it) .
Those controls can be TextBoxes or CheckBoxes or ComboBoxes .. according to a controlType field stored in the db.
So what I'm trying to do is:
1) Fill a form with new production order for a factory (Line, CatalogID,...)
2) Retrieve the...Leave a comment:
-
When I put my code of building dynamic controls inside page_load it worked fine, but I need to run that code from another function, so I tried:
but still have a problem!Code:public partial class PO_Insert : System.Web.UI.Page { public TextBox ctrl1 = null; public TableRow trRow = null; public TableCell tcCell = null;Last edited by Frinavale; May 27 '09, 01:02 PM. Reason: Added code tags. Please post code in [code] [/code] tags.Leave a comment:
-
Hi again,
Well the problem is here:
The controls are created, but I'm not succeeding to get there values, If I'm trying to retrieve:Code:TextBox txtCtl = (TextBox)UpdatePanel1.FindControl(String.format("tagCtrl{0}", i)); string v1 = txtCtl.Text.ToString();
I'm getting null!Code:UpdatePanel1.FindControl(String.format("tagCtrl{0}", i)).ID
I tried declaring...Last edited by Frinavale; May 27 '09, 01:02 PM. Reason: Added code tags. Please post code in [code] [/code] tags.Leave a comment:
-
Dynamic web controls
Hi,
in my aspx page I have somting like that:
...Code:<asp:Content ID="Content1" ContentPlaceHolderID="Body" Runat="Server"> <asp:UpdatePanel ID="UpdatePanel1" ChildrenAsTriggers="true" UpdateMode="Conditional" runat="server" > <ContentTemplate> <asp:Panel ID="Panel1" runat="server">Last edited by PRR; May 26 '09, 10:00 AM. Reason: Code tags addded... Please post code in [code] [/code] tags.
No activity results to display
Leave a comment: