9,022 Topics
I have a SQL Server table that has no rows. Programmatically in WinForms C#, I have created a DataTable with the same schema and populated it with data. I would then like to write the contents of this DataTable to the SQL Sever table using a SQLDataAdapter. Since the data …
how can i save multiple record in single click using user define data type in SQL i am having problem in selecting the value in gridview using checkbox here my code View // View LAyer protected void imgbtnSave_Click(object sender, EventArgs e) { DataTable dtTable = new DataTable(); DataRow dtRow = …
Hi guys, I'm new the this forum where I'm hoping to get some friendly advice for a bit-of-a-newbie C# programmer. I've been through 2 differnt beginners courses on the code so now i'm ready to get my hands in the code! I'm currently having a problem with loading all data …
Hey Guyz I have a SQL Database Assignment i've done the first two tasts out of 7 and i need some help with the rest i can pay 150$ for anyone can help me with it ASAP !!
Too weird but still I have a doubt.... I have two table.... -> OutpatientDetails -> InpatientDetails But the fieldnames are same except for the ID....i.e. OutPatientID and InPatientID respectively..... I want to combine both the tables and produce one output.....I dont know whether it is possible or no.... I want …
how can i save multiple record in single click using user define data type in SQL i am having problem in selecting the value in gridview using checkbox here my code View // View LAyer protected void imgbtnSave_Click(object sender, EventArgs e) { DataTable dtTable = new DataTable(); DataRow dtRow = …
I have been searching for the answer for 2 months, but still no success. Below the setup and connection string and all checked already. Firstly my errorlog file error = 18456 Severity 14 State 11 (Login failed for user OLDPC/GUEST. Token based server access validation failed with an infrastructure error. …
Hello Friends, I need to develop a birthday reminder form in my project.... The list of all patient that are celebrating birthday on that particular day and month...leaving the year.... My database is SQL server and I have used date datatype for it.... So I can I get the month …
2 textboxes to accept fromdate and todate and check with the database column of ida,rda and if matches then display only that row. I tried it in the below way but not able to do. con.Open() i = DataGridView1.CurrentCell.RowIndex cmd = New SqlCommand("SELECT COUNT(*) FROM IssueMBA WHERE ida='" + TextBox1.Text …
i have this code...i m retreiveing did from selected name........ i want to assign this to varible because i want to use this variable to another place... i hope i will get help here.. [code] MyDataAdapter = new SqlDataAdapter("select D_Id from tblDepart where D_Name = '" + D_Name + "'", …
Hi all, I'm trying to get some values from my database using data reader. Its my first time in using dataReader and I have this error "Value of type 'System.Data.SqlClient.SqlDataReader' cannot be converted to 'String'." My code Public Sub LogIn(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim …
I have been working all day on sql developer but now i am trying to work again and when i try to connect it is giving me the following error what shall i do? oracle.javatools.db.DBException: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdevimpl.db.adapter.CADatabaseFactory.createConnectionImpl(CADatabaseFactory.java:66) at oracle.javatools.db.DatabaseFactory.createConnection(DatabaseFactory.java:534) …
**I have been automatically collecting machine breakdown info to a database for 12 months, so I have thousands of entries in a 'Machine Downtime' table. However, I have found that the time_down column is offset by one row. The 'time_down' in the top row needs to be moved to the …
Hi all, I am writing a service to get a count from a table on an SQL server. THe SQL box is in the same domain, and the service is runnign under the same account as the SQL box. The box service is running on is Win 2008 in the …
I tried to install a instance using this youtube video.(http://www.youtube.com/watch?v=d9ozlxbRJLo) But this error occurred. (SQL Server Browser service group does not exists. Check for earlier failures in the setup) HOW TO FIX THIS ERROR....? Server : SQL server enterprise edition 2008.
I have installed new instance. While installing, it is occurred an error like this. (SQL Server Browser service group does not exists. Check for earlier failures in the setup.) In the end of the installation, it is shown sql server installed with failures. In "Services", it is displayed the instance …
Hello everyone, im doing a small program where i have a stock table with my Items and the current stock status. How do i substract from that stock status when i insert a new order in my ordertable. My tables are: STOCK: Item_ID Stock status ORDER Item_FK: Qty So i …
Greetings everyone, I'm having a problem on displaying my picture on the image box. Instead it displays the picture on the image box, it opens a web page and displays it there. Here's the code conn = New SqlConnection("Server=Jeiku-shin-pc;Database=EnrollmentDB;Trusted_Connection=True") Dim cmd As SqlCommand = New SqlCommand( _ "SELECT * FROM …
Good evening guys, I'm having a problem on my web page. I'm trying to store a data on my mssql but it's not saving anymore. but it was working perfectly this morning. it doesn't display any error so i don't know what happened. Thanks in advance.
Hi, i need to know how to convert ms access database to work on sql. Any help would be appreciated. Thank you
BIDS 2005 DEV Ed I am working on a simple SSIS Package that parsers through a folder and uploads certains flat files data to certains databases. TextFile syntax example: CustomerData1213.txt;CustomerData1513.txt;CustomerData3313.txt;CustomerData1323.txt I am using a sql task that pushes file names from a table to the foreach loop (ADO Enumerator). However …
For the purpose of synchronizing data in sql server, such as: **1. Synchronize data between servers and client 2. When loss of internet, the client can still work based on the data required to run on the client. 3. When have the internet connection, data from workstations to be synchronized …
I'm developing a VB.NET application that is going to be checking if a table has been changed and if it has get the data and send it off to another application. I was looking into ways for an application to know that there has been new data added to the …
I really hope someone can help me with this one. It is a Hotel Booking System: Tbl Room (RoomID, Floor, Notes) Tbl BookingsRoom (RoomID, BookingID) Tbl Bookings (BookingsID, StartDate, EndDate, Comments) I have to create an SQL select statement for checking if a room is bookable during a given time …
I have an ssis package the loops through an entire folder importing records into a sql 2005 database. I pull these records from a table in my database through an "execute sql task" then that gets pushed into the foreach loop container. However when one of the filenames is missing …
Hello Friends, I have three table ->PatientDetails ->ParentDetails ->InsuranceDetails -Patient id is the common column in all the three tables... While saving the data in table using VB.Net there is a column in PatientDetails i.e. Insured If the patient is insured then only the values from text boxes and the …
Hi all, i have a table for instance, systemid | phonenumber 1 62222222 1 92222222 1 64444444 2 91111111 3 63333333 3 63333333 i want my select query output to be systemid | phonenumber | phonenumber2 | phonenumber3 1 62222222 92222222 64444444 2 91111111 3 63333333 63333333 I tried to …
I have a gridview(Gridview1) that has 5 columns as below: 1. The 1st column is databound. It binds to a “CustomerID” column of SQL Server customers table; 2. The 2nd column is databound. It binds to a “CustomerName” column of SQL Server customers table; 3. The 3rd column is databound. …
In sql server , my query brings out more than one row of data SELECT * FROM TABLE 1 WHERE COLUMN LIKE 'PARAMETER' Now i am trying to make it in a dtagrid that the datagrid shows allpossible rows that is supposed to show .This is the code Dim objCommand …
hi, i am currently building an application that depends on a third party application written in .net using a mssql server database. i am more of a lamp guy and prefer mysql. to extend the application i would need to add some tables to the database. i am currently thinking …
Currently I build a website, and the idea is that the index (front page) will show entries from all users as well as a main picture. I have considered the possibility that you can let users choose a primary picture when creating a topic, but I want this to happen …
hello.... i create setup using vb.net 2008 with mssql database...... it is run on my machine without any error but when i install it on client-machin i got this error See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception …
i really hate php and javascrip but i really want to make a social network website just for fun. so i wanted to use java, sql, and html to make. i already know these 3 languages and i know how to set a database but i dont know how to …
I have a table called Product. In the Product table we have something called ProductCode and NewProductCode. When we first built the tool we were anticipating the NewProductCodes to be coming down the pipe at a later date. So we added this column with NULL. So right now the DB …
I have an sql table that stores English words and second table that stores meanings of those words in related maner. Here are some informations about table structures: Table1 name: Words WordID int IDENTITY(1,1) NOT NULL, //This is primaryKey Word varchar(50) NOT NULL, Table2 name: Meanings MeaningID int IDENTITY(1,1) NOT …
HI Is it possible for vb6 to add the sql database as a back end for my program?and i would like it to add it during the deployment of my program as a prerequisite of it. Please let me know thank you
Here is a class to SQL use an access database: Class MyDB Public DBName As String Private con As New OleDbConnection(ConStr) Sub New(ByVal DBN) DBName = DBN End Sub Private Function ConStr() ConStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & DBName & ";" End Function Private Sub ConInit() If con.State <> ConnectionState.Open Then …
hello every one , ! i have same prob as the user had in this thread [Click Here](http://www.daniweb.com/web-development/databases/ms-sql/threads/421214/remote-server-access) first i thought to post my question in that thread but then i thought it is better to open new thread . in above mentioned thread a user have prob to connect …
I am trying to insert values from a table to another table. The thing is I want it such that only a row in the source table that does not exist in the destination table should be inserted. I have set each table to have a column that automatically increments …
Hi guys can we update data (Edit) in view table in sql server? If Yes How ,if No Why? Thanks in advance......
Please help me with my database connection. It says that I have an error with my Insert Statement. Imports System.Data.OleDb Public Class Form1 Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click Dim connection As OleDb.OleDbConnection Dim mydb, mystr As String Dim dateFiled = Date.Today Dim user …
I currently have this login form in my python program with a submit button: <input type="text" class="input-small" placeholder="Email"> <input type="password" class="input-small" placeholder="Password"> and I have an sql database that has emails/logins/etc. How do I make it so the after pushing the submit button, the email/password is verified with the database …
Good evening guys, i just want to ask if the dbname.ssmssln something is sendable and usable on other computer or not. because i created a database and my other friend wants to see it and i send the ssmssln file i just want to know if he can access it. …
I need help with the format for single qoutes. I am using dynamic sql in an SSRS for error trapping records inserted with single qoutes during bulk imports but I cannot seem to format the actual select statement properly. SQL Sever 2005 Dev edition. Any help is great. Declare @DB …
Whenever I run the form and complete the procedure then I need to go back to sql database and click on execute. I want to avoid everytime going back and executing each entry because if I don't execute everytime then the further other [b]form data [/b]will not be[b] retrieved[/b] properly …
Hello everybody! I'm doing my project about ASP.NET but i don't know how to Insert Data into Database. Example: [B]First name: xxxxxxx Last name: xxxxxxx[/B] [B]Button(<<<)[/B] i want to know how the code working when i click the Button the data first name and last name will go to Database. …
I am currently working on a stock market monitoring application and I was wondering if anyone cold help me by giving me a guideline on how to create a new portfolio(sort of a personal account) for each user that accesses the system such that 2 different users do not have …
I am currently stuck on a project where I am populating a datagrid from a series of labels and textboxes. I have that part down. Now for the part where I actually add it do the database, I am having a problem. It is actually adding everything to the database …
Hi, I have a doubt in MS SQL, The below condition in the WHERE clause as you can see, "Where COTDetails NOT BETWEEN 32 AND 63 OR COTDetails is NULL", I want to the WHERE clause in such a way that the COTDetails is not between 32 and 63 and …
The End.