Comments by Chiklu.Soumya

Chiklu.Soumya 27-May-13 2:59am View

Deleted

Try this method.......

cn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM ImageUpload WHERE ImgID='100'",cn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
string image = Convert.ToString(DateTime.Now.ToFileTime());
byte[] bimage = (byte[])dr["ImgData"];
FileStream fs = new FileStream(image, FileMode.CreateNew, FileAccess.Write);
fs.Write(bimage, 0, bimage.Length - 1);
fs.Close();
pictureBox1.Image = Image.FromFile(image);
}
dr.Close();
cn.Close();

Chiklu.Soumya 18-May-13 9:09am View

Thank you so much............. Tadit Dash.I can't express my happiness with your code. Thank you once again. Your code works perfectly. I"ll never forget your help. I added an exception to windows firewall for port no 587. Then i turned off antivirus. Finally it worked.

Chiklu.Soumya 18-May-13 4:24am View

Thannks For your reply. But your code getting this error. Please find a solution. Once again Thank You.

"System.Net.Mail.SmtpException: Failure sending mail. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: An attempt was made to access a socket in a way forbidden by its access permissions [2607:f8b0:400e:c02::6c]:587 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) --- End of inner exception stack trace --- at System.Net.ServicePoint.GetConnection(PooledStream PooledStream, Object owner, Boolean async, IPAddress& address, Socket& abortSocket, Socket& abortSocket6) at System.Net.PooledStream.Activate(Object owningObject, Boolean async, GeneralAsyncDelegate asyncCallback) at System.Net.PooledStream.Activate(Object owningObject, GeneralAsyncDelegate asyncCallback) at System.Net.ConnectionPool.GetConnection(Object owningObject, GeneralAsyncDelegate asyncCallback, Int32 creationTimeout) at System.Net.Mail.SmtpConnection.GetConnection(ServicePoint servicePoint) at System.Net.Mail.SmtpTransport.GetConnection(ServicePoint servicePoint) at System.Net.Mail.SmtpClient.GetConnection() at System.Net.Mail.SmtpClient.Send(MailMessage message) --- End of inner exception stack trace --- at System.Net.Mail.SmtpClient.Send(MailMessage message) at _Default.Page_Load(Object sender, EventArgs e)System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: An attempt was made to access a socket in a way forbidden by its access permissions [2607:f8b0:400e:c02::6c]:587 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) --- End of inner exception stack trace --- at System.Net.ServicePoint.GetConnection(PooledStream PooledStream, Object owner, Boolean async, IPAddress& address, Socket& abortSocket, Socket& abortSocket6) at System.Net.PooledStream.Activate(Object owningObject, Boolean async, GeneralAsyncDelegate asyncCallback) at System.Net.PooledStream.Activate(Object owningObject, GeneralAsyncDelegate asyncCallback) at System.Net.ConnectionPool.GetConnection(Object owningObject, GeneralAsyncDelegate asyncCallback, Int32 creationTimeout) at System.Net.Mail.SmtpConnection.GetConnection(ServicePoint servicePoint) at System.Net.Mail.SmtpTransport.GetConnection(ServicePoint servicePoint) at System.Net.Mail.SmtpClient.GetConnection() at System.Net.Mail.SmtpClient.Send(MailMessage message)System.Net.Sockets.SocketException (0x80004005): An attempt was made to access a socket in a way forbidden by its access permissions [2607:f8b0:400e:c02::6c]:587 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) "

Chiklu.Soumya 18-May-13 3:33am View

Deleted

Thannks For your reply. But your code getting this error. Please find a solution. Once again Thank You.

