Hi, This is from Chandrakanth. Actually i am working on SqlReports. I have one Problem that is... Is there any way to give permissions in Reports it self. That means i have One Report Like Report1 Containing Fileds LIKE col1,Col2,Col3 And Col4. that report should be allocated to User And Admin. And i want to show columns for Admin Col1,Col2, Col3, And Col4. And I want to show Columns for User Col1 And Col2. Is there any way to get Reports Like that. Can any one Give reply for this.. Thanks in Advance With Regards ChandraKanth.Gaddam

Chandrakanth

Hi, This is from chandrakanth. I have created SSIS package. And I want to Call from Asp.net 2.0 Can any one tell me how to call that. Thanks In Advance chandrakanth

Chandrakanth

Hi Mr Christian Graus I have Taken Menu Control in (2.0) And My Name of the Page is Menu.aspx that coding is <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server" > <asp:Menu ID="Menu1" runat="server" Font-Names="Verdana" Font-Size="0.8em" ForeColor="White" Height="14px" Orientation="Horizontal" StaticEnableDefaultPopOutImage="False" StaticSubMenuIndent="10px" Style="clear: right; display: inline; font-weight: bold; list-style-position: outside; font-size: 15pt; float: none; text-transform: capitalize; color: purple; list-style-type: circle; text-align: justify; text-decoration: underline" Width="100%" > <%--DataSourceID="SiteMapDataSource1" --%><StaticMenuStyle BackColor="#01145a" /> <StaticMenuItemStyle Font-Size="Small" HorizontalPadding="5px" VerticalPadding="2px" Font-Bold="true" /> <DynamicHoverStyle BackColor="#cccdd5" ForeColor="#01145a" Font-Underline="true" Font-Bold="true" /> <DynamicMenuStyle BackColor="#cccdd5" BorderColor="#ff0000" Font-Bold="true" /> <StaticSelectedStyle BackColor="Fuchsia" BorderColor="Blue" ForeColor="White" Font-Bold="true" /> <DynamicSelectedStyle BackColor="Lime" BorderColor="White" Font-Bold="true" /> <DynamicMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" Font-Bold="true" /> <StaticHoverStyle BackColor="#01145a" ForeColor="White" /> </asp:Menu> <asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" ShowStartingNode="false" /> <table width="100%" > <tr> <td align="center" > <asp:DropDownList ID="ddlMenu" runat="server" Width="200px" Height="22px"> <asp:ListItem Value ="Select">--------------------Select-------------------</asp:ListItem> <asp:ListItem Value ="Sub1">Sub1</asp:ListItem> <asp:ListItem Value ="Sub1">Sub2</asp:ListItem> <asp:ListItem Value ="Sub1">Sub3</asp:ListItem> <asp:ListItem Value ="Sub1">Sub4</asp:ListItem> <asp:ListItem Value ="Sub1">Sub5</asp:ListItem> <asp:ListItem Value ="Sub1">Sub6</asp:ListItem> </asp:DropDownList> </td> </tr> <tr> <td align="center"> <asp:TextBox ID="txtMenu" runat="server" Width="180px" Height="20px"></a

Hi. This is from Chandrakanth. Actually in my page i was added Menu. I have Binded Data through SiteMap Provider. My Menu are ADMIn ,USERS,sALES,rEPORTS. uNDER aDMIN -loGIN,RESET PASSWORD UNDER USERS -USERADD, USERMODIFY UNDER SALES - SALESREPORTADD UNDER REPORTS - REPORT1 NOW I HAVE ONE Drop Down List , TextBox And One Button. Drop Down Items are populated from Database. Drop Down Items are like -- New Menu, AddUsers,Master Records Now i want to Select Items from DropDown(Ex... AddUsers) After that i have enter Name of Menu(LIke Admin, Users,Sales,Report) this choice depending upon User. suppose i enter in the Text box like "Admin" Here after user click Add Button ... What ever i select from DropDown(AddUsers) that shold be added in the Main Menu Based on entering the Name of the Menu Name in the TextBox. Ex in the Dropdown i Have seleced --- addUsers in the Text box i have enterred --- Admin by clicking button Under Admin AddUsers Shold be add. Can any one Give me some suggestion ont this. Thnks andRegards Chandraknth

