Comments by Dinesh.V.Kumar

Dinesh.V.Kumar 9-Jan-15 7:46am View

You can not directly disable a control in a view from controller. You need to pass the model to the view. Based on the model data you can enable or disable the control.
eg:
Solution 1:

Assuming User is a model
User.Status = "success";
return View(postData, User);

In view
if(Model.User=="success")
--add control set the disabled state here
else
--add control without disabled state.

Solution 2:
You can redirect to another view that shows the success message to the user so that the user cannot do anything in the previous view.

Hope this helps

Regards

Dinesh.V.Kumar 22-Sep-14 5:31am View

In order to group by you need to have a aggregate function in the select part of the query.
for eg:
Select si.Date, si.SalaryId,er.EmpCode, er.FName, sum(si.salary) from bl_EmpRegistration er,tbl_SalaryInformation si where er.EmpCode=si.EmpCode and si.PartnerName='Pio' and er.PartnerName='Pio' group by si.Date, si.SalaryId,er.EmpCode, er.FName

Dinesh.V.Kumar 31-Jul-14 2:27am View

Thanks --SA-

Dinesh.V.Kumar 31-Jul-14 2:23am View

Try replacing NVARCHAR with varbinary datatype.

Dinesh.V.Kumar 28-Jul-14 1:32am View

Thanks Champ!!For the idea.. I will take this path and see what happens..But is there any way to pass the user id and password to login to the site..?

Dinesh.V.Kumar 26-Jul-14 23:20pm View

Thanks for taking some time and replying to my query..Sorry that I was not very clear in framing the question. I will try to provide more details.
I have a windows forms and a login credentials to a website. I can login to the website and run a report. In windows forms I have a form. On clicking the button on the form, I need to internally login to the website, run the report and fetch the result of the report and display it on the windows form. I know there is a web browser control but as per the requirement I cannot use the control. Is there any way this scenario can be achieved?

Dinesh.V.Kumar 15-Jul-14 6:57am View

add the data from the form to a datatable and bind the datatable to the gridview in asp.net...If this doesnt help, please improve your question and be little specific.

Dinesh.V.Kumar 11-Jul-14 2:05am View

Order BY clause should come outside as shown below

select * from (select top 100 percent 1 as t,t1.regId, t1.visitCount
from registerdata as t1
) as yy order by t1.visitCount desc
Try this and let me know if its working

Regards,
Dinesh Kumar.V.

Dinesh.V.Kumar 27-Jun-14 9:06am View

I would suggest try to segregate the files to separate projects. You can add a new solution to the website. Then add a new project. Segregate the class files that are common. Then create a new project - Windows Service. Reference the dll of the common project in the windows service.
I think this will be ideal for you as it can be managed easily.

Sorry for the delayed reply.

Regards,
Dinesh Kumar.V.

Dinesh.V.Kumar 26-Jun-14 5:16am View

I Suppose you can do that. Just put it in a separate project. Create a Class Library, add that to your service and try invoking those methods.

Regards,
Dinesh Kumar.V.

Dinesh.V.Kumar 26-Jun-14 2:30am View

Could you please be specific on what is that you need to achieve?

Dinesh.V.Kumar 26-Jun-14 2:07am View

Use a windows service for this purpose. You can configure the service to run at any specified time to send the email.

Regards

Dinesh.V.Kumar 20-Jun-14 1:36am View

Try the below

string selectedItems= string.Empty;
foreach (ListItem item in CheckBoxList1.Items)
{
if(item.selected)
selectedItems=item.selected.value + ",";

}

selectedItems = selectedItems.Remove(selectedItems.Length-1, 1);

PS : I am not sure of the syntax, but you can use this logic...Try and let me know if its working..

Dinesh.V.Kumar 18-Jun-14 3:15am View

Did you check the firewall?

Dinesh.V.Kumar 17-Jun-14 2:37am View

Kindly provide little more information on where you are facing problem..Paste code if possible so that we can help you in a better way!!

Regards,
Dinesh Kumar.V.

Dinesh.V.Kumar 17-Jun-14 2:17am View

What kind of question is this???Please use this forum only if you are facing any problem in your code. These kind of questions does not help you nor will it help us help you. If you are facing any problem frame your question properly and post it..

