Database

3-May-10 0:30

FormView1.FindControl("TextBox2") as TextBox;

I need like it to select the value for DrowpDownList inside GridView

Paramhans Dubey3-May-10 2:57

Paramhans Dubey

3-May-10 2:57

(GridView1.Rows[Index].findControl("DropDownList1") as DropDownList).SelecteedValue

msomar3-May-10 4:34

3-May-10 4:34

I tried your code . but there is some error :
Compiler Error Message: CS0122: 'System.Data.Index' is inaccessible due to its protection level

Paramhans Dubey3-May-10 7:02

Paramhans Dubey

3-May-10 7:02

Try this code in selectedIndexChanged event of dropdownlist

DropDownList ddl = (sender as DropDownList);
string val = ddl.SelectedValue;

Paramhans Dubey3-May-10 19:48

Paramhans Dubey

3-May-10 19:48

try this

foreach(GridViewRow gr in Gridview1.Rows)
{
   string str = ((DropDownList)gr.FindControl("DropDowmList1")).SelectedValue;
}

msomar6-May-10 0:25

Updating related 2 Tables

6-May-10 0:25

please see the following url
http://tareemnet.com/drop.JPG

User Name : adnet
Pass : 123

When Editting, the user can change the value using the dropdownlist, and then updating with that new value selected.
I'm beginner, please provide me a full code in c# for that issue.

msomar2-May-10 23:12

Re: Updating related 2 Tables

2-May-10 23:12

I could execute the following sql in SMSS, but when adding it in a sqldatasource as an update statement, it gets an error.

In SSMS, and it works fine:

UPDATE   S
   SET    S.DailyBudget = 12
   FROM    Account O INNER JOIN  AdCampaign S
         ON O.ID = S.AccountID
   WHERE   O.EmailAddress = 'abc@abc.com'

But In Sqdatasource, it gets error:

UPDATE S SET S.DailyBudget = 12 FROM Account O INNER JOIN AdCampaign S ON O.ID = S.AccountID WHERE (O.EmailAddress = @EmailAddress)

Error: Invalid Object Name 'S'.
Hint: S,O are borrowed names, and not actual table names.

SeMartens3-May-10 0:07

SeMartens

3-May-10 0:07

Hi,

the hint-text gives you the information why the update failed. SqlDataSource does not provide support for abbreviations. So you have to rewrite your query to

UPDATE AdCampaign SET AdCampaign.DailyBudget = 12 FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)

This should work.

Regards,
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

SEARCH QUERY:)

diyaa_082-May-10 21:33

diyaa_08

2-May-10 21:33

sallam 2 all this is a search query bt i got an exception at column S_No
i.e
Select ROW_NUMBER() OVER(ORDER BY pcpd.Cpt_Code, pcpd.Cpt_Description ASC) AS 'S_No', Provider_Cpt_Plan_Detail_Id, Provider_Cpt_Plan_Id, pcpd.Cpt_Code, isnull(pc.Proc_Description,'') as cpt_description, pcpd.Cpt_Modifier, Non_Facility_Participating_Fee, Non_Facility_Non_Participating_Fee, Facility_Participating_Fee, Facility_Non_Participating_Fee, pcpd.Deleted, pcpd.Created_By, pcpd.Created_Date, pcpd.Modified_By, pcpd.Modified_Date From Provider_Cpt_Plan_Details pcpd left outer join procedures pc on pcpd.Cpt_Code=pc.proc_code Where ORDER BY( pcpd.Cpt_Code, pcpd.Cpt_Description ASC) LIKE '4%' And pcpd.Cpt_Code LIKE '00%' And pcpd.Provider_Cpt_Plan_Id ='100ALLALLALLALLALL' And pcpd.Deleted ='0'

the prob is that i use
Select ROW_NUMBER() OVER(ORDER BY pcpd.Cpt_Code, pcpd.Cpt_Description ASC) AS 'S_No' in select statement im confused what i give in search where clause if i give S_No it gives me error if i give the whole ROW_NUMBER...etc etc it says it is used only in select statement
now it gives me exception Incorrect syntax near the keyword 'ORDER'.
when i used ORDER BY( pcpd.Cpt_Code, pcpd.Cpt_Description ASC) LIKE '4%'

any suggestions what i should do?

890213 - Installing SQL Server 2008 failover cluster

ilostmyid22-May-10 19:25

ilostmyid2

2-May-10 19:25

hi i get the following error when try to install an instance of the SQL Server 2008 failover cluster:

Rule "Cluster shared disk available check" failed.
The cluster on this computer does not have a shared disk available. To continue, at least one shared disk must be available.

the machine in which it's installed is a VM provided by ESXi.
what's the problem and what can i do?
thx

Re: 890213 - Installing SQL Server 2008 failover cluster

Michel Godfroid2-May-10 20:53

Update query in sql server 2005

2-May-10 20:53

For a cluster, you'll need at least 2 VM's. (preferably on two different boxes, putting them both on one box is nice for playing around, but it brings you nothing than more points of failure in a production environment).
Next you will need to configure a shared disk, accessible by both machines. This is usually based on some hardware contraption, such as a NAS, or a firewire setup. You may also be able to SIMULATE this in VMWare ESXi, consult the product's documentation.

msomar2-May-10 8:57

How I can pass session parameters to SqlDataSource

2-May-10 8:57

I have select query like this :

