Comments by StackQ (Top 200 by date)

Totally agree +5

from your machine, you have picked wrong value to convert into datetime, check and pick correct convertible value

i told you it's an interview question, I was helpless

"row_number () over (order by 1) as roworder"-Error--> Windowed functions and NEXT VALUE FOR functions do not support constants as ORDER BY clause expressions.

but john logic:- ROW_NUMBER() over (order by (select 1)) is not creating such issue for inconsistent order.

thanks alot for help.

thanks alot for help.

thanks alot for help.

yes I know, but coz of technical issues with internet at moment, I couldn't accept other solutions

but in my opinion cross join will be not good in terms of optimization , and interviewer told me this is a table in DWH, table size is more than GB.

Gr8, today I learned -> ROW_NUMBER() over (order by (select 1)) as rowId, i was looking something by which I can generate row_number , but problem was, i dnt have another column , on the basis of which i can partition/order by. U gave me solution-> (Select 1)

there is only one column - Val, no identity column or another column is present, that's why i was not able to use row_number() over.......

yep agree with you, just when type it on notepad, it worked but when I saved my notepad file and again open it shows ?? didn't worked

♣

Any symbol in my question is not encrypted. Those are in original form. I agree with you for special fonts, but in my opinion, on few Computer I tried with ALT KEY + Numeric Keys and got these characters.
Example:- Alt + 5= ♣

Easily we can write on notepad as well. That's why I think those are not special.

I am trying to develop my encryption alog using these alt codes. And these are not special fonts. These are in built symbols ,can try with ALT + 1,2,3..... so on. But here issue is:-
1)INSERT INTO MyTable VALUES('♣') executed successfully.
2)But in table it saved as ?
3)So I am unable to retrieve it, in select clause as ♣

As well as I tried with StringToBinary, and BinaryToString, byte array but nothing worked.
private void ButtonShow_Click(object sender, EventArgs e)
{
try
{
string s1 = "♣";
s = StringToBinary(s1);
s = BinaryToString(s); //Not working here
cnn = new SqlConnection(connetionString);
cnn.Open();
string sql = "Insert into EDTable (RText) values ('♣≈Ω°±Σⁿ')";
cmd = new SqlCommand(sql, cnn);
cmd.ExecuteNonQuery();
da = new SqlDataAdapter("Select * from EDTable", connetionString);
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];

}
catch (Exception ex) { }
finally
{
cmd.Dispose();
cnn.Close();
this.Close();
}
}
public static string StringToBinary(string data)
{
StringBuilder sb = new StringBuilder();
foreach (char c in data.ToCharArray())
{
sb.Append(Convert.ToString(c, 2).PadLeft(8, '0'));
}
return sb.ToString();
}
public static string BinaryToString(string data)
{
List<byte> byteList = new List<byte>();
for (int i = 0; i < data.Length; i += 8)
{
byteList.Add(Convert.ToByte(data.Substring(i, 8), 2));
}
return Encoding.ASCII.GetString(byteList.ToArray());
}

I want to insert it as:-
INSERT INTO MyTable VALUES('♣');

may be more than 12 values, its not fixed, just an example

http://stackoverflow.com/questions/20119162/transpose-rows-into-columns-in-sql-server-2008-r2
http://stackoverflow.com/questions/13372276/simple-way-to-transpose-columns-and-rows-in-sql
http://stackoverflow.com/questions/18618951/sql-transpose-rows-to-columns

not aaceptable, coz we already used to do this, running project can't alter for BalQty, used to do it by subtracting.

thnx for help, your query almost helped me in a right way, but plz first check from ur side, is it perfectly appropriate. Becoz in practical even u don't want to write a query where there are some additional recoreds like --sysrscols
sysrowsets
sysrowsets
sysrowsets
sysclones

ERROR AT syntax:- and Year(t.addedDt)<2011 is not right showing error for 'AND' & 't'

if u r not able to run your mind just keep patience and learn.

I am not joking ok...

thax for helping me, as per my question i have got perfect answer.

