9,022 Topics
Hello all, I need your help urgently.....................I have database in SQL server and using asp.net 1.1 I need to do something which like when deadline came then after every day of it, administrator has to send mail to that user something about.........User already registered with its mail address.... Please help …
Hello people! i reallay dont have a clue how to connect my newly made database to my c# please help.
Heya... just stumbled across the forums and so far have found quite a few interesting posts, so figured I'd join. :) Currently working as a web architect focusing on student achievement solutions in public education (w00t, fun times). Most of my time is spent in C#, SQL, or dinking with …
My page displays the info in the text boxes, but when we run the click sub for the update button it returns the info that it has been updated sucessfully. Here is the page code and below that is the stored procedure it uses, but not update in the database. …
my default homepage cannot be change.the current default homepage is [URL="http://www.securityuptodate.net/"]http://www.securityuptodate.net/[/URL] which i dun wan to have it as my default homepage.in the internet properties it is written as <about:blank>. So can anyone teach me how to allow me to change the default homepage to my liking? this is my …
[B][COLOR=DarkOrange]ADO.NET is a web-enabled database application.. Likewise, is sql also a web-enabled database application?[/COLOR][/B]
I have a Windows 2000 server on my network, running SQL Server... I've been away from the main office where the server sits and I found there a full system log. Turns out it filled up since Sunday with Log on failure on Account "Administrator". Look like a brute force …
Hi! I'm trying to teach myself VB.NET and having some troubles right now... please help me out :sad: I'm working with NorthWind database in MS SQL Server. I suppose I'm trying to populate tables into ListBoxes and the following highlighted lines are giving me an error (Value of type '1-dimensional …
Does anyone know of any way to select only a certain number of records to appear on one page - say, like 30? - then having links to other pages of records if the number of records exceeds 30?
Hi all i'm trying to populate a datagrid with a data from a sql database and i keep getting this error [I][B][COLOR=red]The ConnectionString property has not been initialized.[/COLOR][/B][/I] [B][I][COLOR=black]my code looks something like this:[/COLOR][/I][/B] [B][I][COLOR=#000000][COLOR=#0000ff]<Private[/COLOR] [COLOR=#0000ff]Sub[/COLOR] GetAssetDetails()[/COLOR][/I][/B][COLOR=#000000] [I][B][COLOR=#0000ff]Dim[/COLOR] cnn [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] SqlClient.SqlConnection[/B][/I] [I][B][COLOR=#0000ff]Dim[/COLOR] sql1 [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]String[/COLOR] = "SELECT DETAIL.[OFFICE LOCATION],USERS._RESOURCEGUID,OS.[OS …
I have an app that performs scans and returns information like what windows updates it has, services running, programs installed, browsesr history, etc. Scans will be performed once a week and sent to a server. The server will only save the most recent scan and store the rest in a …
Hi All, My company is use Coldfusion 4.0 & SQL 7.0, but now want to change to use SQL 2000. If I change SQL 2000, is it have any problem or did I need to do something in program or server. Many Thanks.
HELP - Invalid object error related to sqlole null bug in MSSQL 2000? We had a contract programmer come in last year to write a set of scripts in VB6 that select records from a MSSQL 2000 Enterprise Edition datbase table for display on a web site. Everything was going …
Hi All, I have a problem with a table level constraint i want to create. i have 3 tables: products categories product_categories - use to connect product to categories since a product can be added to more then one category. my problem is i want to create a contraint in …
Hi, I have a slight problem. I am trying to create a mail service for a new game which I have started creating recently. Each user that registers also creates a table for their mail. As the usernames are variable and the table name is the username, I need to …
hey all i need ur help i have a database, and a table with report column. in this column, i storing data and i can change the bold, colored and aligned the text using a toolbar,[B] like the toolbar here when u want to put a thread[/B]. all that is …
I am using netbeans to build this program,but it give this error java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:545) at java.sql.DriverManager.getConnection(DriverManager.java:193) at test.Main.<init>(Main.java:33) at test.Main.main(Main.java:72) how can fix it [code]/* * Main.java * * Created on 14 نوار, 2006, 07:39 Ù… * * To change this template, choose Tools | Template …
I have a form page on the web using a FormView. There are a half dozen fields for the user to fill or select from drop downs. These get populated into the sql database with the standard sqldatasource insert statement. However, I also want to add the current date and …
I have a table to store the answers of users of our sweepstake. The table that consists of 3 fields: the userid, the questionid and the answervalue. Now I need to find the users with the most identical answers as a certain user. For example I may have values like …
In MSSQL "SQL server enterprise manager"(client side), I run query and application display record list, if I want to set a cell to "<NULL>" value, how can I do that with the hot key? thanks for any answer.
I have a table in MS SQL Server 7.0 Like this: Id Cat_Name Definition Image 101 A1 --------------- ************* 102 B1 ----------- ************* 101 A2 ------------------ ************* 103 C1 ----------------- ************* 101 A3 --------------- ************* 101 A4 ------------------ ************* 102 B2 -------------------- ************* 101 A5 -------------- ************* 101 A6 ----------------- …
[COLOR=#555555]I have a table where the user will enter a commencement and ending date and an amount that was charged for the period of time. This is all on a subform, link together by an account number. Also, each record on the subform, may have multiple dates For example:[/COLOR] [COLOR=#555555] …
Hello there all, I need your help..........I have datagrid with its data from SQL server. But i want to update its data to click the ID......That is it........ <a href = "DataUpdate.aspx"> Something here to validate my ID </a> Please help, any idea would be big big help to me......Since …
Hi, I'm writing some complex queries on a very poorly designed database. We're running on MS SQL Server2000. I was wondering if its possible to do in-line if-else blocks within a query.. i.e. [PHP] SELECT * FROM tablename IF (condition1 = 'a') WHERE condition2 = 'a' ELSE WHERE condition2 = …
Hai I m Radha working as a Programmer. I hv done many sites using Access as backend...i wish to try one with SQL Server..so can anyone send the connection Program for ASP with sql server !!
Hi, I'm currently creating a database and need to create a query to show all the records that the warrenty date expires within the next week. i know this is a simple query as I did it when doing my A-Level in computer studies however I was working in a …
hi, sorgu = [COLOR=#0000ff]New[/COLOR] SqlCommand([COLOR=#800000]"SELECT name, surname, age FROM veriler WHERE name=@name"[/COLOR], database) sorgu.Parameters.AddWithValue([COLOR=#800000]"@name"[/COLOR], DropDownList1.Text) name surname and age are rows in one of columns. i cant add them into the DropDownList. DropDownList2.DataSource = kisiler DropDownList2.DataTextField = [COLOR=#800000]"name" [/COLOR]DropDownList2.DataTextField = [COLOR=#800000]"surname"[/COLOR] [COLOR=#800000]DropDownList2.DataTextField = [COLOR=#800000]"age" [/COLOR][/COLOR]DropDownList2.DataBind() this line add only "age". …
Hii All :) I am presently working on a project that has A website and All clients are having their own Windows Applications ... I want to manupilate the data in the website and Clients application using a Web Service. So My Web Service Should Get the data From Website(SQL …
I ran the SP3a installation and it didn't return any errors along the way. However, when I ran the query to look at the current version of SQL it still has the service pack at version 1. Any idea why? P.S. I think the installation process is asinine.
what I use is SQL SERVER 2000,the system is WINXP SP-2 I set the classpath:C:\Borland\JBuilder2005\jdk1.4\lib;.;C:\Program Files\Tomcat 5.0\common\lib;.; I use the JDBC-ODBC to connect the database,the original code is package hospital.db; import java.sql.*; import hospital.db.*; public abstract class DBConnection { private static Connection conn = null; public static Connection getConnection() { …
Hi, can someone help me to code this ? I have a dynamic datagrid and I want to insert only one column from selected [checkbox] rows in the datagrid into a SQL-Server table. I've a working code where I call Add_to_DB function within the loop of Datagrid items, which works, …
Hello All, I'm sure this is an easy one for you all, but pardon...I'm kinda new at this. What I'm trying to do is store a URL in a SQL table using a text field. This is working successfully and as planned. The heart of the issue: I have 200 …
Again, thank you for taking the time. I seem to have fallen into someone else's thread, but am so glad i did. this is the 1st place I have got any real help, & haven't even comunicated with any body yet! I came in looking for help on the FakeMSNBeta, …
Hye, im new here. Need some help on Vb6 coding. I've look up some of the treads on timing in this site but i have problem implementing it. [CODE]Public CHours As Variant Public CMins As Variant Public CSecs As Variant Public CMSecs As Variant Dim StrNested(4) As String ------------------------------------------------------------ Private …
Hi, I've got a module where i search for a candidate with his Id and display his name, age..etc.. I've put the details like name , age etc.. in the datagrid. The search module is working fine.. when a valid candidate Id is entered. But when an invalid ID is …
Over the last several weeks my Internet Browsing has slowed to a crawl. Please help me find out why... Logfile of HijackThis v1.99.1 Scan saved at 09:14:00 PM, on 04/26/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe …
Dear Colleague: In vb I could retrieve a data sored in SQL 2000 server, using grid object placed on the form object. But when I tried to do it using code, meaning with out placing ADODC object in the form object, I couldn't go any longer. Is there any one …
Hi there, I was trying to get a [B]Scheduled Job[/B] (in SQL Server 2000) to [B]run every second[/B] or two. I had three T-Sql blocks I needed to execute every two seconds, and you know you can just schedule recurring times to every minute. I started out by introducing multiple …
Hi, How can i get this on screen ? sql= new sqlcommand("select count(*) from datas", database123) ... ... persons=sql.executereader() ... ... label1.text= [B]????[/B] [B]Thanks[/B]
Hi, I have column with alphanumberic fields like: trader1.dbpt 1234.mcxl abc243.cexl 234-lab.cxcl There are following characteristics of this data: -fifth last place is always decimal -always four characters after the decimal What I want: -only those rows which have ".mcxl" at the end -rows should NOT have numbers in them …
help please........... i need u're recomendation of site to visit i need to learn (freely) the query (SQL SERVER 2000) thank's:confused:
Hi I have 3 tables that I need to display in a report TableA idxA valueA 1, a 2, b 3, c TableB idxB bidxA valueB 1, 1, aa 2, 1, bb 3, 1, cc 4, 2, aa 5, 2, cc TableC idxC bidcA valueC 1, 1, dd 2, 1, …
hi i have to retrieve a webpage from database given i have the id which is passed to that page as q querystring. here is my code ave 2 pages the one where u clik on hyperlink <<A href="mailto:%@LANGUAGE="VBSCRIPT">%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% dim objConn, objRS Set objConn=Server.CreateObject("ADODB.Connection") objConn.open="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= D:\Datastores\greeting.mdb" …
Hi, I have a composite in a Microsoft Access Database that is not populating, when I add data to the two tables connected to it you would expect the Composite Key to populate as well wouldn't you? But this is not happening, can anyone expalain why and how this problem …
How can I create a Formula to figure out a Golf Handicap IN MS SQL Step 1 (Score - Course Rating) x 113 / Slope Rating For example, let's say the score is 85, the course rating 72.2, the slope 131 The formula would be (85 - 72.2) x 113 …
I have this red/green popup that says my computer is infected. and upon clicking on it (my stepfather insists) I get this site [URL="http://www.spywarequake.com/?aff=247"]http://www.spywarequake.com/?aff=247[/URL] So i deceided to do a hijackthis and here is the log [I]\start logfile[/I] Logfile of HijackThis v1.99.1 Scan saved at 11:00:00, on 22.4.2006 Platform: Windows …
please help i need to learn abt query with transact-sql server 2000 a free module please............... thanks:)
Hi Again, I am choosing a server and its operating system for my office. I have two choices for hardware and another two for software. I have offers for HP Pavilion and HP Proliont; As far as I know HP Pavilion is for home use but the difference in price …
[B]Hi all The problem is the following : [list]I am in a project that contains a table of users[COLOR=Green](user_tbl)[/COLOR] and another table of groups[COLOR=Green](Group_tbl)[/COLOR] . and each group can contains multi-user by [U]Group_Id[/U] which is foreign key in [COLOR=Green]user_tbl[/COLOR] . [/list] [list]I am now about creating a trigger that happens …
hi there! Can anyone help me on this... I am currently working in a webbased application using CF 4.5 and SQL Server 2000 as backend. Im having problems with Session variables. The users are complaining for being kicked out while editing few items from quotation detail screen. the timeout actually …
The End.