9,022 Topics
For the system I am creating which is a report generator, there is a form which is created based on the parameters required for a stored procedure, the code for this is: for (int i = 0; i < datatable.Rows.Count; i++) { string label = datatable.Rows[i]["label"].ToString(); Label mylabel = new …
Hi, I have a filestream enabled DB and a table to store the files. Until now i used to get the path of the file that has to be saved to DB. But due to some changes this was changed and now i get a byte array. my question here …
For the system I am creating there are various reports, some of which require input parameters from the user. I have my system working for reports thay require no parameters but can't seem to figure this out. One member of the team has written stored procedures, one being report lookup …
What is difference between MySQl & MSSQL database storage limitation. More descriptively, If I make databases using the above-mentioned database systems. How much data I can store in each of them, i.e. 1GB, 2GB, 10GB, 100Gb. What is the limitation?
I wrote a program in early 2010 that ran a command line function that pulled data from SQL Server 2005. The program worked at the time, but does not seem to work now (for various reasons, it was not used for about a 1 year). BCP "EXEC emdb..Patch2" QUERYOUT D:\shares\patch2.txt …
Hi guys I have problem i need to make ERD relation entity between employee and allowance Employee table Name address Basic Salary Bonus Allowance table House rent Food Allowance Moving Allowance Basic Salary is monthly and fixed Bonus is monthly and fixed food allowance is monthly and fixed for married …
Hi, I'm developing VB6.0 Project using SqlServer2008. After completing the project if i'm using MsAccess the .mdb file will be stored in Package but when i'm using SqlServer Which file shouli use or how can i use sqlserver for using in other system which are not installed SQLServer2008
Hi, I have a project I am currently working on that generates reports for users. At the minute the reports appear in a menu and when selected it directs the user to a page for that report. However I have been asked to change it to allow flexibility. So now …
Hi, I originally created this query to get a result from a single select statement Its funny that it became a very long query having sets of joined table Its also maybe annoying to look for it so im trying to trim it down most of it have same joined …
Please tell me the code for how to display record in datagridview based on combobox selected item. I have a table named table1 in sql server database.and columns are name,id,group,grade,year.when i seleted one name from my table then the remaining fields information(ie only that record)have to dispaly in datagridview by …
Hi 01 - i have create an sql function in my database that take to Date params with code: CREATE FUNCTION [dbo].[SelectEmployee](@frm_date DATE, @to_date DATE) RETURNS TABLE AS RETURN SELECT Emplo_ID, Emplo_Name, Work_Date FROM Employee_Data WHERE Work_Date BETWEEN @frm_date AND @to_date GO 02 - after that add it to project …
Hi insert command works update does not do anything any help Please SqlTimes.InsertCommand = "insert into athletedata([Athlete],[Mydate],[session],[mytime]) values ('" & athletename & "','" & storedate & "','" & todaysession1 & "','" & savetim1 & "') " SqlTimes.Insert() SqlTimes.UpdateCommand = "UPDATE Members SET [Agegrade]=('" & savetim1 & "'where [Fullname]='" & athletename …
basically i m creating vb.net window application which can show the result in rdlc report... at the back end it is SQL server 2008. Is there any easy way to fill RDLC tablix based on row and column grouping. The situation is as follows. I have a table in SQL …
I have a gridview that is being populated from a dataset which is a table returned from a stored procedure. However now the stored procedure has changed and it returns 2 tables, the first returns the column headers as well as labels and other info, the second is the table …
I am trying to get my database data in particular variable. my database handling class and i am trying to store data in currunt form class var list = x.Rows(); if (list.Count != 0) { Object[] ar = new Object[4]; //Object[] ar = list[0]; list.CopyTo(ar, 0); var quntity1 = (int) …
Hello I have a project where I have 2 textboxes called "Name program" and "Error" where I have to write data in, Once I have wrote the data I have to import these 2 textboxes into an SQL database so it has to show like this in the database: Name …
Hi, I have a ksh script that will actually read a config file, run a SQL statement against database,store the output in temp, convert them to HTML format and that sends a user an html-formatted email. Usually once per email, there is an exclamation point popping up in the middle …
Good day! I just need a little help regarding my query..I need to get the opening balance by subtructing debit and credit column where date is less than fromdate(datepicker). But sometimes if the fromdate is a date without transaction, it still displays opening balance? I cant figure out whats the …
Hi, I run into an interesting thing. I'm looking into SQL a bit, and was reading some tutorial on W3C, so I built a small application to play with SQL queries: inserting info in a table and then retrieve it as it is, filter it etc. The table contains 5 …
I must admit I feel a little embarrassed to post this, but I don't seem to get this simple flipping application to work and I'm getting this error: Login failed for user ''. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack …
Hi guys, I'm in a bit of a situation here and I was wondering if anybody has any suggestion. Basically, I need to retrieve some data from 2 or perhaps 1 SQL table (that's what I'd like you to help me finding out). OK, here are my two tables (sure …
Hi Guys, Im a bit puzzled on the best way to store data which will later be saved to a csv. I am doing a record search on a database table which will get cycle through each employee and get the relevent information. Once I have done this I will …
Hello ! I'm using VB.net 2013 , Entity Framework 6 , SQL server 2008R2 and SMO. I have the application that use the database. But sometime I make changes to database structure , and I want to add to my application a "Refresh Database" command. Let's say that I have …
Ok so i have been trying and trying to solve this issue, but to no avail. Therefore, i am posting here. Please note that i am a self learner and don't really know things in depth, just trying to learn.. So please be gentle. Here is my aspx code: <div …
Hi, I have some experience in c# and would like to get more experience of C# with sql, because alot of jobs look for databases. Can anyone me recommend any good books or online tutorials for begineers. Thanks alot,
please help i am confused plz plz plz [CODE] using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class handler : System.Web.UI.Page { protected void Page_Load(object sender, System.EventArgs e) { if …
Hello... Can anybody explain me Ebay or something like that database structur.Do All Item Categoris Store in One Table(with Differnt types)or do they story in many table .ex books for one table,jewellery in another table and so on.if they are store in differnt tables how do we search them ? …
Hi, I have a stored procedure that I have to send one parameter to. I then have to use the same stored procedure to display results, I'm not sure how to do this. Basically the system should allow the user to select an item, push a button (which is when …
hi, how can i add data to a datagridcombo box column from a mdf file, i want to take the first name of all employees and display in the datagrid view combo box column: is the code below correct , please can u tell me what should i do to …
I have heard that table security for data stored in the table can be made by storing Hashbyte data in a column. So anyone comes and change values manually in a table will be identified and that record be ommited for further calculation Need help on these areas CREATE TABLE …
Hi, trying to get the username of the user logged into a computer but it doesn't appear to be working. I was using `Label1.Text = User.Identity.Name;` to check if it did work but it wasn't displaying anything. The only reason I need the username is to send it through to …
Hi Guys, I managed to fill the jtable with the table from the database. Now I want to add specific rows from the database table into the jtable. So I have a textfield and a sql statement: So "Select * from tbl where name =?" I want to add all …
hi, I'm using Windows7, My laptop is better in speed and working process when i install sql server2008 my system becomes very slow how can i recover this problem i need my system should be faster and also i need sql server,,. Please help me Thanks in advance
I am trying to look on the web for a way to create a stored procedure that I can run and then put in multile values and this is the closest I can find: CREATE TYPE dbo.EmployeeList AS TABLE ( EmployeeID INT ); GO CREATE PROCEDURE dbo.DoSomethingWithEmployees @List AS dbo.EmployeeList …
I have a problem with an application. The application have a Form contains a data grid view for displaying items data. There is a column within the data grid view of custom control type when pressing F3 on such column it shows another Form for searching the items. The other …
I have the following table: Region IdDescription IdUser Metropolitan Right 5 Metropolitan Left 6 Metropolitan Right 5 Metropolitan Left 6 Country Town Right 5 Country Town Left 6 Country Town Right 5 Country Town Left 6 Metropolitan Right 7 Country Town Left 8 And I want to query the kinds …
Hello, I'm building an expenses application in asp.net and I'm attempting to insert some data in a SQL database in visul studio but I get the following error (screenshot here http://s13.postimg.org/4kjmn4nev/SQL_error.jpg): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_expenses_ToexpenseCode". The conflict occurred in database "Applications", table "dbo.expenseCode", column …
I'm looking for a user login (or identity) tutorial/example on MVC5 that uses an existing SQL Server database and user table, so NOT code first, and NOT using Entity. Can't see the forest through the trees apparently, because I cannot seem to find one.
In my Windows Forms c# project I try to connect to an already existing ms sql database file (added binding Source on the form, then : bindingSource -> properties -> DataSource -> add source - > .... ) but when I pick this file it writes something like "You dont …
please help me to do Saving Gridview and Non Gridview data to Sql Database
hi everyone, how can i retrieve the data from sql serve2008 and put it in array using vb.net2010. Can anyone help me with this?
I am new to vs2012.I am trying to run MVC3 tutorial to experience the working of vs2012. I have ran thesame tutorial on vs2010 successfully and inserted new record. Now I want to run thesame tutorial on vs2012. On both cases, i am using sqlserver management studio and entity framework(dotnet …
I have the following table User in my database Name(Varchar) DateOfBirth(datetime) Age(int) Name(Varchar) | DateOfBirth(datetime) | Age(int) John | 2014-12-20 23:59:59 | 0 Mary | 2014-12-20 23:59:59 | 1 How can i verify throught javascript if the field DateOfBirth of the table User of the database z is of type …
hi all, I've got something odd going on here. Basically I created a database table in visual studio 2012, using localDB and saved it OK. Now, I'm trying to amend something in it and when I right click on the table (Overtime) to "Open table definition", it loads for about …
Trying to update Packet.MSGState to P where if not R or D and it is Y in table Packet.MSGState SQL is MS-Access var ODBC from c# This is not undating all correct. UPDATE Packet SET Packet.MSGState = 'P' Where (MSGState <> 'R' and MSGState <> 'D') and Exists (Select MSGTO.Selected …
Hi, I'm creating an Events calendar whereby i store event data in an sql database. How do I make it so that when I click on a date in the calendar, it'll display the events details happening on that day in a GridView? I've researched for super long but I …
hello guys ,i need some help i have 2 tables in msql server 2008. table InList:ItemId,Description,Qtyin.... table OutList:ItemId,description,QtyOut... Now,i need to make a query to give me the available Qty of each item The available Qty is the (Sum of Qtyin) - (Sum of QtyOut) i need the query asap,any …
i hv 3 different user,user selection is based on radiobuttonlist and then login button,but im having error that "use of unassigned local variable 'sql'.I couldnt figure out the mistake.do help me :) protected void btn_Login_Click(object sender, EventArgs e) { string sql; if (btn_user.SelectedItem.Text == "Admin") { sql = "Select * …
Hi guys, I hope this is the right section to post. I need to develop an application in visual studio 2012 that uses SQL (please bear with me as I'm not very well versed in databases and SQL and therefore I don't know what SQL visual studio uses), and when …
I have the following query that list all chemicals(chemical tbl) and its consumption(receipt tbl). However if the chemical codes are not in receipt tbl, it does not show the chemical name. It should display the name and put the consumption as zero. My codes below: SELECT Chemical.ChemicalCode, Chemical.ChemicalName, GroupDetails.GroupName, Chemical.LastRate, …
The End.