thanks :-D

nelsonpaixao@yahoo.com.br trying to help & get help

Hello, in some table, how can i perform a group by not by the column string but only by the letter of that column thanks :-D

nelsonpaixao@yahoo.com.br trying to help & get help

Hello there guys, i trying to perform some right join to keep all records from tbl custumers, it works fine but when i do the "where" condition i noticed it killed my right join how can i solve this? i have a way to get the output i want but is very messy, so i guessed u guys could help me here, i sure is very easy X|

select Customers.cname as c_id, sum(Products.price*Purchases.quantity) as z
from Purchases
right outer join Customers on (Customers.CID = Purchases.cust)
left outer join Stores on (Stores.SID = Purchases.Stores)
left outer join Products on (Products.SKU = Purchases.prod)
###where Stores.city = "Porto"
group by Customers.cname
order by z desc

(my aim is to show total value of purchaces per client in some store, but i need to include all client even those that didn´t shop (zero values)) thanks

nelsonpaixao@yahoo.com.br trying to help & get help

i don know what kind of design you have in mind for your application :doh: you can also use usercontrols like pages create a single form that you fill with the usercontrols designed like page, then bring to front the page you want. You can do this insead of creating child forms, if you don´t want to open new windows and run all the show in the same window you have to manage delegates here

nelsonpaixao@yahoo.com.br trying to help & get help

modified on Thursday, August 6, 2009 8:05 PM

make a list of web sites from where you can send free phone msg create a bot in a free web host to navegate to a site to collect information, then navigate to free msg site to send that information to your phone when you run out of messages send from other site

nelsonpaixao@yahoo.com.br trying to help & get help

no stand alone, stored in dir in free web host

nelsonpaixao@yahoo.com.br trying to help & get help

Is it possible to a asp page trigger a c# application? (C# application + free web hosting asp page in the same computer) can the asp page show c# application in the browser?:omg:

nelsonpaixao@yahoo.com.br trying to help & get help

it´s for a browsergame bot, i need a "window" to view the bots work (in the asp page) :doh: i can do it on c# application but my pc is not connected 24 X 7, so i have to use a web host page just need some guidence here, no need to post code

nelsonpaixao@yahoo.com.br trying to help & get help

how can a have a webbrowser inside my asp webpage? i add reference system.windows.forms and and webbrowser in toolbox, but it is disabled

nelsonpaixao@yahoo.com.br trying to help & get help

no, it exists in c#

nelsonpaixao@yahoo.com.br trying to help & get help

hi, what is the equivalent to AxSHDocVw.AxWebBrowser in asp? i cant find that object in asp only in c# application can anyone help me

nelsonpaixao@yahoo.com.br trying to help & get help

solved :doh: i will use that axbrowser intead, i add to tools

nelsonpaixao@yahoo.com.br trying to help & get help

is that really what you want to do? i create the database and all the required store procedures in sql server, only then i begin to build c# application i don´t do any sql in c#, i just trigger a sql SP i want by triggering an event like button click so, i have a DataGridView to show datatable and i trigger refresh, add, delete, edit row SP procedures for exemple to make changes i have also crystal reports viewer, but here you will have to built a scheme that is a 100% match your datatable scheme in order to work, DGV doesn´t need that, it "loads" anything regardless the datadable scheme

nelsonpaixao@yahoo.com.br trying to help & get help

I use sql server :doh: but i think it works quite the same "It will have several users who are going to update the information on the database" remember to manage threads in your applications if you didn´t do that yet "I have no idea how to write the connection string" download microsoft absolute beginners lesson videos (it´s free), there you will find out how to connect to a databade from a asp site

nelsonpaixao@yahoo.com.br trying to help & get help

" Cannot convert type 'System.Windows.Forms.HtmlDocument' to 'mshtml.HTMLDocument' " it for a browsergame bots, i need to see the bot work i got the code from a project here but it uses a AxSHDocVw.AxWebBrowser and assemblers shdocvw and axshdocvw, i think is from old version for course if a change the project code it works i want do changes in code in order it to work in webbrowser object (not in AxSHDocVw.AxWebBrowser)

nelsonpaixao@yahoo.com.br trying to help & get help

i understand what you said, but i don´t want to do that google is a exemple, i what to login to one site using that type of code

nelsonpaixao@yahoo.com.br trying to help & get help

My application has a WebBrowser object Inside a WebBrowser object i navigate to google site and from there a want to type something in the textbox and then press search button how can i achieve that? can anyone check this code?

WebBrowser_Main.Navigate("http://www.google.com/");

        while (WebBrowser\_Main.IsBusy == true)
        {
            Application.DoEvents();
        }

        HTMLDocument myDoc = new HTMLDocumentClass();
        myDoc = (HTMLDocument)WebBrowser\_Main.Document;


        HTMLInputElement otxtSearchBox = (HTMLInputElement)myDoc.all.item("q", 0);

        otxtSearchBox.value = "code project";

        HTMLInputElement btnSearch = (HTMLInputElement)myDoc.all.item("btnI", 0);
        btnSearch.click();

thanks

nelsonpaixao@yahoo.com.br trying to help & get help

what i advice you to do is to design your database scheme first of all turn off the computer, write everthing down before you hit the keyboard after you have your database scheme, take your time to build the database, i advice you to manage login in sql (create user table with id/user/pass and trigger a login store_procedure). go to c# only after database is donne - - - About the connection to the database in the previous post you see a way to do that You can find lots of stuff on google if you use key word like "c# database connection" but i advise you to download microsoft absolute beginners lessons videos, it´s free and you will understand it better in alternative download a project here in codeproject

nelsonpaixao@yahoo.com.br trying to help & get help

"...Now as you know that grids are editable so if any changes are made inside the grid then how to update..." sorry i didn´t check your code because of this sentence you don´t edit that DataGridView, you edit the database in sql database, you create Store Procedures that you trigger in an c# event like button click the SP you create are: insert row, update row, delete row etc etc etc so, to make changes in the DB you have to trigger the procedure you want, after, show it in the DGV (later, don´t forget to use crystal report to display and print data)

nelsonpaixao@yahoo.com.br trying to help & get help

I want to get and set values and trigger events in a website that loads inside a WebBrowser object so, i cant get the code right i get NullReferenceException

WebBrowser_Main.Navigate("the_link");

        while (WebBrowser\_Main.IsBusy == true)
        {
            Application.DoEvents();
        }

HtmlElement textbox_username = WebBrowser_Main.Document.GetElementById("user");
HtmlElement textbox_password = WebBrowser_Main.Document.GetElementById("password");
HtmlElement button = WebBrowser_Main.Document.GetElementById("submit");

textbox_username.InnerText = "the_username";
textbox_username.InnerText = "the_password";
button.click(); // i have to work delegates here :()

nelsonpaixao@yahoo.com.br trying to help & get help