Chandrakanth

Hi, This is from chandrakanth. Actually i want to creta Dynamic Menu in C# Based on Roles. That meams if the Role is Admin then we have to provide some Screens if Role is User means we have to Provider some screens. How can i go for that. Can any OnError suggest me how to go for that. ThanksAnd Regarda Chandrakant

Chandrakanth

Hi, This is from CHandrakanth. I have one gridview in that EDIT button is there. When i click on Edit Button the columnValue(ApplicationName - value) should be displayed in the DropdownList and that should be selected. the code and all i giving here protected void gdvRoleDetails_RowCommand(object sender, GridViewCommandEventArgs e) { ddlApplications1.SelectedIndex = 0; GridViewRow row = (GridViewRow)gdvRoleDetails.Rows[Convert.ToInt32(e.CommandArgument)]; if (e.CommandName == "Edit") { ListItem item = new ListItem(); item.Text = row.Cells[2].Text; ddlApplications1.Items.Clear(); hdnRoleId.Value = row.Cells[0].Text; txtRoleName.Text = row.Cells[1].Text; hdnAppl.Value = row.Cells[3].Text; ddlApplications1.SelectedIndex = ddlApplications1.Items.IndexOf(ddlApplications1.Items.FindByText(row.Cells[2].Text )); } } can any one suggest me what to follow for that

Chandrakanth

Hi, This is from chandrakanth. Actullay i am able to upload the picture into Sqlserver2005. But i can not able to get the picture. And i want to show the picture in Gridview. can any one tell me what are all things have to change in my code. here the code is protected void btnRetrive_Click(object sender, EventArgs e) { IDataReader objReader; SqlDataAdapter da = new SqlDataAdapter(); DataTable dt = new DataTable(); objReader= KF.Search.GetUserIdImages(txtuid.Text); dt.Load(objReader); gdvImagesRetrive.DataSource = dt; gdvImagesRetrive.DataBind(); } GetUserIdImages ------ that metyhod code is.... public static IDataReader GetUserIdImages(string strImageUserId) { try { byte[] imagestr; Database objDataBase = DatabaseFactory.CreateDatabase(); DbCommand objDbCommand = objDataBase.GetStoredProcCommand("STP_KF_Images_Retrive"); objDataBase.AddInParameter(objDbCommand, "@UserId", DbType.String, strImageUserId); IDataReader objDataReader; objDataReader = objDataBase.ExecuteReader(objDbCommand); while (objDataReader.Read()) { imagestr = (byte[])objDataReader.GetValue(1); } return objDataReader; objDataReader.Close(); } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } } can any one tell me what are all things sholud change. Thanks and Regards Chandrakanth

Chandrakanth

Hi, This is from chandrakanth. Actullay i am able to upload the picture into Sqlserver2005. But i can not able to get the picture. can any one tell me what are all things have to change in my code. here the code is protected void btnRetrive_Click(object sender, EventArgs e) { IDataReader objReader; SqlDataAdapter da = new SqlDataAdapter(); DataTable dt = new DataTable(); objReader= KF.Search.GetUserIdImages(txtuid.Text); dt.Load(objReader); gdvImagesRetrive.DataSource = dt; gdvImagesRetrive.DataBind(); } GetUserIdImages ------ that metyhod code is.... public static IDataReader GetUserIdImages(string strImageUserId) { try { byte[] imagestr; Database objDataBase = DatabaseFactory.CreateDatabase(); DbCommand objDbCommand = objDataBase.GetStoredProcCommand("STP_KF_Images_Retrive"); objDataBase.AddInParameter(objDbCommand, "@UserId", DbType.String, strImageUserId); IDataReader objDataReader; objDataReader = objDataBase.ExecuteReader(objDbCommand); while (objDataReader.Read()) { imagestr = (byte[])objDataReader.GetValue(1); } return objDataReader; objDataReader.Close(); } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } } can any one tell me what are all things sholud change. Thanks and Regards Chandrakanth

