ASP.NET

3-Sep-09 3:06

[Message Deleted]

Not Active3-Sep-09 3:35

3-Sep-09 3:35

This really isn't related to ASP.NET, it would probably be more appropriate in the C# or .NET Framework forums.

However, you can try something like this
baContact.BusinesTypeReference.EntityKey = new System.Data.EntityKey("Entities.BusinessType", "ID", businessTypeID);

only two letters away from being an asset

ToddHileHoffer3-Sep-09 3:53

3-Sep-09 3:53

Thanks, I'll try that. I think most people using the entity framework are doing some form of ASP.net, so I figured this would give the best chance of getting answer. Thanks for the reply.

I didn't get any requirements for the signature

ToddHileHoffer3-Sep-09 4:09

3-Sep-09 4:09

I tried the above and it said object reference not set to an instance of an object Frown | :(

Edit I think it was because the baContact is null. It hasn't been inserted into the database yet.

I didn't get any requirements for the signature

Not Active3-Sep-09 4:46

3-Sep-09 4:46

SqlData.BusinessAssociateContactChangeRequest baContact = new BusinessAssociateWorkFlow.SqlData.BusinessAssociateContactChangeRequest();

How can baContact be null? It doesn't matter if it inserting into the database or not at this point.

only two letters away from being an asset

ToddHileHoffer3-Sep-09 4:51

3-Sep-09 4:51

I'm not sure. The error was object reference not set to an instance. I don't what else it could have been.

I didn't get any requirements for the signature

ToddHileHoffer3-Sep-09 4:52

3-Sep-09 4:52

I was able to get my code to work with the following, but it seems inefficient.

<br />
       int baRequestTypeId = int.Parse(this.rblMode.SelectedValue);<br />
            int baAssociateTypeId = int.Parse(this.rcbAssociateType.SelectedValue);<br />
            int baBusinessTypeId = int.Parse(this.rcbBusinessType.SelectedValue);<br />
<br />
<br />
<br />
            SqlData.BusinessAssociateWorkFlowData dataContext = new BusinessAssociateWorkFlow.SqlData.BusinessAssociateWorkFlowData();<br />
            SqlData.BusinessAssociateContactChangeRequest baContact = new BusinessAssociateWorkFlow.SqlData.BusinessAssociateContactChangeRequest();<br />
<br />
            SqlData.RequestType baRequestType = (from r in dataContext.RequestType<br />
                                                 where r.RequestTypeId == baRequestTypeId<br />
                                                 select r).First();<br />
<br />
            SqlData.BusinessAssociateType baBusinessAssociateType = (from b in dataContext.BusinessAssociateType <br />
                                                   where b.BusinessAssociateTypeId == baAssociateTypeId<br />
                                                       select b).First();<br />
<br />
<br />
            SqlData.BusinessType baBusinessType = (from b in dataContext.BusinessType<br />
                                                   where b.BusinessTypeId == baBusinessTypeId<br />
                                                   select b).First();<br />
            baContact.RequestType = baRequestType;<br />
            baContact.BusinessAssociateType = baBusinessAssociateType;<br />
            baContact.BusinessType = baBusinessType;<br />
            baContact.Name = this.rtbName.Text;<br />
            baContact.Abbreviation = this.rtbAbbreviation.Text;<br />
            baContact.Code = this.rtbCode.Text;<br />
            baContact.CreatedBy = User.Identity.Name;<br />
            baContact.CreatedOn = DateTime.Now;<br />
            baContact.LastModifiedBy = User.Identity.Name;<br />
            baContact.LastModifiedOn = DateTime.Now;<br />
            baContact.ContactAddress.Add(this.AddressCntrl1.GetContactAddressEntity(ref dataContext));<br />
            dataContext.SaveChanges();<br />
<br />

I didn't get any requirements for the signature

Edbert P3-Sep-09 16:46

Edbert P

3-Sep-09 16:46

Todd,

I didn't see your original question as it has been deleted.
However, if I got this right you don't need to requery baRequestType, baBusinessAssociateType and baBusinessType.

Your baContact should contain the property xxxxReference (where xxxx stands for the foreign key class), e.g. requestTypeReference.
Instead of requerying all the types you can simply create an entity key and assign it to the xxxxReference.EntityKey property.

Example:

baContact.RequestTypeReference.EntityKey = new EntityKey("YourDataSetNamespace.YourDataSetName", "YourPKPropertyName", yourValue);

Cheers,

Ed

ToddHileHoffer4-Sep-09 3:48

Dynamically populate dropdown dependent on another dropdown using SqlDataSource

4-Sep-09 3:48

Your answer does seem to be the correct solution. Thank you.

I don't know if I like it though. I don't understand why a table column value can't be set as a property just because there is a foreign key on it.

I didn't get any requirements for the signature

rikhav3-Sep-09 2:28

rikhav

3-Sep-09 2:28

Hi,
I have 2 dropdownlists on a page. (DDL1 and DDL2). The DDL1 is populated by values from the database using a SqlDataSource(SDC1). DDL2 is dependent on DDL1. As soon as a value is selected in DDL1 I need to populate values in DDL2, though using SqlDataSource SDC2 which is also available on the page.
SDC2 is defined with correct select sqls and where clause parameters during design time but I need to know how I can populate DDL2 only after a value is selected in DDL1. This might sound as a redundant question though I never found a post that will help me achieve this using SDC.

Thanks for your help in advance.

Re: Dynamically populate dropdown dependent on another dropdown using SqlDataSource

Arun Jacob3-Sep-09 2:35

Arun Jacob

3-Sep-09 2:35

Set DataValueField as primary key in DDL1 and while selecting DDL1 you'll get SelectedValue ie,primary key or the key you want for populating DDL2.

Check this post,
http://forums.asp.net/p/1070373/1559710.aspx[^]

Arun Jacob
http://codepronet.blogspot.com/

GridView inside UpdatePanel not Uploading Image

.NET- India 3-Sep-09 1:55

.NET- India

3-Sep-09 1:55

Hello Friends,

I've a GridView inside a UpdatePanel. And there is a Fileupload control inside the GridView which is fired to Update the existing image with newer one. My code is running perfectly without UpdatePanel. But as i put my GridView inside the UpdatePanel it gives me an error "Object References not set to an instance". I think this error is being generated because of FileUpload control. So i want to have a trigger control of UpdatePanel to upload the new image. How can i bind a trigger control of UpdatePanel at RowUpdating event of GridView at code behind

Re: GridView inside UpdatePanel not Uploading Image

Abhishek Sur3-Sep-09 7:48

Abhishek Sur

3-Sep-09 7:48

If you have to refresh the grid when file upload occurs why do you place the GridView inside the update panel??? Confused | :confused:

You can use PostBack trigger to upload files.. Smile | :)

