[microsoft:sql-server] Forum Topics

Hi everybody, I'm setting up peer-to-peer replication topology. Now, my two sites are working well, both sites could make changes to the common database and the common database is synchronized between the two sites. However I have a question which I still not have the answer my self. In the …

how to create a login in vb.net 2005. the user name and password are stored in sql server 2005. Thanks

I am working on a software project that utilizes the MSSQL Express version. My question is... I have checked out software that does the same thing that I want to do, but it seems that the competition uses a file based database system. I intend to use SQL because it …

Hi, I've got a door_order table which I export to excel, now I have to make it so that underneath each door_order the products are listed from door_product table, please not that this can be more than one product for that order. This is my code so far public DataTable …

Hi, I have installed Visual Studio 2010 Express in my local system. Steps 1. File->New Website 2.Open datbase explorer, right click on dataconnection 3.Select Create new connection 4.use Microsoft SQL Server Database file 5. Type new databse filename 6. Now i want to use SQL authentication which is not working …

Hi, I need a very urgent help. My requirements is, I need to display my data in a datagriedview on monthly basis only. I have done the retrieving of the data from sql server to the datagriedview. But how do i show it only on monthly basis? Regards, Malini Imports …

Having found the following post on datareaders [URL="http://www.daniweb.com/forums/thread278415.html"]Topic Posted On DaniWeb[/URL] i have managed to successfully create a datareader in a class that updates a listbox on the calling form with entries retrieved from a SQL server database. I was wondering if it is possible to achieve the same thing …

I have a registration form and I want to feed the contents of it into an SQL database that I created in Visual Web Developer. I have the proper code to insert the contents into the database table, but there is a problem with my connection string. What's the problem …

Dear SQL sharks.... Please somebody help me with this struggle. I have been searching the web for hours now. I have a table with sales data. In this table i have a columne called SalesAmount, CustomerName and SalesDate(the format i smalldatetime) Now I would like to retreive all the records …

helo i a have this problem in my coding plezz help me.. when i want run my sytem... i get this error..Type 'OpenDb.OpenDbMSSQL' is not defined. anyone can tell what is this??

Continuing from my previous program,the code now can update but can't insert.There will be an error on ExecuteQuery.The program is suppose to identify if the id exist or not.You can probably tell from the coding. Trying to insert but i'm not sure if i set dateID parameter correctly to check …

Hi All, I have a database (sql server) where i store activity information example (activityid,id,summary,signs etc.) I can successfully save this information to the database. what I also want to achieve is to add this information to a listbox so that it can be displayed in the corresponding textboxes at …

I have created a library management system applicationn in vb.net... I have an issue form... which has issueid, issuedate, duedate..... these are set as "not null" in the datavase(sql server).. When I add a new issue and try to add another after that the DateTimePicker values doesn't get reset.... so …

Hi i have a simple question i was wondering how to display the existing data in C# objects like Textbox, combobox or labels. At the moment a sql database file, one of the tables data is currently displayed in the datagridview control just fine. But what i would like to …

hello i want to read 12 values (datetime data type) named s1,s2,s3,s4....,s12 from database. compare these 12 fields with current date. if difference lies between 10 days i want to show corrosponding result. please tell me code for this in c#

I am trying to connect from Eclipse to a database in SQL server 2008. However, i am unable to and the following error message is thrown(see attached image). Can somebody help?

I have table that has students classes and grades. They are allowed to fail a test twice but if they fail twice they have to retake the couse in which they have two more tries. I would like to show only the most recent grade. Here is the table structure …

Hello All , Im developing small portal for learning asp.net webParts , i created web page Default.aspx with visual studio 2008 , the default.aspx : [CODE]<body> </asp:WebPartManager> <form id="form1" runat="server"> <table style="width:100%;"> <tr> <td colspan="2" class="Front"> Welcome to my Portal </td> <td class="Front"> The Content Goes Here </td> </tr> </table> …

