Comments by TarunKumarSusarapu (Top 161 by date)

Just give me some example on grid which deals with large amount of data with in less time

But here in paging also it takes more time to move to next page.Its again calling action method again.

Please check the code which i mentioned here and suggest me the best way

Here My requirement is first of all page is being loaded.After clicking the button it should display popup which contains partial view of Main_Menu.cshtml.
Here GetReqSelection() method which contains linq query to retrieve the data should be called after clicking the button.
Here I have created 4 partial views in index.cshtml.One of the partial view is popup.cshtml.
In that popup.cshtml i am rendering main_Menu partial view which contains the combobox.
Here I have taken two models and that is defined in the tuple.

Hi Graeme_Grant,

Thank you for your explanation with the example.

I understood your example but here where should i call GetReqSelection() method.

I think it should be called in Post method of action in controller.

Would u please elaborate the scenario with example?

Would u please elaborate the scenario with example?

Still got the error on assigning models to the partial view

@model Tuple<DevExpress.DashboardWeb.WorkingMode, DashboardDemo.Models.vw_100_QUERY_FOR_XLS_WEEK_IN_PROGRESS_016_Forecast_Follow_Current_Data>


@Html.Partial("~/Views/Home/DashboardPartial.cshtml",Model.Item1)

@Html.Partial("~/Views/TreeView/VirtualModePartial.cshtml")

@Html.Partial("~/Views/Home/PopupPartial.cshtml",Model.Item2)

@Html.Partial("~/Views/Home/ForecastGridPartial.cshtml",Model.Item2)

Here I am explaining in simple way

This is my main view rendering four partial views with different models that's why i created Tuple.

@*@model Tuple<DevExpress.DashboardWeb.WorkingMode, DashboardDemo.Models.vw_100_QUERY_FOR_XLS_WEEK_IN_PROGRESS_016_Forecast_Follow_Current_Data>*@


@Html.Partial("~/Views/Home/DashboardPartial.cshtml")

@Html.Partial("~/Views/TreeView/VirtualModePartial.cshtml")

@Html.Partial("~/Views/Home/PopupPartial.cshtml")

@Html.Partial("~/Views/Home/ForecastGridPartial.cshtml")

For Popuppartial view in the content section i am calling another partial view which contains model as item2 in the tuple

PopupPartial.cshtml

@(Html.DevExpress().PopupControl(settings =>
{
settings.Name = "PopupControlSelectSub";
settings.ShowOnPageLoad = false;
settings.ShowMaximizeButton = true;
settings.Width = 1200;
settings.Height = 900;
settings.CallbackRouteValues = new { Controller = "Home", Action = "Main_Menu" };
settings.AllowDragging = true;
settings.CloseAction = CloseAction.CloseButton;
settings.PopupAnimationType = AnimationType.Slide;
settings.HeaderText = "Main Menu";
settings.Modal = true;
settings.PopupHorizontalAlign = PopupHorizontalAlign.WindowCenter;
settings.PopupVerticalAlign = PopupVerticalAlign.WindowCenter;
settings.PopupElementID = "btnName_CD";
settings.ScrollBars = ScrollBars.Horizontal;
settings.SetContent(() =>
{
Html.RenderPartial("Main_Menu");
});
}).GetHtml())


On loading the page I got this error

The model item passed into the dictionary is of type 'devexpress.dashboardweb.workingmode', but this dictionary requires a model item of type '@model DashboardDemo.Models.vw_100_QUERY_FOR_XLS_WEEK_IN_PROGRESS_016_Forecast_Follow_Current_Data'

I have already given but still getting the same error

Thanks

Its a basic MVC Flow.Please suggest me

Hi Karthik,

Thank you for your information provided.

But here I have taken devexpress extension of dashboard for html.

