[microsoft:sql-server] Forum Topics

Hello, I am trying to connect a VB.NET 2003 Oledbdataadapter through the wizard to a SQL Server 2005 Database, but i get an error message during the wizard. These are my steps: New Connection, Select provider (Microsoft OLE DB Provider for SQL Server), Select Connection: server name, log on: use …

Hi folks, I had mysql database with English+Chinese data in it...I had to migrate that database from mysql to MSSQL 2005. Now I cant view any chinese character..It shows '?' symbol in place of chinese characters. How can I set the collation in MSSQL that I can view chinese data …

Hello all! I'm trying to convert one of my columns in MS SQL Server 2005 from an integer to a decimal field (ex. 59670 ---> 596.70), but I keep receiving an error message: [COLOR="Red"]Msg 8115, Level 16, State 8, Line 1 Arithmetic overflow error converting numeric to data type numeric. …

hi, I found on the net that to make a query one needs to create a dataset. therefore i have created a datatable to this dataset with 3 columns into into. Now i have created a query to display the information according to the query. the problem is that i …

Hello, Just need quick help in PHP + SQL SERVER 2005 DB CONNECTION ...i having problem while connection SQL SERVER 2005 WITH PHP APPLICATION WHICH WORKING PERFECTLY IN LOCALHOST AT MY PC BUT IT NOW NOT WORKING ON THE SERVER SO DON'T KNOW WHATS WRONG ? I THINK ANY SERVER …

hi there, i get a Argument Out of Range Exception in the line "dgvDAction.Rows[r].Cells[0].Value = dt.Rows[r]["TActionDes"].ToString();" when it runs for the second time.dt.Rows.Count = 2. why is this happening??? [CODE] String query = @"Select TActionDes,TAssignTo,TDueDate,TStatus,TDateComplete,TComment from TopicAction Where TopicNo=@topicno and Phase=@phase "; SqlCommand command = new SqlCommand(query, DB.getConnection()); command.Parameters.Add("@topicno", SqlDbType.VarChar).Value …