I have created an Exams form which has all its control(1 txtbox, 2 combobox) binded to exams table (SQL Database). The form has a Datagridview which shows two column, Subject and OutofMarks(dats total mark assigned to a subject e.g. Subject [B]English[/B] is of [B]100 [/B]mark. The subject column of datagrid …

If you have 3 tables with over 10,000 records each and you have to build a recursive function with this 3 tables link, and you expect to have in return around 200 records, What will you do? "The website is intranet host" Query the sql server multiple times or load …

How would i change this so it will work. I need to link two tables. but i get an error that says "Join expression not supported". [code=c] case 'N'://Get Jobs //long n = Int64.Parse(Del); SEL = "SELECT Employee.[Employee Number], Employee.[Last Name], " + "[DaySchedule]![Shift Code Monday] AS Monday, " + …

I have a table that looks like the one below: Name Score1 Score2 Score3 TOTAL Dan 71 85 23 ? Tom 58 84 87 ? sam 76 65 64 ? I dont know d command that will dynamically get the total score for each student and put it in the …

Can i make privilages to make two modes 1. Admin Mode 2. Ristricted User Mode. Please give me some sample code. I am using vb.net with sql server 2008.

Hello, I am trying to make a Data Grid View for a form that will be used by some co-workers. The hangup I am having is one that I am experiencing as a new developer. I have the Data Source set already and I am will be writing to an …

We need to access a MS SQL 2000 database with unicode data in nvarchar fields from PHP (on IIS). Unfortunately PHP's MSSQL does not support this. Unfortunately we cannot use a different driver (like ADODB) - we're stuck with the application (Interspire KM) and can't rewrite it. Is there anyway …

Hi! I have an application that will operate with a distributed database on various pcs in multiple cities... the application is in c# connected to an sql server...I need the pcs to connect between themselves, how should they do this? it's the first time I work with this type of …

cmd1.Parameters.Add("@emp_name1", SqlDbType.NVarChar); cmd1.Parameters.Add("@join_date1", SqlDbType.DateTime); cmd1.Parameters["@emp_name1"].Value = name.Text; System.Data.SqlTypes.SqlDateTime getDate; //set DateTime null getDate = SqlDateTime.Null; if (joindate.Text == "") { cmd1.Parameters["@join_date1"].Value = getDate; } else { cmd1.Parameters["@join_date1"].Value = joindate.Text; } I used this code to insert a null value in datetime column of sql server table but always its giving …

Hi all, I'm trying to create a method Load that will call a stored procedure,the source code has some problems,really need some guidance still new in C# Ok here's the code now with some minor adjustments rather than just getting one data,i'm planning on retrieving all the parameter just by …

I am using the following code to delete record it did not delete record but just only populate message record deleted successfully what should i do now please please help me. [CODE]If TextBox1.Text = "" Then MessageBox.Show("Please Select record to delete......", "ALI ENTERPRISES", MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If If …

I have recently developed a pretty comprehensive Inventory application for my company. Today I loaded up SQL Server Profiler for the first time and started to play around in the application to see what and how many queries are really being ran. One section of my application utilizes a gridview …

i have a form that searches only text based on 2 criteria. 1st criteria is the user selects from a drop down. The drop down is a table in the database. 2nd criteria is what the user enters in the text box and then clicks to submit. SO whatever the …

I"m very new to SQL but need to insert LOT numbers to inventory. I have my table (cards) and my column (lot). The cards come in lots of 25 units. Each lot increments by 1. So rows 1-25 would have lot 0001, 26-50 would have a lot of 0002, etc. …

.Hello guys! I would like to ask for some help regarding one of my class projects. Here i have two classes named AddBook.cs and the other is ListCommand.cs, what i want to do is to transfer certain codes from AddBook to ListCommand so that whenever i want to use the …

Hello there, I have created a project in C# and I want to make a setup file for it which should first check whether the target machine has framework and sqlserver installed in it. now if these two pre-requisites are not present than these two pre-requisites should be available in …

I'm a college professor with noe one to turn to forauthoritative help regarding the stuff I'm teaching .. when my examples for students (or projects for clients) don't behave as expected, it gets pretty lonely out here! I will appreciate having a circle of well informed, highly experienced folks to …

I'm trying to connect and can. The code fails at the select database. I have created the Tools database already. The table is an exact clone of the mysql counterpart that is currently working. Any Suggestions? [CODE]<?php $dbuser="yukon"; $dbpass="yukon"; $dbname="Tools"; //the name of the database $chandle = odbc_connect("sqlserver", $dbuser, $dbpass) …

userid | personID | positionID 712 | 912 | 8 713 | 814 | 15 516 | 811 | 9 712 | 912 | 9 713 | 814 | 15 from the above table i have to find out userID of the person who has different multiple postion. i.e my …

Briefcase application Access 2003 two way replication Are there any open source databases that allow two way replication exactly the way Access 2003 handles it? I have a desktop app that I would also like to have live on the web but I have to use Open Source software like …

I don’t have a problem, but sometimes I just love the way this system works. I got the message {"Cannot convert object of type 'System.Int64' to object of type 'System.Data.SqlTypes.SqlInt32'."} {System.Data.DataException} This was the command System.Data.DataRow dr_Test0 = this.XML_DataSet.Tables[0].NewRow(); I also love how they obfuscate code. Finding the designer code: …

Hello, me again. No VB experience and very little SQL experience. I am trying to upgrade a web site, that connects to a SQL DB to track requests. The SQL DB was originally built in SQL 2000 and I did not create the DB or the web pages. The new …

Hello, I am new to asp.net. I am using visual studio 2010 express version. 1. I have a log in page with text boxes to accept username and password for admin. 2. Two buttons to rest and login. 3. I already created a sql server database connection from the server …

Hi guys, Can anyone help me how can i search,delete,undo edit record in vb.net using sql server2008 as database please please give me some sample code thanks in advance.

I have an error I don't understand how to get rid of. I want to compare a string consisting of: ID + " " + date + " " + time + ":00" to a string in the database (data type = text). Here's an example of what I fetch …

Hi all, I am executing query for SQL Server 2008 like that , [CODE]myQuery= Insert into Employee(id,name)values(' 99 ' ,' Nitin Daphale ');Insert into Employee(id,name)values('77' ,'XYZ');Insert into Employee(id,name)values(' 88 ' ,'ABC');[/CODE] Here am Inserting 3 Records in an Employee table but the problem is, if any statement fails I can't …

Greetings, I have been cracking my skull all weekend trying to find a solution to this, and I have no idea how to search as I'm not sure what to search for (I have performed a search, but it didn't show what I was looking for, hence, the post). I …

I am in school and as a project I am building a mock Database from SQL Statements. I like having clean code and since I am at home building these statements on notepad to execute at school later I have a questions about white space. When I use CREATE TABLE …

m a newbie to vb.net and aspx and m trying to validate a login (employee id and date of birth) to a sql database and comin up with the following error ([B]CommandText property has not been initialized[/B]). thanks for the help.... [CODE]Protected Sub btn_memberlogin_Click(ByVal sender As Object, ByVal e As …

I am new to SQL query. I would like to join two SQL queries (MS Office Query and Computer Details Quer) into one. The tables output can be found at [URL="http://rapidshare.com/files/412276985/SQL_query.zip"]http://rapidshare.com/files/412276985/SQL_query.zip[/URL] Or, from [email removed] Thanks for your guidance, below are the query: 1) MS Office Query: ================ [CODE]select v_Add_Remove_Programs.DisplayName0 …

Hi I am new to this SQL and I using access to build the below statement. Below is a working SQl statement but I need to output DISTINCT records. How do I compose this syntax inorder to display DISTINCT record using this {SR.No#] field ----------------------------------------------------------------------------------------- SELECT Sheet1.Date, Sheet1.[Club Name], Sheet1.[Problem …

Hi all, I'm using ASP.NET programming with SQL Express 2008: Basically to simplify and summarise, I have Users who can message to each other: Users table: UserID (PK); UserName Messages table: MessageID (PK); UserIDSender; UserIDRecipient I want to Select * from Messages table and also the UserName for the UserIDSender …