[microsoft:sql-server] Forum Topics

I need help. I have a search button and 2 textboxes.Textbox1 should diplay the employee id when the search button is clicked (and it works fine).But I need to automatically see the employee name in textbox2, based on the employee id on textbox1.I'd really appreciate your help. Below is my …

Hi everyone! i am currently working on a project that involves a mssql 2012 database. i have some table columns that i want to calculate and get the amount saved in the total column. And at the same time, i want to be able to display the table with datagridview …

Thank you in advance. I believe the items below should give a whole view. .Net 4.5.1 / x86 When using a SqlAdapter with new SqlParameter() { SqlDbType = SqlDbType.DateTime, ParameterName = "@FromDate", Value = "09/01/2008" }, I get the error "Conversion failed when converting date and/or time from character string" …

how to export asp.net(using sql server as database) project from localhost to godaddy server??please help me

front end vb6.0 and back end sql please send me coding with login

i would like to know if it is possible to translate my code according to a database(currently using microsoft sql server) the code i have it is encrypting and decryption on a file inside the microsoft visual studio project i want to connect it to the database this code is …

Hi All I am looking for repair tools for corrupted mdf and ldf files, ( These files beeing corrupted after i restore them using Easy Recovery Profissional after formatting c drive by mistake. ) Remark : one file of my 3 databases work perfectly when i use attach database. Any …

Hi, I have recently started working with SQL databases of which I have 0 previous experience. I have added the datasource to my project using the Visual Studio wizard and the DataSet appears in my solution explorer. Everything that I have read thus far has shown connecting to the SQL …

i am new in this encryption and decryption i would like to have my encryption appear on my database (currently using microsoft sql server) i create 3 forms : one for the registration which means when u will register, u will be able to access the 3 forms by entering …

Hi! I am facing problems with sql server 2008. I installed sql server 2008 and it was installed successfully. But when i went to start menu then only following features were displaying 1- sql server configuration manager 2- send errors and reports 3- sql server installation center. But other features …

Hi Every one >>> I'm doing visual basic program with sql server database I need to Export database to but it in my own server and connect to my prgram but i can't do it could you help me ...

