.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Selecting record based on domain url and email comparison

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :ASP.Net
 

I want to limit the selecting of data records to only the user who created the record, OR a users who's email address belongs to the domain of the record being edited.
So, if the producer has a value in the URL of "www.mydomain.com" and their email address in the Membership is "someone@mydomain.com" they will be able to see the record.


I have the following table:
Table -  Producer
Field: ProducerID
Field: ItemUserID
Field: URL

I have figured out how to select based on the ItemUserID (see code below), but I don't know how to compair the email address values of URL and the Membership.


protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
      if (Page.User.Identity.IsAuthenticated)
    {
     //get id of user logged in
     e.Command.Parameters["@ItemUserID"].Value = Membership.GetUser().ProviderUserKey;
    }
        
 }

Can someone show me how to code my requirements?
Thanks.




View Complete Post


More Related Resource Links

Filtering/selecting rows based on date

  

I have a gridview, based on thsi datasource:

 

<asp:SqlDataSource ID="SqlDataSourceAllLoads" runat="server" 
        ConnectionString="<%$ ConnectionStrings:tplatz_dk_dbConnectionString %>"               
        SelectCommand="SELECT DISTINCT DATEADD(day, 0, DATEDIFF(day, 0, tblDelivered.delivered_Date)) AS delivered_Date, tblDelivered.delivered_LoadNo, tblDelivered.delivered_TrailerNo, ISNULL(tblDeliveredInfo.deliveryInfo_FirmaNavn, N'?') AS Expr1 FROM tblDelivered FULL OUTER JOIN tblDeliveredInfo ON tblDelivered.delivered_LoadNo = tblDeliveredInfo.deliveryInfo_LoadNr ORDER BY delivered_Date DESC">
    </asp:SqlDataSource>


Using a dropdownlist, I can filter (by changing datasource) the results based on customer names in a dropdownlist. This datasource, working perfectly, looks like this:

 

<asp:SqlDataSource ID="sqldataSourceKundeLoads" runat="server" 
        ConnectionString="<%$ ConnectionStrings:tplatz_dk_dbConnectionString %>" 
        SelectCommand="SELECT  DATEADD(day, 0, DATEDIFF(day, 0, tblDelivered.delivered_Date)) AS delivered_Date, tblDelivered.delivered_LoadNo, tblDelivered.delivered_TrailerNo, ISNULL(tblDeliveredInfo.deliveryInfo_FirmaNavn, N'?&#

How can i update treeview root node every time based on the record entries

  
Hi all, I will have an mdi form and with a treeview which has it's initial property as visible =false. If i select an option from menu a child form will exists i will fill some details and click on save when ever click on save i will make the root node of the treeview to some name as File[batch count:0]. Now if i select another option from menu another form will appear and if i fill it with some details and click on save i would like to change the root node name to File[batch count:1] and a child node should exists with some name

email to each record in gridview

  
I have a gridview that is populated from a selection made from a DropDown list box. I would like to click a check box then send an email to each record in the gridview. Could someone offer some solid help on how to do this?       Thank you for your input.

Cannot INSERT record using Asp.Net Dynamic Data Domain Service Web Applications

  
 Hi, I am working on a 'Asp.Net Dynamic Data Domain Service Web Application' project using just 2 tables, FAQ_Categories and FAQs. The FAQs table has a foreign key to the FAQ_Categories. The steps are straight forward. Add a new project (Asp.Net Dynamic Data Domain Service Web Applications) Add folders Model ( for Linq2Sql datacontext), Domain (for the Domain Services class) Add Linq2Slql and add the 2 tables to the designer. Build the project. Add the Domain Service Class to the Domain folder. in the wizard select the DataContext, uncheck the Enable Client & Expose ODate checkbox Check bothe table & their corresponding Enable Editing tables checbox Check the Generate Metadata class Click OK. In Global.asax set Scaffold to true and add the DomainService name. Build and run.   Pages List and Detail are working fine. But if I try to insert a new record, I get the error "FaqId is required" Faq_ID is the primary key in the database table and it is set to Identiy. The Datacontext is correct, it marked the FAQ table with <Global.System.Data.Linq.Mapping.ColumnAttribute(Storage:="_CustomerId", AutoSync:=AutoSync.OnInsert, DbType:="Int NOT NULL IDENTITY", IsPrimaryKey:=true, IsDbGenerated:=true)> _   I tried this using Linq2Sql, Entity Framework, And both in VB and C# with the same result. I am using VS20