Regards,
Dinesh Kumar.V.

Dinesh.V.Kumar 16-Jun-14 7:05am View

I am not sure but are you able to ping to the smtp.gmail.com. There could be some network issues.
Please check if network connection is alright.

Regards
Dinesh Kumar.V.

Dinesh.V.Kumar 12-Jun-14 1:35am View

Try troubleshooting by following some of the steps mentioned in this link given below
http://msdn.microsoft.com/en-IN/library/ms137625.aspx

Regards,
Dinesh Kumar.V.

Dinesh.V.Kumar 12-Jun-14 1:32am View

Is there any error that is thrown?Could you please check that and let me know so that we can narrow down the issue.

Regards,
Dinesh Kumar.V.

Dinesh.V.Kumar 12-Jun-14 0:52am View

Check this site..
http://www.codeproject.com/Articles/20923/Mouse-Position-over-Image-in-a-PictureBox
I am not sure if this will help you. Just let me know if it helps. If not I will try to find some other solution

Regards

Dinesh.V.Kumar 11-Jun-14 8:36am View

Either you are not in the same network as send.one.com is in or there is a mistake in the host name provided by you. please check the host name and verify if it is correct.

Dinesh.V.Kumar 9-Jun-14 1:42am View

There is a site which will help you convert c# code to vb.net. just google it and you will get it. You can copy paste the code in the site and it will convert c# code to vb.net.

Dinesh.V.Kumar 21-May-14 2:33am View

What is the problem you face? Please elaborate.

Why dont you try Adding Group.

Dinesh.V.Kumar 13-May-14 5:23am View

Pivot is the only solution..

Dinesh.V.Kumar 29-Apr-14 4:55am View

Dont move all the variables to session...Just move the User Information to Session.
Check if Session("UserName") contains any value. If it doesnt exist then redirect to login page.Put this code in the page load of each page in your application.

Dinesh.V.Kumar 29-Apr-14 3:27am View

Try keeping the user information in session rather than application variables.

Dinesh.V.Kumar 16-Apr-14 2:49am View

Your question is not clear enough..Kindly use "Improve Question" widget and give more information on what is that you want and what you have done so far and where you are stuck..

Dinesh.V.Kumar 15-Apr-14 6:17am View

did you replace @User name in both the places in your code?

Dinesh.V.Kumar 15-Apr-14 4:52am View

Instead of @User name change it to @Username and check...

Dinesh.V.Kumar 15-Apr-14 2:49am View

What is the error you are getting?

Dinesh.V.Kumar 9-Apr-14 8:44am View

Thanks once again Raul!!!

Dinesh.V.Kumar 8-Apr-14 13:03pm View

Thanks for you suggestion Raul!!This gives me some thing to work on...

Regards
Dinesh Kumar.V.

Dinesh.V.Kumar 8-Apr-14 9:14am View

Try Dev Express Grid Controls...There are quite a lot functionalities..and hope fully would have added a few more to the existing ones..

Regards
Dinesh Kumar.V.

Dinesh.V.Kumar 7-Apr-14 3:24am View

Thnx a lot buddy!! :D

Dinesh.V.Kumar 3-Apr-14 8:40am View

I can still do it...if you will upvote for me...I will summarize all the steps in to one solution...

:D

Regards,
Dinesh Kumar.V.

Dinesh.V.Kumar 3-Apr-14 7:42am View

Am glad that what ever solution I have provided for you has worked...I was not exactly sure on the windows authentication part..but then the link has helped you and also has helped me through you...I will also keep the points you have mentioned above in my mind and will use it when required..

Thanks and Regards,
Dinesh Kumar.V.

Dinesh.V.Kumar 2-Apr-14 10:42am View

Did u check the settings in web.config???if you have provided all the details required for windows authentication???
Please verify the below site...
http://www.codeproject.com/Articles/94612/Windows-Authentication

Hope this helps

Regards
Dinesh Kumar.V.

Dinesh.V.Kumar 25-Mar-14 9:19am View

string query = "Insert into Role1(RoleId, Add,Edit,View,Delete) Values('" + dropDown1.SelectedValue +"','" + Pages +"','" + (chkAdd.Checked==true?'Y':'N') + "','" + (chkEdit.Checked==true?'Y':'N') + "','"+ (chkDelete.Checked==true?'Y':'N') + "','" + (chkView.Checked==true?'Y':'N') + "')";

