1. Old-school databinding and DataMembers

    Date: 10/19/06 (C Sharp)    Keywords: database, sql, web, microsoft

    Yes, I'm back.



            private string ConnectionString;
            private DataViewManager dsView;
            private DataViewManager dsViewHospitals;
            private DataSet ds;
    
            public TestHospitalFormGrid()
            {
                InitializeComponent();
    
                ConnectionString = "data source=edison;uid=sa;password=nothing;database=hospratestest";
                SqlConnection cn = new SqlConnection(ConnectionString);
    
                //Create the DataSet
                ds = new DataSet("HospRates");
    
                //Fill the dataset with hospitals
                SqlDataAdapter da1 = new SqlDataAdapter("select * from hospitals", cn);
                da1.TableMappings.Add("Table", "Hospitals");
                da1.Fill(ds, "Hospitals");
                //Fill the dataset with rates
                SqlDataAdapter da2 = new SqlDataAdapter("select * from CombinedRateData", cn);
                da2.TableMappings.Add("Table", "Rates");
                da2.Fill(ds, "Rates");
    
                //tables father back will go here later
    
                //Establish relatinship between hospitals and rates
                DataRelation relHospRates;
                DataColumn MasterColumn;
                DataColumn DetailColumn;
                MasterColumn = ds.Tables["Hospitals"].Columns["ID"];
                DetailColumn = ds.Tables["Rates"].Columns["prov_id"];
                relHospRates = new DataRelation("HospRatesRelation", MasterColumn, DetailColumn);
                ds.Relations.Add(relHospRates);
    
                dsView = ds.DefaultViewManager;
                dsViewHospitals = ???;
    
                dgDetail.DataSource = dsView;
                dgDetail.DataMember = "Rates.HospRatesRelation";
                //dgDetail.DataSource = "Rates.HospRatesRelation";
    
                cboName.DataSource = dsView;
                cboName.DisplayMember = "Hospitals.Name";
                cboName.ValueMember = "Hospitals.ID";
            }
        }



    This code generates an error. After two hours of looking around the web, I finally got pointed to this KB article, which tells me my problem stems from the fact that my DataMember has a period in it, and that this bug is considered a "feature" by Microsoft. As you can see, I have tried setting the datasource directly to the relation; this results in the form loading and the datagrid remaining empty no matter what I do.

    I need to find a way to set the datasource of the datagrid to the relation in question. It seems to me that the easiest way to do this will be to set the view dsViewHospitals to only show the relation in the dataset, but I'm not finding any code samples for how to set view to anything other than DefaultViewManager programmatically at Microsoft. How would I go about doing such a thing? Thanks.

    Source: http://community.livejournal.com/csharp/77639.html

  2. a little green...

    Date: 10/20/06 (SQL Server)    Keywords: sql, web, google

    Hello I'm relatively new to SQL.

    Do any of you know of some good websites regarding SQL queries? I've done a search on google but I haven't been too impressed with what I've seen so far.

    Thank you for your help!

    Source: http://community.livejournal.com/sqlserver/52793.html

  3. YouTube erases clips per Japan media demand

    Date: 10/20/06 (Web Technology)    Keywords: web

    Web site pulls 29,549 video files after 23 Japanese media companies raise concerns over copyright infringement.

    Source: http://news.zdnet.com/2100-9588_22-6127857.html

  4. Portland lets desktop Linux roll for VARs

    Date: 10/20/06 (Open Source)    Keywords: web, linux

    For the knowledge worker, those who need access to the Web with an e-mail client and office suite, we can offer good Linux alternatives

    Source: http://blogs.zdnet.com/open-source/?p=820

  5. China moves toward 'real name system' for blogs

    Date: 10/23/06 (Web Technology)    Keywords: web

    Aiming to further control flow of information, China Web watcher wants bloggers to register with their real names.

    Source: http://news.zdnet.com/2100-9588_22-6128484.html

  6. search engine-based news aggregators?

    Date: 10/23/06 (WebDesign)    Keywords: web, yahoo, google

    I'm looking for web-based news aggregators like news.google.com. i know yahoo and msn have them as well.

    any others?

    Source: http://community.livejournal.com/webdesign/1180627.html

  7. How To Enable Nice Friendly URL in Vanilla Forum

    Date: 10/23/06 (Java Web)    Keywords: php, web, apache

    Open up conf/settings.php and add this line: $Configuration[’URL_BUILDING_METHOD’] = ‘mod_rewrite’; Believe me, that’s all you need to do. Ain’t that easy? Note: I am assuming that you are using Apache HTTPD Web Server with mod_rewrite enabled. Note 2: I have tested it on windows but I have all reasons to believe that it will work fine on Unix / [...]

    Source: http://blog.taragana.com/index.php/archive/how-to-enable-nice-friendly-url-in-vanilla-forum/

  8. How To Enable / Use .htaccess / Nice permalinks in Apache Web Server on Windows

    Date: 10/23/06 (Java Web)    Keywords: php, software, web, linux, apache

    .htaccess is a web server directive file populalrly used in Apache Web Server in Linux / Unix environment. In windows environment there is a simple way to enable and use .htaccess. Additionally it allows you to create nice permalinks for software like WordPress or phpBB. To use .htaccess you need to enable mod_rewrite. Even with that [...]

    Source: http://blog.taragana.com/index.php/archive/how-to-enable-use-htaccess-nice-permalinks-in-apache-web-server-on-windows/

  9. Oh shit, IE 7

    Date: 10/23/06 (Web Development)    Keywords: php, java, web

    Hey everyone -

    I just downloaded IE 7 that's going to be auto-installed on every XP user's machine on Nov 1, and the javascript menus for my web site don't work at all. Also, I didn't write them, and although I can debug some JavaScript (I'm a php person) I can't figure out why the menus won't work! I'm not really expecting any miracles here, but could you all give me some advice, like what might be a common change or bug or something in IE 7? It's too much code to post and if I ask the developer to fix, they're going to charge and may not get it done in time. Any advance tips are truly, ecstatically appreciated!

    Thanks!

    http://www.iop.harvard.edu/

    Source: http://community.livejournal.com/webdev/363696.html

  10. cam

    Date: 10/24/06 (Computer Help)    Keywords: web, yahoo

    I have a Logitech Quickcam and want to use Yahoo Mesaging, but it keeps teling me I have no webcam, but i installed stoftware and have the cam plugged in. any ideas?

    Source: http://community.livejournal.com/computer_help/700723.html

  11. Google releases customizable search

    Date: 10/24/06 (Web Technology)    Keywords: web

    Web publishers can pick which keywords and sites to search, then color-coordinates results to match their motif.
    Images: Customized search

    Source: http://news.zdnet.com/2100-9588_22-6128807.html

  12. Web Developement Blog Launch

    Date: 10/24/06 (Web Development)    Keywords: php, css, html, java, web

    I'm not sure if I'm allowed to do this or not, but the company I work for (Sitecrafting) has launched a new website, and part of that is a blog on all things Internet. Our expertise is XHTML, CSS, PHP, and Javascript. This is shameless self-promotion, but check us out. Maybe you'll learn something. (Maybe. Maybe you can teach me something.)

    Sitecrafting Blog

    (Cross post to css_forum, php, and webdev. I can't remember how to link to communities)

    Source: http://community.livejournal.com/webdev/364680.html

  13. dreamweaver question

    Date: 10/24/06 (Web Development)    Keywords: css, html, web

    I made my first simple layout today using dreamweaver. (we'll see how well it works out) I saved my html file, then I saved my css files. (I clicked on cascading sheets) and went to upload them on awardspace.com. My css files are not showing up when I click on browse. I'm just wondering what to do to get them to show up to upload. Does anyone know? *total newbie here*

    Thanks,
    Tasha

    edit: Ok, I realized it's not saving the changes to my html file either. I named a file index, and when I looked to edit it at awardspace, there was nothing I saw in dreamweaver. (all the html and css) - I editted it at the website, awardspace (so I could view my page at least even if I don't know what the hell is going on with dreamweaver) and it STILL doesn't show anything on my website. Grrr. Am I supposed to be saving something .html if it has html and css in it? I normally seperate my css file from my html file. So I've managed to entirely confuse myself. I would realllly appreciate some help.

    Source: http://community.livejournal.com/webdev/364228.html

  14. Amazon profit beats expectations

    Date: 10/24/06 (Web Technology)    Keywords: web

    Web retailer reports lower third-quarter net income but tops Wall Street expectations, sending its shares up 12 percent.

    Source: http://news.zdnet.com/2100-9588_22-6129222.html

  15. Web Developement Blog Launch

    Date: 10/24/06 (PHP Community)    Keywords: php, css, html, java, web

    I'm not sure if I'm allowed to do this or not, but the company I work for (Sitecrafting) has launched a new website, and part of that is a blog on all things Internet. Our expertise is XHTML, CSS, PHP, and Javascript. This is shameless self-promotion, but check us out. Maybe you'll learn something. (Maybe. Maybe you can teach me something.)

    Sitecrafting Blog

    (Cross post to css_forum, php, and webdev. I can't remember how to link to communities)

    Source: http://community.livejournal.com/php/505569.html

  16. Video sites should try everything, Hollywood execs say

    Date: 10/25/06 (Web Technology)    Keywords: web

    Digital Hollywood conference-goers are told to throw just about anything at the Web and see if it sticks.

    Source: http://news.zdnet.com/2100-9588_22-6129357.html

  17. How to install older version of browser on PC

    Date: 10/25/06 (WebDesign)    Keywords: web

    Sorry, I realize this isn't a web design issue per se, but the reason I need to do this has everything to do with web design, and I figure you guys, if anyone will know. I don't know my way around the technical stuff on a PC very well... I've only been working on one for a half a year-- other than that it was Macs for me.

    So I just installed the update for IE7. I wanted to install it separately from 6 so I could still run both for testing purposes, but before I knew what happened, IE7 had overwritten IE6. I even saved a backup of 6, but apparently I didn't get all the files, because it didn't work.

    I found and downloaded an install file for IE6, but it won't let me use it now, because it detects that I have a newer version installed.

    How do I install both on a PC?

    Source: http://community.livejournal.com/webdesign/1181992.html

  18. Portland lets desktop Linux roll for VARs

    Date: 10/27/06 (Open Source)    Keywords: web, linux

    For the knowledge worker, those who need access to the Web with an e-mail client and office suite, we can offer good Linux alternatives

    Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/41974838/

  19. Did worm infect Alaska candidates' site?

    Date: 10/26/06 (Security)    Keywords: virus, web

    A husband-wife team running in the state's governor's race blame a hacker for infecting their election Web site with a virus.

    Source: http://news.zdnet.com/2100-1009_22-6130025.html

  20. Requesting suggestions...

    Date: 10/27/06 (WebDesign)    Keywords: php, browser, java, web

    Ok, so, it's really late and I'm tired as balls, but before I crashed I thought I'd beg y'all for some advice. I recently revamped (e.g., stayed up too late working on) my parents' business' website (www.stenrudgreenhouse.com) and added a photo gallery with zenphoto which '[info]'asu_ska_kid had recently promoted. I like it a lot (zenphoto that is, I still don't know about the website =p), however because I didn't want to redo all the pages, and I wanted to integrate the photo albums, I basically embedded the photo gallery into an iframe on the photo page. Which seems to work fine, except the page is really long on some, and you have to scroll on others (vertical images). I tried using a javascript from dynamicdrive that automatically adjusts teh height of the iframe to the content contained within in, but when scrolling through the albums (previous and next images) sometimes the iframe would become, like, 30 px tall. I didn't want to try and figure out why, so I took it out and just made the iframe a static height. Not to mention it doesn't work at all on IE for Mac.

    So, what I'm asking is, (1) is it ok to keep it the way it is? If not, is there a better solution to automatically adjusting the height of the iframe for someone who knows not a bit of javascript or php? (2) any general suggestions on the site - navigation/info arch or design-wise? I have only tested it so far on a Mac (Safari, Firefox, IE), so glitches on PC browsers would be welcome as well.

    Thanks, again, as always ^^

    Source: http://community.livejournal.com/webdesign/1182662.html

Previous page  ||  Next page


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home