But actually i am trying to find top 3 employees whose salary is maximum, without using order by, max, min, (any function).Trying to apply min max algorithm, i want to compare 1st value with all values available in that column, if any one is greater then will put in my temp variable and will compare from this new value,
Are you have any idea? by using my logic/ or your own without using sql functions

thank u so much, this time i have done it with your help, once again so many thanks :)
*****

1:-PRINT 'CREATE TABLE MYINDEX_' + RIGHT(CONVERT(VARCHAR(8), GETDATE(), 112),2)+LEFT(CONVERT(VARCHAR(8), GETDATE(), 112),6)+ ' (ID INT NOT NULL, NAME NVARCHAR(120))';
O/P is:-
CREATE TABLE MYINDEX_19201311 (ID INT NOT NULL, NAME NVARCHAR(120))

2:-EXEC 'CREATE TABLE MYINDEX_' + RIGHT(CONVERT(VARCHAR(8), GETDATE(), 112),2)+LEFT(CONVERT(VARCHAR(8), GETDATE(), 112),6)+ ' (ID INT NOT NULL, NAME NVARCHAR(120))'
/P:-
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'CREATE TABLE MYINDEX_'.

#USING SQL SERVER 2008
For EXEC Just showing incorrect syntax at CREATE, even i have tried

1:-print 'CREATE TABLE MYINDEX' + ' (ID INT NOT NULL, NAME NVARCHAR(120))'
O/P:-CREATE TABLE MYINDEX (ID INT NOT NULL, NAME NVARCHAR(120))
2:-EXEC 'CREATE TABLE MYINDEX' + ' (ID INT NOT NULL, NAME NVARCHAR(120))'
O/P:-'CREATE TABLE MYINDEX' + ' (ID INT NOT NULL, NAME NVARCHAR(120))'

So problem not with table name with syntax or wrong way.Suggest some other way...
Thanks

O/P is:- CREATE TABLE MYINDEX_Nov1920132:33PM (ID INT NOT NULL, NAME NVARCHAR(120))

1st thing it's always giving error at 'CREATE TABLE MYINDEX_', after solving it i can go ahead.

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'CREATE TABLE MYINDEX_'.

as i am getting u, so i should build all dlls of my application in x86 mode.

In my application i have used any CPU for all dlls to build. Then it should not be the problem of reference dll.

I checked it again on XP, and it's working as i expected.

yes, i have read that article,but it's for XP, right there is no version for windows 7 and 8.
Anything else??

yes, your solution is right.But i am trying to not to change the code of UC. Thanks for ur suggestion.

I not attended any interview,i m a fresher,and today, i m just exploring about .net framework,so i have some doubt,that i asked.If they r wrong just u can tell me ,u can't expect always a right question from a beginner.

thnx for ur help.

No in my opinion perhaps not, see this link:-

http://vb.net-informations.com/framework/managed_code.htm

at 2nd para line:-
The Managed Code running in a Common Language Runtime (CLR) cannot be accessed outside the runtime environment as well as cannot call directly from outside the runtime environment. This makes the programs more isolated and at the same time computers are more secure . Unmanaged Code can bypass the .NET Framework and make direct calls to the Operating System. Calling unmanaged code presents a major security risk.

appears like there is difference between them.

thnx for helping me!!!!I m trying ur code..
Ofcourse i will also not prefer to develop vehicle,but prefer to learn how we assemble vehicle...

ya we know ur train is going!!!! keep patience

thnx, u always help me,and push me to go ahead.thnx for ur support.

Now i have a new question,take a look at it:-

http://www.codeproject.com/Questions/517850/Logicplusbehindplusguidplusinplusc-23pluswindows-3

k,thnx,ya i m searching about it since 5 days,but i have not perfect solution,so finally i posted it here.

YA,i agree with u.So as u explained,this is new for me,it explore me better,Thnx

it's also working right,but it change column constraint to not null,which is not right according to my requirement.But thnx for help.+5

http://blog.sqlauthority.com/2010/11/25/sql-server-concat-function-in-sql-server-sql-concatenation/

this link helps me.

ya i got my answe:Explaining:-

