713 Posted Topics
 | Can you please show what you've already coded and where you are having problems?  |
 | Re: Excel Problem You can create the same by just using an Excel file as a template. Create an Excel file, in page setup set Header "Page 1 of ?", custom footer with "Signature", and for rows to repeat at top (can be found at sheet tab) select the 1st 2 rows. The … |
| | A textchange search can take a long time, but this doesn't have to be because you are using classes or the same class for that matter. If your search is taking a while and it hapens after each keystroke, then you should either plan your search differently or replace the … |
| | Since you are working with web pages and you don't know what kind of characters you'll be storing in your db, it's wrong to use the "whatever = '" & something.text &"'" as the something.text might have single quotes (') in it. Something like this would break your select. Use … |
| | Share more info, code. I'm not sure what you are doing.  |
| | Read here: [url]http://msdn.microsoft.com/en-us/library/ms171933(v=vs.80).aspx[/url] |
| | Since you mention pulling the charger from the laptop, the 1st thing I would check is if the power socket is still soldered on the motherboard. If it's not, solder it and you should be alright. There is always the change that you've cracked the motherboard, but that's not something …  |
| | Re: DataGridView wouldn't an if between the for and the sum do the trick? [CODE]For i = 0 To Table1DataGridView.RowCount - 1 if Table1DataGridView.Rows(i).Cells(3).Value() = "True" sum += Table1DataGridView.Rows(i).Cells(4).Value() [/CODE] |
| | Perhaps you are setting something in design and changing it with your code? Can you specify what you are changing and can't see when running the program? |
| | What do you mean by report? Do you have in mind crystal reports, an excel file, something else??? |
| | So you propose OCR with a database connection? How is this going to be original? I've seen this at least in 12 different parkings, with the license plate being printed on the ticket and then being verified from the ticket when exiting. (Aha, so you plan to use the specs … |
| | You have to figure out how your dbs should be named and pass that name to Create Database. For some strange reason I'm guessing you are following a wrong path here. Can you explain again why each users output rules have to go to a different db? Wouldn't a table … |
| | I've got a good one for you, which could combine most of your interests. I would go with WMS software as a service. It's the new trend, it combines cloud computing ,DBs, distributed systems and you've got something that almost nobody in Greece knows much about. Don't blame me during … |
| | GetAsyncKeyState doesn't check clipboard, that's for sure. You monitor the clipboard contents if you want and use GetAsyncKeyState to see if the data got pasted using Ctrl+V, but I don't see how you could tell if the data got pasted by clicking the paste icon or the Edit/Paste from menus. … |
| | [QUOTE=jovillanuev;1601429]Can be incorporate to one script..(select statement) thanks for your reply.[/QUOTE] select * from (select 1 as 'abc' avg(field) from table where .... ) a inner join (select 1as 'abc',avg(field) from ....) b on a.abc = b.abc inner join ......  |
 | Do you mean update data with the ID for criteria ? PS: Although it's not the cause of your problem, you need to change this part as well [CODE] Try If SQLConnection.State = ConnectionState.Closed Then SQLConnection.Open() MsgBox("Connected...") Else SQLConnection.Close() MsgBox("Connection failed") End If Catch ex As Exception End Try [/CODE] … |