Check this[^] how they are doing fileupload from within the updatepanel using PostBack Trigger.

Rose | [Rose]

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Re: GridView inside UpdatePanel not Uploading Image

.NET- India 3-Sep-09 21:38

.NET- India

3-Sep-09 21:38

I dont have to refresh the page. I just want to use PostBack trigger. But PostBack trigger needs a ControlID so what will be the ControlID for PostBack Trigger. Because i'm using RowUpdating event of GridView......

Re: GridView inside UpdatePanel not Uploading Image [modified]

Abhishek Sur4-Sep-09 7:45

Abhishek Sur

4-Sep-09 7:45

AFAIK... Postback trigger will used to postback the whole page to the server...
The controlId of the PostBack trigger should be the control that should invoke the Postback from within the UpdatePanel.

If you want Button1 which is placed within the UpdatePanel to postback the page, rather than going for partial update, just use ControlID = "Button1" For your help, lets give you a sample code :

<asp:UpdatePanel ID="upTest" ChildrenAsTriggers="False" UpdateMode="Conditional" runat="server">
           <ContentTemplate>
           <asp:Label ID="lblResults" runat="server"></asp:Label><br /><br />
           <asp:Button ID="btnAsync" Text="Asynch Post" runat="server" OnClick="btnAsync_Click" />
           <asp:Button ID="btnFullPost" Text="Full Post" runat="server" OnClick="btnFullPost_Click" >
           </ContentTemplate>
           <Triggers>
               <asp:AsyncPostBackTrigger ControlID="btnAsync" EventName="Click" />
               <asp:PostBackTrigger ControlID="btnFullPost" />
           </Triggers>
       </asp:UpdatePanel>