In my table database(columns are dbname,connstring,financeconnstring,rptdbstring)

by my 1st query it select all connstrings but shows only for dbname and connstring,and remaining exist in background according to 1st query.

but when i run this query:-SELECT + '#VIJAY#' + FinanceConnString + '#VIJAY#' +

RptDBConnString AS ConStr FROM [DataBase] WHERE Active = 1

then it shows all the background/hidden query of financeconnstring and rptdbconnstring.

thnx for ur effort also.

no,i just want to know why we r using:- +'#VIJAY#' + FinanceConnString + '#VIJAY#' +
in my 1st query,bcoz this query is not written by me,it's written by another person,so i want to know why we r using it?

i m not getting u.But u r senior,so i agree with u,may be approach is not right,but i just want to know diff bet them? And plz help me how should i ask for this question to know diff bet them?

Ya i agree with u,and i don't like this also,i m in problem so i pasted.Frm next time i will never do this mistake.

when i build my solution this shows only 1 error:-The type 'NewJoinee.ESTextBox' already contains a definition for 'CheckMandatory'

but after sometime again showing 13 error,can u tell me solution for this problem.

Now check!!!

k

check again

r u want to store colour name or it's value?Why?Bcoz u r giving manually:-Colors.Red
Then u can do it like:-

Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
LayoutRoot.Background = New SolidColorBrush(Colors.Red)
Dim Color as String="Red" //actually what u want i m not getting
End Sub

Elaborate more,and why u want to use class?

provide code,and comment at place where u want solution.

ya,it check for alphabet and numeric character only,not symobls,i m updating only symbols,so showing error,but when i changed my alphabetic characters, it works for them,Thnx..

OK,can u send me the link:- where i will post your question in the Site Bugs forum.

actually i create it on vb.net,and for u,i convert them to vb online.So just follow logic.Thnx to suggest me...

sorry at present i m not in office,so i m unable to send u now,i will send u on monday.Bcoz it's on my office system.
ok,Sure on monday

means there are more value, whose upperlevel value='1000000001'

Select @Query1= (select TRANSACTIONID from TRANSACTIONTABLE where upperlevel='1000000001');
(select [REFERENCE_NUMBER] from TRANSACTIONTABLE where REFERENCE_NUMBER=' (select cast(@Query1 as varchar(max)))'

now check again

oh!,on the browser back button.Ok.Ok

try to export data through sqlConnection.

restart ur pc again.

Solution 1 is ur answer.

means u want to give rights?

Explain:
my problem is I need to Copy almost 10 Questions in New Table using Query.
more....

If u will use "where Qcode=101" then it will copy only one row.If there will exist more records then it copy more.
or
to copy top 10 use:-Top
To copy selected column use: Select QcCode,Description into TblName from TblName

{Actually i m not getting u what u want}

We are not here to complete ur homework.Just to push u.

ok,so create a function,put refresh code inside that function,and call that function where i specified.

may i know ur email id? to send complete project of compression or uncompression.

we bind values on pageload
{Here call for refresh!!!!!!!}
and select next pageindex after we can bind grid with another value the pageindex doesn't change

check for the appropriate event,or tell me after what process, u want to refresh ur gridview.

Give brief description about ur process:

so simple,for each value u r inserting check them,in dropdownlist,if exist not add,else add,Follow logic

ya right answer

try after ur event:UrDataGridViewNaME.Refresh();

and also check for above both link provided by Krunal and Graus.

now check all links.

Why r u reposting ur question again,Just update ur old question and post.That will be better option instead posting new one.

k,wait

what u want?xplain in words

They r just like a template ,u can make them according to u,and then u can use them many times.
Procedure is given by sir,now try to just follow yaar,not difficult.u can do.In the user control,add form's control what u want,then build ur solution,it will be visible in toolbox,when u will build them after creation.

user controls gives us more flexibility also.

really,good answer given by OriginalGriff,it's also advantages.

OK,how u uploading ur image?

TRY THIS LINK:
http://en.wikipedia.org/wiki/Database

Suppose:
Window1 contains ComboBox
Window2 contains SubmitButton (Where u r adding fruit name)
So create function to add item to comboBox, By defining public on window1
now on Window2:
create a object of window1 like->
Window1 objWindow1=new Window1();
Now on submitButton_Click Event call like below
//now call ur comboBox add functionality through object
objWindow1.UrComboBoxAdd_FunctionName();

try it and give me feedback.

paste ur code,or explain more

gud question.I also want to know?

ya,paste ur code,I m not getting u.

k

somebody down voted ur answer,i don't know why?
according to me,u have given right answer so,by me+5

Thnx for help...
i know answer,as u explained here.I just posted this question,perhaps i will get something new.But i know it's difficult,mainly in india,as u explained Kiran (I thought same,with the name kiran.It's really difficult)

