6,934 Topics
 | |
 | hello, i have a application, with sql database, now i want to backup every week, so i have code a but it gives error: "The process cannot access the file 'C:\Users\yogeishh\Desktop\Restaurant-Stock-Management-System\Restaurant-Stock-Management-System\DataBase\RestaurantStockDataBase.mdf' because it is being used by another process." can anybuddy solve this error?? my code is :: " Private …  |
| | -1 down vote favorite I have done this condition to control if the elements of the row of the slq table are equal with the elements of the row of mysql table after this if the condition is true I have to overwrite the elements of the mysql table. Please … |
| | I am tring to recreate my oracle database -> sql server 2008. I never used sql server before, so I am using sql server management studio. I could create tables and views. The views I created using sql server management studio GUI has data in it. Now, I tried to … |
 | Hi - I am a pretty remedial visual studio express user. I recently understood how to do cascading comboboxes using the binding sources of the related tables, eg tbl 1 Make, Table 2 model, so as eg only ford models displayed in cbo2 if Ford selected in cbo1 - thanks … |
 | Hello every one. I am stuck in a place. I am entring medicine record in a table. That's most possible that medicine may exceeds from the rows i am providing. I would like to be assist how can i add new new with a hyperlink text. Also how this row … |
 | Hey guys, i found this tutorial online that involved searching your database for an existing value. I have changed the code around so it fits with my system but when i run it the input displays but once i press ok the input box closes and nothin else happens. Heres … |
| | Greetings, I have a table which contains product information called Products contains fields: ProductID, ProductName, and another table called UnitsInStores contains fields: StoreID, ProductID, UnitsNumber, UnitPrice My first question is: Is it better design to put the UnitPrice field within the Products table or to put it within UnitsInStores table … |
 | Group, I've been working for several hours trying to correctly write to a database file. Here are the parameters: Database Name: DATADESIGNSOLUTIONS Table Name: PRINTERMAINT Column Names: PrinterID (primary Key), PrinterName, PrinterNumber, PrinterLocation, PrinterAddress I've been working at this two ways: through the Visual Basic code and through SQL Server … |
 | So I've been thinking about SQL security lately and wanted to see what others are doing. I have been using integrated security (window's authentication), stored procecedures when necessary and have done my best to limit access to tables and those stored procedures with SQL server in conjunction with my application. … |
| | Well i am having an interesting thing to discuss with you all people. i am having table in database where one column is having xml data with certain fields. I want to fetch those field using select query. So tell me if you can suggest something to me. Thanks a … |
 | [url="http://../tutorials/tutorial6028.html"]Original thread [/url]- To see why this was Updated [i] Reason for new thread is to start with a clean slate and I will also be providing a tutorial for SQL and possibly Oracle DB connections to show how easy this code is to implement regardless of the DB you … |
 | I'm trying to find the errors in this sql statement INSERT INTO images(user, server, img-name, download, download-url, image-loc) VALUES(test@test.com, 3, Penguins.jpg, no, GaNfT, 69Z8PwE0uJLfRNDijPenguins.jpg) I also have an auto increment column but as I understand it you shoudln't supply a value It comes out with this error You have an … |
| | can anyone,plz send m the code for retreiving & updating images onto the sql-server using vb.net...ASAP... regards, preetham......  |
| | Hey guys, I was wondering if you could tell me if this is even possible or if it can be done another way??? So i have a database with 6 tables all the databases have the same columns except for the tables name ahead of the generic headers pub_name, Hotel_name, …  |
 | $sql="select *, (select Faculty from userinfo where Faculty=$college) as category from award where HonoringYear=$year"; $rs=mysql_query($sql); return $rs; |
 | Hey everyone! I have a members.php page/file in which i want logged in users to see the other users registered in the database. I'm not exactly quite sure how to do this and I'm struggling quite a while now with this so your help will be VERY much appreciated. I … |
 | i was thinking of downloading some database software that would help me learn sql. so far i have only *read* sql , ie havent done any practical sort of thing. i made a post earlier in this forum , where i was told that sql server express will be a … |
| | I have a calendar/scheduler that I am coding and I want people to be able to search for the next available date via a few options. One of those options is to only search those dates that are "Monday" for example. I have the following SQL command to retrieve data …  |
 | Good day, I am having troulbe with my computation here. i want to compute for the Custom_Haulage_In_Transit but when i exec my sp the value of the Custom_Haulage_In_Transit is 0. can anyone help me with this please.. here is my code SELECT distinct MATERIAL ,Description ,Material_Type -- ,Requested_Delivery_Date ,ATP_check ,Delivering_Plant …  |
