9,022 Topics
i did creat vb.net code for .aspx files, now i am looking for sql database connection for my project. exapmle: databasename: demo1 table_name: State user id: sa Password: 123 default.aspx - <fieldset> <legend>Table :</legend> <div class="Row"> <div class="textleft">Country Name :</div> <div class="textmid1"> <asp:TextBox ID="TextBox1" runat="server" BorderStyle="Solid" BorderWidth="1" BorderColor="#009933" Height="18px" Width="250px"></asp:TextBox> …
I try to make a query and it works well, but when i put it in a stored procedure.I can't figure out whats wrong with my code. It says **Procedure or function has too many arguments specified** Stored procedure code ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- …
Hi Everyone, I'm trying to set values using checkbox control inside SelectCommand. For example: checked = open unchecked = close + open or any value The 'checked' seems to be working fine but having an issue to fix the 'unchecked' part. SelectCommand="SELECT * FROM [table1] WHERE CurrentStatus = case when …
Greetings, I have a database creation script. I've run the script after changed the path within the 'FILENAME' option to create the database on an external hard disk and I was able to see and select data from tables as the script run with no errors. However, when I tried …
Hello All; I usually do everything in SQL Server these days, however, I have an site that is just so small, that it is going to be using an Access database. This is the code that I am using to generate the Google Sitemap with, however, there is code here …
Hello! There is another problem which I am facing in JDBC, is Insert statement. I am giving code of my program and explaining my problem . I am using ms access and netbeans 8.1 package database2; import java.sql.*; public class Database2 { public static void main(String[] args) { try { …
Warning: mysqli_query() expects parameter 2 to be string, object given in E:\xampp\htdocs\cadastro\cadastrar.php on line 46 Alguem pode me ajudar? <!DOCTYPE html> <html> <head> <meta charset="UTF-8" /> <title>Cadastrar</title> </head> <body> <?php include "config.php"; $nome = isset( $_POST['nome'] ) ? $_POST['nome'] : 'valor_padrao'; $sobrenome = isset( $_POST['sobrenome'] ) ? $_POST['sobrenome'] : 'valor_padrao'; …
Hi, i am working on a database application in java and converting it from console to GUI, to do so i am using ucanacces driver and connecting it to my access database and creating queries using sql(NOT ALLOWED TO USE ANY OTHER METHOD) and want to perform the basic database …
Hi all, Just wanted to start a discussion on a database issue that I am presented with; the issue is that I am trying to insert seed data into around 90 tables without having to worry about manipulating/disabling the foreign key constraints. The most logical solution would be to do …
i need to get record based on maximum created date any body help me date in mysql database structure is varchar. date is 150921141206 any body help me
I'm not looking for others to do my homework, I just want help with getting an idea one what to do. My class was given an assignment and one of the questions is: Create a query that will show the order id, item id, price, sales tax and subtotal for …
I am very new to powershell and I am attempting to import multiple csv files into a SQL database. I have it working if I specify the file but I want to have it import multiple files from a specific folder. The way it's working right now, it will import …
I m new to the MS Access, I m prone to the SQL Server Only. Can u plz explain the difference b/w[B][COLOR="Red"] Datasheet View & Design View[/COLOR][/B]. I have some idea,pls check it whether me right pr wrong. In design view,we have to specify by own datatypes & column names. …
How To connet mssql to php please please please help meeee. I'll wait for you guys to answer
I need some help writing a sql query. I have below 2 queries and I want to combine them together. Now I already tried union but it doesn't work. I first want to print all result of query1 than I want to print all results for query2. Ex: --Query#1 results: …
I am writing a custom MembershipProvider for ASP.NET and would like to record certain events in a table when they happen. I have the methods to do it, but I would like to get the value of the "ID" column of the row I insert into the table. I have …
Hi all! I have a simple procedure which should return an 'id' field if parameter is passed. The problem is that if I provide the single letter parameter it returns no records although there are matches. But if i provide the whole word as it's written in a table, I …
Hi guys, am trying to populate textboxes with data from sql server database. below is the code I am trying to use in Visual studio 2012, Vb.net. Private Sub btnSave_Click(sender As Object, e As EventArgs) Handles btnSearch.Click Dim query As String Dim MyConnection As SqlConnection = New SqlConnection("Initial Catalog=PayRoll;" & …
Write a select statement that will display student id, student last name and the number of courses a student has been enrolled. You will need to join two table, use a COUNT aggregate and a GROUP BY clause in your SELECT statement. That is the question. I've written the following …
Hi Pls advice me the following calculation in stored Procedure my scenario is packing the magazine Example: Order = 6042 copies. 6042 have to be packed by 20 each. so 302 bundle. balance 2 copies. If I divide 6042 /20 Result is 302.10 . How can store 302 and 2 …
I need help about this, I've been working for this a quiet while... I want to log-in using one login form for both admin and normal user but after log in, some of its form and/or buttons in the form should not be available for normal users. here is my …
Hi to all! I have to install sql server first time. But I have a confusion that what is difference between sql server and sql server management studio? secondly is sql server management studio embeded in sql server or will it installed separately? If it will installed separartely then which …
Hi this is my code for computing the payment of my system, But there have a problem in my codes ? Because, there have something wrong my codes, i try to fix the error but i can't, this is the error " Conversation from type 'DBNul' to type 'Integer' is …
I'm updating my database using this code. only id and attendance date is updated but the time(AM_TIME_IN etc...) is not updating. What could be wrong? I'm using access and time(AM_TIME_IN etc...) datatype is shorttext Dim a As String = Now.ToShortTimeString If a.Contains("AM") Then a = "AM" Else a = "PM" …
Hi, I have try to insert edit and delete feature in my gridview app. however, the code is not really work. when I click the edit or delete button it keep adding the blank line. It supposed show textbox with data and Update Cancel link button, when I click the …
My c++ program using visual studio 2012 has one error that i cant figure out what. The error says " 1 IntelliSense: expected a ';' " I do believe that the eror from my program is after this part: cout<<"\n @@@@@@@@@@@@@@@@@@@@@@"; cout<<"\n @@@@ @@@@"; cout<<"\n @@@@ @@"; cout<<"\n @@@@"; cout<<"\n …
Hi, using sql server 2012 as backend and coldfusion 11 as front end for development.Nowadays, weird scenario happening that the application is not working at some times. But there is no trace of any error in the coldfusion application logs or in the sql server part. The site start working …
HI I am a part of database testing team. I have imported a tables.csv file which contains two fields 1. table name- all the tables of a database 2. Primary column- primary column name of the respective tables. I am trying to write a sql query for getting the table …
My current connection and echo code is as follwed: <?php $myServer = "Server_Name"; $myUser = "User"; $myPass = "Pass"; $myDB = "DB_Name"; //connection to the database $dbhandle = sqlsrv_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer"); //select a database to work with $selected = mssql_select_db($myDB, $dbhandle) or …
I need some help with creating a simple search engine for website. Basic idea is that user will enter a string in search bar, which will compare in database key_word and get the reuslts. Lets say I have the following table on sql server database. |----|----------|----------------------| | ID | URL …
Hi All, I have a problem when trying to change user account password in my project I am using Visual Studio 2013 and SQL Server 2012. This is the code I am using and I don't know to how to adjust it to check for the old password before changing …
Hi EveryOne, I have a following controls in my vb.net form: txtID txtName btnAddNew btnSave This form will be storing a values to the SQL Database (SQL Server 2005). In the txtID textbox the auto id should be generated when ever user clicks on btnAddNew. The ID should be generated …
Hi, I am trying to open some dbf files and two of the three I am trying to open does so just fine, but the third one gives this error: "The Microsoft jet database engine could not find the object 'NewStructures'. Make sure the object exists and that you spell …
i now can save a fingerprint template from database using this code.. Dim fingerprintData As MemoryStream = New MemoryStream Template.Serialize(fingerprintData) fingerprintData.Position = 0 Dim br As BinaryReader = New BinaryReader(fingerprintData) Dim bytes() As Byte = br.ReadBytes(CType(fingerprintData.Length, Int32)) Dim cmd As SqlCommand = New SqlCommand("INSERT INTO fininger_table VALUES(@FIRSTNAME, @LASTNAME, @FINGERPRINT)", conn) …
Good afternoon fine DaniWeb folks! I am about to pull my hair out on this one and I'd like to know if someone knows of a simple or obvious "gotcha!" for this problem. I've got a form with some detail fields on it (below)  When a user attempts …
Dear sir, I have basic knowledge of VB .net I want to sum records (integer) of a column in a table if I give a specific value (text) in a field. Dim ds As New DataSet Dim AccessConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=p:\inquiries.mdb;") Dim sql As String = "Select SUM(orders_amount) FROM …
Hello to all! I am facing problems in feartures of sql sever 2008. I installed it but i could not find management studio in it. then i installed managemenet studio2008 separately. but when i opened management studio then there was no interface for making database but only interface was for …
I want to show the total qty of these query (total qty from datagridview where ActualQty value will update the values of Used Column) `SELECT COUNT(Software) AS ActualQty FROM tblswlogs WHERE Software='MS EXCEL'` and (**Total** will appear in textbox) `SELECT MAX(used + initialqty) As Total FROM tblswlist WHERE Software = …
Hi.. I have a big problem, hope that you can help... I have windows 2003 server with CA brightstor 11.0 (Build 2670) and is making backup to all my SQL Servers. so I need to restore a database where the MDF file is 4 GB and the LDF file 111 …
Hi, I select S.No, name and mark from sql database table. This table contain n number of rows. I want to add(+)/Plus the mark and display in the (n+1) row of datagridview how can i do this. Thank You
Can someone please help to advise below question? I need to do a SUM of the amount column based on the CreateDate date range From 10th of previous month to 10th of this month Below is the database table Amount CreateDate 151.00 5 July 2015 567.50 19 July 2015 558.00 …
Hello all, I have an MS SQL table. There are two columns I need to work on: HOURS_DURATION and MINUTES_DURATION. They are of INT type. As you may see in the photo I am attaching: [TABLE SAMPLE IMAGE](http://prntscr.com/8gzg7c) Now, I am making a fast report. And for now I have …
Hi guys, I am trying to save the items in a listview to Access database. The listview has two columns; "Description and Price". For example, If a user adds three Items (products) in a listview and clicks a command button, I want these items to be saved in a database …
Hi all I'm new to s/w development as well as .NET .Plz provide me with guidelines for my project.The salient features are: 1.) It's an online live MCQ exam project using ASP.NET with sql connectivity. 2.) we want it to be able to test 50-60 students simultaneously providing on the …
I am writing SSIS packages and at one point I have to check a date field. It may come in any format of the following but I need it to pass any valid date the faster the better of course. Always returns as a varchar Acceptable formats 'mddyyyy', 'mmddyyyy', 'mm/dd/yyyy', …
Hello my tables have a column type varchar(5) value = 10100 on a form I created five checkbox control corresponding to the value in column if the value =1 checkbox= true and vice versa, the value = 0 checkbox = false how I can upload the data forms correctly by …
i need samples on calculating average the average of "C Program=50" "Html5=70" "DreamWaver=70" "SQL Server=80"
Hi to all, I have always had this problem where: if I have a datagrid with records like RecID Name 2 Tom 5 Rich 6 Harry To Save I will loop through the rows using the sql IF NOT EXISTS(SELECT * FROM myTable WHERE RecID= dgv.rows(i).cells(0).value say) BEGIN INSERT the …
Hi everyone, I need help in selecting between date ranges. I have two dateTimepicker and want to retrieve only records selected between selected dateTimepicker.I tried but im getting all records. I'm using SQL server database. Here is my code: selectQuery = "SELECT * FROM EmployeeRegistration WHERE EmpJoinDate BETWEEN '" & …
I have a C# table that displays sql database. It has the Id,Name and Location as fields.When the program runs it shows the name place for both name and location. here is the code public static void AddPat(string id,string name, string location) { string insStmt = "INSERT INTO PATIENT (Id,Name,Loation) …
The End.