But u have given me a clue by mr/miss/mrs .It can be one solution.

ya,ya it's perfect answer,now i got answer of my question,thnx.I can't vote u again otherwise i will rate again.Whatever but once again thnk u.

no,in my question,there are 3 types of name:
1st- Harish Chandra Singh (Here 3 WORDS)
2nd-Vikash Philips (BUT HERE 2 WORDS)
3RD-Mahamana Madan Mohan Malviya (Here 4 words)
so in this case where name words vary,at that condition how will recognize
(Singh,Philips,Malviya).It's my question.
If name's word will not vary then i can solve according to ur given solution and by other methods.I know.

According to above question u have given perfect answer.So by me +5 given.
But In my question help:
Suppose if name is like->
Harish Chandra Singh
and
Vikash Philips

then how will recognize title (Singh and Philips).

check for rows,greater than 65536 or not?
if greater than 65536,so u may got this error!

but perhaps,u rate me 1 !!!

u r right.

ya, Krunal is right.Explain more..

nothing?gr8 idea!!

u used &&(And) and i used ||(Or) operation.Not bad

If u will choose ur logic to encrypt then,u can decrypt with same logic even in c#,But with the existing logic like md5 or sha-1 u can't do.

sorry yaar,i don't know it with C++,otherwise i will write complete code.So i suggested u only logic.I thought u know about PreviewPane and windows Explorer in context of c++.So Update ur question again.

ok. 1st i saw ur code,and according to ur code i assume if u can write->
string s = "insert into Product(Product1,Quantity,Price,Date,Session,Month) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + dt + "','" + vv + "','" + month + "')";

this code,then u have ability to think what should change.
ok,try more,and u can learn more from this website.

latest or the version which is compatible to ur project.

ya u r right,but i think he know well how to write query.

In my opinion u have to download latest version.Because In Software Industry u have to be updated and aware with new technologies

that's not the matter in which position ur field occur.Even if it occur at 0th position,it will return,number of row=1.

there are 2 way to solve the problem of datagridview-
1st-Use DataGridView and set visibility to false. //But it's not good approach

2nd-U can replace datagridView by datatABLE,AND THEN check row.count for datatable.
3rd-If u will replace dataGridView by DataSet so same,check rows for dataset

textbox1.text=?
is it containing name of product1

oh so u want directly query to,select image form system and store them into database.

So wait,I will also wait?
Perhaps it's possible?I don't know

ok,k, so plz wait for much better answer.I m sure,just after few minutes some of more experienced people will answer u.And ur problem will solve.

here "restart" means as i gave solution,then at last choose restart service on right click

Just so simple yaar,click on restart,if not happen then might be other problem,wait for more experienced answer.

u can manually start the services of windows.

below i write the code to convert ur image to byte array format.

1st u have to declare type "image" of that column where u want to store them.Then u have to convert ur image file to byte format,store it to byte array,and now insert/update to ur database.

ok,If VS2008 Then On dataGridCellClick event make a query like-

string Query,PersonName,JobType;
PersonName=dataGridView1.Rows[e.RowIndex].Cells["PersonName"].Value.ToString();//here u will get person name to query for this person
Query=" Select Job from UserList where PersonName='" & PersonName & "'";
SqlDataAdapter DA=new SqlDataAdapter(Query,UrConnstringName);
DataSet ds=new dataset();
DA.fill(ds);
JobType=ds; //here u will get Programmer for the person (or for which row u clicked)
now
set
ur dropdownThing.defaultVALUE=JobType