either Modify the Role_Id to varchar...or have id as membervalue and text as membertext in the dropdown properties and assign the id to the role_id column..

Dinesh.V.Kumar 25-Mar-14 7:31am View

Following are the issues I see in your code
1) There is no need to do update query in each check box...you can group it into a single update query..
2) The reason why your grid is not maintaining its state is because of the bind that happens in every check checked. Do it once after the single update...

protected void Button3_Click(object sender, EventArgs e)
{

foreach (GridViewRow row in GridView1.Rows)
{

if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkAdd = (row.Cells[2].FindControl("CheckBox1") as CheckBox);
CheckBox chkEdit = (row.Cells[2].FindControl("CheckBox2") as CheckBox);
CheckBox chkView = (row.Cells[2].FindControl("CheckBox3") as CheckBox);
CheckBox chkDelete = (row.Cells[2].FindControl("CheckBox4") as CheckBox);
string strID = row.Cells[0].Text;
string Pages = row.Cells[1].Text;

string query = "Insert into Role1(RoleId,ID, Add,Edit,View,Delete) Values('" + dropDown1.SelectedValue +"','"+ strID+ "','" + Pages +"','" + (chkAdd.Checked==true?'Y':'N') + "','" + (chkEdit.Checked==true?'Y':'N') + "','"+ (chkDelete.Checked==true?'Y':'N') + "','" + (chkView.Checked==true?'Y':'N') + "')";;

SqlCommand cmd = new SqlCommand(query, con);
cmd.ExecuteNonQuery();

BindGrid();
con.Close();
}
}
}

Hope it helps

Dinesh.V.Kumar 25-Mar-14 6:33am View

In the Permission screen, have a drop down which contains roles. Select a role. then check the checkboxes which provide appropriate permissions. when you save the permission data in the table save the following
ID, RoleID, Pages, Add, View, Edit, Delete information.
Add RoleID to the Permission table.
This will provide the Role-Permission mapping
When you create a user there also have a role drop down. When you save the user save the Role Id along with the other user information like user name, password etc...this will provide the User-Role-Permission mapping...

Hope I am clear...

Dinesh.V.Kumar 25-Mar-14 5:37am View

While inserting into permissions..insert the role id along with the permission details...it will be mapped...

Regards

Dinesh.V.Kumar 25-Mar-14 4:46am View

Yes..thanks for pointing me the mistake Raul...I will correct it now..

Regards

Dinesh.V.Kumar 25-Mar-14 4:43am View

Have a look at the below mentioned link..you might get an idea what I am trying to say
http://www.codeproject.com/Articles/15460/C-Image-to-Byte-Array-and-Byte-Array-to-Image-Conv

Regards

Dinesh.V.Kumar 25-Mar-14 4:40am View

Try it out..let me know if there is any problem...

Regards

Dinesh.V.Kumar 25-Mar-14 3:39am View

Convert the image as byte array...add it to a session and in the next page get the byte array and assign it to the image source by converting back from the session..

Regards

Dinesh.V.Kumar 25-Mar-14 3:36am View

What are the columns in the Permission table?
Add a column Role_ID in the Permission Table. Make this as Foreign Key.Now you will have a role to permission mapping. In Users table also add a column Role_ID and make it foreign key..You will have a mapping for User-Role-Permission now...With this you can control the permissions for a user...

Hope it helps

Regards

Dinesh.V.Kumar 21-Mar-14 3:06am View

Did u bind again when you clicked "Edit" button?

Dinesh.V.Kumar 17-Mar-14 13:27pm View

Can you please elaborate on your query?

Dinesh.V.Kumar 17-Mar-14 7:22am View

I have replied to your query..hope that helps!!

Have a nice day!!!

Regards

Dinesh.V.Kumar 17-Mar-14 7:19am View

Hi,
Before assigning the slot check if for the particular teacher has already been assigned to the slot or not. Write a select query
Select Count(ID) from <table> where Teacher_Id=<teacher_id> and slot_Id=<slot_id>
If the count is 1 or more, then show "Slot is busy" message if the count is 0 then assign the slot to the teacher using the update statement.