SELECT AdCampaign.CampaignName, AdCampaign.AdType AS [Campaign Type], AdCampaign.Date AS [Start Date], AdCampaign.Clicks, AdCampaign.Impr, AdCampaign.DailyBudget AS [Daily budget] , AdCampaign.Status FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)

I need like the previous query for update.
How I can do it with Join.

msomar1-May-10 20:45

Re: How I can pass session parameters to SqlDataSource

1-May-10 20:45

hi..

How I can Pass session parameters to sqlDataSource. I do like this but it is not work:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:AdNetConnectionString %>" 
            
            SelectCommand="SELECT CampaignName, AdType AS [Campaign Type], Status, Date AS [Start Date], Clicks, Impr, DailyBudget AS [Daily budget] FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE Account.EmailAddress = @EmailAddress  ">
            <SelectParameters>
            <asp:SessionParameter Name="EmailAddress" Type="String"  SessionField="EmailAddress" />
            </SelectParameters>
            </asp:SqlDataSource>

The session name is :session["EmailAddress"]

Please guide me.

Michel Godfroid1-May-10 22:24

1-May-10 22:24

Add the risk of sounding repetitious and single-minded: And what is the error message? There are no psychics here.

Select error

msomar1-May-10 9:34

1-May-10 9:34

I have this query. but it is not work with the session
Please help me.

SELECT AdCampaign.CampaignName, AdCampaign.AdType AS [Campaign Type], AdCampaign.Status, AdCampaign.Date AS [Start Date], AdCampaign.Clicks, AdCampaign.Impr, AdCampaign.DailyBudget AS [Daily budget] FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = 'Session["Email_Address"]') AND (Account.Pass = 'Session["Password"]')

Re: Select error

Michel Godfroid1-May-10 22:22

Need help with this query so it returns only a single record per user

1-May-10 22:22

And what is the error message?

Michael J. Eber30-Apr-10 8:39

Michael J. Eber

30-Apr-10 8:39

We have a group of users who can access various locations within the datacenter.
For the largest group of users, if they can access one location they can access all of the locations.
For a very small population, the user can only access the office and not the data center locations. These users are causing me a problem.

The query is aimed at basically giving me the count of active locations. But in the mixed case I get BOTH a record with a null count AND a record with access count. In otherwords: Amy can access only the office and cannot access dc1 or dc2. The query returns Amy's record as Amy, null and Amy, 1. I want it to return ONLY Amy, 1.

Any suggestions on the changes I need to accomplish that?

Here is the current query:

SELECT        dbo.ContactMaster.BmcCustKey,
                 (SELECT        COUNT(dbo.LocationAccessGrant.CanAccessLocation) 
                   WHERE        (dbo.LocationAccessGrant.CanAccessLocation = 1)) AS AccessCount
FROM            dbo.ContactMaster LEFT OUTER JOIN
                         dbo.LocationAccessGrant ON dbo.ContactMaster.CompanyID = dbo.LocationAccessGrant.CompanyID AND 
                         dbo.ContactMaster.ContactIdentity = dbo.LocationAccessGrant.ContactIdentity
GROUP BY dbo.ContactMaster.BmcCustKey, dbo.LocationAccessGrant.CanAccessLocation
ORDER BY dbo.ContactMaster.BmcCustKey

Re: Need help with this query so it returns only a single record per user

Jörgen Andersson30-Apr-10 23:47

Jörgen Andersson

30-Apr-10 23:47

Not sure I've understood you properly, but your subquery doesn't look correct.
So try something like this:

SELECT  dbo.ContactMaster.BmcCustKey
       ,Sum(CASE    WHEN    dbo.LocationAccessGrant.CanAccessLocation = 1
                    THEN    1
                    ELSE    0
            END) accesscount
FROM    dbo.ContactMaster
LEFT OUTER JOIN dbo.LocationAccessGrant
    ON  dbo.ContactMaster.CompanyID = dbo.LocationAccessGrant.CompanyID
    AND dbo.ContactMaster.ContactIdentity = dbo.LocationAccessGrant.ContactIdentity
GROUP BY dbo.ContactMaster.BmcCustKey
        ,dbo.LocationAccessGrant.CanAccessLocation
ORDER BY dbo.ContactMaster.BmcCustKey

It should take care of your null values

"When did ignorance become a point of view" - Dilbert

How many concurrent we can have in SQL Server 2005 Express?

divyesh143229-Apr-10 21:26

divyesh1432

29-Apr-10 21:26

Hi,

How many concurrent we can have in SQL Server 2005 Express?
Does it make difference with the operating system like windows server 2003/2008 or winxp pro?

And I am getting error while connecting to the sql server 2005 express that the remote server has refused the remote connection (Error no. 26) though it was working fine before couple of days (I have enabled the remote connection via/pipeline/tcpip and also added in firewall exception port 1433. It was working fine before).

After that I have just restarted my server and its works fine! What can be wrong in this? May be the number of concurrent connection has reached!

Thanks,
Divyesh

Re: How many concurrent we can have in SQL Server 2005 Express?

Michel Godfroid29-Apr-10 23:48

Re: How many concurrent we can have in SQL Server 2005 Express?

29-Apr-10 23:48

I don't see a connection limitation in SQL server express, but there are indeed tcp connection limitations in windows XP. (Microsoft wants you to buy the server if you're doing server work).

Roger Wright30-Apr-10 7:06

Roger Wright

30-Apr-10 7:06

This[^] fixes that little problem.

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

Re: How many concurrent we can have in SQL Server 2005 Express?

Michel Godfroid30-Apr-10 7:24