@Html.DevExpress().DashboardViewer(settings => {
settings.Name = "DashboardViewer";
settings.Width = Unit.Percentage(100);
settings.Height = Unit.Percentage(200);
settings.CallbackRouteValues = new { Controller = "Home", Action = "DashboardViewerPartial" };
settings.ExportRouteValues = new { Controller = "Home", Action = "DashboardViewerPartialExport" };
settings.ClientSideEvents.ItemClick = "function(s, e) { getUnderlyingData(e); }";
settings.ClientSideEvents.ItemElementCustomColor = "function(s, e) { setColors(e); }";
//settings.ClientSideEvents.ItemVisualInteractivity = "function(s, e) { GetCalculatedFields(e); }";
}).BindToSource(Model).GetHtml()

In network tab it is showing span class for that emoji text.

Now my question where should i add the above code?

Or Can i change the color using javascript?

I tried to add field in the textbox in devexpress dashboard and it is showing error on displaying the value and it's been solved.Thank you.

Suppost my project file path is C:\Temp\Original\SourceCode\AINIPMKPIDashboard\App_Data\Dashboards\Data Extracts\

How can add it in app.config file without hard coding.

Hi F-ES Sitecore,

Would you please modify the code

string sPath = HttpContext.Current.Server.MapPath(string.Format(@"~/App_Data/Dashboards"));
string[] lstFiles = Directory.GetFiles(sPath, "*.xml");

I am new to this MVC dashboard controls using devexpress.Please help me

I have also added cdn js files to the view.But getting the same error on the mechine

This is my layout.cshtml


<!DOCTYPE html>



<meta charset="UTF-8" />
<title>@ViewBag.Title

@Html.DevExpress().GetStyleSheets(
new StyleSheet { ExtensionSuite = ExtensionSuite.NavigationAndLayout },
new StyleSheet { ExtensionSuite = ExtensionSuite.Editors },
new StyleSheet { ExtensionSuite = ExtensionSuite.GridView },
new StyleSheet { ExtensionSuite = ExtensionSuite.Dashboard },
new StyleSheet { ExtensionSuite = ExtensionSuite.DashboardViewer }
)
@Html.DevExpress().GetScripts(
new Script { ExtensionSuite = ExtensionSuite.NavigationAndLayout },
new Script { ExtensionSuite = ExtensionSuite.Editors },
new Script { ExtensionSuite = ExtensionSuite.GridView },
new Script { ExtensionSuite = ExtensionSuite.Dashboard },
new Script { ExtensionSuite = ExtensionSuite.DashboardViewer }
)




@RenderBody()

At first I have taken sample devexpress dashboard application using MVC.While running I got the runtime error like this.

No Exception is getting here.But crashing of data taken place

Bro,I tried in the way you mentioned here.But still crashing happens.Would u please suggest me

I have so much code to change it in a parametrized query.Is there any way to change easily or another way?

OK.I will try it.I will confirm u when it works.Thank you.

It must contains alphanumeric letters so please suggest what to do?

Actually this happens in the client system. Can we copy our dlls in Sdk folder to client system? should it work properly?

I have clicked on Publish website and given connection details but i got error like this
'Invalid Web Deploy service URL'

Thank you it's working

Thank you it's working

Thank you koolprasad2003 for your suggestion. I will try my level best.

Thank you OriginalGriff. I will try my level best.

In 32 bit system it is working fine in 64 bit i got this type of problem

I modified the question and i indicated error at the execute nonquery method

How can we know this Fax server respond or not? here it recognizes pc name and taking the file name but on sending only i got error like this

Thanks a lot.It helped me a lot.Can u please provide the links for examples to interact with database

But my script incluedes GO statements we can't execute GO statements in ADO.NET objects that's why i take server

Yeah we can but here i have used server connection

to show the version of the server and need to run the scripts in database dynamically

Server server = new Server(new ServerConnection(conn));

This can't effect on the output I got the same error

I got this error while running on Network service 'OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ClientAc484" returned message "Unspecified error".' Can u pls solve this error