Hope this helps!!!

Regards

Dinesh.V.Kumar 14-Mar-14 3:08am View

Ok...let me check if I can find some solution for this...

Dinesh.V.Kumar 14-Mar-14 3:02am View

Can you tell me why its not working?Is there any error that you are getting..If so,please post the error message..we can try to resolve it..if you are not having error message..then give me some time i will try to find some other solution...

Regards

Dinesh.V.Kumar 13-Mar-14 13:36pm View

Try This link...

http://msdn.microsoft.com/en-us/library/f1hh9fza.aspx

Dinesh.V.Kumar 13-Mar-14 3:26am View

List<string> lstKey = new List<string>();
foreach(var entry in dictionary)
{
lstKey.Add(entry.Key);
}
datagridview.DataSource=lstKey;
datagridview.DataBind();

Regards,

Dinesh.V.Kumar 13-Mar-14 3:15am View

Use the GetEnumerator() to get the keys in to a list object and bind the list object to the datagridview...

Regards

Dinesh.V.Kumar 12-Mar-14 7:59am View

Ok what is the error you are getting? Could u post the error message?

Dinesh.V.Kumar 12-Mar-14 7:45am View

Try using
RichTextBox temp = (RichTextBox)dgvPARs.FindControl("richtextboxcontrolname");

Hope this helps

Regards,

Dinesh.V.Kumar 12-Mar-14 7:38am View

Have u declared objVehicle object?

Regards

Dinesh.V.Kumar 12-Mar-14 7:34am View

Print the @vQuery and run it separately and check...I suppose the update statement as a whole is wrong..

Regards,

Dinesh.V.Kumar 12-Mar-14 5:00am View

You are always welcome!!! Have a nice day!!

Dinesh.V.Kumar 12-Mar-14 4:36am View

Why is that you need the column name like the one you have mentioned...Could you please let me know the purpose..??

Dinesh.V.Kumar 12-Mar-14 4:34am View

Ok...Taking a second look at your DB Design...I would say you can split Teacher to Teacher_Master, Teacher_Qualification...Store the Qualification details separately..
Other than this there is no need to normalize more...

I would recommend you to speak to your teacher and inform him that too much Normalization could affect the performance of the application...as mentioned below in the solution...

Dinesh.V.Kumar 12-Mar-14 3:23am View

Thanks for the vote!!! :)

Dinesh.V.Kumar 12-Mar-14 3:20am View

If possible please vote for the solution..

Regards

Dinesh.V.Kumar 12-Mar-14 3:20am View

You are Welcome!!!

Dinesh.V.Kumar 12-Mar-14 3:08am View

Your question is not clear...
So you want the column name as "testgrade01" or "test" as one column and "grade01" as second column???

Regards

Dinesh.V.Kumar 12-Mar-14 3:06am View

Try setting Hindi fonts for the those columns that are in Hindi...You can set fonts while exporting...

Regards

Dinesh.V.Kumar 12-Mar-14 2:49am View

Ok...I feel the level of normalization you have done is fine and it does not need more than this...

Regards

Dinesh.V.Kumar 12-Mar-14 1:23am View

Seems ok to me except for one thing in

ClassRoom Room_id Integer Pk
Room_label Varchar(50)
Room_type Varchar(50)
Room_id integer Fk

You have created Room_id as PK and FK...Over Normalized Database will also be harmful while maintaining it...

Regards

Dinesh.V.Kumar 12-Mar-14 1:19am View

What is the problem you face? Can you please be descriptive? Please provide code and the error message you receive so that we can understand what your problem is and try helping you.

Dinesh.V.Kumar 11-Mar-14 1:37am View

Why dont you sort the datatable and bind the sorted datatable to the datagridview...

Hope this helps!!

Regards

Dinesh.V.Kumar 27-Feb-14 23:31pm View

Can you please let me know why you downvoted my answer... The links do give info abt abstract class...Even though it helps you even if you dont vote it as an answer...I dont see any reason for the down vote!!!

Dinesh.V.Kumar 26-Feb-14 8:09am View

