6,934 Topics
 | |
 | Hello to all! I am facing problems in feartures of sql sever 2008. I installed it but i could not find management studio in it. then i installed managemenet studio2008 separately. but when i opened management studio then there was no interface for making database but only interface was for … |
 | Hi.. I have a big problem, hope that you can help... I have windows 2003 server with CA brightstor 11.0 (Build 2670) and is making backup to all my SQL Servers. so I need to restore a database where the MDF file is 4 GB and the LDF file 111 …  |
 | I need to update my records normal password into Md5 passwords.my query was like that UPDATE testing SET password = MD5('Manojano234') This query was working fine but i need to add plain text also  |
| | Hi Guys I am trying to select and display on the RadGrid. i am using sqlDataSource. i have 2 Tables (Users and DealerShip). User table i have attributes (UserID(pk),UserName,Email,Phoneand DealerShipID(fk)) on DealerShip table i have attributes (DealerShipID(pk),DealerShipName) and now here is what i want to do. on my grid i … |
 | Hello all, I have an MS SQL table. There are two columns I need to work on: HOURS_DURATION and MINUTES_DURATION. They are of INT type. As you may see in the photo I am attaching: [TABLE SAMPLE IMAGE](http://prntscr.com/8gzg7c) Now, I am making a fast report. And for now I have … |
| | Hello, I have a table with a filed Customers defined as int(10) I have the following query: SELECT * FROM 'table' where `Customers` = 'a' This query returns all entries which have 0 in this field, BUT a is not equal to 0 as we know? Also I can use … |
| | Ok, so right to it. int CSQLDB::Init(const char *host, const char *user, const char *passwd, const char *db) { //Init mySQL mySQL = mysql_init(mySQL); my_bool rec = 1; mysql_options(mySQL, MYSQL_OPT_RECONNECT, &rec); if(!mysql_real_connect(mySQL, host, user, passwd, db, 3306, NULL, NULL)) { printf("(!!!) mySql connection rejected!\n"); mysql_close(mySQL); return 0; } failed = … |
| | cmd.CommandText = "UPDATE tbl_System SET S_Name='" & TextBox2.Text & "', S_Function='" & RichTextBox1.Text & "', S_Failure='" & RichTextBox2.Text & "' WHERE EquipTag='" & Tbl_SystemDataGridView.CurrentRow.Cells(0).Value & "' i think this is correct format for update query but i still get error for this |
 | hello there, i have a purchase requisition table in mysql like below: pr no qty items 1 10 pencil 1 5 ballpen 1 8 eraser I would like to display them in tabular form and eventually the users should be able to edit. But my program does not assign the … |
| | hi, I want to ask about how to declare dropdownlist in vb.net. actually I'm a newbie to this vb.net language. I'm try to insert selected item from dropdownlist into database. but the data is not inserted in the table. and I've try to change the code at dropdownlist area. but … |
| | i need samples on calculating average the average of "C Program=50" "Html5=70" "DreamWaver=70" "SQL Server=80"  |
| | Please guide me. Im begginer in Sql. Im working through task tracking system in php. I need know how to display particular username details using query? Since Im getting all userdetails by single username and password.. |
| | Hi everyone, I need help in selecting between date ranges. I have two dateTimepicker and want to retrieve only records selected between selected dateTimepicker.I tried but im getting all records. I'm using SQL server database. Here is my code: selectQuery = "SELECT * FROM EmployeeRegistration WHERE EmpJoinDate BETWEEN '" & …  |
| | I have a C# table that displays sql database. It has the Id,Name and Location as fields.When the program runs it shows the name place for both name and location. here is the code public static void AddPat(string id,string name, string location) { string insStmt = "INSERT INTO PATIENT (Id,Name,Loation) … |
| | how to export asp.net(using sql server as database) project from localhost to godaddy server??please help me  |
 | Hi everyone, I have about 20 simple queries running seperately on loading a php page with mysql querying. On my localhost the page takes about 3 seconds to load but on the live server this is over 30 seconds. I'm trying to shave some time off but I'm having trouble … |
| | Greeting to daniweb I must partition by Type and rank the following datable ( called dt) by LoanAmt column with ties Type LoanAmt Rnk ==================== A 14 A 15 A 13 A 11 A 11 B 17 B 18 B 17 B 16 As a new learner, I have read … |
| | Not sure if that is the correct title, but I created an additional field in the users profile. I want to add that field with the option to change that field (its a drop down) on the main homepage as well as profile page. It would be the exact same … |
| | 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, 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 ...  |
| | I have a oracle query and i would like to run it by powershell using ODP.Net. Below is the query. set pagesize 100 set linesize 200 break on report compute sum of free_mb on report compute sum of act_size on report compute sum of used_mb on report col %used format … |
| | Im having a problem with updating data in SQLite this is the full code who execute after pressing the button try { PrintWriter writer = new PrintWriter("d:\\"+LBL1.getText()+"\\"+TL3.getText()+"_"+TL2.getText()+"_"+TL4.getText()+"_"+TL5.getText()+"_"+TL1.getText()+".txt", "UTF-8"); writer.println("Invoice Number = "+TL1.getText()); writer.println("Seda = " +TL3.getText()); writer.println("Date = " +TL2.getText()); writer.println("Documental Class = " + TL4.getText()); writer.println("Status = " + …  |
 | Hi I have firewall.log file in my c:\ driver I wonder what destination IP adresses and 3 ports the scanner have attacked most in the attack. SELECT DISTINCT dst-ip FROM c:\firewall.log WHERE dst-port !!!! I apriciate your help |
| | 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 … |
 | My web hosting plan does not include a database. Is there a way i can get around this? Like upload a .sql file or ms access db into my server and connect to it using php?  |
| | Hello, I am loking for a concept to geting started is there a way of creating a notification like on user end any one updates his post update or upload an image then on admin panel it notifies the admin like on menu bar it shows 1 and when the …  |
| | SELECT subject,GROUP_CONTACT(description)FROM assignment WHERE standard_id='1' AND section_id='61' AND assignment_date='2015-06-30' GROUP BY subject; For above query , I am facing this error , what is the mistake, Error:#1305 - FUNCTION ssv.GROUP_CONTACT does not exist.  |
| | 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. |
| | Im using this code to get image from SQLITE try{ String sql = "SELECT Photo FROM Pics WHERE InvoiceNumber=?"; pst = conn.prepareStatement(sql); rs=pst.executeQuery(); if(rs.next()){ byte[]imagedata = rs.getBytes("Photo"); format = new ImageIcon(imagedata); ImIc.setIcon(format); } }catch(Exception e){ JOptionPane.showMessageDialog(null, e); } `private ImageIcon format = null;` String filename = null; int s=0; byte[] … |
| | 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; …  |
| | 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 … |
| |  Im wondering to solve the given task but ended up in nothing.. Can someone help me on this !? Do click here for the image file for the elobarted question . [Click Here](https://onedrive.live.com/redir?resid=70CCAC35D1F2DEFA!693&authkey=!AOy2XqxgwvxJ8yM&v=3&ithint=photo%2cpng) |
| | Hi Everyone, I am a newbie to PHP programming. I just need to update the status when user click delete button. Here is the piece of code that I tried. When I echo the values of $mode and $id it prints properly. But the update query block doesn't working. <?php … |
| | 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 … |
| | 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, Good morning. In a table I show a list of names using while loop from 'name' table and textbox for each student to enter the marks. I showed two students , so two textbox fields will be displayed, and after entering marks in two textboxes, I wrote normal insert … |
| | 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 …  |
| | 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 … |
| | Moving my [Vivaldi](http://www.vivaldichoir.org/index.php) choir pages to use .php to include for common elements as per [Mayne Island Conservancy](http://www.conservancyonmayne.com) (see open question from 3 days ago) & have noticed some anomolies in IE 11. Any help would be appreciated on this and my open query on "Mobile Display" I intend to … |
| | 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 … |
 | Please help me with how i may receive an sms to my java application using ozeki. I have used sample code that i got from http://www.ozekisms.com/index.php?owpn=584 , I used that sample code and was able to send sms. Using the same code how may i receive an sms so that … |
| | 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, How to fix this error? Array ( [application] => Array ( [nama] => John [sex] => Pria [food] => Array ( [0] => ayam [1] => bebek [2] => nasi ) ) ) Notice: Undefined offset: 3 in C:\xampp\htdocs\latihan2\print4.php on line 44 latihan4.php <html> <br><br> <?php echo "Current php … |
| | Hello, I am trying to connect to sql with pdo. I wonder why it does not work? And anyone has any clue how to fix the error? Current php version : 5.6.8 Fatal error: Undefined class constant 'ERRORMODE_EXCEPTION' in C:\xampp\htdocs\latihan2\latihan4.php on line 16 latihan4.php <?php echo "Current php version : … |
 | Dear Folks ! I´m having problems with my navigation at different screensizes. At current level the navigation display is nearly the way i want it for the bigger screensizes. But at media querry @media screen and (max-width: 320px) I want the navigationlinks to stack horizontally which i managed to do … |
The End.