hello everyone, how can i create an updatable view in sql server 2005. Thanks.

Dear all, I have a webservice project running on Computer A. I am calling a webmethod from this web service from an asp.net project on computer B, it is working correctly. But the problem is when i am trying to call the same webmethod from another asp.net project on the computer B, i am receiving this error: The underlying connection was closed: Unable to connect to the remote server. it is not a security problem or configuration since the same webmethod is working on the first asp.net project Can anyone help, thanks.

Dear, I have a .msi file. i want to run it from a vb6 exe, I mean I should call it from the code. can anyone help me with this, what is the syntax for calling a .msi file. thanks

hi everyone, I have an old application VB6 and ASP. the asp pages are on the webserver, the dll is registered on the webserver (win 2000), the dll is in the com+ also of the application server (win 2000). everything is working correctly. When we change the webserver to a win 2003 server, I should register the com object on this new server, I made export from the application server, and I register this com on the new web server (win 2003). I had this error: server.createobject failed. it is like asp can't create any object. what is the problem? security or configuration?

Dear all, i need to do a javascript validation for a textbox, this textbox is for the amount, the user can enter for example the value: 2 or 3.2 or 0.7 I should allow him to enter a digit and also ".", what is the simplest regular expression to do this. The developer that worked previously on this project, put this regular expression: var objRegExp = /(^-?\d\d*\.\d*$)|(^-?\d\d*$)|(^-?\.\d\d*$)/; I can't understand it specially the -? in the begining of each part, what exactly do the "-?" and also for which validation this regular expression is used. Thanks.

Thanks, but this give me the computer name when a row is added, when a row is updated or deleted nothing is logged. I can't know who update a specific record. any other idea. thanks again.

hi everyone, In my company, 4 users are accessing the sql server with a username and a password, they are developers, they have rights to create tables, fields, insert rows, deleting rows,... how can I trace which computer make an insert or delete. for example if a user make an insert into a table from SQL Server enterprise manager by writing an insert query, how can i know which computer make this action? is that possible? thanks.

I tried it, but it gives an error, any other solutions. Thanks anyway.

hi everyone, I want to update a row in a table in SQL with values from another row in the same table, i wrote this: UPDATE Income_Codes IC SET IC.DateLeave = IC1.DateLeave FROM Income_Codes IC1 WHERE IC.Cm = 420 AND IC1.Cm = 911 but it didn't work. I tried this: update Income_Codes set DateLeave = (select DateLeave from Income_Codes where Cm = 911) where Cm = 420 it worked, but if i have to update 20 fields, i have to write 20 selects, any other solution? Thanks

Hi everyone, I am working in a company where data is changed daily (it is a shopping center) where item prices change everyday, quantity in stock vary daily,... What is the scenarios available for the back up on SQL Server 2000 (I am a developer not a database administrator, but I have a task to do which is to make a back up for the critical data) . could u help me with some links or idea. I was thinking of doing a full back up one time everyweek and daily I will do a differential backup? I can't do a full back up daily because data is more than 20 GB and also some tables in the SQL database hold data that is very critical and (I want to include these tables in the backup) other tables holds data not important (I don't want to include these tables in the backup). is that the best solution. Thanks.

I have a textbox and a date time picker. the text box is used to display the value choosen from the date time picker. When the focus is on the textbox, if the user click the ENTER key, I want that the date time picker open, and the focus is on it so the user, by using the ARROW keys, can choose a date. I know how to test the key pressed by the user, this is my code: Private Sub dtpprofdate_DropDown(ByVal sender As Object, ByVal e As System.EventArgs) Handles dtpprofdate.DropDown Me.dtpprofdate.DropDownAlign = LeftRightAlignment.Right Me.dtpprofdate.Focus() End Sub Private Sub txtdateproforma_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtdateproforma.KeyPress If KeyAscii(e) = 13 Then dtpprofdate_DropDown(sender, e) End If End Sub IF the key is an ENTER key (KeyAscii(e) function make the checking)the DropDown event of the date time picker is fired. But the problem is that the date time picker is not opening?? Any help

Thanks Guffa but I don't want to remove them, depending on a radio button choice, I want to hide the first two elements. If the user select another radio button I want to show these 2 elements, How can this be done in Javascript? thanks again.

Thanks, I used the disabled property. Now I want to hide the first two elements in the drop down list, how can I do that using javascript. thanks again.

Hi everyone, I have an aspx page, in this aspx page I have a drop down list, I want to set this drop down list to Read only so the user can't change the selected value, I want to set this drop down list to Read only in Javascript and not using the code behind, what property should I use?? Thanks.

Hi everyone, I want to learn web services from A to Z, how to write web services, how to call them, how to let other user (on other machine of course)use them. what protocols I need to understand in order to write web services... If you can give me some links to articles or tutorials to begin understanding the web services technologies. also if u can give me some book titles discussing web services. Thanks.

hi everyone, when I make an alert in Javascript, I receive the title on the alert window "Microsoft Internet Explorer". Can I change it?? Can I change the font or color of the text that I enter in the alert window?? Thanks.

hi everyone, Their is a control that I want to use but I don't know the name or from where I can get it. This control is: we can write in it like a textbox but it store the previous entries so we can choose from the previous values like a drop down list. what is the name of this control? Thanks

Hi everyone i am new in writing stored procedure and calling them from .net can anyone tell me about a link to an ebook or articles about stored procedure. thanks.

hi everyone in many sites, their is two options for doing search: search the website or google search. i know that the first one search all the pages in this site only and the second make a search like in google. -i think the first one can be done in .net, can anyone help me for doing a search in all the pages of a website? -how can i implement the second search (google search) should i subscribe with google?? or something else. thanks

hi everyone, i have a datagrid that displayed data from a database. i have 2 template columns, the first one with a check box. the second one with a drop down list.When a user change the value in the drop down list the check box should be checked automatically. my code is: Dim item As DataGridItem For Each item In Me.DataGrid1.Items Dim cbRules As CheckBox = item.Cells(0).Controls(1) Dim ddEvent As dropdownlist = item.Cells(14).Controls(1) Me.ddEvent.Attributes.Add("OnChange", "checkcbEvent();") Next the function checkcbEvent() is a javascript function: function checkcbEvent() { document.Form1.cbRules.checked = true; } but it gives me an error: document.Form1.cbRules is null or not an object Can anyone help?????