I got this error while running on Network service 'OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ClientAc484" returned message "Unspecified error".' Can u pls solve this error

Can u pls explain this briefly in 32 bit pc it is working fine in 64 bit it is getting like this. How to modify the folder permissions or other wise how to alter the linked server permissions

No I have n't opened i closed the connection in the query still got same error i am using 64 bit version of windows.

I got error like this while connecting to linked server using ACE Engine 'Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ClientAc825".
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ClientAc825" returned message "Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.".'

How can we use ACE Engine instead of Jet Engine Can u please explain briefly

Here I am using Linked server to retrieve data from msaccess database and then by using linkserver i am copying the total database tables from msaccess to sql server.Here all the tables copied but the is identity property is missing i.e it set to NO

Here we are copying total database that contains 1000 tables from msaccess mdb files to sql server db. For every table we can't give identity and create one table that table copied into another table it takes a lot of time. Would u pls explain this query briefly

I don't know how to use it Can u give me the brief explanation while running a method

windows foms

That table does not exist or you don't need permissions Because here i have used select * into query so we can copy the table with schema

I have successfully imported database from msaccess to sql server using linked servers but it doesn't set is identity prpoerty to columns in destination table.

I have written one stored procedure with setting the identity_insert on before the select * into query but it is being gotten error.

This is my procedure
create proc
SP_Create(@servername nvarchar(100),
@datasr nvarchar(MAX),@table nvarchar(100),
@table1 nvarchar(100),@db nvarchar(100))
as begin EXEC sp_addlinkedserver @server = @servername,
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = @datasr,@provstr=''
exec sp_addlinkedsrvlogin @rmtsrvname=@servername,
@useself = N'false',@locallogin = NULL,@rmtuser = N'Admin',
@rmtpassword = NULL declare @sql nvarchar(MAX)
set @sql=' SET IDENTITY_INSERT '+@table1+' ON; select * into '+@table1+' from '+@servername+'...'+@table+' with (nolock) SET IDENTITY_INSERT '+@table1+' ON '
Exec(@sql)
declare @sql1 nvarchar(MAX) set @sql1 ='EXEC master.sys.sp_dropserver '+@servername+',''droplogins''' exec(@sql1)
end

is there any use with nolock using here

I tried same with stored procedure but got same error here. Actually we have more than 50 mdb files in a folder and each have 40 tables we need to access one by one and executing the query. would u pls write the above query and use SSMS

Actually we are calling the commands from front end we need to do import from access to sql on button click can u pls elaborate this?

Thank you very much for your information bro But I got error while saving table into destination table would u pls observe below solution and guide me your suggestion

I got eeror like this 'ODBC Call Failed' converting mdb to sql database would u pls solve this error
http://www.codeproject.com/Questions/1036469/I-got-error-like-lis-ODBC-Call-Failed-when-importi?arn=0

I got this error when while executing the code
//cn1 = new SqlConnection(con);
//if (cn1.State != ConnectionState.Open) { cn1.Open(); }
//SqlCommand cmd = new SqlCommand("select * into [" + tableName + "] from OPENROWSET('Microsoft.Jet.OLEDB.4.0','" + tr + "';'Admin';'',[" + tableName + "])");
//cmd.Connection = cn1;
//cmd.ExecuteNonQuery();
OleDbCommand cmd = new OleDbCommand("select * into [" + con + "].[" + tableName + "] FROM [" + tableName + "]", connection);
//OleDbCommand cmd = new OleDbCommand("select [[" + tableName + "].*] into [" + con + "].[" + tableName + "] From [" + tableName + "]");
cmd.Connection = connection;
cmd.ExecuteNonQuery();
connection.Close();

