Comments by A94 (Top 61 by date)

Is asp.net 5 and mvc 5 same?

I am using notepad. The error occurs when I click on "save" button in Employee Class.

but I am only retrieving id and storing in rid and based on that I am updating the record and I want to only update title and description

Ok I have split the line using readline() method. but how to get the first word

But only the attachment is encoded in base64. Suppose if there are multiple accounts being used such as yahoo, Hotmail then how to change the email and password. that is why I have used variable to store password.

I have used correct values that are registered with gmail

Ok I am developing a news website and for uploading the details with image I am using database and also storing image into it. So for inserting image into database I am converting it into array of bytes using convertImage() method defined above and below the other two code blocks are of retrieving the image from database and displaying it on website. The first code block is retrieval using data-adapter and other with datareader. With the above comment that you have made that "you are using output from convertImage and an SQL INSERT statement" then how to insert and retrieve image from database? can you help me with other code?

A blank cell. And if the code that is posted above is of retrieval than how to insert it into database.?

img1 is the "ID" for Image Control in ASP.NET. Code that saves the Image in Database is below:
------------------------------
byte[] arrImg;
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack )
{
loadCategory();
}
}

protected void btnSave_Click(object sender, EventArgs e)
{
convertImage();
try
{
SqlCommand cmd = new SqlCommand("Sp_Insert_News", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@title", txtTitle.Text);
cmd.Parameters.AddWithValue("@description", txtDescription.Text);
cmd.Parameters.AddWithValue("@cid", ddlcat.SelectedItem.Value);
cmd.Parameters.AddWithValue("@img", arrImg);
cmd.Parameters.AddWithValue("@ddate",txtDate.Text );
con.Open();
cmd.ExecuteNonQuery();
con.Close();

}
catch(Exception ex)
{
Response.Write("Error:" + ex.ToString());
}
}

It means that the image does not appear in Image Box in ASP.NET and that the code that converts image into bytes is above named "private void convertImage()"
and the datatype that hold image in DB is "varbinary(MAX)" and the code that is used to retrieve image is also above-One with Data Adapter (SportsMain()) and other with Data Reader

Then how to compare the priorities of the threads and put the thread to sleep which has higher priority and determine if it alive or not

I tried the above code (i.e doing it by executing 2 queries). But it inserts only the last checked employee. for example , suppose I check empid 1 and 2 then I will store the record of 2nd id(i.e, 2) and not the first one. I want both...

But where to add. In procedure or in code that you have suggested above.

Thank You. But how to update "mark_attendance" procedure as it is used to insert data of the attendance.Is there any other alternative.Please suggest

First of all the records as fetched in datagrid using stored procedure when the form loads. I have added a functionality by which a record can be searched by using the id. When the user enters id, the record should be searched in datagrid and it should be displayed using LINQ...

Yes It is occurring at "com.Connection=con"

OK, I understood. But which data type should I use to enter binary number of any length(i.e I should convert binary number of any length to its appropriate type)

Can you help me to understand the above line of code. Please.

yes...I tried

I mean some columns like id,name,designation,salary..

But I am getting error : An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. Unclosed quotation mark after the character string ''.

no.

Ok. but how to change the connection string that matches that version of SQL server. Also it is a standalone desktop application (ie my project)

But how to change the connection string to refer to the computer with the production SQL server instance installed on it since different pc have different version of SQL server installed.

But when deploying the application the database will also get installed (ie "EMSDB.mdf") and other related files that is required to run it. So, is SqlLocalDB required on other PC ?

Ok I improve my question

In above connection string the operation of insert,search etc works fine. But when I run application on different pc it gives error. So how to setup correct path. Any Idea

But for standalone application is parameterized query needed.

Thanks.

Thanks. I got It. But What about Stored Procedure. or Both are same ( i.e Param. query and stored procedure)

Normal query- "select * from database1 where id=" & txtid.text & ""

Thanks. But what is the difference between normal query and parameterized query
And again Thank You..!

Please can you help me to understand this code. And thank you very much.

Then how should I write the non-parameterized part. for ex : where empid=@empid
Is the way should I go with ?

dr(16) id the location where image is stored in varbinary type but how to convert back to image and load into picturebox

Thanks It Worked...!!!!

But I have taken Pic as" Image (Datatype) "in SQL database

Thanks. Are there any third party components that is free, for developing attractive win-forms and also how to resize form controls according to different screen resolution (ie, when screen resolution chages the form controls should resize accordingly) ?

But when I added a database in solution explorer using add new item menu it show only "Service Based Database" which has ".mdf" extension. So, should I go with it.

Which extension is SQL Server Compact Edition database file created?

Thanks...

are you sure?

Its ok. That's right I have to make basic decisions. Thank you

There are 3 users of this system(ADMIN,EMPLOYEE AND MANAGER) but when creating a table should I create one table for all of the user( mentioned above) as there is only one admin to manage the system. So How can I distinguish login based on the type of user(ie ADMIN,EMPLOYEE OR MANAGER)? Thanks in advance.

Yes it is a homework but how should I compare reservation type of both functions...that is the problem...Can you help...

OK! I have updated the program and sought out prime numbers from array but how to delete them and display new array please help....

Hey..! is Maths required for software development and if required what type of maths is required for ex: calculus,discrete or algebra please tell...

yes 2,5,7,11 and so on are prime numbers but how to remove it from array..

Still getting en error that : Date should have zero or one argument"

I have implemented operator overloading using friend function where d1-/+ invokes the function and 1 is passed as an argument.IS copy constructor required...

Ok..! I have solved it myself..thanks a lot...!!

ok i agree it takes time and also agree that its a simple problem but since for two days i was trying to solve other functions in the code and i have fixed it too but i think there is a problem in display function...!

I have been trying since two days...and also this is my home work.however i am learning it myself.And as far as clue is concerned i'll provide to you.. so if data is 1,2,3,4,5 it will display 1 and 5 not 1,2,3,4,5...

this is not my homework but i was just trying to workout finding the difference and my intention was not to make you write the whole program but was to suggest me the correct solution.And if you think that it is my mistake for asking a question and I am sorry for this because i think that by asking question only you can learn and gain knowledge and also by trying to solve it.

I agree with you but i am having test and our teacher told to complete the programs by tomorrow.But due to lack of Time i did not able to work an all of them i could complete only 6 of 10 programs.please help...!