9,022 Topics
Hello everyone! I'm wondering if there is a way to assign the values of a column in SQL as the key name in a multidimensional array. Here is what I have, my database looks like this: Table Name = SJCFPCB date | totalin | cdulep | icu | ----------------------------------- 2011-01-27 …
Hey everyone! Im hoping to find someone that can help me with a problem that I cant seem to resolve and it's driving me crazy! Basically I am trying to create a child management system for a nurse using vb.net and SQL as my backend db The application consists of …
Hello, I'm new to vb.net. I have successfully run a simple sql query in vb.net and basically wanted to know how I can export the results from the query to a .txt file? All I really know is that I should be using StreamWriter. Does anyone have suggestions for sending, …
Hi everyOne... I am new to sql Server and installed Ms sql 2005. i want to use command prompt for queries But whenever i use the sqlcmd command my computer gets restarted... Why it is so???? can anyOne plz Help...
I have SQL Server 2008 Developer installed in my machine. The thing is that I have this database backup with version 10.50.1600, SQL Server Developer 2008 SP2 has version 10.00.4000. Well, I know there is not an easy workaround or conversion, so I thought well, what If I installed the …
I can't insert values into a table using a stored procedure because the fields are of data type MONEY. First, is the data type CURRENCY the same as data type MONEY? Right now, I am currently using the integer value of adCurrency for the data type parameter of the createparameter …
hi.. i'm using ssrs 2008 enterprice edition.. i want to send a report as email.. to my gmail address.. i want to schedule a report so that it can deliver daily to my gmail address.. how to send the report to my gmail address.. i dont know anything about smtp …
[code] cmd=new sqlcommand("insert_student",con) cmd.commandtype=commandType.StoredProcedure Add.Parameters.AddwithValue("@stuid",txtstuid.text) Add.Parameters.AddwithValue("@name",txtname.text) Add.Parameters.AddwithValue("@course",txtcourse.text) con.open() cmd.ExecuteNonQuery() [/code] i want to create method for executing procedure but how it possible... [code] Function ExecuteStoredProc(Proc as String) cmd=new sqlcommand(Proc,con) cmd.commandtype=commandType.StoredProcedure Add.Parameters.AddwithValue(????,?????) con.open() cmd.ExecuteNonQuery() end function [/code] how to call this function can anybody help me.........
Hello, I'm a newbie to VB.Net and I need an urgent help as I'm developing an application using the VB.Net. I have a form just like the login form in VB.Net. The usernames are prepopulated on a combobox with datas from the SQL DB backend, and the text box for …
I have a form set up and on that form is a DataGridView, on that DataGridView I would like to display all of a customer's transactions. I am having a problem where the debugger is throwing me a "Syntax error in JOIN operation." and I can't proceed. [CODE] ' Select …
I got a jsp page which forwards request of two textfields txtname and txtpass to a servlet and the servlet then inserts the data into sql db and the name of the db is online_store. The db has two columns. When i checked the values are passing to the servlet …
I am trying to run several stored procedures from my code and I get the error message that my sp's can't be found, but if I remove all of them but one, my code executes fine. I've tried this way to run my sp's: [code] Dim oCmd2 As System.Data.SqlClient.SqlCommand Dim …
Hi, I am getting an error while fetching the records from sql server to datagridview. Ex. I have 10 rows in datagridview first five are with one table and next five for another table. When loop goes for next table it throws an error like "timeout expired. the timeout period …
How can I create a report using 5 tables of SQL Server? I've got table master that stores the data. And others child tables, where i keep the data. In the child tables I have any data to the same data in masters. So, I want to select data by …
Hi there im making a PHP website for this game and the passwords it use are like this [CODE]0x7BF1EA5EBADD9D7DD2D43E25ABEBCD100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 which translates into "999momo999"[/CODE] any idea what sort of cryptography that might be? the pass itself is stored in a MSSQL DB and the column type is BINARY(60) thanks for any …
Hi there, I have a question in EncryptByPassPhrase. I am trying to encrypt the source column in the database table PForm. When I run the code it sasys, “Failed to convert parameter value from a String to a Byte[].” the SourcePath column in the database is varBinary(256) type. What is …
How to import an Excel file into SQL Server 2005.. anyone?
[ICODE]it won't show any error but after clicking the update it show the previous data again[/ICODE] [CODE]protected void gvdatatable_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { GridViewRow row = (GridViewRow)gvdatatablle.Rows[e.RowIndex]; Label lbl = (Label)row.FindControl("lblid"); TextBox txt1 = (TextBox)row.FindControl("txtpassword"); TextBox txt2 = (TextBox)row.FindControl("txtconpassword"); TextBox txt3 = (TextBox)row.FindControl("txtemail"); gvdatatablle.EditIndex = -1; SqlConnection con …
i'm trying to make a login form connected to an sql server database. my data base has records like this: fname - lname - minit each name in a separate column, and i wanted to use the name as the login username, so in the dataset designer i made a …
Hi All, I have this tables Sales ReportID SalesAmt Branch {LocationA, LocationB} ReportDate What am i missing from this table or i need to create another table to normalize it.
Dear Daniweb Team I am new to vb.net and doing some experiments with it. Trying to make a small application for personal use. I have some WORD files, which are formatted using bold, italic and colors etc. I want to copy entire content of word file into SQL Server table …
hi guys, does anyone have an idea how i could generate a monthly,daily or annual report using sql statement since i have tried with the one for daily and i keep getting the error 'now' is not a recognized function name. i want to get the total of Amount column …
[CODE]Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\reg.php on line 3 [/CODE] it just comes up with that and this is the only code i have [CODE]<?php session_start(); mssql_connect("Philip-Pc\DRAGONICA", "sa", "123456"); ?>[/CODE] any ideas?
I want to add new field when user enter text in text box and click on create then in the database table new field is create with the name present in text box I use this code to do this but it takes a8 as new field can i use …
I am using VB 2008 and have a datetime picker. I wam trying to use this value in an INSERT command to load in to a table but I just can't get it to work. I debug it out which shows something along the lines of "24/03/2010" but it just …
Could anyone point me into the right direction on how to make a C# SQL Datalogin?
Hey there. How do i search through my Datatable. I know how to do it when there is a Datagridview involved, but i dont have one in this case. I know they say you should do this [CODE]DataRow foundRow = dataSet1.Tables["AnyTable"].Rows.Find(s); [/CODE] Something like that, but i have no idea …
Hi Everyone, I have a form with multiple tabs that allows the user to insert data into a customer table. The ID is an Identity column. After a row is inserted into the database I would like to retrieve the ID number for that row that was just inserted into …
I have simple db with 4 tables: class, book, student and studentbook. studentbook has st_id and book_id as foreign keys and an extra field for result. book has some book for classes. I just insert new students. I'm quite beginner in db and don't know how to fill studentbook. should …
When i'm trying to create a new SQL Server Database in VB.NET 2005 through Server Explorer i'm getting following error (no matter what authentication i select): [COLOR="Red"]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the …
Hi! I am creating an entrance examination and what I want to do is get all the questions which belong to the same Year Level (e.g.first year) from a table and display the first question into a rich text box and when the next button is clicked, the second row …
Hi guys, I just want to ask some help I added a Download Button in every row of my Gridview. Its function is to download the Binary File of the corresponding row. Whenever i run it it gives me the error "Object reference not set to an instance of an …
What is difference between SQL,MYSQL, and MS-SQL?
I have a small company Database that tracks our repair orders. I have a query that I would like to execute based on criteria that the user inputs. I am new to VBA so most of my code is based on google research. I took a technique of wrapping my …
I am using BIDS 2008 to export to flat file(CSV) it will be automatically exported at 11.00 am in the morning. What i want to know, can we make it so the file that are being exported has a unique name each time it was being generated? so each day, …
The issue I am having is the following: Table1.FieldA is unique where as the Table2.FieldA field is not. When I run the following: SELECT Table1.Numbers, Table2.Numbers FROM Table1, Table2 WHERE Table1.ID = Table2.ID I get mutiple records like so: ID Name Numbers 125 John Doe 555, 556, 557 125 John …
Hello Guys! I just created my first VB.net project using Microsoft Visual Studio 2010 that has database(.mdf) and some forms, here is the video link of my project: [URL="http://www.youtube.com/watch?v=4YBt3vP85kY"]http://www.youtube.com/watch?v=4YBt3vP85kY[/URL] I want my project to be remote/network using lan environment, in what way i can do this? can you please help …
Hi I want add .mdf file in visual studio 2010 but in add conncetion show this error : click this link to show error [URL="http://imagenic.net/viewer.php?file=el5ce80y64r9d9bdspq1.jpg"]http://imagenic.net/viewer.php?file=el5ce80y64r9d9bdspq1.jpg[/URL] use SQL server 2008 R2 and VS2010 and I dont know what Please help me or give me a learning file or website Thanks
Hi everyone, I have an InvalidCastException Error in my program. The program is that i try to insert an employee record into a database table after getting the details from a form. I've used Money data type is SQL Server for salary and SqlTypes.SqlDecimal data type in employee template class. …
hi there, I asked this question before also. i have two date times in a table in the MS SQL server database, when i write the query as below. the Sstart Date and the Due Date is displayed as 12/11/2010 12:00:00 AM it shows correct in the MS SQL business …
Hiii I am developing one window application in c#.net with sql server 2005 as database. now, i have Some questions: How To Use OpenFileDialog control in C# window application. and how to give the validation for it. How To copy this file On The Other Folder also store the path …
[B]SELECT staff.StaffNo, semester.SemesterID, teach.SubjectID, teach.Sub2, teach.Sub3, teach.Sub4, teach.Sub5, teach.Sub6, teach.TeachLoad, (IIf(IsNull( teach.SubjectID),0,1) + IIf(IsNull(teach.Sub2),0,1) + IIf(IsNull(teach.Sub3),0,1) + IIf(IsNull(teach.Sub4),0,1) + IIf(IsNull(teach.Sub5),0,1) + IIf(IsNull(teach.Sub6),0,1)) * 3 As teach.TeachLoad, FROM (subject INNER JOIN (staff INNER JOIN teach ON staff.StaffNo = teach.StaffNo) ON subject.SubjectID = teach.SubjectID) INNER JOIN semester ON staff.StaffNo = semester.Staff[/B] i …
How to make or set this as autonumber in msaccess-vb database? from 00-00-00 up to 9999-9999-9999 how to make that code to become autonumber? and what code can i use in my database when the new entry is equal to existing ?(The same primary key)
I've searched the net high and wide for the answer, and yet came up with nothing. Right now, in out web.config file, we have our database connectivity stored in 2 different ways. We have our connection string, and we have it broken up into parts in our application settings. Crystal …
hello... I created a website having a database. I realised that I need to set a database username and password. I tried to include it in the connection string but I'm having the below error: Login failed for user ''. The user is not associated with a trusted SQL Server …
I have a property active to indicate status of an employee. Along with all the details, i extract the details from an employee table into a dataset, but however i am not able to get the value present in active as i get an invalid cast exception. This is the …
hello guys! Its been a long time posting here since I've switch to dot net...But I CANT LEAVE VB6 in programming.! I just want a little help.. Anybody can recode this statement regarding connecting to SQL SERVER local database.. The connection is succesful. But i want to trap the error …
I have a parent/child relation I am trying to create fow 2 datasets. The parent ds consusts of a range of PO Header information After I fill this dataset I loop through it getting the PO number. I then take that value and execute another sql statement on the DETAIL …
I recently installed MS SQL Server 2008 Developer Edition (on my home PC with Win7 Ultimate 64-bit). I have been trying to get it set up for use, but am having some issue. I keep getting an error when trying to connect to the server. On the "Connect to Server" …
Hi. so i'm using ms access 2007 as a database, i have here a table of TRANSACT IP which has the following columns of Transact_ID, IP_ID, Date, Time, Average, Min, Max. i have to produce a report in which i have to query from this table with the follwing format: …
The End.