Comments by Subrata.In (Top 43 by date)

Yeas, you are right. It is risky job. Actually I want to get idea about this. Specially from where I can get some information/resources (like - we can get/accept payments through any payments gateway). Who do this job? Or is there any private player who providing any API? Or it is directly manage by RBI? If it done by RBI, who can access that API?...

Thanks for your reply. I know that this may not appropriate forum for asking this question, but I do because, I notice that, here is some people who are really genius. They may work same type of project or have some idea.

Thank you vary much for your reply, and also thanks for your link. It is very help full. But sorry to say that I am not able to figure out the problem.
1. Yes, report file in correct location.
2. Data Source & Data Structure are correct and also loading data properly (I used it on GridView for checking).
3. Parameter also correct.

There is no error/exception occur. I try to figure out by step by step break point, which is given below.
ReportDocument _rpt = new ReportDocument();
-> So many exception
_rpt.Load(Server.MapPath("rpt_Demo.rpt"));
-> HasRecords = '_rpt.HasRecords' threw an exception of type 'CrystalDecisions.CrystalReports.Engine.LogOnException'
_rpt.SetParameterValue("Report_Data", "Hello! How are you?");
-> Same as above
_rpt.SetDataSource(_Data);
-> HasRecords = Function evaluation timed out. And all after this
crv_Report.ReportSource = _rpt;
-> DefaultXmlExportSelection = '_rpt.DefaultXmlExportSelection' threw an exception of type 'System.NullReferenceException'

Please Note:
a) At the time of designing I use belo table/database for preparing report :
MS OLEDB Provider for SQL Server -> A Demo Databse which store tables as per require data structure
b) On your 1st example :
rpt_Demo _rpt = new rpt_Demo()
where I use :
ReportDocument _rpt = new ReportDocument();
_rpt.Load(Server.MapPath("rpt_Demo.rpt"));

That's only the diff (I can not access rpt_Demo directly, it throwing [The type or namespace name 'rpt_Demo' could not be found (are you missing a using directive or an assembly reference?)]).

Sorry for lengthy reply.

Thanks you so much for you reply. It will help me for future...

Thanks for your reply. You are right base class method not executing. I changed : this.SelectionChanged += new System.EventHandler(this.base_SelectionChanged) -> base.SelectionChanged += new System.EventHandler(this.base_SelectionChanged)

Thanks

Hi! Is it the wrong community/platform to ask this question? Please give any suggestion where to post my question.

try this:
for (int l = 0; l < str.Length-1; l += chunkLength)
instead of:
for (int l = 0; l < str.Length; l += chunkLength)

Thanks for your response. However, i think you overlook my question. I am not trying to connect 192.168.xx.xx. My question is how to connect PC-01 to PC-A.
Thanks in advance.

Is it possible to explain more.

Thanks for your comments. In above example 116.203.188.231 is target machine ip address.
1. I think it is not mandatory that isp provide 116.203.188.231 ip for me only (it may by shared by other user also).
2. On my end i have a broadband router where 5 computer connected (Eg: 192.168.1.2 to 198.168.6). So how can i connect 192.168.1.2?

So how can i connect <116.203.188.231>.<port>.<192.168.1.2>? Or can you inform me where can I found the resource for learn how web server send data to a specific machine (browser)?

If your birth day field storing date and time then you can try:

SELECT * FROM student WHERE birthday BETWEEN '"+FromDate.ToString("dd-MMM-yyyy")+"' AND '"+ToDate.ToString("dd-MMM-yyyy 23:59:59")+"'

Store birth day without time and fetch using "dd-MMM-yyyy" format.

You are Welcome.
It's a very simple and also common problem, but it take long time to identify. Always use proper datatype else especially datetime data, store "dd-MMM-yyyy" format to avoid conversion error.
Good night.

Yes I know, for this reason I am telling to store "23-Jan-2013" format not "23/01/2013" this format. May sql server treat first two digit as month. I think if you store '01/01/2013' it will not raise any error.
So either store that format or recreate table (and drop previous table: drop table <tablename>) with datetime field.