ok,so in case of vs2010 i don't know,bcoz i m not using vs2010.Well see other answer.Or search another event which is used like cellClick in 2010version.

not right.

u can user saveFileDialog which will give more flexibilty to user at download time.

ya u can show ur table's data to gridview.

urGridView.datasource=dt; (dt is the table where is ur data)

Here each time when u will click on cell,each time new value will be store into ur dropdown.

oh sorry it's for local ip address.

u should read this article,It will help u

http://www.codeproject.com/Articles/23673/DNS-NET-Resolver-C

DON'T forget to add namespace.

ok,try and learn

i agree with Graus

ya

like at the button click event-
urDataGridName.datasource= UrDataSourceName

r u statified?

Sure,it will work

it's really not working,wait i m trying,if success then i will share

wait

+5,not only for this,bcoz u always help me,and sometimes angry on my stupid activity.

:)

ok,thnx ..

k, I agree with u.But we can see in many sites suppose we forgot our password then they ask our security question and if correct then,they send our password to our registered emailid or anywhere(Here they not reset password)(It means either they store our password as we input or if store in any other form (encrypted) then perhaps they will decrypt it and then send us).

Or You can suggest me some other ways->how can i send user password without resetting if user request through forgotPassword link.

see my improve question and suggest me some more format to add comment.

see my improve question and suggest me some more format to add comment.

i know about datetime.now muchbetter.I have an application which reads sms from my handset.So here in my system it shows the date of sms,when i received it in above format,so i have to save this date in my database same but without +22,but i don't want to use splitting method.I want to convert it in the format (yyyy-mm-dd hh:mm:ss) only

so u have to give a textbox where user will input how many check box he wants to check,then set this value at greater than > (as user specify)

with my logic after the value of checkboxCount++, u can check it in if-else condition and if,it's value is greater than >2(what u want u can put 2,3,4...) then show error else nothing.

it's okay

it's perfect answer

AT UserControl right click on every textbox then-go to properties then-see Modifiers change it to public

as here i m selecting .doc file through openfiledialog,u can select image file instead it.It will work for any type file.Hope it will help u

SELECT 1stColumnName,2ndColumnName,3rdColumnName into database2.tableName from database1.tableName;

3-tier architecture ..but in which field,in dbms,stroage,or .net

ok,try.. gudluck

u r using asp.net code at ExportDataSetToExcel,but i don't know anything about asp.net ,so it's difficult for me, but i can give u logic to save in 2 sheets

here remotefile=http://www.w3schools.org//
and localfilename=application.startupath+myfile.html

can i assign them like this?

right

here logic is same as i m doing, and one thing,it's bye asp-net. plz yr give right answer only mention in my question heading (using c#)

can u help me with some programming logic? it will be better for me.

ofcourse, i was also thinking, how it will be possible,bcoz these are 2 diff network. but i thought may be there will be option for it,but thnx ....it's really not possible

means u want to check this column for each value of column dayid,and if there is value like (1,2,3....) then replace it (1 replace with monday,then 2 with tuesday and so on) and if there is already (monday,tuesday,3,4) then only want to replace 3 and 4 with their respective values. m i right?

Showing error ----(error is)--->

Msg 102, Level 15, State 1, Line 8
Incorrect syntax near '>'.
Msg 156, Level 15, State 1, Line 11
Incorrect syntax near the keyword 'else'.

:) ya i agree with u.