People Picker gets error when selecting user from a trusted domain(one way forest trust)

  
  Hello all,   Our current setup is SharePoint 2010 Foundation server in one external forest(Trusting forest), and trying to have users in a separate internal forest(Trusted forest) access the site. The external forest's DC and SharePoint server are in a DMZ separated by a firewall with the internal forest's DC and users. A one way transitive forest trust was successfully created and has been validated. On SharePoint, we're ran the sts commands to set the setapppassword as well as the peoplepicker-searchadforests adding the domain that the SharePoint server is in, as well as the trusted forest. An iisreset was issued after running these commands. In SharePoint, we can then search for users from the trusted domain, and select the users in the Select People page, but when hitting the final Ok, an error is received: An unexpected error has occurred in which a correlation ID is provided. Reviewing the SharePoint logs we find the following: <!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520092929 1073786111 9 0 415 0;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520081665 -1073717157 41 0 66047 0;} /* Style Defin

domain based webservice connection problem

  
When I try to connect domain based  webservice from my application getting "The request failed with HTTP status 401: Unauthorized"  error .What could be the problem. When i browse the service from browser(http://10.1.23.4/gss/myManagerService.asmx) i can see the service output but when i try to connect from my below programe getting 401 error.Please advice me.   MyService service= new MyService ();        System.Net.CredentialCache cache = new System.Net.CredentialCache();        cache.Add(new Uri("http://10.1.23.4/gss/myManagerService.asmx"), new    System.Net.NetworkCredential("muusername", "mypwd","mydomain"));        service.Url = "http://10.1.23.4/gss/myManagerService.asmx";        int cnt = 0;        myrec[] records = new myrec[0];                AccRecord oaccRecord = new AccRecord ();                               DateTime enddt = DateTime.Now;       

domain based webservice connection problem

  
When I try to connect domain based webservice from my system getting "The request failed with HTTP status 401: Unauthorized" error .What could be the problem. When i browse the service from browser(http://10.1.23.4/gss/myManagerService.asmx) i can see the service output but when i try to connect from my below programe getting 401 error. Please advice me. MyService service= new MyService (); System.Net.CredentialCache cache = new System.Net.CredentialCache(); cache.Add(new Uri("http://10.1.23.4/gss/myManagerService.asmx"), new System.Net.NetworkCredential("muusername", "mypwd","mydomain")); service.Url = "http://10.1.23.4/gss/myManagerService.asmx"; int cnt = 0; myrec[] records = new myrec[0]; AccRecord oaccRecord = new AccRecord (); DateTime enddt = DateTime.Now; DateTime stdt = DateTime.Now.AddDays(-10); service.Credentials = cache; MessageBox.Show("service"); records =service.ReadRecord(records , stdt, enddt);// here taking some time and throwing 401 eroor

domain based webservice connection problem

  
When I try to connect domain based webservice from my system getting "The request failed with HTTP status 401: Unauthorized" error .What could be the problem. When i browse the service from browser(http://10.1.23.4/gss/myManagerService.asmx) i can see the service output but when i try to connect from my below programe getting 401 error. Please advice me. MyService service= new MyService (); System.Net.CredentialCache cache = new System.Net.CredentialCache(); cache.Add(new Uri("http://10.1.23.4/gss/myManagerService.asmx"), new System.Net.NetworkCredential("muusername", "mypwd","mydomain")); service.Url = "http://10.1.23.4/gss/myManagerService.asmx"; int cnt = 0; myrec[] records = new myrec[0]; AccRecord oaccRecord = new AccRecord (); DateTime enddt = DateTime.Now; DateTime stdt = DateTime.Now.AddDays(-10); service.Credentials = cache; MessageBox.Show("service"); records =service.ReadRecord(records , stdt, enddt);// here taking some time and throwing 401 eroor

Reading each record from a text file and sending email

  
Hi All, I have a text file (CSV) which has only three fields (Name, Email, SendYN). I want to read each record from this text file and send email to those records where SendYN field has Y. I had created Flat File connection and a Flat File source in a data flow which uses Flat file connection. Now I stuck how to move further. Which control I need to add and where to identify whether SenderYN = Y and how to send email? I am new to SSIS. Thanks.

Possible to send an email if a record is added to a table?

  
I would like to be able to send an email notification if a website user inserts a new record in a table.  This will be a relatively rare occurrence so it would be very useful to have the notification as opposed to having my users check my summary page that lists all the IDs that have a record in this table. I googled but I must not be hitting on the right keywords or phrase to find the answer to this question. Thanks in advance for 1) letting me know if this is possible (I'm version ASP.NET 2.0 and using VB with a SQL Server database) and/or 2) pointing me in the right direction to find out how to do it if it is possible. Thanks! 

ajaxToolkit:AutoCompleteExtender should filer record based on enrting the text value

  

Hi All,

I am using ajaxToolkit:AutoCompleteExtender.

<asp:TextBox runat="server" ID="myTextBox" Width="300" autocomplete="off" AutoCompleteType="FirstName" />

            <ajaxToolkit:AutoCompleteExtender

                runat="server"

                ID="autoComplete1"

                TargetControlID="myTextBox"

                ServicePath="autoComplete.asmx"

                ServiceMethod="GetCompletionList"

                MinimumPrefixLength="2"

  &n

Selecting a field based on a variable

  

If I have a field name in @FieldName is there a way to do something like

SET @FieldName = 'MyField'

SELECT @FieldName FROM MyTable

where the above would yeild the same results as

SELECT MyField from MyTable

Thanks in advance.


Problem getting same record when trying to populate data into texboxes when selecting a row/record f

  

I can't seem to get the select record from the datagrid to populate in the textboxes. I get the same record no matter what I select in the datagrid. Hopefully someone can help with this. I tried using a where clause for POPULATION_LIST_ID = '" & Me.lblPopulationID.Text & "' and I get a ORA-01722 error - invalid number. Here is the code I have so far for the grid:


  Protected Sub MHGrid_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles MHGrid.SelectedIndexChanged
Me.Table1.Visible = True
Me.MHGrid.Visible = True

Dim dvSql As DataView = DirectCast(MHFoundation.Select(DataSourceSelectArguments.Empty), DataView)

Me.MHFoundation.SelectCommand = "SELECT POPULATION_LIST_ID, FIRST_NAME, MIDDLE_NAME, SSN, BIRTH_DATE, ADDRESS, SPOUSE_NAME, OTHER_ID2, WORK_PHONE, PREFERRED_COMMUNICATION, LAST_NAME, NAME_PREFIX, NAME_SUFFIX, MRN1, CITY, STATE, ZIP, CHILDREN,OTHER_ID1,POPULATION_TYPE,HOME_PHONE,CELL_PHONE,POPULATION_RATING,NOTES,EMAIL,PERSON_TYPE FROM CHP_POPULATION_LIST "
For Each drvSql As DataRowView In dvSql
Me.lblPopulationID.Text = drvSql("POPULATION_LIST_ID").ToString
Me.txtMRN.Text = drvSql("MRN1").ToString()
Me.txtBirthD

select record based on / match selected date

  
 
with the sql statement below, i try to select the records based on the selected date, it return no rows from adapter filled datatable. 
however, when i run the query in sql query in sql server studio management, it returns records. 
date format = 09/28/2010

string[] splitDT = txtSelectedDate.Text.Split('/');

            string strRearrangeDT = splitDT[0] + "/" + splitDT[1] + "/" + splitDT[2];

using (SqlConnection sqlconn = new SqlConnection(connstring))
            {
                DataTable dt = new DataTable();
                string strSQL = "SELECT userclaim_details3.id, userclaim_details3.userclaimid, userclaim_details3.userid, userclaim_details3.childcategorytableid, userclaim_details3.statusid, " +
                         "userclaim_details3.amount AS amountname, userclaim_details3.remark AS remarkname, userclaim_details3.datecreated AS datecreatedname, " +
                         "userclaim_details3.datemodified, approvaltable.id AS Expr1, approvaltable.typename AS statusname, usertable2.id AS Expr2, usertable2.name AS uname, " +
                         "childcategorytable.id AS Expr3, childcategorytable.categor

how to set primary key in datatable and find the record based on primary key

  

Hi all,

I want to set primary key to my datatable and find the index of my record in my datatable based on that primary key. Can any one please help me regarding this?

Regards,

Ramesh Rathi


Adding a second domain to windows authentication based web site

  

Hi All

I have an interweb web application that uses Active Directory to authenticate the user.
Im now getting some complaints that users on other domains are unable to access the application.

How can i make it work so that their domain name is also accepted by the application?


SharePoint Portal Server 2003 - email alert based on due date

  

Hello All,

Hoping someone can help us here.

Note:Workflow/3rd party solutions not an option-

We would like to send an email alert when a list items due date is eqaul to "today".

We are trying to manage some certificates of compliance by flagging the "due date of the particular certificate (list item)" and sending an alert email when that occurs.

Is this feasible in any manner without workflow?

Is it possible to send an alert based on a calculated field when that calculated data changes? .

Any direction would be appreciated.

Thank you

Mike Harvey
Software Solutions Architect

 


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend