Comments by Vedat Ozan Oner

Vedat Ozan Oner 19-Jul-14 5:39am View

as far as I understand you try to keep a connection open as long as your application runs. this is not a good approach. open a connection when only you need it.

Vedat Ozan Oner 19-Jul-14 5:28am View

see this: http://msdn.microsoft.com/en-us/library/bb387098.aspx

Vedat Ozan Oner 18-Jul-14 17:06pm View

it depends on your xyz.ksh script implementation. send it here by using 'improve question' and let's see what happens in it.

Vedat Ozan Oner 18-Jul-14 17:03pm View

I think you have to map your music folder to a web folder. open IIS manager (of course if it's your web server), right click on your website then add your physical mp3 folder "c:\.." to a virtual folder. But I'm not sure, just test it.

Vedat Ozan Oner 18-Jul-14 16:56pm View

that is great :) from now on, I will embed music into my answers :)

Vedat Ozan Oner 18-Jul-14 16:47pm View

It would be better if you could provide some code sample to talk about on it :)

Vedat Ozan Oner 2-Jul-14 5:54am View

many options. see here: http://msdn.microsoft.com/en-us/library/ff650862.aspx

Vedat Ozan Oner 1-Jul-14 15:02pm View

you can check out my article here: http://www.codeproject.com/Articles/776132/Service-based-Arduino-Data-Logger. it's beyond your need, but I think it helps.

Vedat Ozan Oner 1-Jul-14 13:23pm View

any serial terminal is enough for your need. you don't have to write code to communicate with arduino in your case. arduino ide includes a serial communication tool with arduino and you can use it.

Vedat Ozan Oner 29-Jun-14 11:23am View

INFO is null. therefore, when you try to access it, you get this error. ensure that you set INFO.

Vedat Ozan Oner 25-Jun-14 8:41am View

why? :)

Vedat Ozan Oner 25-Jun-14 6:45am View

collect all data in a list. then send this list to your save method. if your list is too big to hold in the memory, then you can process a record as soon as you fetch it from the html page. many many options.

Vedat Ozan Oner 25-Jun-14 6:38am View

do you your service up and running? have you tested it?

Vedat Ozan Oner 25-Jun-14 5:24am View

to solve it, you have to provide your code, obviously :)

Vedat Ozan Oner 23-Jun-14 15:05pm View

http://www.connectionstrings.com/

Vedat Ozan Oner 23-Jun-14 14:58pm View

Can you test it with Arduino.h? I don't get any error with your code. ( having paste errors corrected & function declarations mocked)

Vedat Ozan Oner 18-Jun-14 6:48am View

Activity monitor may help: http://technet.microsoft.com/en-us/library/ms191199%28v=sql.105%29.aspx

Vedat Ozan Oner 18-Jun-14 6:36am View

you need to start from the beginning: http://www.asp.net/get-started/websites

Vedat Ozan Oner 18-Jun-14 6:33am View

see here: http://msdn.microsoft.com/en-us/library/system.datetime.aspx

Vedat Ozan Oner 18-Jun-14 6:31am View

as I said, it can be anything. nobody can know without seeing all your code. the best thing is to use the debugger. learn how to use it, then you can have better understanding of what happens without a need for another person.

Vedat Ozan Oner 18-Jun-14 6:23am View

ok, then it is not a bug, but I count it as hidden bug because default behavior must be 'true' since it is easy to fall into pit as we see in your case.

Vedat Ozan Oner 18-Jun-14 6:09am View

you are definitely wrong.

Vedat Ozan Oner 18-Jun-14 5:21am View

this link contains all information you need: http://msdn.microsoft.com/en-us/library/tzwewss0%28v=vs.110%29.aspx

Vedat Ozan Oner 18-Jun-14 5:18am View

many possibility. your text may not contain the pattern you expect. the text you try to split may not be the text you assume, etc. best, use your debugger to see what happens.

Vedat Ozan Oner 18-Jun-14 4:48am View

:) 5!

Vedat Ozan Oner 18-Jun-14 4:45am View

you should know how. because it (objGetLocalDL) is your implementation. if not yours, ask to whom implemented this 'data layer'.

Vedat Ozan Oner 18-Jun-14 4:39am View

what do you mean by 'not working'? which part doesn't work? you can use your debugger. f9 breakpoint. f10 step over etc.

Vedat Ozan Oner 18-Jun-14 4:36am View

set border color to backcolor of your textbox.

Vedat Ozan Oner 18-Jun-14 4:34am View

can you explain more about where you stuck?

Vedat Ozan Oner 2-Jun-14 5:05am View

this is nothing with version of anything. if you share your code, I can probably give you some idea. but better, you can use your debugger. you are assuming something exists while it doesn't. (check for NULLs).

Vedat Ozan Oner 2-Jun-14 5:00am View

can you explain more? giving an example would be helpful.

Vedat Ozan Oner 2-Jun-14 4:58am View

right. it compiles. I think I'm getting old :( I don't mean since c99, but forgetting things :)

Vedat Ozan Oner 1-Jun-14 12:49pm View

Ok, then you can change 'else' part in the tick handler. you can rewind progress bar and it never stops until you manually stop it. if you like, I can update the solution.

Vedat Ozan Oner 1-Jun-14 12:45pm View

does it compile? I don't expect it because of 'char strng2[k];' since 'k' is not a constant value.

Vedat Ozan Oner 30-May-14 4:23am View

it is nothing with behaviors. error says what it is. your service doesn't implement the contract specified in configuration file. possibly, some namespace issue, or simply a typo. can you post the service implementation.

Vedat Ozan Oner 22-May-14 13:44pm View

why don't you use typed datasets? you get such head aches just because of not coding in a type-safe manner. you have a dataset designer in the IDE which makes the life better, safer, easier and you don't use it. I really can't understand.

Vedat Ozan Oner 22-May-14 12:33pm View

Simply I don't know. But I think you have just found a bug in odp.net. Congradulations :) you should report it to the odp.net development team. Before reporting it would be better to check if there exists any option about date time format for bulk insert.

Vedat Ozan Oner 22-May-14 3:34am View

oops, that is bad. because that means you are inserting year 1420 actually, not 2014 as expected. that is weird since this conversion is handled by odp.net driver. you can try to insert one by one instead of bulk insert to see what happens when you do so. another option, you can set datetime value as formatted string like dr["dt_date"] = System.DateTime.Now.ToString("yy/MM/dd HH:mm:ss"); assuming that your oracle default datetime format as in the date format string. but that is really weird.

Vedat Ozan Oner 21-May-14 16:00pm View

what do you get if you convert it to the list as var q = (....).ToList();

Vedat Ozan Oner 21-May-14 6:55am View

you are welcome

Vedat Ozan Oner 21-May-14 4:00am View

you have a bug in your method where your service stops and you have to debug it. I cannot know the solution without any code. I don't think you have an error in your config file since you can reach it at least one call. what I would do is to separate business logic code from service implementation and debug them separately to locate the error more easily.

Vedat Ozan Oner 20-May-14 15:37pm View

can you tell me what you get when you run select to_char(dt_date, 'YY') from tb_dates

Vedat Ozan Oner 20-May-14 15:30pm View

it is not a generic error. it means the endpoint you trying to connect doesn't exist. you said the second trial fails. I think your first call put the service into faulted state. successive calls will fail. therefore, you must have a bug in that method which makes your service faulty.

Vedat Ozan Oner 18-May-14 16:59pm View

I couldn't understand what you are trying to do.

Vedat Ozan Oner 18-May-14 8:35am View

thanks

Vedat Ozan Oner 16-May-14 2:40am View

actually that is an interesting question, but I try to understand the motivation behind it. why do you ask such a question about what can't be done? you use a language to do something. not 'not to do' something. yes, you can find 'to do' set by negating 'not to do' list, but you can ask 'to do' set directly :) the next question after that question would be 'why', which makes more sense in terms of understanding the background of the design. for example why not to use a static type parameter with a generic class. this may lead to another good talk.

Vedat Ozan Oner 13-May-14 9:20am View

please see my solution (comparison part).

Vedat Ozan Oner 13-May-14 8:47am View

actually it is better to tell microsoft about that example, because it causes confusion.

Vedat Ozan Oner 13-May-14 8:42am View

:) ok, then I don't agree with microsoft :p if you check that example carefully, you will see that the sql command has two different parts in the command string. the first one is for insert, the second is for reading an id. ExecuteScalar method is used to read the second part which is a query returning a single scalar value: "SELECT CAST(scope_identity() AS int)".

Vedat Ozan Oner 13-May-14 7:49am View

what happens on that line?

Vedat Ozan Oner 13-May-14 7:44am View

ExecuteScalar returns resultset[0][0]. therefore not for insert statement. see here http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar%28v=vs.90%29.ASPX

Vedat Ozan Oner 6-May-14 5:11am View

error says what happened. use the debugger to find where you get this error. https://www.google.com.tr/#q=object+reference+not+set+to+an+instance+of+an+object

Vedat Ozan Oner 6-May-14 4:07am View

I have updated the solution and code samples. you can now compile and run it.

Vedat Ozan Oner 5-May-14 17:21pm View

I think someone doesn't like my solution because of 'separation of concerns' :) yes, in terms of 'separation of concerns', this example is not good. it would be better to implement serialization issues in another class and let that class handle all serialization concerns. but you can still see how to serialize/deserialize objects in that example :)

Vedat Ozan Oner 5-May-14 9:28am View

have you done anything to share with us?

Vedat Ozan Oner 5-May-14 7:25am View

You are welcome

Vedat Ozan Oner 3-May-14 9:55am View

which version of ide do you use? and can you create a simple form without any alteration and see what happens? I don't see any problem with my test form.

Vedat Ozan Oner 1-May-14 12:28pm View

https://www.google.com.tr/search?q=sqlconnection+example

Vedat Ozan Oner 1-May-14 5:09am View

see here: http://msdn.microsoft.com/en-us/library/system.security.cryptography.md5%28v=vs.110%29.aspx

Vedat Ozan Oner 1-May-14 4:44am View

I am not sure but possibly you do this in one project (project A) and in another project (project B), you only add a reference for that project (project A). (this was assumption part)
If you add the EF 6.1 reference (NuGet) in project B, you will see the error cleared. I hope :)

Vedat Ozan Oner 29-Apr-14 13:08pm View

you are welcome

Vedat Ozan Oner 29-Apr-14 5:05am View

ok. updated the solution

Vedat Ozan Oner 29-Apr-14 3:52am View

actually I didn't test c# code. there are some obvious blanks in it. But I've checked command string (insert statement) for mysql. it worked on my table (mysql 5.5). if you test this statement on your table, and then embed it in c# code, I think it will do what you want.

Vedat Ozan Oner 28-Apr-14 15:16pm View

thank you. you're right about your comment. I just tried to show a solution with 'File.Exists'. But, I will update it as you indicated.

Vedat Ozan Oner 28-Apr-14 15:12pm View

I have updated my answer. Please see it.

Vedat Ozan Oner 28-Apr-14 14:42pm View

moreover mysql, not mssql

Vedat Ozan Oner 25-Apr-14 3:39am View

you are welcome.

Vedat Ozan Oner 16-Apr-14 5:48am View

I would still prefer dependency injection in terms of SOLID principles. don't depend on concrete classes, instead use abstraction if you want loose coupling. MVC is of course good pattern when you think of 'separation of concern's. but I don't think Windows Forms is appropriate enough for MVC. maybe you could check WPF, which is a good example for modern UI design infrastructure.

Vedat Ozan Oner 14-Apr-14 8:57am View

yes, it is possible. but you have to be careful with your design. if you're stuck somewhere, that indicates a design issue.

Vedat Ozan Oner 1-Apr-14 7:32am View

if you don't have to use .net remoting, wcf is advised by msdn. see http://msdn.microsoft.com/en-us/library/kwdt6w2k%28v=vs.85%29.aspx

Vedat Ozan Oner 30-Mar-14 4:33am View

:) what are you trying to do?

Vedat Ozan Oner 28-Mar-14 5:24am View

if you send your code, we can talk about it.

Vedat Ozan Oner 18-Mar-14 17:45pm View

yes right but what I try to say is that, for example, I want to run "RunYourCodeHere" for (about) every 5 minutes. but let's say "RunYourCodeHere" takes time between 1-3 minutes. then it runs every 6-8 minutes, not 5 minutes.

Vedat Ozan Oner 18-Mar-14 16:54pm View

thanks for the explanation. I haven't ever used (thought) backgroundworker as in your sample. this is very useful. but what happens if "RunYourCodeHere" method takes a long time compared to "thread.sleep"? I think the aim determines which technique is better to use.

Vedat Ozan Oner 18-Mar-14 9:28am View

Why?

Vedat Ozan Oner 18-Mar-14 5:21am View

:) I implemented that algorithm as the final project. I would share it but unfortunately it was very long time ago and I lost it (possibly somewhere in a CD). maybe you know, but the idea is to construct a dictionary for binary sequences. use short key for a long repeating series, and add new key (longest) for a new sequence. (or something like that :))

Vedat Ozan Oner 18-Mar-14 5:11am View

that part of your code should work as much as I understand. But I'm updating my solution to find missing numbers in a series.

Vedat Ozan Oner 18-Mar-14 4:31am View

can you share that part of the code?

Vedat Ozan Oner 18-Mar-14 3:47am View

can you explain more? what do you mean by 'run website to another computer'?

Vedat Ozan Oner 18-Mar-14 3:42am View

you have to parse this text file. since it is not in a standard format (like xml), you cannot use standard libraries. you have to write your own.

Vedat Ozan Oner 18-Mar-14 3:39am View

1- read xml file.
2- until end of xml, check if it is ordered by ID or not.
if you stuck at some point of your code, you can ask it here again.

Vedat Ozan Oner 18-Mar-14 3:33am View

Possibly.

Vedat Ozan Oner 17-Mar-14 10:30am View

:) agree

Vedat Ozan Oner 17-Mar-14 10:25am View

very vague question. what is your aim? if you want to do something which is time-dependent (like scanning something periodically), then you have to use some kind of timer mechanism. else you cannot do that. at least, you can use another application to trigger your service. but then that application has to use timer.

Vedat Ozan Oner 17-Mar-14 10:12am View

ok, I tried to say similar things, but I think open to discussion. "Solution 3" is parallel to what I said, therefore deleting my answer.

Vedat Ozan Oner 16-Mar-14 9:55am View

what do you mean online, offline? dll & online usage & offline usage?? irrelevant.

Vedat Ozan Oner 15-Mar-14 8:18am View

server means something that serves something. therefore when you install a wcf service on a machine (with necessary configuration for remote connections), it becomes a server.

Vedat Ozan Oner 13-Mar-14 11:07am View

you're welcome :)

Vedat Ozan Oner 13-Mar-14 10:32am View

then you have just found your solution. by including user group in your query, you can direct user to an appropriate page according to his/her group. therefore you don't need two separate methods like 'full' or 'trial'.

Vedat Ozan Oner 13-Mar-14 9:20am View

I couldn't understand. Can you explain more what to do?

Vedat Ozan Oner 13-Mar-14 6:36am View

have you asked google?

Vedat Ozan Oner 13-Mar-14 6:26am View

all this must be joke.

Vedat Ozan Oner 13-Mar-14 5:57am View

AllowFullOpen property supports what you want, I think. If you open the link of ColorDialog, you will see that there are many options provided.

Vedat Ozan Oner 12-Mar-14 10:13am View

I couldn't understand. Is that a question?

Vedat Ozan Oner 12-Mar-14 5:15am View

why don't you use http://msdn.microsoft.com/en-us/library/system.windows.forms.webbrowser%28v=vs.110%29.aspx

Vedat Ozan Oner 12-Mar-14 5:09am View

yes, you can change its name but every node needs a name in a valid xml. moreover, every xml needs a root node. I used the list as root node but altered its name.

Vedat Ozan Oner 7-Mar-14 7:49am View

please use comment area for your comments.

Vedat Ozan Oner 7-Mar-14 7:44am View

still not right. there is no such thing in C, vectors, templates etc.

Vedat Ozan Oner 7-Mar-14 7:41am View

google it first.

Vedat Ozan Oner 7-Mar-14 7:37am View

no. that is not right. we are using C.

Vedat Ozan Oner 7-Mar-14 7:36am View

I couldn't understand what exactly your problem is.

Vedat Ozan Oner 7-Mar-14 7:33am View

:) your homework will be completed today part by part.

Vedat Ozan Oner 7-Mar-14 7:12am View

this is not a solution, use 'Comments' area.

Vedat Ozan Oner 7-Mar-14 7:11am View

google it first.

Vedat Ozan Oner 7-Mar-14 7:06am View

what is the problem exactly? what do you intend to do at which point? what do you get?

Vedat Ozan Oner 7-Mar-14 6:36am View

it is no different from any other control. if you know how to use DevExpress GridView, you can create an instance at runtime and set its properties, handle its events etc. first try this, then if you get stuck at some point, we can discuss it here.

Vedat Ozan Oner 7-Mar-14 6:30am View

do you know this? http://htmlagilitypack.codeplex.com/

Vedat Ozan Oner 7-Mar-14 5:43am View

that is a very weird question. because if you are able to encrypt and write into excel file, I can easily assume that you can also decrypt and read it. you shouldn't need any help. If you have an error in your code, send it and let's see together.

Vedat Ozan Oner 7-Mar-14 4:58am View

google it. you will find your answer.

Vedat Ozan Oner 7-Mar-14 4:57am View

I think it is related to this: http://stackoverflow.com/questions/19748878/entity-framework-migrations-error-using-visual-studio-2013

Vedat Ozan Oner 6-Mar-14 3:40am View

google answers this question in 0.35 secs: https://www.google.com.tr/#q=How+to+create+.exe+from+Installshield

Vedat Ozan Oner 6-Mar-14 3:38am View

google answers this question in 0.35 secs: https://www.google.com.tr/#q=how+to+create+a+xml+schema+file+of+gridview+dataset

Vedat Ozan Oner 6-Mar-14 3:37am View

google answers this question in 0.35 secs: https://www.google.com.tr/#q=How+to+start+SharePoint

Vedat Ozan Oner 6-Mar-14 3:33am View

google answers this question in 0.34 seconds: https://www.google.com.tr/#q=How+to+use+Microsoft+datagrid+in+visual+c%2B%2B+2010.

Vedat Ozan Oner 6-Mar-14 3:31am View

google answers this question in 0.32 seconds: https://www.google.com.tr/#q=how+to+use+accordion+using+jquery+in+asp.net+including+css+stylesheet

Vedat Ozan Oner 6-Mar-14 3:30am View

google answers this question in 0.34 seconds: https://www.google.com.tr/#q=How+Do+I+Create+A+Crystal+Report+Using+The+Datas+In+The+Gridview

Vedat Ozan Oner 6-Mar-14 3:29am View

google answers this question in 0.34 seconds: https://www.google.com.tr/#q=error+code+500+IIS

Vedat Ozan Oner 5-Mar-14 14:47pm View

have you seen this: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/sqldev_migration/msaccess/migrate_microsoft_access_otn.htm

Vedat Ozan Oner 5-Mar-14 14:45pm View

google answers this question in 0.34 seconds: https://www.google.com.tr/search?q=How+Can+I+Create+A+Web-Server+On+My+Computer+To+Publish+A+Website+Online

Vedat Ozan Oner 5-Mar-14 14:43pm View

google answers this question in 0.24 seconds: https://www.google.com.tr/search?q=how+to+create+simple+MFC+Modal+dialog+box

Vedat Ozan Oner 5-Mar-14 3:21am View

see here: http://technet.microsoft.com/en-us/library/ms186724%28v=sql.105%29.aspx

Vedat Ozan Oner 5-Mar-14 3:05am View

null

Vedat Ozan Oner 5-Mar-14 2:42am View

google answers this question in 0.29 secs: https://www.google.com.tr/#q=migrate%20from%202005%20to%202008%20sql

Vedat Ozan Oner 5-Mar-14 2:37am View

google answers this question in 0.19 seconds: https://www.google.com.tr/search?q=how+to+show+the+image+from+database+to+picturebox+in+c%23

Vedat Ozan Oner 5-Mar-14 2:34am View

google answers this question in 0.12 seconds. https://www.google.com.tr/search?q=toolbar+backcolor

Vedat Ozan Oner 5-Mar-14 1:43am View

google answers this question in 0.34 seconds: https://www.google.com.tr/search?q=how+do+i+get+connection+string+in+.net+framework+4.0+using+in+c%23

Vedat Ozan Oner 5-Mar-14 1:39am View

thank you, all. trying to help.

Vedat Ozan Oner 4-Mar-14 17:02pm View

this question really took attention :)

Vedat Ozan Oner 4-Mar-14 9:30am View

why don't you use this? http://msdn.microsoft.com/en-us/library/system.windows.forms.webbrowser%28v=vs.110%29.aspx

Vedat Ozan Oner 4-Mar-14 9:19am View

see here: http://msdn.microsoft.com/en-us/library/windows/desktop/ms644990%28v=vs.85%29.aspx

Vedat Ozan Oner 4-Mar-14 8:26am View

what have you tried?

Vedat Ozan Oner 4-Mar-14 8:11am View

first google for the error. try to understand what it means. it is very easy and fast (returns over 100.000 results in 0.27 secs) https://www.google.com.tr/search?q=An+error+occurred+during+the+compilation+of+the+requested+file#q=An+error+occurred+during+the+compilation+of+the+requested+file%2C+or+one+of+its+dependencies

Vedat Ozan Oner 4-Mar-14 8:05am View

there are many questions&answers exactly the same with your question in codeproject. moreover there are many articles about the subject. please search them first.

Vedat Ozan Oner 4-Mar-14 7:50am View

updated.

Vedat Ozan Oner 4-Mar-14 4:44am View

I don't think this is a solution, because killing an application doesn't mean to forbid it to be started while running OP's application. you have to monitor periodically to see if started again, which may not still solve the actual question.

Vedat Ozan Oner 4-Mar-14 4:33am View

CheckBox in here: http://msdn.microsoft.com/en-us/library/system.windows.forms.checkbox%28v=vs.110%29.aspx

Vedat Ozan Oner 4-Mar-14 4:31am View

see articles in codeproject. there are many.

Vedat Ozan Oner 3-Mar-14 14:32pm View

yes. winform. I didn't write all steps:
1- interop.excel -> saveas(temp.csv)
2- ado.net bulk insert(temp.cvs)
3- ado.net insert unique raws to real table.
4- check them (with user)
or some other combinations :)
since OP doesn't provide any code, I've just provided a possible solution.

Vedat Ozan Oner 3-Mar-14 11:28am View

:) I think there is a misunderstanding here. OP tries to register a dll, not a service. confused questions?

Vedat Ozan Oner 3-Mar-14 10:56am View

you can use your debugger to find the problem without waiting an answer. put breakpoints with F9, start with F5 and go line by line with F10.

Vedat Ozan Oner 3-Mar-14 10:32am View

there are many points here. first you should define an array to hold number of days for each month. if you want to take account of a leap year, then number of days becomes meaningless, because without knowing specific year (2012) you cannot talk about leap year. assuming that there is a specific year in the problem, then you should update #of days for February for leaps years. therefore I agree to Stefan_Lang.

Vedat Ozan Oner 3-Mar-14 10:10am View

OK, maybe it would be better to read its documentation for special cases. if you can't still solve, you may get help from the forum of that article.

Vedat Ozan Oner 3-Mar-14 10:06am View

send your code, then let's talk about it.

Vedat Ozan Oner 3-Mar-14 7:48am View

I couldn't understand what your problem is exactly.

Vedat Ozan Oner 3-Mar-14 6:52am View

yes, because by doing that, you try to get access beyond your allocated memory which may cause (most probably) undesired results.

Vedat Ozan Oner 3-Mar-14 5:23am View

yeah, you're right.

Vedat Ozan Oner 3-Mar-14 4:55am View

yours is still better. I've just showed another way.

Vedat Ozan Oner 3-Mar-14 4:34am View

it happens (mostly to me :p)

