[microsoft:sql-server] Forum Topics

I have combo box of programme and another is courses.. when i select any programme combo box so courses combobox add courses with respect to programme... the problem is when select another programme so previously programm's course also included in combobox.. i want to remove previously courses..in courses combobox. [CODE] …

Hello, I am trying this.. [code] Imports System.Data.OleDb Public Class Form1 Dim conn As OleDbConnection Dim cmd As OleDbCommand Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click conn = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; Data Source=c:\nikhil.mdb") conn.Open() Dim row As DataRowView=ComboBox1.SelectedValue Dim row1 As DataRowView = ComboBox2.SelectedValue Dim row2 …

hi i have a question in reporting server. the server is started and when i try to go to the URL it doesn't give me anything my windows account does not have admin privileges is this the cause for this. and from MS SQL management studio when i try to …

Hello anybody I 'm a beginner programmer and now I have one problems that is errors " could not find store procedure" in myform here is my code [code] Public Sub GRID_STAFF_INFO() CONTOSQL()'that is a function for connection to sql server' Dim table As New DataTable CMD.CommandType = CommandType.StoredProcedure CMD.CommandText …

hi there, i am using a code to back (downloaded) up a database in a server and when i run the application it gives me an error saying operating system error 3 [CODE=C#] //Use this line if you have already created a bakup file. File.Delete(DBpath + "\\backup.bak"); this.Cursor = Cursors.WaitCursor; …

Hi all, First-time poster and netadmin/infosec guy trying to get into coding. My company uses a SQL Server 2005 database to store customer information and the like, and I'm hoping to learn to interact with it programmatically so I can write and/or customize software to make life a bit easier …

Hi everyone, I use the ADO.Net SqlConnection, SqlCommand and SqlDataReader for all of my database interaction within my DAL. When I do a SELECT statement I cycle through my reader in a while loop and store each row in custom objects I have created. It seems to me like nobody …

Hi everyone, Here is my situation: I have a table of users in my database with all the usual user information it it. I have another table which lists the rights that each user has. this table has 2 columns 'Userid','Functionid'. Each user may have multiple rows in this table, …

hi there, i have a question in connecting to the server. when i log in to the server and connect to the ms sql server i can connect to the databases. but when i login to another computer and try to login to the MS SQL server management studio i …

Hello everyone, I am using [CODE]ExecuteNonQuery()[/CODE] to execute a SQL command that inserts data into a SQL Server 2005 Database. I want to return the number of rows affected. I've read that this method returns the value, but I can't figure out how to access it. Help is very much …

We're having issues with database performance, and up till now, have done very little with indexing. We try to turn on full text indexes when available, but we do support (though we are phasing this out of our support)MSSQL2000, we try to advise our clients to use the newest available …

I'm trying to query several different tables using INNER JOINs but there's something missing in my code. I get all the results I need except that what I want in this case is that for example, when we make partial shipments, I need to have all the different shipping dates, …

hi there i have a database which is MS SQLserver 2008 and ihave a database called AdminApp. from visual studio 2008 i add the database and the connection is succeded, but when i get the connection string and add it to my DB class for the db string and run …

[CODE] insert into mst_order_report(Capacity, Clearing_Alpha, Client_ID, Client_Order_ID, Cumulative_Executed_Size, Date_Of_Expiry, Entry_Time, Exec_Type, Executed_Qty, Executed_Value, Execution_ID, Hidden_Size, Inactive_Time, Order_ID, Order_Qty, Order_Status, Order_Type, Owner_ID, PAN_ID, Parent_Order_ID, Reason, Remarks, Side, Stop_Price, TIF, Total_Qty, Trade_Report_ID, Trader_ID, Transact_Time, Value, Visible_Size, Trading_Member_ID, Symbol) select * from order_report(Capacity, Clearing_Alpha, Client_ID, Client_Order_ID, Cumulative_Executed_Size, cast(Date_Of_Expiry as date), cast(Entry_Time as datetime), …

Can you please help me in my problem regarding in using Listview in vb.net. I can manipulate some flow like searching and selecting data coming in database (SQL) but my problem is that i need a message thtat will pop up that there is no particular data in the database …

Guys, I am a newbie to using SQL inside the Query Builder of VB Express 2010. Very sorry if this is a stupid question... . I have 2 tables: "Student Details" ( Primary key: "SID" ) and "Level 2 Red Belt" (Primary key:"SID" ) I want after entering a record …

[CODE]20110319-04:30:00.772[/CODE] is the row of Entry_time column from order_report Above is in varchar Need to convert in datetime I am trying the below query but not working select Convert(datetime,Entry_Time,121) from order_report

Okay, I created an application that used SQL. It works perfect on the computer that I compiled it on, but, when I release the application it shows an error like: "Cannot open this application, missing components" ... Also, on the computer I compiled it on, it shows the database file …

In my form I have 5 text boxes where the user will be updating roughly 21 tables in the DB. Do I have to keep building a new sql connection for each event? Or is there a way for me to only have to write the connection code once? Basically …

Hello all. The Java Date and time classes are difficult. I think I have to use java.sql.Date which is a sub class of Date but is not a date unless the time is normalized to zero. so I've heard. I would like to work with my studentDOB first by collecting …

afternoon all hope someone can help, i want to populate a report and print it directly without the user hitting the print button. i have this working in a diffrent project but for some reason it wont work in this one. i get the error missing parameter, on the last …

what is the pattern of datetime in sql?

I was asked to create a report similar to a gridview in asp.net for a windows form application. I don't really have much knowledge about reporting, especially not in VS 2010 unless its a gridview or something similar since it will suffice and noticed that you could create a report …

good day guys! anyone can help me about this.. i need to create a login form with database (users.mdf) im newbie in c# .net i manage to create a connection my problem is the code behind the Login_Button thanks God bless

I am working with database and I am trying to join two tables . In one of my methods I wrote this code [code] 'this will construct a client object. The client data 'for the target client id(parameter) will be retrieved 'from the client data table. All of the transactions …

hi I want to fetch data from sql and use them to make a new data I really like to store the records in variables and maybe do some operations on some of them , but the main point is to update three tables in ways that are not the …

Hi, I am looking for a recommendation on a decent server backup software. Right now, I am evaluating, novastor, acronis, and datastor, but would greatly appreciate some advice on the matter. Right now, we have 3 servers: a file server, an application server, and a domain controller. I would like …

Hello I have a class with an sql statement to return a list of customers from a postcode search from a database. Then on my form I am attempting to return a sorted list of these customers into a list box for selection. Could someone please tell me how to …

[CODE]using System; using System.Data; using System.Configuration; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; /// <summary> /// Summary description for class1 /// </summary> public class class1 { SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["privacycloudconnection"]); SqlConnection con1 = new SqlConnection(ConfigurationManager.AppSettings["cloudconnection"]); SqlCommand cmd, cmd1, …

hi i get an error saying cannot login to the ms sql server, i did all the things restarted the server, and changed the authentication mode to mixed mode nothing doesen't work, i created an another login with mixed mode authenitication the same error saying login falied to user sa …

hi there, i was doing some changes to the ms sql reporting server and after some time i get an error saying "the request failed or the service did not respond in a timely fashion. consult the event log or other applicable error log for details" i restarted the server …

I am having a desktop application which take the csv file and dump the data to the database. At the Page Load there is table name in the combo-box I browse the file and select the table name from combo-box and data get dump to appropriate table It working fine …

i have these two tables connected to each other [B]tblOrder[/B] ID - int (P.K.) DateTime - datetime TotalPrice - money StaffID - int OrderTypeID - int ReservationID - int (F.K.) [COLOR="Green"]can be null[/COLOR] Paid - bit [B]tblReservation[/B] ID - int (P.K.) DateTimeReservation - datetime NumberOfPeople - int DateTimeOfEvent - datetime …

Hi, I am a beginner programmer. I am trying to make a website but I cannot get the membership to configure. So I press "ASP.NET Configuration", then go into security but an error page comes up: " There is a problem with your selected data store. This can be caused …

Hi everyone, I am building a database of users for our website. It is an MSSQL database. Currently I have all the usual fields eg First Name, Last Name, email etc. There are different things that our users need to have access to on our site. At the current time …

I have a view with two tables and three fields tables are called SC011000 and SC33013 the fields are called SC01049 and SC33013 both are datetime fields. I want to make the third field show the biggest date. but i am doing something wrong I am typing in case when …

Hi, I am new to SQL and just trying to self teach myself... I have written the below script and I am recieving an error. If anyone could help this would be much appreciated... [CODE]SELECT (CASE WHEN SL_PL_NL_DETAIL.DET_NOMINALCR = NULL THEN SL_PL_NL_DETAIL.DET_NOMINALDR ELSE SL_PL_NL_DETAIL.DET_NOMINALDR = NULL THEN SL_PL_NL_DETAIL.DET_NOMINALCR END)][/CODE]

Hi How can i create a new sql database at runtime Can any one help me

Hello Everybody! My problem is connected to the SQL Server Enterprise Managager. I worked with it for a day testing a database attaching/detaching it and after I closed the Manager the following problem occured. The local database seems to be dissapeared. However, the applications through the network reach it because …

I cannot figure out why my update statement will not work? I figure it has to be something small that Im missing. [CODE] private void button2_Click(object sender, EventArgs e) { string strconn = "SERVER=15.5.7.9;User=sa;password=JFK3G785!340b;Database=addressstagingtable"; SqlConnection conn = new SqlConnection(strconn); conn.Open(); try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; …

This is my code to save values in MS access...but when i click on save it shows "INSERT INTO STATEMENT error" Plz som1 help!!!! [CODE]Private Sub save_Click() 'Text4.Text = cmbCustID.Text 'Text3.Text = cmbLocation1.Text 'Text5.Text = cboSize1.Text Dim temp As Integer 'On Error GoTo eror blnerror = False myValidation If blnerror …

Hi, I have the problem that the textfile did not appear after I saved it at my document, dekstop and other existing folder or new folder that created by user.Currently, it is only can be saved at C and D. Below is the summary: first:i want to call the value …

So, I'm a tech writer, not a database guy, but I've been asked to develop documentation for my company's databases. This means I have some questions. It seems obvious to me that there must be some SQL documentation tools out there, but I have no idea what is used for …

I keep getting an error: System.Data.SqlClient.SqlDataReader. Any idea on why this error is arising? [ICODE]using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; using System.Data.Sql; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { string strconn = "SERVER=22.3.1.9;User=CHMSE;password=18465!JFKi8nis;Database=CFOH"; SqlConnection conn = new SqlConnection(strconn); conn.Open(); SqlCommand cmd = …

my table structre like this ID nAME 1 Mumbai,Pune,Chennai i want output of name like this Name Mumbai Pune Chennai pl help m 'new to sql Thanks in Advance

Hi all, This is ridiculous they teach so much at uni except what you need to know to program :-/ haha. This is actually gonna be a 2 part question but I'll do it one at a time. So I'm developing a small program for a company, this company has …

[CODE] namespace Test1 { public partial class Form1 : Form { string emp_code = ""; public Form1() { InitializeComponent(); } private void Uploadbutton_Click(object sender, EventArgs e) { openFileDialog1.ShowDialog(); filenametextBox.Text = openFileDialog1.FileName; }//Uploadbutton_Click private void save_to_DBbutton_Click(object sender, EventArgs e) { SqlTransaction transaction = null; string servername = ""; string dbname = …

Dear Friends, I am new to sql, I have 2 tables named as payroll and employees. My payroll table has many columns as per my requirement. But I am giving here only few columns of my table.Few columns of payroll table has data in following format: empid, month, year, basicpay, …

I would like to develop a database system using ms sql server 2005 express or 2008 express edition where the data may store in other than english language into tables. so i did it using mysql database but not working in 2005 express edition. Is there any solution?

ProductID | id | TaxDescription| 2009001 | 1 | Excise 2009001 | 2 | Edu Cess on Exc 2009001 | 3 | S.HS.EduCess-Ex 2009002 | 1 | Excise 2009002 | 2 | Edu Cess on Exc 2009003 | 1 | Excise 2009003 | 2 | Edu Cess on Exc 2009003 …