AsyncPostBackTrigger will postback asynchronously while PostBackTrigger will do this normally...

Cool | :cool:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

modified on Wednesday, November 18, 2009 4:52 PM

Re: GridView inside UpdatePanel not Uploading Image

macupryk28-Oct-09 14:58

macupryk

28-Oct-09 14:58

I have the same problem can you take a look:
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="ctrlUserProfilePics.ascx.cs"
Inherits="OmegaLove.Web.UI.ctrlUserProfilePics" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<%--<%@ Register Src="ctrlGPStatusBox.ascx" TagName="ctrlGPStatusBox" TagPrefix="uc1" %>
--%>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<br />
<div id="UploadArea">
<table>
<tr>
<td>
Browse Image:
</td>
<td>
<asp:FileUpload ID="FileUpload1" runat="server" />
</td>
</tr>
</table>
</div>
<p>
<asp:Button ID="UploadButton" runat="server" Text="Upload Now" OnClick="UploadButton_Click" />
</p>
               
<asp:Label ID="lblResult" runat="server" ForeColor="#0066FF"></asp:Label>
</ContentTemplate>
<Triggers>
<asp:PostBackTrigger ControlID="UploadButton" />
</Triggers>
</asp:UpdatePanel>
<br />
<hr />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="5"
GridLines="None" ShowHeader="False">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:Image ID="imgSaved" runat="server" ImageUrl='<%# imageURL(DataBinder.Eval(Container.DataItem, "img_id").ToString()) %>'
AlternateText='<%#DataBinder.Eval(Container.DataItem,"img_title") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<EmptyDataTemplate>
No records found
</EmptyDataTemplate>
</asp:GridView>

Connection string for ms access database in website

manish.m.meshram3-Sep-09 1:25

manish.m.meshram

3-Sep-09 1:25

Hi,

My Ms-Access Database is on my website.

ftp//ftp.WebsiteName.com/App_Data/SerialNo.mdb

What will be my connection sting.

Thanks

Re: Connection string for ms access database in website

Not Active3-Sep-09 1:31

Re: Connection string for ms access database in website

3-Sep-09 1:31

http://www.connectionstrings.com/[^]

only two letters away from being an asset

Abhishek Sur3-Sep-09 7:59

Abhishek Sur

3-Sep-09 7:59

You want to have connection to your database using ftp protocol.... ?????

Please download the file to your own location and use it.. Or you can use unc path to the server like \\yourserverip\app_Data\serialNo.mdb

In ftp, you need to create session to pass ftp commands like open, mput, mget etc... Your session will be terminated just like the HTTP session timeouts, if left idle. So I dont think you can work with this directly using this way... Big Grin | :-D

Just point the file through network path. Rose | [Rose]

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

passing session details from user control

dotnetcsharpdev3-Sep-09 0:49

dotnetcsharpdev

3-Sep-09 0:49

I have a page which has 4 user controls on it.
The problem is : I have a link on this user control and when clicked goes to other page but I dunno how to pass the session variable to the other page from this page containing that uc.

The other page always gets the same values as the session variable doesn't update when user control is clicked for different values.

Not Active3-Sep-09 1:33

3-Sep-09 1:33

Session["SomeKey"] = SomeValue

This doesn't work for you? Perhaps you should show a little of what you are doing.

only two letters away from being an asset

dotnetcsharpdev3-Sep-09 1:37

dotnetcsharpdev

3-Sep-09 1:37

the session values pass across all pages .
The problem is on this page I have a user control which is a grid with links. when i click on these links i am passed to other pages with different values for different links of the grid.

but the next page gets only those values which are set in the first page where UC is embedded I need to change values in UC.

Not Active3-Sep-09 2:01

3-Sep-09 2:01

I still don't get what the difficulty is. You can't handle the click event in the user control and make the appropriate settings?

only two letters away from being an asset