select * into [ODBC;Driver=SQL Server;Data Source=serverpc\sqlexpress,52120;Initial Catalog=TARUN_DB;Persist Security Info=True;User ID=vipl-user;Password=vipl-user!@#$%;MultipleActiveResultSets=True].[ACTYPE] FROM [ACTYPE]

Would u please elaborate it for one table here is the sample query
select * into [ACTYPE] IN ODBC; Driver={SQL Server};Server='PC01';Initial Catalog=TARR;Persist Security Info=True;User ID= 'sa';Password='123' FROM [ACTYPE]

Boss I want to copy total database from ms access to sql in which it has to create its own table and copy that data into sql like insert * into query. Upto 2nd step it is ok we can retrieve the data from access table and load that data into datatable but to copy that data into sql we need to create that same table with all columns in sql then use write to server method.

I have more than 1000 tables in my access mdb it takes a more time to create every table in sql and copy that database.

K Thanks for ur info I will try in your way and tell u soon

I tried all that i got error like this 'Access to the remote server is denied because no login-mapping exists.' while accessing the data from the linked server i created linked server login and linkedserver also but i am using a server which is connected to all the machines.
Is it necessary to take the permission from admin to do this operation? Here Mdb files are in local machine i.e my pc. I will try this one also

Bro I tried all that i got error like this 'Access to the remote server is denied because no login-mapping exists.' while accessing the data from the linked server i created linked server login and linkedserver also but i am using a server which is connected to all the machines.
Is it necessary to take the permission from admin to do this operation? Here Mdb files are in local machine i.e my pc.

Thanks for your consideration I got error like this 'Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.' while using openrowset. I will try linked server.
This is my query
insert into [ACTYPE] select * from OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\EZACC\DATA\AH.mdb';'Admin';'',[ACTYPE])

I also used openrowset but it is also getting error.Any help to my problem would be much appreciated

Bro I have a problem in converting mdb to sql database would u pls solve this error
http://www.codeproject.com/Questions/1016561/IErrorInfo-GetDescription-failed-with-E-FAIL-x?arn=0

Thank u bro its working Keep it up have a bright future bro

OK Thank u I will check it once and i will tell u

Suppose i inserted three invoices for STOCK IN with quantity & cost
10 11
10 12
10 13
i inserted four invoices for STOCK OUT with quantity & cost
1 5
2 5
12 5
3 5
then u have to findout the fifo cost for stock out
for 1 5 invoice stock in -stock out 10-2=9 for this invoice fifo cost 11
for 2 5 invoice 9-2=7 for this invoice also fifo cost 11
similarly
for 12 5 invoice 7-12=-5 that will be added to next invoice qty
i.e 10 12 invoice in STOCK IN so the final qty is 10-5 =5 for next invoice in STOCK OUT 2 5 the fifo cost is 12.
Like that we need to find FIFO QTY by comparing stock in & StockOut

Have u found out any other ways to calculate this cost?

Previously I have asked one question In that all the logic will be there at front end so that you can easily understand the calculation part.
http://www.codeproject.com/Questions/1029415/How-to-write-a-cursor-in-sql-to-compare-two-table?arn=0

Here It checks every record with another record in another table to find the fifo cost that's why i have written two cursors to calculate the fifo cost. Would u please elaborate the code without use cursors so that we can increase the performance.

are u free to do this have u found any solution for this?

K Thank you

Yeah I tried this from last two days would u pls spend a 10 min for this

Its OK bro what about the solution have u tried or not

take table 1 qty_in column and table 2 qty_out column if Qty_in is greater than or equal to qty_out then find the stock followed by calculate fifo cost. I have clearly written that code

Thanks for your Help But i want logic to write cursor in sql for that you can follow below code in front end

Thank a lot

It is not getting with appropriate result after 1.sql it is showing 10.sql

Not working bro I tried that also

Thanks for ur information Actually That has been posted by me That is different from this one can u pls solve this

Thanks for your advice but that is completely different from my question how can u run queries step by step or line by line in .sql file using c#

see above TarunKumarSusarapu at 33 mins ago

Would u pls write that query using exception handling without error

--------------------------RUN THIS SCRIPT IF GRADEDDETAILS TABLE CONTAINS DATA / IF ERROR OCCURS WHILE CONVERTING THE ABOUVE SRIPT---------
ALTER TABLE GradedDETAILS ADD STOCK_DATE1 DATETIME NULL ----STEP 1--

ALTER TABLE GradedDETAILS ALTER COLUMN [STOCK_DATE] NVARCHAR(100) ----STEP 2--

UPDATE GradedDETAILS SET [STOCK_DATE]=CONVERT(DATETIME, [STOCK_DATE], 104) ----STEP 3--

UPDATE GradedDETAILS SET [STOCK_DATE1]=[STOCK_DATE] ----STEP 4--

ALTER TABLE GradedDETAILS DROP COLUMN [STOCK_DATE] ----STEP 5--

SP_RENAME 'GradedDETAILS.STOCK_DATE1','STOCK_DATE','COLUMN' ----STEP 6--

I want to execute query step by step in sql using C# with single click

if you execute it once then i got error like this

Incorrect syntax near 'SP_RENAME'.

Yeah I want the answer for that i want to execute it line by line should i use any condition in front of each query

I have tried still it is getting same error

Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.

Would u please elaborate ad-hoc queries in a stepwise

I got error like this

Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.

select * into [Driver=SQL Server;Data Source='serverpc\sqlexpress';Persist Security Info=True;User ID= 'vipl-user';Password='vipl-user!@#$%';Initial Catalog=TTT].[ClientAc] from [ClientAc]

Is it Correct or not

After Executing that query only i got error like this

Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.

I have used OPENROWSET also but i am getting errors not executed

cn1 = new SqlConnection(con);
if (cn1.State != ConnectionState.Open) { cn1.Open(); }
SqlCommand cmd = new SqlCommand("select * into [" + tableName + "] from OPENROWSET('" + connection.ConnectionString + "';,'admin','',[" + tableName + "])");
cmd.Connection = cn1;
cmd.ExecuteNonQuery();

select * into [ClientAc]
from
OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\ezacc\DATA\accountdata.mdb';'';'',[ClientAc])


I got error like this

Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.

OleDbCommand cmd = new OleDbCommand("select * into ["+con+"].["+tableName+"] from [" + tableName + "]");
cmd.Connection = connection;
cmd.ExecuteNonQuery();


I got Invalid Argument error

I tried that
select * into ClientAc from [Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\ezacc\DATA\accountdata.mdb].[ClientAc]
I got error like this

Invalid object name 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\ezacc\DATA\accountdata.mdb.ClientAc'.

This is my query
select * into [Data Source='serverpc\sqlexpress';Persist Security Info=True;User ID= 'vipl-user';Password='vipl-user!@#$%';Provider=SQLOLEDB.1;Initial Catalog=TTT].[ClientAc] from [ClientAc]
while executing I got error

would u please correct the code and post it in this

Thanks for your information bro will try and contact u soon

But how to integrate those tools in c# code and getting output in a single click

It is not working bro retrieving tables is ok but how to generate script for those tables would u pls suggest me the solution

How can you access it from a specific folder containing many .mdb files

Can you please elaborate it

Same I did here but it has been taken more time to create invoice in the server for multiple users
at a single time clicking the save button

what is the techniques to isolate the database at the front end?

would you please elaborate it?

I agree with you brother but here i have taken two different tables for Inserting and getting new invoice no. Here I need to change the transaction behaviour as you said or creating temp table or cache. How to create cache between sql and c#?

we don't have that much of resources to hire DBA Please tell me how to optimise database traffic

Dude this is not the joke can you please tell me how to optimise sql server database

I want to ask one more question to you how to add database to y points

Yeah it's working.Thank You For your Information.

I have already added using DevExpress.XtraCharts namespace.Still I am getting same error.

K Let me try on my side. Any way Thank you for your valuable information.

Can u please suggest me another way of getting this because i didn't get u

I want to retreive Qty,Product_No,AC_NO and Amount According to the sales in months in the year. In Reports I want to Display All Months i.e January to December and also print Qty and Amount based on Product_no according to sales in Prooper Months.

Here I have taken invoice,cashbill and salesreturn tables in which i want to select

inv_no from all tables.

Here Every table has its own values for inv_no.

But i want to select single inv_no value for common product in all tables group by

customer.

Same Thing I have done but it is not getting.Is there any another way to do this

EF6 and VS2012

At first I have added Entity Data Model to the solution. Later I added Entity Data Source Control to the form from the toolbox then i selected EntityDataSource Control Properties there it is showing only ObjectContextType Property not DbContext Type Property there I am getting only none instead of DataContext in Entity Model.

I tried but no use

Yes I have added but it is not showing on that property.

Sorry to disturb you. I added Entity Data Source control to toolbox in my project. I have taken that into form but it is showing only none not showing any datasource in property ObjectContextType in EntityDataSource Control Properties.Can u Please solve this

K Its Working Thank you for your information.But They have created classes for entity datasource and navigator.I want to take from toolbox by default.How to enable that in toolbox.

Thank you for your information I already tried this but i want to do crud operations using EntityDataSource Control.

What i mean to say u is i want to appear scroll bar to drag a row down or vertically to change that row height.

For all rows

Would u please explain breifly what should I do

Here Have u taken empty xml file or adding any columns

Would u please tell me how to use local users database

Here we should not use database for saving the column width it automatically saves and after re debugging also it shows same width

when we close a form the datagridview columns width will be saved.

Whenever we debug again and again it will show that column width as Saved column width

in the datagridview.

For that where should I write these code.

I did n't understand what u wrote here.Can u please explain briefly

No I set datatype as image and it stored like this hexagonal
0x53797374656D2E44726177696E672E4269746D6170

In database it stored like this 0x53797374656D2E44726177696E672E4269746D6170

Can u pls solve the error

in Db

I have taken field datatype as image

Thanks for your Information but still i am getting same error 'parameter is not valid'
at pictureBox1.Image= Image.FromStream(stmBLOBData);

Thanks for your information but it is also getting same error'Parameter is not valid'

I created but i didn't get it.

I have added User control2 in User control1 so I want to close user control 2 and display user control1 when the exit button is pressed in the usercontrol2 both i have taken in the same form by using panel1.

Panel6.visible=false;

K I got it I used Convert.Todouble() method Thanks For ur valuable suggestions

K I got it I used Convert.Todouble() method Thanks For ur valuable suggestions

Thanks What is the solution I am asking. can u pls solve it

yes I want accurate value

I tried but I have taken Exchangerate datatype as float.

When I pass value in the front end 1.25555555

then it takes same value at the backend 1.26

I got the result in front end but it did n't convert at the backend. In Backend I have taken Exchange rate as float

What is 2 in the Math.Round() method

I have Improved My Question did u see that

I tried but i didn't get that accurate result

I want to write this in windows not console

Its getting error like this "Object reference not set to an instance of an object." at obj.Controls["Txt_EmpCode"].Text = dataGridView1.Rows[row].Cells[1].Value.ToString();

Its not working bro

welcome

Its not a c# code it means "thank you"

Just see on this below link
http://www.onlinebuff.com/article_step-by-step-3-tier-architecture-in-aspnet-using-c-example_45.html

I have taken two user controls named as work and empsearch.

When user wants to click Collapsed button in work form then it will display empsearch form with datagridview data.

In Empsearch form I have taken select button.After selecting a row in datagridview then click on select button.Then it displays work form with all the selecting row columns in the textboxes.

For that I have written above code.Kindly see this code.

I tried that also.But it is showing empty code in the notepad.What should I do to resolve this error.

I Have tried all these methods.But It is always showing same error.