| | Group, In reviewing the data in one of my SQL Server tables, I noticed that my nchar or nvarchar fields have additional spaces added to the end of the record. Is there a way to stop this? Should I be using a different data type? In advance, thanks for your …  |
 | Hi All, I've tried the following to format my date in 'dd/mm/yyyy' instead of 'dd/mm/yyy hh:mm:ss' when importing data from csv to DataSet. CONVERT(VARCHAR(10), [dateColumnName], 103) AS [DD/MM/YYYY] and CONVERT(DATETIME, [dateColumnName], 101) AS [DD/MM/YYYY] Both give me the error: Undefined function 'CONVERT' in expression What would be the correct method … |
 | Hello, I have a question and I thank everyone for helping me in advance. I am using Visual Studio 2010, ASP.NET and C#. I have a table in SQL server DB. Server page (news.aspx.cs) is collecting all the data from the table (`select * from news`). Using `container.Controls.Add(new LiteralControl(news.ToString()));` I … |
| | Hello everyone, I hope someone can explain something to me. Im a Junior Developer with very limited knowledge in VB.net, but I am self teaching. I will soon have projects to do whilst at work, and although my coding is pretty ok now, one thing eludes me, and I cant …  |
| | Hello I have databse in MySQL with 21 fields which are listed below Field Name Data Type NULL status text No roll_no text No branch_id int(5) No student_name text No father_name text No phone1 text No phone2 text No email text No dob date No city text No course_id varchar(5) … |
| | Hi all, I'm trying to bring up a table of data using a select query to create a DataSet that I'm displaying in a datagrid. When I use SELECT * FROM myTable it works fine, but when I only want the specific columns SELECT URN, 'CanX Reason', 'Date to take … |
| | Hi to all, I want to install SQL SERVER 2008 on my XP 32-bit OS. After clicking on "New SQL Server stand-alone installation or add features to an existing " link unser installation tab, Setup Support Rules window shows success status of all rules except "Restart Computer". It neither directly … |
| | I have an HTML page that makes a query to SQL database when clicking on button "OTSI". My problem is that after populating the table with the data, I cant sort it anymore. I am using a standard tablesorter library ([TableSorter](http://tablesorter.com/docs/)). Here is the page making the query: [page with … |
| | Group, I'm thinking I may want to use the Date data type in SQL Server. However I'm still very unclear how to read, write and compare using this kind of data type. I realize this has a time component which is of no importance right now (it will be later … |
| | Hello everyone, I was wondering if anyone could tell me how to connect and query sql databases in c#. Thanks in advance  |
| | Group, I'm having an issue with SQL Server that has me baffled. I need help. When I originally loaded SQL Server 2008 Express and created my database, I called it "DataDesignSolutions". The tables were created through VB Studio 2010 Express. It's path was "C:\User\Don\Documents\DataDesignSolutions.mdf". I'm not sure how, but somewhere … |
| | I am trying to implement a Login validation using C# 2005 in ASP.net 2.0 web application. The SQL Server database contains a table named "UserList" with columns LoginId, Password and Role. The Login webform should authenticate the LoginId and password and depending upon the Role assigned to that user/visitor should … |
| | Hello, I'm tring to develop a mysql news scroller for my website. The problem that i'm facing is that i need to have multiple mysql querys joing together beceuase i have multple categories like: select * from news where category LIKE '$cat1' order by id desc limit 1 select * … |
| | How to know which version 1.Microsoft SQL Server 2008.(Express) 2.Microsoft SQL Server 2012.(Express) Both installed on my machine,am I running(using)? |
| | Good day, I am having trouble with my condition, i dont know where should i put where in my query here is my code.. SELECT distinct MATERIAL ,Description ,Material_Type -- ,Requested_Delivery_Date ,ATP_check ,Delivering_Plant ,Order_Quantity ,Held_by_Finance ,Rejected_OOS ,Rejected_Others ,ISNULL(Open_Order_Quantity,0) AS Open_Order_Quantity ,ISNULL(Order_Quantity_NKA,0)as Order_Quantity_NKA ,ISNULL(Order_Quantity_RKA,0) AS Order_Quantity_RKA ,ISNULL(Order_Quantity_Others,0) AS Order_Quantity_Others ,ISNULL(Stock,0) AS … |
| | hi guys, how are you all? well, i am participating in the google's science fair and my question is: how can we make social networks student friendly? and my aim is to make a social network that can be student friendly and also as professional as other social networks in … |
 | Hi, I would like to know how to find duplicate records based on exact match on some columns and slight difference on others... for example, I have a table with the following fields 1. Name nvarchar(50) 2. City nvarchar(50) 3. State nvarchar(50) 4. Age int(10) Now, I wish to search …  |
| | Basically my table Itinerary table where a record can have a parent record. so table cound have ID Parent ID which can be any ID from The same table. Other details Parent ID can be null if the record doesn't have child. and if i delete the parent record of …  |
| | I have this code Dim con = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Danial\documents\visual studio 2010\Projects\ESI_PF_Payroll_V1\ESI_PF_Payroll_V1\Pay.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True") con.Open() cmd.CommandText = "SELECT Firstname,Lastname FROM Employee where Firstname = @Firstname and Lastname = @Lastname" cmd.Parameters.Add(New SqlParameter("@Firstname", TextBox1.Text)) .Value = TextBox1.Text cmd.Parameters.Add(New SqlParameter("@Lastname", Lname_txt.Text)) .Value = Lname_txt.Text dr = cmd.ExecuteReader While dr.Read Label4.Text = dr(0) … |
 | select top 2 for a single column,,others with all data in sql  |
| | Good day, I am having a probem with my sql. I want to create a formula for my pivot field.. here is my code... SELECT * FROM ( SELECT REPORT.MATERIAL ,REPORT.Description ,REPORT.Material_Type ,REPORT.ATP_check ,REPORT.Delivering_Plant ,REPORT.Order_Quantity ,REPORT.Held_by_Finance ,REPORT.Rejected_OOS ,REPORT.Rejected_Others ,REPORT.Open_Order_Quantity ,REPORT.Order_Quantity_NKA ,REPORT.Order_Quantity_RKA ,REPORT.Order_Quantity_Others ,REPORT.Stock ,REPORT.DSD_Delivery ,REPORT.OUtBound_Haulage ,REPORT.Total_OutBound_items ,REPORT.InBound_Haulage ,REPORT.Haulage_In_Transit ,REPORT.Process_Order ,REPORT.Total_Inbound_Items … |
| | I have sql database with table Images, in that table there are 2 Columns ID (identity), DisplayImage (image). Table has 2 rows for first row i have written insert into Image values(1,'Libraries\Pictures\Lotus.jpg') and 2nd row as INSERT INTO [dbo].[Image] ([Id],Images) SELECT 2, (select * FROM OPENROWSET(BULK 'C:\Users\Public\Pictures\Sample Pictures\Tulips.jpg', SINGLE_BLOB) AS … |
 | i figured out the problem it is that Hash function generates different hash each time for same value i.e 12345 and thats why it doesn't match during login with the one that i submitted during signup. so is there any way to make the hash stable for same value e.g. …  |
| | Visual Web Developer 2010 how to save textbox to SQL VB.net I am new to Visual Web Developer Express I connected the SQL Created a webpage and simply added 2 textbox(s) a gridview (works) Submit button When trying the app the Submit button, The page resets, it appears to work … |
 | Hi All I am upgrading a SQL 7 database to SQL2008 R2 and just cannot undestand why 2008 has a problem with the code for this view (my experience with SQL 2008R2 is limited): SELECT dbo.tbl_orgbusinessunits.BusAreaCode, dbo.tbl_orgbusinessunits.Region, dbo.tbl_orgbusinessunits.CompanyCode, dbo.tbl_orgbusinessunits.BusAreaCode & ' ' & dbo.tbl_orgbusinessunits.BusinessAreaName AS Branch, dbo.tbl_orgcompanies.CompanyCode & ' ' … |
 | Hello there, I recently faced problem with my website www.zomedia.in. I am using sql server 2005 and asp.net 4.0 with c#. My database tables are automatically filled with some unknown html css junk codes such as (</title><style>.apyk{position:absolute;clip:rect(438px,auto,auto,438px);}</style><div c) (check http://zomedia.in/ZomediaSongs/ZomediaMp3.aspx and you can see the gridview with junk data in … |
| | I have a trigger on insert CREATE TRIGGER [dbo].[InsertNewCustomersAsGroupMembers] ON [CustomerBase].[dbo].[Cutomers] AFTER INSERT AS BEGIN SET NOCOUNT ON; -- Insert statements for trigger here DECLARE @inserterdCustomerID uniqueidentifier UPDATE [CustomerBase].[dbo].[GroupMembers] ?---? END GO I want to get the values of the inserted record at [CustomerBase].[dbo].[customers] into the trigger inorder to update … |
| | Hi all I have multiple checkboxes to be used as the status of a certain order. another words as the order is being processed the user will check the status and a date will be inserted into an access table. Now my isue is when a checkbox is checked for … |
| | My page have textbox , lable and one button when the user click the button it should display message if the user in the database "email has been sent" the message will show otherwiser it will show "email is not in the system" this is what I did , but … |
| | I just couldnt find a soluation for this. How to insert a one record inside one forum with muliple sql tables in one php page? Here is my code i have two insert button, i only need one for the both form <?php require_once('Connections/Omar.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function … |
| | Group, I've read through the tutorial regarding Listviews and SQL's (http://www.daniweb.com/software-development/vbnet/code/445801/avoiding-sql-injection-attacks). Thanks for the article. It was very imformative. So I thought I might try this with the project I'm doing. I really like how these listview look and what they can do. But I realize I need to know … |
The End.