9,022 Topics
Hello there, I am trying without much success to display multiple columns from a database where the selected data is dependant on specific common data. I have tried using an SQL statement with a Jet 4.0 OLE DB connection. SELECT Name,Date,Action FROM Track WHERE SerialNumber="1" with the output displayed in …
Hello guys, I have been working for a long time a project in vb.net using a database which is in SQL Server 2000.I am currently trying to upload an image!The file i want to upload is not type image but nvarchar.I have made save it inthe database as ID of …
Hello, I was wondering if there is any altrernate to Ms SQL Enterprise Manager? and of course a free one Thanx
hello 2 all, anyone can help me.i am a newbie on programming and i dont know how to use grid. this is the scenario when i search on a database using sql i want to display it to a grid. i am using the component Microsoft datagrid control 6.0 (SP4)(OLEDB). …
Hi, Here is the scenareo as well as I, a nubi can 'splain' it. Three pages: 1. Order Form page. Collects the data and use input. Very complicated, but works and does its stuff well. 2. Processing page. --a. checks for errors, returns errors - all ok --b. If no …
Hello, Does anybody know of a tutorial on download specific data from a web server sql db and inserting this into a local access db?
Hello all, I am here for help again. Any time i run my application, it gives me this error. "An attempt to attach an auto-named database for file C:\techno-wise consortium\techno-wise consortium\Database1.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on …
How do you display a drop down box with a resultset in a loop? I just get a sql exception with my current servlet code. any help appreciated Thanks [CODE] out.println("Select Reading List"); out.println("<select name=" + rs1.getString("degree")+ ">"); while(rs1.next()){ out.println("<option value=" + rs1.getString("idcol") + ">" + rs1.getString("degree") + "</option>"); } …
[B][/B] Gentlemen, I have two badly designed tables - I didn't design these table, they where passed on to me. The tables are so cumbersome I have to create a new table, to be able to use their data. [B]Please see attachments to have a clear idea of the table …
Hi all, I've been designing a program in VB6 to extract certain rows of data from a SQL Database and shoot them out over email. Problem is, the farthest I can get is to printing them on the VB form, and can't do much else. I get an error when …
I have a customer with a small accounting/invoice software program (order pro). Not very fancy at all. At any rate, the software stores all of the invoice data in one ".XDB" file. Anyone have any idea what type of database this could be? It seems like the application is an …
Hi new to the forum. I hope there is someone that can help me. I need to retrive some data from a table in sql server. The data is going to be used in an import to some other tool. The problem i have is as follow. I want to …
I have written a VB6 application to query an industrial MSSQL database and installed it locally to run on one network machine, Is it possible to install it on the server to allow all users to run it? Is the compile/build any different?
[B]Hello,[/B] We are small but very smart company located in Lithuania developing products for German, Canadian and Lithuanian customers. We are looking for bright, experienced and responsible developers capable of [B]working remotely[/B]. If you are web experienced developer developing with Microsoft platform ([B]ASP.NET[/B], [B]C#[/B], [B]MS-SQL[/B]) you are warmly welcome. To …
hello , i want to add new record ino database ,but getting some problem pl help me front end :- VB.net2003 back end :- SQL Server 2000 my efforts : Imports System.Data.SqlClient Imports System.Data Dim conn As SqlConnection = _ New SqlConnection("server=;database=tempdb;uid=;pwd=") Dim ds As New DataSet Dim da As …
hi i am facing problem with insertion of data into database front end:- vb.net2003 backend:- SQL Server2000 please tell me code with which i can insert data in database
Hey everyone, This problem I've been working with has got me stumped. Let me show you the table layout first. ID_NUM int, SEQ_NUM int, ATTRIBUTE_CODE char(2), ATTRIBUTE_DEF char(50), JOB_TIME datetime This table contains a list of activities individuals like and there is no way of knowing which one they like …
The tables are joined. I want to display last 7 data with grouping their category My tables: Category: categoryId, categoryName Order: orderId, catgoryId, product
Hello, Could you help, with sql injecton about from where i can download it and who it is works. plz
Hi I have question. When I post a thread, on focus of that thread, the brief discussion of that thread is displayed. I would like to know, how to develop that feature. Can some body help me out?
Someone please help!! I am use to working with MS Access. So, for me, working with SQL is a downgrade at this point. But, I have to do it. I am working with Microsoft Visual Web Developer which apparently is supposed to be easy!!! The help feature is pretty extensive …
i have a column "discription" in my item table that is full of HTML code. It was created using and editor like the one i am using here. It is five pages long when i print it out. I need to update the column in all records of the table. …
Hi guys. I have a program which needs to store some user profile data. I want to use a database to do this, but i've never worked with databases. I was wondering if anyone can help me with it. My program is written in the java programming language, and i …
hi :) any comments appreciated about my site [url]http://extendedprocedure.com/[/url]
OK, one last thing. Now I have 3 textboxes and here's what I wrote: [CODE] SqlConnection conn = new SqlConnection(); conn.ConnectionString = "data source=.;initial catalog=ForumDataBase;integrated security=true;"; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "INSERT INTO PostTable(ThreadTitle,PostMessage,UserName) values('"+ThreadTextBox.Value+"','"+PostTextBox.Value+"','"+NameTextBox.Value+"')"; cmd.Connection = conn; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); [/CODE] Can you please tell me what's …
hi to all I am trying to make a simple java servlet(like jsp) program which allow user to update his profile but I have a problem when user click on update's button [CODE]String un = req.getParameter("username"); String Fn = req.getParameter("Fname"); String Ln = req.getParameter("Lname"); String pw = req.getParameter("passwors"); String updateString …
Please help me " System.Data.SqlClient.SqlException: Prepared statement '(@Name varchar(100),@Describes varchar(100),@Money char(10))Upda' expects parameter @Describes, which was not supplied. at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Assignment.rose.dtgFlower_UpdateCommand(Object source, DataGridCommandEventArgs e) in c:\inetpub\wwwroot\assignment1\rose.ascx.cs:line 111Error:Cannot update " This is the code "namespace Assignment { using System; using System.Data; using …
Dear friends: I've copy the asp.net code from Unleashed book. I want to use this part of the code to take stored procedure rather than select statment. The stored procedure I write for is this: ********************************************************* CREATE PROCEDURE authenticatedUser ( @userName Varchar ( 20 ) , @userStatus Varchar (20), @userPassword …
Hi All, I have a software module(enquiry) developed in ASP using MSSQL as back end. In the index page , i display 4 new enquiries for the logged in user, clicking on which land to the enquiry pages. This has been working fine. But now recently i have come across …
I've always heard it best to keep processes separate when dealing with Application servers etc. My question is this: [COLOR="Red"]Are there any best practices associated with creating a website that queries a SQL Database? [/COLOR] My thought is to separate the web element from the SQL Server and host it …
probably, all of you have seen this scenario a lot when entering customerID into a large database it takes AGES to bring back one simple record of a single customer === let's say, this has been DONE already , for tuning performance separate the CUSTOMERS table into 2 TBLcustomer1 -- …
Hi All, I have a software module(enquiry) developed in ASP using MSSQL as back end. In the index page , i display 4 new enquiries for the logged in user, clicking on which land to the enquiry pages. This has been working fine. But now recently i have come across …
Hi, I have created a Crystal Report Viewer. When compiled on my machine it works fine. However, earlier this week I had to make a copy onto a server. When doing this I had encountered several problems that I maanged to solve...except for one :o(. No matter what I try …
hi to all i am creating travel project, i want to insert image path in the sqlserver and i want to display image in the dataridview using c#, please sombody help me to clear my problem thankin you raghu
Hi, I'm doing one ASP.NET project with vb.net as code-behind. I'm using SQL Server 2000 as backend. I want to store the date in the following format. [B][I][COLOR="red"]2007-10-29 14:08:00[/COLOR][/I][/B] Can anyone please suggest how to get this format?
Dear members, Please help me in regarding my problem. I am very much confused on whom to blame for the problem........MSSQL? or .NET ? or Win server? I have a dedicated server with 2GB RAM, SQL 2005, 150GB bandwidth, 160 GB disk space etc., I have created a .net application …
Hi I have created one form with labels as ScripName,LTP1,LTP2,LTP3. 1.Now i want to write an event procedure for On Click event.I want to run the following update query when i click on LTP1 label UPDATE ppc500 INNER JOIN bse500 ON ppc500.ScripCode = bse500.ScripCode SET bse500.LTP1 = ppc500.ltp; ( ppc500 …
Hi I am new in VB.net . I dont know how to connect vb.net with sqlserver. Would any one help me regarding this . Thanks Nazrul
Hi I am experimenting with VBScript and SQL and am unsure if the following code will actually work. I do not have access to IIS at present so I am unable to test it. I would be greatfull if anyone could just take a brief look at the code to …
hi to all,, some one please help me how to ctreate image table in sqlserver 2000 and displaying image in the datagridview using c#
I am getting a server report from one of our companys sent to me and everytime its sent I try to open it in outlook and it says The page cannot be displayed An error occurred on the page you are trying to view. -------------------------------------------------------------------------------- To work around this problem, …
hi jerry thanks for dropdownlist, but i got another problem regarding updatating a profile of a login member, i created a storedprocedure for login information just look at my codding CREATE PROCEDURE sp_UserValidation ( @Username varchar(50), @UserPassword varchar(20) ) AS IF EXISTS (SELECT UserName FROM LogIn1 WHERE UserName=@Username and UserPassword=@UserPassword) …
Recently had to re-install all of pc...not a prob as all (except db) was backed up to seperate hd. I develop locally using MSSQL client tools and adp's and then upload new tables as and when ready. I had done quite a bit of work when pc died, and now …
Hi everyone, Can anyone tell me the security issues when passing url parameters for a forum. I'm building my own forums using dreamweaver and as I understand it, using url parameters make the site susceptible to sql injection. Regards Taffd
Hi, Simple query: [code]select * from MyTable where Id=123456;[/code] The first time I execute this query it takes 14 seconds. However, the second time I execute it takes 0 seconds. I wanted to clear the cache so the second execution takes 14 second just like the first execution. So i …
hi, Can anyone please show me how to use siss, and how to load data using SSIS. thank you
I have this assignment in school that says i should connect my asp.net website to my database and i'm finding it difficult, could you help pls? thanx i basically need the codes,i created my database using sql.
i need some help here i have design a gridview which contains two columns with dropdown list first is emp_id column n second is orderofwork column...when i try to update database with selected values in dropdown it gives me the following error Conversion from string "update subj_emp_assign set emp_i" to …
I need help to write a stored procedure, or pseudo code, that looks into a table named numbers_ranges and retrieves the next unused value. The table currently has the following data: Columns are: id, start_range (22), end_range (22), status (1), date_created (datetime), date_updated (datetime) 1 8057777777450780000000 8057777777450780000010 N 2007-11-29 16:28:46.793 …
Hi, A third party development company is creating a third party application for us in PHP and uses a MYSQL database. The app is an extension of our website which is developed in .NET and uses a MSSQL 2005 database. There are some cases where the two databases require connectivity …
The End.