You are inserting "dd-MMM-yyyy HH:m:s" fromat means "23-Jan-2013 1:27:30", so why it is showing 23/01/2013 18:56:27?
In normal in your data is showing correct format, but it is sure there is some wrong may there some unnecessary space or anything.
It is better you change your data type or check there is some mistake on insertions.

Insert data "dd-MMM-yyyy HH:m:s" format.
I think you are using: DateTime.Now.ToString()
Use DateTime.Now.ToString("dd-MMM-yyyy HH:m:s")

Try to insert data "dd-MMM-yyyy HH:m:s" format. Or post your insert query for the table Logindata.

Post the result of Select * from logindata, if possble post your insert query.

Check system date using:

Select GetDate()

Execute this query on query eitor:
select [UserName], [LoginTime], [LogoutTime], [Upload] as 'UploadFile', [Download] as 'DownloadFile' from logindata where DateDiff(d, Cast([logintime] as datetime),'23-Jan-2013')=0

And check what message showing. If possible show the script of that table.

It will be better to change datatype in database (in datetime by dropping and re-creating table). However, I am sure there is some wrong/junk value in logintime. Use: Select * from table name and check care fully the fields. You can post your insert query, problem may be there (inserting data in wrong format).

Still this problem not solved? It is very simple query. However please try this if not solved, try to execute this query to query editor (SQL Server) and check what message is showing.

If you change the field type to datetime:
select [UserName], [LoginTime], [LogoutTime], [Upload] as 'UploadFile', [Download] as 'DownloadFile' from logindata where DateDiff(d, [logintime],'" + YourDate.ToString("dd-MMM-yyyy") + "')=0


If you unable to change the field type to datetime:
select [UserName], [LoginTime], [LogoutTime], [Upload] as 'UploadFile', [Download] as 'DownloadFile' from logindata where DateDiff(d, Cast([logintime] as datetime),'" + YourDate.ToString("dd-MMM-yyyy") + "')=0

You can try previous query or this:
SqlDataAdapter da = new SqlDataAdapter("select UserName, LoginTime, LogoutTime, Upload UploadFile, Download DownloadFile from logindata where DateDiff(d, Cast(logintime as datetime)," + YourDate.ToString() + ")=0", con);

What is the data type of logintime? Try to change datatype as datetime. If not possible have to convert data type as datetime using cast(logintime as datetime).

Code will be:
SqlDataAdapter da = new SqlDataAdapter("select UserName, LoginTime, LogoutTime, Upload UploadFile, Download DownloadFile from logindata where month(cast(logintime as datetime))=" + YourDate.Month + " And day(cast(logintime as datetime))=" + YourDate.Day + " and year(cast(logintime as datetime))=" + YourDate.Year, con);

Sorry for my mistake there will be and before year. I modified the solution.

Just try:
cmd.Parameters.Add(new SqlParameter("PO_Date", mDT_PoHead.Rows[0]["PO_Date"]));

No require to convert to datetime, as well as there is no checking require for null.

In a single word you can't insert date in a specific format. It will manage by server and also regional settings of client system. But you can show date as your require format, before show date just format it.
On C#: use Conver.ToDateTime(Field[""]).ToString("dd/MM/yyyy")
On sql: create user define function and/or using DateName function

Fine, don't use default value. Just store Field=Null (Don't use quotation mark) id sql. When retrieving value just check for null, that's all.

If you got your answer it's ok. However your question is not clear. If it's possible give an output example.
On your loop Qid will replace current rows value, so try to use Qid+=Convert.ToInt32(dt2.Rows[0]["id"].ToString());

I think you have write code for positioning control of text bow on re-size event or else of usercontrol. So when you are trying to make change of usercontrol then child control are re-locating. So fiend out where write Left/Top/Position properties in user control. If you did not fix your problem. Write your code and mention what you want to do.

What is the code inside button click event?

Why you are not using a id field in your table?
If it's not possible to add field in your table, you can do it by temporary table/variable.

Specify in details what you want to do.

It will avoid space from both end of string. Else your picturebox may visible if user provide space.

You are right.
It will be better if you do this:
pictureBox1.Visible = (textBox1.Text.Trim() != "");//For avoiding space

Why you want this dll?