I have a form that has multiple text boxes, check boxes etc... The question is, instead of writing out: [CODE=c#] cmd.Parameters.Add(new SqlParameter("@myparam", (object)textbox.Text));[/CODE] a million times for each parameter, is it possible to load all of the names of the objects on a form into an array and just do …

hi there, when i pick a date from the datetime picker and do to save it in the databassse the time is as 12.00.00 am in the database with the date. how can i make the time to set the default system time to be saved to the database. i …

Hi,i got this error. Error is: The updated data was repeated again.when i refresh the page,it comes correctly, How i rectify it codings given below --------------------------- Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating ' GridView1.AutoGenerateColumns = False Dim row As GridViewRow Dim Exp As TextBox …

hi.. im using VS 2008 to build my app. i need to generate a report for a specific user. i have a SQl database which contains all my tables & Stored Proc's.. i have created a proc to retrieve data for tht specific user & used the same to bind …

Hi all, I have just received a quote from a software supplier for a new SOP solution - windows based upgrade to our UNIX based one. We already have a Small Business Server 2003 in place & the new software would sit on a Windows Server 2008 box. The new …

Hi, This should be a simple query but I am not able to figure out how to get the result I want. I have two tables A and B and want A left Join B however, I do not want all of table A. I want to restrict table A …

Table1 has clustered PK A, 2 has clustered PK [A,B] and has a foreign key to table1. Both A and B are uniqueidentifiers and when table2 adds a record, B is always set to newid() so B is unique in table2. For each A value, there aren't more than 100 …

[COLOR="Red"]I just want to know that how to make a (NoOfChildrens)[B][I]tinyint[/I][/B] data type to an [B][I] unsigned tinyint[/I][/B] data type through SQL Server Management Studio Express ?[/COLOR] Where 'NoOfChildrens' is a column in table named Family in the database.

I have created a DLL file using VB6.0 and the registered the DLL into another server. Now I have created a DTS Package (ActiveX Task) which will create object of the DLL and call a particular function. The problem is when I execute the DTS task from my ID, everything …

[B]sir I design a small application in vb (Windows-xp system) which displays the records from the sql database tables. Entering a table name in the text box and clicking the Button, its records are displayed in the data grid. The code for the button is[CODE]adodc1.recordsource="select * from " & txttable.text …

hello dear developers. i have recently completed a c# application. i have also created user accounts and there respected logins. after saying that now i want to build a system in which specific users have specific rights on reports,edit action on accounts and other sql related rights. how could i …

guyz i need your help..i'm still developing my project bout evaluation of employees. I'm using the code below,I want to multiply the values of the two specific row/column inside my datatable and then insert the product in the KPIGRDEQUI field in the KWEEKDTL table.Is it possible to be done? please …

Does anybody out there know of any VB.Net tutorials regarding pulling and adding records out of a sql database? I am trying to figure this out on my own, but I just need an example program to show me how to do it. I have figured out how to connect …

Hi friends..... As when i am doing this task and found know help .............. here i am putting steps for importing data from Excel sheet into SQL Server 2003. How to Import data from excel sheet to SQL Server Note : - Sheet should be exactly same as Table in …

Hello I am recieving error [icode]java.sql.SQLException: At least one parameter to the current statement is uninitialized.[/icode] at ConnectStudentDAO.java at [icode]ResultSet rs=ps.executeQuery();[/icode] Not sure if the xml statment or the bean variables or if ps.close() is needed [b] output [/b] [code] run: driver tableName from xml: org.apache.derby.jdbc.EmbeddedDriver in bCreatedTables: created table: …

I have binded a textbox to a column in a SQL Server 2005 Database, when i fill the dataset it displays the data, but when i click the save button it doesn not save the changes to the database. I used this same code to do a Datagridview and it …

Hello, U just started using acces and I need to make a query using multiple tables. I read some tutorials and watched videos but I can't seem to do it right. I have 2 tables: the first one is Login, the second one is Group. Login contains Username, Name, Group …

How to create Database connectivity for sql server express edition 2008? plz Help me.. i am confused so much...

Hi Guys, I have a problem connecting to a SQL Server from Windows 7 - this particular server I can only connect to by using the named instance from Win XP - I can connect to other servers that does not require you to connect to the named instance eg: …

hi, i work on windows application and i have this code: [CODE] SqlCeDataReader rrs; SqlCeCommand comd = new SqlCeCommand("select CodePersonne from Table1 where DateR ='" + DateTime.Now.Date + "';", conne); rrs = comd.ExecuteReader(); [/CODE] while running, i get this error: The data type is not valid for the boolean operation. …

Hi Folks: I am still having trouble moving data between sql and ms access databases. Has anyone got any idea? Bob Ghodsi

Hi. my name is srikar.......and my query is How to differentiate system databases and user created databases in sql server 2005??????????????

Hi I want to add the table names from a database in sql server to a combobox with vb.net windows programming. Its a customer accounts database where for instance I add a new Account holder which creates a new Table and when I want to view a specific account holder …

Hi, I am having problems inserting data into a table using a stored procedure. When I click the button to insert the data nothing happens at all. I added a [B]server.transfer[/B] after the insert to see if it was falling over before the end of the query/insert. My code behind …

Hello Friend, I am freelancer web developer person. In this time i am developing one web application but i have some problem in this application. 1) Error of ','; 2) Database in Sql. 3) How to use proper query in application. If any one to know about, so plz give …

I hope you can help me. I'm working on a program that will open any Access database that might be on the system. The problem I'm having is that I cant get get the SQL statement to show all the tables within the database. The code im using is as …

Hy, I have a select like: [CODE] select case when isnull(my_table.entry,0) > 0 and my_table.edate = convert(datetime,substring('2009-09-20',1,10)) THEN COUNT(*) else 0 END as no_entries_date1 ,case when isnull(my_table.entry,0) > 0 and my_table.edate = convert(datetime,substring('2009-09-21',1,10)) THEN COUNT(*) else 0 END as no_entries_date2 ,case when isnull(my_table.entry,0) > 0 and my_table.edate = convert(datetime,substring('2009-09-22',1,10)) THEN …

Hi I get the error Invalid column name 'MakerID' from my code below. [CODE] <asp:GridView ID="GridView1" AllowSorting="true" AllowPaging="true" runat="server" DataSourceID="SqlDataSource1" AutoGenerateDeleteButton="true" AutoGenerateEditButton="true" DataKeyNames="CamID"AutoGenerateColumns="False"> <Columns> <asp:BoundField Visible="false" ReadOnly="true" HeaderText="ID" DataField="CamID" SortExpression="CamID" /> <asp:BoundField HeaderText="Kamera" DataField="CamName" SortExpression="CamName" /> <asp:BoundField HeaderText="MakerID" DataField="MakerID" SortExpression="MakerID" /> <asp:TemplateField HeaderText="Tillverkare"> <EditItemTemplate> <asp:SqlDataSource SelectCommand="Select * from Maker" ConnectionString="<%$ …

