Comments by Ram7 from Hyderabad (Top 43 by date)

This is the Question which i have updated now:-
"How to get an rows cell value from JQGrid to Controller Action method"
Thanks
Ramu

Hi,i have posted as new thread,please help me.......

Dear Jameel,
Thanks for ur responce,the code u provided is working fine for my 1st requirement i.e displaying Edit Links to each row, but iam facing problem with getting an Id to the Controller Action.This is how i modified my JQGrid with ur code
$("#emp-data-grid").jqGrid({
datatype: "local",
data: mdata,
colNames: ["EmployeeID", "EmpName", "Designation", "Salary", "MobileNo", "Email", ""],
colModel: [
{ name: "EmployeeID", index: "EmployeeID", sortable: false,
editable: true, edittype: 'checkbox', editoptions: { value: 'true:false' }
},
{ name: "EmpName", index: "EmpName" },
{ name: "Designation", index: "Designation" },
{ name: "Salary", index: "Salary", sorttype: "int" },
{ name: "MobileNo", index: "MobileNo", sorttype: "int" },
{ name: "Email", index: "Email" },
{name: 'Link', formatter: function (cellvalue, options, rowObject) {
var x = '@Html.ActionLink("EDIT", "Edit", "Home", new { id = "EmployeeID" }, new { @style = "color:Blue;font-weight:bold;" })';
return x.replace("EmployeeID", rowObject[1]);
}, align: 'left', width: 100
}
shrinkToFit: true,
viewrecords: true,
sortorder: 'asc',
caption: "Employee List"
});
this is my Controller Action code:-
public ActionResult Edit(int id)
{
ViewData["RowData"] = int id;
return view();
}
In the above controller i want to access id and send to view for displaying that id in some textbox,using viewdata.
Please guide me where iam doing mistake,...
Thanks
Ramu

Can you please explain in detail how to fix the formatting,as iam new to MVC

Hi,Following is my Controller Code
public ActionResult GetData(TableData model)
{
using (personalEntities db = new personalEntities())
{
var emply = from p in db.empdetails
select new
{
EmpID = p.empid,
EmpName = p.ename,
Designation = p.designation,
Salary = p.salary,
DeptNo = p.deptno,
};
}
return View(emply.ToList());
}
In the Last line of my Controller Code i.e return View(emply.ToList()),please observer this line wheather iam doing write or not..
Thanks
Ramu

Dear Moideen,
The code u provided is working fine for redirecting from one controller,but here i have one more requirement i.e is there any possibility for redirecting from one view to another view with some data...

Dear Moideen,Thanks for ur intrest towards my post,here is my controller code
public ActionResult Login(UsersLogin model)
{
if (model.UserName == "employee1" && model.Password == "ramu")
{
//return View("~/Views/Account/Register");
return View("employee1");
}
else if (model.UserName == "employee2" && model.Password == "ramu2")
{
return View("employee2");
}
else if (model.UserName == "manager" && model.Password == "manager")
{
return View("manager");
}
else if (model.UserName == "admin" && model.Password == "admin")
{
return View("admin");
}

else
{
ViewData["Error"] = "Invalid UserId or Password";
return View();
}

}
I Have created 5 views
1)Normal Login View:-

Member Login

type="text/javascript"></script>
@Html.ValidationSummary(true, "Login was unsuccessful. Please correct the errors and try again.")
@using (Html.BeginForm()) {
<div>
<fieldset>
@* Account Information
*@
<div class="editor-label">
@Html.LabelFor(m => m.UserName)
</div>
<div class="editor-field">
@Html.TextBoxFor(m => m.UserName)
@Html.ValidationMessageFor(m => m.UserName)
</div>

<div class="editor-label">
@Html.LabelFor(m => m.Password)
</div>
<div class="editor-field">
@Html.PasswordFor(m => m.Password)
@Html.ValidationMessageFor(m => m.Password)
</div>

@*<div class="editor-label">
@Html.CheckBoxFor(m => m.RememberMe)
@Html.Label(ViewData["Error"])
</div>*@
<div>
@ViewData["Error"]
</div>
<p>
<input type="submit" value="Log On" />
</p>
</fieldset>
</div>
}
2)employee1 View:-
<table>
<tr>
<th></th>
<th>Empid</th>
<th>Ename</th>
<th>Task</th>
</tr>
<tr>
<td>@Html.ActionLink("Edit","Edit")
</td>
<td>101</td>
<td>Ramu</td>
<td>Fixing Bugs</td>
</tr>
</table>
3)Similarly employee2 view:-

You are Logged in as employee2

<table>
<tr>
<th></th>
<th>Empid</th>
<th>Ename</th>
<th>Task</th>
</tr>
<tr>
<td>@Html.ActionLink("Edit","Edit")</td>
<td>102</td>
<td>Vijay</td>
<td>Testing Code</td>
</tr>
</table>
4)Manager view:-

You are Logged in as Manager

<table>
<tr>
<th></th>
<th>Empid</th>
<th>Ename</th>
<th>Task</th>
</tr>
<tr>
<td>@Html.ActionLink("Edit","Edit")
<td>101</td>
<td>Ramu</td>
<td>Fixing Bugs</td>
</tr>
<tr>
<td>102</td>
<td>Vijay</td>
<td>Testing Code</td>
</tr>
</table>
5)Admin view:-
<table>
<tr>
<th.</th>
<th>Employees</th>
<th>ManagerName</th>
<th>ManagerTask</th>
</tr>
<tr>
<td>@Html.ActionLink("Edit","Edit")
<td>Ramu</td>
<td>RamaKrishna</td>
<td>Code Review</td>
</tr>
<tr>
<td>Vijay</td>
<td>Naresh</td>
<td>Code Review</td>
</tr>
</table>
Hear i need to create one