Am not sure but pls check this..
Select (case when sum(A.[Quantity]) is null then 0 else sum(A.[Quantity]) END) +
(case when sum(B.[Quantity]) is null then 0 else sum(B.[Quantity]) END)
From [tablename1] A Inner Join [tablename2] B On A.Sorce_No =B.No
Where ((A.[Status]=4) AND (A.[Spcl Order]=1)
AND (A.[Finished Date] = aa.FromDate ))) And B.[Item Category Code] = 'STYLES'
AND (B.[Prod_ Order No_]='') AND ( B.[Buy-from Vendor No_] in (@vendor))
AND (B.[Quantity]>0) AND (B.[Spcl Order]= 1)
AND ( B.[Posting Date] = aa.FromDate))))

Dinesh.V.Kumar 26-Feb-14 7:39am View

What are all the columns in both the tables.. which is the Primary Key and Foreign Key...

Dinesh.V.Kumar 26-Feb-14 1:22am View

Create a Formula Field named "NetAmount" in the Report. Double click on it...Select from the list of bound database fields the "subtotal" and "discount" fields and use
{subtotal} - {discount}. Check for errors and save it if there are no errors. Drag and drop the formula field in your report.

Regards

Dinesh.V.Kumar 26-Feb-14 1:16am View

What is the problem you are facing??? Kindly provide the error information and also rephrase the question so that we can help you.

Dinesh.V.Kumar 21-Feb-14 1:05am View

Store the information in Session if the information is less...

Regards

Dinesh.V.Kumar 20-Feb-14 2:30am View

Joins are always better then subquery...

Dinesh.V.Kumar 20-Feb-14 2:29am View

Unused SPs will not affect your application...But queries that are being used if referring to unused columns may affect though the impact will not be big..but still may affect the application

Dinesh.V.Kumar 20-Feb-14 2:25am View

Try these links
techbrij.com/add-dynamic-form-elements-textbox-button-radio-checkbox
haacked.com/archive/2008/10/23/model-binding-to-a-list.aspx
c-sharpcorner.com/forums/thread/220191/create-dynamic-control-in-mvc4-razor.aspx

Hope one of these links helps!!

Dinesh.V.Kumar 20-Feb-14 1:54am View

Just remove those. The query will unnecessarily fetch the columns when it is not required. Then these columns will be in memory and will be unused...Till it is cleared..

Also clear the memory as and when it is used..
Usage of proper design patterns in the web application will help you in memory management
For eg: using singleton pattern will help you manage the objects. The object once created will be reused when required and will not be created again and again when needed.

Find the Design Patterns suitable for your application and implement it..
It will reduce lot of over heads..

Regards

Dinesh.V.Kumar 19-Feb-14 1:57am View

Yes it is possible...

Dinesh.V.Kumar 18-Feb-14 3:23am View

Deleted

in checkbox_checked() event, write the following code
int amount=0;
for int i=0;i

Dinesh.V.Kumar 18-Feb-14 1:17am View

Are you receiving any error message? If so please paste the error message..It will help us to solve your problem..

Regards

Dinesh.V.Kumar 17-Feb-14 6:18am View

There is a problem when you track the IP..the user can login from different IPs...How will you identify which user has logged in from which IP...

Regards

Dinesh.V.Kumar 17-Feb-14 5:12am View

try ..kpi.Enabled=false...

Regards,

Dinesh.V.Kumar 17-Feb-14 2:11am View

Please post your code...

Dinesh.V.Kumar 17-Feb-14 1:27am View

There are different tools..You can use SAP Crystal Reports/SSRS..It depends on the purpose of reports...Please google it..you will find enough information to build reports..

Regards

Dinesh.V.Kumar 14-Feb-14 9:37am View

Check the value for this "User.Identity.Name"...

Dinesh.V.Kumar 14-Feb-14 8:57am View

Are you sure this query returns the data you need to display..
"select Id,name,midname,surname,username,password,contact,dob,email,address,ltype,image from login where id='" + User.Identity.Name + "'", ?????

Dinesh.V.Kumar 14-Feb-14 7:22am View

To my knowledge it is not possible to do so unless there is a way to know the details of the user when they open the home page...like login...

Gimme some time...will see if I can come up with some solution...

Regards

Dinesh.V.Kumar 14-Feb-14 6:42am View