hi there, Question 1: i have a question in invalid operation exception. it says that " there is already an open datareader associate with this command which must be closed first. " the code is shown below [CODE] public void AddToAction() { String query = @"Select * from TopicAction"; SqlCommand …

hello all, pls have some patience to read this and help me. Im a student and doing a project using CSharp. Im doing an automation process. For which i ve to login to a website click some links and then download files from there. I cant download all the files …

Hi All, I think this is my first question here. My web application uses an Access database and I'm getting some strange behaviour which might be related to that. Here's the issue: At the end of processing a users request (during which a lot of calculations are done), a record …

hi, i havea mathod called "getProposalNumbers" which returs a string array. this is filled by the data from the database. what i want is to check whether the array hase no values the mothod code is below. how can i check whether the array has no values? please can someone …

Protected Sub Button5_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button5.Click Dim connection As SqlConnection = New SqlConnection("server=(local); Database = Bookstore; integrated Security=True") Dim CSP As SqlCommand = New SqlCommand() 'Dim Cust As SqlCommand = New SqlCommand() CSP.Connection = connection CSP.CommandText = ("select CusID,CusPassword from CusromerDetail where CusUsername = …

i'll attach a little snippet: [CODE] comd = New OdbcCommand("INSERT INTO news (new_title, new_content) VALUES (@newTitle, @newContent)", conn) comd.Parameters.Add("@newTitle", OdbcType.Text) comd.Parameters("@newTitle").Value = newsTitle.Text comd.Parameters.Add("@newContent", OdbcType.Text) comd.Parameters("@newContent").Value = FCKeditor1.Value conn.Open() comd.ExecuteNonQuery() Response.Redirect("default.aspx") [/CODE] this code executes, and my database is updated, but the new_title and new_content fields are still NULL. i've …

HI Everyone, I have designing a desktop application with SQL SERVER 2005. I have one form where user can take a full backup of SQL Database in one File. I have following controls : 1. txtSQLServerName 2. txtSQLDBName 3. txtSQLSQUserID 4. txtSQLSAPassword 5. txtBackupLocation 6. btnStart 7. btnCancel When user …

Plz help me out to resolve a conflict. I have made untiring efforts to resolve but coudln't. I have showed my data in gridivew now in windows forms now i want that when i make chages on the gridview using it like an excel sheet. These changes should also be …

i have a textbox to upload .csv file. after i click upload it insert the .csv file into sql server database how to insert .csv file using vb.net into sql server

[CODE]1. protected void Button1_Click(object sender, EventArgs e) 2. {string s="Data Source=Black-PC\\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True"; 3. SqlConnection Conn = new SqlConnection(s); 4. 5. Conn.Open(); 6. string strqry = “Insert into students values (” + TextBox1.Text + 7. “,’” + TextBox2.Text + “‘,’” + TextBox3.Text + “‘)”; 8. 9. SqlCommand Com = new …

I have the following code: [CODE]Imports System.IO Imports System.Data Imports System.Data.SqlClient Partial Class _Default Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load End Sub Protected Sub Submit1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Submit1.Click Dim SaveLocation As String = Server.MapPath("Data") & "\upload.txt'" …

hey, does anyone know how to handle this exception? please help me [CODE] //Retrieves all the contract numbers from the Contract table public String[] getPhaseNumbers(String TopicNo) { db.openConnection(); String query = @"Select Phase From Topic Where TopicNo = @topicNo"; SqlCommand command = new SqlCommand(query, DB.getConnection()); command.Parameters.Add("@topicNo",SqlDbType.Int).Value = TopicNo; SqlDataAdapter da …

Hi all, been working on this problem for a while now but having little success finding a satisfactory solution. I have a DTS package which contains two connections. one for SQL, the other for AS4000. I would like to pull records from the AS400 table using Account numbers stored in …

Hi, I'm developing this query for a dashboard using System Center Config Manager Dashboard. The query needs to produce a table which shows the number of computers which have Office 2007 Standard edition in one row, and the next row should show the number of computers which do not have …

Hello guys, I am asking a very simple thing to be done in my project (May be I've forgotten the syntax)......... I've taken a drop-down list in which diff. user-names are coming and added a delete button to delete the full row which contains the selected drop-down list user-name. I've …

[code] try Dim da As String = "+100acs+" Dim con As SqlConnection = New SqlConnection("Data Source=RAHUL-034890AF0\SERVER2005;Initial Catalog=user_accounts; Integrated Security =True") Dim command As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("Insert into sales_details (bill_number,product_id,quantity,rate,amount) VALUES ('" + da + " ','" + Ddpproducts.SelectedItem.ToString + " ','" + Textquant.Text + "','" + Ddpproducts.SelectedValue + "','" …