Dear Prabakar,
Thanks for ur responce the links u provided to me helped me a lot and cleared all confusions about how to implement the validations in MVC......

Dear Vijay,thanks for ur responce my requirement is with checkbox only,i will try with ur code,thanks once again for ur responce......

Dear Bernhard,myn actual requirement is i need to copy a table data from my local mysql db to a table present in different server mysql db,for example if i have a two tables say mainlog and sparelog, mainlog table is present in local mysql db& sparelog table is present in different server mysql db, now if i perfor any dml operation it should auto reflect to sparelog table by writing some triggers or stored procedures

Hii,it is two different database's,

Hii,ya i have tried from MSSQL to MYSQL by creating linked server to mysql,even i have another requirement that is it possible to connect from MYSQL to MSSQL,if yes please guide how should i go with this..........

Thank u i will go with the above link

Hii thanks for ur responce,will u guide me how to work with ssis,provide some documentation links.
Thanks
Ramu

Dear gvprabhu, thanks a lot its working....................

Dear kumar,sorry for disturbing u again, iam finding again errors with update please help me,this is the trigger iam writing for update
create TRIGGER updateLogRecords
ON mainlog FOR update
AS
BEGIN
update users2.dbo.sparelog set users2.dbo.sparelog.empid in(inserted.empid WHERE users2.dbo.sparelog.empid =Inserted.empid)
END
thanks
Ramu

ya sure definitely

Ya kumar,its working thanks for all,

Both tables mainlog&sparelog have similar structure with same datatypes,like this with 5columns
empid Firstname Lastname Location Age
and update trigger like what u have given:-
CREATE TRIGGER UpdateLogRecords
ON mainlog FOR UPDATE
AS
BEGIN
UPDATE users2.dbo.sparelog SET users2.dbo.sparelog.Age=Inserted.Age WHERE users2.dbo.sparelog.empid=Inserted.empid
END
Delete trigger like this:-
CREATE TRIGGER DeleteLogRecords
ON mainlog FOR DELETE
AS
BEGIN
DELETE FROM users2.dbo.sparelog WHERE users2.dbo.sparelog.empid=deleted.empid
END
Iam new to this DB coding,i think iam wrong with giving correct values with where condition..
thanks
Ramu

I have tried with ur above trigger,but iam finding errors like
Error:-"The multi-part identifier "deleted.Age" could not be bound"
I wrote the trigger like this....
"DELETE FROM users2.dbo.sparelog WHERE users2.dbo.sparelog.empid=deleted.empid"
I think iam wrong with where condition itself,i have the table structure with 5 columns like this:empid,Firstname,Lastname,Location,Age
can u please tell me where iam doing the mistake

Dear Babu,thanks for ur quick responce, i tried with ur above update,delete triggers,they were executed successfully, but here when delete trigger is executed the selected record is being deleted from mainlog table(source table) and in sparelog table it is inserting as a new record(duplicate record)Here my requirement is, the selected record from mainlog for delete it also should delete from sparelog table,rather inserting as a new duplicate record,the same thing is happing with update trigger also,the source table should be an exact replica of target table,please tell me how to rectify the above triggers to meet my exact requirement

Thanks khorshed,thanks for all ur valuable suggestions........

Thanks Khorshed,i will try with the above link, or else i will go with procedure,
can u please tell me,how many possible ways of migrating data from one server database to another,so that i can try with those alternatives

Dear Khorshed,i have started Distributed Transaction Co-ordinator with help of ur above link,and again,iam getting the new error like below,please check the below error and guide me how to overcome this,thanks in advance..
Error:-"OLE DB provider "MSDASQL" for linked server "MYSQL" returned message "[MySQL][ODBC 5.1 Driver]Optional feature not supported".The operation could not be performed because OLE DB provider "MSDASQL" for linked server "MYSQL" was unable to begin a distributed transaction".

Dear Khorshed,thanks for ur responce, i have tried with ur above rectified trigger but iam getting an error like this:-
Procedure LogRecords, Line 9
MSDTC on server 'RAMU-IBX' is unavailable.
where 'RAMU-IBX'is my DSN name.Can u please guide me where iam doing mistake

Dear Reynolds thanx for ur responce, i have already created a linked server,and iam able to retrieve data,insert,update,delete with the help of distributed querys.And hear iam unable to copy a table data from sqlserver to mysql using a single trigger,can u please help me in thid..

Thanks a lot khorshed, i will go with
this.......

hii Khorshed thanks for ur responce,i have tried with linked server,but i didn't reached my requirement.Iam getting error with connection.can u also please guide me how to work on linked server or to provide any link to go with this.Iam trying to create linked server to mysql db from sqlserver db.............

hii gholam, almost a day i worked with ur link,iam getting the following error while configuring ODBC datasource please help me.
ERROR is:-connection failed:[HY000][MYSQL][ODBC 5.2(a)driver]can't connect to mysql server on "10.10.1.173"(10061)

ya, i got the connection string and i placed it in my web.config file

ok ok,fine i wil try with ur above steps..............

Hii Griff thanks for ur reponse,actually my requirement is with only database's not with front end,my question is how should i connect from one database to another database,and how should i transfer data,can perform operation b/w two different database's(SQL,& MYSQL).i.e Linked server concept.please help me in this way....thanks in advance

Hi gholam,thanks for ur response,iam working on ur link............

Thank u vishwa, its working, thanks a lot

Hi Master, thanks for ur responce,from google i came to know that max limit is 1024,but iam searching for the reason why it is only 1024,can u help in this way

Hii master, thanks for ur responce,nw iam going to try.................

Thanku very much its working............................

Hii,thanks for ur responce, i want code in asp.net technology