Vedat Ozan Oner 3-Mar-14 4:11am View

it is not good to store a date info as varchar !!

Vedat Ozan Oner 3-Mar-14 2:54am View

you are welcome :)

Vedat Ozan Oner 3-Mar-14 2:52am View

search google with 'How to provide security for the configuration file SSIS'

Vedat Ozan Oner 3-Mar-14 2:50am View

so? :)

Vedat Ozan Oner 3-Mar-14 2:47am View

Maciej is right.

Vedat Ozan Oner 3-Mar-14 2:42am View

set ddlUserType datasource as '_UserTypeInfoList'

Vedat Ozan Oner 3-Mar-14 2:30am View

see the documentation of the control.

Vedat Ozan Oner 3-Mar-14 2:28am View

search google with 'how to solve isnull () in SQL'

Vedat Ozan Oner 3-Mar-14 2:19am View

What have you done? Where did you get stuck?

Vedat Ozan Oner 3-Mar-14 2:18am View

search google with 'I want access database from another system, how to write the connection string.'

Vedat Ozan Oner 3-Mar-14 2:17am View

it is hard to answer this question since it is quite ambiguous. if you ask it partially (like 'I did this, code is that, but this part doesn't do what I want. It gives .. error. It does this which is not that I want'), your chance to get an answer rises.

Vedat Ozan Oner 3-Mar-14 2:09am View

what have you done? where did you get stuck?

Vedat Ozan Oner 3-Mar-14 2:07am View

see here: http://www.vesic.org/english/blog/winforms/full-screen-maximize/

Vedat Ozan Oner 3-Mar-14 2:05am View

what have you done? Where did you get stuck?

Vedat Ozan Oner 3-Mar-14 2:04am View

what have you done? Where did you get stuck?

Vedat Ozan Oner 3-Mar-14 1:44am View

if your db is properly designed (ie. primary keys, foreign keys etc), then this query should work. But I think one of the tables has no row, therefore your 'inner join's returns no row. check your table relations, keys and try to select from each table one by one. after you find the table without any record, you can fix it. And more important point, I advice you to read mysql reference carefully to understand what joins and other relational db concepts. you should know these things as a software developer.

Vedat Ozan Oner 2-Mar-14 13:48pm View

it (#ifdef _WIN32) is closed. just below getchar_unlocked definition.

Vedat Ozan Oner 2-Mar-14 13:34pm View

you can join with other tables. http://dev.mysql.com/doc/refman/5.0/en/join.html

Vedat Ozan Oner 28-Feb-14 6:18am View

possibly, you have forgotten a ';' above it.

Vedat Ozan Oner 28-Feb-14 6:17am View

now, you can google it :)

Vedat Ozan Oner 28-Feb-14 5:29am View

have you tried to edit your project definition file (csproj)? remove all references to 'MySql.Data.dll' and add the reference again. And possibly, dll file may be corrupted itself. Clean installation may solve your problem.

Vedat Ozan Oner 28-Feb-14 5:03am View

assuming that you are talking about 'SQL Server' service, it makes sense not to be able to connect it. see event viewer (eventvwr) logs, sql server logs (which can be found in service startup parameters) to understand what happens with the service. without finding the actual cause, you cannot start the service (or you must be lucky which contradicts with Murphy).

Vedat Ozan Oner 28-Feb-14 2:54am View

can you explain your question with a sample code?

Vedat Ozan Oner 28-Feb-14 2:51am View

are you sure about the instance name? for example, when I try to connect to default instance (localhost), I'm receiving the same error since there exists no default. But when I connect to the named instance (localhost\sqlexpress), it is ok. moreover, you can try 'Windows Authentication' instead of server authentication.

Vedat Ozan Oner 28-Feb-14 2:08am View

it is written on the sql server installation pages as prerequisites.

Vedat Ozan Oner 28-Feb-14 2:07am View

have you tried connecting with ssms?

Vedat Ozan Oner 26-Feb-14 8:14am View

I'm sorry, I couldn't understand what you want exactly from me. On what part do you want more explanation?

Vedat Ozan Oner 26-Feb-14 8:10am View

you are welcome :)