| | Depending on the database you are working with, there are a number of options (or lack of). If this is an SQL server I would handle the update/insert with a stored procedure. I believe it offers way more control and I find it easier, cleaner and less bandwith consuming to … |
| | [QUOTE=sknake;1601715]Its very difficult to understand your question. Here's my guess at what you're after: [code=sql] Declare @StartDate DateTime, @EndDate DateTime Set @StartDate = CAST(Floor(CAST(GetDate() as float)) as DateTime) --Trim off the time portion Set @EndDate = @StartDate + 1 Select * From SomeTable Where CreateDate >= @StartDate and (CreateDate < … |
| | Since you want 2 particular names to go last, I assume you know how to sort the results, but want the whole field sorted ascending and out of sort those 2 names in the bottom. I'll give you an example for 2 names hardcoded and you can modify it with … |
| | [QUOTE=chibex64;1600679]first of all, to have a matching 'user_id' with a matching 'iD' in the users table, there has to be a relationship between the two tables in order to avoid conflicts or avoid the return of nulls.[/QUOTE] Not necessarily. Null is a value and it is not always possible to … |
 | And why do you go with random number with 4 digits? Why don't you use an integer + indentity, or GUI or datetime? 4 digits mean your table can hold only up to 9999 records. If you want it to be totally random and impossible for somebody to find the … |
| | Re: Problem in text or use [CODE] if i < ListBox1.Items.Count - 1 then textbox6.text &= "," [/CODE] to insert the comma (,) character. |
| | Re: Sum() In textbox If you don't want to go with the textchanged events, you can have a timer call the calculate function. |
| | [QUOTE=doomhades666;1595330]And how can i save it to database.[/QUOTE] When do you want to save it, where and using what (as a column and as a field) as criteria for the update. If you want to create a new record (and not update an existing one) you'll need to provide with … |
| | Re: increment dates using dateadd function. Read about it here: [url]http://msdn.microsoft.com/en-us/library/ms186819.aspx[/url] |
| | Since you are new to this, a small hint: If you get lost with the nested IFs and can't tell where each else (or end if) goes to which if, it might help you to add a comment at the end of the line starting the if with a number. …  |
| | So your question is how would your app know when a sms has been received? Why don't you check the db every few secs or something? |
| | Can you show us what you are doing? I can't figure out why you would unbind. |
| | See if this will help you: [url]http://www.codeproject.com/KB/vb/Senthil_S__Software_Eng_.aspx[/url] |
| | Read here: [url]http://www.freecodesnippets.com/code/vb.net/database-ado.net/database-listview/read-data-and-feed-into-listbox-and-listview-using-oledb[/url] Scroll down to Private Sub Button1_Click and you'll find your answer. |
| | [QUOTE=mogaka;1595160]use tcp/ip protocals to connect to the remote machine. first configure sql to accept remote tcp/ip connections[/QUOTE] I can hardly see how SQL is going to help copy files. |
| | You should not have any problem as long as you specify the table.owner in your select: [CODE]select * from LCDEL.dbo.tablename select * from LCDFV.dbo.tablename[/CODE] You don't need an openrowset to read from SQL Server. Not even if they weren't in the same server (you would need to link the 2 … |
| | If you do find a way to run the code when TAB is pressed, wouldn't that mean that your code would run after every scan? Why don't you check if the text entered is equal to the barcode you plan the users to scan for finishing the data entry? Just … |
| | Since you are not providing a clear set of rules for your query, I will improvise. You can change the criteria used on your own, or provide a clear set of rules. [CODE] select a.ESN, a.TYPE,a.DATE,b.RMA from tablename a left join (select ESN, RMA from tablename where RMS IS NOT … |
| | Why are you reading into sourcepage2 and then handling lines from sourcepage?  |
| | Edit your post and remove IP Address and administrators password ASAP. Next time don't include them in any post or your problem might not matter (after a malicious attack). PS: Specify a provider on your openrowset. Read here for info: [url]http://msdn.microsoft.com/en-us/library/ms190312.aspx[/url] |
| | Why do you need a program? Doesn't it have a sleep value you can reduce and get it to go in standby mode? What model is the printer? |
| | Please post table schema for both your tables. urtrivedi is right you don't need to convert. Why are you using STR? Is this MS SQL? |
| | Like debasisdas said, yes you can. But this won't delete the record from both tables, if that's what you had in mind. It's use is to delete from grp_performance, using c.cat_name as an example. If you need to delete from both tables with 1 delete, you will need a trigger. |
| | What is itr ? I don't think that you are creating a sheet the first time around [CODE]Dim xlWSheet As excel.Worksheet = CType(xlWBook.Worksheets(1), excel.Worksheet)[/CODE] This selects an existing sheet, not adding one. This should be adding: [CODE] dim newsheet as excel.worksheet newsheet = wlWBook.worksheets.add [/CODE] PS: Use newsheet2 for a … |
 | I guess that you are looking for a particular column in your datagridview. [CODE]DataGridView1.Item(0, DataGridView1.SelectedRows.Item(0).Index).Value[/CODE] |
 | The IIS is running an instance of SQL Express, right? |
| | 1st of all your login form is weak. It can be bypassed in half a second. Try retrieving a count and verify that the count returned is equal to 1. This way even if the query is bypassed, you won't give access further down. as for changing password, copy your … |
| | You've used .\ right? Try System.Windows.Forms.Application.StartupPath |
| | I'm guessing using SqlClient.SqlConnection (That it MS SQL) won't work with MySQL. Follow the link in adatapost's message to get the mysql connector and try using that, with the appropriate connection string. |
| | [QUOTE=mogaka;1595281]I have developed a system which should be accessed remotely. the system reads sql credentials from a notepad file to authenticate to the remote sql server. however, when trying to connect, the system says: "request for odbc permission failed". but if i put the application on the client machine together … |
 | Read here to get a hint: [url]http://www.codeproject.com/KB/threads/applicationhost.aspx[/url] |
| | Mitja Bonca was adding records to the datatable with this part of code, same as with the columns. If you have the data in a dataset, you don't need to add them manually to your datatable. |
| | When you run your export code your browser doesn't show your page at all, or is it not populating your datagrid? I believe that you will need a pop-up to handle the export and leave your page with the datagrid. |
| |
The End.