Hi, I have been getting this error when doing savechanges(). System.Data.SqlClient.SqlException: New transaction is not allowed because there are other threads running in the session. I read this issue in many places and most are fixed with a .ToList() .First() or similar methods (basically not changing the object while the …

hello to all. I have used jdk 7 and now i have started to use netbeans8.0.1 i want to know that how to connect ms acces and sql server database using netbeans. Please send me procedure and sample code to connect to these two databases.

this is the code I create to import pics select image: JFileChooser chooser = new JFileChooser(); chooser.showOpenDialog(null); File f = chooser.getSelectedFile(); filename = f.getAbsolutePath(); file_picker1.setText(filename); try{ File image = new File (filename); FileInputStream fis = new FileInputStream(filename); ByteArrayOutputStream bos = new ByteArrayOutputStream(); byte[] buf = new byte[1024]; for (int readNum; …

How do I import some values from .txt files to a VB.NET DataGridView and then store them on a SQL database? I don't need all file values. I don't know how to get words after ; or ;;; or 1 SPACE or 3 spaces, and after the loop is finished …

i need some help concerning the encryption and decryption i have a login table on my microsoft sql server 2012 but i want to do the encryption and decryption remember i have 5 departments and i want to direct each username and password to a specific department form that i …

Hi there, I have have a challenge with my application. I am developing it using VB.Net and SQL server 2014. My database contains 2k plus records. I used to search and return the results very fast when the database was still small. The problem now is that whenever i try …

Im having ap roblem with this.  after I press Save button that image show up it doesnt execute this code String te1 = tf1.getText(); String te2 = TA3.getText(); String te3 = TA2.getText(); String te4 = TA1.getText(); String te5 = tf2.getText(); String te6 = TL1.getText(); String sql = "UPDATE …

i have two combobox and i have two database table in sql server 1st table name is Province and 2nd table name is City if i select province in my 1st combobox then show all cities against selected province show in the 2nd combobox when we click on combobox dropdown …

Hi guys. I am looking for a software tools that can analyse data from several sources like databases: Oracle,Mysql,Access,MsSql e.t.c and draw graphs,dashboards or other data visualisation objects. The software should also be able to read excel sheet and analyse the data and give output in variuos graphs/pie charts. It …

Am having a little problem with importing data from MS SQL to and Excel sheet. I followed previous answers on daniweb, but they couldn't help me out. Here my code. Private Sub btnExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExcel.Click Dim appXL As New Microsoft.Office.Interop.Excel.Application Dim shXL As …

hello, i am neha currently and 2 nd year It student required to do a mini project using vb as frontend and sql as backend i liked the idea of student database project can someone help me with its coding and gui screens plz its urgent only 2 weeks to …

Hi I tried connecting to my database but I am getting this message The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following: the client tried to connect to an unsupported version of SQL Server; the server …

hi i'm struggling to read data from database i created a table with 5 rows as for Login form username and password i would like to have access to forms when i enter password and username of department 1 it shows department 1 but when i enter password and username …

Hi guys, i am creating a search function on my web. This is the result [CODE]"SELECT [ROUTE], [INST_KEY], [INST_TYPE], [ACCT_KEY], [STATUS], [DMZ], [CUST_NAME], [ADDRESS_LINE1], [ADDRESS_LINE3], [ADDRESS_LINE4], [ADDRESS_LINE5], [METER_KEY], [SIZE], [INSTALL_DATE], [X], [Y], [Z], [ADDRESS_LINE2], [MI_PRINX] FROM [DBCUSTOMER] WHERE ([CUST_NAME] LIKE '%' + @CUST_NAME + '%')"[/CODE] This function just looking one …

Hi guys! I'm getting frustrated with my code because my filter in my query is not working. All of the item_model in my receiving_details table were being suggested in auto complete but as you can see in my query that I'm filtering item model with a certain form_no. Please help …

try { frmCombination.Mode = "Add"; this.Clear_All_Controls(); this.Enable_All_Controls(); if (!(this.Form_Name == "Secured Life")) ; this.btnGenerate.Enabled = true; this.btnChange.Enabled = true; this.mskReportDate.Text = Convert.ToString(DateTime.Now); ****** if (this.Form_Name == "Secured Life") this.txtQuotation.Text = Common_Functionality.GenerateId("ProdMix_Quot_No", "Secured_Life_Quotation", "").ToString(); else this.txtQuotation.Text = Common_Functionality.GenerateId("ProdMix_Quot_No", frmCombination.tblAnnorSet, "").ToString(); this.SetupDataGridView(); this.SqlQry = "select Tax_Sec_80CCC_Limit,Tax_Sec_80D_Limit,Tax_rate_Limit from Global_Parameters"; Connection connection = new …

**Hello every body,** I working an application in C# to process a log file that has a size 1 terabytes. I have to read the file row by row and insert each row in the DataBase to search in it, and I use a stored procedure. But I have a …

Hello there i m new here and new in the world of programming. I have started since 8 months on C# and Sql and i have started to make practice about programming office projects with SqlServerDataBases.My target at this moment is to feel comfortable with CodeWriting and further i want …

Restaurant | restaurant_id | names | Date | date_id | date | Time_slots | time_slots_id | start_time | end_time | restaurant_id | date_id | Reservations | reservation_id | No.of.people | time_slots_id| Relations between tables: Relation between time slots and restaurants = Many to Many Relation between time slots and date …

Server Error in '/MasterPage' Application. Could not find stored procedure 'spSearchPlayers'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure …

I have a table of names that have done something on a certain date, now this could be over and over again yet of course on different dates but never the same. I need to update a field called last_time that corresponds to the previous date that they occur and …

Hello to everyone i have a databse made up of 5 table, where 4 of the tables are linked to the fifth one by foreign keys. the tables are as follows. 1. **Client** - ClientID, ClientName 2. **Brand** - BrandID, BrandName 3. **Currency** - CurrencyID, CurrencyType 4. **RegisterShipments** - RegShipmentID, …

In the work I came up against a situation when the working database at the end of day went to the Suspect Mode. And the archive was in many hours before. To transfer it in normal mode, until isn't made repaired base it was impossible. DBCC checkdb also refused to …

I have SSRS column chart in which data of percentage complete for half day and full day is shown . The 4 legend series are half day complete,half day incomplete,full day complete and full day incomplete.Months are shown in x axis and percentage in interval of 10 on y axis …

hi programming masters! i need your help..how can i SEARCH a record in a database and display the results?? example: if i type an ID number or a name on the text box and click the search button it will look for the records and display it.. i have a …

I have uploaded an Image into database through C# application. Here is my code. FileStream fs1 = new FileStream(toolStripLableClientSelectedImage.Text, System.IO.FileMode.Open, System.IO.FileAccess.Read); byte[] image = new byte[fs1.Length]; fs1.Read(image, 0, Convert.ToInt32(fs1.Length)); fs1.Close(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "INSERT INTO tblClientDetails ([clFname], [clName], [clAddress], [clCity], [clState], [clPhone1], [clPhone2], [clEmail1], [clEmail2], [clProfession], [clPhoto]) …

My SQL2000 server crashed, and I was able to recover the data and log files. I had to reinstall from scratch after that. I found that I can use the sp_attach_db procedure to create databases on the new server from the data and log files. That recovery procedure worked, at …

Sample code: Try Dim constr As String = ConfigurationManager.ConnectionStrings("FileDBConnectionString").ConnectionString Using con As New SqlConnection(constr) Using cmd As New SqlCommand() 'cmd.CommandText = "SELECT fldControlno, fldRecno, fldFileName ,fldDate FROM tblPDSTrainzATemp where fldRecno= ('" & txtrecordno.Text & "')" Convert(varchar, fldDate, 101) ' cmd.CommandText = "SELECT fldcontrolno,fldEmpID,Convert(varchar, fldDate, 101) as [Date],fldPosition, fldSalary, fldAttachType, fldfilename,fldfiletype,fldfiledata …

Hello Everyone, it seems that I cannot see the wood for the trees.... :-) I am having problems with this line of code... StateSQL = "select * from petrol_table where fueldate >= " & "'" & M12S & "'" & " and fueldate < " & "'" & M12F & …

dear members, i need help, i have one datagrid and two dataset with two diff. tables, what i want is to insert data into datagrid and save grid data to other tabel in sql server.

Hi all ! I'm using vs2008, sqlserver2008 and vb.net as language. I would like to ask, i got this line of error when i'm debugging my code **----Too many arguments to 'Public Function getDrawingNumber(PlcCode As String) As System.Data.DataSet'.----** below is my program code : Protected Sub Page_Load(ByVal sender As Object, …

Hi, I'm using PHP, I am trying to develop: 1. a login page in HTML, once user enter the correct username and password, this will be directed to the User page. 2. In User page, there will be some text fields of the user (eg. name and address), all these …

Hello Everyone, Actually i have one question. I create one generic method like below:- public static dynamic ExecuteSelectProcedure<T>(string procedureName) where T: class { SqlDataReader reader = ExecuteSelectCommand(procedureName, CommandType.StoredProcedure); if (typeof(T).FullName.Equals("System.Data.DataTable")) { DataTable dt = new DataTable(); dt.Load(reader); reader.Close(); return dt; } return reader; } Now i want to restrict user …

hello: i was given a corrupted mdf file, the server the database (sql 2000) crashed and the only file recovered was this .mdf file. I have tried as many of the options that i can find, and still cannot get this database recovered. downloaded several of the programs that claim …

I have added month name in category field, percentage on y axis , data in series field and data has values : half day complete, full day complete,half day incomplete and full day incomplete, I have added count(Data) in data field . I am able to get the data values …

The Database ID 5, Page (1:9248), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE I am having above error on sql 2008 R2 , i have identified the table which …

Can anyone check my search code? What seems to be the problem? **ERROR: **Object variable or with block variable not set. Dim con As New SqlConnection(connectionString:="Data Source=APBIPHAP06; Initial Catalog=PMT; Integrated Security=SSPI") Dim ds As New DataSet() Dim da As New SqlDataAdapter() Dim query As String = "SELECT * FROM tblPM …

I’ve been looking and researching ASP.NET hosting provider for the past few weeks. Please kindly help me to choose the best hosting provider for me. I will be more details about my requirement below. I’m leaning towards Microsoft Azure Web but a bit concerned about the price. I will talk …

I want to add data to sql databse using vb.net form And I am new to programming :( I get an error message saying "Incorrect syntax near "deatails") Can somebody tell me the reason the following is the code I'm using Imports System.Data Imports System.Data.SqlClient Public Class Customer_Profile Dim con …