Vedat Ozan Oner 26-Feb-14 1:30am View

I don't know if a direct way exists for what you want (maybe shell escape??). But actually, it can be done via os shell scripting. for example using bash:
assume that file.1 contains 'part1', file.2 contains 'part2', then:
$ echo set title \'$(cat file.1) $(cat file.2)\' > 1.plot
prepares your gnuplot script.
You can search it as 'gnuplot shell escape' as a starting point.

Vedat Ozan Oner 25-Feb-14 17:16pm View

then Sergey's answer contains what you need.

Vedat Ozan Oner 25-Feb-14 17:09pm View

what do you mean by 'client computer'? is it the client as in a software which connects remote computer (server), or your customer who buys your application?

Vedat Ozan Oner 25-Feb-14 16:04pm View

:) I think it is time to share this case with others in a new question. It would be better to hear others at this point.

Vedat Ozan Oner 25-Feb-14 14:36pm View

the error is nothing with FileRecord class.

Vedat Ozan Oner 25-Feb-14 6:08am View

Since I don't know exactly what FileRecord class is, I can't say what next, but you can try another class as your datasource type for the grid. For example, in my code, if you delete 'ReadOnly=true' line and set the grid as editable, you will see that you can edit checkbox value.

Vedat Ozan Oner 25-Feb-14 4:58am View

ok, at least, invisible checkbox problem is solved, I think :) your last error must be related to something else because in your code, you create a new object of type 'FileRecord' which is not a 'read-only' file.

Vedat Ozan Oner 24-Feb-14 15:37pm View

Did you solve the problem?

Vedat Ozan Oner 24-Feb-14 13:53pm View

because it's read-only. set ReadOnly property to false.

Vedat Ozan Oner 24-Feb-14 12:26pm View

Have you tried my example as it is?

Vedat Ozan Oner 24-Feb-14 12:07pm View

Still nothing. It should work. I have updated the solution (very similar to your code). What I advice:
1- run my code as an example to see how it goes.
2- adapt this code in your project (copy-paste my example into your code).

Vedat Ozan Oner 24-Feb-14 10:38am View

really? :)

Vedat Ozan Oner 24-Feb-14 7:56am View

If you put some code into your question related to the point where you stuck, help will come faster possibly.

Vedat Ozan Oner 24-Feb-14 7:51am View

Ok. You can use BindingSource. I updated the solution.

Vedat Ozan Oner 24-Feb-14 7:02am View

At what point did you get stuck?

Vedat Ozan Oner 24-Feb-14 6:57am View

at what point did you get stuck?

Vedat Ozan Oner 23-Feb-14 5:55am View

you can use JSON. see http://www.json.org/

Vedat Ozan Oner 22-Feb-14 15:21pm View

that is weird, because you don't refer any column named 'Label5' in this code.

Vedat Ozan Oner 22-Feb-14 11:30am View

I think I can't help anymore without more source code.

Vedat Ozan Oner 21-Feb-14 16:16pm View

I'm sorry. I think I missed a point. What do you mean by 'before setting grid.DataSource, the Selected column is correct and I can check it'? do you set it somewhere else and you succeed? You provide very little code to tell you about what happens.

Vedat Ozan Oner 21-Feb-14 9:23am View

Deleted

you can test it with grid.AutoGenerateColumns=true. add following lines just before settings grid.DataSource:

this.dataGridView1.Columns.Clear();
this.dataGridView1.AutoGenerateColumns = true;

Vedat Ozan Oner 21-Feb-14 9:10am View

you can test it with grid.AutoGenerateColumns=true. add following lines just before setting grid.DataSource:

this.dataGridView1.Columns.Clear();
this.dataGridView1.AutoGenerateColumns = true;

Vedat Ozan Oner 20-Feb-14 19:39pm View

see https://www.google.com.tr/#q=sql%20server%20stored%20procedure%20example

Vedat Ozan Oner 20-Feb-14 3:43am View

Yes, that code runs. It creates the file with the 'saveas' method. framework version is 4.5. but I think it is good with other versions. you can delete Tasks namespace since you don't need it.

Comments by Vedat Ozan Oner (Top 200 by date)