Welcome to CP!!!
Your question is not clear....You want to enter a content for a selected member...The entered content should be displayed when this member is selected?
In any case this content need to be saved in some place [DB/Files]. Then it has to be fetched from its storage place and has to be displayed..

hope this helps!! If it does not help..pls reformat your question..

Regards

Dinesh.V.Kumar 14-Feb-14 4:19am View

is it working??

Dinesh.V.Kumar 14-Feb-14 2:23am View

Can you tell us the purpose of passing the control to the function????

If you need to do something with the data displayed in the grid view, then send the data table bound to the grid...do some modification and then rebind the modified datatable to the grid...

Regards

Dinesh.V.Kumar 13-Feb-14 12:52pm View

It should not be "yy", it should be "mm"
select OrderDate from Orders where OrderDate
and I am sorry it should have been the other way round..

try this query...
select OrderDate from Orders where OrderDate
between Dateadd(yy,GetDate(),-3)
and GetDate()

Dinesh.V.Kumar 13-Feb-14 9:24am View

You can do this from the code page..
label1.Text = Session["mType"];

Regards

Dinesh.V.Kumar 13-Feb-14 9:18am View

use "<date> between GetDate() and DateAdd(m,GetDate(),-3)" in your query....

Dinesh.V.Kumar 13-Feb-14 8:58am View

Any updates?

Regards,

Dinesh.V.Kumar 13-Feb-14 7:47am View

you are welcome!!

Regards

Dinesh.V.Kumar 13-Feb-14 7:46am View

Pls check this site...there are lots of samples provided for you
http://devlibrary.businessobjects.com/businessobjectsxi/en/en/boe_sdk/samplelist.htm
hope this helps

Regards

Dinesh.V.Kumar 13-Feb-14 7:39am View

ok...I am not sure..but I will try finding some solution for you...

Regards,

Dinesh.V.Kumar 13-Feb-14 7:13am View

