[microsoft:sql-server] Forum Topics

I am new to c# so please don't laugh at me :icon_biggrin: i have a database called database1 in my program , when i create a setup file and lunch it in another computer because the database isn't attached i will get many errors , how can i attach it …

i m doing jdbc in sql server. when i have installed it then it is asking for connection. in server column what i need to write ? by default "(local)" is there and when i press connect button, it says "error reporting!!" and some description about that. what is this …

Hi I want to display the data from database, in graphical manner, Can anyone suggest an idea. for eg: Piechart for productivity of a company. Name Productivity rahul 200 ramesh 345 raj 429 Thanks

I have a ComboBox,Textbox,save button and delete button..i want to implement Model view presenter so dat the value selected in combobox and textbox are inserted into SQL database..plzz help..thanks in Advance

Guys , I have some questions 1) lets say that im developing a asp.net site using VS 2008 , how do i use sql server 2005 as the database 2) I have using MS-ACCESS as the database before and it was easy , all had to do was to create …

Hi, I am trying to create a Please Wait message in excel vba. This is to let the user know while processin some sql querry at the background which may take unkown amount of time. I would like to have it displaying in a userform. The situation is: Userform is …

I have a datagridview which allows the user to select multiple rows of a table.Now i have to take the values of one column of all the selected rows and insert those into the sql table.how do i do that?

Hi! I am usingVisual Studio 2010. I have a little problem for data binding. There are two SQL tables. 1st Products: - prod_id - prod_name - Prod_goup_id (FK) 2nd groups: - group_id - GROUP_NAME Add to a data source in the two tables. If I "throw" the products to from …

