6,934 Topics
 | |
| | Hi, please I need a query that performs the following: I have a table like this: set_id | rec_id 10 | 1 10 | 25 10 | 32 20 | 61 20 | 90 30 | 77 Now I have suppose rec_id = 61 and rec_id = 90 I need … |
| | Hi all, I am novice in the c #. Having completed the Application contains SQL database. But when I run on another machine gives me an error message as follows: [url]http://img103.herosh.com/2009/09/02/819895428.jpg[/url] Please note that I have the installation of the .net framework, And the connection string I used is: SqlConnection … |
| | Hello, I have an append query in my access, that is linked with sql server 2005. I want to use an append query that I maked in access, i want to use it in sql server so it can append the records to a specific table. My query is as …  |
 | As the title says, how can i convert a string value to a Microsoft.SqlServer.Managment.Smo.Datatype ??? :-/ Example of code that im looking for: [CODE] Using Microsoft.Sqlserver.Managment.Smo; public partial class 'FormName' { String datatype = "Nvarchar"; Microsoft.SqlServer.Managment.Smo.Datatype dt = datatype; }[/code] |
| | Hi I have successfully installed SQL Express 2008 on SBS 2003 a few times now- all connection issues overcome! I am now in the situation where I want to migrate the Express 2008 database (4GB limit) on the SBS 2003 production server to a valid SQL 2008 standard SBS edition … |
| | Im having trouble to use this function FillList ($sql, $selected=0) from my Mysql Class.. I want to implement it to a dropdown box in my page this is the full MysqlClass.php <?php // Read the database name for the site //PostgreSQL-PHP include "mysqldb.php"; class MySqlClass { //this are the global … |
| | Hi all, I've got my restore database code working good but was wondering if there is anyway to get some feedback from the SQL server during the restore? [CODE] Dim sqlstr As String sqlstr = "restore database " + dbNameFinal + " from disk ='" + tbBAKpath.Text + "' with … |
| | hi, i am doing a system in java for my assignment .that system is able to add ,delete,modify records. i have created sql commands for all in my programme.but i don't know how to put codings on above buttons here i attach some cods.any one please help me. this is …  |
| | I am installing sql server 2005 express as a pre-requisite along with my VB.net application setup. When I run-setup, set-up starts and after 2 or 3 minutes it gives error as follows : [COLOR="Red"]Component SQL Server 2005 Express Edition SP2 (x86) has failed to install with the following error message: … |
 | Hi, I've got two tables in a database - one a list of schools (around 50 entries), and one a list of pupils (around 17,000). Both are spatially-attributed using PostGIS. Basically I need to allocate each pupil to their nearest school. Currently I'm looping through the schools repeatedly, using the … |