"System.Net.Mail.SmtpException: Failure sending mail. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: An attempt was made to access a socket in a way forbidden by its access permissions [2607:f8b0:400e:c02::6c]:587 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) --- End of inner exception stack trace --- at System.Net.ServicePoint.GetConnection(PooledStream PooledStream, Object owner, Boolean async, IPAddress& address, Socket& abortSocket, Socket& abortSocket6) at System.Net.PooledStream.Activate(Object owningObject, Boolean async, GeneralAsyncDelegate asyncCallback) at System.Net.PooledStream.Activate(Object owningObject, GeneralAsyncDelegate asyncCallback) at System.Net.ConnectionPool.GetConnection(Object owningObject, GeneralAsyncDelegate asyncCallback, Int32 creationTimeout) at System.Net.Mail.SmtpConnection.GetConnection(ServicePoint servicePoint) at System.Net.Mail.SmtpTransport.GetConnection(ServicePoint servicePoint) at System.Net.Mail.SmtpClient.GetConnection() at System.Net.Mail.SmtpClient.Send(MailMessage message) --- End of inner exception stack trace --- at System.Net.Mail.SmtpClient.Send(MailMessage message) at _Default.Page_Load(Object sender, EventArgs e)System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: An attempt was made to access a socket in a way forbidden by its access permissions [2607:f8b0:400e:c02::6c]:587 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) --- End of inner exception stack trace --- at System.Net.ServicePoint.GetConnection(PooledStream PooledStream, Object owner, Boolean async, IPAddress& address, Socket& abortSocket, Socket& abortSocket6) at System.Net.PooledStream.Activate(Object owningObject, Boolean async, GeneralAsyncDelegate asyncCallback) at System.Net.PooledStream.Activate(Object owningObject, GeneralAsyncDelegate asyncCallback) at System.Net.ConnectionPool.GetConnection(Object owningObject, GeneralAsyncDelegate asyncCallback, Int32 creationTimeout) at System.Net.Mail.SmtpConnection.GetConnection(ServicePoint servicePoint) at System.Net.Mail.SmtpTransport.GetConnection(ServicePoint servicePoint) at System.Net.Mail.SmtpClient.GetConnection() at System.Net.Mail.SmtpClient.Send(MailMessage message)System.Net.Sockets.SocketException (0x80004005): An attempt was made to access a socket in a way forbidden by its access permissions [2607:f8b0:400e:c02::6c]:587 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) "

Chiklu.Soumya 17-May-13 12:30pm View

Thankx for updating my quest. Will not commit this mistake again.

Chiklu.Soumya 17-May-13 12:25pm View

Yes I had used 465 port no. But it's getting same error. Please find error in my code. Thanks for your reply.

Chiklu.Soumya 23-Apr-13 4:42am View

Have you enabled AutoPostBack feature of DropDownList ? Turn it on and then see the result.

Chiklu.Soumya 23-Apr-13 4:20am View

Welcome..........

Chiklu.Soumya 23-Apr-13 3:48am View

Yeah...It's working. In my code change SqlDbType.Image to SqlDbType.VarBinary. It's working. By the way Thanks for your question.

Chiklu.Soumya 23-Apr-13 3:45am View

Hello... I have used this code with Image datatype in Sql server 2008,2012. Varbinary was working only in Sql 2005. Don't think it's problem using varbinary. Now i"ll try and will respond u if i succeed.

Chiklu.Soumya 22-Apr-13 12:01pm View

I need your help. Can you get me the solution. I don't know javascript. Thanks in advance.

Chiklu.Soumya 22-Apr-13 11:38am View

My query is like creating an account in gmail or yahoo for first time where a username is suggested by a lable whether typed username is available or not.

Chiklu.Soumya 22-Apr-13 11:27am View

Thanks for reply. But couldn't understand your solution. Please read my query carefully.

Chiklu.Soumya 1-Mar-13 9:42am View

Please suggest me if you know solution of this problem.

Chiklu.Soumya 1-Mar-13 9:38am View

Yes. But modified.

Chiklu.Soumya 27-Feb-13 14:05pm View

It's ok.

Chiklu.Soumya 27-Feb-13 13:46pm View

values of image1 and image2 comes from ImageCollection table.

Chiklu.Soumya 27-Feb-13 13:08pm View

It shows error when i wrote FileMode.Open.The error is "Could not find file 'C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\130064619000881758'."
When I wrote FileMode.Append it shows error "The process cannot access the file 'C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\130064617880809532' because it is being used by another process.
"

Chiklu.Soumya 20-Feb-13 11:07am View

Thanks a lot!!!!!!!!

Chiklu.Soumya 20-Feb-13 10:47am View

Chiklu.Soumya 19-Feb-13 22:08pm View

Thanks A lot. Now it's working fine.

Chiklu.Soumya 19-Feb-13 13:40pm View

it gives an error "syntax error(missing operator) in query expression 'payment.indate=income.indate INNER JOIN bank_dep on income.indate=bank_dep.indate"

Chiklu.Soumya 8-Feb-13 11:02am View

don't know it's coding...