Create a Script [VB.net/C#] task.. Write your encryption routine...Then invoke the File System Task after this task is executed.

Regards

Dinesh.V.Kumar 13-Feb-14 7:04am View

You may be able to do that. I am not exactly sure how..There are some dlls provided by Business Objects..Include them as reference to your project. If you are using Crystal Reports then its not a problem...But if you are using WEBi then try it out... I will also look for some references so that you can do the task...

Try googling...you may find some solution...

Regards

Dinesh.V.Kumar 13-Feb-14 1:53am View

Need more info Sachi!!Can you post what you have done so far and also the code if possible

Regards

Dinesh.V.Kumar 12-Feb-14 1:12am View

hi..i just wanted to know if all is well with u about the issue u were facing//

Regards

Dinesh.V.Kumar 11-Feb-14 4:31am View

Did you check the "SerialNo" that you are binding..Is the name correct? pls check the datasource you are binding...

Regards

Dinesh.V.Kumar 11-Feb-14 3:28am View

then your code is correct...

But ensure the column that you are binding is correct.

Regards

Dinesh.V.Kumar 11-Feb-14 3:18am View

Pls tell me clearly what you want to do with the text box in the place holder. If you have to get the value from the text box use my code...if you have to set a value to the text box dynamically what you are doing is correct..but check the "tb1" you are using to bind...If it is not declared/used earlier, it will throw error.

Hope this helps!!

Regards

Dinesh.V.Kumar 11-Feb-14 2:40am View

As already mentioned
the below code will work to get the value from textbox placed in a place holder
string tb1Val=string.Empty;
TextBox txtBox1= (TextBox)PlaceHolder1.FindControl("tb1");
tb1Val = txtBox1.Text.Trim();

As for your error...I can just point out the solution as I do not have the db and it will take time to reproduce the error. Please paste the detailed error message so that I can try to help you..

Regards

Dinesh.V.Kumar 11-Feb-14 2:19am View

You are welcome!!!

Regards,

Dinesh.V.Kumar 11-Feb-14 2:15am View

Try this code in say..any button event...for example..btnCalculate or btnSave...

Regards,
Dinesh Kumar.V.

Dinesh.V.Kumar 11-Feb-14 2:13am View

Try quantity -= Math.Ceil(txtQty.Text)

Regards

Dinesh.V.Kumar 11-Feb-14 2:09am View

Deleted

decimal total=0.0;

for (int i=0;i

Dinesh.V.Kumar 11-Feb-14 2:02am View

Instead of int.Parse(txtQuantity.Text);
try
Convert.ToInt32(txtQuantity.Text.Trim());

Regards,

Dinesh.V.Kumar 10-Feb-14 8:52am View

It could be because the txtQuantity is wrong name for the text box...Pls check that..

Dinesh.V.Kumar 10-Feb-14 8:35am View

Place a breakpoint in save click event and debug and check if the break point is getting hit...

Regards

Dinesh.V.Kumar 10-Feb-14 8:20am View

Did u check what value you got in tb1Val variable? Can you post that too?

Dinesh.V.Kumar 10-Feb-14 7:22am View

try this
string tb1Val=string.Empty;
TextBox txtBox1= (TextBox)PlaceHolder1.FindControl("tb1");
tb1Val = txtBox1.Text.Trim();
You can use this value and send this to the insert query/sp to save it to database.

Regards

Dinesh.V.Kumar 10-Feb-14 6:37am View

Try this
la.Text = ddlProductName.SelectedItem.Value + i.ToString();

Regards,

Dinesh.V.Kumar 10-Feb-14 4:34am View

Sure just post the solution so that it may be helpful some time later..

Thanks & Regards

Dinesh.V.Kumar 10-Feb-14 4:23am View

Oops!!Sorry about that....Please check the Solution provided below by another member thatraja...in the mean time let me check if there is any other solution for you...

Sorry once again that the solution didnot work..

Regards

Dinesh.V.Kumar 10-Feb-14 1:11am View

Guys!!!Lets not fight!!!You have a problem and you have stated that...Dont ever post any ID and password combo hence forth...even if its demo account...!!!

Regards,

Dinesh.V.Kumar 10-Feb-14 1:06am View

Right click on the text controls. Select Properties..You will have a property named "Suppress". To the right of that there will be a button. Click on that button. It will open a Formula window. There use the formula similar to the one below
if trim({<field from="" db="">}) = "" then true else false.
This will suppress the fields from displaying if there are no records...Hence will not be available for printing.

Hope it helps

Regards

Dinesh.V.Kumar 10-Feb-14 1:00am View

Can you paste the code where you are generating the "RAM textbox" part? This may help us solve your problem...

Regards

Dinesh.V.Kumar 8-Feb-14 9:57am View

I am not exactly clear on what you want...but assuming that, on executing the SP you get the result in a data table. After this use the below code
Session["UserID"] = dataTable.Rows[0]["Login_ID"];
Session["RoleID"] = dataTable.Rows[0]["Role_ID"];

Regards

Dinesh.V.Kumar 7-Feb-14 7:22am View

Just let me know if you are facing any issues.. we shall sort it out...

Regards,

Dinesh.V.Kumar 7-Feb-14 7:03am View

Any updates?

Dinesh.V.Kumar 6-Feb-14 8:25am View

Hope all is well thr...!!How is it going?

Regards

Dinesh.V.Kumar 6-Feb-14 0:27am View

you are always welcome!!Have a nice day!!

Dinesh.V.Kumar 6-Feb-14 0:10am View

Try having a User Mapping Table...Map the user with the entities he/she can use in the User mapping table. Allow the user to access those entities in for which the user has permissions....

Am not sure if this will be apt...but to my knowledge this is one solution you can try...let me know if this doesnt work for you...I shall see what we can do for this..

Regards

Dinesh.V.Kumar 5-Feb-14 6:56am View

Hi Ravi,

Currently I dont have a solution for this...Give me some time...I will try to figure out on how it can be implemented and will let you know.

Regards

Dinesh.V.Kumar 5-Feb-14 6:33am View

If you want to restrict the user to read/write/delete/modify in all the tables in your db then you can do it using code. Can you please elaborate on this part?

Regards

Dinesh.V.Kumar 5-Feb-14 6:23am View

Please check the folllowing links...You might be able to get some idea..
http://www.codeproject.com/Articles/265870/Bypass-Forms-Authentication-to-Use-Active-Director
http://www.codeproject.com/Articles/15877/ADAM-and-LDAP-Client-Net-LDAP-Access-Control-for-A
Hope this helps!!!

Regards,
Dinesh Kumar.V.

Dinesh.V.Kumar 4-Feb-14 8:26am View

Do let me know if you still face issue. Please post the detailed error so that we can help you solve it....

Dinesh.V.Kumar 4-Feb-14 7:04am View

set the CustomError tag to "On". It will give you a detailed error description...You may yourselves be able to solve that issue once you get it..If its still a problem..please post the detailed error message. We can solve it...

Dinesh.V.Kumar 3-Feb-14 7:40am View

Could be that the control you are binding the datarow/datatable needs "farmername" but it is not available in the datatable. Please post your code for us to check and help you.

Dinesh.V.Kumar 3-Feb-14 7:30am View

Need more info on the error...please post the error message

Dinesh.V.Kumar 29-Jan-14 1:07am View

For javascript you will not get intellisense..just try adding the code to the window.onbeforeunload() event...it should work..

Dinesh.V.Kumar 29-Jan-14 0:02am View

Thanks..am happy that its working fine!!!coz i did not check it here...Kindly mark it as answer....

Dinesh.V.Kumar 28-Jan-14 7:55am View

Pass the item id to the details page via session/querystring.
in the details page fetch the passed item id and query the db and display the details.

Hope this idea helps!!

Dinesh.V.Kumar 28-Jan-14 7:36am View

Query seems correct...it will be helpful if you can provide the error information...so that we can help you out...

Dinesh.V.Kumar 28-Jan-14 6:42am View

Wrong Forum!!!But depends on experience

Dinesh.V.Kumar 28-Jan-14 6:38am View

While you click the edit button, kindly do another rebind...

Dinesh.V.Kumar 28-Jan-14 1:38am View

Deleted

Loop through the length of S1. Fetch each character using
string S1 = "abc";
string S2 = "xaybzc";
string S3=string.Empty;
string S4 = string.Empty;
string S5 = string.Empty;
for (int i = 0; i < S1.Length; i++)
{
S3 = S1.Substring(i,1);
if (S2.Contains(S3))
{
S4 = S2;
for (int j = 0; j < S2.Length; j++)
{
S5 = S2.Substring(j,1);
if (S5.Contains(S3))
{
S4=S4.Replace(S3, "");

}
}
S2 = S4;
}
}
Console.WriteLine(S2);
Console.ReadLine();

Dinesh.V.Kumar 22-Jan-14 7:28am View

Is this range of numbers finalized?
If yes then have the numbers in a list [arrays, arraylist, or generic list]. when the user enters a value in the textbox, check the value is available in this list. If the value is available then allow the user to proceed else show an error message.

Hope this helps

Regards
Dinesh Kumar.V.

Dinesh.V.Kumar 21-Jan-14 1:16am View

Deleted

Could any one please explain why this answer was downvoted?

Dinesh.V.Kumar 20-Jan-14 6:59am View

use the below query -
Select name, sum(marks) from table_name Where <condition> group by name

Dinesh.V.Kumar 20-Jan-14 1:57am View

Hi Raghav_Shankar,

Firstly, sorry for the delayed response!!!

I have deployed projects using both the methods.
You can transfer files in 2 ways from XML files.
Using windows service:
1) Create a service.
2) Use FileWatcher component available. This one watches the folder you specify for any files moved in to the folder.
3) If its xml files. Convert the xml to a datatable and insert the records one by one to the table.
http://www.codeproject.com/Articles/18521/How-to-implement-a-simple-filewatcher-Windows-serv

You can find the examples for the above in google/stackoverflow/codeproject.

Alternately :
Using windows service:
1) Create a service.
2) Use Timer component available. You can program to execute the code every <1>[configurable] minute. Check if the file is available in the folder. If its available, process as in Step 3.
3) If its xml files. Convert the xml to a datatable and insert the records one by one to the table.

You can also find the examples for the above in google/stackoverflow/codeproject.
The above two methods work well only with less amount of data.
If the data in xml files are huge, its advisable to use SSIS.

http://www.codeproject.com/Articles/173918/How-to-Create-your-First-SQL-Server-Integration-Se

Note: Pardon me if you are aware of SSIS already.

Comments by Dinesh.V.Kumar (Top 148 by date)