9,022 Topics
Please note, this was a request from my job. I am a SQL developer, and I've had just over 2 weeks experience with C#. I have a main thread running on another forum, but I could use as many eyes on this as possible. I have so far only had …
Okay, I know some of you are looking at that title and thinking I'm quite daft because obviously I have to have a dataadapter if I have a bindingsource. And you're right, there is a dataadapter, but it's not exposed to me. I've taken over a winforms project (attached to …
Hello, I want to make a connection to MSSQL 2008 database, using Visual Studio 2010, ASP.NET C# web site I wrote this connection string in web.config file: <connectionStrings> <add name="konekcija" connectionString="data source=.\SQLEXPRESS;Initial Catalog=Movies;Integrated Security=True;" providerName="System.Data.SqlClient" /> </connectionStrings> Now I need to call that connection on a code behind the page... …
Hi all, I need some help in how to achieve this functionality....the problem is ... I have some data in my database.On clicking 'generate invoice' , It should gather the data from the sql server and publish it to a document which the user can send it to a company.Basically …
Hello,... i usually used win7 x32 bit and i use sql server 2008 r2 enterprice in it and there is no problem , but i change my windos and installed win7 x64 on my labtop after that i try install the same sql server which i used in this system …
Hello, sirs! I have got a SQL Database on one computer and there is another computer in a local network. I want the other computer have access to SQL-Database by real time, but not able to modify it. And one more thing, is there any possibility to convert SQL-Database to …
Hi All, I would like to start a web site that build from ASP.net & C# and database using MS SQL 2008. Got any good website, source code or book recommend to me to doing this project. Thank you
this is our insertion logic. but the problem is that after inserting one record we reset the textfields to clear them.and after that if we again press the insert button it duplicate the previous record into our database.we want to tackle with this??????so that no duplicate entry should be inserted …
Ok so here's the thing, I used to read in data from an excel file and bulk copy this data into a SQL table and everything worked fine. But now, my source file changed, so now i get data from a other excel file. Both file look exactly the same, …
i am having real issues trying to build a sql string Dim SelectQry = "SELECT * FROM TblSupplierQuotes where TenderNo='" & Me.txtTenderRef.Text & "' AND KMBPartNo=" & " " & Me.lbKMBPartNo.Text & " " in SQL the TenderNo is varchar(50) = L003141T75-2012JANTEN KMBPartNO is text = 442 019 115 1 …
Hello all programmers .... need some tips which i have some issue down here... I got test the (sql1) and then the result for the records is zero (0) ...when it's run for "check manager gender" , the error appears... give me some help and i will owe u guyz …
I have two tables. One with orders and one with lines items for the orders. The line items have a unique code that relates to the line item number. When sorting on this unique code, you are able to see the order in which the item was added to the …
hi i am getting error plz error SqlConnection conn = new SqlConnection("Data Source=RAVI-PC\\SQLEXPRESS;Initial Catalog=personals;User ID=sa;password=sa;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(" select * from table_2", conn); DataSet ds = new DataSet(); da.Fill(ds, "table_1"); conn.Open(); SqlCommand SQLINSERT =new SqlCommand(); command.Parameters = "insert into table_1(ID,name,address,phone,city)values('@id','@name','@address','@phone','@city')" ; SQLINSERT.Parameters.Add(("@ID",Textbox1.Text.ToLower) SQLINSERT.Parameters.Add(("@name",Textbox1.Text.ToLower) SQLINSERT.Parameters.Add(("@address",Textbox1.Text.ToLower) SQLINSERT.Parameters.Add(("@phone",Textbox1.Text.ToLower) SQLINSERT.Parameters.Add(("@city",Textbox1.Text.ToLower) SQLINSERT.ExecuteNonQuery()
Ohayo I Hav a Doubt regarding the storage of database.. Suppose i have a college database...among Master Model Tempdb MSdb were do i store this college database??in master?? even if i create a new database how to add the new data into the existing database??
I am doing system using window phone 7 and sql server as database. I am using below coding to get shopping cart list at listbox. public List<Order> FindOrder(string custemail, string orderstatus) { var findorder = from r in order.Orders where (r.CustEmail == custemail && r.OrderStatus == orderstatus ) select r; …
Hey guys so for a class of mine we have to build a program for a client that is going to require a Database. The database is going to be purely for demo purposes so an actual server is not necessary. Now I have never done this before and I …
hello ! i am using mssql server 2008 , i have a table with three fields , 1- ProdID 2-ProdName 3-ProdPic , now i want to show the all records of the table in the datagridview by using vb.net , how can i show my image field in datagridview , …
I have completed my project with front-end as vb.net 2008 and back-end as SQL server 2005. I have to backup and restore my project in the following extensions: 1. .bak 2. .xls 3. .mdb Please tell me how can i store the backup project in my own path.
Hi everyone, In a nutshell...I have developed a site in ASP.Net and VB.Net which allows a user to create an order and submit it to a SQL Server backend database. When the order is placed...an xml file is also produced, showing the items that have been ordered...which is then loaded …
Hi, I'm trying to upload multiple image to folder and insert the image information into a database. I have been successful in being able to upload the images to the folder (thanks to a tutorial online) but when I try to add the code to insert the image information to …
CREATE TABLE Contain ( Disk_ID int NOT NULL, Artist_ID int NOT NULL, CONSTRAINT Fk_Disk_id FOREIGN KEY(Disk_ID) REFERENCES Disks(Disk_ID) ON DELETE CASCADE, CONSTRAINT Fk_Artist_id FOREIGN KEY(Artist_ID) REFERENCES Artists(Artist_ID) ON DELETE CASCADE, ) I have a Home Music Managment Database and software to work with it. I have 4 relational Tables i …
Here's the error : "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - …
Hello guys, I'm trying to learn asp.net mvc 3, but am having real nightmare with database queries :( I added a new sql server database in my project under app _data folder and created this little table where account_id is primary key and identity column. I added new ADO.net entity …
Hi guys I've been trying to connect my c# file to my database file(in .mdf format created in SQL Server Management Studio 2008). So basically I used visual studio 2008 for my C# file and SQL Server Management Studio 2008 for my database file. Now I'm sure that the naming …
I cannot connect to SQL server heres the code Dim conn As New SqlClient.SqlConnection conn.ConnectionString = "Data Source=|DataDirectory|\Books.sdf" conn.Open() '\\ Error Comes here Dim sqlcomm As SqlCommand = New SqlCommand(("SELECT MAX(ID) FROM Books"), conn) maxid = sqlcomm.ExecuteNonQuery() Error Prompts me as > A network-related or instance-specific error occurred while establishing …
Hi guys... I am developing an windows application in c# with sql server as back end with windows authentication i want username and password for sequrity purpose can i set username and password without changing it to server authentication. Thanks in advance.
Hello Forum Members, I am fairly new to programming in general and am just learning VBA for Excel and Access. I currently have a work project that involves producing a SQL query from our internal database system based on VBA procedures in an Excel template. Most of the code was …
Hi guys I've been trying to connect my c# file to my database file(in .mdf format created in SQL Server Management Studio 2008). So basically I used visual studio 2008 for my C# file and SQL Server Management Studio 2008 for my database file. Now I'm sure that the naming …
Hi Guys, My project is in Java and i am using sql server 2005 database and my requirement is as follows for database ----- sql sever is in windows authentication mode ---- suppose my database name is db1 then **can I create password for my databse db1 in windows authentication …
I have the following code Dim adoCN As ADODB.Connection Dim sConnString As String Dim sSQL As String Dim lRow As Long, lCol As Long sConnString = "Provider=sqloledb;Server=MonsterSQ1;Database=AmiCatSQL;User Id=SA;Password=123456" Set adoCN = CreateObject("ADODB.Connection") adoCN.Open sConnString 'Assumes that you have Field1, Field2 and Field3 in columns A, B and C 'For this …
Hi, Needs to construct the tables with the meta info retrived by another stored procedure I wrote, given the table id or name. There could be some flaws in the logic, not sure. The flow is - - iterate through one table which stores tbl name, id info - pass …
Can someone please help me on this problem. I am trying to send the updated changes to the sql database when I remove a row. I use the delete method to delete the numbered row through a dataview and then use the upate command to update the changes to the …
i have a big problem here when i want to insert 6 data into 6 different row in 1 click. in field @ form it have name, staff no.,items, quantity and date. We can select 6 items to insert which i use ComboBox for save the data in form. In …
i havae problem java connection with sql server 2005 in windows authentication mode my code is as follows Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection connection = DriverManager .getConnection("jdbc:sqlserver://localhost:1433;database=dbName;integratedSecurity=true;");
Hi all I'm struggling with a MSSQL database that, ultimately, I want to get into MySQL, but for now I just want to import to a local server. I know nothing about MSSQL, but I am pretty familiar with MySQL. I have a .bak file exported from my current hosting …
hi, SELECT Sum(acpt_qty),mat_code1 FROM view_mrir_esd GROUP BY mat_code1 SELECT Sum(net_qty),mat_code1 FROM view_bom_total GROUP BY mat_code1 these 2 queries are giving the actual report, but when combining these queries like SELECT DISTINCT view_bom_total.mat_code1,Sum(net_qty),Sum(view_mrir_esd.acpt_qty) FROM view_bom_total inner join view_mrir_esd ON view_bom_total.mat_id=view_mrir_esd.mat_id GROUP BY view_bom_total.mat_code1 giving the wrong acpt_qty and net_qty. Please advise …
sqlBulk.ColumnMappings.Add(new SqlBulkCopyColumnMapping("[W.C.V]", "WCV")); i'm importing excel data into sql database, a column in the excel file has special characters (W.C.V) I cannot get the code to accept the special characters; I've tried "IMEX=1" in connection string without success. It is difficult to change the column in the excel, as it …
Hello Everyone,,please help me out here.i have a problem whicn needs to be solved.. i'm creating a windows form using C# visual studio 2005 and my database is SQL Server 2005..i have a Login table inside my database. the login windows works fine.however i need a form which will let …
SELECT sum(GoodsRcpt.PurchQty) FROM GoodsRcpt where GoodsRcpt.GlsClr=" WHITE"; SELECT count(Prescriptions.SrNo)/2 FROM Prescriptions where Prescriptions.GlsClr=" WHITE"; SELECT sum(GlassDamage.DamageQty) FROM GlassDamage where GlassDamage.GlsClr=" WHITE"; Combine above three query and the equetion should be like, (result of query1) - ( result of query 2 + result of query 3) its urgent... Thank you....
I am working on Admin panel of Asp.Net Site.As usual first task in this case is of User Management.I dont know how to assign different roles to different users. i am using SQL SERVER 2005 on the back end. i dont know that either i create users from back end …
Hi Guys, My requirements: How do I get the overall average for the transaction given for every month. My Query: This is the last part of my CTE Query ) Select Partno ,SUM(Case When TransMOnth='January' Then Usage2 else 0 End) As Jan ,SUM(Case When TransMOnth='February' Then Usage2 else 0 End) …
Hi, I am building a database for an institution. However, I will love the database to intimate the operator of birthdays of those in the database using vb 2008 and sql server. My query for the sql server goes thus: select Surname, Other_Names, Mobile_Phone from Parishioner_Adults where WHERE day(Date_of_Birth) =day((GETDATE()+15)) …
I creating a small program which basically reads Electronic identity cards and stores the information in a SQL database. There is more to the program of course, but this is where i need help with. The EID has a picture from the person also. I decided not to save the …
G'day folks, My sql server 2012 database is plodding along happily with its custom online store. Yesterday it's primary key incremental column jumped from 60681 to 61678 then resumed incrementing by 1. It is now up to 61686 and chugging along again. No apparent harm done but very strange behaviour. …
i am getting "Unhandled Null referenceException "--object reference not set to an instance of an object at below mentioned code in bracket (return System.Configuration.ConfigurationManager.ConnectionStrings["unitmoduleconnectionstring"].ConnectionString) and below is the total code help me to get out of this bug.... namespace TIMS { public partial class Form1: Form { public Form1() { …
Hi, I'm quite new to Web Development. I'm creating a web site and it has a Registration Page where I managed to create the form. But when the user clicks on the 'CreateUser' button, how do I display a message on the form to show that the User is created. …
hi this is my connection string SqlConnection conn = new SqlConnection("Data Source=RAVI-PC\\SQLEXPRESS;Initial Catalog=personals;User ID=sa;password=sa;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(" select * from table_2", conn); DataSet ds = new DataSet(); da.Fill(ds, "table_1"); conn.Open(); Actually my doubt is how to insert(data entered in texbox) and delete and update view record from …
I am doing a sample program where it involves inserting data from textboxes and a Combox to SQL Server databse ... private void btnAdd_Click(object sender, EventArgs e) { da.InsertCommand = new SqlCommand("INSERT INTO Member VALUES (@MemberID, @Name, @Surname, @IDNo, @Address, @Town, @TelNo, @MobNo, @Email)", c); da.InsertCommand.Parameters.Add("@MemberID", SqlDbType.VarChar).Value = textBox50.Text; da.InsertCommand.Parameters.Add("@Name", …
Guys i am trying to make an ASP web application for a small organization. They want is that barcode reads the information of the bill which means that whatever User have taken from a grocery store, barcode reads the 1. Bill Number 2. Amount 3. Date 4. Store Name 5. …
As the title tell, i want to delete a row from a data grid view and also it updates in the sql table. I have this code so far : DialogResult dr; dr = MessageBox.Show("Are you sure ?" , "Rent Returned", MessageBoxButtons.YesNoCancel); if (dr == DialogResult.Yes) { if (this.dgvRent.SelectedRows.Count > …
The End.