Hello guys i am little bit confuse here with the code can any one help me out .. i want max customer paid in shopping and their name i dont know that i am using right way or not but guide me here [CODE]Select sum(od.unitprice * od.quantity) as Amount, (Select …

I am planing to outsource a project to create a business application, a CRM like system. Few says C++ and MSSQL while other .net and MSSQL. I would like to know what is the advantage going with C++ The system is going to be a web based platform.

Iam developing a small school software. I want to show fees of every student of whole year. Like John(student) I want show his fees that every month he paid at what date and how much. So how should I start please help..

how to update datagridview in C# windows application. I want to update the rows in datagridview. I have 1textbox, 1gridview, and button. Before saving the data I want to make additions of textbox value and datagrid value. if i enter 20 value in textbox. the value should be add in …

[CODE]Sub retrievepic() Dim conn As New SqlConnection("data source=.\sqlexpress; integrated security=true; attachdbfilename=|datadirectory|\WAIS.mdf; user instance=true;") Dim cmd As New SqlCommand("select ImageData from ImagesStore where ImageId=@ImageId", conn) cmd.Parameters.AddWithValue("@ImageId", 3) Try conn.Open() PictureBox1.Image = Image.FromStream(New IO.MemoryStream(CType(cmd.ExecuteScalar, Byte()))) Catch ex As Exception MsgBox(ex.Message) Finally conn.Close() End Try End Sub [/CODE] This is my code for …

[CODE] protected void RefList_SelectedIndexChanged(object sender, EventArgs e) { // Define ADO.NET objects. string selectSQL; selectSQL = "SELECT * FROM Project "; selectSQL += "WHERE Ref#= '"+RefList.SelectedItem.Text +"'"; // Label14.Text = RefList.SelectedItem.Text; SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=.;Initial Catalog=Project;User ID=sa;Password=786"; SqlCommand cmd = new SqlCommand(selectSQL, con); SqlDataReader reader; …

Hi Friends, Am developing a project for a college with all basic module of creating department , Course details , Student Attendance etc....My question is I need to store Daily attendance for final report , So how can i store those data rather going to sql databse ? Is it …

Dear Team, I have a question regarding LINQ 2 SQL and data integration with textbox: I have one textbox and button on my form, one stored procedure and LINQ 2 SQL class file in my project, I want that when I hit button, my store procedure run the SQL query …

Hi, I cannot seem to figure out how to search through a created/filled dataset for a certain value which exists in column(1), returning Column(0)'s value into a textbox. My code looks like this: Dim connStringdg44 As String = "server=(local);database=Cricket;trusted_connection=yes" Dim conndg44 As New SqlConnection(connStringdg44) Dim strSQLdg44 As String = "select …

Hi All, I have one vb form with two textbox,one checkbox, and two buttons. I am using SQL Database as back end for this form. Controls of my form goes like that: 1. txtGenderID 2. txtGenderName 3. chkIsDefault 4. btnSave 5. btnCancel SQL Table as follows: Table Name: tblGender GsGenderCode …

Hello, I am getting the contents on my website from database using SQL Stored Procedure (C#). Now, I want to change the output look with XML / XSLT. How can I do this? Something like this http://forums.asp.net/t/1230093.aspx/1 but am not sure how to go about it, am new to C# …

I am having a problem with a datareader. [CODE] Do While myData.Read itmListItem = New ListViewItem() strValue = IIf(myData.IsDBNull(0), "", myData.GetValue(0)) itmListItem.Text = strValue For shtCntr = 1 To myData.FieldCount() - 1 If myData.IsDBNull(shtCntr) Then itmListItem.SubItems.Add(" ") Else itmListItem.SubItems.Add(myData.GetString(shtCntr)) End If Next shtCntr view_data.DatabaseListView.Items.Add(itmListItem) Loop [/CODE] I have used message …

Hello, I have one more question. I am connectinag to SQL Server 2008, not express, and I keep getting the "login failed for user "..."" The connection string I am using is: [CODE] Dim connStrg As String = "Data Source=" _ & ServerAdressTextBox.Text & _ ";Initial Catalog=" & _ DatabaseNameTextBox.Text …

I need to save pictures in my database, my database is MSSQL as of now, my code for getting the picture is this: Private Sub browsepic_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles browsepic.Click With dialogpic 'Open File Dialog sa toolbox .InitialDirectory = "C:\Users\CAMILLE\Pictures" .Filter = "JPG Files|*.jpg|PNG Files|*.png|GIF …

Hello :) i intend to make a game in c# that will contain information of 10,000 people i dont familiar with db yet but i guess from a little reading that the best way is to use ADO.NET sql library... the game is not on the internet, it will be …

Hello, I am creating a web server which lets me insert into a table. The user invokes the specific ID and its meant to append to the table with that ID, startdate and an enddate. [CODE] <WebMethod()> _ Public Function reserveVehicle1(ByVal vID As Integer) As Boolean Dim strInsert As String …

hi! i want to include a pie chart in my report! i have a file called inquiries in sql server 2008. the file contains Inquiry Number,Name,Date,Telephone,Email and status. The status contains information from where the customer got to know about a particular product(i.e newspapers,Friends,T.v etc) i want to generate a …

[code]public partial class Home_AlumniLogin : System.Web.UI.Page { Buildconnection c = new Buildconnection(); public string conn = ConfigurationSettings.AppSettings["dsn"]; public string str = "Data Source=S-90E1F156B1BF4\\SQLEXPRESS;uid=a;database=college"; public SqlConnection con; protected void Page_Load(object sender, EventArgs e) { } protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { con = new SqlConnection(conn); string str = "select ID1 …

hi, i have a project in my last year and have 2 queries i am using vb.net and sql server 2005 as backend first problem is, i have a search form in which a field called billno is searched and all details are displayed in datagridview but the problem is …

I am preparing a Business Management System, in which the user enters the details of purchase and sale, where item number identifies the stock availability. Suppose i purchased item1 as Business Stock, it was not in the stock, it is updated in table 4. But if it exists, i gave …

I am trying to build a login page in asp.net with sql as backend , when i enter the username and password and click the submit , nothing happens.. Please help this is my *.aspx.vb file........ Imports System.Data.SqlClient Imports System.Data Partial Class login1 Inherits System.Web.UI.Page Protected Sub TextBox1_TextChanged(ByVal sender As …

Good day people please i need your clearification here: i want to go for mcdba certification. i do not understand these category exam stuff of 70-431, 70-293, 70-290, 70-291 etc. please let someone explain for me. thank you.

Hey Everyone hope all well. I have this code that works perfectly on a mysql database [CODE]<?php // visit http://php.net/pdo for more details // start error handling try { // connect $pdo = new PDO('mysql:host=localhost;dbname=name', 'name', 'password'); // enable error handling through exceptions $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // create safe query $query …

Hi! I have a problem in Crystal Reports on VB.NET 2008. I have two GroupHeaderSection, one is grouping per Department and the other is per Section. Under the Section grouping, I have series of Summaries, i.e. EmpA, EmpB, EmpC. These summaries are the Sum of all the workOutputHrs of employees …

I am facing the problem when i m attaching the ms sql 2005 database file in win7... MICROSOFT SQL SERVER ERROR 5120

I am unable to restore .bak file in sql server 2005 ,Although i took back up from sql server 2005 and restore in the same version,its giving me an error ... does any one thing think that .bak is corrupted or whatever... please give me any remedy in that case …

We have an error on time of database attachment error 948 in ms sql server management studio 2008 what is solution of it

Hello everyone, I have been coding a Reset Login Details form, the user needs to enter the new Username, the new Password and the Current Password. Here is my code below - something in the form is not working as i am getting an error when i fill in the …

Here is the link to download my database with sample data (Management Inventory): [url]http://www.mediafire.com/?9o5ycrqot2risa8[/url] I am making a query to access redundant or missing quatity of material. [B]Report[/B] MatId CusMatName TDK NTK XTK ... . . . . . . . . with: TDK: [CODE]select detail.MatId as ID_Nhap, SUM(Quantity) as …

I am trying to filter a 2nd Combobox based on the selected value of the 1st Comboxbox. For example, when the user choses "BMW" from the cbxmanufacturer control, I need the cbxModel control to display all models associated to "BMW". I am almost there but I get an error "Cannot …

How can i convert from sql money datatype to double in c#.

heres a form i have created. its a search form. [url]http://img266.imageshack.us/img266/722/paymentsh.jpg[/url] it searches and lists the results in list view. heres my mssql query : [CODE] select transactions.trans_id,transactions.cust_id,transactions.trans_amount," _ & "transactions.trans_date,customers.fname+' '+ customers.lname as customer from transactions inner join customers on transactions.cust_id=customers.cust_id " _ & "where trans_type='inv' and (trans_id= " …

Hi, I am actually an HR consultant with minor experience in SQL, have asked our developers for help and received the query below, but it is not working - Please help!!! My Client records training for employees, these employees need to be recertified at certain dates. I need a report …

Hi, I have a simple query I've used again and again previously, but in this case it's telling me that it is too complex. I've output this sql string into a message and cannot see any problems with the syntax, I'm completely baffled with this one so any help would …

Hello everyone. Am designing a web application based on human resources. I need to perform a search which would give results as a dropdown as the searchstring is being typed( as seen in photo one) to include the photo/image of the person and little detailed description like the Name, Department …

I want to write a program in C# that will populate the fields in a database that I have created, for example... I have fields in the database such as TotalWins, Name and TotalCredits. In the C# program, I want to have users enter these values into textboxes and when …

Hi, I'm hoping someone here can give me some insight. I'm looking to do some more Microsoft accreditation and am looking at exam 70-342. There are 2 main books on the topic: Mcts Self paced training kit - the official MS press book and The real MCTS Sql Server 2008 …

I have a foreach loop package that parses through some flatfiles and imports them into a database. Instead of using a batch script to grab files only with todays date I would like the the ssis package to only parse files with some sort of getdate() function. SSIS 2005 sorry …

hello all, after tried so much now posting here. i have two programs sql.php and form.jsp. i want to do insert values into mssql database from user input form. sql.php is able to insert the values into database. i have connected database using ODBC.form.jsp is able to give user input …

I'm having a problem with using the table adapters to accomplish this and was wondering if someone might know of something I could be doing wrong. The scenario is this: Adding a new record to the underlying SQL database in this case requires that both a record exist in TableA …

I am making a DBMS using C#.Net and MS SQL. i want to display the data using crystal reports. In the Database Fields when the Database Expert wizard opens after choosing OLE DB (ADO) and then OLE DB for SQL provider, i have to give the Server, user & password …

Hey guys next question :(. Now I have having troubles with the IMAGE data type, can anyone provide examples on how to retrieve and update the image? I have tried the following: [CODE] [size=2][/size][size=2][color=#0000ff]Dim[/color][/size][size=2] imgdatastream [/size][size=2][color=#0000ff]As[/color][/size][size=2] FileStream [/size][size=2][color=#0000ff]Dim[/color][/size][size=2] imgdatalen [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]Integer [/color][/size][size=2][/size][size=2][color=#0000ff]Dim[/color][/size][size=2] imgtype [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]String [/color][/size][size=2][/size][size=2][color=#0000ff]Dim[/color][/size][size=2] n [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]Integer [/color][/size][size=2]imgdatastream …