Chiklu.Soumya 8-Feb-13 10:39am View

Don't know it's coding. Please suggest.

Chiklu.Soumya 6-Feb-13 13:26pm View

Is it possible to extract a month from specific date from datebase?

Chiklu.Soumya 6-Feb-13 13:23pm View

Is it possible to extract data from a table of a particular month by selecting any date(of that month) in calender and to display them in a gridview(table doesn't have a month column and it has column of datetime where only dates are saved.).So is it possible to get month from those dates.
Ex: CREATE TABLE Sales(productname varchar(50),quantity int,saledate datetime)
Insert: Nokia,10,02/07/2011. Can I select month from the specified date from table?

Chiklu.Soumya 6-Feb-13 12:56pm View

datetime

Chiklu.Soumya 6-Feb-13 12:26pm View

No. Error. But gridview doesn't showing any data.

Chiklu.Soumya 6-Feb-13 11:55am View

It doesn't showing any exception. It's working only when a specific date is selected.(Calender1.SelectedDate.ToShortDateString)i'm using this code. But I want it in month and don't know how to do it.

Chiklu.Soumya 19-Jan-13 12:15pm View

Thank You Very Much. It works fine.

Chiklu.Soumya 19-Jan-13 8:47am View

Dear Adriancs thank u very much for ur useful links and special thanks for the asp.net ebook link.I"m remained ever grateful to you for your kind advice.

Chiklu.Soumya 18-Jan-13 12:26pm View

Don't know how to display values using button. Please give me a full code for my convenience. Bcoz i"m completely new to asp.net.

Chiklu.Soumya 18-Jan-13 12:17pm View

Thanks richcb......Now It's working fine.

Chiklu.Soumya 18-Jan-13 11:58am View

I"m completely new to asp .net and don't know anything. Excuse my mistakes. Please try to solve my code. My requirement is:"whenever i"ll click on one or more checkboxlist there value/s will be displayed on listbox." Thanks.....

<form id="form1" runat="server">
<div>

<asp:CheckBoxList ID="CheckBoxList1" runat="server" AutoPostBack="True"
onselectedindexchanged="CheckBoxList1_SelectedIndexChanged">
<asp:ListItem>Max Payne
<asp:ListItem>Call Of Duty
<asp:ListItem>Hitman
<asp:ListItem>Shader
<asp:ListItem>Mafia

</div>
<asp:ListBox ID="ListBox1" runat="server" Height="146px" Width="134px">

</form>

protected void Page_Load(object sender, EventArgs e)
{
CheckBoxList1.SelectedIndexChanged += new EventHandler(CheckBoxList1_SelectedIndexChanged);
}
protected void CheckBoxList1_SelectedIndexChanged(object sender, EventArgs e)
{
ListBox1.Items.Add(CheckBoxList1.SelectedItem.ToString());
}

Chiklu.Soumya 18-Jan-13 11:33am View

Sorry Bro! I haven't tried ur above written code. My question was regarding individual radio button "not radiobuttonlist". My code is as of:

<div>

<asp:RadioButton ID="RadioButton1" runat="server" AutoPostBack="True"
CausesValidation="True" GroupName="radio"
oncheckedchanged="RadioButton1_CheckedChanged" Text="Male" />
<asp:RadioButton ID="RadioButton2" runat="server" AutoPostBack="True"
CausesValidation="True" GroupName="radio"
oncheckedchanged="RadioButton2_CheckedChanged" Text="Female" />
<asp:TextBox ID="TextBox1" runat="server">

</div>

protected void RadioButton1_CheckedChanged(object sender, EventArgs e)
{
if (RadioButton1.Checked == true)
{
RadioButton1.Text = TextBox1.Text;
}
else
{
TextBox1.Text = "";
}
}
protected void RadioButton2_CheckedChanged(object sender, EventArgs e)
{
if (RadioButton2.Checked == true)
{
RadioButton2.Text = TextBox1.Text;
}
else
{
TextBox1.Text = "";
}

Chiklu.Soumya 18-Jan-13 10:22am View

I tried. But didn't worked. Please give me full example with coding.

Chiklu.Soumya 18-Jan-13 10:21am View

Thanks!!! But It's working only in RadioButtonList Control. Doesn't worked on individual radio button. If you have any coding plz post.

Comments by Chiklu.Soumya (Top 37 by date)