perfect answer.But one problem in case suppose input is address-My House no-01, distt-Newyork, pin-896547, India (so in this case the program removes(',' and '-' character),is there any solution to print , and - value.

but thnx for helping.....

this one is best suit for me.Thnk u so much

excuse me ,with talking in a polite manner i am accepting my mistake,so how you can blame me rude, it's not right

ok I agree with u,but now help me in this question once again, it's my request to you, if u can help me in this show plz tell me,with some code or logic,

Is there any problem with u? I m getting for more answers it will explore me and I can gain much, is this not right to learn? why I m here?

i m saying that if,my every line length will be suppose 11 character,so there are some problem occur to print-( I want to play football and I want to play chess.)
1st line will take 11 character which will be(I want to p),in 2nd line will print(lay footbal) and so on.So here u can see play divide into 2 words p and lay,again football is dividing in 2 words footbal and l,so this is a problem.I want if this type of situation occur then complete word should be start from next line,as i want then 1st line will be(I want to) then 2nd line will be(play) and in 3rd line (football) and so on.

thnx..

can u tell me a best dll resource editor name,by which i can edit everything of a dll file

ya i know this is illegal,but i just want to learn,not for any commercial purpose.

Is there any way without using third party tool,so plz tell me.I don't want to use any other dll except default.

no its not working for pdf files.It creates but when i m open it manually showing error-

in this line when i m using extension-.pdf or .xps then file creates but when i m opening it manually showing error
writeStream = new FileStream(Application.StartupPath + "Raaz.pdf", FileMode.Create);

thnk u so much.It's working .And i have successfully completed my activity.

both type,input file may be in (.doc or .docx)

ok.

if u can solve this problem through delegate,so plz provide me solution through delegate.

i have a UC Component, in which i have taken a textbox(UserControl.TextBox1.Text).In my Form1 i m using 2 UserControl(UserControl1 and UserControl2).I want the code through which text of UserControl1.TextBox1.Text should show in UserControl2.TextBox1.Text,simultaneouly as i m entering values in UserControl1.TextBox1.Text.

In brief-
1-Suppose i have to write ME,so first i will enter M in UserControl1.TextBox1.Text(here i m entering the values in UserControl1.TextBox1.Text but it should also show in UserControl2.TextBox1.Text) like (on the keypress event of textbox1 --textbox2.text=textbox1.text)

help on my this question-http://www.codeproject.com/Questions/462895/Value-of-textbox1-should-show-in-textbox2-on-every

wait,i have a question,i m working on it since 3 days,but unable to find the solution throught code project and myself,plz help me. U can see my question through the link-
http://www.codeproject.com/Questions/462895/Value-of-textbox1-should-show-in-textbox2-on-every

ok,ok,i m getting u. thanks,bcoz u always help me.thnx a lot

Original Griff,i want to know,what u have edited here,if u have done any changes,so plz tell me,it will be beneficial for me

is this not right?and if i m right,so why u delete it?

i have submitted my solution,u can see this,it's working,but i m using
pictureBox1.Width = e.ProgressPercentage * 10;
so according to progress my picturebox load like 10%,then 20% and so on,but i don't want to use here picturebox,if i will be able to use picture.width=e.progressPercentage*10
then it will be so nice.than i mean.And one thing i m using backgroundworker,progressbar.But I only want to use track bar.

just wanna learn,bcoz i m beginner.I m learning C# since 2 months.I have done it,the step is that 1-I m loading the complete image into picturebox,then except picture,i m showing picture box according to track bar.But if i can do it through picture,so it will be so nice.

ok ,i m trying

how,can u guide through code,coz i have no idea,about this concept,i m learning C# since 2 months.

not working bcoz this is not simple textbox,this textbox is in user control UI component.U should see once again my updated question.

THERE is not the textChanged event bcoz this is not simple textbox,this textbox is in user control UI component.

how can i do it,bcoz i m a beginner ,so can u give me some idea or guide through code,i have also pasted my user control and forms code.

----------------------------------------------------------------------------------------------
1-Form1.cs code

Collapse | Copy Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace TxtBoxAutomation
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void ucTxtBox1_KeyPress(object sender, KeyPressEventArgs e)
{
ucTxtBox1.textBox1.Text = ucTxtBox2.textBox1.Text;
}

}
}

2-UCTxtBox.cs code-

Collapse | Copy Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace TxtBoxAutomation
{
public partial class UCTxtBox : UserControl
{
public UCTxtBox()
{
InitializeComponent();
}
}
}