Chandrakanth

Hi, Once again this is from Chandrakanth. Can you please tell me what are all things have to follow in Code Thanks and Regards Chandrakanth

Chandrakanth

Hi, This is from Chandrakanth. Now i am uploading Image in to Sqlserver2005. I have written coding like this using Enterprise Library protected void btnUpload_Click(object sender, EventArgs e) { if (upXLTalisma.PostedFile != null) { if (upXLTalisma.PostedFile.ContentLength > 0) { HttpPostedFile objHttpPostedFile = upXLTalisma.PostedFile; if (CheckValidFileType(objHttpPostedFile.FileName)) { int intContentlength = objHttpPostedFile.ContentLength; byte[] bytImage = new byte[intContentlength]; objHttpPostedFile.InputStream.Read(bytImage, 0, intContentlength); KF.Search.StoreImage(Convert.ToByte(bytImage)); } } } } public static bool CheckValidFileType(string strImage) { string strImageFile; strImageFile = strImage; if (strImageFile.LastIndexOf(".") == -1) return (false); int i = strImageFile.LastIndexOf("."); strImageFile = strImageFile.Substring(strImageFile.LastIndexOf(".") + 1); return (strImageFile.ToUpper() == "JPG"); } This is the code i am using in Class file public static void StoreImage(byte strImage) { try { Database objDataBase = DatabaseFactory.CreateDatabase(); DbCommand objDbCommand = objDataBase.GetStoredProcCommand("STP_KF_IMages"); objDataBase.AddInParameter(objDbCommand, "@Image", DbType.Binary, strImage); objDataBase.ExecuteNonQuery(objDbCommand); } catch (Exception Ex) { throw new Exception(Ex.Message.ToString()); } } but i am getting error in this line, KF.Search.StoreImage(Convert.ToByte(bytImage)); and Saying "Unable to cast object of type 'System.Byte[]'to 'System.IConvertible'. " Can any one suggest me what to do for that coding. Thanks And Regards Chandrakanth

Chandrakanth

Hi, This is from Chandrakanth. I would like to call a function which is in C#, From JavaScript. How can i go for that? Can any one give me repply for this. Thanks And Regards chandrakanth

Chandrakanth

Hi, This is from Chandrakanth. Now I am working on asp.net 2.0 My Problem is i have one Page called "Search".In that search page i have Text Box called "txtUserName". And i entered some letter in that Textbox. Based on that letter list of records are displaying with Radio Buttons in gridview. And i want to select only one record from the gridview by selecting RadioButton. at present i can able to select multiple records by clicking radio buttons. i do want to select only one record, Then Rest of the radio buttons record should be unselect in gridview. Can any one help me for this. Thnaks in advance here i am giveing Gridview code also <table id="tblEmpDtls" cellspacing="2" cellpadding="2" width="100%" border="1" runat="server"> <tr> <td class="TableHead" colspan="2"> Employee Details</td> </tr> <tr> <td class="TableRow" colspan="4"> <asp:GridView ID="gdvUserSearch" runat="server" AllowPaging="True" AllowSorting="True" PageIndex="15" AutoGenerateColumns="False" Width="100%" Height="77px"> <Columns> asp:TemplateField <ItemTemplate> <asp:RadioButton ID="rdSelect" runat="server" Text="Select" GroupName="rdBox" OnCheckedChanged="rbdefault_CheckedChanged" /> </ItemTemplate> </asp:TemplateField> <asp:BoundField HeaderText="User Id" DataField="UserId" /> <asp:BoundField HeaderText="User Name" DataField="UserName" /> <asp:BoundField HeaderText="Email Id" DataField="Email" /> <asp:BoundField HeaderText="Mobile No" DataField="Mobile_No" /> </Columns> </asp:GridView> </td> </tr> </table> Thanks and Regards Chandrakanth

