Member Avatar
Hi, I have a filestream enabled DB and a table to store the files. Until now i used to get the path of the file that has to be saved to DB. But due to some changes this was changed and now i get a byte array. my question here …
by necrovore -2 in Databases ()
Member Avatar
what is the best way to save data from multiple checkboxes ?? if i have 50 , 60 checkboxes Is it reasonable to set up a column of 50 or 60 checkboxes for ٍsaving value for each question separately ? and presumably there are questions that have not responded what …
by aseel.jaradat.9 in Databases ()
Member Avatar
I have a multicolumn listview. There are three button Add, delete and Updata. List is working fine, it add, delete and update list data. But i want to save every row inside listview when i click save button. Bellow is my XAML. ... My add method is like ... and …
by burhanahmed92 in Software Development ()
Member Avatar
I'm using MS SQL 2012 - trying to LEFT JOIN 3 Pivots - but am running into issues within a query variable that I'm not sure how to debug. Each Pivot works on it's own - but the actual Joining is causing the issue. Any help is appreciated. First time …
by radiancebox in Databases ()
Member Avatar
Hi There, I have two computers, both connected to the internet and running Windows 7 (Home Premium + Professional). One is my main one, the other is one I do not use. If I installed say, SQL Server, on the old machine, is there a way of connecting them together …
by mattster 195 in Software Development ()
Member Avatar
Hi all , can you pls say how i able to send the email notification alert with the datas getting from Sql server 2008 using windows service . Thanks in advance
by jaga.dish.39 in Software Development ()
Member Avatar
i installed PHP version5.4.3 SQL server 2008 IIS7 SQLSRV version3.0 Drupal 7 SQLSTATE[42S02]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'watchdog'. This error occurs right after the following during Drupal 7.26 installation (shown in the error report). It hangs at the start of Install Profile: Installation tasksChoose profile(done)Choose language(done)Verify …
by ganesh641 in Web Development ()
Member Avatar
i have written this query to show total working time and overtime of an employee on particular date (if he has came) otherwise it doesn't show record for a person if his INTIME and TIMEOUT are empty but i don't want this now, i want if for a particular date …
by haymen.roth.3 in Databases ()
Member Avatar
I have text file (attached image) i need to loop and get the values (with ellipse shape )into sql table the text file record usually started with (----)
by ikrami in Databases ()
Member Avatar
i am given task to analyze and modify pre written large queries within small time, so please help me understanding it i understand first part but not exactly 2nd part:
by haymen.roth.3 in Databases ()
Member Avatar
i almost spent 3 hours on EXISTS operation, used in SQL especially with subqueries, i got its purpose :) that's ok but what i don't get is that WHY TO USE IT ? e.g. couldn't understand this example: TABLE STORES storeName----Sales-------Txn_date TABLE GEOGRAPHY regionName----storeName
by HunainHafeez 9 in Databases ()
Member Avatar
we should create a program that could run through two computers and the computers should be able to access 1 database for record sharing. how can we make that? we already made the system. the problem is, how can we implement this in a networked way? thanks in advance. :)
by ses03 in Software Development ()
Member Avatar
I am new to vb.net Pls. Can someone help me on how do to display my data saved into sql server from form1 to datagridview in form2 with vb.net. Thanks in advance.
by oluseye.ademola in Software Development ()
Member Avatar
Hey everyone, I am trying to create an excel spreadsheet that is populated with data from a table in sql server. I would like to make it so it will update several times a day with out the user having to do so. I have no clue how to go …
by jtodd in Databases ()
Member Avatar
I have to make a database system that is purely on SQL Server. It's about a diagnostic lab. It should contain at least 40,000 distinct patient records. I have a table named "Patient" which contains an auto-generated ID, Name, DOB, Age and Phone number. Our teacher provided us with a …
by moomal.razak in Databases ()
Member Avatar
I have this sql statement which only return me the facilities that are available. The problem is, I wanted it to check for the check-out time as well. Eg, A user make a reservation on 3/11/2013 10am and the duration is 2 hours. When the another user make a reservation …
by cooling in Databases ()
Member Avatar
Collapse | Copy Code int s1 = Convert.ToInt16(dataGridView1.CurrentRow.Cells[3].Value); int s2 = Convert.ToInt16(dataGridView1.CurrentRow.Cells[6].Value); int s3 = s1 * s2; dataGridView1.CurrentRow.Cells[38].Value = s3; this is working fine when i change the value lively in dataGridView1.CurrentRow.Cells[3] it multiply with the changed value with dataGridView1.CurrentRow.Cells[6] and display the value in dataGridView1.CurrentRow.Cells[38] like cell[3] cell[6] …
by sathishk20 in Software Development ()
Member Avatar
hi all. I want to fill the Listview from a mssql database in vb.net but it not show all the data in Listview. I have the followning code. Dim sSQL As String Dim lvwItem As New ListViewItem() sSQL = "SELECT field1, field2, field3 FROM tablenam e " sSQL = sSQL …
by khair.ullah -2 in Software Development ()
Member Avatar
guys i need ur help i want to insert data directly into the sql table using c# here is my code all that i have been able to do is get the values from the table not insert them i tried to do it this way but apprently there is …
by A.Muqeetkhan in Software Development ()
Member Avatar
Hi First of all i would like to say is, i am a fresher to this vb.net.. having one project in hand. But as i dont know the code for using a datagridview i am asking your help. In my sqlserver table "EmployeeDetails" we have so many columns. In that …
by zuni786 in Software Development ()
Member Avatar
Hi, I have a problem on getting data from XML file. I am honestly have 0 knowledge on this. Here is the XML data content, i opened the XML file using notepad then pasted here. And here is my sql query And it gives me this error Please help me, …
by alleybye 6 in Software Development ()
Member Avatar
Hello hi. I am seeing flames with using FILESTREAM in SQL Server 2008! I have a table (Products), in which I wanna store a link to an image stored on disk, under the ProdPicture column. This is what the script looks like: I have looked up using FILESTREAM online, and …
by sphe_g in Databases ()
Member Avatar
All, I can't seem to find a good example of how to work with databases in C#. I'm using sqlserver and I can do simple things like insert and retrieve data, but when I am retrieving data I have to refer to the ordinal index values of the columns (reader[0], …
by WDrago in Software Development ()
Member Avatar
In sql server , my query brings out more than one row of data Now i am trying to make it in a dtagrid that the datagrid shows allpossible rows that is supposed to show .This is the code so anyway to make multiple rows to show will be appreciated …
by Pamilerin in Software Development ()
Member Avatar
can any body help me by giving me a guideline on how to insert data from a populated datagrid into sql server table and how to make the values conform to the specified datatypes constructe in the sql server side...assuming the datagrid headings have already been created in the sql …
by Pamilerin in Software Development ()
Member Avatar
I am trying to learn how to make a mobile phone communicate with a server and a database. So far, I have made a web-service on my PC using this tutorial: The above tutorial makes a sortof WCF service. What would be the best Database system for me? Simplicity and …
by Usmaan 7 in Software Development ()
Member Avatar
Friends i want to submit project in my college on employee management system.... front end should be c# and back end sql server 2008... i got one project on net but its backend is microsoft access I want to change this to sql server 2008.... what changes i have to …
by deepak690 in Software Development ()
Member Avatar
Hi, I am having trouble with retrieving records on my database. My layout was this.. UsersList Username Firstname LastName Role Records TheUser ApprovedBy DateApproved The first text are the table names while the indented once are the field names. I have a table named Records. TheUser and ApprovedBy was referring …
by michaelzip in Databases ()
Member Avatar
Hi.... I am trying to connect sql server with vb.net in Visual Studio 2008 with foll. code.... but it is having problem....what is the problem? Please tell me.... 1. I created "publication" databse. In table i took 2 columns...fname and lname and fill the records... 2. I took DataGridView onto …
by deolalkar_pooja in Databases ()
Member Avatar
need to check an SQL Server database (not asp.net membership) to see if an email is already in use before allowing the user to register. I have tried using the information in this website but it does not seem to work. Your help will be much appreciated
by Seesharp in Web Development ()