| | Hi All, i worked hard with following error from two weeks. when i am connecting to my sql database from client machine using vb.net following error occured. its worked for local machine. "an error has occured while connecting to the server. when connecting to sql server 2005 ,this failure may …  |
| | hi, i have a problem,that is i have 2 datatables.in that tables item_id is uniqueidentifier and primary key column for both tables.remaing columns are diffrent columns.if i insert the data generate only item_id same guid for both tables,in remaing data is saved remaing columns.plz help me.i search a lot of … |
| | HI experts..I need ur help.. VB.NET category I need script that can be used to do settings for allowing SQL SERVER 2005 Express to allow remote connections. The settings that we do manually after installation [COLOR="Green"][B]i.e to enable TCP/IP in remote connection in Configration Manager , start Browser service, set … |
| | I want to select multiple records from sql table and insert it to a dataset when the selected index is changed from a combo box. for example if i select "1" from the combo box then, only values with "1" in the sql table's mentioned column should be inserted into … |
| | I have made one crystal report.In which i hv used sql server 2005 db and ms access db .It works properly but it doesn't work with vb.net. I want to know how to make connection string for both db for a single report in vb.net.  |
| | hi guys I want know that whether is it possible that to implement Client - Server architecture by using SQL SERVER 2005 EXPRESS EDITION as a main server and on other client PCs also I have SQL SERVER 2005 EXPRESS EDITION . So can i connect to main server from … |
| | I can't get my website to connect to the built-in db for ASP.NET login funtions (ASPNETDB.MDF). I've been trolling multiple forums for weeks now, and nothing seems to work. I've tried every combination I can think of but get some variation of 'cannot open database' or 'login failed'. Where am … |
| | Does anyone here have experience using the Acunetix Web Vulnerability Scanner? I happened to use it on my site to check for vulnerabilities and found about 15 HIGH level ones - all of them with basically the same problem: [B]Cross Site Scripting[/B] and [B]Cross Site Scripting in URI[/B]. For every … |
| | Hi Im trying to execute a the following query, but its throwing me an error [code]select apex_item.checkbox(1,"EQUIPMENT_ID") Tick, ef.equipment_type as "Device Type", e.equipment_name as "Device Name", ef.equipment_id, ef.Customer_Name as "Customer Name", ef.Site_Name as "Site Name", ef.Managed_Ip as "IP Address", dst.discovery_state_name as "Discover State", d.Error_Code as "Error Code" , d.Last_Discovery_Time as … |
| | I am using the SQL 2005 Express edition for SQL server. The database resides on another server and I connect to it from my machine through the object explorer. I have created a trigger to run certain queries and updates, but can't seem to find the trigger listed under [QUOTE]MyDB->Programmability->Database … |
| | i need to save doc file in sql database but have no idea to choose the field data type, i think it'll require binary data type. and how to save selected doc file from window based application using c#.net ,please share any solution regarding this.... |
| | Hi, can anyone please rewrite the following sql-query? It's working, but it takes some time to execute. [CODE=sql] SELECT `cd_e_calls`.`bedrijfs_id` AS gegevens_id, `gebeld` , `status` FROM `cd_e_calls` , `cd_e_gegevens` , `cd_e_negatief` WHERE `cd_e_gegevens`.`RvV` != '1' AND `bedrijfs_id` = ( SELECT `cd_e_gegevens`.`id` AS gegevens_id FROM `cd_e_gegevens` WHERE ( SELECT COUNT( `cd_e_calls`.`bedrijfs_id` … |
| | I am trying to copy a list of email addresses in Excel and paste them into SQL. I am using Navicat. I am able to paste the text, but I lose the hyperlink format. What can I do? Obviously, I new at this. Any help would be appreciated. Thanks...Gadfly_1943  |
| | Hi, currently i'm able to save an image that I have draw into SQL but I would like to knw if it is possible to update new draw picture to replace the old picture? how can i modify this code in order for it to save instead of create another … |
 | In my access file I write code in query [CODE]SELECT AccountInfo.incategory, Sum(AccountInfo.InAmount) AS TotalAmount FROM AccountInfo WHERE (((AccountInfo.Date)>=#1/1/2009# And (AccountInfo.Date)<=#12/31/2009#)) GROUP BY AccountInfo.incategory; [/CODE] It show the total amount between 01-01-09 to 31-12-09 and it show in report. but in vb6 I want I select this two date and the … |
| | Hi, I am now want to retrieve only year from my table(summary),field name(dates). So i am facing the problem on how to display the year in combo Box. my sql statement as below. Thanks If i put [b]SELECT DATES[/b], that means day,month and year will display. So, what should i … |
 | Is there a way to isolate the nth record from a table using [U]sql queries alone[/U]? The table is a [U]non relational[/U] one and you cannot use any temporary tables...Do u think there is a possible solution for this in MS SQL Server 2000? Otherwise tell me whatever you know? … |
| | hi this may sound simple but i can not get it to work i have try for about 5-6 weeks now and this my last hope all my project is to make a job dater base that workers can add jobs and cliences can see there job but i am … |
| | Pls see my code.Nothing is displaying in the grid [code]Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connString As String = "Provider=SQLOLEDB;Data Source=MSALAMEEN;uid=sa;pwd=Sa1;Initial Catalog=Biometric" Dim myConnection As OleDbConnection = New OleDbConnection myConnection.ConnectionString = connString Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select ID from bdata", myConnection) … |
| | I'm currently working on APEX where I expect the following query to work.. But its not working or giving me any errors. here is the query [code=sql]select et.equipment_type, max(case when name='Managed_Ip' then value end) as SNMP_port, e.equipment_name as equipment_name, cu.customer_name as customer_name, st.site_name as site_name from equipment_feature ef inner join … |
| | Hello everyones, I want to delete where my id has unique identifier in the table in my database.... how can I do it? Thanks |
| | Is there anyone knows how to make either bar or pie graph in vb.net and getting the data on sql 2005. I need it for our thesis please help me on my problem. Thanks |
| | Hi, First I wish to say that I have tried my best to think, but I still coudn't think "out of box". I want to perform a SQL statement base on the condition below: 1.) Table A consists of employee data (Emp_Id, Email, Sex, Address, race and nationality) We have …  |
 | I have made a login form in C#.net windows application i am facing a problem during connecting it to the database SQL Server 2005 it is sending [B]error 25[/B] it will be helpful for me if somebody solve this problem if will be better if somebody send me coding also |
| | can any body plz tell me how to access data from sql server 2005, i have created sql database table , but i dont know how to connect, and how to get date in to a text box ,i m using asp.net with C# , and i want to know …  |
| | Can anybody recommend good online courses for SQL and/or data controls? (I guess I should master the regular data controls before going on to Silverlight, right?)  |
| | [B]Hi all, I'm newB in C# and kind of lost now since couldn't find the right/suitable references. Please correct me if I'm wrong...[/B] My application will store values into database once user run it. In the Form Application, it runs well(no doubt). Now with the same approach, i want it … |
| | Hi, In the page I'm developing, I have a CheckBoxList which is populated based on what the user types in a TextBox (Similar to an AutoSuggest). The CheckBoxList is inside an UpdatePanel. When anything is typed, I'm settting the focus to the end of the word, otherwise the focus goes … |
| | I am trying to populate a label using a T-Sql query to a SQL Server table upon a click event. I have the click event and linking to the SQL Server table working just fine. The process (below) returns "System.Windows.Forms.BindingSource" rather than any value from the table. My code is … |
| | Hi Experts, I already have a database set up in SQL Server that I have used with vb.net in the past, and would like to use it with JSP. I just started JSP last week, and have no idea what I'm doing. I downloaded the sqljdbc driver from Microsoft's website …  |
| | I have a table with 2 fields category_ID Category_name 1 india 2 china 3 japan 4 africa 5 france I bind these data into grid in aspx page and in that i have given delete command and when i perform delete operation and if i delete china and japan i … |
 | Hi i have a table which i was using with a datagrid using hyperlink to maintain a simple menu to browse a internal site. but now i decided to create a horizontal menu with the Menu Component of asp.net, i know there is a different way how to do this, … |
| | Hi i am wondering if anyone has a solution for sorting by postcode area. I wanted to be able to pick off either the First letter or first two letters and group by this. I have figured out how to group by the first to characters of the postcode using … |
| | Hi all :) Does anyone have or know of any examples of how to store and upload .pdf files through a c#/asp.net web application? Thanks :) |
 | Hello everyone. This is quite possibly not the place for this but it is more to do with SQL than the other things included so I apologise if I am wrong. I am looking for some help on a task I have been set. When I say help, what I … |
| | I installed Visual Studio 2008 but when I creates any database it gives me error that" SQL server don't allow remote connection" & if i uninstalled only SQL Server & it'r related packeges like VSS Writer, setup support files etc. & I agian installed fresh copy of SQL server then … |
| | Is there a way to upgrade SQL Server Express 2008 basic to Advanced Series without having to reinstall the whole thing? |
| | Hello! I'd like to run mssql script (file with extension sql). I installed Microsoft SQL Server 2008 and run in Command Prompt: C:\Documents and Settings\useruser>osql -Usa -Ppassword -i "F:\Data\MyApplication\Scripts\CreateDb.sql" [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQL Server Native Client 10.0]Login … |
| | hello every one, i m trying to insert data from jsp page to database using sql insert query. every thing is working fine but when i m using autonumber in database(Ms Access) it is showing error. so please help me how to do it??/ |
| | I used the GridView1_RowDeleting Event to delete from the gridview . [code] use sonia select * from Info1 drop table Info1 create table Info1(UID integer,FirstName Varchar(100),LastName varchar(100),EMail varchar(100),Address varchar(100),PhoneNo varchar(100)) Insert into Info1 values(1,'Sonia','Sardana','a@yahoo.com','FBD','2222') Insert into Info1 values(2,'Shouvik','Choudhary','b@yahoo.com','KolKatta','9848484474743') Insert into Info1 values(3,'A','Ad','ds@yahoo.com','qqwD','9444212270') [/code] Suppose I delete record that has UID … |
The End.