Chandrakanth

Hi, This is from Chandrakanth. I am doing Encrypt and Decrypt ther Password. Regarding Encryption I am saving Password in different format. I want to decrypt the Password from DataBase. How can i go for that. Is there any source code means please send me that. Thanks And Regards Chandrakanth

Chandrakanth

Hi, This is from Chandrakanth. Actually i have done Mailing System.It is working fine. And i want attach a file with Mail. How can i attach a file with Mail. Can any one tell me how to attach a file Thanks And Regards Chandrakanth.

Chandrakanth

Hi, This is from Chandrakanth. Actually i want to Use LIST OBJECT Control which was located in EXCEL CONTROLS. Can any one tell me what are all the DLL i have to Add to use Excel Controls in my Project. Thanks And Regards Chandrakanth.G

Chandrakanth

Hi, This is from Chandrakanth. Actullay i have been working on Dotnet Framework2.0. my Question is some of the Controls are DISABLED MODE in TOOL BOX. How can i ENABLE that controls. That means suppose i want to Use EXCEL Controls along with Standard Controls. How can i use that EXCELControls in TOOL BOX. That EXCEL controls are DISABLED MODE. How can i ENABLE that Controls. Thanks in Advance With Regards Chandrakanth.G

Chandrakanth

This is from Chandrakanth. I need some Guidance regarding Dynamic Generic XL Upload With Validation. Can any one give me some suggestion for this Dynamic Generic XL Upload in C#. That means in MY Excel sheet in non -specific fields that means... In my excel sheet fields are not fixed it may be 5 columns,it may be 10 columns. I have to do this excel uploading with validation ,, while I am doing this excel upload I have to map with stored procedure.. and column data types... Developer does not involve on every uploading coding part...that means we have to facilitate to end user Excel uploading any file regardless of fields and data types has to upload with validation... We have to make general Excel Uploading ,,,,,, with validation using SSIS feature in SQL SERVER 2005 If u have any Idea(any other logic) to do generic excel uploading,,please share with me ... Thanks in Advance Chandrakanth.Gaddam

Chandrakanth

Hi, This is from Chandrakanth. I am using dotnet3.5. In that i am using Master Page. When i am going for Desing Mode i am getting erro like "Master Page File '~/GlobalMaster.master' Page can not be loaded" My Master Page Name is GlobalMaster.master. When i run the application the page is not saying any error it is runbning fine. I can not able to view the desing in my Page. My page name is "Login Page" Can any one give me some suggestion how to rectify this problem Thanks And Regards Chandrakanth.

Chandrakanth

Hi, This is from Chandrakanth. I am using Sitemap Conrtrol in my Project. My Problem is.... Actually in my form i have One DropDownList.In that i am binding RoleNames Like "AccountOperation","HealthCPU" . And I have one DataGrid Control. In that i am populating Screen Names.Screen Names like "MasterSCREEN","Report Screen" "Upload SCREEN" . Here User Have To Select RoleName From DropDown and then , User Have to Select SCREEN NAME From DataGrid Control.Here after by Clicking "SUBMIT" button SITEMAP control should Generate Menu what ever selected by USer. For Example ROLENAME is "ACCOUNT OPERATION" AND SCREEN NAME is "MASTER SCREEN","REPORT SCREEN". Then SITEMAP control should generate MENU like MASTERSCREEN AND REPORTSCREEN. How can i go for that. Can any one give me reply for this. Thanks in Advance.. With regards Chandrakanth

Chandrakanth

Hi, This is from Chandrakanth. I am using GridVeiw Control and in that I have one DropDownList. My problem is i would like to Bind the Data to that DropDownListbox in that GridView Control. How can i bind the data to that DropDownList Box In that GridView Control. Can any one give me reply for this. Thanks in Advance With Regards Chandrakanth

Chandrakanth